Question

In: Accounting

Your new baby was born yesterday. To save for her education, you decide to invest in...

Your new baby was born yesterday. To save for her education, you decide to invest in a 529 plan and will make QUARTERLY contributions until your child enters the great UNLV when she turns 18. That is, you will save for the next 17 years (Or should it be 18 years? Think about it), and the contribution will be made at the END of each quarter. You expect that the 529 plan will return 8.5% per year with quarterly compounding. The current in-state cost (tuition and other expenses, if living with parents) for UNLV is about $20,176 per year, and you expect your child to spend 4 years in college. You expect this cost to go up 4% per year until your child finishes college.

1. How much will you need to save per quarter so that your child will have enough funding for college? (Assume: Tuition payments are made ONCE per year at the BEGINNING of the year. Your 529 plan remains invested until your child finishes college.)


2. Construct a one-way data table to perform a what-if analysis by varying the annual investment return between 5% to 12%, with one-percentage-point increment. That is, how much you need to save each quarter to reach your goal if the investment return varies between 5% and 12%.

Solutions

Expert Solution

rate of increase ==> 4%

Year Amt Required
18 18086.00
19 18809.44
20 19561.82
21 20344.29

Now we use the excel function of =PMT(8.5/4,72,,-D3,0)

=PMT (rate, nper, pv, [fv], [type])

rate = 8.5/4 as compounding quaterly

nper = 18*4 = 72, 76, 80, 84

pv is left

fv= - 18086, -18809.44, -19561.82, -20344.29

type= 0 as investment is made in begining

Rate of Increase 1.04
years 18 Year Amt Required
Factor(qtry comp) 4 18 18086.00 $108.42
Rate Of interest 8.50% 19 18809.44 $112.76
20 19561.82 $117.27
21 20344.29 $121.96
Total Savings $460.41

We sum all the savings desired to get total savings = $ 460.41

2)

ROI Total savings
5% 663.95
6% 599.65
7% 540.38
8% 485.91
9% 436.02
10% 390.47
11% 349.00
12% 311.36

-------------------------------

-------------------------------


Related Solutions

Your new baby was born yesterday. To save for her education, you decide to invest in...
Your new baby was born yesterday. To save for her education, you decide to invest in a 529 plan and will make QUARTERLY contributions until your child enters the great UNLV when she turns 18. That is, you will save for the next 17 years (Or should it be 18 years? Think about it), and the contribution will be made at the END of each quarter. You expect that the 529 plan will return 8.5% per year with quarterly compounding....
Congratulations! Your first baby was born yesterday and is healthy and strong. To guard against your...
Congratulations! Your first baby was born yesterday and is healthy and strong. To guard against your premature death, you want to purchase a life insurance policy that will replace $58,000 of your annual income until your child is 20 years old. How much life insurance should you purchase, if you assume a 3% inflation rate? and please note what formula you used: 1. future value 2. present value annuity 3. future value payment or 4.present value
Your child was just born and you are planning for his/her college education. Based on your...
Your child was just born and you are planning for his/her college education. Based on your wonderful experience in Managerial Economics you decide to send your child to Binghamton University as well. You anticipate the annual tuition to be $60,000 per year for the four years of college. You plan on making equal deposits on your child’s birthday every year starting today, the day of your child’s birth. No deposits will be made after starting college. The first tuition payment...
Your child was just born and you are planning for his/her college education. Based on your...
Your child was just born and you are planning for his/her college education. Based on your wonderful experience in Advanced Finance you decide to send your child to Binghamton University as well. You anticipate the annual tuition to be $50,000 per year for the four years of college. You plan on making equal deposits on your child’s birthday EVERY OTHER YEAR for the ages one through seventeen inclusive to fund his/her education. Assume the first tuition payment is due in...
To save for her newborn son's college education, Lea Wilson will invest $23,000 at the beginning...
To save for her newborn son's college education, Lea Wilson will invest $23,000 at the beginning of each year for the next 12 years. The interest rate is 9 percent. What is the future value? Use Appendix C to calculate the answer. Multiple Choice $504,919. $64,699. $477,410. $527,919.
In order to save money for their daughter's college education, new parents Ashley and John decide...
In order to save money for their daughter's college education, new parents Ashley and John decide to put $325 dollars into a savings account that yields 9.2% interest compounded semi-annually. After making 20 equal payments of $325 they stop making deposits and simply allow the money to grow at the of 9.2% compounded semiannually for 8 more years. How much money will be in the account at the end of this time period?
Jennifer was just born and her parents have decided to save money to pay for her...
Jennifer was just born and her parents have decided to save money to pay for her college education.   They will invest $15,000 right now, and $10,000 each year on her future birthdays for the next 17 years (i.e. $10,000 when she turns 1, 2, 3,   … 16, 17). They are bullish on America and are investing all of this money in the stock market. The principal and returns are allowed to accumulate (i.e. are reinvested) in the equities market and...
When a baby girl is born, her oocytes have begun meiosis but are paused at the...
When a baby girl is born, her oocytes have begun meiosis but are paused at the end of Prophase I. At puberty hormones trigger meiosis to proceed for a few oocytes in each month. At the same time the hormones trigger mitosis for the surrounding follicle cells that support the oocyte. How many chromosomes are present in the developing oocytes of a baby girl?
Jan wants to plan for her daughter’s education. Her daughter, Rachel was born today and will...
Jan wants to plan for her daughter’s education. Her daughter, Rachel was born today and will go to college at age 18 for five years. Tuition is currently $15,000 per year, in today’s dollars. Jan anticipates tuition inflation of 6% and believes she can earn an 10% return on her investment. How much must Jan save at the end of each year, if she wants to make her last payment at the beginning of her daughter’s first year of college?...
in order to save for your child's college education, you want to save $500 every month...
in order to save for your child's college education, you want to save $500 every month for 20 years, starting one month from now. The monthly interest rate on your savings account is 0.8%. How much money will you have in your account in 20 years?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT