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

CHANGE TOPIC: Walking Hand-rails in Hallways in geriatric units for

 CHANGE TOPIC: Walking Hand-rails in Hallways in geriatric units for fall prevention If this topic is not workable please change but remember this is a Nursing assignment.  Review the Resources and identify one change that you believe is called for in your organization/workplace. This may be a change necessary to

First Exercise – Chapter 7 – List the keys to

    First Exercise – Chapter 7 – List the keys to using return on investment (ROI) successfully in the pursuit of profit and channel effectiveness.  Second Exercise – Chapter 8 – How do you position a product or service so that it is differentiated from products or services of

Growth Application and Ethical Perspectives Reflection Nursing Assignment Help

Your program has provided many opportunities for you to cultivate your competencies as a leader. Think about how your experiences contributed to and will continue to contribute to you becoming a more informed, reflective, and responsive leader. The Leadership Impact Paper provides an opportunity for you to assess and reflect

Key Themes in History

Show the following 1. Demonstrated knowledge of the textbook, documents, and discussion assignments? 2. Applied this knowledge skillfully and persuasively throughout their essays? 3. Inferred from known facts to arguable or “educated” guesses? 4. Cited (given proper credit to) the sources used by using quotation marks to set off the

Balance Sheet – Ford Motor Company In a two- to

Balance Sheet – Ford Motor Company In a two- to three-page paper (not including the title and reference pages), explain the purpose of a balance sheet and analyze Ford Motor Company’s balance sheet from its Ford Motor Company 2012 Annual Report (Links to an external site.). In your analysis, you

Please Answer these 2 Questions from the attached Case Study-Uber.

Please Answer these 2 Questions from the attached Case Study-Uber. 1)  Uber is notoriously aggressive in its business tactics. It frequently operates without getting regulatory approval and it often ignores legal concerns; consequently, the company has become a lightning rod for criticism. Should Uber be taking more of a “tiptoe”

Single girder overhead travelling cranes

The aims of the present coursework are to: • become familiar with the specific lifting devices (single girder overhead travelling cranes) and the standards used for their design • practice the calculation of N-Q-M diagrams, the application of the singularity-functions method and the calculation of the normal/shearing/equivalent stress in a

In your readings this week, Roger Brown described five stages

In your readings this week, Roger Brown described five stages of language development based on MLU.  In thinking about the stages, most children are able to use most of the variations in the English language by age 5.  Perform a morphological analysis using one of the language samples provided.  Discuss whether you believe

Chronic Kidney Disease, 3 pages, APA formatting for formatting and

   Chronic Kidney Disease, 3 pages, APA formatting for formatting and citations. Use double spacing, 12-point Times New Roman font, and one-inch margins.   IV. Treatment and Prevention: In this section, you will research and discuss prevention and treatment options available for the selected disease. A. Prevention Strategies: Describe the

Establishing threat intelligence goals and requirements will help the threat

  Establishing threat intelligence goals and requirements will help the threat intelligence team to better allocate and utilize its resources and fine-tune the data types, tools, and methods that will produce the most relevant and useful intelligence about the particular threats to the organization. Using the organization you chose in

Training Program

Review the following lecture: Global Workforce, Succession Planning, and Training Project The project assignment provides a forum for analyzing and evaluating relevant topics for this week on the basis of the course competencies covered. Introduction: In Week 3 Global Workforce, Succession Planning, and Training lecture, you were provided a case

Diary sections are utilized to record the monetary action of

   Diary sections are utilized to record the monetary action of your business. Diary passages are either kept in auxiliary records in the event that you’re keeping your books physically, or they’re recorded straightforwardly into the overall record (G/L) assuming you use bookkeeping programming. Whichever way they’re recorded, they are

Evidence suggests that patients do better when their expectations about

  Evidence suggests that patients do better when their expectations about specific benefits of nursing care are discussed and met.  Design a “comfort contract” whereby patients or their surrogates designate an expected level of postsurgical overall comfort, and also where they can specify chronic discomforts and interventions that they use

Make sure you have completed the Riverbend City scenario, Riverbend

  Make sure you have completed the Riverbend City scenario, Riverbend City: HPDP Program Design, and read the Ethical Standards for Human Services Professionals before beginning this discussion. For this discussion, present at least two professional standards and their application in this scenario. Choose the professional standards and describe how

DUE TOMORROW BY 4PM CST NO LATER To help you

   DUE TOMORROW BY 4PM CST NO LATER  To help you with your reply, please consider the following questions:  250 words each part 1 and 2 each  · What did you learn from the posting? · What additional questions do you have after reading the posting? · What clarification do