Solved

early loan resettlement formula

Posted on 2014-01-01
5
432 Views
Last Modified: 2014-01-14
Hello

Please could you point me in the direction of a formula for calculating early loan resettlemen in the uk. I can see there are regulations from 2004 but I can't find a formula. I have read of an actuarial method if that helps

Thanks
0
Comment
Question by:andieje
5 Comments
 
LVL 14

Expert Comment

by:Don Thomson
ID: 39749874
Here is one for Mortgages http://www.moneysavingexpert.com/mortgages/mortgage-overpayment-calculator

Here is an "Any Loan" calculator  http://www.financecalcs.co.uk/Calcs/Settlement.php

If you need the raw formulas try here http://www.excelworks.co.uk/default.aspx?page=30100

Download the Excel Spreadsheets - the formulas should be easy to figure out
0
 

Author Comment

by:andieje
ID: 39751039
Hi. I need the formula not the calculator.  I should have said it is for fixed rate loan so the mortgage spreadsheet doesn't apply. Thanks
0
 
LVL 19

Accepted Solution

by:
Ken Butters earned 500 total points
ID: 39771419
The following PDF file contains the law : Chapter 11 (Starting on Page 49 in attached PDF)
it also contains examples of it's application including formulas : Appendix (Starting on Page 85 in attached PDF)

Note: It is not a simple formula, but rather a sum of calculations for each month in the term.  That is why you find that it most often determined with various calculators.
10-1053-consumer-credit-directiv.pdf
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article seeks to propel the full implementation of geothermal power plants in Mexico as a renewable energy source.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now