Homework Problem

Bittergiraffe

New Member
Joined
Mar 17, 2020
Messages
1
Office Version
  1. 365
Platform
  1. 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
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,127,336
Messages
5,624,093
Members
416,011
Latest member
chengkoonwing

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top