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

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.

This is a journal entry prompt that needs to be written in your own words, no AI or Plagiarism, please ! Continuing your analysis of Alphabet, you will evaluate its strategic effectiveness, organizati

This is a journal entry prompt that needs to be written in your own words, no AI or Plagiarism, please ! Continuing your analysis of Alphabet, you will evaluate its strategic effectiveness, organizational structure, and its internal and external environment for your research journal this week. You will use your

You 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 a

You 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

CASE STUDY METHODOLOGY ASSIGNMENT INSTRUCTIONS OVERVIEW Researchers describe the background of the problem to define the root problem and explain the organizational consequences – this is where you wi

CASE STUDY METHODOLOGY ASSIGNMENT INSTRUCTIONSOVERVIEWResearchers describe the background of the problem to define the root problem and explain theorganizational consequences – this is where you will ‘well-define’ your case study. The problemstatement is a foundational component of the research study. In this assignment, you will beginto craft a single case

Discussion Thread: Problem Statements and Research Questions Business Problem Information A bank is experiencing a decrease in productivity. Employees appear to be stressed as a result of unmitigated

Discussion Thread: Problem Statements and Research Questions Business Problem Information A bank is experiencing a decrease in productivity. Employees appear to be stressed as a result of unmitigated job demands. Bank leaders have tried to address the issues but their efforts have had minimal positive impact. Leaders at the bank,

This is a journal entry that must be written in your own words, no ai or plagiarism included please! Instructions below: Strategic management includes an analysis of a business’s current state. Contin

This is a journal entry that must be written in your own words, no ai or plagiarism included please! Instructions below: Strategic management includes an analysis of a business’s current state. Continuing with your research of Alphabet, you will leverage the business SWOT tool to identify and drive organizational strategic

OVERVIEW OF CASE STUDIES ASSIGNMENT INSTRUCTIONS OVERVIEW Each case study type and its design are slightly different. These differences are important for researchers to consider when selecting a case

OVERVIEW OF CASE STUDIES ASSIGNMENT INSTRUCTIONSOVERVIEWEach case study type and its design are slightly different. These differences are important forresearchers to consider when selecting a case study type most appropriate for their research.Regardless of the type or design, each case study centers around its subject and object.Researchers typically build their

In a two page Word document, summarize the concepts learned in this course. Be sure to include: The role of forecasting in decision makingRisks associated with capital budgetingHow financial ratios (

In a two page Word document, summarize the concepts learned in this course. Be sure to include: The role of forecasting in decision making Risks associated with capital budgeting How financial ratios (analysis) assist in forecasting and budgeting Challenges in budgeting and forecasting Your paper should be in APA format

You will be using the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study for all of the assignments in this course. To complete the first assignment, you will need

You will be using the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study for all of the assignments in this course. To complete the first assignment, you will need to read the case study to develop the first progress report on your findings for the CEO. You will access the case study