In: Accounting
After-Tax Cash Flows
Using the data that is shown below - (a) calculate the individual after-tax cash flow effect of each relevant item in each independent situation, and (b) sum the individual after-tax cash flows in each situation to determine the overall net after-tax cash flow.
| A | B | C | |
|---|---|---|---|
| Cash revenue received | $110,000 | $525,000 | $275,000 |
| Cash operating expenses paid | 64,000 | 385,000 | 165,000 |
| Depreciation on tax return | 14,000 | 32,000 | 25,000 |
| Income tax rate | 30% | 25% | 20% |
Do not use negative signs with any of your answers below.
| A | B | C | ||
|---|---|---|---|---|
| (a) | Cash revenue | Answer | Answer | Answer |
| Cash operating expenses | Answer | Answer | Answer | |
| Depreciation expense | Answer | Answer | Answer | |
| (b) | Net after-tax cash flow | Answer | Answer | Answer |
| A | B | C | |
| Cash revenue | $ 110,000.00 | $ 525,000.00 | $ 275,000.00 |
| Cash operating expenses | $ 64,000.00 | $ 385,000.00 | $ 165,000.00 |
| Depreciation expense | $ 14,000.00 | $ 32,000.00 | $ 25,000.00 |
| Net after-tax cash flow | $ 36,400.00 | $ 113,000.00 | $ 93,000.00 |
Working
| A | B | C | ||
| A | Cash revenue received | $ 110,000.00 | $ 525,000.00 | $ 275,000.00 |
| B | Cash operating expenses paid | $ 64,000.00 | $ 385,000.00 | $ 165,000.00 |
| C | Depreciation on tax return | $ 14,000.00 | $ 32,000.00 | $ 25,000.00 |
| D=A-B-C | Income before taxes | $ 32,000.00 | $ 108,000.00 | $ 85,000.00 |
| E | Income tax rate | 30% | 25% | 20% |
| F=D x E | Income tax expense | $ 9,600.00 | $ 27,000.00 | $ 17,000.00 |
| G=D-F | Net income after tax | $ 22,400.00 | $ 81,000.00 | $ 68,000.00 |
| H | Depreciation on tax return | $ 14,000.00 | $ 32,000.00 | $ 25,000.00 |
| I=G+H | Net after-tax cash flow | $ 36,400.00 | $ 113,000.00 | $ 93,000.00 |