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 9%. The parents deposit $2400 on their daughter's first birthday and plan to increase the size of their deposits by 7% each year. Assuming that the parents have already made the deposit for their daughter's 18th birthday, then the amount available for the daughter's college expenses on her 18th birthday is closest to ________.

Solutions

Expert Solution

Answer:- 160462.577

Explanation:- To calculate the amount available on the daughter's 18th birthday the following should be taken into cognizance

First, the yearly deposit increases by 7% every year, therefore year one is $2,400 but year 2 is $2,400 x1.07= $2,568 and continuing like that.

Secondly, the total deposit pre year is calculated as annual deposit for the year x (1+interest rate)∧year on a descending basis.

Following is the excel sheet showing the calculation of the amount available for the daughter's college expenses on her 18th birthday:-

Following is the Formula Sheet of above excel sheet for easy understanding of the formulas used:-  


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...
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?
What advice would you offer prospective parents if they want to insure that their baby has...
What advice would you offer prospective parents if they want to insure that their baby has every chance to be as physically healthy as possible when it is born.
Malcolm and Ainsley Weaver are a dual-career couple who just had their first child. Malcolm, age...
Malcolm and Ainsley Weaver are a dual-career couple who just had their first child. Malcolm, age 30, already has a group life insurance policy, but Ainsley’s employer does not offer a life insurance benefit. A financial planner is recommending that the 27-year-old Ainsley buy a $250,000 whole life policy with an annual premium of $1,670 (assumed rate of earnings of 5% a year). Help Ainsley evaluate this advice and decide on appropriate course of action.  
Suppose a young couple deposits $600 at the end of each quarter in an account that...
Suppose a young couple deposits $600 at the end of each quarter in an account that earns 6.8%, compounded quarterly, for a period of 2 years. After the 2 years, they start a family and find they can contribute only $200 per quarter. If they leave the money from the first 2 years in the account and continue to contribute $200 at the end of each quarter for the next 18 1/2 years, how much will they have in the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT