Question

In: Finance

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 14 years from today and the other will begin 16 years from today. You estimate your children’s college expenses to be $38,000 per year per child, payable at the beginning of each school year. The appropriate interest rate is 6.8 percent. Your deposits begin one year from today. You will make your last deposit when your oldest child enters college. Assume four years of college for each child. How much money must you deposit in an account each year to fund your children’s education?

Solutions

Expert Solution

Present value of college expenses need to be computed first. Here n = 4, I/Y = 6.8% and PMT = 38,000.

Thus PV = 129,297.32

I have solved the PV using the PV function in excel and the syntax: PV (6.8%, 4, 38000)

Next we find cost today of oldest child’s expenses. Here n = 13, I/Y = 6.8% and FV = 129,297.32. So again PV function will be used and syntax will be: PV(6.8%, 13,, 129297.32). The value will be $54,974.75

Next we find the cost today of second child’s expenses. Here n = 15, I/Y = 6.8% and FV = 129,297.32. So again PV function will be used and syntax will be: PV(6.8%, 15,, 129297.32). The value will be $48,197.08

Thus total cost today = $54,974.75 + $48,197.08 = $103,171.83

So money to be deposited in an account each year to fund your children’s education will be computed using the following: n = 14, I/Y = 6.8%, PV = $103,171.83. We need to compute PMT.

In excel put the following formula: PMT(6.8%, 14, 103171.83)

= $11,656.08

Thus you need to put $11,656.08 in an account each year to fund the education of your child.


Related Solutions

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 in 7 years, and another in 10 years. You estimate your first child’s college expenses to be $30,000 per year, paid at the beginning of each college year (first payment is at year 7 and so on). You estimate your second child’s college expenses to be $50,000 per year, paid at the beginning of each college year (first...
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 21,000$ per year per child, payable at the beginning of each school year. It takes four years to graduate. The annual interest is 15%. How much money must you deposit in an account each year to fund...
You are saving for the college eduction of your two children. They are two years apart...
You are saving for the college eduction of your two children. They are two years apart in age; one will begin college 17 years from today and other child will begin in 19 years from today. You estimate the college expenses to be $40000 per year per child. Given r = 8% EAR. College expenses are paid at the beginning of each school year. How much money must you deposit in an account each year to fund your children's education?...
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...
You are currently saving for your child's college education. The current cost of college is $10,000...
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 all...
You are saving for your child's college education. You plan on making a total of six...
You are saving for your child's college education. You plan on making a total of six tuition payments each one-year apart (college plus a masters program). The annual estimated tuition payment will be made 14-years from today (at t=14), and you estimate that payment will be $50,000. The remaining five-payments will be made from t=15 to t=19. You decide to make 15 yearly contributions into an investment account. The first contribution is made today (t=0) and your last contribution will...
You are saving for your child's college education. You plan on making a total of six...
You are saving for your child's college education. You plan on making a total of six tuition payments each one-year apart (college plus a masters program). The annual estimated tuition payment will be made 14-years from today (at t=14), and you estimate that payment will be $50,000. The remaining five-payments will be made from t=15 to t=19. You decide to make 15 yearly contributions into an investment account. The first contribution is made today (t=0) and your last contribution will...
You want to start saving for your son's college education. You will need $150,000 in 10...
You want to start saving for your son's college education. You will need $150,000 in 10 years. You can earn 6% compounded annually. How much do you need to invest today to pay for the entire education?
You decided to start saving for your son's education and openeda college investment account. Assume...
You decided to start saving for your son's education and opened a college investment account. Assume that the account earns an 8% interest rate annually. You are planning on making $4,000 annual deposits to the account at the beginning of each of the next 10 years, with the first deposit to the account today. What will be the value of the savings account 10 years from today?Group of answer choices$ 49,680$ 65,903$ 57,946$ 60,873$ 52,365$ 62,582
You are saving for your child's education since you did not participate in the Texas Tomorrow...
You are saving for your child's education since you did not participate in the Texas Tomorrow Fund. Your child is five-year-old today. Starting next quarter, you will deposit $300 every quarter until you child turns 17. Your last payment will be on his 17th year. You can to withdraw $X very year starting his 18th birthday for 4 years, first payment on his 18th birthday. Assuming you have investing your money in an account is provides 12% return and the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT