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

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are designations used to describe complex economic market structures. These represent three of the categories which are further broken down. Keep in mind, perfect markets are a theoretical construct. Case 3 Resources What Does Imperfect

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are

Module 3 – CaseImplications of Market StructuresAssignment Overview Market Structure Analysis Monopolistic, Oligopolistic, and Competitive are designations used to describe complex economic market structures. These represent three of the categories which are further broken down. Keep in mind, perfect markets are a theoretical construct. Case 3 Resources What Does Imperfect

Module 3 – SLPImplications of Market StructuresAssignment Overview Economics and Cryptocurrency Cryptocurrency has supporters and detractors. Is it a

Module 3 – SLPImplications of Market StructuresAssignment Overview Economics and Cryptocurrency Cryptocurrency has supporters and detractors. Is it a tool for transparency in digital transactions? Is it a way to evade taxes or hide net worth? Session Long Project 3 Resources Cryptocurrency Explained With Pros and Cons for Investment (2024)The Crypto

An important aspect of a change management strategy is to consider how different alternatives may impact future outcomes. Organizations often use the

An important aspect of a change management strategy is to consider how different alternatives may impact future outcomes. Organizations often use the business case method to explore strategic alternatives as it helps simulate a real situation. Such simulations help with identifying business issues and provide critical information that organizations can

Module 1 – CasePersonality and MotivationAssignment OverviewApplying Motivational Theories Herzberg posits that motivation is influenced by hygiene

Module 1 – CasePersonality and MotivationAssignment OverviewApplying Motivational Theories Herzberg posits that motivation is influenced by hygiene factors (which can demotivate if absent) and motivators (which can boost satisfaction when present). You will provide insights into motivation for a multi-generational workforce. Using the framework of McGregor’s Theory X and Theory

Module 1 – CasePersonality and MotivationAssignment OverviewApplying Motivational Theories Herzberg posits that motivation is influenced by hygiene

Module 1 – CasePersonality and MotivationAssignment OverviewApplying Motivational Theories Herzberg posits that motivation is influenced by hygiene factors (which can demotivate if absent) and motivators (which can boost satisfaction when present). You will provide insights into motivation for a multi-generational workforce. Using the framework of McGregor’s Theory X and Theory

ListenMBA 620 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: Prepare and

ListenMBA 620 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: Prepare and present internal and external reports. Monitor and evaluate performance. Recommend opportunities for performance improvements. Scenario You are a former pilot, and you are now the controller of a division of

MBA 580 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: Evaluate creative an

MBA 580 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: Evaluate creative and innovative organizational structures Recommend alternative innovations to solve an internal or market need Implement creative and innovative processes within an organization Overview Companies that are innovative must make sure