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

April 1, 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.

Communications

Share This Post

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

Related Questions

Please, discuss a state-level response to the reversal of Roe

Please, discuss a state-level response to the reversal of Roe v Wade through one specific, politically-feasible policy measure, and provide 2 to 3 paragraphs of written response. 1, Please briefly explain the policy basis for why you selected that particular state of Arkansas ( Because it has the second highest

Instructions Right. The knee-jerk reaction is the way of society,

Instructions Right. The knee-jerk reaction is the way of society, right now, eh? “In my opinion…” Have you learned to consider, to look deeper into things, to research — to do some philosophy?? To make

Deliverable Length: 750–1,000 words Assignment Description Respond to the following

Deliverable Length: 750–1,000 words Assignment Description Respond to the following scenario with your thoughts, ideas, and comments. Be substantive and clear, and use research to reinforce your ideas. Mary Francis has just returned to her office after attending preliminary discussions with investment bankers. Her last meeting regarding the intended capital

PSYC 515 Discussion: Research Project Draft 1 and Peer Review Assignment Instructions

PSYC 515 Discussion: Research Project Draft 1 and Peer Review Assignment Instructions Overview This is the first written component of your professional research paper. This project will refine your graduate level writing abilities and allow you to practice scientific writing skills. It also requires you to locate and read many

Question: By the time he or she is finished reading,

Question: By the time he or she is finished reading, do the authors (Palenberg, Boorman and Malory) intend for readers to judge Arthur as a good and admirable king, whose strengths outweigh his weaknesses? Or as a bad king, impossible to admire, whose weaknesses outweigh his strengths? To support

please see attachment BODY PARAGRAPHS: Topic sentence: tells reader what paragraph is about • Highlight in color light pink • Box in words that

please see attachment BODY PARAGRAPHS: Topic sentence: tells reader what paragraph is about • Highlight in color light pink • Box in words that show the focus on their paragraph: media should referenced in some way (NOT SOCIAL MEDIA) and topic/connection/theme Evidence: support or proof of topic sentence • Highlight

Estimation (Confidence Intervals)

Create a MS word document that lists each Quantitative variable in the Class Survey Data, provide a point estimate of the mean (the sample mean) and a 95% confidence Interval for the sample mean for each variable. Also, use your 1 qualitative 1 quantitative relationship from Course Project 5 (Order

Overview Imagine that you are employed at one of the

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Q.1 write a reply for this article (Natali) The financial

Q.1 write a reply for this article (Natali) The financial institution I work for has four key strategies but the one that resonates with me is “Diversify and expand with new products and markets”. In 2019 Walmart ended the partnership with Synchrony after 20 years of service causing a

This is a reading assignment, 200-300 words. I have attached

This is a reading assignment, 200-300 words. I have attached the book and instruction. The assignment is really easy, the instruction just seem like a lot. Let me know if you can or can’t access the document in the chat. View: John Green, “Crash Course on Iranian Revolution” https://www.youtube.com/watch?v=8w4Ku6l7OEI (Links to

Key Assignment Part 1: The board of directors at AGC

Key Assignment Part 1: The board of directors at AGC needs a status update on your change management project. Shawn asks you to write an executive report for John and the board of directors about the change management process and the progress being made toward resolving the global human capital

Two different questions one is probability and the other one is geometry

Using proper APA formatting, cite the peer-reviewed article you selected

Using proper APA formatting, cite the peer-reviewed article you selected that pertains to your practice area and is of particular interest to you and identify the database that you used to search for the article. Explain any difficulties you experienced while searching for this article. Would this database be useful

The Department of Health and Human Services (2021), estimates that

The Department of Health and Human Services (2021), estimates that 53 million Americans are at increased risk for bone fractures. Calcium and Vitamin D are vital components for osteoporosis prevention. Dairy products, especially milk products, are common in the American diet and even have a familiar marketing campaign (“Got Milk?”)

Discuss an organization’s need for physical security. What methods, approaches,

Discuss an organization’s need for physical security. What methods, approaches, and models can be used by organizations when designing physical security needs? Lastly, explain how these security measures will safeguard the organization.Please make your initial post and two response posts substantive. A substantive post will do at least two of

Think of an incident of bias or discrimination that you

Think of an incident of bias or discrimination that you are aware of. It can be one that you have been a part of, witnessed, or seen in the news. Describe the incident and consider what could have been done to identify the issue and respond accordingly to avoid a

Leadership and Culture Survey Development

Develop questions for an employee survey to determine the views of department leadership and whether there is an inclusive workplace culture in PMC’s Lima plant, and make distribution recommendations on how the survey is sent and to who should receive it. Demonstration of Proficiency By successfully completing this assessment, you

Critical Thinking Questions 1 What happened at Wells Fargo with

Critical Thinking Questions 1 What happened at Wells Fargo with regard to past activities that led to this major scandal? 2 What internal dimensions of the company were part of the problems that occurred? 3 How might the organizational structure of the company have been part of the problems that