Finance · real student question

A monthly annuity must accumulate a future value of $85,000 in 17 years at 3.8% APR compounded monthly. How much is deposited in total, and how much is interest?

Question

A fixed amount is deposited every month into an ordinary annuity. The goal is a future value of 85,00085{,}000 after 1717 years, with an APR of 3.8%3.8\% compounded monthly.

Find:

  1. the required monthly deposit,
  2. the total amount actually deposited,
  3. the interest earned.

Step-by-step solution

  1. Set up the future value of an ordinary annuity. Deposits are made at the end of each period, so

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

    where ii is the periodic rate and nn the number of deposits.

  2. Convert the APR to a monthly rate and count the periods. Compounding is monthly, so

    i=0.038120.0031666667,n=17×12=204i = \frac{0.038}{12} \approx 0.0031666667, \qquad n = 17 \times 12 = 204

  3. Solve the formula for PMTPMT. Rearranging,

    PMT=FVi(1+i)n1=850000.0031666667(1.0031666667)2041PMT = FV \cdot \frac{i}{(1+i)^n - 1} = 85000 \cdot \frac{0.0031666667}{(1.0031666667)^{204} - 1}

  4. Evaluate the growth factor. (1.0031666667)2041.905948(1.0031666667)^{204} \approx 1.905948, so the denominator is 0.9059480.905948 and

    PMT850000.00316666670.905948297.11PMT \approx 85000 \cdot \frac{0.0031666667}{0.905948} \approx 297.11

    The monthly deposit is about \297.11$.

  5. Total the deposits. Over 204204 months,

    297.110626×204=60,610.57297.110626 \times 204 = 60{,}610.57

    Note the unrounded PMTPMT is used here. If the deposit is actually rounded to the cent, \297.11 \times 204 = $60{,}610.44andthebalancelandsafewcentsshortofand the balance lands a few cents short of$85{,}000$.

  6. Subtract to get the interest. The account reaches \85{,}000$, so the interest is the part that was not deposited:

    8500060610.57=24,389.4385000 - 60610.57 = 24{,}389.43

Answer

Deposited: $60,610.57Interest earned: $24,389.43\text{Deposited: } \$60{,}610.57 \quad\text{Interest earned: } \$24{,}389.43

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