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 | 220,000 | 1,050,000 | 550,000 |
Cash operating expenses paid | 128,000 | 770,000 | 330,000 |
Depreciation on tax return | 28,000 | 64,000 | 50,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 |
Solution: | ||||
(a) | A | B | C | |
Cash Revenue (A) | $154,000 | $787,500 | $440,000 | |
[$220,000*(1-0.30)] | [$1,050,000*(1-0.25)] | [$550,000*(1-0.20)] | ||
Cash Operating expenses(B) | $89,600 | $577,500 | $264,000 | |
[$128,000*(1-0.30)] | [$770,000*(1-0.25)] | [$330,000*(1-0.20)] | ||
Depreciation ( C) | $8,400 | $16,000 | $10,000 | |
[$28,000*30%] | [$64,000*25%] | [$50,000*20%] | ||
(b) | Net after tax cash flows A-B+C | $72,800 | $226,000 | $186,000 |
Working note: | ||||
After tax revenue = Revenue(1-tax rate) | ||||
After tax Operating expenses = Operating expenses(1-tax rate) | ||||
After tax depreciation = Depreciation * tax rate | ||||
After tax cash flow = After tax revenue - after tax operating expenses+depreciation tax sheild | ||||
Please upvote , if found the answer useful. | ||||
For any clarification, Feel free to reach at comment Section |