Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started