Our Services

Get 15% Discount on your First Order

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

April 1, 2024

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. Consult the Shapiro Library APA Style Guide for more information on citations.

Communications

Share This Post

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

Related Questions

250 words Oftentimes you will see children with mental health

250 words Oftentimes you will see children with mental health disorders having difficulty in home, public places, and schools. They can be labeled as “difficult” or “out of control” and their behaviors often present challenges to parents, caretakers, and teachers. The ability to support these children and their families is

Data analytics plays an important role in marketing management. There

Data analytics plays an important role in marketing management. There are many types of data to be gathered and studied. Structured data are quantitative data that can be stored in a fixed format such as a spreadsheet or list. These data can be easily processed by computers. Examples of

GENERALIST PRACTICE 1 I need each question in this assignment

GENERALIST PRACTICE 1 I need each question in this assignment answered in 200 words Lesson 3 Discussion: Minimum of 200 words. Please review the document: Working with Involuntary and Mandated Clients. This provides some helpful considerations for engaging involuntary or mandated clients. There is also a brief review of Motivational

Software platform that integrates a wide range of media devices

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.

Part 1 Issue area: This is where you tell the

Part 1 Issue area: This is where you tell the reader the issue area in need of attention in regards to global governance. Why have you chosen this issue over others? How will focusing on such an area improve global governance effectiveness? Part 2 Analysis: You will provide your thorough

Choose and analyze a current event article that has legal

Instructions To complete this assignment, you will need the attached

Instructions To complete this assignment, you will need the attached files and the the Small Merchant Guide to Safe Payments documentation (click link to download) from the Payment Card Industry Data Security Standards (PCI DSS) organization. Please read the instructions carefully and ask questions if anything is unclear. You must use

For this week’s assignment, reflect on the many roles (macro

For this week’s assignment, reflect on the many roles (macro and micro) that social workers can have within behavioral health. Assume you have been asked to prepare an educational brochure to help those you may engage with from other disciplines understand the roles social workers can have when working

Purpose This week’s graded discussion topic relates to the following Course Outcome (CO). CO 6: Develop a personal awareness of complex organizational systems, and integrate values and beliefs with or Nursing Assignment Help

Purpose This week’s graded discussion topic relates to the following Course Outcome (CO). CO 6: Develop a personal awareness of complex organizational systems, and integrate values and beliefs with or

Diary sections are utilized to record the monetary action of

Diary sections are utilized to record the monetary action of your business. Diary passages are either kept in auxiliary records in the event that you’re keeping your books physically, or they’re recorded straightforwardly into the overall record (G/L) assuming you use bookkeeping programming. Whichever way they’re recorded, they are

Assignment Content Competency Analyze how human resource standards and practices

CompetencyAnalyze how human resource standards and practices within the healthcare field support organizational mission, visions, and values. Student Success CriteriaView the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane. ScenarioWynn Regional Medical Center

As a current or future leader, it is important for

As a current or future leader, it is important for you to understand how various leadership styles impact organizational culture, employees, and stakeholders. For your Week 1 assignment, you will create a PowerPoint presentation critiquing four leadership styles. Begin by familiarizing yourself with each of the eight theories listed

Please choose organizational I-O psychology, link is down below I-O

Please choose organizational I-O psychology, link is down below I-O Application Discussion You have been introduced to I-O Psychology, a fascinating and highly applicable subfield of psychology. Given the recent adjustments that we’ve all had to make to our school and/or workplace because of the COVID-19 pandemic, it is expected

ssessment Description Describe one internal and one external method for

ssessment Description Describe one internal and one external method for the dissemination of your evidence-based change proposal. For example, an internal method may be the hospital board, and an external method may be a professional nursing organization. Discuss why it is important to report your change proposal to both of

Deliverable Length: 5-7 slides with speaker notes Recently, Green Branch

Deliverable Length: 5-7 slides with speaker notes Recently, Green Branch Coffee mangers have approached you with questions regarding the Americans with Disabilities Act (ADA), the Age Discrimination in Employment Act (ADEA), the Equal Pay Act (EPA), and the Fair Labor Standards Act (FLSA). To address these questions, you have decided

A. Summary of the Case In one or two paragraphs,

A. Summary of the CaseIn one or two paragraphs, provide a general overview of the case that serves as a snapshot of what the case is about and how it ended up in your state high court. A summary is using your words to write a brief history of the

Management Accounting LSBM107: Determine the profit per unit of each

You have been employed as a consultant for Fitzgerald Ltd. Your brief is to review the current management accounting systems operating within Fitzgerald Limited, with particular reference to the treatment of production overheads and the profitability of their main products. Fitzgerald Ltd is a manufacturing company that produces three main

HS-Case 2 Nursing Assignment Help

Note: I need complete 2-3 pages paper on the following assignment. HALF PAGE LENGTH IS NOT ACCEPTED. Must address the all steps properly. Must include 3 credible references cited in APA. Must provide 100% original work. DO NOT PROVIDE THE PREVIOUSLY USED WORK. DO NOT WRITE QUESTIONS IN ANSWER! Assignment This is a three-part assignment related to a study of contraceptive drug use