In: Finance
Given the following two mutually exclusive project, calculate the equivalent annual annuity for Project B. Assume a required rate of return of 12%. (Round to 2 decimals)
Year | Project A | Project B |
0 | -500 | -600 |
1 | 320 | 300 |
2 | 320 | 300 |
3 | 320 | 300 |
4 | 300 |
Discount rate | 12.0000% | ||
Cash flows | Year | Discounted CF= cash flows/(1+rate)^year | Cumulative cash flow |
(600.00) | 0 | (600.00) | (600.00) |
300.000 | 1 | 267.86 | (332.14) |
300.000 | 2 | 239.16 | (92.98) |
300.000 | 3 | 213.53 | 120.55 |
300.000 | 4 | 190.66 | 311.20 |
NPV of B = 311.20
PV = 311.20, FV = 0, N = 4, rate = 12%
use PMT function in Excel
EAA = 102.46