Question

A professor has two daughters that he hopes will one day go to college. Currently, in-state...

A professor has two daughters that he hopes will one day go to college. Currently, in-state students at the local University pay about $21,576.00 per year (all expenses included). Tuition will increase by 3.00% per year going forward. The professor's oldest daughter, Sam, will start college in 16 years, while his youngest daughter, Ellie, will begin in 18 years. The professor is saving for their college by putting money in a mutual fund that pays about 8.00% per year. Tuition payments are at the beginning of the year and college will take 4 years for each girl. (Sam's first tuition payment will be in exactly 16 years) The professor has no illusion that the state lottery funded scholarship will still be around for his girls, so how much does he need to deposit each year in this mutual fund to successfully put each daughter through college. (ASSUME that the money stays invested during college and the professor will make his last deposit in the account when Sam, the OLDEST daughter, starts college.)

Homework Answers

Answer #1

University Fees in 16 years from now= 21576*(1+3%)^16=34623.15

Similarly, Tuition Fees calculation for the following years is given below:

years from now Tuition Fees Total Tuition Fees Discounted Value at 16th year @8% (i.e. Fees/(1+8%)^(year-16)
16 $ 34,623.15 $          34,623.15 $                                                                                                34,623.15
17 $ 35,661.84 $          35,661.84 $                                                                                                33,020.22
18 $ 36,731.70 $          73,463.39 $                                                                                                62,983.02
19 $ 37,833.65 $          75,667.29 $                                                                                                60,067.14
20 $ 38,968.66 $          38,968.66 $                                                                                                28,643.13
21 $ 40,137.72 $          40,137.72 $                                                                                                27,317.05
Total $                                                                                              246,653.70

Please noet that, on 18th and 19th year tuition fees are double as both of his daughter is studying together.

Now, professor's money should grow to the value of $246653.70 on 16th year. Therefore, FV=246653.70, nper=16,rate=8%

So, every year professor has to deposit $7531.36 to get the required tuition fees for their daughters.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A careful father decides to deposit $67.00 every month to fund his daughter’s college education. He...
A careful father decides to deposit $67.00 every month to fund his daughter’s college education. He deposits the money in a fund that pays 4.44% APR. His first deposit will be in one month, and his daughter will start college in 12.00 years. How much money will he have saved for his daughter at the end of the 12.00th year?
A careful father decides to deposit $144.00 every month to fund his daughter’s college education. He...
A careful father decides to deposit $144.00 every month to fund his daughter’s college education. He deposits the money in a fund that pays 6.12% APR. His first deposit will be in one month, and his daughter will start college in 14.00 years. How much money will he have saved for his daughter at the end of the 14.00th year?
You are saving for the college education of your two children. They are two years apart...
You are saving for the college education of your two children. They are two years apart in age; one will begin college 15 years from today and the other will begin 17 years from today. You estimate your children’s college expenses to be $43,000 per year per child, payable at the beginning of each school year. The appropriate interest rate is 7.3 percent. Your deposits begin one year from today. You will make your last deposit when your oldest child...
You are saving for the college education of your two children. They are two years apart...
You are saving for the college education of your two children. They are two years apart in age; one will begin college 13 years from today and the other will begin 15 years from today. You estimate your children’s college expenses to be $39,000 per year per child, payable at the beginning of each school year. The annual interest rate is 7.3 percent. Your deposits begin one year from today. You will make your last deposit when your oldest child...
he wants to have a secure university education for his lovely daughter Daisy. His daughter is...
he wants to have a secure university education for his lovely daughter Daisy. His daughter is now 13 years old. She plans to enroll at the University of Professional Studies, Accra in 5 years, and it should take her 4 years to complete her education. Currently, the cost per year (for everything – her food, clothing, tuition, books, transportation, and so forth) is GH¢ 12,000 per year. This cost is expected to remain constant throughout the four-year university education. The...
You are saving for the college education of your two children. They are two years apart...
You are saving for the college education of your two children. They are two years apart in age; one will begin college 15 years from today and the other will begin 17 years from today. You estimate your children’s college expenses to be $55,000 per year per child, payable at the beginning of each school year. The annual interest rate is 9.2 percent. How much money must you deposit in an account each year to fund your children’s education? Your...
You are saving for the college education of your two children. They are two years apart...
You are saving for the college education of your two children. They are two years apart in age; one will begin college 13 years from today and the other will begin 15 years from today. You estimate your children’s college expenses to be $39,000 per year per child, payable at the beginning of each school year. The annual interest rate is 7.3 percent. Your deposits begin one year from today. You will make your last deposit when your oldest child...
Tim has just had his 45th birthday. He has two children. One will go to college...
Tim has just had his 45th birthday. He has two children. One will go to college 4 years from now and require four year beginning of year payments for college expenses, $18,000, $19,500, $20,500, and $21,500. The other will go to college 9 years from now and require four year beginning of year payments for college expenses, $23,000, $23,500, $24,000, and $24,500. In addition, Tim plans to retire in 20 years. Tim wants to be able to withdraw $100,000 per...
Jimmy and Jane Have Goals Jimmy Johnson is 25 years old. He and his wife Jane...
Jimmy and Jane Have Goals Jimmy Johnson is 25 years old. He and his wife Jane have two children, Emmitt and Patricia, ages 2 and 4 respectively. Jimmy wants to retire in 40 years and build boats. He would like a nice retirement home with some land on a peaceful lake in the mountains of Georgia. Jimmy believes that to purchase a home and lot in 40 years would cost $300,000 in today’s prices. In forty years Jimmy also believes...
In 20XX the stock market crashed and decreased in value by 47%. Jose and John each...
In 20XX the stock market crashed and decreased in value by 47%. Jose and John each had $500,000 in a mutual fund that was now worth $265,000. Jose sold the mutual fund for $265,000 obtaining a taxable loss of $235,000. He took his $265,000 and invested in another fund that had also gone down 47%. His friend John told Jose he was crazy, pouring good money after bad. John pulled out his money and put it in the bank to...