Accounts & Finance
"1. Payment at retirement = $275,000
Number of years = 65
To determine whether the policy is worth buying we will compute the future value of all the payments until retirement and compare it with the payoff at retirement.
Since there are two interest rates in two different time periods, first will compute the future value of all the payments until year 6.
Then, the FV of this amount will be computed i.e. 59 (=65-6) years later.
To compute FV, excel function FV(interest rate, number of periods, LEAVE BLANK, -present value or the payment made to policy) will be used.
Here, Interest rate = 11%
Now, compute FV 59 years later using the same excel function with interest rate = 7%
Then FV = $308,437.08
Future value of the payments made exceeds the payoff at retirement.
Therefore, the policy is not worth buying."