Perform a horizontal and vertical analysis on Jane's wedding centre and identify 5 questions that come out of your analysis.

Week 2 Homework Exercise 1 (2) - Excel (P FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri Wrap Text General % Cut Copy Format Painter - 12 - AA ..A Paste BIU Merge & Center - 9.% Conditional Forn Formatting. Tat Clipboard Font Alignment Number 21 XV D E G 1 Week 2- Analysis Homework Horizontal Analysis Page perform a horizontal analysis on the Income Statement and Balance Sheet 3 4 5 Jano's Wedding Centre Janie's Wedding Centre 6 Condensed Income Statement Balance Sheets December 31, Last Year and This Year For the Periods Ending December 1. Last Year and This Year 9 Last Year This Yea Changi Change Lant Year (3) This Yea Change Change to INCOME STATEMENT ASSETS 11 Current Assets 12 Sales 5.525001 742205 Cash 42.000 30 000 12 Cost of Sales 2.22.025 2002 mo Murable Securities 93.000 80.000 14 Gross Profit 3.25.4231 482.405 Net Fleceivables 138.000 152.000 Cerino perve Ecluding 160.225 2.80.278 Ireories 5.000 STAD 15 Cestion 10 Depreciation ERGO 2.000 Total Current Assets 2000 20.000 1 Operating Income (IT) 1.06201 140.000 18 eest 30.000 Property and examen 1200.000 10:31.7.0 1. Income Before Income Taxes 71.2001 1222 Lol Accumulated Depreciation 200.000 71.000 20 Inme TNR 1401 297180 OOR Net Property and Equipmen 1000.000 9.50,700 21 Net Income 127201 7390 22 TOTAL ASSETS 122 10 23 14 LIABILITIES AND OWNERS' EQUITY Current Liabilities 28 Aron Payable 107.000 45000 27 Notes Payable 15.000 2000 28 Accrued Wages 38.000 2009 29 Total Current Liabilities 160.000 127.000 00 31 Lore-Term Labied 32 Long Term De 3:40.800 12200 33 Total Liabilities 500 000 2.65.200 34 55 Owners' Equity 36 Capits Stock 6.00.000 730.000 32 Pendamine 127.200 2.03.500 30 Total Owners' Equity 227200 29 40 TOTAL LIABILITIES AND OWNERS' EC 1278.00 MATEO 41 42 43 44 Horizontal Analysis Vertical Analysis Questions from Analysis $ Week 2 Homework Exercise (7) Excel Product Activatio FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri TAA Normal X Cut a copy Paste Format Painter Clipboard Wrap Text Number Merge & Center. 9. % BIU- A. 3 Conditional Format as Good Formatting Table - Font Alignment Number 112 A E E H 5 Jane's Wedding Centre 's Wedding Centre Conderved Income Statement Balance Sheets 2 December 31, Last Year and This Year B. For the Periods Ending December 31 Last Year and The Year Last Year This Year ast Year his Year % Last Year 191 This Year ast Year This Year 10 INCOME STATEMENT ASSETS Current Asses Ses 552300 742205 142.000 30.04 Costos 2016 33.000 30.000 14 Grets Profit 22543 48240 Acciate 000 1 Gerling penses duong 10 290276 wwertones 5.000 6.00 15 Cero 16 Decreto BIELE Total Current Assets 27900 2100 17 Operating Income TERITI 165200 4 Property and East 1200.000 TOLLES Income Before Income Taxes 1200 122267 Acum Nedeti 2.00.00 LETO 20 Income Taxes 02 20140 Teroperty and Equpment 000 000 90 ZEE 21 Nont income TOTAL ASSETS 30 12 23 24 LIAHIUTIES AND OWNERS EQUITY 25 ICU 26 Accountable 107000 CO 27 Notese 6000 201 ALOW 33.000 20 20 Total Current Lotion 150 000 1270 30 31 Long-Term Lines 22 Line CBI 2012 2020 22 Total Lities 34 Own 14 ch 000 7. 17 weg 38 Tots LO 393 40 TOTAL LIAUTIES AND OWNERS 41 42 40 Horizontal Analysis Vertical Analysis Questions from Analysis B> Wiek 2 Homework 10) Excel (Produd Activation Failed) FILE HOME INSERT WGE LAYOUT FORMULAS DATA REVIEW VIIW cut Calibri 16 . Wrap Test General Normal 3 Noru Copy Page U... A. + Format Printer Merge Center - - % Conditional format as Good Formatting Table Clipboard Font Abigan Number yle AI Xf Week 2 Analysis Homework A B D E F G 1 J K M N 1 Week 2- Analysis Homework 2 Questions from Analysis Pege-list question from your analysis of Jane's results that you would want to research further 3 4 5 6 7 S 9 10 12 13 13 16 17 18 19 20 21 23 25 26 27 319 Horizontal Analysis Vertical Analysis Questions from Analysis READY