Calculating the interest part of a loan?
Options
Kanatkins
Registered Posts: 11 New contributor ๐ธ
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

Ideally you need the original loan document, which will give all the details you need, including the interest rate and the amount of interest.0

It depends on what sort of loan it is.
Some 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!0 
Depends on the type of loan. If it is a variable rate loan then there should be a statement. If it is a fixed rate loan then I do the following:
Using 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.Regards,
Burg0 
Thankyou doesn't seem to be an easier option then!
Is it common practice to assume the interest accrues evenly, I would presume the interest reduced year on year?
Best Regards0 

Google 'sum of the digits'.
That is the most common method of weighting the interest over the period of the loan.0 
Is sum of digits not a GAAP/FRS requirement?
Anyway, 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.0 
Sum of the digits is one of a number of acceptable methods and, yes, the interest is weighted towards the beginning.0

checked it out on HMRC
http://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!0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.4K For AAT students
 275 NEW! Qualifications 2022
 148 General Qualifications 2022 discussion
 9 AAT Level 2 Certificate in Accounting
 48 AAT Level 3 Diploma in Accounting
 70 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 269 VAT
 91 Software
 271 Tax
 134 Bookkeeping
 7.1K General accounting discussion
 197 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 579 Job postings
 16 Who can benefit from AAT?
 36 Where can AAT take me?
 42 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 66 AAT membership