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

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:

  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. Consult the Shapiro Library APA Style Guide for more information on citations.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Positive Leadership can help an organization overcome obstacles such as

  Positive Leadership can help an organization overcome obstacles such as a hostile work environment.  Positive Leadership can also foster an effective organizational culture enhanced by diversity and gender differences.    Please refer to Chapters 1-5 in The Power of Positive Leadership. Positive Leadership Concept Questions: Answer the following questions: 

Discuss the roles and relationships between mission, vision, values, and

Discuss the roles and relationships between mission, vision, values, and strategic goals.  Provide one example of directional strategies used in one healthcare organization (your own employer or from  the internet) and comment on the interrelatedness of the four areas. Expectations Initial Post: Due: Thursday, 11:59 pm PT Length: A minimum

It has been stated that the actual number of people

  It has been stated that the actual number of people in the United States who have genital herpes may be a lot higher than official statistics depict. Describe what genital herpes as if you were addressing a potential patient. Explain how genital herpes affects the human body. Discuss some

The nurse-client relationship and the use of therapeutic communication as

  The nurse-client relationship and the use of therapeutic communication as an important part of that relationship. Please answer the following questions: What are your concerns or fears about mental health nursing in general? Are you interested in mental health nursing, or do you approach the topic with some anxiety?

Define the word “candor” in both a personal and a

Define the word “candor” in both a personal and a universal way. Argue a point while considering the possible multiple points that conflict it. Extend the definition into the future while basing it on am understanding of the past. Include five (5) appropriate sources (In-text citations and reference page citations

Several companies are known for linking their mission, values, and HR practices in ways that have ledto business success as well as employee satisfaction.

Several companies are known for linking their mission, values, and HR practices in ways that have ledto business success as well as employee satisfaction. These companies include Southwest Airlines(www.iflyswa.com), Cisco Systems (www.cisco.com), SAS Institute (www.sas.com), Verizon(www.verizon.com), Container Store (www.containerstore.com), Google (www.google.com), Steelcase(www.steelcase.com), Whole Foods (www.wholefoods.com), and TELUS (www.telus.com). Choose oneof

Share your thinking about the Literature Circles activity from the

 Share your thinking about the Literature Circles activity from the previous topic. Think of a book you have read (preferably one that would be appropriate for the grade level you will be teaching—like Charlotte’s Web for elementary, Bridge to Terabithia for upper middle, or another book with which many people

MHA FPX 5020 CU United Health Group Optum Capstone Nursing Assignment Help

Construct a draft proposal for your project, and integrate it with the organizational balanced scorecard model. There is no page limit for this assessment.Introduction Note: Each assessment of your capstone project is built on the work you have completed in previous assessments. Therefore, you must complete the assessments in this

Write a 5-6 page mini-paper, on a trending topic in

   Write a 5-6 page mini-paper, on a trending topic in Economics. You may use non-peer reviewed sources to start your quest, but support your writing with Economic theory(ies) and academic resources Synthesize and connect to the “New Growth Theory” economic theory as a major theme. Integrate the impact of

Application of Restorative Justics Educa

Application of Restorative Justics Educa Description word essay describing possible applications of RJE in your personal and/or professional context. This could be one idea or several ideas. Be specific and focused. Support your ideas with a rationale that is grounded in your readings. This piece of work is your background

Consider the following hypothetical: Ed contracted with Becky to build

Consider the following hypothetical: Ed contracted with Becky to build a house. Immediately prior to that meeting, Becky was so nervous that she drank an entire bottle of champagne and she does not remember all of the details of the meeting. Shortly before the closing, Ed met with Becky, accused

The Software Development Life Cycle (SDLC) is a process used

The Software Development Life Cycle (SDLC) is a process used for designing, creating, deploying, and testing software. What are the steps/phases of the SDLC? Provide a graphic that shows how they interrelate. (Cite your source.) For each step/phase of the SDLC, explain what specific positions and roles are likely to

SWK205- SOCIAL WORK WITH THE ELDERLY Lesson 9 Discussion 1

SWK205- SOCIAL WORK WITH THE ELDERLY  Lesson 9 Discussion 1 (200 words) Alison is a 65-year-old female who is meeting with the Social Worker at her assisted living home. The staff at the assisted living home have noticed that Alison’s appetite has decreased, she has been sleeping more and has