MBA 620 Module Five Power BI Executive Summary Guidelines and RubricOverview To measure the financial performance of any company, it is important to

MBA 620 Module Five Power BI Executive Summary Guidelines and RubricOverview

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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Case Study, 1. June Frankel, a 23-year-old patient, presents to

Case Study,  1. June Frankel, a 23-year-old patient, presents to the emergency department with a sports-related fracture injury to her right arm and receives a long-arm fiberglass cast. (Learning Objective 2) What nursing assessment should the nurse provide after the cast has been applied? What nursing interventions should the nurse

Describe how and why the leader use of leadership theories

   Observe a leader whose role and leadership behaviors have changed over time because of external circumstances or growth by doing the following: Note: You may choose a leader from the literature, history, or personal experience. 1. Describe how and why the leader’s use of leadership theories (i.e., transactional and

Pick a product or service that you consume on a regular

Pick a product or service that you consume on a regular basis and speculate on what the elasticity of demand might be for that product. What might be the income elasticity of demand for that product? Explain and support why you think the product has the elasticity that it does based on how

Select a training topic, and develop a training needs analysis

Select a training topic, and develop a training needs analysis and learning objectives as part of your initial training and development program design. Introduction For this assessment, you will create the initial design of your training and development program for an organization of your choice, including the selection of a

Class, Welcome to Week 7! Chapter 9, “Technology,” discusses how

  Class, Welcome to Week 7! Chapter 9, “Technology,” discusses how technological advancements and changes may affect how we can work to find solutions for the global threats discussed so far. Technological advances can and do affect development in positive and negative ways. REQUIRED WEEK 7 CHECKLIST: Task A) Answer the following questions and cite your work: 1) Besides

Write a 1-page narrative in APA format that addresses the

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Topic: Establishing on-site day care or providing other child care

Topic:    Establishing on-site day care or providing other child care benefits  Please post a draft of your executive summary for your final report. Make sure that your executive summary draft follows the format and structure of the Victoria Business School executive summary. The purpose of this discussion topic is

Overview: For this task, you will complete the Module Four

 Overview: For this task, you will complete the Module Four worksheet detailing a SWOT analysis to determine the strengths, weaknesses, opportunities, and threats of a specific healthcare organization’s service or product. Focus on a specific product or service within one of the healthcare organizations you selected from the worksheet (the

The theory-practice gap in nursing

Please reply to this discussion with one reference.   The theory-practice gap in nursing is the idea that there is a distinct divide between our current knowledge base and the utilization of that knowledge into the discipline of nursing practice.  The struggle to close this nursing theory-practice gap stems from factors

Normative Decision Model

 ormative Decision Model Prompt: In Chapter 14, Figure 14.1 on pp. 553-554 (book) Leadership Enhancing Lesson of Experience Author: Richard & Robert Ginnett & Gordon Curphy Publisher : McGraw-Hill Higher Education ISBN: 9781259963261 is a graphic depicting Vroom and Yetton’s Leadership Decision Tree. Given the problem presented by your instructor,

Glomerulonephritis

Glomerulonephritis Case Studies A 7-year-old boy was brought to his pediatrician because he had developed hematuria, which required hospitalization. Approximately 6 weeks before his admission, he had a severe sore throat but received no treatment for it. Subsequently, he did well except for complaints of mild lethargy and decreased appetite.

This course has introduced you to information systems (IS). In

This course has introduced you to information systems (IS). In this task, you will identify the needs for a specific information system, select tools to identify and refine those needs, and go through the development stages and different management systems. You will also identify key contributors and their roles, the

Each student is to choose a topic, which includes identification

Each student is to choose a topic, which includes identification of a problem in a food service operation, with a detailed written solution to the problem. The student will need to think and brainstorm as a foodservice supervisor would. The student will have the opportunity to come up with its

   Assignment 2. The focus of the assignment is to evaluate the

   Assignment 2. The focus of the assignment is to evaluate the understanding level of students related to communities of Practice, learning organization, and various techniques used to capture tacit and explicit knowledge. Assignment Questions Besides consulting other materials, read chapter 4 and chapter 5 thoroughly and write detailed answer