Chapter 3 Case Problem 3: SNICKS BOARD SHOP You are to create a financial analysis for Snicks Board Shop as of December 31, 2017, and December 31, 2018. Following the Chapter 3 examples, use the student file ch3-06.xls to create a vertical and horizontal analysis of the balance sheet and income statement in the columns provided. (Note: The horizontal analysis will compare December 31, 2017, with December 31, 2018.) Also create a pie chart of expenses for the year ended December 31, 2018, formatted in a manner similar to your chapter work; a column chart of expenses for the years ended December 31, 2017, and December 31, 2018, formatted in a manner similar to your chapter work; and a ratio analysis as of December 31, 2018. Save the file as ch3-06_student_name.xls (replacing student_name with your name). Note: You will have to use Excels help feature to create the column chart because the columns are not adjacent to one another as in the chapter example. Use whatever chart layout you prefer. Print each completed worksheet in Value view, with landscape orientation, scaling to fit 1 page wide by 1 page tall, and with your name and date printed in the lower left footer and the file name in the lower right footer.

Please check to see if those formulas are correct or not and help with the ratios. please answer in excel format

Snick's Board Shop Income Statemnt for the period ended 12/31/2017 $ 45,000 14,000 31,000 % Sales 100% 31% 69% 12/31/2018 $ 35,000 16,000 19,000 % Sales 100% 46% 54% % Change -22% 14% -39% $ $ Sales Less: Cost of Goods Sold Gross Margin Expenses: Advertising Depreciation Wages Supplies Other Net income (loss) 8,000 1,200 12,000 900 1,500 18% 3% 27% 2% 6,000 1,300 9,000 2,100 1,600 17% 4% 26% 6% 5% -3% -25% 8% -25% 133% 7% -840% 3% 23,600 7,400 20,000 (1,000) $ 16% $ 2018 Expenses 8% 11% 30% Snick's Board Shop Balance Sheet as of December-2017 % Assets December-2018 % Assets % Change Assets Current Assets: Cash Inventory Supplies $ $ 8% 7,500 4,800 500 44% 28% 3% 1,000 6,500 500 50% 4% -87% 35% 0% 12,800 8,000 Equipment Less: Accumulated Depreciation Total 9,000 4,800 11,100 6,100 4,200 $ 17,000 25% 100% 5,000 $ 13,000 38% 100% 19% -24% Liabilities and Stockholders' Equity Current Liabilities Accounts Payable Payroll Liabilities $ 11,000 3,000 65% $ 18% 8,950 2,050 69% 16% 14,000 11,000 -21% Owner's Equity Total 3,000 $ 17,000 18% 100% 2,000 $ 13,000 15% 100% -33% -24% Snick's Board Shop Ratio Analysis December 2018 Profitability Return on owners' investment Return on total investment Profit margin Gross margin Liquidity Current ratio Quick ratio Receivable turnover Inventory turnover Solvency Debt-to-equity Liability