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

Discussion – Org Leader and Decision Making Practical connection – Org Leader and Decision Making Assignment – Operational Excellence

Week6_Test Plan Instructions: The Test Plan for each project includes the Pseudocode, Flowchart, Goals and Objectives, Functional Requirements, and Test

Week6_Test Plan Instructions: The Test Plan for each project includes the Pseudocode, Flowchart, Goals and Objectives, Functional Requirements, and Test Matrix including Actual Output column. Below the table are screenshots verifying the actual output for each case. Week 6 Notes – Methods/Functions Let us recall our Week 5 Notes: We

On line 190, Othello asks lago, “How shall I murder him?” Are you shocked by the brutality of the words? How can you account for Othello’sresponse? How

On line 190, Othello asks lago, “How shall I murder him?” Are you shocked by the brutality of the words? How can you account for Othello’sresponse? How should these lines be said—whispering, ranting, calm, menacing? Explain your reasons and, more importantly, how might yourdirection (decisions about how those lines should

Chapter 4: How do you think planning in today’s organizations compares to planning in an organization 25 years ago? Do you think planning becomes more

Chapter 4: How do you think planning in today’s organizations compares to planning in an organization 25 years ago? Do you think planning becomes more important or less important in a world where everything quickly changes and crises are a regular part of organizational life? Why? Chapter 4: Is

CASE #2 Nancy Jefferson is the superintendent of a medium-sized public school district. Nancy is passionate about finding ways to better prepare her

CASE #2 Nancy Jefferson is the superintendent of a medium-sized public school district. Nancy is passionate about finding ways to better prepare her district’s students for life after high school graduation. While the district’s current teaching methods are in accordance with the state-mandated curriculum and her district’s students are testing

how to address pharmacotherapy As you read and complete your coursework this week on pharmacokinetics, pharmacodynamics, and pharmacotherapeutics,

how to address pharmacotherapy As you read and complete your coursework this week on pharmacokinetics, pharmacodynamics, and pharmacotherapeutics, connect what you are learning to a current or recent article that relates to one of the week’s topics. Search for a recent professional journal article or an article from a professional website

1) What are some recommendations on ways that law enforcement can increase its effective and impactful use of technologies and information to keep

1) What are some recommendations on ways that law enforcement can increase its effective and impactful use of technologies and information to keep citizens safer? 2) Do most law agency funding sources (police departments) consider IT to be a commodity or a critical business necessity? 3) Why is it important

I need you to complete a presentation on ‘Financial Decision Making.’ Here are the specific requirements: Complete a PowerPoint presentation according

I need you to complete a presentation on ‘Financial Decision Making.’ Here are the specific requirements: Complete a PowerPoint presentation according to the requirements. Based on the PowerPoint, prepare a speech of approximately 15-20 minutes. Note: I have uploaded all the textbooks related to this course. I need you to

In Watch: What is a Ph.D.?,

In Watch: What is a Ph.D.?, read-Psychology and Christianity : Five Views by Eric L. Johnson, , David G. Myers, , Stanton L. Jones, , Robert C. Roberts, , P. J. Watson, , John H. Coe, , Todd W. Hall, , and David A. Powlison PUBLISHER InterVarsity Press DATE 2010-07-07

Several companies are known for linking their mission, values, and HR practices in ways that have ledto business success as well as employee satisfaction.

Several companies are known for linking their mission, values, and HR practices in ways that have ledto business success as well as employee satisfaction. These companies include Southwest Airlines(www.iflyswa.com), Cisco Systems (www.cisco.com), SAS Institute (www.sas.com), Verizon(www.verizon.com), Container Store (www.containerstore.com), Google (www.google.com), Steelcase(www.steelcase.com), Whole Foods (www.wholefoods.com), and TELUS (www.telus.com). Choose oneof

Build a slide presentation (PowerPoint preferred) of the hypothetical health promotion plan you developed previously. Then, implement your health

Build a slide presentation (PowerPoint preferred) of the hypothetical health promotion plan you developed previously. Then, implement your health promotion plan by conducting a hypothetical face-to-face educational session addressing the health concern and health goals of your selected group. How would you set goals for the session, evaluate session outcomes,

Homework This discussion will help prepare you for Assignments 1 and 2. For these assignments, you will choose a target country from the list

Homework This discussion will help prepare you for Assignments 1 and 2. For these assignments, you will choose a target country from the list provided in the instructions, as well as a product or service to analyze. To get started, read and reply to each of the prompts below: ·

Overview Scenario 1 Lori is walking to her car in a shopping mall parking lot at night when Brian suddenly jumps in front of her and points a knife in her

Overview Scenario 1 Lori is walking to her car in a shopping mall parking lot at night when Brian suddenly jumps in front of her and points a knife in her face. Brian strikes Lori. Fortunately, Lori took a self-defense class and hits Brian with her knee and fists and

The research topic is Incorporating Social Emotional Learning (SEL) and Biblical Worldview in Christian Schools and use the template and follow the

The research topic is Incorporating Social Emotional Learning (SEL) and Biblical Worldview in Christian Schools and use the template and follow the advanced side of the grading rubric

Your readings this week have focused on health care financing with particular attention given to the topics of Medicaid coverage and health care

Your readings this week have focused on health care financing with particular attention given to the topics of Medicaid coverage and health care spending. For your discussion, please respond to the following prompt: ● Describe (note: describe, do not just list) the major ways that health care delivery is financed

Module 04 Written Assignment – Nursing Diagnosis Purpose of the Assignment 1. Assist students in clustering assessment data

Module 04 Written Assignment – Nursing Diagnosis Purpose of the Assignment 1. Assist students in clustering assessment data when developing a nursing diagnosis. 2. Develop students’ ability to write client based outcomes when planning care. Course Competencies · Explain components of multidimensional nursing care for clients with musculoskeletal disorders. Scenario