Please help me balance the statement of cash flow. Operating balance should be $145,654.65
the assignment is due tonight and I need help.
| Peyton Approved Statement of cash Flow For Year Ended 12/31/2017 Net Income $ 175,476.18 Depreciation Expense 677.86 176,154.04 Increase in Accounts Receivable (25,886.91) Increase in Baking Supplies (11,362.84) Increase in Merchandise inventory (443.10) Increase in Prepaid Rent (449.55) Increase in Prepaid Insurance (1,004.55) Increase in Misc. Supplies (114.99) Increase in Accounts Payable 6,467.11 Increase in Wages Payable 1,850.48 Increase in Interest Payable 44.96 Operating Cash Flow 145,254.65 Cash Flow from Investments Equipment Purchases (5,300.00) Cash Flow from Investments (5,300.00) Cash Flow from Financing Repayment of Note Payable (10,000.00) Dividends Paid (105,000.00) Cash Flow from Financing (115,000.00) Net Cash Flow 24,954.65 Beginning Cash 43,165.39 Ending Cash 68,520.04 |
| | | | | 145,254.65 |
| | | | (5,300.00) |
| | | | (115,000.00) |
| | | | | | 24,954.65 |
| | | | | | 43,165.39 |
| | | | | | | 68,520.04 |
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 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 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 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 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
