In: Finance
|
Net present value. Independent projects Using a 14% cost of capital, calculate the net present value for each of the independent projects shown in the following table, and indicate whether each is acceptable. |
|||||||||||||
| Project A | Project B | Project C | Project D | Project E | |||||||||
| Initial investment | $26,000 | $500,000 | $170,000 | $950,000 | $80,000 | ||||||||
| Year | Cash inflows | ||||||||||||
| 1 | $4,000 | $100,000 | $20,000 | $230,000 | $ 0 | ||||||||
| 2 | 4,000 | 120,000 | 19,000 | 230,000 | 0 | ||||||||
| 3 | 4,000 | 140,000 | 18,000 | 230,000 | 0 | ||||||||
| 4 | 4,000 | 160,000 | 17,000 | 230,000 | 20,000 | ||||||||
| 5 | 4,000 | 180,000 | 16,000 | 230,000 | 30,000 | ||||||||
| 6 | 4,000 | 200,000 | 15,000 | 230,000 | 0 | ||||||||
| 7 | 4,000 | 14,000 | 230,000 | 50,000 | |||||||||
| 8 | 4,000 | 13,000 | 230,000 | 60,000 | |||||||||
| 9 | 4,000 | 12,000 | 70,000 | ||||||||||
| 10 | 4,000 | 11,000 | |||||||||||
| Project D | |||||||||||||
| Discount rate | 14% | ||||||||||||
| Number of years | 8 | ||||||||||||
| CF0 | -$950,000 | ||||||||||||
| CF1-8 | $230,000 | ||||||||||||
| PV of cash inflows | |||||||||||||
| NPV of project D | |||||||||||||
| The project will be | |||||||||||||
| Project E | |||||||||||||
| Discount rate | 14% | ||||||||||||
| CF0 | -$80,000 | ||||||||||||
| CF1 | $ 0 | ||||||||||||
| CF2 | $ 0 | ||||||||||||
| CF3 | $ 0 | ||||||||||||
| CF4 | $20,000 | ||||||||||||
| CF5 | $30,000 | ||||||||||||
| CF6 | $ 0 | ||||||||||||
| CF7 | $50,000 | ||||||||||||
| CF8 | $60,000 | ||||||||||||
| CF9 | $70,000 | ||||||||||||
| PV of cash inflows | |||||||||||||
| NPV of project E | |||||||||||||
| The project will be |

Only Project D and E is acceptable as its npv is positive

please ask if any query. Only Project D and E is acceptable as its npv is positive