need help balancing the statement of cash flow

2- me ) = Insert Page Layout Formulas Data Final Milestone - Review View Ariel - 12 - - A - / U - - A ormat Painter ard Wrap Test Merge & Center S. . 1 Conditional Format Formatting Table Normal Check Cell . Font Alignment Warning Automatic update of links has been disabled Options - Peyton Approved Peyton Approved Balance Sheet As of December 31, 2017 Assets Current Assets: Cash Accounts Receivable Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Misc Supplies Other receivables Insurance 68,520.04 68,519.91 18,681.70 1,238.07 2,114 55 2,114.55 170.49 700 00 Liabilities and Owners' Equity Current Liabilities: Accounts Payable 23.437.11 Wages Payable 3,383 28 Interest Payable 1.46 Customer deposits 1,000.00 Total Current Assets 162,059.31 Total Current Liabilities 28,031.85 Long Term Liabilities: Notes Payable Total Long Term Liabilities: 5,000.00 Long Term/Fixed Assets: Baking Equipment Accumulated Depreciation Net Fixed assets 12,000.00 (406.44) 5,000.00 11,593.56 Total Liabilities: 33,031.85 Common Stock Retained Earnings 20.000.00 120.821.02 Total Equity 140.621.02 Total Assets 173,652.87 T otal Liabilities & Equity 173,652.87 017RE 2012. Red Cash Flow 2017 2017 Revised Ba BS 2017 Revised Incom nation and press ENTER Orcheste Type here to search Orte L Wiap TEL at Painter Merge & Center Alignment ning Automatic update of links has been disabled Options... e Peyton Approved D Peyton Approved Income Statement For Year Ended 12/31/2017 327,322.55 1,205.64 328,528.19 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold - Baked Cost of Goods Sold - Merchandise Total Cost of Goods Sold Gross Profit 105,834.29 859.77 106,694.06 221,834.13 Operating Expenses Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Loss on sale of equipment Total Operating Expenses: 24,549.19 10,670.72 3,000.46 + 2,045.77 1,363.84 677.86 1,091.08 1,549.74 818.31 490.98 100.00 46,357.95 Net Income. 175,476.18 Final Milestone 3 - Micro F C Normal Bad Check Cell Merge Center Automatic update of has been Peyton Approved Peyton Approved Balance Sheet As of December 31, 2016 Assets Current Assets: Cash Accounts Receivable Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Misc Supplies Liabilities and Owners' Equity Current Liabilities: Accounts Payable 16,970.00 Wages Payable 1,532 80 Interest Payable 166.50 43,165 39 42,633.00 7,318.86 79497 1.665 00 1,110.00 55.50 Total Current Assets 96,742.72 Total Current Liabilities 18,669.30 Long Term/Fixed Assets: Baking Equipment Accumulated Depreciation Net Fixed assets Long Term Liabilities: Notes Pavable 15,000.00 Total Long Term Liabilities: 15,000.00 8,000.00 928.58 7,071.42 Total Liabilities: 33,669.30 Common Stock Retained Earnings 20.000.00 50,144.84 Total Equity 70,144 84 103,814.14 Total Liabilities & Equity 103.814.14 Data Review View Home Insert Page Layout Formulas & Cut Arial - 12 - A Copy Paste Format Painter B IU. . . A- Clipboard - Wrap Test Merge Center Accounting - - Fort $ % 42 Security Warning Automatic update of links has been disabled Number Options... H Peyton Approved Statement of cash Flow For Year Ended 12/31/2017 Instruc Mileste 5 Net Income 7 Depreciation Expense $ 175,476.18 677.86 176,154.04 10 Increase in Accounts Receivable 1 Increase in Baking Supplies 12 Increase in Merchandise inventory 13 Increase in Prepaid Rent 14 Increase in Prepaid Insurance 15 Increase in Misc. Supplies 16 Increase in Accounts Payable 17 Increase in Wages Payable 18 Increase in Interest Payable (25,886.91) (11,362.84) (443.10) (449.55) (1,004.55) (114.99) 6,467.11 1.850.48 44 96 Operating Cash Flow 145,254,65 145.654 65 23 Cash Flow from Investments 24 Equipment Purchases (5,300.00) Cash Flow from Investments (5,300.00) 28 Cash Flow from Financing 29 Repayment of Note Payable 30 Dividends Paid (10,000.00) (105,000.00) Cash Flow from Financing (115,000.00) Net Cash Flow 24,954.65 36 Beginning Cash 43,165,39 ed Cash flow 2012 CF 2017 Revied Bance shee Type here to search O e L ViewSonic Insert Page Layout Formulas Data Review Calibri - 11 - - Wrap Text Merge & Center Accounting - % BIU-- ormat Painter ard Font Alignment Number Narning Automatic update of links has been disabled Options... Peyton Approved Income Statement For Year Ended 12/31/2017 $ 327,322.55 1,205.64 328,528.19 Bakery Sales Merchandise Sales Total Revenues Cost of Goods Sold-Baked Cost of Goods Sold - Merchandise Total Cost of Goods Sold Gross Profit 105,83429 859.77 106,694.06 221,834.13 Operating Expenses Rent Expense Wages Expense Misc. Supplies Expense Business License Expense Misc. Expense Depreciation Expense Insurance Expense Advertising Expense Interest Expense Telephone Expense Loss on sale of equipment Total Operating Expenses: 24,549.19 10,670.72 3,000.46 2,045.77 1,363.84 677.86 1,091.08 1,549.74 818.31 490.98 100.00 46,357.95 Net Income 175,476.18