Our Services

Get 15% Discount on your First Order

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

August 30, 2024

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:

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.

Business & Finance

Share This Post

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

Related Questions

SLP/BUS520 Business Analytics and Decision Making Business Analytics & Intelligence Reporting Assignment Overview Final Analysis We have been working

SLP/BUS520 Business Analytics and Decision Making Business Analytics & Intelligence Reporting Assignment Overview Final Analysis We have been working with survey data throughout class. Create a final report that can be used by industry leaders. Data analysis is transformed to business intelligence. This is where you make the tough

Topic: Supply Chain and Pandemic 500 – 1,200 words with at least 4 sources; work cited page should be at the bottom. Topic: Supply Chain and Pandemic Your

Topic: Supply Chain and Pandemic 500 – 1,200 words with at least 4 sources; work cited page should be at the bottom. Topic: Supply Chain and Pandemic Your outline will look something like this: Research Question: Thesis Statement: (a complex sentence that answers your Research Question) Topic sentence 1: (The

In Milestone One, you recommended an innovation option (incremental or discontinuous) to the organization from the course scenario. Now that senior

In Milestone One, you recommended an innovation option (incremental or discontinuous) to the organization from the course scenario. Now that senior management of the company has approved your recommendation, your task is to find an efficient process for your cross-functional team to follow during the development of your innovation. Remember

The Ratio Analysis on Marriott is attached with the question. Write a 0.5-page, 12-font, double-space, financial assessment based on the ratio analysis.

The Ratio Analysis on Marriott is attached with the question. Write a 0.5-page, 12-font, double-space, financial assessment based on the ratio analysis. Base the write-up purely on the ratio analysis provided. In the write-up, you will interpret the ratios and their trends that help you figure out the financial performance

A ratio anaylsis on the template provided with a write up of 0.5 page of the analysis. 1. Do a ratio analysis of Marriott International for the years

A ratio anaylsis on the template provided with a write up of 0.5 page of the analysis. 1. Do a ratio analysis of Marriott International for the years 2019, 2020, and 2021. The template for the Ratio Analysis is attached with the question. The annual financial reports of the above

1. Create a ratio analysis of Marriott International for the years 2019, 2020, and 2021. The template for the Ratio Analysis is attached with the question.

1. Create a ratio analysis of Marriott International for the years 2019, 2020, and 2021. The template for the Ratio Analysis is attached with the question. The annual financial reports of the above years are also attached. 2. After filling out the template, make an overall assessment of the financial

This lab will use the following Lab Resources. Virtual Lab Citrix (MS Word 2016 or 2019) You can use a personal copy of the software or access the Lab

This lab will use the following Lab Resources. Virtual Lab Citrix (MS Word 2016 or 2019) You can use a personal copy of the software or access the Lab Resources located in the Course Resources page. Step 1: Lab Preparation Please review the following video on how R is used

To what extent does a rigorous Corporate Social Responsibility policy lead to a company being ethical? Support your answer with reference to two

To what extent does a rigorous Corporate Social Responsibility policy lead to a company being ethical? Support your answer with reference to two companies. There are two parts of the essay I need to provide Part1 : The writer need to show plan for overall structure of essay with list 5

Follow all Instructions for the Community Assessment Plan This is for the grant Transitional Living Program Grant for youths/adults ages 16-22. A need

Follow all Instructions for the Community Assessment Plan This is for the grant Transitional Living Program Grant for youths/adults ages 16-22. A need statement is an important part of a grant proposal. It describes the reasons the grant is needed and makes a case for why support should be provided.

Research design refers to the specific type of study that you will conduct. Research design is normally consistent with the philosophical worldview and

Research design refers to the specific type of study that you will conduct. Research design is normally consistent with the philosophical worldview and methodological approach of the researcher. In this case, you are using a quantitative methodology. As we have discussed in this course, quantitative research designs include experimental and

For this assignment, you will define the research objectives and develop the research questions and hypotheses to set the stage for the Sun Coast

For this assignment, you will define the research objectives and develop the research questions and hypotheses to set the stage for the Sun Coast Remediation research project. Be sure to include the following sections in your submission, and remember to use APA-formatted section headings and subheadings. Introduction Research problems Research

SLP3/BUS530 Managerial Economics Implications of Market Structures Assignment Overview Economics and Cryptocurrency Cryptocurrency has supporters and

SLP3/BUS530 Managerial Economics Implications of Market Structures Assignment 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 ResourcesA beginner’s guide to cryptocurrency (2022)Biden orders government to study

5-2 Project Draft: Communication Strategies to Navigate Conflict Make sure you’ve included all the required elements by reviewing the guidelines and

5-2 Project Draft: Communication Strategies to Navigate Conflict Make sure you’ve included all the required elements by reviewing the guidelines and rubric.Please see attachments along with the assignments you did

5-1 Discussion: Going Beyond Conflict by Applying Restorative PracticesEffective conflict management often includes using restorative practices. In this

5-1 Discussion: Going Beyond Conflict by Applying Restorative PracticesEffective conflict management often includes using restorative practices. In this discussion, you will explore how to take conflict management to the next level by applying restorative practices. Discussing challenges that face our world often means investigating opinions and ideas different from your

Ethical Lens Paper 6-8 pages For this task, you will respond to an ethical situation as well as analyze the results of the Ethical Lens Inventory (ELI),

Ethical Lens Paper 6-8 pages For this task, you will respond to an ethical situation as well as analyze the results of the Ethical Lens Inventory (ELI), which should be completed in the course. This task focuses on you as a leader by helping you to define, refine, and test

Ethical Paper 2: 6-8 pages As a leader in your organization, it is vital that you are familiar with the laws that regulate your industry. Sparked by the

Ethical Paper 2: 6-8 pages As a leader in your organization, it is vital that you are familiar with the laws that regulate your industry. Sparked by the dramatic corporate and accounting scandals of Enron, Arthur Andersen, Adelphia, and WorldCom, the Sarbanes-Oxley Act was implemented in 2002 in an effort

Discussion Find an article using the APUS Library or the internet regarding one of the terms found in Chapter 1 or 2 readings. For example: Articles of

Discussion Find an article using the APUS Library or the internet regarding one of the terms found in Chapter 1 or 2 readings. For example: Articles of Incorporation, S-Corporation, Limited Liability Company Sarbanes-Oxley Act Dodd-Frank Act Time Value of Money Insider Trading Income Statement: Earnings per Share, Price-earnings Ratio Balance

Ethical Paper 1 6-7 pagesAs an organizational leader, one of your primary roles is establishing programs and policies that ensure the organization operates

Ethical Paper 1 6-7 pagesAs an organizational leader, one of your primary roles is establishing programs and policies that ensure the organization operates under ethical considerations and legal mandates. This responsibility includes informing employees of the organization’s code of ethics, communicating the code of ethics, providing training, and ensuring that