Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[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

Order Now

Related Questions

This assignment addresses the following unit learning outcomes: Discuss the three reasons for listening.Identify the guidelines for effective listening.Examine ways to improve listening competence in

This assignment addresses the following unit learning outcomes: Discuss the three reasons for listening. Identify the guidelines for effective listening. Examine ways to improve listening competence in any context. It also addresses the following course outcome: CM206-3: Explain the relationship between listening and interpersonal communication. For this assignment, you will write

Introduction Thinking critically is important for everyone and underlies a broad range of activities. Thinking both rationally and abstractly touches virtually all aspects of human life. Critical thin

Introduction Thinking critically is important for everyone and underlies a broad range of activities. Thinking both rationally and abstractly touches virtually all aspects of human life. Critical thinking involves analyzing arguments and identifying fallacies and biases. In this task, you will choose a case study and use critical thinking skills

Introduction Thinking critically is important for everyone and underlies a broad range of activities. Thinking both rationally and abstractly touches virtually all aspects of human life. Critical thin

Introduction Thinking critically is important for everyone and underlies a broad range of activities. Thinking both rationally and abstractly touches virtually all aspects of human life. Critical thinking involves analyzing arguments and identifying fallacies and biases. In this task, you will choose a case study and use critical thinking skills

Composition: Writing with a Strategy — D269 RGM3 SUBMIT IN DIFFERENT DOCUMENTS TASK 1 Introduction Effective writers know how to tailor their text for a specific purpose and a specific audience. For e

Composition: Writing with a Strategy — D269 RGM3 SUBMIT IN DIFFERENT DOCUMENTS TASK 1 Introduction Effective writers know how to tailor their text for a specific purpose and a specific audience. For example, writers can choose to make an emotional appeal using simple language so that any audience can understand

UXM3 Task 2: Professional Communication and Problem-Solving Introduction During your academic career and beyond, you will need to apply strategies that will help you accomplish your goals and advance

UXM3 Task 2: Professional Communication and Problem-Solving Introduction During your academic career and beyond, you will need to apply strategies that will help you accomplish your goals and advance lifelong learning.You will encounter some problems or questions that will require you to identify sources of information and find solutions. You

Explain the principles of verbal communication.Examine the influence of verbal communication on interpersonal communication.Discuss verbal and nonverbal communication.Explain the principles of nonverb

Explain the principles of verbal communication. Examine the influence of verbal communication on interpersonal communication. Discuss verbal and nonverbal communication. Explain the principles of nonverbal communication. Examine the influence of nonverbal communication on interpersonal communication. It also addresses the following course outcome: CM206-2: Identify the roles of symbolic cues in interpersonal

MAKE CORRECTIONS TO THE ATTACHED PAPERS. CORRECTIONS TO BE DONE ARE BELOW. 1) PROFESSIONAL COMMUNICATION AND PROBLEM SOLVING The submission includes three sources and citations. However, the self-dire

MAKE CORRECTIONS TO THE ATTACHED PAPERS. CORRECTIONS TO BE DONE ARE BELOW. 1) PROFESSIONAL COMMUNICATION AND PROBLEM SOLVING The submission includes three sources and citations. However, the self-directed learning strategies described in Aspects B1-B3 do not have supporting sources in the reference list, as this information is not found in

Your employer has asked you to mentor a new employee. To help you prepare, your employer has asked you to reflect on the questions below. Using the Unit 2 Assignment Template, respond to the following

Your employer has asked you to mentor a new employee. To help you prepare, your employer has asked you to reflect on the questions below. Using the Unit 2 Assignment Template, respond to the following (one to two paragraphs each, drawing on course concepts): Select three principles of interpersonal communication that

TASK 1 Introduction Understanding your message’s audience and considering how to adapt your message is key to successful interactions. In this task, you will: 1. Write two emails introducing yourself

TASK 1 Introduction Understanding your message’s audience and considering how to adapt your message is key to successful interactions. In this task, you will: 1.  Write two emails introducing yourself in a professional workplace setting to two different characters from the scenario below. 2.  Demonstrate in a written analysis how each introductory

InstructionsAlternative Research Assignment: Writing Assignment on Peer Reviewed Article. Guidelines for paper. This assignment is submitted in two parts. Both parts are submitted directly to your

InstructionsAlternative Research Assignment: Writing Assignment on Peer Reviewed Article.  Guidelines for paper. This assignment is submitted in two parts. Both parts are submitted directly to your instructor. Each part is equivalent to two hours of research credit (25 points for each part, in order to achieve a total of 50

Alternative Research Assignment: Writing Assignment on Peer Reviewed Article. Guidelines for paper. This assignment is submitted in two parts. Both parts are submitted directly to your instructor.

Alternative Research Assignment: Writing Assignment on Peer Reviewed Article.  Guidelines for paper. This assignment is submitted in two parts. Both parts are submitted directly to your instructor. Each part is equivalent to two hours of research credit (25 points for each part, in order to achieve a total of 50

I need a 5–7 minute speech essay for my Corporals Course presentation. The topic is “Time Management in the Life of a Marine.” The essay should include an introduction, body, and conclusion in MLA for

I need a 5–7 minute speech essay for my Corporals Course presentation. The topic is “Time Management in the Life of a Marine.” The essay should include an introduction, body, and conclusion in MLA format and reflect personal and Marine Corps-related experiences. Main points to include: Not all Marines have

I need help completing the bolded and underlined portion of this assignment. 2. Organize Previous Academic Coursework (already completed can provide info once tutor has been assigned) Using your un

I need help completing the bolded and underlined portion of this assignment. 2.  Organize Previous Academic Coursework (already completed can provide info once tutor has been assigned) Using your unofficial transcript, organize the coursework you have taken at the 2000-, 3000-, or 4000-level into their appropriate academic disciplines based on

LDR 4303-22.01.01-6A25-S1, Team Building and Leadership Unit III Assignment You have been recently promoted to lead a new division of Company XYZ. This company is known for its team-oriented atmospher

LDR 4303-22.01.01-6A25-S1, Team Building and Leadership Unit III Assignment You have been recently promoted to lead a new division of Company XYZ. This company is known for its team-oriented atmosphere, and your boss has raved about some of your natural leadership qualities. Your first task is to assemble the best