Skip to content

APRC mortgage calculator: fees, insurance and amortisation schedule

Enter the loan amount, rate, term, insurance and fees of your mortgage offer: the calculator works out the monthly payment, the total cost, the APRC with the actuarial method and a year-by-year amortisation schedule. A second offer can be compared in one click.

What you enter stays on this device.

Method and sources checked on by the Casakal editorial team · Our method

The APRC (annual percentage rate of charge) expresses the total cost of a mortgage as a yearly rate: it adds fees and any insurance the lender requires to the interest, and is worked out with the actuarial method of Annex I of Directive 2014/17/EU. A £250,000 mortgage at 3.50% over 20 years with £3,500 of fees and 0.30% insurance has an APRC of 4.22%.

Diagram: on a £250,000 mortgage at 3.50% over 20 years with insurance at 0.30% a year and £3,500 of fees, the total cost of credit is £116,476, of which £97,976 is interest, £15,000 insurance and £3,500 fees; the 3.50% rate becomes an APRC of 4.22% (3.56% with no fees or insurance).

£250,000 over 20 years: payment, total cost and APRC

The example loaded in the calculator is a £250,000 repayment mortgage at a fixed 3.50% over 20 years, with insurance at 0.30% a year of the initial amount, a £1,000 arrangement fee and £2,500 of valuation and other required fees. The mortgage payment is £1,449.90 a month; insurance adds £62.50, making £1,512.40 in total.

Over 240 months you pay £97,976 of interest, £15,000 of insurance and £3,500 of fees: a total cost of £116,476. The 3.50% rate becomes an APRC of 4.22%, of which 0.50% comes from the insurance alone.

How the APRC is worked out

The APRC is not an average or a sum of percentages. It is the yearly rate at which the money you receive and everything you pay have the same present value: each payment in month k is divided by (1 + APRC) to the power k/12. Annex I of the Mortgage Credit Directive 2014/17/EU sets the method: time is measured in years or fractions of a year, with twelve equal months, and the result is given to at least one decimal place. Fees paid at the start reduce the money you actually receive; insurance the lender requires is added to every payment.

What is countedAPRCTotal cost
Loan only, no fees or insurance3.56%£97,976
+ £1,000 arrangement fee3.60%£98,976
+ £2,500 valuation and other fees3.72%£101,476
+ insurance at 0.30% of the initial amount4.22%£116,476
Same insurance on the outstanding balance4.04%£109,874

With no fees at all the APRC is already 3.56% for a 3.50% rate. That is not an error: interest is charged each month at a twelfth of the annual rate, and monthly interest compounds over the year.

Monthly payment, cost and APRC on £200,000

A £200,000 mortgage with insurance at 0.30% a year of the initial amount, a £1,000 arrangement fee and £2,000 of other required fees. The total cost adds interest, insurance and fees; the APRC uses the actuarial method of Annex I of the Mortgage Credit Directive 2014/17/EU.

Term and interest rateMonthly paymentTotal costAPRC
15 years at 3.00%£1,431.16£60,6103.80%
15 years at 3.50%£1,479.77£69,3574.31%
15 years at 4.00%£1,529.38£78,2874.82%
20 years at 3.00%£1,159.20£81,2063.73%
20 years at 3.50%£1,209.92£93,3814.23%
20 years at 4.00%£1,261.96£105,8714.75%
25 years at 3.00%£998.42£102,5273.68%
25 years at 3.50%£1,051.25£118,3744.18%
25 years at 4.00%£1,105.67£134,7034.69%

Insurance on the initial amount or on the balance

Insurance priced on the initial amount costs the same every month, £62.50 in the example, while the debt shrinks. Priced on the outstanding balance at the same 0.30%, it starts at the same level and then falls: over 20 years it costs £8,398 instead of £15,000, and the APRC drops to 4.04%. Compare policies on their total cost rather than on the headline rate.

Reading the amortisation schedule

The amortisation schedule splits each payment into principal, interest and insurance, and shows the balance after each one. Interest for a month is charged on what is still owed, so it is heavy at the start and almost nil at the end. The calculator shows the schedule year by year; tap a year to see its twelve months, and use the export button to get a CSV file for a spreadsheet.

YearPrincipalInterestInsuranceBalance
1£8,789£8,610£750£241,211
10£12,038£5,361£750£146,623
20£17,073£325£750£0

In year one, £8,789 of principal is repaid against £8,610 of interest. After ten years, £146,623 is still owed, more than half the loan, which is why overpaying the mortgage early on saves the most.

Comparing two mortgage offers

The “Compare with another offer” button opens a second example offer: the same loan at 3.35%, insurance on the outstanding balance and a £1,500 broker fee. Its monthly payment is £1,493.20, its APRC 3.95% and its total cost £106,731, £9,745 less than offer A. Replace these figures with the offers you have received: for the same amount and term, the total cost including fees and insurance decides.

The result is indicative. It assumes the rate stays fixed for the whole term, equal monthly payments and fees paid at the start; when a fixed deal ends, a different rate applies. Only your lender's offer is binding. Before settling on a payment, check your debt-to-income ratio; to see how much you could borrow, use Calkavo's borrowing calculator. For a buy-to-let, work out the rental yield as well.

Method and sources

References used:

This tool is checked by automated tests against known cases. Spotted a mistake? Report it on the contact page.

Last updated

Frequently asked questions

How is the APRC of a mortgage calculated?
It is the yearly rate at which the money received at the start, after fees, equals the present value of all payments, including any insurance the lender requires: each payment in month k is divided by (1 + APRC) to the power k/12. That is the method of Annex I of Directive 2014/17/EU.
Why is the APRC higher than the interest rate even with no fees?
Because interest is charged monthly at a twelfth of the yearly rate and compounds over the year. At 3.50% with no fees or insurance, the APRC is 3.56%.
What is the monthly payment on £250,000 over 20 years?
At 3.50%, £1,449.90 without insurance and £1,512.40 with insurance at 0.30% a year of the initial amount. With £3,500 of fees, the total cost comes to £116,476.
Which fees count in the APRC?
Fees the lender requires for the loan, such as arrangement, valuation and broker fees, and insurance the lender requires. Under the directive\x27s method, taxes and conveyancing costs of the purchase itself are left out.
How do I read an amortisation schedule?
Each row is one payment split into principal, interest and insurance, followed by the balance still owed. Interest falls month after month because it is charged on a smaller balance.
Are my calculations saved?
Only on your device, in the calculator's history. Nothing is sent anywhere.