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

The purpose of this presentation assignment is to research emerging technologies that impact businesses and society and how individuals, businesses, and go

The purpose of this presentation assignment is to research emerging technologies that impact businesses and society and how individuals, businesses, and government organizations go about protecting users in the cyberworld. The technologies we focus on in this research are in telecommunications, the Internet, and wireless technologies. These technologies improve the

Evaluate change management plans. Introduction: Redman (2019) states that the world is changing quickly, change is hard, and many change efforts fail. A

Evaluate change management plans. Introduction: Redman (2019) states that the world is changing quickly, change is hard, and many change efforts fail. A leader must have a good plan in place to navigate through these changes to stay successful. Now, you will apply that knowledge to a company scenario, building

You are a former Navy officer and fighter pilot who is now the controller of a division of TransGlobal Airlines, which utilizes a fleet of corporate jets

You are a former Navy officer and fighter pilot who is now the controller of a division of TransGlobal Airlines, which utilizes a fleet of corporate jets for charter at several airports in the southeast part of the United States. Your division’s private charter clients include several Fortune 500 companies

Read the case study “Southwest Airlines,” found in Part 2 of your textbook.Review the “Guide to Case Analysis,” found on pp. CA1-CA11 of your textbook (the

Read the case study “Southwest Airlines,” found in Part 2 of your textbook.Review the “Guide to Case Analysis,” found on pp. CA1-CA11 of your textbook (the guide follows the last case in the textbook).Use the Case Study Format as described in the “Guide to Case Analysis” to complete a written

Must be in Times New Roman. The body of the document should be printed in standard 12-point font size. Indent paragraphs in all assignments and use double

Must be in Times New Roman. The body of the document should be printed in standard 12-point font size. Indent paragraphs in all assignments and use double spacing within paragraphs. The business plan should be 2,500 words (+/- 10%) excluding the reference list & title page, double-spaced. Emphasize quality over quantity.

You are the Information Security Director for a medium-sized company. You recently experienced a ransomware attack that cost the company $500,000.00. After

You are the Information Security Director for a medium-sized company. You recently experienced a ransomware attack that cost the company $500,000.00. After the attack, your CEO held a meeting and informed you and the other IT professionals that it “WILL” not happen again. Write a Directive to the company’s employees

Create multiple charts to represent the division you have selected. The division “West North Central” cannot be used for your analysis. Within the TC Ice

Create multiple charts to represent the division you have selected. The division “West North Central” cannot be used for your analysis. Within the TC Ice Cream Excel Workbook, use the “Division Analysis” sheet to create the following charts. It is recommended that you use pivot table filtering functionality to filter the data

Quiz for INTRODUCTION TO BUSINESS DATE: AUG 8 9:00 AM TO 11:30 AM EST TORONTO TIME

Hello, I need help with an assignment: 6-1 Week six assignment INT 220 Module Six Assignment International Team Expectations Assignment Guidelines and

Hello, I need help with an assignment: 6-1 Week six assignment INT 220 Module Six Assignment International Team Expectations Assignment Guidelines and Rubric Overview Managing an international team will present unexpected challenges. You are in different time zones; you have different schedules; you come from different cultures; and your own

Unit II Case Study: It is important to understand what information systems are and why they are essential for running and managing a business. It is also

Unit II Case Study: It is important to understand what information systems are and why they are essential for running and managing a business. It is also important to understand the different systems that support different groups or levels of management. In addition, digital technology and the Internet play a

Many young people moving into apartments and new homes look forward to the excitement of furniture shopping. These young shoppers are usually interested in

Many young people moving into apartments and new homes look forward to the excitement of furniture shopping. These young shoppers are usually interested in cheaper, build yourself furniture, however, many of them are not too handy and the excitement quickly dissipates as they start putting their furniture together. The instructions,

See attachment…Respond in 100 unless indicated. There’s question that required 200 words.

You are the Public Information Officer (PIO) for a small company, responsible for communication distribution for your organization. Learning

You are the Public Information Officer (PIO) for a small company, responsible for communication distribution for your organization. Learning Objectives Explain the internal structures of the organizations Demonstrate using technology Prompt In this scenario, an unexpected incident has occurred within your local community, impacting the safety of employees returning to

Best ideas for the next management century? Based on the week’s readings, identify what you think are the three most important ideas to emerge from “the

Best ideas for the next management century? Based on the week’s readings, identify what you think are the three most important ideas to emerge from “the management century” that will help us manage effectively in the next management century, and write a persuasive essay to defend your choices. Books To

SLP/MGT 509 Human Resource Management It is important for HRM professionals to keep up on the HRM field. In this SLP assignment, you will be investigating

SLP/MGT 509 Human Resource Management It is important for HRM professionals to keep up on the HRM field. In this SLP assignment, you will be investigating an HRM practitioner publication, TD (Talent Development) found in the Trident Online Library. It is the main publication of the Association for Talent Development (ATD)—a well-known

Case/MGT509 Human Resource Management Performance/Talent Management; Change Management Consulting-OD Assignment Overview Signature Assignment: Body of

Case/MGT509 Human Resource Management Performance/Talent Management; Change Management Consulting-OD Assignment Overview Signature Assignment: Body of Knowledge, Introduced Level In this assignment your body of knowledge will be assessed at the “introduced” level. The first criterion, “Assignment Driven” in the rubric will be useful for this purpose. Case Assignment Address the

Health insurance for Veterans Affairs 1. In this assignment, as a group, you will select the change management model and justification you want to use for

Health insurance for Veterans Affairs 1. In this assignment, as a group, you will select the change management model and justification you want to use for your project based on the submission from the individual group members. Your group will describe the changes the organization needs to make to meet

Please add health insurance for VA and what type of insurance! 1. In this assignment, as a group, you will select the change management model and

Please add health insurance for VA and what type of insurance! 1. In this assignment, as a group, you will select the change management model and justification you want to use for your project based on the submission from the individual group members. Your group will describe the changes the