Reference no: EM132946147

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 on campus) for UNLV is about $25,296 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.

Problem 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.)

Problem 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%.