Question

Jill wishes to provide herself, or her estate, with an income of $10,000 at the end of each year for 10 years. She will make a lump sum deposit when the account is established and add $3000 at the end of each year for 12 years. The income is to start at the end of the year following the year in which the last deposit was made. Compute the lump sum deposit. (All interest rates are 7 Percent Compounded annually

Answer 1

Inputs

Deposit A amount=$10,000

End of year deposits

N=10years

Deposits B amount=$10,000

End of year deposits N= 12years

interest rate= 7%

$\text{Future value}= PMT \times \frac{((1+r)^N-1)}{r}\\ \text{Future value}= PMT \times \frac{((1.07)^{10}-1)}{0.07}\\ \text{Future value}= 138,164.48$

Future value of Deposit B after 12 years

$\text{Future value}= 12,000\times \frac{((1.07)^{12}-1)}{0.07} = 53,665\\$ Future value after 12 years= Future value after 10years x (1+Rate)$^2$

Future value after 12 years =

138,164.48 x (1.07)$^2$

=158,184.51.

Lump sum Deposit = Future value of Deposit A after 12 years + Future value of Deposit B after 12 years.

Lump sum Deposit = 158,184.51+53,665.35

Lump sum Deposit = 211,849.89.