The Book-keepers Forum (BKF)

Post Info TOPIC: Loan Interest


Master Book-keeper

Status: Offline
Posts: 3904
Date:
Loan Interest


Client took loan out for 6k January 2018 from her bank, payable over 5 years  Interest is roughly 2k and is shown on agreement, but says it is accrued daily on outstanding loan, so would mean higher interest at the front end reducing.  Do I need to work this out, and how would I do that, or can I divide the interest by 60 to apply to the accounts?



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Hi John
Depending on where she got the loan from it should show the capital & interest split on the loan agreement.

Or at the very least the APR so you can work it out on an actuarial basis.

She may also have something on her Bank statements/advice from the Bank.

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Master Book-keeper

Status: Offline
Posts: 3904
Date:

Hi Joanne

Yes, I've got the loan figure, the overall interest, and the APR (12.9%) so presumably I should work out the interest monthly based on the amount outstanding?



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Hi John
Sorry for the delay. The interest is on a compounded basis, so you would need to set up a spreadsheet for that to work it out daily.

You could use the sum of digits method, but essentially they should give you about the same.

So it depends on how easy you find setting up spreadsheets. Let me know if you need the SOD method.



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Master Book-keeper

Status: Offline
Posts: 3904
Date:

Hi Joanne

I think I've understood sum of digits  1826 days (including leap day)  x 1827  / 2  then reduce down 1 day at a time?

I've done the first 30 days, is this right?  Edited to add daily interest calculated by multiplying SOD by total interest.

I've followed it through for the 1826 days and I have an exact sum of £2043.00

sum of digits.png



-- Edited by Leger on Monday 14th of January 2019 01:00:17 PM

Attachments
__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Hi John
Oh Im confused. I hate looking at other folks spreadsheets (especially when still got a headache from a busy weekend of booze!)

Is the £66 the interest for the first month (bottom of column D?) as that wouldnt be enough I dont think.

Also not sure where you have the 1827 days from. Sorry, I might be missing something!

For sum of digits I would be tempted to do the interest calc monthly (I know a purist would do it daly, but that would be 66000 lines of calc!)

Sum of digits works on a formula n * (N+1) / 2
n = number of months (or days if you insist).
For months this is literally the number of months ie 24 calculated as 1+2+3+4+5+6 etc answer is 300
ie using the formula 24 * (24+1) /2 = 300

Then you allocate the sum of digits to each month but kind of backwards
So interest for month 1 is calculated as 24/300 X £interest amount, say £2000 = £160 is interest in month 1

Month 2 23/300 X2000 = £153.32 is interest in month 2

Month 3 22/300 x 2000 =£146.67

Etc will show interest on reducing balance.

Hope Im making sense and my calcs are correct



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Master Book-keeper

Status: Offline
Posts: 3904
Date:

Cheshire wrote:

Hi John
Oh Im confused. I hate looking at other folks spreadsheets (especially when still got a headache from a busy weekend of booze!) Lol I polished off my remaining 1/3rd bottle of Southern Comfort last night whilst watching the movie Skyscraper.

Is the £66 the interest for the first month (bottom of column D?) as that wouldnt be enough I dont think.  Yes, it's over 5 years though.

Also not sure where you have the 1827 days from. Sorry, I might be missing something!  365 x 5 years + 1 day for leap year, then the +1

For sum of digits I would be tempted to do the interest calc monthly (I know a purist would do it daly, but that would be 66000 lines of calc!) Sorry, misunderstood you, thought I had to do it daily 

Sum of digits works on a formula n * (N+1) / 2   60 x 61 = 3660 / 2 = 1830
n = number of months (or days if you insist).
For months this is literally the number of months ie 24 calculated as 1+2+3+4+5+6 etc answer is 300
ie using the formula 24 * (24+1) /2 = 300

Then you allocate the sum of digits to each month but kind of backwards
So interest for month 1 is calculated as 24/300 X £interest amount, say £2000 = £160 is interest in month 1   60 / 1830 x 2043 = £66.98    Harrah I have got it right, as it will be fractionally higher doing it monthly.

Month 2 23/300 X2000 = £153.32 is interest in month 2

Month 3 22/300 x 2000 =£146.67

Etc will show interest on reducing balance.

Hope Im making sense and my calcs are correct


 Thanks Joanne, your help is much appreciated.



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Where in hell did I get 2 years from?

Think it was the 2 in £2k!!!

Oops, sorry John.




__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About