Enter college cost and aid details
Example data table
Use this sample scenario to understand how total cost, aid, and remaining funding needs interact in a typical college budgeting review.
| Scenario | COA | Gift Aid | Net Price | Loans | Gap |
|---|---|---|---|---|---|
| In-state public | $37,900 | $15,200 | $22,700 | $5,500 | $10,500 |
| Private campus housing | $54,600 | $28,000 | $26,600 | $6,500 | $8,900 |
| Commuter pathway | $24,800 | $9,700 | $15,100 | $4,000 | $4,100 |
Formula used
Cost of Attendance = Tuition + Fees + Room and Board + Books + Transportation + Personal Expenses + Other Costs.
Gift Aid = Federal Grants + Scholarships + State Aid + Institutional Aid.
Net Price = Cost of Attendance − Gift Aid.
Estimated Family Capacity uses adjusted income, assessable assets, household size, dependency status, and number in college to approximate annual pay capacity.
Estimated Need = Cost of Attendance − Estimated Family Capacity.
Affordability Gap = Net Price − (Family Contribution + Student Savings + Work-Study + Employer Aid + Veteran Benefits + Loans).
Need Coverage % = Gift Aid ÷ Estimated Need × 100.
How to use this calculator
- Enter annual tuition, fees, housing, books, travel, and personal costs.
- Add all grants and scholarships that do not require repayment.
- Include work-study, employer aid, veteran benefits, savings, and planned loans.
- Provide household and asset details for the family capacity estimate.
- Submit the form to view net price, need coverage, and affordability gap.
- Download the result summary as CSV or save the printable report as PDF.
Frequently asked questions
1. What does net price mean?
Net price is the annual college cost after subtracting gift aid, such as grants and scholarships. It does not automatically remove loans or work-study.
2. Why are loans separated from gift aid?
Loans reduce the immediate bill, but they must be repaid later. Keeping them separate helps you compare true affordability against future debt obligations.
3. Should I include transportation and personal costs?
Yes. Those expenses are part of total attendance cost. Ignoring them can make a college appear cheaper than it really is for a full academic year.
4. Is estimated family capacity the same as an official aid number?
No. It is a planning estimate based on simplified assumptions. Colleges may calculate aid eligibility differently using their own federal or institutional methodology.
5. What is a good need coverage percentage?
Higher is generally better. A college covering a large share of demonstrated need usually leaves a smaller uncovered gap for savings, work, or borrowing.
6. Can this compare two colleges?
Yes. Enter each school’s costs and aid separately, then compare net price, remaining cost after loans, and affordability gap to identify the stronger offer.
7. Do outside scholarships affect net price?
Usually yes. Add them under scholarships. Some colleges may reduce institutional aid when outside funding increases, so check each award letter carefully.
8. Can families use this before financial aid letters arrive?
Yes. It works well for early planning. Use estimated grants and scholarships first, then update the numbers once the official package becomes available.