Rex says
Money math without the spreadsheet headache. Plug in your numbers and I'll show you exactly where the dollars land.
Try a scenario
Click to load — tweak from there.Inputs
Result
Max sustainable aid budget
$612,000
Portion funded by tuition dollars
$462,000
Average award if spread evenly
$9,415
Dedicated funding applied
$150,000
Psst — share this and help Rex grow
One click, a permanent link with your numbers baked in.
How to use this
- 1Enter projected gross tuition revenue ($).
- 2Enter target discount rate ceiling (%).
- 3Enter dedicated aid funding (endowment/annual fund) ($).
- 4Enter expected number of aid recipients.
- 5Read your max sustainable aid budget on the right — it updates as you type.
- 6Hit Share to keep the scenario or send it to someone.
About this calculator
Financial aid committees need a hard number to work within before they start awarding, not a figure discovered after applications are already promised. This calculator takes projected gross tuition revenue, a target discount rate ceiling, and any dedicated funding (endowment draw, annual fund allocation for aid) to compute the maximum sustainable aid budget and how much of that must come from tuition dollars versus dedicated funding. It also shows the average award size available if you spread the aid budget across an expected number of aid recipients, which is a useful gut check before individual award decisions start — if the average award works out far below what families typically need to actually enroll, the target discount rate or funding plan needs revisiting before awards go out, not after.
Worked example
Using the values the calculator loads with:
Inputs
- Projected gross tuition revenue: 3400000 $
- Target discount rate ceiling: 18 %
- Dedicated aid funding (endowment/annual fund): 150000 $
- Expected number of aid recipients: 65
Results
- Max sustainable aid budget: $612,000
- Portion funded by tuition dollars: $462,000
- Average award if spread evenly: $9,415
- Dedicated funding applied: $150,000
What each field means
Inputs
- Projected gross tuition revenue ($)
- The projected gross tuition revenue used in the calculation, measured in $. Starts at 3400000 $ so you have a working example on load.
- Target discount rate ceiling (%)
- The target discount rate ceiling used in the calculation, measured in %. Starts at 18 % so you have a working example on load. Accepted range: 0–100 %.
- Dedicated aid funding (endowment/annual fund) ($)
- The dedicated aid funding (endowment/annual fund) used in the calculation, measured in $. Starts at 150000 $ so you have a working example on load.
- Expected number of aid recipients
- The expected number of aid recipients used in the calculation. Starts at 65 so you have a working example on load.
Results
- Max sustainable aid budget
- Returned as a money amount in US dollars and shown as the headline result. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Portion funded by tuition dollars
- Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Average award if spread evenly
- Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Dedicated funding applied
- Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
FAQ
How do I pick a target discount rate ceiling?
Start from your historical rate and comparable-school benchmarks, then adjust based on how much dedicated funding (endowment draw, annual fund) you have to offset tuition-funded aid. A school with strong endowment support can sustainably run a higher discount rate than one funding aid entirely from operating tuition, since the ceiling should reflect what the operating budget can absorb without cutting programs.
Why show 'average award' when awards vary by family need?
It's a planning sanity check, not an award formula. If your average comes out to $2,000 per recipient but your real cost of attendance gap for a typical aid family is $8,000, either you need fewer, larger awards, more total budget, or a different aid philosophy (need-based tiers vs. flat awards) before the committee starts reviewing individual applications.
What happens if aid decisions exceed the cap mid-cycle?
This is the most common budget blowout in enrollment-driven organizations: committees approve awards application-by-application without tracking a running total against the cap, and discover the overage only after all decisions are final. Track cumulative awarded dollars against this cap in real time during decision season, not after.
Should the cap change if enrollment comes in below projection?
Yes — the cap is a percentage of actual gross tuition, so if enrollment falls short, gross tuition falls and the dollar cap should be recalculated, not left at the original projection. Re-run this calculator once enrollment is confirmed each year rather than relying on the pre-enrollment estimate through the full award cycle.
Accuracy and limitations
- Results are estimates before tax, fees, and inflation unless an input explicitly covers them.
- Rates are treated as fixed for the whole period — variable-rate products will drift from this projection.
- This is educational maths, not financial advice. Check anything contractual with the lender or your accountant.
Related tools
Tuition Discount Rate (Financial Aid) Calculator
See how much of your gross tuition revenue financial aid is actually consuming.
Tuition Increase Attrition Impact Calculator
See whether a tuition hike still grows revenue after expected family losses.
Classroom Enrollment Breakeven Calculator
Find the minimum enrolled children a classroom needs to cover its costs.
Cite this calculator
Writing about this topic? Grab a citation — every link helps keep these tools free.
RevenueLab. (2026). Tuition Assistance Budget Cap Calculator. Retrieved from https://www.revenuelab.fyi/toolbox/tuition-assistance-budget-cap
<p>Source: <a href="https://www.revenuelab.fyi/toolbox/tuition-assistance-budget-cap" target="_blank" rel="noopener">Tuition Assistance Budget Cap Calculator — RevenueLab</a> (2026).</p>
Source: [Tuition Assistance Budget Cap Calculator — RevenueLab](https://www.revenuelab.fyi/toolbox/tuition-assistance-budget-cap) (2026).