In: Finance
A new project is being considered and the data is given below. The asset has a 3-year tax life, would be depreciated on a straight-line basis over the project's 3-year life, and would have a zero salvage value after Year 3. Operating working capital change would be of $1000. Revenues and other operating costs will be constant over the project'slife. If the units decline by 45% from the expected level, find the change in NPV.Investment cost $60,000 Units2,800 Price/Unit$25.00 Fixed costs$10,000 V cost/unit $5.375 Annual depreciation$20,000 WACC10.0% Tax rate40.0%
Given : | ||
Annual Depreciation : | 20,000 | |
Tax rate | 40% |
Annual Depreciation Tax saving | 8,000 | ||
Sales Details in two scenario | Full sales | Sales with 45% decline | |
Annual Sales Units | 2,800 | 1,540 | |
Price/Unit | $ 25.00 | $ 25.00 | |
a | Annual sales Revenue | 70,000 | 38,500 |
Variable cost per unit | $ 5.375 | $ 5.375 | |
b | Annual variable cost | $ 15,050.00 | $ 8,277.50 |
c | Annual fixed cost | $ 10,000.00 | $ 10,000.00 |
d | EBIT (w/o depreciation)=a-b-c | $ 44,950.00 | $ 20,222.50 |
e | Tax @40% | $ 17,980.00 | $ 8,089.00 |
f | After Tax Income | $ 26,970.00 | $ 12,133.50 |
NPV with full sales | Year 0 | Year 1 | Year 2 | Year 3 | |
Initial Investment | |||||
Investment cost | (60,000) | ||||
Investment in NWC | (1,000) | ||||
a | Total Initial Investment | (61,000) | |||
Cash flow from Operations | |||||
After Tax net Income | 26,970.00 | 26,970.00 | 26,970.00 | ||
Depreciation Tax savings | 8,000 | 8,000 | 8,000 | ||
b | Total Cash flow from Operations | 34,970 | 34,970 | 34,970 | |
Terminal Cash fow | |||||
Return of NWC | 1,000 | ||||
c | Total Terminal Cash flow | 1,000 | |||
d | Total Free Cash flow from Project =a+b+c | (61,000) | 34,970 | 34,970 | 35,970 |
e | PV factor @WACC 10%=1/1.10^n | 1 | 0.9091 | 0.8264 | 0.7513 |
f | PV of FCF =d*e= | (61,000) | 31,791 | 28,901 | 27,025 |
g | NPV =Sum of PV of FCF = | 26,716.53 |
NPV with 45% less sales | Year 0 | Year 1 | Year 2 | Year 3 | |
Initial Investment | |||||
Investment cost | (60,000) | ||||
Investment in NWC | (1,000) | ||||
a | Total Initial Investment | (61,000) | |||
Cash flow from Operations | |||||
After Tax net Income | 12,133.50 | 12,133.50 | 12,133.50 | ||
Depreciation Tax savings | 8,000 | 8,000 | 8,000 | ||
b | Total Cash flow from Operations | 20,134 | 20,134 | 20,134 | |
Terminal Cash fow | |||||
Return of NWC | 1,000 | ||||
c | Total Terminal Cash flow | 1,000 | |||
d | Total Free Cash flow from Project =a+b+c | (61,000) | 20,134 | 20,134 | 21,134 |
e | PV factor @WACC 10%=1/1.10^n | 1 | 0.9091 | 0.8264 | 0.7513 |
f | PV of FCF =d*e= | (61,000) | 18,303 | 16,639 | 15,878 |
g | NPV =Sum of PV of FCF = | (10,179.65) |
NPV with full sales | 26,716.53 |
NPV with 45% reduced sales | (10,179.65) |
Change in NPV = | 36,896.18 |