
Annual Report
Docs + Word6 pages
FeaturedFree
College prices rise faster than most household budgets, so today's price is a poor guide for a child who enrolls in a decade. This projector grows the cost for you. The Costs tab holds one year of tuition, room and board, books, transportation and personal costs in today's dollars, each with its own yearly increase. On the Child tab you list each child with an age, the age at enrollment, the years of study, the amount saved so far, a monthly deposit and a return.
The Projection tab prices each year of study at the time it will be paid, adds the four years, projects your savings to the enrollment date and shows the amount still to find and the share covered. A chart compares cost and savings child by child. The sample family has three children at ages seven, four and one, so the gap is wider for the youngest, who enrolls later and has had less time to save.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Child tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Nobody knows. The sheet takes today's costs and grows each cost line by the yearly increase you choose, so you can test a range of what the price might be when your child enrolls.
It depends on the cost you expect, the time left and the share you want to cover. Change the monthly amount on the Child tab until the share covered reaches your goal.
No. Aid and scholarships are unknown until a child applies, so the sheet shows the full cost. Subtract any expected aid from the cost lines if you want a net figure.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free