Our Services

Get 15% Discount on your First Order

Overview To measure the financial performance of any company, it is important to analyze its four key financial statements: balance sheets, income statements, cash flow statements, and shareholders’ e

December 28, 2023

Overview

To measure the financial performance of any company, it is important to analyze its four key financial statements: balance sheets, income statements, cash flow statements, and shareholders’ equity statements. In this assignment, you will:

Visually present the balance sheet to depict what each company owns and what it owes over the past three years.
Visually present the income statement to depict how much money a company made and spent over the past three years.

The visual presentation and analysis will help you understand and compare the performance of both the companies to be acquired and eventually will help you build your recommendation for the acquisition.

Prompt

Use the provided data sets of Company A and Company B to create data visualizations of their financial performance in Power BI. Then, based on the visualizations, write an executive summary interpreting the financial performance of Company A and Company B. Include screenshots from your data visualizations as needed in your summary. Follow the directions in the Power BI Executive Summary Assignment User Manual.

To complete this assignment, you will use Power BI software that is located within the virtual desktop infrastructure (VDI).

Specifically, you must address the following criteria:

Assets, Liability, and Equity: Summarize how the assets, liabilities, and owner’s equity have changed over three years for Company A and Company B. Include screenshots of your data visualization as follows:
1. Company A: In Power BI, use the provided Company A Financials and construct a set of three clustered column charts, representing:
  1. The assets of Company A as represented in the data during each of the three years
  2. The liabilities and owners’ equity over the same three years
  3. Once the column charts are created, summarize the insights about how the assets, liability, and equity have changed over three years, as presented in the visualizations using Power BI
2. Company B: In Power BI, use the provided Company B Financials and construct a set of three clustered column charts, representing:
  1. The assets of Company B as represented in the data during each of the three years
  2. The liabilities and owners’ equity over the same three years
  3. Once the column charts are created, summarize the insights about how the assets, liability, and equity have changed over three years, as presented in the visualizations using Power BI
Revenue and Earnings: Use the provided income statements to summarize the gross revenue and net earnings for Company A and Company B over three years. Include screenshots of your data visualization as follows:
1. Company A: In Power BI, use the provided Company A Financials document and construct a line chart illustrating the visual relationship of revenue, gross profit, total expenses, earnings before tax, net earnings, and taxes.
2. Company B: In Power BI, use the provided Company B Financials document and construct a line chart illustrating the visual relationship of revenue, gross profit, total expenses, earnings before tax, net earnings, and taxes.
Conclusion: Summarize your observations about the financial performance of both companies. Include any insights you may have about their performance trends or how they have performed compared to each other over the past three years.

What to Submit

Submit a 2- to 3-page Word document using double spacing, 12-point Times New Roman font, and one-inch margins. Sources should be cited according to APA style Consult the Shapiro Library APA Style Guide for more information on citations.

company, financial, flow, important, income, key, measure, Overview, performance, sheets, statements

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Please make the following corrections listed below to the attached paper. The sections needed to be updated are highlighted in yellow on the attach paper.

Please make the following corrections listed below to the attached paper. The sections needed to be updated are highlighted in yellow on the attach paper. Funding Choice Include the numerical breakdown of the total amount of funding between the options. For self-funding, you will need to provide numerical justification that

Please make the corrections to the attached paper by following the directions below. The 2 sections that need to be corrected are highlighted in yellow on

Please make the corrections to the attached paper by following the directions below. The 2 sections that need to be corrected are highlighted in yellow on the attached paper. 1. Specific Market Conditions for Walmart in 2019 Please include numerical data (ie fed funds rate, unemployment rate, WMT’s effective interest

I want to answer this Assignment in a scientific and detailed manner

SLP/BUS530 Managerial Economics Consumer Behavior, Production and Cost SLP Assignment Expectations Economic Impacts for Producers This week’s case focused

SLP/BUS530 Managerial Economics Consumer Behavior, Production and Cost SLP Assignment Expectations Economic Impacts for Producers This week’s case focused on the consumer side of economics. Producers must manage more constraints in their decision-making. Session Long Project 2 ResourcesProducer Price Index (PPI) (2022)Purchasing Power (2022)The Market System as an Efficient Mechanism for Information (2022) Business

Recall that United Savings Bank collects information in each of the following systems. Core Banking System Online Banking Lending System (Auto/Personal

Recall that United Savings Bank collects information in each of the following systems. Core Banking System Online Banking Lending System (Auto/Personal Loans) Credit Card System Mortgage Lending System Insurance Policy System Financial Investment System They are interested in understanding how they can leverage this data, in addition to data gathered

2-2 Project Draft: Social JusticeIDS 105 Module Two Project Draft Guidelines and Rubric Overview In this assignment, you will explore key concepts related

2-2 Project Draft: Social JusticeIDS 105 Module Two Project Draft Guidelines and Rubric Overview In this assignment, you will explore key concepts related to social justice, including justice, fairness, equality, and bias. You will also explore how narratives affect perceptions of social justice and core principles of social justice. This part

1-2 Journal: Using Social Justice and Understanding Bias Specifically, you must address the following: Describe your most dominant social

1-2 Journal: Using Social Justice and Understanding Bias Specifically, you must address the following: Describe your most dominant social identities. Describe implicit bias represented within your most dominant identities. How does implicit bias show up in your most dominant identities? Identify the core principles of social justice. Describe how implicit bias impacts your understanding of the core

The Commerce Clause refers to Article 1, Section 8, Clause 3 of the U.S. Constitution. It authorizes Congress “to regulate commerce with foreign nations,

The Commerce Clause refers to Article 1, Section 8, Clause 3 of the U.S. Constitution. It authorizes Congress “to regulate commerce with foreign nations, and among the several states, and with the Indian tribes.” This is the fundamental source of authority for the federal regulation of commerce. However, the federal government’s authority to regulate

BUS530 Managerial Economics Case 2 Assignment Buyer Behavior and Effects of the Economy The Course Data File contains the Product for this

BUS530 Managerial Economics Case 2 Assignment Buyer Behavior and Effects of the Economy The Course Data File contains the Product for this assignment. Research the product from an economic standpoint (include supply and demand, cost). Describe what has been happening in the product market over the last year or two.

SWOT Analysis paper of a fictitious organization you worked at – 10-14 pages. Paper outline and requirements below. Table of Contents – example Overview of

SWOT Analysis paper of a fictitious organization you worked at – 10-14 pages. Paper outline and requirements below. Table of Contents – example Overview of The Organization ……………………………………………………………………………. 3 Leadership Practices ………………………………………………………………………………… 3 Current Leadership Organizational Affect ……………………………………………………3 Strengths and Weaknesses …………………………………………………,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.. 4 Opportunities and Threats …………………………………………..,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,….. 5 Leadership Theory

I need help constructing a research framework. See attached

Module Title :: Global Business Strategy Value of Module :: Reflective Commentary on Practice Word Count :: 3500 of 1 Type of Submission :: Individual

Module Title :: Global Business Strategy Value of Module :: Reflective Commentary on Practice Word Count :: 3500 of 1 Type of Submission :: Individual Report Method of Submission :: Moodle submission link Learning Outcomes LO1. Explain the principles of strategic management and how strategists apply them to organisations LO2.

Module Title :: Accounting and Finance for Decision Making Assessment Task :: Business Report based on Case Study Word Count :: 1,750 words (‡10%) Type of

Module Title :: Accounting and Finance for Decision Making Assessment Task :: Business Report based on Case Study Word Count :: 1,750 words (‡10%) Type of Submission :: Written Report Method of Submission :: Turnitin via Moodle Typed feedback within Turnitin in Moodle. Once the assignment is marked, Feedback the

Business 5. You are the Public Information Officer for a small company and responsible for communication distribution for your organization. Answer the

Business 5. You are the Public Information Officer for a small company and responsible for communication distribution for your organization. Answer the question below. If you were to send an immediate correspondence to all employees, what method would you use? Memo, email, voice mail, video message, Twitter, what is your specific modality

Write 2 pages Apa Corporate social responsibility in supply management has sparked the interest of both companies and all parties involved, as

Write 2 pages Apa Corporate social responsibility in supply management has sparked the interest of both companies and all parties involved, as corporations are increasingly required to evaluate their influence on stakeholders and the environment. Rights of humanity, safety and health at work, along with environmentally friendly production and environmental

SLP/BUS530 Equilibrium, Supply and Demand Session Long Project 1 ResourcesDemand, Supply, and Equilibrium in Markets for Goods and Services (2022)Shifts in

SLP/BUS530 Equilibrium, Supply and Demand Session Long Project 1 ResourcesDemand, Supply, and Equilibrium in Markets for Goods and Services (2022)Shifts in Demand and Supply for Goods and Services (2022)Changes in Equilibrium Price and Quantity: The Four-Step Process (2022) How to Draw Demand Curves in Excel How to create a simple supply and demand graph in

Use the following information to ensure successful completion of the assignment: Refer to “DBA-820 Integrated Case Study” located in the Class Resources

Use the following information to ensure successful completion of the assignment: Refer to “DBA-820 Integrated Case Study” located in the Class Resources for this course. Instructors will be using a grading rubric to grade the assignments. It is recommended that learners review the rubric prior to beginning the assignment in order

Analysis Instructions: APA formatting: Papers must be 5-8 pages long,double spaced, submitted in Microsoft Word, 12 point Times Roman Numeral with 1”

Analysis Instructions: APA formatting: Papers must be 5-8 pages long,double spaced, submitted in Microsoft Word, 12 point Times Roman Numeral with 1” margins At least fivein-text citations are required. A bibliography (i.e. references, works cited) is a requirement. I recommend ½ page eachfor introduction and conclusion and 1 page per stakeholder. Case study: