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