Loan repayment and amortisation calculator

How the loan repayment calculator works

On capital and interest we apply the standard amortising formula, so the loan is fully repaid over the term and the monthly payment stays level. On interest only the monthly payment is just the interest on the full loan, which stays outstanding at the end. We also break out the first year, because early payments are mostly interest, which matters for cash flow and tax planning on a holiday let loan.

The capital and interest monthly payment is the loan multiplied by the monthly rate, divided by one minus one plus the monthly rate to the power of minus the number of months. The monthly rate is the annual rate divided by twelve. For the first year we step through twelve months, charging interest on the falling balance and treating the rest of each payment as capital. On interest only the first year interest is the monthly payment multiplied by twelve, with no capital repaid.

Why amortisation matters on a holiday let loan

Amortisation is the gradual repayment of capital over the term. In the early years most of each payment is interest because the balance is high, so a holiday let mortgage pays down less capital in year one than in year ten. Some investors choose capital and interest to own the property outright, while others lean to interest only to keep the monthly cost down against the short-let income. To model the deposit on a holiday let purchase, use our holiday let mortgage calculator.

Worked example

On a 315,000 pound loan at 8 percent over 10 years on capital and interest, the monthly payment is roughly 3,820 pounds, the total interest is about 144,000 pounds and the total repayable is around 459,000 pounds. In the first year roughly 24,800 pounds is interest and about 21,100 pounds clears capital. On interest only at the same rate the monthly cost falls to about 2,100 pounds, with the full 315,000 pounds still outstanding.