Scholarship Yield Calculator Formula
Understand the math behind the scholarship yield calculator. Each variable explained with a worked example.
Formulas Used
Scholarship Yield Rate
yield_rate = scholarships_accepted / scholarships_offered * 100Net Cost After Scholarship
net_cost = total_cost_of_attendance - avg_scholarship_amountScholarship Coverage
scholarship_coverage = avg_scholarship_amount / total_cost_of_attendance * 100Total Scholarship Budget (accepted)
total_scholarship_budget = scholarships_accepted * avg_scholarship_amountVariables
| Variable | Description | Default |
|---|---|---|
scholarships_offered | Scholarship Offers Made | 200 |
scholarships_accepted | Offers Accepted (enrolled) | 130 |
total_cost_of_attendance | Total Cost of Attendance($) | 45000 |
avg_scholarship_amount | Average Scholarship Amount($) | 12000 |
How It Works
Understanding Scholarship Yield
Scholarship yield measures how many scholarship recipients actually enroll. It helps institutions budget financial aid and plan enrollment.
Formula
Yield Rate = Accepted Offers / Offers Made x 100
Net Cost = Total Cost of Attendance - Scholarship Amount
Coverage = Scholarship / Cost of Attendance x 100
Higher scholarship amounts generally produce higher yield rates, but there are diminishing returns beyond a certain threshold.
Worked Example
200 scholarship offers made, 130 accept and enroll. COA is $45,000, average scholarship $12,000.
scholarships_offered = 200scholarships_accepted = 130total_cost_of_attendance = 45000avg_scholarship_amount = 12000
- 01Yield rate: 130 / 200 x 100 = 65.0%
- 02Net cost: $45,000 - $12,000 = $33,000
- 03Coverage: $12,000 / $45,000 x 100 = 26.7%
- 04Total budget: 130 x $12,000 = $1,560,000
Ready to run the numbers?
Open Scholarship Yield Calculator