Question

In: Finance

Mizzy Elliott plans to pay her daughter’s tuition for four years starting eighteen (18) years from...

Mizzy Elliott plans to pay her daughter’s tuition for four years starting eighteen (18) years from now. The current annual cost of college is $7,500 and she expects this cost to rise at an annual rate of 5 percent. She assumes that she can earn 6 percent annually in her planning. How much must Missy put aside each year, starting next year, if she plans to make 17 equal payments?

Solutions

Expert Solution

Annual cost of college fees in 18th year = $ 7,500 x (1+0.05)18 = $ 7,500 x (1.05)18

                                                               = $ 7,500 x 2.40661923369108 = $ 18,049.64

Annual cost of college fees in 19th year = $ 7,500 x (1+0.05)19 = $ 7,500 x (1.05)19

                                                               = $ 7,500 x 2.52695019537564 = $ 18,952.13

Annual cost of college fees in 20th year = $ 7,500 x (1+0.05)20 = $ 7,500 x (1.05)20

                                                               = $ 7,500 x 2.65329770514442 = $ 19,899.73

Annual cost of college fees in 21th year = $ 7,500 x (1+0.05)21 = $ 7,500 x (1.05)21

                                                               = $ 7,500 x 2.78596259040164 = $ 20,894.72

Total value of college fees in year 17 = $ 18,049.64/ (1+0.06) + $ 18,952.13/ (1+0.06)2 + $ 19,899.73 (1+0.06)3 + $ 20,894.72 / (1+0.06)4

= $ 18,049.64/ (1.06) + $ 18,952.13/ (1.06)2 + $ 19,899.73/ (1.06)3 + $ 20,894.72 / (1.06)4

= $ 18,049.64/1.06 + $ 18,952.13/ 1.1236 + $ 19,899.73/1.191016+ $ 20,894.72 / 1.26247696

= $ 17,027.9622641509 + $ 16,867.3282306871 + $ 16,708.1970351364 + $ 16,550.5753071327

= $ 67,154.0628371071 or $ 67,154.06

Future value of 17 equal deposits should be $ 67,154.06 which can be computed using formula for FV of annuity as:

FV = P x [(1+r) n – 1/r]

P = FV/ [(1+r) n – 1/r]

P = Periodic deposit

r = Rate per period = 6 %

n = Numbers of periods = 17

P = $ 67,154.06/ [(1+0.06) 17 – 1/0.06]

   = $ 67,154.06/ [(1.06) 17 – 1/0.06]

   = $ 67,154.06/ [(2.69277278576681– 1)/0.06]

= $ 67,154.06/ (1.69277278576681/0.06)

   = $ 67,154.06/ 28.2128797627802

= $ 2,380.26251005375 or $ 2,380.26

Missy must put aside $ 2,380.26 for daughter’s college fees.


Related Solutions

A couple plans to pay their child’s college tuition for 4 years starting 18 years from...
A couple plans to pay their child’s college tuition for 4 years starting 18 years from now. The current annual cost of college is C$7,000, and they expect this cost to rise at an annual rate of 5 percent. In their planning, they assume that they can earn 6 percent annually. How much must they put aside each year, starting next year, if they plan to make 17 equal payments?
A stock will pay no dividends for the next 3 years. Four years from now, the...
A stock will pay no dividends for the next 3 years. Four years from now, the stock is expected to pay its first dividend in the amount of $2.1. It is expected to pay a dividend of $2.9 exactly five years from now. The dividend is expected to grow at a rate of 7% per year forever after that point. The required return on the stock is 12%. The stock's estimated price per share exactly TWO years from now, P2...
A stock will pay no dividends for the next 3 years. Four years from now, the...
A stock will pay no dividends for the next 3 years. Four years from now, the stock is expected to pay its first dividend in the amount of $2.1. It is expected to pay a dividend of $2.9 exactly five years from now. The dividend is expected to grow at a rate of 5% per year forever after that point. The required return on the stock is 14%. The stock's estimated price per share exactly TWO years from now, P2...
Ariana contributed $100 from her pay cheque at the beginning of every month from age 18...
Ariana contributed $100 from her pay cheque at the beginning of every month from age 18 to 65 into an RRSP account (no contribution in the month of her 65th birthday). Macy contributed $4000 at the beginning of every year from age 35 to 55 into a similar RRSP account, then leave the money in the fund to accumulate for another 10 years(no contribution in the year of her 55th birthday). money earned 4.8% compounded daily in both RRSP accounts....
18-In 2019, Elaine paid $3,200 of tuition and $700 for books for her dependent son to...
18-In 2019, Elaine paid $3,200 of tuition and $700 for books for her dependent son to attend State University this past fall as a freshman. Elaine files a joint return with her husband. Elaine’s AGI is $168,000.What is the maximum American opportunity credit Elaine can claim for the tuition payment and books? 19-In 2019, Amanda and Jaxon Stuart have a daughter who is one year old. The Stuarts are full-time students and they are both 23 years old. Their AGI...
john wishes to pay $1000 a year for 3 years, starting 5 years from today. interest...
john wishes to pay $1000 a year for 3 years, starting 5 years from today. interest rates are forecast at 2% compounded monthly over the next two years and 4% compounded monthly there after. how much must he set aside today?
You are considering investment that is going to pay $1,500 a month starting 20 years from...
You are considering investment that is going to pay $1,500 a month starting 20 years from today for 15 years. If you can earn 8 percent return on any investment, compounded monthly, how much at most are you willing to pay for this investment opportunity? Round to the nearest cent. Do not include any unit (If your answer is $111.11, then type 111.11 without $ sign.)
An investment will pay $381 two years from now, $620 four years from now, and $1,842...
An investment will pay $381 two years from now, $620 four years from now, and $1,842 five years from now. You are going to reinvest these cash flows at a rate of 11.19 percent per year. What is the future value of this investment at the end of year five?
Today is Janet’s 23rd birthday. Starting today, Janet plans to begin saving for her retirement. Her...
Today is Janet’s 23rd birthday. Starting today, Janet plans to begin saving for her retirement. Her plan is to contribute $1,000 to a brokerage account each year on her birthday. Her first contribution will take place today. Her 42nd and final contribution will take place on her 64th birthday. Her aunt has decided to help Janet with her savings, which is why she gave Janet $10,000 today as a birthday present to help get her account started. Assume that the...
A client plans to send her child to college starting in the fall of 2038. She...
A client plans to send her child to college starting in the fall of 2038. She estimates that tuition will cost $40,000 per year and that room and board will cost $14,000 per year, with $20,000 payable for tuition and $7,000 payable for room and board on each January 1 and July 1 during the four years in college, starting on July 1, 2038 and ending on January 1, 2042. She can invest in a fund that will pay 6%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT