Question

In: Finance

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 5% each year. Assuming that the parents have already made the deposit for their daughter's 18th birthday, what is the amount available for college tuition?

Solutions

Expert Solution

We can excel worksheet to solve this question as shown in the below table:

Annual deposit is increasing 5% every year. first deposit will be $2,000 and will earn interest for 17 years. second deposit will be $2,000*1.07 (including 5% increase) and will earn interest for 16 years. same way annual deposit will keep increasing by 5% and will earn interest by less than a year than previous deposit. so third deposit will earn interest for 15 years and so on. on the deposit made on 18th birthday, no interest will be earned on 18th year. interest on 18th deposit will be earned on 19th year.

the amount available for college tuition is $97,331.30.

Years Annual deposit Total value of deposit including interest
1 $2,000.00 $6,317.63
2 $2,100.00 $6,199.54
3 $2,205.00 $6,083.66
4 $2,315.25 $5,969.95
5 $2,431.01 $5,858.36
6 $2,552.56 $5,748.86
7 $2,680.19 $5,641.41
8 $2,814.20 $5,535.96
9 $2,954.91 $5,432.48
10 $3,102.66 $5,330.94
11 $3,257.79 $5,231.30
12 $3,420.68 $5,133.52
13 $3,591.71 $5,037.56
14 $3,771.30 $4,943.40
15 $3,959.86 $4,851.00
16 $4,157.86 $4,760.33
17 $4,365.75 $4,671.35
18 $4,584.04 $4,584.04
Total $56,264.77 $97,331.30

Formulas and calculation


Related Solutions

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 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 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. 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...
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...
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...
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...
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