Overview
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
Based on the attached 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.
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:
Company A: use the provided Company A set of three clustered column charts, representing:
The assets of Company A as represented in the data during each of the three years
The liabilities and owners’ equity over the same three years
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 BICompany B: use the provided Company B set of three clustered column charts, representing:
The assets of Company B as represented in the data during each of the three years
The liabilities and owners’ equity over the same three years
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 line charts 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:
Company A: use the provided Company A line chart illustrating the visual relationship of revenue, gross profit, total expenses, earnings before tax, net earnings, and taxes.
Company B: use the provided Company B 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 page Word document using double spacing, 12-point Times New Roman font, and one-inch margins. With sources cited according to APA7 style.