Skip to main content
Free Tool · Finance & Admissions

Institutional Scholarship Allocation Matrix

Model how distributing merit or need-based scholarship funds across student tiers impacts your institution's net tuition yield — before committing the budget.

Runs entirely in your browser · No login · No data uploaded

Cohort Settings
Scholarship Tiers

Add tiers (e.g. Merit A, Merit B, Need-Based). Set the discount % and how many students receive it.

Configure your cohort and scholarship tiers, then click Model Yield Impact.

How to Model Scholarship Yield in 3 Steps

Follow these steps to get results in under a minute

01
Set cohort size and full tuition
Enter your intake cohort size, the full tuition fee per student, and your total scholarship budget available for the intake. The model tracks whether your allocations stay within budget.
02
Add scholarship tiers
Create scholarship tiers — Merit A, Merit B, Need-Based — and set the discount percentage and how many students receive each tier. You can model merit-only, need-only, or blended approaches.
03
Review the net tuition yield impact
Click Model Yield Impact to see gross tuition, total scholarships awarded, net tuition yield, and discount rate. The visual bar shows the proportion of full-pay, discounted, and scholarship students.

How Scholarship Matrix Compares

vs spreadsheets, manual processes, and paid platforms

Feature UniCloud360 Scholarship Matrix Manual SpreadsheetFinance Office ModellingPaid Enrolment Analytics
Multi-tier discount modelling Unlimited tiers ⚠️ Complex formulas ⚠️ Manual scenarios Yes
Net tuition yield calculation Auto-computed ⚠️ Manual calculation ⚠️ Accountant needed Yes
Budget vs awarded comparison Over/under flag ⚠️ Manual check Not shown ⚠️ Separate report
Visual yield breakdown chart Inline bar chart Separate chart tool No ⚠️ Paid dashboard
Print-ready impact report One-click ⚠️ Manual formatting No ⚠️ Scheduled export
Cost Free forever ⚠️ Manual effort ⚠️ Accountant time Paid platform

What Finance and Admissions Teams Are Saying

Trusted by lecturers and students across Sri Lankan universities

4.9
★★★★★
4 reviews
PF
Dr. Priyanka Fernando
VP Finance
★★★★★

"Before scholarship season we run multiple models — a merit-heavy scenario vs a need-heavy scenario — to see which one gives us the best net yield while hitting our enrolment targets. This tool makes that a 5-minute exercise instead of a spreadsheet marathon."

CJ
Chamari Jayawardena
Financial Aid Officer
★★★★★

"The budget vs awarded comparison caught an error in our initial plan — we were over-budgeting the top merit tier by 18%. Seeing it flagged immediately meant we could reallocate to a need-based tier that was under-funded."

DR
Dilshan Rathnayake
Admissions Director
★★★★★

"We modelled 6 different scholarship scenarios for our 2026 intake in under 30 minutes. The net yield column made it immediately clear which scenario gave us the best financial outcome alongside our recruitment goals."

MS
Malika Senanayake
Academic Registrar
★★★★☆

"The visual bar chart is the feature I show to the board — they can see at a glance what percentage of the cohort is on full fees, partial scholarship, and full scholarship. Much clearer than a table of numbers."