Worked example: a monthly budget for a UK university student
These numbers are made up to show how the Monthly Budget tab works. They are not averages and not a recommendation. All amounts are in pounds per month.
| Income | Planned |
|---|---|
| Part-time work | £750 |
| Bursary / grant | £150 |
| Family support | £100 |
| Maintenance loan instalment (monthly share) | £650 |
| Other income | £40 |
| Total income | £1,690 |
| Expenses | Planned |
|---|---|
| Rent / housing | £480 |
| Utilities | £55 |
| Phone and internet | £20 |
| Insurance | £10 |
| Transport pass | £35 |
| Subscriptions and other fixed | £25 |
| Total fixed expenses | £625 |
| Groceries | £160 |
| Eating out | £50 |
| Fuel / rides | £20 |
| Books and supplies | £30 |
| Personal care and clothing | £40 |
| Entertainment | £45 |
| Other variable | £25 |
| Total variable expenses | £370 |
| Total expenses | £995 |
| Leftover (income minus expenses) | £695 |
The leftover of £695 is what is available for debt payments and savings. In the example, the three minimum payments below add up to £500, which leaves £195, enough to try an extra £100 a month.
Calculator figures: paying off three example debts with and without an extra £100 a month
Three example debts with illustrative rates, such as an overdraft, a card and a private loan. These are not official rates and not current rates; replace them with your own figures.
| Debt | Balance | Annual rate | Minimum payment |
|---|---|---|---|
| Debt A | £5,000 | 5.5% | £150 |
| Debt B | £12,000 | 6.8% | £250 |
| Debt C | £2,500 | 19.9% | £100 |
Inputs for the table below, stated in full: the three debts above and an extra payment of £100.00 a month. Each month the interest is balance times annual rate divided by 12 and the payment is made at month end. These figures are results of the free in-browser debt snowball calculator; example figures for the example debts shown, your results depend on your own numbers; they are not results of the spreadsheet. The calculation stops at 600 months. In the snowball and avalanche rows the extra goes to the target debt and, when a debt is paid off, its whole payment moves to the next one. That ordering is done only by the free calculator. The USD 12 workbook has a monthly budget, a debts list, a per-debt payoff plan with an extra payment applied to one chosen debt, and a term plan; nothing is carried over to the other debts, so its with-extra output is not the snowball or avalanche row.
| Method | Months to debt-free | Total interest | Total paid | Debt A paid off in month | Debt B paid off in month | Debt C paid off in month |
|---|---|---|---|---|---|---|
| Minimums only | 57 | £3,239.13 | £22,739.13 | 37 | 57 | 33 |
| Snowball (smallest balance first) | 37 | £2,273.75 | £21,773.75 | 24 | 37 | 15 |
| Avalanche (highest rate first) | 37 | £2,249.69 | £21,749.69 | 37 | 37 | 15 |
In this example the extra £100 a month moves the last payoff from month 57 to month 37 and lowers total interest by £965.38 (snowball) or £989.44 (avalanche). These are calculator figures, not spreadsheet figures. The workbook's Payoff Plan tab calculates a with-and-without-extra schedule for your own debts. See the student loan payoff spreadsheet page and the debt payoff planner page.
A note on UK student loan repayment
Many UK student loans are repaid as a percentage of income above a threshold, taken through pay or self assessment, and any balance left after a set number of years is written off. That is not a fixed monthly payment, so the payoff example above fits overdrafts, cards and private loans best. For a plan loan, enter your own estimate of the monthly amount as the minimum payment, or use the Loan rules block as a reminder of your plan's figures. The threshold, rate and write-off period depend on your plan type and change over time: check repaying your student loan on gov.uk and student finance on gov.uk.
How to use a budget and payoff sheet in four steps
- Budget. Enter planned and actual amounts for income and expenses for one month, and compare.
- List your debts. Name, balance, annual rate and minimum monthly payment for each debt.
- Test an extra payment. Type an extra monthly amount and the debt that receives it. Read the months and interest saved.
- Plan the term. Spread a lump sum, such as a maintenance loan instalment, over the weeks until the next one.
What is in the paid workbook
One Excel-format workbook (.xlsx) for the UK with 5 tabs, plus a PDF guide:
- Start: how to use the workbook, notes on the calculation and the disclosures.
- Monthly Budget: planned, actual and difference columns for income, fixed and variable expenses, with totals and leftover.
- Debts: up to 6 debts, plus a Loan rules block (repayment threshold, repayment rate, interest rate, write-off years) that is left blank on purpose so you fill it from gov.uk.
- Payoff Plan: a 120-month schedule per debt with and without an extra payment, payoff month, total interest, interest saved and months saved.
- Term Plan: spreads a lump sum over up to 26 weeks into a weekly allowance and a week-by-week balance.
The PDF guide explains each tab with a worked example.
How it was checked: a script verified the workbook structure and cell references, and compared the payoff schedule for three example debts to a closed-form calculation. It was produced with AI assistance. No claim is made that it was opened in any particular spreadsheet program; spreadsheet programs recalculate the formulas when you edit an input.
Price, refund and licence
USD 12, one-time payment, sold on Gumroad. Licence: personal use. Refund on request within 14 days. These are the same terms as on the Gumroad listing.
Get the workbook, USD 12 on Gumroad
Other countries
Loan rules differ by country. See the United States edition and the Canada edition. The USD 12 purchase includes all three workbooks (US, UK, CA) and the PDF guide. Looking for the debt snowball method? See the debt payoff spreadsheet page.