Method and apparatus for advanced mortgage diagnostic analytics
View Patent ↗A method and apparatus for calculating individual or collective safe scores for properties with loans. These safe scores are useful in comparing the risk of loss due to exposure in the case of a default on the loan or loans being evaluated and may be used to objectively compare individual loans or groups of loans for such risk and for the worthiness for refinancing or additional lending.
1. A computer-based method of calculating a safe score for a property comprising the steps of:
gathering data related to a property from a database, the data comprising a current loan balance on said property, a margin of safety, an automated valuation of said property, and a forecast standard deviation, wherein the margin of safety is an amount or percentage above the current loan balance, and the forecast standard deviation is a forecast of a standard deviation for an automated valuation model used to generate the automated valuation of said property;
calculating, using a processor, an exposure value for said property using the current loan balance on said property and the margin of safety;
calculating, using the processor, an exposure variance for said property using the automated valuation of said property and the exposure value;
converting, using the processor, said exposure variance for said property into sigma units using the forecast standard deviation and the exposure variance, wherein the sigma units is a measure indicating a likelihood that a true value of the property is greater than or less than the exposure value; and
determining, using the processor, a safe score using the converted exposure variance in sigma units.
2. The method of claim 1 , wherein said steps are repeated for each property in a subject group of properties.
3. The method of claim 2 , wherein said safe scores are averaged to create a median safe score for said subject group of properties.
4. The method of claim 2 , wherein said safe scores are averaged to create a mean safe score for said subject group of properties.
5. The method of claim 1 , wherein said exposure variance is:
(automated valuation−exposure value)/exposure value.
6. The method of claim 1 , wherein said converting step is accomplished by dividing said exposure variance by the forecast standard deviation.
7. The method of claim 1 , wherein said safe score is the percentage of potential true valuation variances in sigma units less than said exposure variance in sigma units.
8. The method of claim 1 , wherein said determining step is accomplished by calculating the percentile of the exposure variance measured in sigma units.
9. The method of claim 1 , wherein said determining step is accomplished by using a lookup table of percentile table of variance measured in sigma units.
10. The method of claim 1 , further comprising the step of calculating, using the processor, the good and bad portions of a loan for said property.
11. The method of claim 1 , further comprising the step of calculating, using the processor, a bad part ratio.
12. The method of claim 11 , wherein the bad part ratio is:
((1−SS)*TLA)/TLA
wherein:
SS is a safe score, namely an indicator of the potential exposure should the loan go into default described as a decimal number from 0 to 1.00; and
TLA is the total loan amount, namely the total of all loan balances owed outstanding on said property.
13. The method of claim 2 , further comprising the step of calculating, using the processor, a bad part ratio.
14. A computer-based apparatus for calculating a safe score for a property comprising:
database connector means connected to a temporary data storage means for receiving data related to a property the data comprising a current loan balance on said property, a margin of safety, an automated valuation of said property, and a forecast standard deviation,
wherein the margin of safety is an amount or percentage above the current loan balance, and the forecast standard deviation is a forecast of a standard deviation for an automated valuation model used to generate the automated valuation of the property, the forecast standard deviation being calculated using valuation differences between an automated valuation of each property in a set of properties and a true value of each property in the set of properties,
automated valuation model connector means connected to said temporary data storage means for receiving automated valuations of said property;
calculation means connected to said temporary data storage means for calculating an exposure value for said property using the current loan balance on said property and the margin of safety, for determining a pivot point for said property, for calculating an exposure variance for said property using the automated valuation of said property and the exposure value, and for converting the exposure variance for said property into sigma units using the forecast standard deviation and the exposure variance, wherein the sigma units is a measure indicating a likelihood that a true value of the property is greater than or less than the exposure value; and
database connector means further connected to said calculation means for receiving percentiles in sigma units to thereby determine a safe score.
15. The apparatus of claim 14 , wherein the calculation means further comprises an aggregation means for calculating aggregate safe scores for a subject group of properties.
16. The apparatus of claim 14 , wherein said exposure variance is:
(automated valuation−exposure value)/exposure value.
17. The apparatus of claim 14 , wherein said exposure variance in sigma units is the exposure variance divided by the forecast standard deviation.
18. The apparatus of claim 14 , wherein said safe score is the percentage of potential true valuation variances in sigma units less than said exposure variance in sigma units.
19. The apparatus of claim 14 , wherein said calculation means further calculates the good and bad portions of a loan for said property.
20. The apparatus of claim 14 , wherein said calculation means further performs the step of calculating a bad part ratio.
21. The apparatus of claim 20 , wherein said bad part ratio is:
((1−SS)*TLA)/(TLA)
wherein:
SS is a safe score, namely an indicator of the potential exposure should the loan go into default described as a percentage represented by a decimal number from 0 to 1.00; and
TLA is the total loan amount, namely the total of all loans outstanding on said property.
22. The apparatus of claim 15 , wherein said calculation means further performs the step of calculating a bad part ratio.