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 * 100

Net Cost After Scholarship

net_cost = total_cost_of_attendance - avg_scholarship_amount

Scholarship Coverage

scholarship_coverage = avg_scholarship_amount / total_cost_of_attendance * 100

Total Scholarship Budget (accepted)

total_scholarship_budget = scholarships_accepted * avg_scholarship_amount

Variables

VariableDescriptionDefault
scholarships_offeredScholarship Offers Made200
scholarships_acceptedOffers Accepted (enrolled)130
total_cost_of_attendanceTotal Cost of Attendance($)45000
avg_scholarship_amountAverage 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
  1. 01Yield rate: 130 / 200 x 100 = 65.0%
  2. 02Net cost: $45,000 - $12,000 = $33,000
  3. 03Coverage: $12,000 / $45,000 x 100 = 26.7%
  4. 04Total budget: 130 x $12,000 = $1,560,000

Ready to run the numbers?

Open Scholarship Yield Calculator