Ask Question
BusinessBusiness
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
You Might be Interested in
To start work every day, David sits down and sets his goals for the day and then he decides how to achieve them, formulating future courses of action to achieve the specified results. This is the definition of planning. True / False.
Answers (1)
Suppose chips and salsa are complements. An increase in the price of salsa will cause: A. An upward movement along the demand curve for salsa. B. A leftward shift of the demand curve for salsa. C. A leftward shift of the demand curve for chips. D.
Answers (1)
Workhorse Air Crane Corporation employs aircraft mechanics, computer programmers, outside salespersons, and professionals, including pilots.
Answers (1)
A brief overview of your company's strengths, weaknesses, opportunities, and threats is called a branding strategy. financial evaluation. paranoid scenario. situational analysis.
Answers (2)
You need a 30-year, fixed-rate mortgage to buy a new home for $335,000. Your mortgage bank will lend you the money at an APR of 6.3 percent for this 360-month loan.
Answers (1)
New Questions in Business
You would advise a client that's launching a new product line to advertise on the google display network because she can:
Answers (1)
Which statement is generally TRUE? Private markets overprovide public goods. Private markets underprovide public goods. Private markets provide the socially optimal amount of public good.
Answers (1)
When opening a checking account, the bank does not run an account verification if you provide a state-issued ID.
Answers (1)
According to the case, the digital tabloid market is at which stage of the product life cycle?
Answers (1)
Which tab in the Group Policy Results window shows all events in Event Viewer that are generated by group policies, and can be used to view the relevant information on a remote computer?
Answers (1)
Home » Business » 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
Sign Up Forgot Password?