Change the amounts for selected balance sheet accounts in the spreadsheets created for either S12-7 to calculate the net cash flows from operating activities if, just before the current year-end, the company’s management took the actions listed in the following requirements. Consider each question independently, unless indicated otherwise.

Required:
1. What if the company collected $10,000 of the accounts receivable?
2. What if the company had paid down its interest payable by an extra $2,000?
3. What if the company waited an additional month before paying $6,000 of its accounts payable?
4. What if the company had reported $5,000 more depreciation expense?
5. What if all four of the above events had taken place at the same time?

Spreadsheets From 12-7:

Transcribed Image Text:

2 3 4 5 6 7 8 9 17 18 Home neert 22222 Cash Accounts receivable Inventories Total Current Assets 10 Property plant, and equipment 11 Leas: accumulated depreciation. 12 Total Assets LIABILITIES 13 14 Accounts payable 15 Income taxes payable 16 Interest payable Page Layout Formula B Small Business Client: 19 Long-term clabt 20 Total Liabilities 21 22 Contributed Capital Balance Sheet At December 31 ASSETS Ready Other accrued liabilities Total Current Liabilities Cut 12j xlsx Microsoft Excel 23 Retained Eamings 24 Total Stockholders' Equity 26 STOCKHOLDERS' EQUITY ||A|| Data Review View D S 65 S 62.500 105,000 (20.000) 147.500 $ 31.400 3,000 4,000 11.000 49,400 40,000 89,400 Current Year Prior Year 5 8,000 $ 12,000 16.900 8.500 37.600 25.900 46.400 105,000 0. (10.000) -10.000 141.400 10,000 48 100 58 100 63 Total Liabilities and Stockholders' Equity 5 147.500 $ BS 19 Indirect Direct 100% 30,000 4.000 1.800 14.000 49.800 40,000 89,800 2 10,000 41,500 51,600 141.400 T " E ILI D C Change -4.000 +8.400 +11.700 +1.400 -1,000 +2.200 -3.000 0 0 +6.500