Prepare the spreadsheet for the 2016 statement of Cash Flows. Format Cash Flows from operating activities by the indirect method.

t method. th he you Data Table Energy Plus, Ino. Income Statement Year Ended September 30, 2016 Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: 240,000 99,000 141,000 $ 54,000 22,000 Salaries Expense Depreciation Expense-Plant Assets Total Operating Expenses Net Income Before Income Taxes Income Tax Expense Net Income 76,000 65,000 7,000 S 58,000 Print Done 40 2 of 4 (3 complete) by the indi i More Info s not used a. Acquisition of plant assets is $114,000. Of this amount, $102,000 is paid in cash and $12,000 by signing a note payable. b. Cash receipt from sale of land totals $25,000. There was no gain or loss c. Cash receipts from issuance of common stock total $32,000 d. Payment of note payable is $11,000 sis Payment of dividends is $13,000 From the balance sheet DIT e. f. September 30 2016 2015 $ 39,000 $ 18,000 Cash Accounts Receivable Merchandise Inventory Plant Assets Accumulated Depreciation Land Accounts Payable Accrued Liabilities Notes Payable (long-term) Common Stock, no par 46,000 99,000 204,000 57,000 92,000 90,000 (46,000)(24,000) 96,000 13,000 24,000 11,000 8,000 273,000 71,000 30,000 13,000 12.000 40,000 318,000 Print Done se the transaction referencen in Panel B when selecting the tannacion references n Panel A (If a f box is not usod in the spreadsheot, leave th Enoray Plus, too Spreadsheet toe Statenent of Caoh Fo Iransaction Analysis DEBIT Balance Balance CREDIT s 18,000 Cash Accounts Recelvable Merchandise Inventory 39,000 46,000 | 99,000 204,000 2,000 90,0001[ Accumulated DepreciationPlant (24,000) 96,000 $329,000 (46,000) 71,000 $ 413,000 Total Assets 13,000 24,000 11,000 48,000 30,000 13,000 12,000 Notes Payable 55,000 8,000 273,000 40,000 318,000 3 29.000 s413,000 the income statement and additional data of Energy Plus, Inc follow II (Click the lcon to viow the incomestatoment) (Cick the kon to vhow the addilional dala) Prepare the spreadsheet for the 2016 stat Total Liabilities and Stockholders' Equilty Panel B-Statement of Cash Flows: Cash Flows from Operating Activities Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities Cash Flows from Investing Activities Net Cash Provided by Operating Activities Cash Flows from Investing Activities (g1) Net Cash Used for Investing Activities Cash Flows from Financing Activities Net Cash Used for Financing Activities (g2) and F (92)