In: Finance
Projects A and B have first costs of $5000 and $9000, respectively. Project A has net annual benefits of $2500 during each of its 5-year useful life, after which it can be replaced identically. Project B has net annual benefits of $3300 during each year of its 10-year life. Use Present Worth analysis, an interest rate of 30% per year, and a 10-year analysis period to determine which project to select. Please provide the present worth of the best alternative.
(show all equations)
Project A | |||||||||||
Discount rate | 0.3 | ||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Cash flow stream | -5000 | 2500 | 2500 | 2500 | 2500 | -2500 | 2500 | 2500 | 2500 | 2500 | 2500 |
Discounting factor | 1 | 1.3 | 1.69 | 2.197 | 2.8561 | 3.71293 | 4.826809 | 6.274852 | 8.157307 | 10.6045 | 13.78585 |
Discounted cash flows project | -5000 | 1923.077 | 1479.29 | 1137.915 | 875.31949 | -673.323 | 517.9405 | 398.4158 | 306.4737 | 235.749 | 181.3454 |
NPV = Sum of discounted cash flows | |||||||||||
NPV Project A = | 1382.2 | ||||||||||
Where | |||||||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||||||
Discounted Cashflow= | Cash flow stream/discounting factor | ||||||||||
Project B | |||||||||||
Discount rate | 0.3 | ||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Cash flow stream | -9000 | 3300 | 3300 | 3300 | 3300 | 3300 | 3300 | 3300 | 3300 | 3300 | 3300 |
Discounting factor | 1 | 1.3 | 1.69 | 2.197 | 2.8561 | 3.71293 | 4.826809 | 6.274852 | 8.157307 | 10.6045 | 13.78585 |
Discounted cash flows project | -9000 | 2538.462 | 1952.663 | 1502.048 | 1155.4217 | 888.7859 | 683.6815 | 525.9088 | 404.5453 | 311.1887 | 239.3759 |
NPV = Sum of discounted cash flows | |||||||||||
NPV Project B = | 1202.08 | ||||||||||
Where | |||||||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||||||
Discounted Cashflow= | Cash flow stream/discounting factor | ||||||||||
Project A is best as it has higher NPV (present worth)