Ask Question
3 June, 21:47

Jack and Jill have just had their first child. If college is expected to cost $150 comma 000 per year in 18 years, how much should the couple begin depositing annually at the end of the next 18 years to accumulate enough funds to pay 1 year of tuition 18 years from now

+5
Answers (1)
  1. 4 June, 00:56
    0
    The below is missing from the question:

    Assume that they can earn 6% annual rate of return on their investment.

    $4,853.48

    Explanation:

    The amount the couple should begin depositing can be determined using the pmt formula in excel as follows:

    =-pmt (rate, nper, pv, fv)

    rate is the 6% annual rate of return on their investment

    nper is 18 years

    pv is the present worth of the tuition fee which is unknown

    fv is the amount of tuition required 18 years from now

    =-pmt (6%,18,0,150000)

    =$4,853.48
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Jack and Jill have just had their first child. If college is expected to cost $150 comma 000 per year in 18 years, how much should the ...” in 📘 Business if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers