# Homework Problem

#### Bittergiraffe

##### New Member
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

### Excel Facts

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

#### dmt32

##### Well-known Member
Hi,
welcome to forum

Probably better to search for existing templates to give some guidance for your assignment

Maybe this one here will get you started:College Savings Calculator for Excel

Dave

Replies
2
Views
209
Replies
12
Views
713
Replies
0
Views
495
Replies
0
Views
241
Replies
28
Views
1K

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.

### Which adblocker are you using?

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

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