Finance · real student question

Kevin deposits a fixed monthly amount into an annuity to accumulate a future value of 75,000 dollars in 16 years at an APR of 3.8% compounded monthly. How much will he ultimately deposit, and how much is interest?

Question

Kevin deposits a fixed amount each month into an annuity account to accumulate a future value of \75{,}000inin16years.TheAPRisyears. The APR is3.8%compoundedmonthly.Howmuchofthecompounded monthly. How much of the$75{,}000$ will Kevin ultimately deposit, and how much is interest earned?

Step-by-step solution

  1. Identify the periodic rate and the number of periods. Monthly compounding splits the APR into twelve equal periods:

    i=0.03812=0.0031666667,n=16×12=192i = \frac{0.038}{12} = 0.0031666667, \qquad n = 16 \times 12 = 192

  2. Write the future-value formula and rearrange for PMT. From FV=PMT(1+i)n1iFV = PMT \cdot \dfrac{(1+i)^n - 1}{i},

    PMT=FVi(1+i)n1PMT = FV \cdot \frac{i}{(1+i)^n - 1}

  3. Evaluate the accumulation factor to full precision.

    (1.0031666667)192=1.83499060(1.0031666667)^{192} = 1.83499060

    A truncated value such as 1.8355711.835571 would inflate the denominator and give PMT \approx \284.23about— about20centslow,whichcompoundsintoacents low, which compounds into a$40$ error in the deposit total.

  4. Compute the monthly payment.

    PMT=75000×0.00316666670.83499060=$284.43PMT = 75000 \times \frac{0.0031666667}{0.83499060} = \$284.43

  5. Total the deposits and subtract.

    284.43×192=$54,610.56,7500054610.56=$20,389.44284.43 \times 192 = \$54{,}610.56, \qquad 75000 - 54610.56 = \$20{,}389.44

  6. **Compare with the 17-year, 85,000case.There,85{,}000 case.** There, $297.11amonthovera month over204monthsyieldsmonths yields$24{,}389.56ofinterestalargershare,becausetheextrayearofcompoundingdoesmoreworkthantheextraprincipal.Interestisaboutof interest — a larger share, because the extra year of compounding does more work than the extra principal. Interest is about27.2%ofthebalancehereversusof the balance here versus28.7%$ there.

Answer

PMT=$284.43,total deposited=$54,610.56,interest=$20,389.44PMT = \$284.43, \quad \text{total deposited} = \$54{,}610.56, \quad \text{interest} = \$20{,}389.44

Need to solve a different problem like this? Open the solver →