How to compare education offers by total cost and funding gap
To compare education offers fairly, put every offer into the same cost structure for the whole programme, apply each scholarship only to the costs it covers, keep conditional aid apart from confirmed aid, follow the money by due date rather than by annual total, keep each cost in its own currency, and allocate every funding source only once. What is left uncovered is the funding gap — and the date it first appears matters as much as its size.
The steps below use fictional numbers you can replace with your own.
Put every offer into the same cost structure
Tuition is only one line. The decision depends on everything the student has to pay to attend. For each offer, list:
- tuition per term or year;
- mandatory fees (registration, student services, lab or studio fees);
- deposits — enrolment deposits, housing deposits — and whether they are refundable;
- books, materials and equipment;
- housing, food and local transport;
- travel to and from the place of study;
- visa costs and insurance you are required to hold;
- any other entered requirement.
Do this for the full programme, not only the first term. A three-year course with low first-year tuition and a large increase later is not the same as a two-year course with a steady price. If an institution states an annual increase, enter it; if it does not, do not invent one.
Use the same categories for every offer. That is what makes the comparison honest: when two totals differ, you can see which line causes the difference.
Apply aid to the right base
A scholarship or grant usually covers specific costs. A 20% tuition-only scholarship on tuition of 10,000 is 2,000. It does not reduce 5,000 of living costs. If you apply the percentage to the whole budget, you would count 3,000 of aid that does not exist.
The same rule applies to fixed awards: a 1,500 housing grant cannot be larger than the housing cost it is for, and a grant that pays once does not repeat every year. Always write down which categories and which terms an award covers. That list — the eligible base — is part of the award, not a detail.
Separate confirmed, conditional and renewable aid
Some aid is confirmed in writing. Some depends on a condition: a minimum grade, full-time enrolment, a document still to be sent. Many awards are renewable — the first year is confirmed, later years depend on a renewal.
Keep these apart. A useful comparison has three views:
- Baseline — confirmed aid only.
- All conditions met — confirmed plus conditional and renewal aid.
- Renewal fails — conditional aid that is not a renewal still counts, but every renewal is removed.
Removing a failed renewal should change only the terms it covers. If the year-2 renewal of a 6,600 award fails, the year-1 award stays; the plan simply needs another source for year 2. Do not turn a condition into a percentage chance — you do not know it, and a blended "expected" figure hides the case you need to plan for.
Use dates, not only annual totals
Money is due on dates. A refundable deposit of 1,000 due before family funds arrive creates a temporary gap of 1,000. The annual plan may appear balanced while the student cannot make the first payment.
So list each cost with its due date and each source with the date it becomes available, then walk through the dates in order. On each date, the money available by that date pays the costs due that day. The lowest point of the running balance is the peak funding gap, and the first date the balance goes below zero is the first unpaid date. A refund that comes back later — such as the deposit — helps the later balance, not the day it was due.
Keep each cost in its own currency
When an offer is in another currency, keep every cost in that currency and convert with a dated rate you enter. If 1 EUR is entered as 1.1 of your base currency, a cost of 2,000 EUR is 2,200. Then test a downside: a +10% stress changes only the foreign-currency amounts. Costs already in your base currency do not move.
Do not pretend to know a future rate. If the rate for a later payment date is missing, the offer still has a valid total in its own currency — but the converted comparison is incomplete and should say so. It must never be treated as zero.
Allocate funding once
Each source of money can be used only once. A sensible order is:
- scholarships and grants, applied to their eligible costs;
- refunds that come back, savings and family money;
- income from work during study, capped by the hours actually allowed;
- loans;
- whatever remains is uncovered — the funding gap.
If family money is allocated to tuition, it cannot also be shown paying for housing.
Estimate the loan with its own terms
If borrowing is needed, use the loan's stated terms: the interest convention (an effective annual rate is converted to a monthly factor; a nominal rate is divided by 12), fees added to the balance or paid up front, the dates money is drawn, what is paid during study — nothing, interest only or a fixed amount — any grace period, and the repayment schedule.
For example, a loan of 12,000 at an effective 12% a year repaid over 12 months gives a monthly factor of about 0.95% and a payment of 1,062.74; total interest is 752.95. At 0% the interest is exactly zero. Do not apply one country's student-loan rules to everything; enter the terms you were actually offered. Compare required borrowing and repayment beside total cost — not instead of it.
A worked example
The fictional demo uses base currency USD:
- Harbourside, USD: tuition 10,000 with a 20% tuition-only scholarship (aid 2,000); housing 5,000 untouched; a refundable 1,000 housing deposit due 15 May; family money arrives with the first term on 1 September. The year balances, but the cash plan shows a temporary gap of 1,000 from 15 May. The year-2 scholarship depends on a renewal, so the baseline leaves it out.
- Rhein, EUR: every EUR cost is converted at the entered 1.1, and the +10% stress changes only EUR amounts — the flight, entered in USD, does not move.
- Alpine, CHF (second demo): the entered rate runs only until 30 June 2028, so the second-year tuition has no rate. The native-currency total is valid; the converted comparison is marked incomplete.
- Lys, EUR (third demo): 50% of tuition of 12,000 EUR is 6,000 EUR a year — 6,600 USD at 1.1 — with year 2 subject to renewal. "All conditions met" counts 13,200 USD; "renewal fails" removes only year 2 and keeps 6,600.
None of these is "the winner". Harbourside needs bridge money in May; Rhein depends on a rate; Alpine cannot be compared until a rate is entered; Lys depends on a renewal.
Decide without a false score
A single score hides the trade-offs you actually face: a lower total with a large early deposit, a higher total with secure grants, a currency-sensitive offer. Look at net cost, required borrowing, peak gap, loan repayment, first-year cost and the share of funding that is conditional side by side. If you want one weighted number, choose the weights yourself — and keep the table next to it.
Education Offer & Funding Gap Lab does this comparison from the information you enter. It does not assess admission, aid eligibility, visa rules or whether a loan suits you. No AI guesses. Every result shows its working. Open the fictional three-offer demo to inspect tuition, living costs, scholarship renewal, timing and borrowing together.
