Can someone help me answer the attached statement of cash flows problem (located in the attached PDF)? I've started the assignment in excel (also attached), but I'm not sure how to proceed.

Homework 2 X Boca Inc. Balance Sheets December 31 Assets Cash Accounts Receivable Inventory Prepaid Expenses Long-term Investments Plant Assets 2018 40,800 87,800 112,500 28,400 138,000 367,000 2017 48,400 38,000 102,850 26,000 109,000 242,500 Accumulated depreciation Total (50,000) (52,000) 724,500 514,750 Liabilities and Stockholders' Equity Accounts Payable Accrued Expenses Payable Dividends Payable Bonds Payable Common Stock Retained Earnings Total 72,000 13,500 3,000 170,000 262,000 204,000 724,500 67,300 21,000 146,000 175,000 105,450 514,750 Additional Information: 1. Old plant assets having an original cost of $57,500 and accumulated depreciation of $48,500 were sold for $1,500 cash. 2. A new plant asset was purchased directly in exchange for common stock valued at $42,000. 3. New bonds were issued at par for $60,000. 4. Net income was $154,480. 5. A $1,000 prior period adjustment was recorded in 2017 correcting an understatement of depreciation in 2015. The 2017 balance sheet is appropriately restated. Required 1. Prepare a 2018 statement of cash flows using the indirect method. Use the textbook format (pages 1,420, 1,423, and 1,427). 3/14/2016 ACC 503 Homework #2 Boca Inc. Statement of Cash Flows For the Year Ended December 31, 2015 Presented Below are data from the records of Boca Inc.: 2018 40,800 600,000 87,800 112,500 28,400 138,000 367,000 (50,000) 85,500 3,000 170,000 262,000 204,000 Cash Short-term Investment A/R Inventory Prepaid Expenses Long-term Investment Plant Assets Accum Depre. A/P and Accrued Liabilities Dividends Payable Bonds Payable Common Stock Retained Earnings Plant Assets 242,500 42,000 Change Increase/Decrease (7,600) 600,000 49,800 9,650 2,400 29,000 124,500 2,000 (2,800) 3,000 24,000 87,000 98,550 2017 48,400 38,000 102,850 26,000 109,000 242,500 (52,000) 88,300 146,000 175,000 105,450 Accum Depre. R.E 52,000 105,450 46,500 50,000 204,000 48,500 57,500 140,000 367,000 Long-term Investment 109,000 Common Stock 175,000 42,000 45,000 262,000 138,000 Boca Inc. Statement of Cash Flows For the Year Ended December 31, 2015 Cash Flows from Operating Activities Net Income to reconcile net income to Adjustments net cash provided by operating activities: Deprecitation Expense Increase in Receivables Increase in Inventory Loss on sale of Plant Assets Decrease in A/P and Accrued Liabilities Net Cash Flow Provided by Operating Activities $ $ Cash Flows from Investing Activities 47,500 49,800 9,650 7,500 (2,800) 154,480 111,650 266,130.00 Increase(Decrease) in Cash Provided by Investing activities: Sales of Equipment Sales of Long-term Investment Purchase of Equipment Purchase of Short-term Investment Total Cash Flow from Investing Activities Cash Flows from Financing Activities 0 Increase(Decrease) in Cash Provided by Investing activities: Paid Dividend Issue Common Stock Sale of Notes Payable Total Cash Flow from Financing Activities Total Cash Flows Cash Change 0 Beginning Balance of Cash Endding Balance of Cash Cash Change