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 sta

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.

Share This Post

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

Related Questions

For this assignment, you will research the different ways that managers and leaders use communication to guide their organizations. Find an instance where the organizational leader communicates direct

For this assignment, you will research the different ways that managers and leaders use communication to guide their organizations. Find an instance where the organizational leader communicates directly with his or her employees, investors, or customers. Analyze the message, the channel, and the potential for feedback. Do you believe that

For this assignment, you are an employee who is experiencing a global workplace issue. This issue may be a current issue you are facing, a past issue, or a hypothetical issue. Design a plan to resolve

For this assignment, you are an employee who is experiencing a global workplace issue. This issue may be a current issue you are facing, a past issue, or a hypothetical issue. Design a plan to resolve this global workplace issue.In this formal plan, include the following information. Use these subheadings

This assignment is for a speech class , I need a persuasive speech on one of these topics and it does not matter which topic you pick. Topics are student loans, mental health awareness and gun control

This assignment is for a speech class , I need a persuasive speech on one of these topics and it does not matter which topic you pick. Topics are student loans, mental health awareness and gun control. Choose 1 of the 3 . Speech need’s to be well organized !

This assignment is for a speech Communications Class: Think of an opportunity you had to be persuasive and convince someone to change their mind. Describe that situation , and explain if you were

This assignment is for a speech Communications Class: Think of an opportunity you had to be persuasive and convince someone to change their mind. Describe that situation , and explain if you were successful. If you were explain. And if not explain what you would have done differently? Needs to

LDR 4302-20.01.01-5A25-S1, Communication Skills for Leaders Unit III Case Study Understanding yourself, as well as others, aids in learning how to adapt to differences. We can develop better conflict

LDR 4302-20.01.01-5A25-S1, Communication Skills for Leaders Unit III Case Study Understanding yourself, as well as others, aids in learning how to adapt to differences. We can develop better conflict management skills and more effective communication habits when we understand our own perspectives and learn to respect and adapt to others’ social,

Part I: Read A Heated Conversation Scenario. A PDF version of A Heated Conversation Scenario is also provided. Identify one noisemaker and one communication barrier for Emerson. Explain how these nega

Part I: Read A Heated Conversation Scenario.A PDF version of A Heated Conversation Scenario is also provided. Identify one noisemaker and one communication barrier for Emerson. Explain how these negatively affect Emerson’s communication.Next, identify one noisemaker and one communication barrier for Charlie. Explain how these negatively affect Charlie’s communication. Reminder:

Locate an article in the CSU Online Library that focuses on managing conflict in an organization through communication. For this assignment, you will need to accurately identify the article’s premise,

Locate an article in the CSU Online Library that focuses on managing conflict in an organization through communication. For this assignment, you will need to accurately identify the article’s premise, significant points in support of the premise, and the significance of those points to the course and/or the field. You

need to make my 2100 word AI content humanize with no AI detectetion and zero plagirism and also make a powerpoint presentation with all six questions and noting down points with suitable pictures

For this assignment showcases your personal brand. Your personal brand represents how you want to be perceived professionally, the values you stand for, and your unique strengths. Building a strong pe

For this assignment showcases your personal brand. Your personal brand represents how you want to be perceived professionally, the values you stand for, and your unique strengths. Building a strong pe For this assignment showcases your personal brand. Your personal brand represents how you want to be perceived professionally, the

For this assignment showcases your personal brand. Your personal brand represents how you want to be perceived professionally, the values you stand for, and your unique strengths. Building a strong pe

For this assignment showcases your personal brand. Your personal brand represents how you want to be perceived professionally, the values you stand for, and your unique strengths. Building a strong personal brand is essential as it helps you communicate who you are and what you bring to the table, giving

For this assignment, you will research the different ways that managers and leaders use communication to guide their organizations. Find an instance where the organizational leader communicates direct

For each of the following statements, respond in 1—2 paragraphs: Explain how the Four-Step Outline concept can serve as a fundamental framework for structuring various types of presentations, from int

For each of the following statements, respond in 1—2 paragraphs: Explain how the Four-Step Outline concept can serve as a fundamental framework for structuring various types of presentations, from internal updates to external sales pitches. Four-Step Outline (Tell what, Tell why, Tell, Tell what has been told) Provide a detailed

By exploring practical instances where businesses and teams have effectively utilized panel discussions, individuals will better understand how collaboration between different departments can be stren

By exploring practical instances where businesses and teams have effectively utilized panel discussions, individuals will better understand how collaboration between different departments can be strengthened. Instructions For each of the following statements, respond in 1—2 paragraphs: Identify delegation techniques that are well-known. Describe what can be learned or gained from

Create and evaluate a degree map.Create strategies to increase skill deficits.Evaluate a professional conversation.Instructions Following the live discussion with your partner, you will reflect on the

Create and evaluate a degree map. Create strategies to increase skill deficits. Evaluate a professional conversation. Instructions Following the live discussion with your partner, you will reflect on the conversation and evaluate the quality. Evaluate yourself and your partner in terms of quality of preparation, communication skills, and the ability

Writing Requirements (APA format) Must use the integrated templateLength: Minimum 6 pages (including the title page and references page)1-inch marginsDouble spaced12-point Times New Roman fontReferenc

Writing Requirements (APA format) Must use the integrated template Length: Minimum 6 pages (including the title page and references page) 1-inch margins Double spaced 12-point Times New Roman font References page (sources provided)

Locate an article in the CSU Online Library that focuses on managing conflict in an organization through communication. For this assignment, you will need to accurately identify the article’s premis L

Locate an article in the CSU Online Library that focuses on managing conflict in an organization through communication. For this assignment, you will need to accurately identify the article’s premis Locate an article in the CSU Online Library that focuses on managing conflict in an organization through communication. For this

This assignment will be an analysis of a few powerpoint slides. The paper should be a summary of each content section of the powerpoint slide given. I will provide the instructions and the outline w

This assignment will be an analysis of a few powerpoint slides. The paper should be a summary of each content section of the powerpoint slide given. I will provide the instructions and the outline with powerpoint. Must be APA Must use the integrated template Length: Minimum 2 pages (not including