In: Finance
Your firm is considering an investment that will cost $920,000 today. The investment will produce cash flows of $450,000 in year 1, $270,000 in years 2, 3 and 4, and $200,000 in year 5. The discount rate that your firm uses for projects of this type is 12%. How much would the NPV change if discount rate increases to 14%?
| 
 $102,774  | 
||
| 
 ($95,214)  | 
||
| 
 $53,373  | 
||
| 
 ($45,813)  | 
| Project | ||||||
| Discount rate | 12.000% | |||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 
| Cash flow stream | -920000.000 | 450000.000 | 270000.000 | 270000.000 | 270000.000 | 200000.000 | 
| Discounting factor | 1.000 | 1.120 | 1.254 | 1.405 | 1.574 | 1.762 | 
| Discounted cash flows project | -920000.000 | 401785.714 | 215242.347 | 192180.667 | 171589.881 | 113485.371 | 
| NPV = Sum of discounted cash flows | ||||||
| NPV Project = | 174283.98 | |||||
| Where | ||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||
| Discount rate | 14.000% | |||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 
| Cash flow stream | -920000.000 | 450000.000 | 270000.000 | 270000.000 | 270000.000 | 200000.000 | 
| Discounting factor | 1.000 | 1.140 | 1.300 | 1.482 | 1.689 | 1.925 | 
| Discounted cash flows project | -920000.000 | 394736.842 | 207756.233 | 182242.309 | 159861.675 | 103873.733 | 
| NPV = Sum of discounted cash flows | ||||||
| NPV Project = | 128470.79 | |||||
| Where | ||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||
change in NPV = newNPV-oldNPV = 128470.79 - 174283.98 = -45813