Question

You deposit $13,000 annually into a life insurance fund for the next 10 years, after which time you plan to retire.

a. If the deposits are made at the beginning of the year and earn an interest rate of 6 percent, what will be the amount in the retirement fund at the end of year 10?
b. Instead of a lump sum, you wish to receive annuities for the next 20 years (years 11 through 30). What is the constant annual payment you expect to receive at the beginning of each year if you assume an interest rate of 6 percent during the distribution period?
c. Repeat parts (a) and (b) above assuming earning rates of 5 percent and 7 percent during the deposit period and earning rates of 5 percent and 7 percent during the distribution period.

Answer 1

We will use excel to derive all the 3 situations

Rate	6%	5%	7%
Amount in the fund after 10 years	$181,631.35	$171,688.23	$192,186.79
Annual payment	$14,939.10	$13,120.67	$16,954.27

WORKINGS