Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:

We hope you are all safe and well and if you need us we will be here. 💚

Please check this link for the latest updates:

We hope you are all safe and well and if you need us we will be here. 💚

# Calculating the interest part of a loan?

Kanatkins
New MemberRegistered Posts:

**11**
Hello

Have been stuggling with calculating what part of a business loan to but to interest as expenses - can anyone help.

Is the a formula to use?

Thanks

Have been stuggling with calculating what part of a business loan to but to interest as expenses - can anyone help.

Is the a formula to use?

Thanks

0

## Comments

1,44833Some banks provide monthly/yearly statements with the interest shown as payments. These are quite straightforward.

Others just have the original loan document with the interest rate, monthly payments etc. These are a bit more difficult. The interest is applied to the outstanding loan. I usually set up a spreadsheet showing the outstanding loan each month, the amount of the repayment, the amount of interest applied and the loan outstanding at the end of the month.

It is a bit fiddly so I'm hoping someone will reply with an easier answer for us both!

1,441Using the loan agreement take the total amount of interest payable. (this can be calculated by taking the payment amount x the number of payments less the original loan amount)

Assume the interest accrues evenly.

Then if three payments are made in the year and there are a total of 60 payments to be made the interest for that year will be 3/60 of the interest.

I then use a control account to calculate the amount outstanding at the year end and reconcile this to the outstanding payments and remaining interest to be accrued which should come back to nil.

Burg

11Is it common practice to assume the interest accrues evenly, I would presume the interest reduced year on year?

Best Regards

1,438I agree with Ian, that's what I've always done if I have nothing else to go by. Same for HP.

1,809That is the most common method of weighting the interest over the period of the loan.

11Anyway, sum of digits calc reflects the true nature of the loan i.e more interest is paid at the start of the loan, because more capital is outstanding.

1,80911http://www.hmrc.gov.uk/manuals/ctmanual/ctm53220.htm

sum of digits much easier than spreadsheet I was using -Wrenchie you should have a look at this, might save you some time too!