1. Create a Financial Analysis for What SUP, Inc. as of December 31, 2019. You are to...

Question:

1. Create a Financial Analysis for What SUP, Inc. as of December 31, 2019.
You are to create this financial analysis as of December 31, 2019, from the information found on file ch3-02.xls. This file contains three work-sheets, which are labeled Income Statement, Balance Sheet, and Ratios. Following the Chapter 3 examples, create a vertical analysis of both the income statement and balance sheet for December 31, 2019, only. Then create a horizontal analysis of both the income statement and balance sheet. The horizontal analysis will compare December 31, 2018, with December 31, 2019. In addition, create a pie chart of expenses for the year ended December 31, 2019; a column chart (in a format of your choice) of expenses for the years ended December 31, 2018, and 2019; and a ratio analysis as of December 31, 2019. Save the file as ch3-02_student_name.xls (replacing student_name with your name). Print each completed worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer.

2 Create a Financial Analysis for What SUP, Inc. as of December 31, 2020.
You are to create What SUP’s financial analysis as of December 31, 2020, from the information found on file ch3-03.xls. This file contains three worksheets, which are labeled Income Statement, Balance Sheet, and Ratios. Following the Chapter 3 examples, create a vertical analysis of both the income statement and balance sheet for December 31, 2020, only. Then create a horizontal analysis of both the income statement and balancesheet. The horizontal analysis will compare December 31, 2019, with December 31, 2020.) In addition, create a pie chart of expenses for the year ended December 31, 2020; a column chart (in a format of your choice) of expenses for the years ended December 31, 2019, and 2020; and a ratio analysis as of December 31, 2020. Save the file as ch3-03_student_name.xls (replacing student_name with your name).
Print each completed worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer.

Balance Sheet
Balance sheet is a statement of the financial position of a business that list all the assets, liabilities, and owner’s equity and shareholder’s equity at a particular point of time. A balance sheet is also called as a “statement of financial...