Module-04-Assignment-Student-Name [Read-Or FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 16 Cut BE Copy Calibri 11 -A A Wrap Text General Normal Bad Paste Format Painter BI U - B - GA Merge & Center $ - % Conditional Format as Check Cell xplan Formatting Table Clipboard Font Alignment Number i11 1 Instructions: 1. Using Microsoft Excel formulas, calculate a horizontal and vertical analysis for the first three months of 2 QB Cloud's operations for the profit and loss. 4 QB Cloud Profit and Loss 6 Horizontal & Vertical Analysis 7 Quarterly Vertical 8 October November December October - December Analysis Horizontal Analysis 9 Income 10 401 Sales 6,000.00 11,920.00 13,220.00 31,140.00 11 Total Income 5,000.00 $ 11,920.00 $ 13,220.00 $ 31,140.00 12 Cost of Goods Sold 13 501 Cost of Goods Sold 0.00 5,960.00 6,610.00 12,570.00 14 Total Cost of Goods Sold 0.00 $ 5,960.00 $ ,610.00 $ 12,570.00 15 Gross Profit 5,000.00 $ 5,960.00 $ ,610.00 $ 18,570.00 16 Expenses 17 601 Advertising 125.00 250.00 330.00 705.00 18 603 Bank Charges 20.00 20.00 20.00 60.00 19 605 Dues & Subscriptions 150.00 0.00 125.00 275.00 20 607 Depreciation Expense 0.00 0.00 800.00 800.00 21 609 Freight & Delivery 64.65 89.15 52.65 206.45 22 611 Insurance 0.00 0.00 750.00 750.00 23 619 Meals and Entertainment 26.40 46.40 109.71 282.51 24 621 Office Supplies 226.85 11.82 200.11 538.78 25 623 Rent or Lease 0.00 0.00 5,000.00 6,000.00 6 625 Repair & Maintenance 140.00 0.00 150.00 290 0 27 627 Shipping and delivery expense 47.00 0.00 47.00 94 00 28 629 Stationery & Printing 425.22 127.96 115.82 669.00 29 633 Telephone Expense 158.32 58.32 240.45 557.09 30 635 Utilities 79.00 84.32 85.33 248.65 31 Total Expenses 1,562.44 $ 887.97 $ 9,026.07 $ 1,476.48 32 Net Operating Income 4,437.56 $ 5,072.03 -$ 2,416.07 $ 7,093.52 33 Net Income 4,437.56 $ 5,072.03 $ 2,416.07 $ 7,093.52 34 5 Address the following questions. Be mindful of writing in complete sentences and using proper spelling and grammar. 36 37 Profit and Loss Balance Sheet Ratio Analysis + READY Type here to search WE e Pa hp