Our Services

Get 15% Discount on your First Order

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

March 31, 2024

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:

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
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.
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.

HR Management

Share This Post

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

Related Questions

Write or deliverable Length: 400-600 words by responding to the following questions with your thoughts, ideas, and comments. This will be the foundation for

Write or deliverable Length: 400-600 words by responding to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be s

In your paper, complete the following: · Summarize the case study. · Describe credible and scholarly sources relevant to a particular theory. · Apply

In your paper, complete the following: · Summarize the case study. · Describe credible and scholarly sources relevant to a particular theory. · Apply a social psychological theory to a chosen case study. · Explain how social psychological research studies relate to a particular social psychological theory. · Apply an

PROJECT DESCRIPTION The use of digital media has transformed how companies communicate with their customers. The use of the websites, YouTube, e-books, e-mail

PROJECT DESCRIPTION The use of digital media has transformed how companies communicate with their customers. The use of the websites, YouTube, e-books, e-mail and various forms of social media such as Facebook, Twitter, Pinterest, Snapchat, Instagram, and blogs has shaped current day communication strategies. Project 1 Consists of: 1. Project

Learning Assessment #4 Please complete the following steps as your Learning Assessment. This Learning Assessment serves as your exam, therefore do

Learning Assessment #4 Please complete the following steps as your Learning Assessment. This Learning Assessment serves as your exam, therefore do not share your answers otherwise it will be considered as academic dishonesty. Please refer to the syllabus for consequences of Academic Plagiarism. This Learning Assessment is worth 100 points.

Define and describe the concept of Organization Development, show how it operates, and describe the role of action research in strengthening an

Define and describe the concept of Organization Development, show how it operates, and describe the role of action research in strengthening an organization’s structure, culture, and processes. Strengthen your argument by choosing one of the seven illustrations cited in Chapter One that best fits your workplace. You will support your

Analyze the following transactions using the T account approach. Place the dollar amounts on the debit and credit sides. Indicate next to each entry the

Analyze the following transactions using the T account approach. Place the dollar amounts on the debit and credit sides. Indicate next to each entry the number for that transaction. After all transact Analyze the following transactions using the T account approach. Place the dollar amounts on the debit and credit

Essay: Comparison and Contrast After receiving feedback from your prewriting assignment, complete this assignment following the instructions on this

Essay: Comparison and Contrast After receiving feedback from your prewriting assignment, complete this assignment following the instructions on this page. Save a copy of your document, and submit it for grading. To submit your graded project, proceed to the Graded Assignment page in the course. Follow the instructions provided to

Unit 7 Use Berkshire Hathaway Phase IV Part II: Credit Policies and Profitability Analysis Overview: This unit requires you to analyze the impact of

Unit 7 Use Berkshire Hathaway Phase IV Part II: Credit Policies and Profitability Analysis Overview: This unit requires you to analyze the impact of various credit policies on your chosen company’s profitability. Consider different credit terms and policies that the company might adopt and evaluate how these would influence cash

Use the resources linked below to help complete this assessment. Collapse All Models, Tools, and Data Exploration The set of

Use the resources linked below to help complete this assessment. Collapse All Models, Tools, and Data Exploration The set of readings focus on the collection and use of data to monitor and produce quality outcomes. · McGonigle, D., & Mastrian, K. (2022). Nursing informatics and the foundation of knowledge (5th ed.).

After watching the video posted below on John Locke and Thomas Hobbes, which forms of government best relate to each philosopher? Please elaborate on

After watching the video posted below on John Locke and Thomas Hobbes, which forms of government best relate to each philosopher? Please elaborate on your response in 5-6 sentences using terms from your text.

Your written assignment for this module should be a 1-2 page paper (not including title page and reference page) that describes the following: • What are

Your written assignment for this module should be a 1-2 page paper (not including title page and reference page) that describes the following: • What are the different types of immunities and give an example of each • Describe how stress impacts the immunity of a person You should include

Description Reply to Introduction to Operations Management Discussion 2 Q – Please read the discussion below and prepare a Reply to this discussion

Description Reply to Introduction to Operations Management Discussion 2 Q – Please read the discussion below and prepare a Reply to this discussion post with comments that further and advance the discussion topic. Discussion Introduction Internally, the organization’s most effective business processes are fully managed and administered. Operations management is

HOw many franchise wins does the Solar Bears Hocket team have

Pathophysiology PowerPoint Assignment Each student will select one disease process/disorder from one of the five topics listed below. Examples are provided.

Pathophysiology PowerPoint Assignment Each student will select one disease process/disorder from one of the five topics listed below. Examples are provided. Students will create a PowerPoint presenta

Harriet is a 51-year-old married woman with a past history of alcohol and cocaine abuse. She has been attending AA and NA meetings regularly and does not

Harriet is a 51-year-old married woman with a past history of alcohol and cocaine abuse. She has been attending AA and NA meetings regularly and does not report urges to drink or use drugs during the 4 years you have been her psychiatric mental health nurse practitioner. She needs carpal