Question: Please show me how to do this in excel using formulas if possible! 2. (20 points) Suppose that you just had a baby and wish

Please show me how to do this in excel using formulas if possible!
2. (20 points) Suppose that you just had a baby and wish to ensure that enough money will be available to pay for your child's college education. Currently (time=0), college tuition, books, fees, and other cost $25,500 per year. On average, tuition and other costs have historically increased at a rate of 6.5% per year and you expect this growth rate to continue for the foreseeable future. Assume the first college payment is made on your child's 18th birthday (i.e., at time=18). a. Assuming college costs continue to increase an average of 6.5% per year and that all the college savings are invested in an account paying 7% interest, what is the amount of money you will need to have available at age 18 to pay for all four years of your child's undergraduate education? b. How much do you need to save every year until your child's 18th birthday to achieve this goal, assuming you make the first savings payment on your child's first birthday (time=1), the last one on your child's 18 th birthday (time =18 )? Assume you save the same amount every year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
