Use a spreadsheet and the following financial information from Mineola Company’s financial statements to build a template that automatically calculates the net operating cash flow. It should be suitable for use in preparing the operating section of the statement of cash flows (indirect method) for the year 2018.

Transcribed Image Text:

Cash Account Receivable Prepaid Assets Total Assets Accounts Payable Common Stock Retained Earnings Total Liabilities and Equity Additional information: Net income Dividends paid Dec. 31, 2018 $57,000 12,500 1,500 71,000 2,700 39,000 29,300 71,000 7,000 4,000 Dec. 31, 2017 $42,000 15,000 1,100 58,100 1,800 30,000 26,300 58,100