Jump to content


007coot

How do i calculate interest on reducing balance?

style="text-align:center;"> Please note that this topic has not had any new posts for the last 2668 days.

If you are trying to post a different story then you should start your own new thread. Posting on this thread is likely to mean that you won't get the help and advice that you need.

If you are trying to post information which is relevant to the story in this thread then please flag it up to the site team and they will allow you to post.

Thank you

Recommended Posts

Hi,

 

I have a secured loan with paragon, been paying it for 7 years and so far they have charged me over £36k in interest and I have paid £39K so far. My debt has only reduced by £2,800. I want to do a spreadsheet so i can try and work out how my balance will reduce over the years, I know interest rate may change but I just want an idea of how the payments will start to reduce my balacne becasue at the moment I see no light at the end of the tunnel! This should be a 300 month term and I can't see it'll get paid off in time if over 7 years I've only cleared £2,800 off balance. I thought it might help if I culd put my payments in up until end date of July 2030 and use current interest rate just to see if it does look any better and make things a bit clearer for me. Then it should give me some hope!

 

I called paragon and raised my concerns but they just said as long as I paid my monthly payments on time it would be clear by the end of the 300 months but I can't get my head around it.

 

Any ideas how I can do a spreadsheet please on excel?

 

Thanks in advance!

Share this post


Link to post
Share on other sites

sorry to add the loan was for £46k and I still owe £43K after 7 years

Share this post


Link to post
Share on other sites

What is the amount of the monthly payment please?


If I have helped you please leave me a message by clicking my star

 

1. Single Premium PPI Q&A Read Here

2. Reclaim mis-sold PPI

Read Here

3. Reclaim Loan & Credit Card Charges Read Here

4. The CAG Interest Tutorial

Read Here

5. Feel Bullied by Creditors or Debt Collectors?

Read Here

6. Staying Calm About Debt

Read Here

7. Thinking of a Full & Final Settlement?

Read Here

 

How To Upload Documents To Cag

Instructions

 

I DON'T GIVE ADVICE BY PM BUT IF YOU SEND ME A LINK TO YOUR THREAD THEN I WILL BE HAPPY TO OFFER HELP THERE

 

 

 

Private message facilities are offered for users to communicate issues that are perhaps inappropriate for posting on the main forum. Site rules explain this in more detail.

 

If you receive a private message which you consider abusive, derogatory or otherwise inappropriate, whether it be about yourself or other members, please report it using the "report" icon

 

If you are approached (or have been approached) by private message with an offer of help "Off Forum" or with a view to asking you to visit another website, please inform the site team via the report icon, especially if this results in a request for a fee. Remember, this is for your own protection

my views are my own and are given in good faith to try and help people. Please seek professional advice on your case if necessary

 

PLEASE HELP US TO KEEP THIS SITE RUNNING

EVERY POUND DONATED WILL HELP US TO KEEP HELPING OTHERS

 

Share this post


Link to post
Share on other sites

Hi Ims I pay 482.84 per month, they charge me aprrox £422 in interest and my current rate is 11.772

 

Thanks x

Share this post


Link to post
Share on other sites

OK use this spreadsheet

 

Enter the three bits of information at the top and it will give you some idea of how a loan progresses over time.

 

Not that in the early years you pay a very small amount of capital off the loan but a lot in interest. In the later years that trend is reversed.

 

Hope this helps

 

ims

 

LoanAnalysis.xls


If I have helped you please leave me a message by clicking my star

 

1. Single Premium PPI Q&A Read Here

2. Reclaim mis-sold PPI

Read Here

3. Reclaim Loan & Credit Card Charges Read Here

4. The CAG Interest Tutorial

Read Here

5. Feel Bullied by Creditors or Debt Collectors?

Read Here

6. Staying Calm About Debt

Read Here

7. Thinking of a Full & Final Settlement?

Read Here

 

How To Upload Documents To Cag

Instructions

 

I DON'T GIVE ADVICE BY PM BUT IF YOU SEND ME A LINK TO YOUR THREAD THEN I WILL BE HAPPY TO OFFER HELP THERE

 

 

 

Private message facilities are offered for users to communicate issues that are perhaps inappropriate for posting on the main forum. Site rules explain this in more detail.

 

If you receive a private message which you consider abusive, derogatory or otherwise inappropriate, whether it be about yourself or other members, please report it using the "report" icon

 

If you are approached (or have been approached) by private message with an offer of help "Off Forum" or with a view to asking you to visit another website, please inform the site team via the report icon, especially if this results in a request for a fee. Remember, this is for your own protection

my views are my own and are given in good faith to try and help people. Please seek professional advice on your case if necessary

 

PLEASE HELP US TO KEEP THIS SITE RUNNING

EVERY POUND DONATED WILL HELP US TO KEEP HELPING OTHERS

 

Share this post


Link to post
Share on other sites

Thaks Ims, I was asking Paragon if I pay mainly interest first but she just didn't understand me, Thaks so much, I feel much better now you've said that. I really appreciate your help.

 

P.s hope you read my message on my other post reminding you how amazing you are too lol, it's not just dx that gets my praises hehe!

Share this post


Link to post
Share on other sites

Aw shucks :hug:


If I have helped you please leave me a message by clicking my star

 

1. Single Premium PPI Q&A Read Here

2. Reclaim mis-sold PPI

Read Here

3. Reclaim Loan & Credit Card Charges Read Here

4. The CAG Interest Tutorial

Read Here

5. Feel Bullied by Creditors or Debt Collectors?

Read Here

6. Staying Calm About Debt

Read Here

7. Thinking of a Full & Final Settlement?

Read Here

 

How To Upload Documents To Cag

Instructions

 

I DON'T GIVE ADVICE BY PM BUT IF YOU SEND ME A LINK TO YOUR THREAD THEN I WILL BE HAPPY TO OFFER HELP THERE

 

 

 

Private message facilities are offered for users to communicate issues that are perhaps inappropriate for posting on the main forum. Site rules explain this in more detail.

 

If you receive a private message which you consider abusive, derogatory or otherwise inappropriate, whether it be about yourself or other members, please report it using the "report" icon

 

If you are approached (or have been approached) by private message with an offer of help "Off Forum" or with a view to asking you to visit another website, please inform the site team via the report icon, especially if this results in a request for a fee. Remember, this is for your own protection

my views are my own and are given in good faith to try and help people. Please seek professional advice on your case if necessary

 

PLEASE HELP US TO KEEP THIS SITE RUNNING

EVERY POUND DONATED WILL HELP US TO KEEP HELPING OTHERS

 

Share this post


Link to post
Share on other sites

spreadsheet is fantastic, thank Ims, can't wait to show my husband when he gets home from the Olympics, it will be a great weight off our shoulders because we can see now how it will reduce. Thank you so so much! :-)

Share this post


Link to post
Share on other sites
:thumb:

If I have helped you please leave me a message by clicking my star

 

1. Single Premium PPI Q&A Read Here

2. Reclaim mis-sold PPI

Read Here

3. Reclaim Loan & Credit Card Charges Read Here

4. The CAG Interest Tutorial

Read Here

5. Feel Bullied by Creditors or Debt Collectors?

Read Here

6. Staying Calm About Debt

Read Here

7. Thinking of a Full & Final Settlement?

Read Here

 

How To Upload Documents To Cag

Instructions

 

I DON'T GIVE ADVICE BY PM BUT IF YOU SEND ME A LINK TO YOUR THREAD THEN I WILL BE HAPPY TO OFFER HELP THERE

 

 

 

Private message facilities are offered for users to communicate issues that are perhaps inappropriate for posting on the main forum. Site rules explain this in more detail.

 

If you receive a private message which you consider abusive, derogatory or otherwise inappropriate, whether it be about yourself or other members, please report it using the "report" icon

 

If you are approached (or have been approached) by private message with an offer of help "Off Forum" or with a view to asking you to visit another website, please inform the site team via the report icon, especially if this results in a request for a fee. Remember, this is for your own protection

my views are my own and are given in good faith to try and help people. Please seek professional advice on your case if necessary

 

PLEASE HELP US TO KEEP THIS SITE RUNNING

EVERY POUND DONATED WILL HELP US TO KEEP HELPING OTHERS

 

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 Caggers

    No registered users viewing this page.


  • Have we helped you ...?


×
×
  • Create New...