price = 700,000
shipping, site preparation, and installation cost = 100,000
Δinventory = 50,000
Δaccounts payable = 20,000
sale price = 75,000
| Year | 1 | 2 | 3 | 4 | Total |
| Sales | 750,000 | 750,000 | 750,000 | 750,000 | |
| Variable costs | 225,000 | 225,000 | 225,000 | 225,000 | |
| Fixed expense | 75,000 | 75,000 | 75,000 | 75,000 | |
| Depreciation | 264,000 | 360,000 | 120,000 | 56,000 | (*11) 800,000 |
| Earnings before tax (EBT) | 186,000 | 90,000 | 330,000 | 394,000 | |
| after-tax cash flow | 375,600 | 414,000 | 318,000 | (*12) 292,400 | |
| Net income (*1) | (*2) 111,600 | (*3) 54,000 | (*4) 198,000 | ||
| Tax rate (*5) | (*6) 40% | (*7) 40% | (*8) 40% | (*9) 40% | |
| A system-related cash flow | (*10) -830,000 | 75,000 | |||
| Total after-tax cash flow | 375,600-830,000 =-454,400 | 414,000 | 318,000 | 292,400+75,000 = 367,400 |
(*1) Net income = Total after-tax cash flow - Depreciation
(*2) 375,600 - 264,000 = 111,600
(*3) 414,000 - 360,000 = 54,000
(*4) 318,000 - 120,000 = 198,000
(*5) EBT * (1-t) = Net income = Total after-tax cash flow - Depreciation
t = 1-Net income/EBT = 1-(Total after-tax cash flow - Depreciation)/EBT
(*6) t = 1-Net income/EBT = 1-111,600/186,000 = 40%
(*7) t = 1-Net income/EBT = 1-54,000/90,000 = 40%
(*8) t = 1-Net income/EBT = 1-198,000/330,000 = 40%
(*9) given based on the result of (*6), (*7), and (*8)
(*10) Initial investment outlay = (price + shipping, site preparation, and installation cost) + increase in net working capital = (700,000 + 100,000) + (50,000 - 20,000) = 800,000 + 30,000 = 830,000
(*11) 264,000 + 360,000 + 120,000 + 56,000
(*12) EBT * (1-t) = Net income = Total after-tax cash flow - Depreciation
Total after-tax cash flow = EBT * (1-t) + Depreciation = 394,000 * (1-40%) + 56,000 = 292,400
or
(S-C)(1-t) + D*t = (750,000-225,000-75,000)(1-40%) + 56,000*40% = 270,000 + 22,400 = 292,400
Terminal year after-tax non-operating cash flow (TNOCF) = SalT + NWCInv - t * (SalT - BT)
= 75,000 + (50,000-20,000) - 40% * (75,000 - 0) = 75,000
BT=0 since original (price + shipping, site preparation, and installation cost) = 800,000 = cumulative depreciation at Year 4
Why does NWCInv have positive sign and need to be added back?
You spend some money at the start of the project on NWCInv to start up the capital budgeting project. When the project ends - you get that money back (it gets freed up) and you can sell the NWCInv including inventory, and whatever you procured in the beginning. Since you get it back, you have to add it back and account for it at the end of period cash flow.
Economic Income = After-tax Operating Cash Flow - Economic Depreciation
Economic Depreciation = Market Value(beginning) - Market Value(ending)
Market Value(time=t) = Present Value of all remaining cash flows discounted at the WACC
Market Value(beginning, Year 3)
= CF3/(1 + WACC)1 + CF4/(1 + WACC)2
= 318,000/(1 + 8%)1 + 367,400/(1 + 8%)2
= 609,430
Market Value(ending)
= CF4/(1 + WACC)1
= 367,400/(1 + 8%)1
= 340,185
Economic Income(Year 3)
= After-tax Operating Cash Flow (Year 3) - Economic Depreciation (Year 3 to 4)
= 318,000 - (609,430 - 340,185)
= 48,755
0 comments:
Post a Comment