Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Ten Commandments To A Financial Healing

Authors: Ms. Kemberley J Washington

1st Edition

1499607261, 978-1499607260

More Books

Students also viewed these Finance questions