Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The average cost of a college education is $40,000 per year and private college costs are increasing at an annual rate of 3% per year.

The average cost of a college education is $40,000 per year and private college costs are increasing at an annual rate of 3% per year. Write a spreadsheet that allows a user to enter the childs age today, the age at which they will enter college and an annual return on investment. Assume tuition is paid once a year at the beginning of the year (If your child is born today and starts college at 18, they will start college exactly 18 years from now and will pay tuition 18, 19, 20, and 21 years from now respectively) and that tuition costs continue to rise while they are in college. Assume graduation in 4 years. The spreadsheet should return expected tuition plus how much you would need to save monthly to afford college. (Assume college costs increase annually, but savings (or investment) compounds monthly. You make your first investment one month from today, and the last one month before your last tuition payment) (On this spreadsheet I should be able to vary the inputs and the spreadsheet should recalculate automatically and correctly) I understand how to calculate the growth, as well as the monthly amount needed, but how would I create functions so that age and interest rate can be variable inputs? Thank you

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_2

Step: 3

blur-text-image_3

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

Handbook Of Safeguarding Global Financial Stability Political Social Cultural And Economic Theories And Models

Authors: Gerard Caprio

1st Edition

0123978750, 0123978785, 9780123978752, 9780123978783

More Books

Students also viewed these Finance questions

Question

5. What is a learning curve and how can it be used?

Answered: 1 week ago