Bittergiraffe
New Member
- Joined
- Mar 17, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
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 child’s 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
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
