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 stat

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.

Share This Post

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

Related Questions

MALPRACTICE APOLOGY ANNOTATED BIBLIOGRAPHY INSTRUCTIONS OVERVIEW The Malpractice Apology Annotated Bibliography and the Malpractice Apology Research Paper are related assignments that require you to r

MALPRACTICE APOLOGY ANNOTATED BIBLIOGRAPHY INSTRUCTIONSOVERVIEWThe Malpractice Apology Annotated Bibliography and the Malpractice Apology ResearchPaper are related assignments that require you to research the existing literature and thendevelop the information from your sources into a critical analysis and practical application. Bothyour research of the literature and the research paper will focus

Repairing Customer Satisfaction Board of Directors Presentation Overview For your final assignment, you will continue to use the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfac

Repairing Customer Satisfaction Board of Directors Presentation Overview For your final assignment, you will continue to use the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study to complete the assignment, you will need to read the case study and the article, The Art of Setting the Stage for Persuasion to develop the Board of

Files and Resources: All related files for the Final Project are available in the Modules → Final Project Folder on Canvas. You will find a ZIP folder that includes: Two datasets: House Price Data Ba

Files and Resources: All related files for the Final Project are available in the Modules → Final Project Folder on Canvas.You will find a ZIP folder that includes: Two datasets: House Price Data Basketball Season Wins Data A Final Project Summary Report Template After unzipping the folder, review the files and choose one dataset to complete your

To: Consulting Team From: CEO Re: Research Project and Presentation For this project, you will be focusing on Organizational Change, which is discussed in Chapter 16. Organizational change can come ab

To: Consulting TeamFrom: CEORe: Research Project and Presentation For this project, you will be focusing on Organizational Change, which is discussed in Chapter 16. Organizational change can come about for a number of reasons, which include problems within the organization that decreases its reputation or product confidence, innovation, technological improvements,

Assignment Overview In this week’s Strategic Management Research Project presentation, you will demonstrate your understanding of strategic management, apply critical thinking and problem-solving skil

Assignment Overview In this week’s Strategic Management Research Project presentation, you will demonstrate your understanding of strategic management, apply critical thinking and problem-solving skills, and exercise your skills in quality control when you evaluate the effectiveness of operational changes at Alphabet, Inc. Recall that you are the assistant strategic development

For this essay assignment, you are tasked with locating a company or business that has experienced an ethical issue within the last 5 years. In your essay, you will include the following information:

For this essay assignment, you are tasked with locating a company or business that has experienced an ethical issue within the last 5 years. In your essay, you will include the following information: the name of the company or business and a description of the ethical issue that took place,

You will create two concept maps using PowerPoint. You will need to use slide notes to expand upon the topics of your concept maps. The goal is to create a visualization of your responses to the promp

You will create two concept maps using PowerPoint. You will need to use slide notes to expand upon the topics of your concept maps. The goal is to create a visualization of your responses to the prompts listed below. Keep it simple and readable. You may search the internet to

For the second assignment, you will continue to use the “Repairing Customer Satisfaction’ Download “Repairing Customer Satisfaction’case study to develop the second of two progress reports. You will a

For the second assignment, you will continue to use the “Repairing Customer Satisfaction’ Download “Repairing Customer Satisfaction’case study to develop the second of two progress reports. You will access the case study via the link provided and follow the instructions below. Review “Types of Data Analysis” Download “Types of Data Analysis”, for additional information

Pageof 3ZoomBUSI 830 Page 1 of 3 BIBLICAL, ETHICAL RESEARCH ASSIGNMENT INSTRUCTIONS OVERVIEW In this assignment, you will research Biblical, ethical research. Establishing a firm ethical foundation ba

Pageof 3ZoomBUSI 830Page 1 of 3BIBLICAL, ETHICAL RESEARCH ASSIGNMENT INSTRUCTIONSOVERVIEWIn this assignment, you will research Biblical, ethical research. Establishing a firm ethicalfoundation based on Biblical principles can reduce the researcher’s bias as well asmisrepresenting the literature and study findings. As Christians, we want to ensure we are beingobedient to God

This is a a journAl entry. No Ai or plagiarism included, pleas! Write a 525- to 700-word response to the following prompts in your journal entry: Identify Alphabet’s short-term and long-term goals.Ev

This is a a journAl entry. No Ai or plagiarism included, pleas! Write a 525- to 700-word response to the following prompts in your journal entry: Identify Alphabet’s short-term and long-term goals. Evaluate how mergers and acquisitions in the last 3 to 5 years have contributed to Alphabet’s performance and affected

ou must then post 1 reply to one of your peers of as close to 300 words as possible by 11:59 p.m. (ET) on Sunday of the assigned Module: Week. For each thread, you must support your assertions with at

ou must then post 1 reply to one of your peers of as close to 300 words aspossible by 11:59 p.m. (ET) on Sunday of the assigned Module: Week. For each thread, youmust support your assertions with at least 3 peer-reviewed, scholarly citations (besides thepossible use of the course texts

Discussion Thread: Case Study Research: Digital Considerations Types of Iterative Bounding Regarding ‘iterative bounding’, discuss the 3 types (spatial, temporal, and relational). Application of Boun

Discussion Thread: Case Study Research: Digital Considerations Types of Iterative Bounding Regarding ‘iterative bounding’, discuss the 3 types (spatial, temporal, and relational). Application of Bounding to an Element of a Digital Case Study Design THEN show how you would apply at least 1 of these 3 types of bounding to 1 of 8

BUSI 830 Page 1 of 2 DATA GATHERING TOOLS AND ANALYSIS TECHNIQUES ASSIGNMENT INSTRUCTIONS OVERVIEW While data is information, evidence is data in support of some proposition. Collecting and analyzing

BUSI 830Page 1 of 2DATA GATHERING TOOLS AND ANALYSIS TECHNIQUES ASSIGNMENTINSTRUCTIONSOVERVIEWWhile data is information, evidence is data in support of some proposition. Collecting andanalyzing data is a major element of the work of a case study that requires severalconsiderations, such as delimitations, limitations, and assumptions; triangulation; population andsampling, etc. This

1) PERSONAL EXPERIENCE This section is intended to give you, as the applicant, the opportunity to discuss how your lived experiences, including those outside of your academic experiences, resulted in

1) PERSONAL EXPERIENCE This section is intended to give you, as the applicant, the opportunity to discuss how your lived experiences, including those outside of your academic experiences, resulted in a positive outcome that helped prepare you for this stage in your life. This section is not intended to compel

Country Project Report : FIJI Students will conduct research on an assigned country and complete a report about the country including the following information: Political environment Political system

Country Project Report : FIJI Students will conduct research on an assigned country and complete a report about the country including the following information: Political environment Political system (provide a score as well as information about the scale, state where the country lies on the continuum discussed in class, and

You will continue to use the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study to develop a hypothesis for your framed problem. This will be your first draft; you

You will continue to use the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study to develop a hypothesis for your framed problem. This will be your first draft; you will develop the final draft integrating your instructor’s feedback in the Week 6 Assignment. Instructions Based on the case study “Repairing Customer Satisfaction” Download “Repairing

Using the company Amazon.com, conduct a comprehensive analysis through the lens of strategic management. The paper should be 8–10 pages in length (not including title page and references) and incorpor

Using the company Amazon.com, conduct a comprehensive analysis through the lens of strategic management. The paper should be 8–10 pages in length (not including title page and references) and incorporate at least 10 high-quality academic or professional sources (e.g., peer-reviewed journals, credible business publications, textbooks). Using concepts and frameworks from

Prepare a detailed 7-8 page comprehensive analysis based on an integrated view of international business management using the company Toss, toss.im, a South Korea based finance app that plans to expan

Prepare a detailed 7-8 page comprehensive analysis based on an integrated view of international business management using the company Toss, toss.im, a South Korea based finance app that plans to expand services to Australia by the end of 2025. Paper details attached.