You are to create a financial analysis for Snick's Board shop as of December 31,2017, and December 31,2018. Following the Chapter 3 Examples, use the student filech3-06.xla 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, formated similar to you 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.

8 ch3-06 - Excel View Help Search AutoSave on 2 File Home Insert Calibri Paste BTU .0 : Draw Page Layout Formulas 12A A == . 29. AA E E E Data Review Wrap Text Merge & Center General - Paste $ -% 8 Inser Conditional Format as Cell Formatting Table - Styles Styles Clipboard Font Alignment Number A1 - fx Snick's Board Shop ID E F G H I Snick's Board Shop Balance Sheet as of December-2017 % Assets December-2018 % Assets % Change Assets 6 Current Assets: Cash 8 Inventory 9 Supplies $ 7,500 4,800 500 100% $ 6496 1,000 6,500 500 12,800 7% 8,000 11 Equipment 12 Less: Accumulated Depreciation 13 Total 9,000 4,800 11,100 6,100 4.200 $ 17,000 5,000 $ 13,000 $ $ 11,000 3,000 14,000 8,950 2,050 11.000 15 Liabilities and Stockholders' Equity 16 Current Liabilities 17 Accounts Payable 18 Payroll Liabilities 19 20 Owner's Equity 21 Total Income Statement 3,000 $ 17,000 2,000 13,000 $ Ratio Analysis Average: 9740 06150 count st suma Type here to search DOLL ch3-06 - Excel AutoSave File Home 8. Draw Insert Page Layout Formulas Data Review View Help Search o Wrap Text General Calibri BIU. 12 - A A .0.A. Paste 5 Merge & Center - $ -% 98 Conditional Format as Formatting Table Cell Styles Clipboard Font Alignment Number Styles 1 x Snick's Board Shop 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 -2296 1496 -39% 6 Sales 7 Less: Cost of Goods Sold 8 Gross Margin 9 Expenses: 10 Advertising 11 Depreciation 12 Wages Supplies Other 15 Net Income (loss) 8,000 1,200 12,000 900 100% 15% 150% 6,000 1,300 9,000 2,100 1,600 8% -25% 13395 100% 22% 150% 35% 57% -3% 13 52% 23,600 7,400 20,000 (1,000) -15% - 11496 $ 16% S Income Statement Balance Sheet Ratio Analysis Type here to search DELL T