Excel for Accounting 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 balance sheet. (Note: 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. Chapter 3 Case Prohl AutoSave 0 8 ch3-03-Dalton Gasque - Saved Search File Home Insert Draw Page Layout Formulas Data Review View Help X Cut Book Antiqua 12 - A A Wrap Text Gene Copy Paste BIU A Merge & Center v $ - Format Painter Clipboard G Font G Alignment A1 fx What SUP, Inc. A B D E F G 123 4 5 6 Sales Revenue What SUP, Inc. Income Statement For the Year Ended 7 Less: Cost of Goods Sold 8 Gross Margin 9 Expenses: 10 11 Advertising Depreciation 12 Interest 13 Other 12/31/19 $950,000.00 $1,300,000.00 500,000.00 12/31/20 % of Sales % Change 800,000.00 450,000.00 500,000.00 30,000.00 45,000.00 25,000.00 28,000.00 50,000.00 22,000.00 15,000.00 -17,000.00 14 Payroll 160,000.00 190,000.00 15 Utilities 35,000.00 40,000.00 16 Net income before taxes 135,000.00 158,000.00 17 Income taxes 30,000.00 40,000.00 18 Net income $105,000.00 $ 118,000.00 19 20 21 22 23 24 25 26 37 Income Statement Balance Sheet Ratios Type here to search 2 O B A What SUP, Inc. Balance Sheet as of B D E LL F 12/31/20 % of Assets % Change Assets Current Assets: Cash Accounts Receivable Inventory 12/31/19 $ 35,000.00 $ 25,000.00 60,000.00 115,000.00 65,000.00 140,000.00 10,000.00 8,000.00 Property, Plant, and Equipment: Prepaid Expenses Supplies 8,000.00 7,000.00 120,000.00 120,000.00 Land Building 5 Equipment 5. Less: Accumulated Depreciation 7 Total 8 19 Liabilities and Stockholders' Equity 20 Liabilities 21 Current Liabilities: 22 Accounts Payable 23 Payroll Liabilities 24 Long-Term Debt 25 Stockholders' Equity Common Stock 26 27 Retained Earnings 28 Total 29 30 300,000.00 300,000.00 67,000.00 93,000.00 (115,000.00) (143,000.00) ######## ######## $ 52,000.00 $ 40,000.00 8,457.36 150,000.00 11,457.36 56,000.00 10,000.00 10,000.00 379,542.64 497,542.64 ######## Income Statement Balance Sheet Ratios 9 Alignment B C D E C22 1 2 3 4 Clipboard X fx A Font What SUP, Inc. Ratio Analysis Ratio Analysis 2020 6 Return on owners' investment 5 Profitability 7 Return on total investment 8 Profit margin 9 Gross margin 10 11 12 13 Liquidity 14 Current ratio 15 Quick ratio 16 Receivable turnover 17 Inventory turnover 18 19 20 Solvency 21 Debt-to-equity 22 Liability 23 24 22222220 25 26 27 28 29 LL 30 Income Statement Balance Sheet Ratios C Tune horn to coarch C