Question

In: Finance

Suppose that a young couple has just had their first baby and they wish to ensure...

  1. Suppose that a young couple has just had their first baby and they wish to ensure that enough money will be available to pay for their child's college education. Currently, college tuition, books, fees, and other costs, average $12,500 per year. On average, tuition and other costs have historically increased at a rate of 4% per year.

    Assuming that college costs continue to increase an average of 4% per year and that all her college savings are invested in an account paying 7% interest, then the amount of money she will need to have available at age 18 to pay for all four years of her undergraduate education is closest to:

    A) $97,110
    B) $107,532
    C) $101,291
    D) $50,000
    E) None of the above

Solutions

Expert Solution

Current Fees per year = 12500, No of years of college = 18 years, Growth rate tuition and other fees = inflation = 4% per year

College fees after 18 years or at age of 18 = Current college fees x (1+ inflation)18 = 12500 x (1+4%)18 = 12500 x (1.04)18 = 12500 x 2.0258165 = 25322.7065 = 25322.71 (rounded to two decimal places)

Nominal Return earned on savings = 7%

Real return earned on savings during college years or after age of 18 years = (1+Nominal Return earned on savings) / (1+inflation) - 1 = (1+7%)/(1+4%) - 1 = (1.07 / 1.04) - 1 = 1.0288461 - 1 = 0.0288461 = 2.88461%

Real fees for four years of college = College fees after 18 years or at age of 18 = 25322.71 per years

Hence Amount needed at 18 years will equal to present real fees for college for years discounted at real rate of return

Amount needed at 18 years = 25322.71 + 25322.71 / (1+2.88461%) + 25322.71 / (1+2.88461%)2 + 25322.71 / (1+2.88461%)3

Real fees for four years paid at beginning of year forms an annuity due. We can find the present value of annuity due using PV function in excel,

Formula to be used in excel: =PV(rate,nper,-pmt,fv,type)

In the formula type = 1 since payments are made at beginning of year. Since real fees is withdrawn from amount needed at 18 years and after 4th year fees balance of amount accumulated becomes 0, hence fv=0

Using PV function in excel, we get amount of money needed at 18 to pay four year of undergraduate fees = 97110.01= 97110(rounded to nearest whole dollar)

Answer: A) $97110


Related Solutions

Suppose that a young couple has just had their first baby and they wish to ensure...
Suppose that a young couple has just had their first baby and they wish to ensure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 7%. The parents deposit $2000 on their daughter's first birthday and plan to increase the size of their deposits by...
Suppose that a young couple has just had their first baby and they wish to ensure...
Suppose that a young couple has just had their first baby and they wish to ensure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 7%. The parents deposit $2000 on their daughter's first birthday and plan to increase the size of their deposits by...
Suppose that a young couple has just had their first baby and they wish to insure...
Suppose that a young couple has just had their first baby and they wish to insure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 9%. The parents deposit $2400 on their daughter's first birthday and plan to increase the size of their deposits by...
Suppose that a young couple has just had their first baby and they wish to insure...
Suppose that a young couple has just had their first baby and they wish to insure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 7%. The parents deposit $2000 on their daughter's first birthday and plan to increase the size of their deposits by...
Suppose that a young couple has just had a baby boy, and they wish to have...
Suppose that a young couple has just had a baby boy, and they wish to have enough saved to fund four years of college education at a school like UCLA when their son is at the ages of 19-22. Suppose this year’s total expense of an undergraduate student at WashU, including tuition, room and board, books and supplies, amounts to $74,000. This annual cost is expected to grow at 3.5% a year. To simplify the timeline, they assume that all...
Suppose that you just had your first baby, Oprah, and you wish to ensure that enough...
Suppose that you just had your first baby, Oprah, and you wish to ensure that enough money will be available to pay for Oprah's college education. Tuition and other fees today add up to $12,500 per year. Tuition and other costs are expected to increase at a rate of 4 percent per year. Assuming that all of Oprah's college savings are invested in an account paying 7 percent interest, then the amount of money she will need to have available...
A young couple has just had their first child and they decide to make deposits into...
A young couple has just had their first child and they decide to make deposits into an investment account on each of their daughter’s birthdays, starting with her first birthday. Assume that the account will earn an interest rate of 4% p.a. The parents deposit $4,000 on their daughter’s first birthday and plan to increase the size of their deposits by 6% every year. Assuming that the parents make the last deposit on their daughter's 18th birthday, the amount available...
1.A couple just had a baby. How much should they invest now 5.9​%compounded daily in order...
1.A couple just had a baby. How much should they invest now 5.9​%compounded daily in order to have ​$45,000 for the​ child's education 18 years from​ now? Compute the answer to the nearest dollar.​ (Assume a​ 365-day year.) 2.Find the value $20,000 at the end of one year if it is invested in an account that has an interest rate of 5.40% and is compounded in accordance with the rules below. a. compounded monthly b.compounded daily​ (assuming a​ 365-day year)...
A young couple has made a nonrefundable deposit of the first month's rent (equal to $1,000)...
A young couple has made a nonrefundable deposit of the first month's rent (equal to $1,000) on a 6-month apartment lease. The next day they find a different apartment that they like just as wekk, but its monthly rent is only $900. They plan to be in the apartment only six months. Should they switch to the new apartment? What if they plane to stay 1 year? Assume an interest rate of 12%.
Your brother and his wife just had a baby and they are wondering when their baby...
Your brother and his wife just had a baby and they are wondering when their baby will begin talking. They hope soon, and they have begun saying "mama" and "dada" to their baby. What can you tell them about the course of language development during the first year of life?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT