John and Jackie have 2 children ages 3 and 5. The current annual cost of college...

John and Jackie have 2 children ages 3 and 5. The current annual cost of college is $25,000. The children will begin college at age 18 and be in college for 4 years. Education inflation is expected to be 6% and the parent’s portfolio rate of return is 10%. What would be the lump sum amount the parents need to set aside today to invest for their children’s education?

$97,256
$112,812
$149,752
$149,961

Solutions

Expert Solution

for the child aged 3 years, it will start its college when it turns 18 , or 15 years from now. Its 2nd year at college is 16 years from now, 3rd year- 17 years from now and 4th year 18 years from now.

for the child aged 5 years, it will start its college when it turns 18 , or 13 years from now. its 2nd year at college is 14 years from now, 3rd year- 15 years from now and 4th year 16 years from now.

we need to adjust for the inflation- and project how much the college fee will be in each of the above years

FV = PV X (1+r )ⁿ here r is the inflation rate

This gives the college fee to be incurred in future. But we need the amount to be set aside today. It will be the PV of these amounts

PV = FV / (1+r)ⁿ here r is the rate of return on investment

accordingly,

excel formulas

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Steve and Rebecca have 2 small children ages 3 and 4. They have moved to the...

Steve and Rebecca have 2 small children ages 3 and 4. They have moved to the suburbs and bought a house to provide enough space for their kids to run around and burn energy so that they have time to binge watch their TV shows. They have a sizable mortgage of $720,000 on the home. They earn a combined take home salary of $225,000. They want their kids to pursue post-secondary education but don’t expect either of the children will...

What is the present value of the cost of college education for 4 children ages 1,...

What is the present value of the cost of college education for 4 children ages 1, 3, 5, and 7. The current cost of college is $25,000. The children will begin college at age 18 and be in college for 4 years. Education inflation is expected to be 6% and the parents portfolio rate of return is 8%.

A.C Neilson reported that children between the ages of 2 and 5 watch an average of...

A.C Neilson reported that children between the ages of 2 and 5 watch an average of 25 hours of television per week. Assume that the variable is normally distributed and the standard deviation is 3 hours. If 20 children between the ages of 2 and 5 are randomly selected, find the probability that the mean of the numbers of hours they watch television will be greater than 26.3 hours.

The Jameson family have three young children, ages 8, 6 & 2. They live in a...

The Jameson family have three young children, ages 8, 6 & 2. They live in a home in an urban area adjacent to a local construction company. The construction company owns multiple construction vehicles, including several back hoes. The property is gated and fenced and there are "NO TRESPASSING" signs posted throughout the property. One day, the Jameson's 8 year old daughter managed to climb through a hole in the company's fence to play on the property. While there, she...

Renee and Karl have been married for six years, and have two active children, ages 2...

Renee and Karl have been married for six years, and have two active children, ages 2 and 5. The kids keep both parents busy, chasing the kids around and, recently, preparing the oldest child for kindergarten. In addition, both Renee and Karl work full time, so there isn’t a lot of free time to do things that are important to their health, like see the doctor for regular physicals. Both are healthy, so they haven’t been too worried. Renee went...

Bob has 3 children, ages 2, 6 and 8. He would like to pay for their...

Bob has 3 children, ages 2, 6 and 8. He would like to pay for their education at a public college, four years for each child beginning at age 18. The annual cost of education is currently $18,000 and has been increasing at 5% and is expected to continue. If his savings for their education expenses will earn 8.5%, a) What is the NPV of their college educations? b)Bob plans to save for their education expenses over the next 10...

Mike (age 40) and Molly (age 38) are married and have three children ages 5, 10,...

Mike (age 40) and Molly (age 38) are married and have three children ages 5, 10, and 13. Their salaries for the year amounted to $91,375 and they received $3,750 of taxable interest income. Mike and Molly’s deductions for adjusted gross income amounted to $3,150, and their itemized deductions were $13,250. Mike and Molly file a joint income tax return for 2017. Calculate the following amounts (answer each question independently from all other questions): A.Adjusted gross income (AGI). Show the...

2. You are currently saving for your child's college education. The current cost of college is...

2. You are currently saving for your child's college education. The current cost of college is $10,000 a year. You expect that college costs will continue to increase at a rate of 5 percent a year. Your child is scheduled to begin attending a four-year college 10 years from now (i.e., college payments will be made at t=10, t=11, t=12, and t=13). You currently have $25,000 in an account which earns 6 percent after taxes. You would like to have...

Mrs. B is a 34-year-old woman with 3 children between the ages of 5-12. She works...

Mrs. B is a 34-year-old woman with 3 children between the ages of 5-12. She works full time and brings her children to various extracurricular activities after work. She is on the run a lot. She has just been diagnosed with GERD. Her Doctor is also concerned about her weight gain of 15#over the past year. She is 5'5" and weights 188#. She reports that she sometimes does not have time to pack her lunch, so she goes out to...

Julian, age 27 has 2 children, ages 4 and 3, from his firstmarriage. He is...

Julian, age 27 has 2 children, ages 4 and 3, from his first marriage. He is now married to Margaret. The children live with their mother, Alice. Julian and Margaret each make $26,000 per year and have recently bought a house for $100,000, with a $95,000 mortgage. They have the following life, health, and disability insurance coverage:Policy APolicy BPolicy CInsuredJulianJulianMargaretFace Amount250,00078,00020,000Type20 year level termGroup termGroup termAnnual Premium$250$156$50Who pays premiumTrusteeEmployerEmployerBeneficiaryTrusteeAliceJulianPolicy ownerTrustJulianMargaretHealth Insurance: Julian and Margaret are covered under Julian’s employer plan,...

Subjects