2020; and a ch3-03 student ame. printed in the lower left footer and the HI footer Print each completed worksheet in Chapter 3 Case Problem 1: KELLY'S BOUTIQUE ou are to create Kelly's Boutique's financial analyses as of D You file ch3-04 xls to create a vertical and horizontal analysis l compare December 31, 2018, with December 31 chart of expenses for the years ended December 31, 2018, and Dec December 31, examples, use the of the balance 2019.) Also cre- 2018, and as of student file ch3-04.xls to December 31, 2019. Following the Chapter 3 ex sheet and income analysis will compare ate a pie chart of expenses for the year ended December 31, 2019; a co statement in the columns provided. (Note: December 3 1, 2019: and ch3- -04 stud Print each a ratio analysis as of December 31, 2019. Save the f ent name.xls (replacing student name with your name). completed works heet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. Font Alignment Oipboard c18 F G Kelly's Boutique Income Statement For the Year Ended : 9bOf Sales %Change 31-Dec-18 31-Dec-19 S 345,274.22 $400,000.00 164.217.74 210,000.00 6 Sales Revenue Less: Cost of Goods Sold 8 Gross Margin 9 Expenses: 10 Advertising 11 Depreciation 12 Interest 13 Payroll 14 Supplies expense 181,056.48 190,000.00 s 25,871.45 s 28,000.00 8,431.227,000.00 5,574.1516,000.00 105,487.51109,000.00 4,732.845,000.00 0847.009,000.00 10,112.31 16,000.00 3,784.44 5000.00 S 6,32787 $ 11,000.00 5 Utilities 16 Net income before taxes 17 Income taxes 18 |Net income 63278711.000.001 21 23 28 30 31 32 36 Income Statement Balance Sheet Ratio Analysis O Type here to search B8 F G 31-Dec 18 31-Dec- 19 % of Assets %of 5 Assets 31-Dec-18 31-Dec-19 6 Current Assets: 7 Cash S 8213.50 6,000.00 35,5715 45,000.00 60,214.55 92,000.00 700.00 1,500.00 Accounts Receivable 9 Inventory 10 Prepaid Rent 11 Supplies 12 Property, Plant, and Equipment: 300,00 13 Land 400,000.00 427,000.00 35,000.00 33,000.00 21,000.00) (30,000.00) $550,000.00 $600,000.00 15 Equipment 16 Less: Accumulated Depreciation 17 Total 19 Liabilities and Stockholders' Equity 20 Liabilities 21 Current Liabilities: 22 Accounts Payable 23 Income Tax Payable 24 Notes Payable 25 Pa 26 Mortgage Payable s 29,663.39 40,000.00 4124.14 5,000.00 2,000.0087,000.00 3,212.47 6,000.00 120,000.00125,000.00 28 Common Stoclk 29 Retained Earnings 30 Total 301,000.00 306,000.00 20,000.00 31,000.00 5550,000.00 $600,000.00 Income StatementBalance Theet Ratio Analysis O Type here to search Number Clipboard Font Alignment Kelly's Boutique Ratio Analysis December 2019 5 Profitability 6 Return on owners investment 7 Return on total investment 8 Profit margin 9 Gross margin 10 Liquidity 11 Current ratio 12 Quick ratio 13 Receivable turnover 14 Inventory turmover 15 Solvency 16 Debt-to-equity 17 Liability 18 21 26 30 32 income Statement Balance Sheet Ratio Analysis O Type here to search