o measure the financial performance of any company, it is important to analyze its four key financial statements: balance sheets, income statements, cash

o 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:

  1. 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
  2. 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.
  3. 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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Discussion Thread: Place For this module’s discussion, you will select peer-review journal articles on one of the 4Ps – Place. Keyword search terms might

Discussion Thread: Place For this module’s discussion, you will select peer-review journal articles on one of the 4Ps – Place. Keyword search terms might include one of the following:  marketing channel strategy, distribution, retailers, internet, or supply chain. Once you have selected your peer-reviewed journal articles, post a synopsis of the

MARKETING PAPER: MYOPIA ASSIGNMENT INSTRUCTIONSYou will write 1000 words minimum on the classic Theodore Levitt 1960 paper calledMarketing Myopia.

MARKETING PAPER: MYOPIA ASSIGNMENT INSTRUCTIONSYou will write 1000 words minimum on the classic Theodore Levitt 1960 paper calledMarketing Myopia. ‘Marketing myopia’ is a term coined by Theodore Levitt. A business suffersfrom marketing myopia when a company views marketing strictly from the standpoint of sellinga specific product rather than from the

Module 4 – CaseEconomic Justice and Organizational StrategyAssignment Overview Economic Justice Economic Justice is a global issue. The struggle for

Module 4 – CaseEconomic Justice and Organizational StrategyAssignment Overview Economic Justice Economic Justice is a global issue. The struggle for Economic Justice in modern America is not a new movement. Paradigm-shifting events in 2020 pushed companies and organizations to address inequities and assess their track records while devising a different

Module 2 – CaseFostering CollaborationAssignment OverviewA Manager’s Role in Collaboration Leadership styles play a role in shaping team dynamics.

Module 2 – CaseFostering CollaborationAssignment OverviewA Manager’s Role in Collaboration Leadership styles play a role in shaping team dynamics. Cross-functional teams, whether virtual or in-person, require a leader adept at understanding varied departmental perspectives, bridging knowledge gaps, and facilitating effective collaboration across specialties.  **Complete SLP 2 before Case 2** Case

Module 2 – SLPFostering CollaborationAssignment OverviewCross-Functional Teams Collaborative cross-functional teams thrive under leadership styles that

Module 2 – SLPFostering CollaborationAssignment OverviewCross-Functional Teams Collaborative cross-functional teams thrive under leadership styles that prioritize open communication, mutual respect, and shared decision-making. **Complete SLP 2 before Case 2** Session Long Project 2 Resources Servant Leadership (2023)Understanding The Role Of Team Dynamics To Make A Healthy Work Environment (2023)Leadership and teamwork dynamics:

Module 2 – CaseFostering CollaborationAssignment OverviewA Manager’s Role in Collaboration Leadership styles play a role in shaping team dynamics.

Module 2 – CaseFostering CollaborationAssignment OverviewA Manager’s Role in Collaboration Leadership styles play a role in shaping team dynamics. Cross-functional teams, whether virtual or in-person, require a leader adept at understanding varied departmental perspectives, bridging knowledge gaps, and facilitating effective collaboration across specialties.  **Complete SLP 2 before Case 2** Case

Reply of at least 250 words by 11:59 p.m. (ET). Each reply must demonstrate asubstantive discussion.  Chopra Text: Chapter 1 Discussion Question Chapter

Reply of at least 250 words by 11:59 p.m. (ET). Each reply must demonstrate asubstantive discussion.  Chopra Text: Chapter 1 Discussion Question Chapter 1 Discussion: Understanding the Supply Chain According to Chopra (2019), a supply chain is a network of parties which include manufacturers, suppliers, transporters, warehouses, retailers, and customers,

DISRUPTIVE MARKETING PLAN: BRAND PROPOSAL PAPER ASSIGNMENT INSTRUCTIONSProduct/Service Topic IdentificationEach student must choose an existing consumer

DISRUPTIVE MARKETING PLAN: BRAND PROPOSAL PAPER ASSIGNMENT INSTRUCTIONSProduct/Service Topic IdentificationEach student must choose an existing consumer product/service to analyze for the Disruptive Marketing Plan.You will submit a proposal in 750–1000 words in regards to your idea using the provided template. Threereferences, including one Journal of Marketing reference, are required.Important: Written