Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

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

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

Order Now

Related Questions

***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 3 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED******

***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 3 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** PART 1- Module 5- DISCUSSION 5 Food & Beverage Management After studying Module 5: Lecture Materials & Resources,

Instructions: Review the AHIMA Code of Ethics found on pages 1030 through 1034 in Health Information Management: Concepts, Principles, and Practice. Apply your understanding of professional ethics and

Instructions: Review the AHIMA Code of Ethics found on pages 1030 through 1034 in Health Information Management: Concepts, Principles, and Practice. Apply your understanding of professional ethics and the appropriate professional code of conduct using the seven-step ethical decision-making matrix to the five scenarios provided. The ethical decision-making matrix can be

HRM 3302-22.02.00-5A25-S1, Human Resource Management Unit III Scholarly Activity Part 1: You are voluntarily leaving your position. (This can be a position you currently have, one you have had in

HRM 3302-22.02.00-5A25-S1, Human Resource Management Unit III Scholarly Activity  Part 1: You are voluntarily leaving your position. (This can be a position you currently have, one you have had in the past, or one that you would like to have.) Your supervisor has asked you to create recommendations the organization

SHEILA- UP TO 4/3/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 3 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES

SHEILA- UP TO 4/3/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 3 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** PART 1- Module 3- DISCUSSION 3 Resort Planning After studying Module 3: Lecture Materials

VAL- UP TO 3/27/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WH

VAL- UP TO 3/27/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** PART 1- Module 2- DISCUSSION- (VAL)- Corporate Strategy A Corporate Strategy is the

Overview: For this assignment, you will research careers more thoroughly based on the O*Net Interest Profiler results. https://www.mynextmove.org/explore/ip Instructions: First, find the O*NET link

Overview:  For this assignment, you will research careers more thoroughly based on the O*Net Interest Profiler results.  https://www.mynextmove.org/explore/ip Instructions:  First, find the O*NET link in the Readings and Resources and take the O*NET Interest Profiler Self-Assessment to generate two (2) career options most relevant to yourself.  Next, research each of

This journal entry measures your mastery of ULOs 2.14. Journal: Course Reflection In this course you have developed the communication and management skills essential for successfully resolving conf

This journal entry measures your mastery of ULOs 2.14. Journal: Course Reflection In this course you have developed the communication and management skills essential for successfully resolving conflict situations in labor and management practices. Part 1: Describe the three most important insights you gained from the course. Part 2: Share

Explain the importance of teamwork in an organization. In your explanation, address the two types of self-directed work teams and the three generic team types and how an organization’s context of cult

Explain the importance of teamwork in an organization. In your explanation, address the two types of self-directed work teams and the three generic team types and how an organization’s context of culture, structure, and systems supports teamwork. Your response should be at least 250 words in length.

VAL- UP TO 3/6/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 3PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN

VAL- UP TO 3/6/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 3PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** PART 1- Module 4- DISCUSSION- (VAL)- Bankruptcy Why do businesses file for bankruptcy and

SHEILA- UP TO 3/6/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES

SHEILA- UP TO 3/6/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** PART 1- Module 4- DISCUSSION 4 What barriers of effective communication do you

ORGB 327: Assignment 2 Due: After completion of Lesson 7 Credit Weight: 25% of your final grade Summary: Case study essay (1000–1200 words; word-processed and double-spaced) __________________________

ORGB 327: Assignment 2 Due: After completion of Lesson 7 Credit Weight: 25% of your final grade Summary: Case study essay (1000–1200 words; word-processed and double-spaced) _________________________________________________________________________ Case Study: Reed Hastings — Netflix Adapted from Lussier, R. N., & Achua, C. F. (2016). Leadership: Theory, application, and skill development (6th

Negotiation Flow Chart This flow chart assignment measures your mastery of ULOs 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 2.10, 2.11, 3.1, 3.2, 3.3, 4.1, 4.2, and 4.3. Requirem

Negotiation Flow Chart This flow chart assignment measures your mastery of ULOs 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 2.10, 2.11, 3.1, 3.2, 3.3, 4.1, 4.2, and 4.3. Requirement: Develop a flow chart for a selected negotiation that has either succeeded or failed (business, international,

Explain the importance of teamwork in an organization. In your explanation, address the two types of self-directed work teams and the three generic team types and how an organization’s context of cult

Explain the importance of teamwork in an organization. In your explanation, address the two types of self-directed work teams and the three generic team types and how an organization’s context of culture, structure, and systems supports teamwork. Your response should be at least 250 words in length.