Please complete in excel

P16A-37A Preparing the statement of cash flows -direct method Use the Rolling Hills data from Problem P16-34A. Requirements 1. Prepare the 2015 statement of cash flows by the direct method 2. How will what you learned in this problem help you evaluate an investment? P16B-38A Using a spreadsheet to prepare the statement of cash flows indirect method The 2015 comparative balance sheet and income statement of Appleton Group, Inc. follow. Appleton disposed of a plant asset at book value during 2015 APPLETON GROUP, INC. Income Statement Year Ended December 31, 2015 S 439,000 Sales Revenue Cost of Goods Sold 205,500 Grass Profit 233,500 Operating Expenses: Salaries Expense $ 76,500 Depreciation Expense Plant Assets 15,500 Other Operating Expenses 49,500 Total Operating Expenses 141,500 Operating Income 92,000 Other Revenues and (Expenses): Interest Revenue 11,800 (24,300) Interest Expense Total Other Revenues and (Expenses) (12,500) Net Income Before Income Taxes 79,500 Income Tax Expense 16,300 S 63,200 Net Income APPLETON GROUP, INC. Comparative Balance Sheet December 31, 2015 and 2014 2015 2014 Assets Current Assets S 15.300 Cash 9,300 Accounts Receivable 42,000 43,200 Merchandise Inventory 97,100 93,700 Long-term Assets Plant Assets 121,440 113,160 Accumulated Depreciation-Plant Assets (20,240) (18,860) Land 41,100 16,000 S 262,500 Total Assets S 290,700 Liabilities Current Liabilitios: S 25,600 S 26,600 Accounts Payable Accrued Liabilities 24,000 22,800 Long-term Liabilities Notes Payable 46,000 62,000 Total Liabilities 95,600 111,400 Stockholders' Equity Common Stock 140,300 131,400 Retained Earnings 54,800 19,700 Total Stockholders' Equity 195,100 151,100 S 262,500 Total Liabilities and Stockholders' Equity S 290,700 Prepare the spreadsheet for the 2015 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed for $0. The cost and accumulated depreciation of the disposed asset sales of land, no retirement of common stock and no treasury stock transactions. was $14,120. There were no