Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

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 sta

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:

  1. 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
  2. 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.
  3. 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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Infographics are a vital tool in business communication, offering a visually engaging way to convey information succinctly and impactfully. In this assignment, you will create an infographic that outl

Infographics are a vital tool in business communication, offering a visually engaging way to convey information succinctly and impactfully. In this assignment, you will create an infographic that outlines the strengths and weaknesses of a business of your choice. The infographic narrative should be logical, guiding the viewer through the

Review the Ameriprise Financials’ Tom Endersbe, in chapter 4 of your text to complete the following activity. Instructions For each of the following statements, respond in 1—2 paragraphs: Describe how

Review the Ameriprise Financials’ Tom Endersbe, in chapter 4 of your text to complete the following activity. Instructions For each of the following statements, respond in 1—2 paragraphs: Describe how Ameriprise Financials’ Tom Endersbe, in chapter 4, employed framing to strengthen advisor-client relationships during economic turmoil. Explain the relevance of utilizing

Locate an article in the CSU Online Library that focuses on managing conflict in an organization through communication. For this assignment, you will need to accurately identify the article’s premis

Locate an article in the CSU Online Library that focuses on managing conflict in an organization through communication. For this assignment, you will need to accurately identify the article’s premise, significant points in support of the premise, and the significance of those points to the course and/or the field. You

This assignment aims to equip you with the necessary skills and strategies to excel in virtual meetings, a crucial aspect of modern business communication. You will analyze the obstacles faced in virt

This assignment aims to equip you with the necessary skills and strategies to excel in virtual meetings, a crucial aspect of modern business communication. You will analyze the obstacles faced in virtual communication, develop techniques for active participation, and present your findings through a professionally written report. InstructionsResearch and Analysis

Writing Requirements (APA Format) Must use the integrated template Length: Minimum 1–2 pages (not including title page or references page; no maximum page count) 1-inch margins Double spaced 12-point

Writing Requirements (APA Format) Must use the integrated template Length: Minimum 1–2 pages (not including title page or references page; no maximum page count) 1-inch margins Double spaced 12-point Times New Roman font Title page References page *INSTRUCTIONS AND RUBRIC PROVIDED AS WELL AS SOURCES***

Paper topic: communication Writing Requirements (APA Format) The integrated template must be used. Length: Minimum 1–2 pages 1-inch margins Double spaced 12-point Times New Roman font Minimum of 1

Paper topic:  communication Writing Requirements (APA Format) The integrated template must be used. Length: Minimum 1–2 pages 1-inch margins Double spaced 12-point Times New Roman font Minimum of 1 outside source (in addition to the textbook/lesson) Title page References page (lesson/textbook citation and outside source citation in APA format) **INSTRUCTIONS

For this assignment, you will research the different ways that managers and leaders use communication to guide their organizations. Find an instance where the organizational leader communicates direct

For this assignment, you will research the different ways that managers and leaders use communication to guide their organizations. Find an instance where the organizational leader communicates directly with his or her employees, investors, or customers. Analyze the message, the channel, and the potential for feedback. Do you believe that

This is the continuation of the project Create a presentation (CO8) that builds upon the Week 3 Project Plan and the Week 5 Location and Access (Source Organization worksheet) that effectively communi

This is the continuation of the project Create a presentation (CO8) that builds upon the Week 3 Project Plan and the Week 5 Location and Access (Source Organization worksheet) that effectively communicates the knowledge you have gained during COMM120. Presentation will include an introduction, body, conclusion, and properly formatted reference/work cited slide in the

Goal: The goal of this assignment is to research your topic, evaluate selected sources, and organize your sources. Description: During the Week 3 Assignment, Project Plan, you chose a topic and creat

Goal: The goal of this assignment is to research your topic, evaluate selected sources, and organize your sources. Description: During the Week 3 Assignment, Project Plan, you chose a topic and created your project plan. In the Week 3 Lesson, you read about location and access and in Week 4, you learned

Individually: Complete and upload submission to this Dropbox.List your name and name of the program/link to the video.Read the attached evaluation rubric.Instructions: This exercise is going to be a n

Individually: Complete and upload submission to this Dropbox. List your name and name of the program/link to the video. Read the attached evaluation rubric. Instructions: This exercise is going to be a nonverbal analysis of a conversation. You will choose a short clip from your favorite TV show in where

Mock Speech Write-up: Pretend you’re a well-paid speechwriter. You will write a 3-5 minute persuasive public address speech focusing on a current issue in society. You will not give the speech; you wi

Mock Speech Write-up: Pretend you’re a well-paid speechwriter. You will write a 3-5 minute persuasive public address speech focusing on a current issue in society. You will not give the speech; you will just be writing what you would say for someone else delivering it. You will write the speech  as if you expect

Instructions For this assignment, you will write a 1-2 page single spaced report. Your report will describe an event, expo or location you have recently visited that someway pertains to your work, stu

InstructionsFor this assignment, you will write a 1-2 page single spaced report. Your report will describe anevent, expo or location you have recently visited that someway pertains to your work, studies, orinterests, and should be based on a recent first-hand experience (See the trip ideas sheet locatedat the end of

Submit the provided blank form as a fully completed Word document, uploaded to its assignment tab before the deadline. Assignment: Write at least 600 words, but no more than 1,200 words in addressing

Submit the provided blank form as a fully completed Word document, uploaded to its assignment tabbefore the deadline.Assignment: Write at least 600 words, but no more than 1,200 words in addressing the following.WATCH YOUR VIDEO OF YOUR SPEECH and evaluate your performance, in full and completesentences (as in not bullet