Jump to content


How do i calculate interest on reducing balance?


007coot
 Share

style="text-align: center;">  

Thread Locked

because no one has posted on it for the last 3310 days.

If you need to add something to this thread then

 

Please click the "Report " link

 

at the bottom of one of the posts.

 

If you want to post a new story then

Please

Start your own new thread

That way you will attract more attention to your story and get more visitors and more help 

 

Thanks

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!

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

 

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

 

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!

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

 

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! :-)

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

 

Link to post
Share on other sites

 Share

  • Recently Browsing   0 Caggers

    No registered users viewing this page.


  • Have we helped you ...?


×
×
  • Create New...