← All prebuilt solutions
Tax & Company

Student Loan & Family Tax Calculator

Student loans, Marriage Allowance, Child Benefit and childcare – worked out for your family

£20

Secure checkout. Your download link is sent as soon as payment clears.

Student Loan & Family Tax Calculator

Overview

Families lose thousands of pounds a year to rules that are easy to miss: a Child Benefit charge nobody mentioned, a Marriage Allowance that was never claimed, Tax-Free Childcare left on the table, or student loan overpayments that will never pay off. This workbook brings those rules together. You enter your family's incomes, pension contributions and children once, and it works out what you're entitled to, what you're paying, and what you could do about it.

Price
£20
Who it’s for
Tax & Company
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Your Family

Tax year, circumstances, both partners' incomes and pension contributions, and your children. Works out adjusted net income, tax, NI and the tests every other sheet uses. What you do: fill in every yellow cell.

Your Family
Student Loans

Step 2

Student Loans

Your loan details, this year's repayments, the result with and without overpaying, and repayments at other incomes. What you do: enter your loan and assumptions.

Step 3

Loan Projection

The year-by-year workings to write-off for both scenarios and any postgraduate loan, plus the 'other incomes' projections. What you do: optional: change the ten test incomes in the yellow cells.

Loan Projection
Marriage Allowance

Step 4

Marriage Allowance

Eligibility and value this year, and a backdating table for the previous four years. What you do: enter earlier years' incomes.

Who it is for

Made for people like you

  • Example – text
  • Calculator – What it answers
  • Student loans – Will I ever repay my Plan 1, 2, 4, 5 or postgraduate loan? How much will I pay in total, when is it written off, and is overpaying worth it?
  • Marriage Allowance – Can we transfer part of a personal allowance between us – and can we backdate it for earlier years?
  • Child Benefit – How much do we get, how much does the High Income Child Benefit Charge take back, should we claim or opt out, and how much pension would cut the charge?
  • Tax-Free Childcare – Are we eligible, and how much will the government add to our childcare bills?
  • The £100k trap – What happens between £100,000 and £125,140 – and what a pension contribution really costs once the lost allowance, Child Benefit and childcare support are counted.

Quick start

Up and running in minutes

  1. Example – text
  1. Your Family – Choose the tax year and answer the yes/no questions. Enter each partner's income, pension contributions and Gift Aid, then up to six children with date of birth, childcare costs and whether you claim Child Benefit.
  2. Student Loans – Pick whose income to use, the loan plan, today's balance (from your Student Loans Company account) and the April repayments started. Add any postgraduate loan and a monthly overpayment you're thinking about.
  3. Marriage Allowance – Check this year's result, then type each partner's income for the last four tax years in the backdating table.
  4. Child Benefit – See the charge and recommendation, then try an extra pension contribution in the yellow box.
  5. Childcare – Check the eligibility ticks and the top-up for each child.
  6. £100k Trap – Use your own figures or a partner's, and see what a pension contribution really costs.
  7. Dashboard – Read the summary of everything your family is entitled to and what to do next.

Key features

  • Student loan forecaster for Plans 1, 2, 4, 5 and postgraduate loans: interest, repayments year by year, write-off date, whether you'll ever clear it – and whether overpaying is worth it.
  • Marriage Allowance checker with the value this year and up to four years backdated.
  • Child Benefit and the High Income Child Benefit Charge (£60,000–£80,000), whether to claim or opt out, and how pension contributions or Gift Aid cut the charge.
  • Tax-Free Childcare top-ups for each child with full eligibility checks, plus the £100,000 '60% tax trap' and how much a pension contribution really costs.

What’s included

  • Dashboard – Your family's entitlements at a glance
  • Your Family – Incomes, pensions and children
  • Student Loans – Will you repay it? Should you overpay?
  • Loan Projection – Year by year to write-off
  • Marriage Allowance – This year and backdated
  • Child Benefit – The charge and how to cut it
  • Childcare – Tax-Free Childcare top-ups
  • £100k Trap – The 60% tax band and pensions
  • Tax Rates – UK tax rates by year
  • Family Rates – Loan, childcare and other rates
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions