Question

In: Finance

Jaide and Jim plan to send their daughter Sarah (currently 7-year old) to university at the...

Jaide and Jim plan to send their daughter Sarah (currently 7-year old) to university at the age of 18 for a 4-year undergraduate program in Ontario Tech. University. They intend to invest ANNUALLY in a GIC account, which pays 3.5% interest per year. That is, the first annual deposit occurs today (i.e. 7th birthday) until she turns 17. The university tuition currently is $8,000 per year. It is estimated that the tuitions grow at the inflation rate (2% per year). Tuitions will be paid at the beginning of each year (i.e. when Sarah is 18,19,20, and 21). Assume there is no tax to be paid on the account upon withdrawal. How much should the parents save each year to be able to fully fund their daughter’s university tuition expenses?

Solutions

Expert Solution

Fees currently-T7 $ 8,000
Inflation rate per annum 2%
Fees at T18 8000*(1+2%)^11 $ 9,946.99
Fees at T19 8000*(1+2%)^12 $10,145.93
Fees at T20 8000*(1+2%)^13 $10,348.85
Fees at T21 8000*(1+2%)^14 $10,555.83
Lets compute the PV of these fees payments at T17.
PV factor, 1/(1+3.5%)^t PV= Payment * PV factor
Fees at T18 $         9,946.99           1.000 $ 9,946.99
Fees at T19 $       10,145.93           0.966 $ 9,802.84
Fees at T20 $       10,348.85           0.934 $ 9,660.77
Fees at T21 $       10,555.83           0.902 $ 9,520.75
Total PV $38,931.35
So now lets make an annuity so that the future value of annuity is $ 38,931.35
FV of annuity due
P = PMT x ((((1 + r) ^ n) - 1) / r)*(1+r)
Where:
P = the future value of an annuity stream $38,931.35
PMT = the dollar amount of each annuity payment To be computed
r = the effective interest rate (also known as the discount rate) 3.50%
n = the number of periods in which payments will be made 11
38931.35= PMT x ((((1 + r) ^ n) - 1) / r)*(1+r)
38931.35= PMT * ((((1 + 3.5%) ^ 11) - 1) / 3.5%)*(1+3.5%)
Each payment= 38931.35/ (((((1 + 3.5%) ^ 11) - 1) / 3.5%)*(1+3.5%))
Each payment= $ 2,862.19

Related Solutions

Collin and Devonte plan to send their son to university. To pay for this they will...
Collin and Devonte plan to send their son to university. To pay for this they will contribute equal monthly payments to an account bearing interest at an annual rate of 6.7%, compounded monthly. They will make these payments for 12 years.  Five years after their last contribution, they will begin the first of 60 monthly withdrawals of $3,830 to pay the university's installment bills. How large must their monthly contributions be?
It is 2017. My 2-year old daughter wants to go to Harvard (a private U.S. university)...
It is 2017. My 2-year old daughter wants to go to Harvard (a private U.S. university) starting in 2033 (in 16 years’ time). The tuition fee is estimated to be $250,000. How much do I need to put aside starting one month from today and at the end of every one month until I have $250,000 saved up to pay her tuition fees in 2033? Assume I can earn 1% interest per month in my investment account. Please round your...
It is 2017. My 2-year old daughter wants to go to Harvard (a private U.S. university)...
It is 2017. My 2-year old daughter wants to go to Harvard (a private U.S. university) starting in 2033 (in 16 years’ time). The tuition fee is estimated to be $250,000. How much do I need to put aside starting one month from today and at the end of every one month until I have $250,000 saved up to pay her tuition fees in 2033? Assume I can earn 1% interest per month in my investment account. Please round your...
In 2020, Dr. Chen’s daughter is 7-year old, and Dr. Chen is planning for his daughter’s...
In 2020, Dr. Chen’s daughter is 7-year old, and Dr. Chen is planning for his daughter’s college fund. He expects his daughter to start her college education at the age of 18, which is 11 years from now. The expected cost of tuition only for a 4-year college education in 2032 is $94,800 at a public, in-state university. The college fund is invested to gain investment returns. Dr. Chen is considering two investment options. The first is a mutual fund...
A mother and her 15 year old daughter come into the ER because the daughter is...
A mother and her 15 year old daughter come into the ER because the daughter is feeling extremely sick. When the mother leaves the daughter confides in you, the doctor, that she is sexually active. Her pregnancy test comes up positive. She begs you not to tell her mother. 1.) What are the possible courses of action 2.) Evaluate and compare these options from a utilitarian perspective.
Camille Sikorski was divorced last year. She currently provides a home for her 15-year-old daughter, Kaly,...
Camille Sikorski was divorced last year. She currently provides a home for her 15-year-old daughter, Kaly, and 18-year-old son, Parker. Both children lived in Camille’s home, which she owns, for the entire year, and Camille paid for all the costs of maintaining the home. She received a salary of $55,000 and contributed $4,200 of it to a qualified retirement account (a for AGI deduction). She also received $6,000 of alimony from her former husband. Finally, Camille paid $2,700 of expenditures...
Camille Sikorski was divorced last year. She currently provides a home for her 15-year-old daughter Kaly....
Camille Sikorski was divorced last year. She currently provides a home for her 15-year-old daughter Kaly. Kaly lived in Camille’s home for the entire year, and Camille paid for all the costs of maintaining the home. She received a salary of $107,500 and contributed $6,400 of it to a qualified retirement account (a for AGI deduction). She also received $16,500 of alimony from her former husband. Finally, Camille paid $17,400 of expenditures that qualified as itemized deductions. Use 2018 standard...
Camille Sikorski was divorced in 2018. She currently provides a home for her 15-year-old daughter Kaly.
Camille Sikorski was divorced in 2018. She currently provides a home for her 15-year-old daughter Kaly. Kaly lived in Camille’s home for the entire year, and Camille paid for all the costs of maintaining the home. Camille received a salary of $90,000 and contributed $5,600 of it to a qualified retirement account (a for AGI deduction). She also received $13,000 of alimony from her former husband (per divorce decree issued in 2018). Finally, Camille paid $16,700 of expenditures that qualified...
Camille Sikorski was divorced in 2017. She currently provides a home for her 15-year-old daughter Kaly....
Camille Sikorski was divorced in 2017. She currently provides a home for her 15-year-old daughter Kaly. Kaly lived in Camille’s home for the entire year, and Camille paid for all the costs of maintaining the home. She received a salary of $105,000 and contributed $6,300 of it to a qualified retirement account (a for AGI deduction). She also received $16,000 of alimony from her former husband (per divorce decree issued in 2017). Finally, Camille paid $17,300 of expenditures that qualified...
Camille Sikorski was divorced in 2016. She currently provides a home for her 15-year-old daughter, Kaly....
Camille Sikorski was divorced in 2016. She currently provides a home for her 15-year-old daughter, Kaly. Kaly lived in Camille’s home, which she owns, for the entire year, and Camille paid for all the costs of maintaining the home. She received a salary of $52,500 and contributed $4,100 of it to a qualified retirement account (a for AGI deduction). She also received $5,500 of alimony from her former husband.   Finally, Camille paid $2,600 of expenditures that qualified as itemized deductions....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT