College Cost Planner
Plan college costs by academic year with separate projections for aid and available funding, then see each year's net price and funding gap or surplus.{{ summaryTitle }}
{{ summaryLine }}
| Academic year | Gross cost | Gift aid | Net price | Available funds | Gap | Surplus | Copy |
|---|---|---|---|---|---|---|---|
| {{ row.academic_year }} | {{ formatMoney(row.gross_cost_cents) }} | {{ formatMoney(row.gift_aid_cents) }} | {{ formatMoney(row.net_price_cents) }} | {{ formatMoney(row.available_funding_cents) }} | {{ formatMoney(row.remaining_gap_cents) }} | {{ formatMoney(row.funding_surplus_cents) }} |
The chart renderer is unavailable. The same annual values remain available in the year plan.
| Review item | Current plan | Next check | Copy |
|---|---|---|---|
| {{ row.label }} | {{ row.value }} | {{ row.action }} |
A college price is rarely one number. Published tuition covers only part of the annual budget, while housing, food, books, supplies, transportation, and other education costs can materially change what attendance requires. A useful plan puts every amount on the same academic-year basis before comparing schools or funding choices.
Three terms keep the comparison clear. Gross cost is the sum of the included education costs. Gift aid is grants and scholarships that generally do not need to be repaid. Net price is gross cost minus gift aid. Loans do not reduce net price because they replace when payment happens rather than remove the cost.
- Available funding
- Savings and income reasonably expected to be available for the academic year.
- Funding gap
- The portion of net price not covered by the available funding entered in the plan.
- Surplus
- Available funding above net price for that year. It is not automatically carried into another year.
Later years deserve their own rows because costs and resources do not always change together. Tuition may rise while a fixed scholarship stays flat. Family income may grow, but a one-time savings balance should not be treated as recurring annual funding. Applying one growth assumption to each category makes the effect visible, though it remains a scenario rather than a forecast.
Financial-aid offers also need careful reading. Renewal conditions, enrollment level, residency, housing choice, satisfactory academic progress, and program length can alter later awards. Federal Work-Study must be earned through a job and may not be available when a bill is due, so it should not be treated like an unconditional grant or cash balance.
A funding gap is a planning signal, not a recommendation to borrow that amount. Taxes, loan fees, interest, repayment terms, emergency reserves, cost changes, and expenses outside the chosen categories can change the final decision. Update the plan when an institution publishes a new cost budget or aid offer.
How to Use This Tool:
Build the first academic year from amounts that describe the same student, enrollment period, and institution.
- Enter the First academic year and expected Program length from 1 to 8 years.
- Add tuition and fees, housing and food, books and supplies, transportation, and other education costs on one annual basis. Avoid counting a charge in more than one row.
- Enter Grants and scholarships from the current offer. Include only gift aid and check its renewal conditions before projecting later years.
- Enter Available savings and income only when those funds are expected to be available for each modeled year. Do not enter loans here as if they reduced the price.
- Set separate annual growth rates for costs, gift aid, and available funding. Leave a rate at 0% when there is no documented assumption; accepted rates run from -50% through 50%.
- Review each academic year's gross cost, net price, gap, or surplus. If projected gift aid exceeds gross cost, correct the cost basis or aid amount before using the totals.
Interpreting Results:
The year table matters more than the final total. A four-year gap concentrated in the first year creates a different cash need from the same total spread evenly. Compare each row with the date when bills are due and with the conditions attached to that year's aid.
- Net price equals gross cost minus grants and scholarships; it is never allowed to fall below zero in a valid plan.
- Gap is positive only when net price exceeds available funding. Surplus is positive only in the opposite case, so both are not positive for the same year.
- Growth assumptions compound from the first-year amount. A 3% cost rate does not mean that every school charge will actually rise by 3%.
Technical Details:
All monetary inputs are converted to integer U.S. cents. Each annual category grows independently, and the result is rounded to the nearest cent after every one-year compounding step. That repeated rounding can differ slightly from applying a multi-year exponent once and rounding only at the end.
Formula Core:
For year index y, where the first academic year is 0, a base amount A and annual rate r produce the following projected amount. In the actual plan, the same rule is applied one year at a time with cent rounding after each step.
Within each academic year, the reconciliation is:
Rule Core:
| Rule | Boundary or effect |
|---|---|
| Program length | Whole number from 1 through 8 years. |
| Annual amounts | $0 through $10,000,000 per category, with at most two decimal places. |
| Growth rates | -50% through 50%, inclusive, with at most two decimal places. |
| Gift aid check | Every projected year must satisfy gift aid ≤ gross cost; otherwise the plan stops with a correction message. |
| Totals | Sum the year-level amounts. A surplus is not automatically carried forward to reduce another year's gap. |
With the built-in first-year amounts and 0% growth, gross cost is $46,500, gift aid is $15,000, net price is $31,500, and available funding is $12,000. The annual gap is therefore $19,500. A four-year plan repeats those annual values and totals a $78,000 funding gap.
Limitations:
This is an educational planning scenario, not financial advice or an institutional aid calculation.
- It does not calculate loan interest, origination fees, taxes, inflation from an external index, or the timing of payments within an academic year.
- It assumes each entered category follows its selected annual rate and does not model one-time funding separately.
- Institutional cost of attendance, aid eligibility, and renewal rules remain authoritative for the student's actual offer.
References:
- 2026–2027 Federal Student Aid Handbook: Cost of Attendance, U.S. Department of Education, June 29, 2026.
- How to Evaluate Your Aid Offers, Federal Student Aid.
- Net Price Calculator Center, U.S. Department of Education.