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

Understanding of Corporate Social Responsibility.

Assignment -1 Aim This assignment will assess the knowledge and understanding of Corporate Social Responsibility. Direction Locate the website of any company that publishes a corporate social responsibility report (also referred to as sustainability report) .Describe two non-financial performance measures included in the report. Why do you think the company

You need to collect data regarding the best approaches and

   You need to collect data regarding the best approaches and needs for an interface product. Explain the benefits of using probability methods versus non-probability methods and the circumstances that would affect whether you chose either collection method. Which collection method do you think is most prevalent in interaction design?

Please use the following scenario to respond to this week’s

  Please use the following scenario to respond to this week’s discussion. You are the second in command at a city law enforcement agency. Your agency is currently in the promotion cycle with several candidates interested in a Lieutenant’s position that has become available. The agency only has positions at

Your post should be no longer than 2-3 paragraphs. Simply

Your post should be no longer than 2-3 paragraphs. Simply posting your opinion will not guarantee you any points for the week. You must be able to make intelligent connections between the discussion question topic and course content. Your response should reference relevant concepts, theories, and/or findings from the textbook, additional

Scene analysis ( POWER POINT PRESENTATION )

 MEDST 317 :: Advanced Video Editing :: Spring 2019 SCENE ANALYSIS ASSIGNMENT : This is not a critical-studies type of analysis. You will select a motion picture that has impressed you. Choose a specific scene from this picture, then try to analyze it. You’ll present the scene to the class,

Identity – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

After reading the short article in Documents and Resources answer

 After reading the short article in Documents and Resources answer the following questions  . You do not need to use the company that you use in this post for your MBA capstone, but you might want to. Remember all businesses even service businesses need to have a sourcing strategy. What

Product Innovation: What lessons can other product innovators learn by

In this paper, you should use the experiences of the iPhone as illustrations of your general points, but your focus should be on product innovation in general rather than on the iPhone alone. What about the iPhone experience has been typical of major new product innovations? What about this experience

Current Topic Discussion Guidelines Students must make a minimum of

  Current Topic Discussion Guidelines Students must make a minimum of three substantive contributions on three separate days of the learning week to the management discussion topic using authoritative sources including those found in the KU library. Post your response to the discussion question early in the learning week (no later than Wednesday), and then

1. Demonstrate critical thinking and analysis Recognize relationships among different

1.   Demonstrate critical thinking and analysis Recognize relationships among different disciplinary approaches to the study of human cultures and the natural world Integrate learning from different disciplines to illuminate intersecting topics of investigation Week #7 Individual Assignment Refer to the readings and videos from this week and previous weeks

Overall, your book report should focus on the central argument(s)

  Overall, your book report should focus on the central argument(s) (thesis) of the book followed by a thorough description of evidence presented in the book to back up the author’s claims. In the introduction of the book report, you will identify the author’s thesis and explain it in your

An online experiment on reaction time located within the psychology

For this assignment, you will participate in an online experiment on reaction time located within the psychology learning tools”. Once you have completed the experiment you will need to analyze data (I will give you data) and write a lab report (7- 10 pages) in APA style consisting of the

What do the four parts of the Christian biblical narrative

What do the four parts of the Christian biblical narrative (i.e., creation, fall, redemption, and restoration) say about the nature of God and of reality in relation to the reality of sickness and disease? From where would one find comfort and hope in the light of illness according to this

HRM4002 People in Organisations Case Study – Report and Presentation:

Question 2. Motivation and effective teams, and presentation Analyse and evaluate the ways in which ZPG may build effective teams through motivation; identify team development attributes that may contribute to ZPG success. Present your main findings in a presentation suitable for ZPG managers. (Suggested word count – 1400 words including

UA GRANTHAM Healthcare Data Discussion Nursing Assignment Help

Expert Solution Preview Introduction: As a medical professor responsible for creating college assignments and evaluating student performance, my main goal is to facilitate the learning process and assess the knowledge and skills of the medical college students. In order to do so, I design and conduct lectures, examinations, and assignments

As we all know, pain and pain management is becoming

As we all know, pain and pain management is becoming a major issue in our society, as providers, how can we help our patients and maintain the integrity/legal aspects of our profession? Requirements; Use academic jargon Needs to be APA 7th edition 400 words with 2 references less than 10%