In: Finance
You are given three investment alternatives to analyze. The cash flows from these three investments are as follows:
| End of year | a | b | c |
| 1 | $1,000 | $2,000 | $6,000 |
| 2 | 2,000 | 2,000 | 6,000 |
| 3 | 3,000 | 2,000 | (6,000) |
| 4 | (4,000) | 2,000 | (6,000) |
| 5 | 4,000 | 5,000 | 16,000 |
What is the present value of each of these three investments if the appropriate discount rate is 9 percent?
| Inv a | ||||||
| Discount rate | 0.09 | |||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 |
| Cash flow stream | 0 | 1000 | 2000 | 3000 | -4000 | 4000 |
| Discounting factor | 1 | 1.09 | 1.1881 | 1.295029 | 1.4115816 | 1.538624 |
| Discounted cash flows project | 0 | 917.4312 | 1683.36 | 2316.55 | -2833.701 | 2599.726 |
| NPV = Sum of discounted cash flows | ||||||
| NPV Inv a = | 4683.37 | |||||
| Where | ||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||
| Inv b | ||||||
| Discount rate | 0.09 | |||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 |
| Cash flow stream | 0 | 2000 | 2000 | 2000 | 2000 | 5000 |
| Discounting factor | 1 | 1.09 | 1.1881 | 1.295029 | 1.4115816 | 1.538624 |
| Discounted cash flows project | 0 | 1834.862 | 1683.36 | 1544.367 | 1416.8504 | 3249.657 |
| NPV = Sum of discounted cash flows | ||||||
| NPV Inv b = | 9729.1 | |||||
| Where | ||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||
| Inv c | ||||||
| Discount rate | 0.09 | |||||
| Year | 0.00% | 1 | 2 | 3 | 4 | 5 |
| Cash flow stream | 0 | 6000 | 6000 | -6000 | -6000 | 16000 |
| Discounting factor | 1 | 1.09 | 1.1881 | 1.295029 | 1.4115816 | 1.538624 |
| Discounted cash flows project | 0 | 5504.587 | 5050.08 | -4633.1 | -4250.551 | 10398.9 |
| NPV = Sum of discounted cash flows | ||||||
| NPV Inv c = | 12069.92 | |||||
| Where | ||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||