Excel File Edit View Insert Format Tools Data Window Help G Q Sat Apr 1 9:24 AM AutoSave OFF ... Funderburk-Phil-Milestone-Five Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments LE Share Calibri (Body) v 11 AA =1 ap Wrap Text v Accounting Paste B IUV MvAv Merge & Center $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data B19 X fx B C D E F G H J K L M N 0 P Q R S T A Company Income Statement For Month ending 3/31/20XX DO VOUI AWNI Revenues Service Revenue $ 6,225.00 Total Revenues $ 6,225.00 10 Operating Expenses: 11 Rent Expense 950.00 12 Business License Expense 250.00 13 Depreciation Expense 45.83 14 Insurance Expense 50.00 15 Repairs and Maintenance Expense 95.00 16 Advertising Expense 500.00 17 Wages Expense 275.00 18 Utilities Expense 135.00 19 20 Total Operating Expenses: 3,000.83 21 22 Net Income 3,224.17 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 General Journal Ledger Accounts Trial Balance Income Statement Statement of Stockholder Equity Balance Sheet Closing Entries + Ready Accessibility: Investigate + 100%Excel File Edit View Insert Format Tools Data Window Help G Q Sat Apr 1 9:24 AM AutoSave OFF ... Funderburk-Phil-Milestone-Five Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments LE Share Calibri (Body) v 11 A A ap Wrap Text v General EX Ac Paste B IUV MvAv Merge & Center $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data M32 X V fx A B D E F G H J K L M N 0 P Q R S T U V Company Name Statement of Owner's Equity Period Ending 03/31/20XX Beginning Capital on 3/01/20XX $ Increases to capital Net income/loss: 3,224.17 Owner Contributions 17,750.00 Subtotal: 20,974.17 10 Decreases to capital 11 12 Owner Draws $ 500.00 13 14 Ending Equity as of 03 S 20,474.17 15 16 17 18 19 20 21 23 24 25 26 33 34 35 36 37 38 39 40 41 42 D General Journal Ledger Accounts Trial Balance Income Statement Statement of Stockholder Equity Balance Sheet Closing Entries + Ready Accessibility: Investigate + 100%Excel File Edit View Insert Format Tools Data Window Help G Q Sat Apr 1 9:24 AM AutoSave OFF ... Funderburk-Phil-Milestone-Five Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments LE Share Calibri (Body) 12 A A ap Wrap Text v General EX AP- O. Paste BIL MvAv Merge & Center $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data ES X V fx Total Current Liabilities A C D E F H K M N Q R A Company Balance Sheet As of March 31, 20XX 5 Assets Liabilities and Owners' Equity 6 Current Assets: Current Liabilities: 7 Cash 138,515.00 Accounts Payable 135.00 8 Accounts Receivable 3,500.00 Wages Payable 275.00 9 Prepaid Rent 950.00 Total Current Liabilities 410.00 10 C 15.00 Long Term Liabilities 11 Notes Payable 125,000.00 2 Total Current Assets 143,180.00 Total Long Term Liabilities: 125,000.00 13 14 Total Liabilities: 125,410.00 15 16 17 Owner's Equity 18 Owner's Equity 20,474.17 19 Non-Current Assets: 20 Office Furniture 2,750.00 21 Accumulated Depreciation (45.83) Total Equity 20,474.17 22 Total Non Current/Fixed Assets 2,704.17 23 24 Total Assets: 145,884.17 Total Liabilities & Equity 145,884.17