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

March 31, 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.

HR Management

Share This Post

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

Related Questions

1 Requirement Read page 90-102 1.What factors motivated Iberians to explore and colonize the Americas in the 16th century? How did westward

1 Requirement Read page 90-102 1.What factors motivated Iberians to explore and colonize the Americas in the 16th century? How did westward expansion impact Spain and Mexico? Define U.S. foreign policies during the 19th century regarding Latin America. How did these policies impact Latin America? What issues drove the Latinx

Business Finance – Management for proven ster 2 written assignment

Simulation: Energy Skate Park Basics https://phet.colorado.edu/sims/html/energy-skate-park-basics/latest/energy-skate-park-basics_en.html Select

Simulation: Energy Skate Park Basics Select Intro. Click on (Half pipe skateboard ramp) Select (Bar Graph), (Grid), (Speed), and select the smallest mass= 80 kg) Skater is at the top of the half pipe skateboard ramp. Drag the skater to the top of the track and start the animation

EDUC 775 CAREER INTEREST POWERPOINT ASSIGNMENT INSTRUCTIONS OVERVIEW Numerous professional and career opportunities are available in the field of

EDUC 775 CAREER INTEREST POWERPOINT ASSIGNMENT INSTRUCTIONS OVERVIEW Numerous professional and career opportunities are available in the field of educational psychology. After surveying job listings in educational psychology, you will construct a PowerPoint presentation portraying the landscape of the field. INSTRUCTIONS Compose a PowerPoint presentation on important components in the

Project Guidelines and RubricIDS 105 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following

Project Guidelines and RubricIDS 105 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: Describe the factors that influence one’s perception of social justice Examine the impact of intercultural competence on collaboration and communication Utilize interpersonal communication strategies to navigate conflict Overview In

For this Discussion Board, you are supposed to read the Essay#2 Guidelines, Lesson: Making Academic

For this Discussion Board, you are supposed to read the Essay#2 Guidelines, Lesson: Making Academic Arguments, . and Lesson: Thesis Statement. For this discussion board, you need to do two things: 1) Find two articles from Opposing Viewpoints-Gale (Dallas College Database) that present two different viewpoints on the topic selected

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Organization Design and Development (MGT 404) Due Date: 05/10/2024 @ 23:59 Course Name: Organization Design and Development Course Code: MGT404 Student’s Name: Semester:

The choice of an appropriate input device for a product is often based on both the type of device being used and the target market for that device. For

The choice of an appropriate input device for a product is often based on both the type of device being used and the target market for that device. For instance, a device targeted to college students and one targeted to older individuals may use different input methods. Suppose that you

What are the pros and cons of the current highway funding structure as related the taxes paid by motor carriers? How do you think sustainability efforts

What are the pros and cons of the current highway funding structure as related the taxes paid by motor carriers? How do you think sustainability efforts by Walmart will impact the larger logistics industry?

1 2 Literature Review Begin by describing which databases you searched, search terms you used related to your topic,

1 2 Literature Review Begin by describing which databases you searched, search terms you used related to your topic, how you narrowed your search, how you selected those references you will discuss in this section. Summary of Article This section should discuss at least 10 articles/peer reviews on the topic

I need answer to use the STAR approaches: Situation Task Action & Result

One part of research is to assess your sources for diverse perspectives, which helps to create a robust argument. In this discussion, you will

One part of research is to assess your sources for diverse perspectives, which helps to create a robust argument. In this discussion, you will discuss how two of your sources help you understand your topic by portraying diverse perspectives. Discussing challenges that face our world often means investigating opinions and

Description This Key Assignment (KA) template will be the basis for a Security Management Document. Although an actual plan is not feasible, each week will

Description This Key Assignment (KA) template will be the basis for a Security Management Document. Although an actual plan is not feasible, each week will constitute portions of an overall Security Management Document that could be implemented. Throughout this course, you will be working with a scenario in which some

their organizational priorities and mission(s) areas

In your first assessment, you assessed risks and areas of need for a potential crisis situation and community you chose to

In your first assessment, you assessed risks and areas of need for a potential crisis situation and community you chose to focus on. In this assessment, you’ll develop a disaster management plan for actually addressing the risks you identified earlier, and you’ll do it in the form of a presentation.

Compare the current provisions in the ACA with those in the failed first version of the AHCA

In Unit 2, you explored the experiences of the earliest settlers. For this assignment, you are asked to imagine yourself as one of these people.

In Unit 2, you explored the experiences of the earliest settlers. For this assignment, you are asked to imagine yourself as one of these people. Write a narrative of two or more paragraphs that includes: · Why did you travel to a new land inhabited by native people you did

Please see he attached documents You will post one thread that is between 300 and 350 words. you must incorporate relevant ideas from at least two

Please see he attached documents You will post one thread that is between 300 and 350 words. you must incorporate relevant ideas from at least two of the required course texts in the thread. Must be APA format. Through the course materials, you have learned about how to effectively lead

Our Services

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

Share This Post

Related Questions

Use Our 6 Free Tools