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

COM 2301-21.02.01-5B24-S1, Professional CommunicationUnit VII AssignmentUnit VII AssignmentAssignment Content For this assignment, you are an employee who

COM 2301-21.02.01-5B24-S1, Professional CommunicationUnit VII AssignmentUnit VII AssignmentAssignment Content For this assignment, you are an employee who is experiencing a global workplace issue. This issue may be a current issue you are facing, a past issue, or a hypothetical issue. Design a plan to resolve this global workplace issue. In

For your final paper, I’d like you to demonstrate to me what you’ve learned this semester about strategic communication, using your thoughts on an

For your final paper, I’d like you to demonstrate to me what you’ve learned this semester about strategic communication, using your thoughts on an organization that currently is undergoing an organizational change or instability Choose one of the following issues currently found in the news (see four options below). You

No more than 7 pages -Reference page APA format Social workers understand how racism and oppression shape human experiences and how these 2 constructs

No more than 7 pages -Reference page APA format Social workers understand how racism and oppression shape human experiences and how these 2 constructs influence practice at the individual, family, group, organizational, and community levels and in policy and research. Furthermore, social workers understand the historical roots of social and

Locate an article in the CSU Online Library that focuses on managing conflict in an organization through communication. For this assignment, you will need

Locate an article in the CSU Online Library that focuses on managing conflict in an organization through communication. For this assignment, you will need to accurately identify the article’s premise, significant points in support of the premise, and the significance of those points to the course and/or the field. You

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ 1. Performance outcomes Candidates analyze their teaching at the end of clinical

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ 1. Performance outcomes Candidates analyze their teaching at the end of clinical practice to reflect on their personal and professional growth since they began clinical practice What will you do? Write or record a reflection of 300-500 words

what is the received power in dbm for a free space signal, whose transmit power is 1w and carrier frequency is 2.4ghz. if the receiver is at a distance of

what is the received power in dbm for a free space signal, whose transmit power is 1w and carrier frequency is 2.4ghz. if the receiver is at a distance of 1 mile (1.6 km) from the transmitter. what is the path loss in db?

You will prepare an analysis (7-8 pages of content) that describes the crisis, describes the organization or individual’s response to it, analyzes the

You will prepare an analysis (7-8 pages of content) that describes the crisis, describes the organization or individual’s response to it, analyzes the response using course concepts/theories, evaluates the response, and offers suggestions for how the organization could have done better where appropriate. Your paper MUST include at least. seven

BUS 2303-19.01.02-5B24-S3, Professionalism in the Workplace Discussion Topic Please note that there are two posts needed to successfully complete the

BUS 2303-19.01.02-5B24-S3, Professionalism in the Workplace Discussion Topic Please note that there are two posts needed to successfully complete the discussion board assignment. An initial post addressing the discussion board topic is due by end of day Saturday. A response post to at least one other student is due by

BUS 2303-19.01.02-5B24-S3, Professionalism in the Workplace **Unit IV Journal Assignment Content The purpose of this journal is for you to define and

BUS 2303-19.01.02-5B24-S3, Professionalism in the Workplace **Unit IV Journal Assignment Content The purpose of this journal is for you to define and explain what constitutes quality in a product or service, including internal and external customer service you have either been provided or provided to others. When shopping for goods

Unit III AssignmentAssignment Content For this two-part assignment, you will review and analyze a conversation as well as discuss your own communication

Unit III AssignmentAssignment Content For this two-part assignment, you will review and analyze a conversation as well as discuss your own communication noisemakers and barriers and how they can be overcome. Instructions: Part I: Read A Heated Conversation Scenario. A PDF version of A Heated Conversation Scenario is also provided. Identify one noisemaker

Requirements- no AI/ChatGpt, no plagiarism Part 1 – 5 pages required Abstract & Guiding Research Question Include your research question. – “What are some

Requirements- no AI/ChatGpt, no plagiarism Part 1 – 5 pages required Abstract & Guiding Research Question Include your research question. – “What are some ways to use dance therapy’s positive effects to help people of all ages, abilities, and backgrounds overcome social barriers and achieve general well-being?” Include a concise abstract

After watching the video from the University of California, what have you learned about how you can better communicate with non-English speakers in your

After watching the video from the University of California, what have you learned about how you can better communicate with non-English speakers in your career? After watching the video from Cardiff University, what techniques have you learned regarding how to better communicate with someone suffering from Dementia?

Cultures in Conflict – Week #1 Assignment Culture Assignment Please answer the following questions: Firstly, choose a culture different from the one you

Cultures in Conflict – Week #1 Assignment Culture Assignment Please answer the following questions: Firstly, choose a culture different from the one you identify with. Examples are: Hispanic, Asian, American, Middle Eastern, Mexican, Irish, Country Music culture, Cross-Fit culture, etc….. · Identify the culture and explain how you became familiar with it.

· NORTH AFRICAN (Algeria, Egypt, Libya, Mauritania, Morocco, Sudan, Tunisia, & Western Sahara) RESEARCH THE GEO-CULTURE You are expected to be

· NORTH AFRICAN (Algeria, Egypt, Libya, Mauritania, Morocco, Sudan, Tunisia, & Western Sahara) RESEARCH THE GEO-CULTURE You are expected to be well-versed with regard to the geo-culture you chose to investigate. This means that you can provide, in YOUR OWN WORDS, a comprehensive summary of cultural elements (literature, performing arts,

The Final Presentation in PowerPoint represents 30% of your grade and should be the culmination of all the critical thinking, information literacy, and

The Final Presentation in PowerPoint represents 30% of your grade and should be the culmination of all the critical thinking, information literacy, and presentation work that you have mastered throughout the course. The first part of the process is researching and choosing the topic that you plan to present upon.

You have been asked to evaluate Company A and Company B and make your recommendation for acquiring one or both companies. Based on your initial assessment,

You have been asked to evaluate Company A and Company B and make your recommendation for acquiring one or both companies. Based on your initial assessment, you have created balanced scorecards for both companies. You are now ready to analyze the information you have gathered so far about the two

After watching this video and reading the textbook, what is your conclusion on the prevalence of false memories and incorrect eyewitness accounts?

video 1 Question: After watching the video from Neal Gittleman (Dayton Philharmonic Conductor), what have you learned about what simple silence

video 1 Question: After watching the video from Neal Gittleman (Dayton Philharmonic Conductor), what have you learned about what simple silence communicates to others? Video 2 Question: After watching the video, explain what steps were taken by the school administration to assist this child and his family better understand.