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,
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.
Step by Step Solution
3.26 Rating (170 Votes )
There are 3 Steps involved in it
1 What SUP Inc Income Statement For the Year Ended 123118 123119 of Sales Change Sales Revenue 85000000 95000000 100 12 Less Cost of Goods Sold 44500000 50000000 53 12 Gross Margin 40500000 45000000 4... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (3 attachments)
1512_605d88e144c0b_679835.pdf
180 KBs PDF File
1512_604b6a4c0364b_679835.xlsx
300 KBs Excel File
1512_605d88e144c0b_679835.docx
120 KBs Word File
Study Help