Answer:
$11,845,000
Step-by-step explanation:
there are two ways to calculate the value, the first one is using an excel spreadsheet and the other one is by using the growing annuity formula:
the excel spreadsheet is relatively easy to use (use NPV function), so I'll focus on the growing annuity formula:
PV = [P / (r - g)] x {1 - [(1 + g) / (1 + r)]ⁿ}
- P = $1,000,000
- g = 3%
- r = 7%
- n = 17
PV = [$1,000,000 / (7% - 3%)] x {1 - [(1 + 3%) / (1 + 7%)]¹⁷}
PV = ($1,000,000 / 4%) x [1 - (1.03 / 1.07)¹⁷]
PV = $25,000,000 x (1 - 0.5232)
PV = $25,000,000 x 0.4738 = $11,845,000