In: Finance
NPV and maximum return A firm can purchase new equipment for a $20,500 initial investment. The equipment generates an annual after-tax cash inflow of $5,000 for 7 years.
a. Determine the net present value (NPV) of the asset, assuming that the firm has a cost of capital of 11%. Is the project acceptable?
b. Determine the maximum required rate of return that the firm can have and still accept the asset.
a
| Discount rate | 11.000% | |||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 
| Cash flow stream | -20500 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 
| Discounting factor | 1.000 | 1.110 | 1.232 | 1.368 | 1.518 | 1.685 | 1.870 | 2.076 | 
| Discounted cash flows project | -20500.000 | 4504.505 | 4058.112 | 3655.957 | 3293.655 | 2967.257 | 2673.204 | 2408.292 | 
| NPV = Sum of discounted cash flows | ||||||||
| NPV Project = | 3060.98 | |||||||
| Where | ||||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||||
b
| IRR is the rate at which NPV =0 | ||||||||
| IRR | 15.49% | |||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 
| Cash flow stream | -20500.000 | 5000.000 | 5000.000 | 5000.000 | 5000.000 | 5000.000 | 5000.000 | 5000.000 | 
| Discounting factor | 1.000 | 1.155 | 1.334 | 1.540 | 1.779 | 2.055 | 2.373 | 2.740 | 
| Discounted cash flows project | -20500.000 | 4329.385 | 3748.715 | 3245.926 | 2810.573 | 2433.611 | 2107.208 | 1824.583 | 
| NPV = Sum of discounted cash flows | ||||||||
| NPV Project = | 0.000 | |||||||
| Where | ||||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||||
| IRR= | 15.49% = max rate | |||||||