To measure the financial performance of any company, it is important to analyze its four key financial statements: balance sheets, income statements, cash

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

For this assessment you will conduct two kitchen science experiments

For this assessment you will conduct two kitchen science experiments that each focus on energy processes in living organisms. You will complete the experiments separately but then discuss how the two processes are related. Part 1: Photosynthesis. Use the Photosynthesis lab procedure to conduct your experiment. Your results (table, graph,

Directions Choose one of the protections of the Sixth Amendment

Directions Choose one of the protections of the Sixth Amendment and discuss how it is being affected during a global pandemic. Can and should these protections be expected to apply during a global pandemic? Be sure to provide real-life examples in your answer. Make sure you include citations and references.

You have just been promoted to a management position at

You have just been promoted to a management position at a multinational company. Most of the leaders of the company are from the baby-boomer generation, which is known for closely adhering to a hierarchical, top-down leadership model. They have been with the company for an average of 18 years. You

Vaccinations are important for all ages.

in regards to nursing. regarding groups include: ethnic, religious, racial, tribal minorities, immigrants, refugees and internally displaced people, prisoners, persons with mental illnesses, physical impairments and older persons. Write a 2-3 page paper, excluding the abstract Describe a specific situation where you were involved or observed  health care inequalities for one the vulnerable populations identified on page

** RESEARCH PAPER**  please address the following in a properly formatted

** RESEARCH PAPER**  please address the following in a properly formatted research paper: 1. Do you think that ISO 27001 standard would work well in the organization that you currently or previously have worked for? If you are currently using ISO 27001 as an ISMS framework, analyze its effectiveness as

Please write an analytical essay

Please write an analytical essay based on ONE of the following prompts. Length: 4-5 pages double-spaced. Remember that the following are only “prompts” meant to get you started on thinking about your essay. Do not think of these as questions you must answer. Once you have selected a topic based on a prompt,

Throughout this course, you have had the opportunity to understand

Throughout this course, you have had the opportunity to understand the important role human resources has as a strategic business partner and to reflect on the role of HR within your respective organizations.  For this presentation, you will be capturing the key findings learned in this course, including making recommendations

To define a dissertation paper in textual terms and put

To define a dissertation paper in textual terms and put it from an academic perspective, we can say that a https://www.bestcustomwriting.com/personal-statement-help proposal is merely an academic paper that provides the readers a brief overview of the content included in the entire research paper and the methodologies used to arrive upon

Case titled “HOW GIVING FACE CAN BREW SUCCESS” (Rob March)

Case titled “HOW GIVING FACE CAN BREW SUCCESS” (Rob March) page 2   Read the case and write a report for a client who is preparing to negotiate in China. The report needs to address ALL the following questions and include recommendations.:   “Before tendering began, we were working with

The Contribution of Classical Theorists to Contemporary Developmental Theorists While all major developmental theories attempt to explain the growth of

The Contribution of Classical Theorists to Contemporary Developmental TheoristsWhile all major developmental theories attempt to explain the growth of individuals, each theory has a slightly different perspective. Some theories emphasize environmental (nurture) more than biological (nature) influences. Some theories focus on a particular construct (e.g., cognition), while others emphasize the

1-)Corporate F (adegboyego) Mergers and acquisitions are often referred to

1-)Corporate F (adegboyego) Mergers and acquisitions are often referred to as the market for corporate control. When a firm acquires a target firm, the acquiring firm takeover control of the corporation being sold. There are several types of mergers which include the horizontal merger whereby a corporation acquires another that

 Psychological disorders, such as depression, bipolar, and anxiety

 Psychological disorders, such as depression, bipolar, and anxiety disorders can present several complications for patients of all ages. These disorders affect patients physically and emotionally, potentially impacting judgment, school and/or job performance, and relationships with family and friends. Since these disorders have many drastic effects on patients’ lives, it is

https://www.indiatoday.in/world/story/explained-privilege-visas-demand-pandemic-1813814-2021-06-11 Discussion Posts: You are required to post items to

https://www.indiatoday.in/world/story/explained-privilege-visas-demand-pandemic-1813814-2021-06-11   Discussion Posts: You are required to post items to the course online discussion forum (see syllabus for how they will be graded) that add value to the topic that is covered that week linking theory to real world examples. Find & Post (or post a link to) a concept of International Business

Mobile Device Attacks – Premium Paper Help

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.

An equity research report can include varying levels of detail,

     An equity research report can include varying levels of detail, and while there is no industry standard when it comes to format, there are common elements to all thorough and effective equity research reports. Highlighted below are some fundamental features and information that should be considered essential to every