Question

Suppose an individual makes an initial investment of $1,400 in an account that earns 8.4%, compounded monthly, and makes additional contributions of $100 at the end of each month for a period of 12 years. After these 12 years, this individual wants to make withdrawals at the end of each month for the next 5 years (so that the account balance will be reduced to $0). (Round your answers to the nearest cent.) (a) How much is in the account after the last deposit is made? (b) How much was deposited? (c) What is the amount of each withdrawal? (d) What is the total amount withdrawn?

Answer 1

1.
=1400*(1+8.4%/12)^(12*12)+100/(8.4%/12)*((1+8.4%/12)^(12*12)-1)=28544.2842768277

2.
=1400+100*12*12=15800.00

3.
=(1400*(1+8.4%/12)^(12*12)+100/(8.4%/12)*((1+8.4%/12)^(12*12)-1))*(8.4%/12)/(1-1/(1+8.4%/12)^(12*5))=584.254938400207

4.
=(1400*(1+8.4%/12)^(12*12)+100/(8.4%/12)*((1+8.4%/12)^(12*12)-1))*(8.4%/12)/(1-1/(1+8.4%/12)^(12*5))*12*5=35055.2963040124