Our Services

Get 15% Discount on your First Order

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

March 28, 2024

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:

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.

HR Management

Share This Post

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

Related Questions

For this assignment, students will reflect on and evaluate their teaching presentation to determine how to improve for next time. The Community Teaching

For this assignment, students will reflect on and evaluate their teaching presentation to determine how to improve for next time. The Community Teaching Project has indirect care experience requirements. The “Indirect Care Experience Hours” form, found in the Topic 1 Resources, will be used to document the indirect care experience

Read this student response attached with YOUR opinion but include

Read this student response attached with YOUR opinion but include a NARRATIVE CITATION TO reference and support your thoughts THE CITATION MUST BE A NARRATIVE CITATION TO RECIEVE CREDIT 150 WORDS MINIMUM NO MORE THAN 300 the professor is very specific ! your response must have a narrative citation

“What’s it like to be a victim of domestic violence”

As for your research proposal, I suggest following all of the steps outlined in the textbook (except for the Literature Review). Just make sure to make explain your ideas very clearly and simply. Don’t use words you don’t fully understand. Remember the acronym, “K.I.S.S.” (Keep It Simple Silly). Also, give

All parts of the outline should be complete in its

All parts of the outline should be complete in its entirety – introduction, body, conclusion and bibliography The bibliography should have at least 3 sources in APA format Use the blank out template for the rough draft outline The blank outline template, outline & APA directions, as well as student

Using company, DISNEY as reference, respond to the four writing

Using company, DISNEY as reference, respond to the four writing prompts below. Your responses must include information from academic and scholarly research, including at least four resources Create a case study summary of DISNEY, including a general overview of the company, its external environment, and a list of its current

Discussion: Professional Nursing and State-Level RegulationsBoards of Nursing (BONs) exist in all 50 states, the District of Columbia, American Samoa, Guam, the Northern Mariana Islands, and the Virgi Nursing Assignment Help

Discussion: Professional Nursing and State-Level RegulationsBoards of Nursing (BONs) exist in all 50 states, the District of Columbia, American Samoa, Guam, the Northern Mariana Islands, and the Virgin Islands. Similar entities may also exist for different regions. The mission of BONs is the protection of the public through the regulation

You recently created your imaginary e commerce company! Now in

You recently created your imaginary e commerce company! Now in this assignment you will include key technical elements for your hypothetical e-commerce company’s information systems infrastructure in a 5 page paper. – Write an overview of the document – Determine your e-commerce company’s major hardware and software from a size,

discussion Nursing Assignment Help

APA Managing financial risk is an important responsibility of medical managers. Risk management is an important process to keep the finances of all healthcare organizations safe. Discuss the following: 1. What are the financial risks to healthcare organizations? 2. What role do the accountants play in risk management? 3. Why is it important to hire

You may have seen how financial news media provides real-time

You may have seen how financial news media provides real-time financial market reporting. They often produce stock-market news feeds for traders. These news feeds include a stock chart. The stock chart may include different filters that allow you to see how the stock is performing today or has performed over

Uniform Crime Reports (UCR), National Incident-Based Reporting System (NIBRS), and

Uniform Crime Reports (UCR), National Incident-Based Reporting System (NIBRS), and Crime Data from Victims of Crime: The National Crime Victimization Survey (NCVS). Please answer the questions below: Define the terms UCR, NIBRS, and NCVS. What is the purpose of each? If you could pick only one measure of crime, which one would you choose?

Amendment Modification Project Instructions: For this assignment, you are being

Amendment Modification Project Instructions: For this assignment, you are being asked to either modify an existing amendment or to create a brand new amendment based on the academic research you complete. First, you will need to include your modified amendment or the original amendment. The modified amendment should consist of

you will complete an Afterschool Program Evaluation. Select a local

you will complete an Afterschool Program Evaluation. Select a local afterschool program: https://greenacresfl.gov/yp/page/cares and evaluate program based on the principles and practices presented in attached. The paper must address the following topics: Name of Afterschool Program Issues/Problems of Afterschool Program State Goal of Program Evaluation Type of Evaluation (Formative,

Traditional two-parent family

This class will be an exercise in exploring diversity in American families. Below is a list of various types of families within our culture. Students are asked to select one of the following family types: (I recommend choosing one that is different from your own.) o Traditional two-parent family o

In this module, you explore the importance of goal setting

In this module, you explore the importance of goal setting as an essential attribute of leadership. Effective leaders are skilled communicators, negotiators, and strategists who apply authentic approaches to achieve their social impact goals. Through their inspiration and motivation, leaders are social change agents who can allocate and optimize

Review the last-in, first-out (LIFO) and first-in, first-out (FIFO) inventory

Review the last-in, first-out (LIFO) and first-in, first-out (FIFO) inventory methods discussed in Ch. 6, “Reporting and Analyzing Inventory” of Accounting. Respond to the following in a minimum of 175 words: Explain LIFO and FIFO inventory methods. Provide 1 example of a business that uses LIFO and 1 example

Briefly describe how the risk management program at the organization

Briefly describe how the risk management program at the organization where you work (or at that of a typical health care organization) addresses social media and patient information privacy. Provide three examples of risk management steps your health care organization (or another health care organization) could take to further protect

HCM 500 SEU The United Kingdom Healthcare System Discussion Nursing Assignment Help

I’m working on a health & medical question and need the explanation and answer to help me learn. From your text readings regarding the United Kingdom, describe how the infrastructure of the United Kingdom’s healthcare sector, including rural and underserved populations is structured. How is access to healthcare developed and

The Benefits of Change Management

Instruction You are a project manager and believe that your initiative would be more successful if you had a change manager on your team. Develop an argument to your manager on the importance of change management. Describe the role of a change manager and how it will benefit the project.