WO2003090130A1 - Risk assessment and measurement method and system - Google Patents

Risk assessment and measurement method and system Download PDF

Info

Publication number
WO2003090130A1
WO2003090130A1 PCT/AU2003/000448 AU0300448W WO03090130A1 WO 2003090130 A1 WO2003090130 A1 WO 2003090130A1 AU 0300448 W AU0300448 W AU 0300448W WO 03090130 A1 WO03090130 A1 WO 03090130A1
Authority
WO
WIPO (PCT)
Prior art keywords
value
property
data
year
financial instrument
Prior art date
Application number
PCT/AU2003/000448
Other languages
French (fr)
Inventor
Peter Gerard Moon
Maurice Squirrell
Craig Dawson
Hugh Sarjeant
Original Assignee
Australian Property Ratings P/L.
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Australian Property Ratings P/L. filed Critical Australian Property Ratings P/L.
Priority to AU2003218528A priority Critical patent/AU2003218528A1/en
Publication of WO2003090130A1 publication Critical patent/WO2003090130A1/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/08Insurance

Definitions

  • the present invention relates to the financial and banking sectors of business.
  • the present invention is a residential real estate (RRE) capital value risk identification and estimation tool.
  • the present invention is applicable to any financial instrument such as, property, shares, etc. against which a financial facility, for example a loan, might be granted and which financial instrument, fluctuates/grows in its value or market price.
  • the present invention in one form, has been developed for use in the financial sector, particularly in the field of banking, but also has application in mortgage securitisation, mortgage insurance and other areas where the identification and measurement of the probability of capital loss and/or negative equity for residential real estate is important.
  • LVR The traditional residential real estate (RRE) risk assessment tool for lending and mortgage insurance is the Loan to Value ratio (LVR).
  • LVR is defined as the mortgage amount at loan commencement divided by the security value at loan commencement.
  • LVR Loan to Value ratio
  • Any loan that exceeds a Loan to Value ratio (LVR) of 80% is considered to be "risky” and generally requires mortgage insurance.
  • loans written at less than a 80% loan to value ratio are considered to be "safe”.
  • Lenders and Mortgage insurers alter policy from time to time, depending upon local geographic conditions and may consider not lending or insuring at any price. To date, these risk adjustments tend to be intuitive or semi-empirical. Banking and insurance are considered mature, highly competitive industries with little (considered) chance for differentiation in the market. Banks constantly strive to develop and offer new products and reduce costs.
  • Negative equity is the term used when the value of a property falls below the outstanding loan amount of the property. It has been clearly demonstrated that negative equity often becomes a trigger for loan delinquency, default and mortgage insurance claims. Standard and Poor's notes that "the major" causes of default in Australia are generally considered to be:
  • the present invention provides a method, system and computer program product as outlined in the specification and as defined in the attached claims.
  • the invention as outlined in the specification and as defined in the attached claims provides a method of providing a financial facility for a transaction involving a financial instrument.
  • the present invention has come about by realising that the loan to value ratio is a gross generalisation in respect to residential real estate risk.
  • research suggests that residential real estate sub-markets, measured at a very fine level of disaggregation, have very different risk profiles.
  • An example of a sub-market is a real estate market specified in terms of geographic location (zip/postcode), type (house / non house) and price (subdivisions /categories).
  • sub-markets may be determined for any other financial instrument, such as shares for example, where it is suggested that such sub-markets, measured at a very fine level of disaggregation, have very different risk profiles
  • the 80% loan to value ratio marker is considered a gross overstatement or understatement of the real sub-market risk.
  • the measure of risk for a given sub-market is dynamic, and will tend to change depending upon underlying factors such as economic cycles, price levels and/or other economic and non-economic events.
  • the real residential real estate or other properties risk occurs not only at the time of arranging the financial facility but is significant for a period of years. That period varies on financial conditions and the terms of the mortgage, but 5 years is considered a reasonable period for domestic mortgages. During this period, the loan principal has usually been reduced by a relatively small amount, whereas property markets and economies may have changed significantly. It is during this 3 to 5 year period from the commencement of the loan that the residential real estate security risk exists.
  • the present invention is directed, in one aspect to the identification and measurement of the probability of "negative equity" or the outstanding loan amount exceeding the value of the financial instrument at any time during this period. It is considered that this is the real measure of risk, not the initial loan to value ratio(LVR).
  • the present invention has a number of advantages, which include: That it will allow users in the finance industry to improve their risk assessment in the RRE market. In turn, this will allow them to better direct their business and minimise losses. Another benefit of the present invention is to allow increased returns on a risk adjusted basis. That it will enable estimation of the probability of negative equity (value less than outstanding loan balance) at a user set confidence level for a period 3 to 5 years in the future. This calculation can be undertaken for any financial instrument, for example, residential property type or value in any location, where sufficient historical data is available.
  • An example output may be as follows: Example 1 - Ballarat decile 1 (lowest 10%) houses: 1. To be 95% confident of no negative equity in this residential real estate sub-market, lend only up to 89% (approx) of the current value.
  • Example 2 Toorak decile 1 (lowest 10%) houses:
  • the Applicant's research indicates that based on historical data, residential property sub markets specified in terms of geographic location (zip / postcode), type (house / non house) and price (subdivisions /categories) have:
  • the present invention is forward looking i.e., looking at what might happen at any time in the next 5 years, and expressed in terms of probabilities, the results can be used to help any business involved in residential finance to: • Identify and measure detailed subdivisions of risk
  • the present invention may be applicable to many other financial instruments (property, shares, etc ...) against which a financial facility such as a loan might be granted and which instrument fluctuates/changes in value or market price. Most commonly, this would be property, but the principles could be applied generally.
  • the type of investment against which the loan is granted would need to be able to be grouped into sufficiently homogenous subsets for analysis to be meaningful. For example, loans secured against business operations would need to be assessed against the on-going value of a business. Analysis of loans secured against a share portfolio of, for example, the All Ordinaries, may also be contemplated in accordance with the present invention.
  • An embodiment of the present invention directed at residential real estate uses residential real estate historical sales data that is sourced from either the
  • the data is from different sources, it contains a variety of fields, formats, and is of varying quality.
  • the data needs to be standardised in its format, fields, and the like before they can be agglomerated into one data file.
  • the required data fields are price, date of transaction, property type (house or flat/unit) and postcode. Data for land sales are not analysed.
  • the database associated with the present invention would be updated periodically and probabilities re-calculated. Each year, another 500,000 records could be added. If updated on a quarterly basis, 125,000 records would be added.
  • the data would be cleaned and checked using a purpose built, rules based algorithm. We wish to identify and remove mathematically intractable, inconsistent, illogical and substandard observations, outliers, incomplete sets etc.
  • a preferred set of rules may reflect that the data is reviewed to ensure that it consists of values that could represent a single house or flat at a given point in time, and that it may provide a reasonable basis for analysis.
  • Points may be just sales data values, by year, by Flat/House, and / or by suburb. They may be the individual data records.
  • the price must be within a ratio of ⁇ 2 from the nearest price. Note that the logged prices are estimated to 1 decimal place. The above criterion means that the value can be no more than 7 log-points from the last observation.
  • a residential real estate property sub-market is a transaction:
  • the "boundary condition parameters" are the mean, standard deviation and serial correlation values derived for such a data set, comprising the yields obtained for one decile in one house/flat set for one suburb.
  • the 150,000 RRE sub-markets with 15 data points each have mean, standard deviation and serial correlations with 1 , 2 and 3 year lags calculated.
  • the process proceeds by assuming no capital repayments in the first 5 years, and using the Normal distribution assumption in conjunction with the parameter values calculated to derive the probabilities.
  • the outputs from this multi parameter algorithm are stored in a database with pre-defined fields.
  • LVR Value Ratios
  • Pairs of ⁇ ⁇ indicate the start and end of a given sub-process. Determine or get the relevant yields from year to year, for a given sub- market criteria, such as, for each suburb, for houses/flats separately, and for each decile
  • Pt,i is the Consideration in year t and the ith quantile.
  • Standard deviation where s is the standard deviation of delta; n is the number of years with 'calculated' yields' X j ,i is the natural log of 1 plus the yield in year j and the ith quantile
  • P2 Pi Po 1 arge number of simulations (e.g. 10000) ⁇
  • Set an arbitrary initial property value Construct column matrix X of the most recent yields in reverse order. For example, if the most recent log yields are y-i, y 2 , y 3 , construct as y 3 , y 2 , yi.O For each of five years ⁇
  • the output data stored in the database can be interrogated, picked, re-arranged and re-expressed in a number of ways to answer many different types of questions.
  • Example 1 Ballarat decile 1 (lowest 10%) houses:
  • Example 2 Toorak decile 1 (lowest 10%) houses: A. To be 95% confident of no negative equity in this RRE sub-market, lend up to 47.5% (approx) of the current value.

Abstract

In one form the present invention provides a method, system and computer program product for determining the risk of capital value of a financial instrument falling below a pre-determined ratio of the financial instrument's property value at sale, the method including: f) obtaining data related to the value of the property, g) determining which of the data fit within predetermined guidelines, and retaining the data, h) grouping the retained data, in accordance with sub-market criteria, i) determining a mid-point value of each of the grouped data, together with corresponding mean, standard deviation and serial correlation values, and determining, relative to the mid-point, mean, standard deviation and serial correlation values, the likelihood the property value will fall below the predetermined ratio. The present invention also provides a method, system and computer program product for assessing whether a property value is likely to fall to a predetermined value. The present invention is applicable to any financial instrument such as, property, shares, etc. against which a financial facility, for example a loan, might be granted and which financial instrument, fluctuates/grows in its value or market price. The present invention, in one form, has been developed for use in the financial sector, particularly in the field of banking, but also has application in mortgage securitisation, mortgage insurance and other areas where the identification and measurement of the probability of capital loss and/or negative equity for residential real estate is important.

Description

RISK ASSESSMENT AND MEASUREMENT METHOD AND SYSTEM FIELD OF INVENTION
The present invention relates to the financial and banking sectors of business. In one form, the present invention is a residential real estate (RRE) capital value risk identification and estimation tool. In other form(s), the present invention is applicable to any financial instrument such as, property, shares, etc. against which a financial facility, for example a loan, might be granted and which financial instrument, fluctuates/grows in its value or market price. The present invention, in one form, has been developed for use in the financial sector, particularly in the field of banking, but also has application in mortgage securitisation, mortgage insurance and other areas where the identification and measurement of the probability of capital loss and/or negative equity for residential real estate is important. BACKGROUND OF INVENTION The traditional residential real estate (RRE) risk assessment tool for lending and mortgage insurance is the Loan to Value ratio (LVR). The LVR is defined as the mortgage amount at loan commencement divided by the security value at loan commencement. For a number of years, any loan that exceeds a Loan to Value ratio (LVR) of 80% is considered to be "risky" and generally requires mortgage insurance. Loans written at less than a 80% loan to value ratio are considered to be "safe". Lenders and Mortgage insurers alter policy from time to time, depending upon local geographic conditions and may consider not lending or insuring at any price. To date, these risk adjustments tend to be intuitive or semi-empirical. Banking and insurance are considered mature, highly competitive industries with little (considered) chance for differentiation in the market. Banks constantly strive to develop and offer new products and reduce costs.
Banks are in the process of reviewing the role of the traditional Valuer / Appraiser in the lending process in order to reduce cost and speed up process. Statistically derived, automated valuations are becoming more common in the USA and Canada. Australia is starting to follow this path. In essence, the current trend in relation to residential real estate risk assessment is to continue to use a loan to value ratio, but in a manner which is quicker and cheaper and which works on the basis of a "portfolio" of risks. The portfolio of risks is believed to enable exposure to relatively risky loans to be offset with exposure to relatively less risky loans.
The concept of negative equity is considered important in residential financial areas including lending, insurance securitisation, and investment. Negative equity is the term used when the value of a property falls below the outstanding loan amount of the property. It has been clearly demonstrated that negative equity often becomes a trigger for loan delinquency, default and mortgage insurance claims. Standard and Poor's notes that "the major" causes of default in Australia are generally considered to be:
• Loan affordability
• Loss of income
• Personal crisis OR any of the above accompanied by declining property values.
According to Robert Schiller (1996,-Journal of Real Estate ResearchNol.7, Issue 2, p248), one of the world's most well respected finance researchers and practitioners:
"there is no shortage of evidence on the importance of house prices and equity in the default decision".
Quercia and Stegman (1992, Journal of Housing Research, Vol.3, Issue 2, p375) reviewed 29 empirical studies done over a 30-year period and concluded:
"Consistently, home equity, or the related measure of loan to value ratio, has been found to influence the default decision. There is consensus in most recent default studies that the correct measure of a borrower's net equity is the contemporaneous market value of the property less the contemporaneous value of the loan "
Kau, Keenan and Kim (1994, Journal of Urban Economics, Vol.35, Issue 3, p287) reached the same conclusion: "There exists a significant literature examining the causes of default. In conformity with this paper's approach, considerable empirical evidence exists showing that it is the house versus the mortgage value, rather than such personal characteristics as the homeowner's liquidity position, that explains default." In a study using a discrete proportional hazard model, micro-level mortgage data from Freddie Mac, and weighted repeat sales price indices, Quigley, Van Order and Deng (1993, the Competing Risks for Mortgage termination by Defaults and Prepayments in the Residential Housing market, paper presented at National Bureau of Economic Research Summer Institute, Cambridge, MA, USA, at p24) stated:
"The results show that the probability of negative equity ratio is the main time varying covariate influencing mortgage holders default decisions"
In a recent investigation into mortgage defaults in Australia, Berry et. al. (1999, Falling Out of Home Ownership, Mortgage Arrears and defaults in Australia, University of Queensland Press, ISBN: 1 875997 32 6 at p.37) summarized findings:
"mortgage default is viewed from an option taking perspective in which the level of owner's equity, captured by the LVR, is the key causal factor. There is increasing agreement that the correct measure of equity is the difference between current market value of the dwelling and the current market value of the mortgage, rather than the level of equity implicit in the initial LVR." SUMMARY OF INVENTION
It is an object of the present invention to provide a method, system and computer program product which enables capital risk identification and an associated estimation tool therefore.
The present invention provides a method, system and computer program product as outlined in the specification and as defined in the attached claims.
Furthermore, the invention as outlined in the specification and as defined in the attached claims provides a method of providing a financial facility for a transaction involving a financial instrument.
The present invention has come about by realising that the loan to value ratio is a gross generalisation in respect to residential real estate risk. In coming to realise the present invention, research suggests that residential real estate sub-markets, measured at a very fine level of disaggregation, have very different risk profiles. An example of a sub-market is a real estate market specified in terms of geographic location (zip/postcode), type (house / non house) and price (subdivisions /categories). Equally, it should be understood that sub-markets may be determined for any other financial instrument, such as shares for example, where it is suggested that such sub-markets, measured at a very fine level of disaggregation, have very different risk profiles
In most cases, the 80% loan to value ratio marker is considered a gross overstatement or understatement of the real sub-market risk. In addition, the measure of risk for a given sub-market is dynamic, and will tend to change depending upon underlying factors such as economic cycles, price levels and/or other economic and non-economic events.
In addition, it has been realised that the real residential real estate or other properties risk occurs not only at the time of arranging the financial facility but is significant for a period of years. That period varies on financial conditions and the terms of the mortgage, but 5 years is considered a reasonable period for domestic mortgages. During this period, the loan principal has usually been reduced by a relatively small amount, whereas property markets and economies may have changed significantly. It is during this 3 to 5 year period from the commencement of the loan that the residential real estate security risk exists. The present invention is directed, in one aspect to the identification and measurement of the probability of "negative equity" or the outstanding loan amount exceeding the value of the financial instrument at any time during this period. It is considered that this is the real measure of risk, not the initial loan to value ratio(LVR).
The present invention has a number of advantages, which include: That it will allow users in the finance industry to improve their risk assessment in the RRE market. In turn, this will allow them to better direct their business and minimise losses. Another benefit of the present invention is to allow increased returns on a risk adjusted basis. That it will enable estimation of the probability of negative equity (value less than outstanding loan balance) at a user set confidence level for a period 3 to 5 years in the future. This calculation can be undertaken for any financial instrument, for example, residential property type or value in any location, where sufficient historical data is available. An example output may be as follows: Example 1 - Ballarat decile 1 (lowest 10%) houses: 1. To be 95% confident of no negative equity in this residential real estate sub-market, lend only up to 89% (approx) of the current value.
2. There is a 23.3% chance that this residential real estate sub-market will fall below its current value within the next 5 years. 3. There is a 76.7% chance that this residential real estate sub-market will not fall below it's current value within the next 5 years. Example 2 - Toorak decile 1 (lowest 10%) houses:
1. To be 95% confident of no negative equity in this residential real estate sub-market, lend only up to 47.5% (approx) of the current value. 2. There is a 75.7% chance that this residential real estate sub-market will fall below its current value within the next 5 years.
3. There is a 24.3% chance that this residential real estate sub-market will not fall below it's current value within the next 5 years
In determining the present invention, the Applicant's research indicates that based on historical data, residential property sub markets specified in terms of geographic location (zip / postcode), type (house / non house) and price (subdivisions /categories) have:
• Substantially different risks of negative equity,
• Substantially different financial performance characteristics, • Different trend growth rates and,
• Different probabilities of market value rise or fall.
Because the present invention is forward looking i.e., looking at what might happen at any time in the next 5 years, and expressed in terms of probabilities, the results can be used to help any business involved in residential finance to: • Identify and measure detailed subdivisions of risk
• Manage and mitigate that risk,
• Set explicit risk policies and strategies,
• Direct business to where the greatest risk adjusted rates of return can be gained, • Provide for capital adequacy on a more accurate basis,
• Provide for VAR (Value at Risk) input,
• Move away from intuitive or semi empirical measures of risk. Equally, the present invention may be applicable to many other financial instruments (property, shares, etc ...) against which a financial facility such as a loan might be granted and which instrument fluctuates/changes in value or market price. Most commonly, this would be property, but the principles could be applied generally. The type of investment against which the loan is granted would need to be able to be grouped into sufficiently homogenous subsets for analysis to be meaningful. For example, loans secured against business operations would need to be assessed against the on-going value of a business. Analysis of loans secured against a share portfolio of, for example, the All Ordinaries, may also be contemplated in accordance with the present invention. DESCRIPTION OF PREFERRED EMBODIMENT
A preferred embodiment of the present invention, which relates to residential real estate, will now be described. It is to be borne in mind that the present invention also has similar application to many other financial instruments or properties: 1. DATA :
An embodiment of the present invention, directed at residential real estate uses residential real estate historical sales data that is sourced from either the
Valuers General office's or from private data resellers. In the USA, data is more freely available than in Australia and thus it should be easier to obtain the necessary data.
In the first instance, historical sales data from as many years as possible is required. 10 years would probably be a minimum. In Victoria, we are using 16 years of data.
Because the data is from different sources, it contains a variety of fields, formats, and is of varying quality. The data needs to be standardised in its format, fields, and the like before they can be agglomerated into one data file. The required data fields are price, date of transaction, property type (house or flat/unit) and postcode. Data for land sales are not analysed.
In Victoria, there are 1.6 million sales recorded between 1985 and 2001. In all, the model would use about 6 million records of base data and each record would have 4 fields.
The database associated with the present invention would be updated periodically and probabilities re-calculated. Each year, another 500,000 records could be added. If updated on a quarterly basis, 125,000 records would be added.
Historical output from the present model would also be collected so that, in future, the dynamics of the RRE markets could be displayed and analysed. 2. DATA CLEANING AND CHECKING:
The data would be cleaned and checked using a purpose built, rules based algorithm. We wish to identify and remove mathematically intractable, inconsistent, illogical and substandard observations, outliers, incomplete sets etc.
A preferred set of rules may reflect that the data is reviewed to ensure that it consists of values that could represent a single house or flat at a given point in time, and that it may provide a reasonable basis for analysis.
2A. Initially the data is reviewed to ensure that the number of sales per annum provided for a dwelling type and suburb is greater than 20. The basis for this is that the property prices are divided into deciles. With less than 20 observations, the value of a decile can be too heavily influenced by a single data point/sale. In our research, this test omitted the most data in comparison to the other criterion below. Out of 58,180 observations, 329 were omitted, as there was too few observations to maintain statistical accuracy or relevancy.
"Points" may be just sales data values, by year, by Flat/House, and / or by suburb. They may be the individual data records.
2B. The values must be between the set ranges. For our purposes we have set the low log price to 9 ($8,103) and the high to 17 ($24,154,953)
In the same data set as in 1., 100 prices were deemed to be too small, and
62 too large. 2C. The price must be within a ratio of ± 2 from the nearest price. Note that the logged prices are estimated to 1 decimal place. The above criterion means that the value can be no more than 7 log-points from the last observation.
For example, the last logged price observed for Boronia houses was 13.4.
The next observation is 14.3. There are (14.3-13.4)/0.1 = 9 logged price points between the two observations. This equates to a ratio of 2.46 which is outside the range. The price difference in dollar terms is $963,343.
2D. There must be at least 3 contiguous points when the data are grouped in bands of 0.1 by log-price. This ensures that the points are not too scattered. Data is tested for sufficient residual numbers to determine if calculations will be statistically significant or the whole set should be identified and removed.
It has been determined that if the data is too sparse, we cannot offer a service in respect of that section of the market based on that sample having sufficient statistical accuracy.
3. DATA SPLITTING:
Data are split into their respective sub-markets. A residential real estate property sub-market is a transaction:
• in a given postcode • either a house or a unit/flat and
• within a yearly dynamic price quantile, (at this stage a decile) described by the total range of a given years sales data. This process involves sorting the data in ascending order, and then counting, for example, one-tenth of the sorted data to determine or get the first decile point. A useful and advantageous approach at present is to take the mid-point to represent the value for the range. For example, the value of the first 20th-quantile is taken to represent the value for the first decile.
When this process is complete, there are mathematically tractable data sets for some 150,000 property sub-markets across Australia. The historical performance characteristics of these property markets are now capable of being analysed, described statistically and boundary conditions set for the future based on their historical performance.
Values are obtained at the mid-points of the deciles, and these are taken as being proxies for the whole decile, and ratio values are obtained across years to get year-on-year rates of change in value of that decile. The "boundary condition parameters" are the mean, standard deviation and serial correlation values derived for such a data set, comprising the yields obtained for one decile in one house/flat set for one suburb.
This database will be unique in Australia and could form the basis of other useful work.
4. RATE OF CHANGE:
Decile mid points are calculated for each year for each sub-market and rates of change between each year's midpoints are calculated and stored. For each sub-market we now have one datum point per year - 15 rates of change for 16 years. The rates of change are converted to the "force of interest" equivalents, by taking the natural logarithm of the 1 + the rate of change expressed as a decimal. For example, a rate of change of 10% is expressed as ln(1.1) = 0.09531.
These data point series form the basis of subsequent calculations : mean, standard deviation, and serial correlation values.
5. DESCRIPTIVE CALCULATIONS:
The 150,000 RRE sub-markets with 15 data points each have mean, standard deviation and serial correlations with 1 , 2 and 3 year lags calculated.
6. CALCULATION OF BOUNDARY CONDITIONS AND PROBABILITIES: We are using a 5 parameter algorithm at this stage, but in the future, and depending upon data available, more or fewer parameters may be used. The key outputs are expressed as : if a loan is granted at x% of valuation, what is the likelihood that the price will fall below the loan amount over the next 5 years.
Alternatively, if the lender wants there to be only a 5% chance that there will be negative equity over the next 5 years, how much should be lent as a % of sale price.
For example, with one set of parameters, if the lender is prepared to accept a 20% chance of negative equity at any time in the first 5 years, 80.6% of valuation could be lent. For a more conservative 5% chance, only 68.1% would be made available to the purchaser.
The process proceeds by assuming no capital repayments in the first 5 years, and using the Normal distribution assumption in conjunction with the parameter values calculated to derive the probabilities.
The outputs from this multi parameter algorithm are stored in a database with pre-defined fields.
The following description outlines one process of determining Loan to
Value Ratios (LVR), in accordance with the present invention, by assessment of the likelihood of property values falling to any given / predetermined level.
Obviously, other formulae or techniques could be used. Pairs of { } indicate the start and end of a given sub-process. Determine or get the relevant yields from year to year, for a given sub- market criteria, such as, for each suburb, for houses/flats separately, and for each decile
Figure imgf000011_0001
where rt,i is Yield in year t and the ith quantile;
Pt,i is the Consideration in year t and the ith quantile.
and calculate mean, delta, by
Figure imgf000011_0002
where ry is Yield in year t and the ith quantile; n is the number of years with 'calculated' yields;
Mean: Sum of all values divided by the number of observations Determine or get the relevant standard deviation and serial correlation parameter;
Standard deviation:
Figure imgf000011_0003
where s is the standard deviation of delta; n is the number of years with 'calculated' yields' Xj,i is the natural log of 1 plus the yield in year j and the ith quantile
Serial correlation parameters: these were approximated using a similar formula to below
-ΣLwfo - **--* -*) .
-k = 0,l,2...timelag
Figure imgf000011_0004
Construct the Cholesky matrix C, such that C'.C produces the matrix formed by s'.R.s where s is the column matrix of standard deviations, and R is the square matrix of serial correlations. For example, for serial correlations po , pi and p2 construct as
R = 11 Ppoo Ppii p2
Po 1 Po Pi
Pi Po 1 Po
P2 Pi Po 1 arge number of simulations (e.g. 10000) { Set an arbitrary initial property value Construct column matrix X of the most recent yields in reverse order. For example, if the most recent log yields are y-i, y2, y3, construct as y3, y2, yi.O For each of five years {
Solve for z such that z=C" (X-μ) where μ is a column matrix of the mean returns. Derive z4 as a Normal(0,1) variate.
(We do this using the Box-Muller formulae, but any method would suffice)
Calculate simulated returns as μ + C*z
Retain the z values for all but the most recent year, and re-position the remainder so that they relate to one year earlier;
From the current year yield returned, calculate the revised estimate of a property value as last value times Exp(Current Year's return value).
} Take the lowest value of the property over the five year period
Divide the lowest value by the original property price at time 0 to obtain a price ratio
The % chance that a residential real estate sub-market will fall below its current value within the next 5 years is estimated accordingly. } 7. DATABASE:
Database Front End:
At this stage, the output data stored in the database can be interrogated, picked, re-arranged and re-expressed in a number of ways to answer many different types of questions.
An example given previously was: Example 1 - Ballarat decile 1 (lowest 10%) houses:
A. To be 95% confident of no negative equity in this RRE sub-market, lend up to 89% (approx) of the current value. B. There is a 23.3% chance that this RRE sub-market will fall below its current value within the next 5 years.
C. There is a 76.7% chance that this RRE sub-market will not fall below it's current value within the next 5 years.
Example 2 - Toorak decile 1 (lowest 10%) houses: A. To be 95% confident of no negative equity in this RRE sub-market, lend up to 47.5% (approx) of the current value.
B. There is a 75.7% chance that this RRE sub-market will fall below its current value within the next 5 years.
C. There is a 24.3% chance that this RRE sub-market will not fall below it's current value within the next 5 years.
Problems & Solutions:
The following is a summary of the current problems or limitations that various business types within the financial sector experience and how the present invention(LR) helps to solve these problems.
Figure imgf000013_0001
Figure imgf000014_0001
Figure imgf000015_0001
Similar industry relevant issues are applicable to mortgage insurance, securatisation and ratings processes. As the present invention may be embodied in several forms without departing from the spirit of the essential characteristics of the invention, it should be understood that the above described embodiments are not to limit the present invention unless otherwise specified, but rather should be construed broadly within the spirit and scope of the invention as defined in the appended claims. Various modifications and equivalent arrangements are intended to be included within the spirit and scope of the invention and appended claims.

Claims

CLAIMS:
1. A method of determining the risk of capital value of a financial instrument falling below a pre-determined ratio of the financial instrument's property value at sale, the method including: a) obtaining data related to the value of the property, b) determining which of the data fit within predetermined guidelines, and retaining that data, c) grouping the retained data, in accordance with sub-market criteria, d) determining a mid-point value of each of the grouped data, together with corresponding mean, standard deviation and serial correlation values, and e) determining, relative to the mid-point, mean, standard deviation and serial correlation values, the likelihood the property value will fall below the predetermined ratio.
2. A method as claimed in claim 1 , wherein the data obtained related to property value is over a period of at least 10 years.
3. A method as claimed in claim 1 or 2, wherein the guidelines include at least one of: i) reviewing that a property type of each financial instrument has at least 20 points, ii) setting a market price for each property within a range, iii) a market price being within a ratio of 2 from the nearest price, and iv) having 3 contiguous points in a scale of 0.1 in logged prices.
4. A method as claimed in any one of claims 1 to 3, wherein the sub-market criteria includes post-code, type of property, yearly dynamic price quantile.
5. A method as claimed in any one of claims 1 to 4, wherein at least one of steps b) to e) of claim 1 , are carried out in accordance with a predetermined instruction set operating on a processor device.
6. A method of assessing whether a property value is likely to fall to a predetermined value, the method including: determine the relevant yields from year to year, for a given sub-market criteria, according to a formula
Figure imgf000017_0004
where rt|, is Yield in year t and the ith quantile;
Pt,ι is the Consideration in year t and the ith quantile; and calculate a mean, delta, by
Figure imgf000017_0001
where rt,, is Yield in year t and the ith quantile; n is the number of years with 'calculated' yields;
Mean is sum of all values divided by the number of observations; determine the relevant standard deviation and serial correlation parameters, according to a formula
standard deviation:
Figure imgf000017_0002
where s is the standard deviation of delta n is the number of years with 'calculated' yields
Xj,ι is the natural log of 1 plus the yield in year j and the ith quantile serial correlation parameters approximated using a formula:
Figure imgf000017_0003
construct the Cholesky matrix C, such that C'.C produces the matrix formed by s'.R.s where s is the column matrix of standard deviations, and R is the square matrix of serial correlations, such that, for serial correlations po , pi and P2 construct as
R = 1 Po Pi P2
Po 1 Po Pi
Pi Po 1 Po
P2 Pi Po 1 for a large number of simulations (e.g. 10000) { set an arbitrary initial property value; construct column matrix X of the most recent yields in reverse order, such that, the most recent log yields, y-i, y2, y3, construct as y3, y2, yι,0 for each of five years { solve for z such that z=C"1(X-μ) where μ is a column matrix of the mean returns; derive z4 as a Normal(0,1 ) variate; dalculate simulated returns as μ + C*z retain the z values for all but the most recent year, and reposition the remainder so that they relate to one year earlier; from the current year yield returned, calculate the revised estimate of a property value as the last value multiplied by exp(current year's return value);
} take the lowest value of the property over a predetermined period; divide the lowest value by the original property price at a time 0 to obtain a price ratio; determine whether the price ratio is equal to or less than the predetermined value
}
7. A method as claimed in claim 6 wherein, the given sub-market criteria is at least one of the following: a) suburb; b) house or flat, and; c) decile.
8. A method as claimed in claim 6 or 7 wherein, z4 is derived using a Box- Muller formulae.
9. A system operable to perform the method as claimed in any one of claims 1 to 5 or 6 to 8.
10. A computer program product including: a computer usable medium having computer readable program code and computer readable system code embodied on said medium for determining the risk of capital value of a financial instrument falling below a predetermined ratio of the financial instrument's property value at sale within a data processing system, said computer program product including: computer readable code within said computer usable medium for performing a method as claimed in any one of claims 1 to 5.
11. A computer program product including: a computer usable medium having computer readable program code and computer readable system code embodied on said medium for assessing whether a property value is likely to fall to a predetermined value within a data processing system, said computer program product including: computer readable code within said computer usable medium for performing a method as claimed in any one of claims 6 to 8.
12. A method of providing a financial facility for a transaction involving a financial instrument including the steps of a method as claimed in claims 1 to 5 or 6 to 8.
13. A method, system or product as herein disclosed.
PCT/AU2003/000448 2002-04-15 2003-04-15 Risk assessment and measurement method and system WO2003090130A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2003218528A AU2003218528A1 (en) 2002-04-15 2003-04-15 Risk assessment and measurement method and system

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
AUPS1694A AUPS169402A0 (en) 2002-04-15 2002-04-15 Risk assessment and measurement method and system
AUPS1694 2002-04-15

Publications (1)

Publication Number Publication Date
WO2003090130A1 true WO2003090130A1 (en) 2003-10-30

Family

ID=3835271

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/AU2003/000448 WO2003090130A1 (en) 2002-04-15 2003-04-15 Risk assessment and measurement method and system

Country Status (2)

Country Link
AU (1) AUPS169402A0 (en)
WO (1) WO2003090130A1 (en)

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7783505B2 (en) 2003-12-30 2010-08-24 Hartford Fire Insurance Company System and method for computerized insurance rating
US7899741B2 (en) 2007-03-28 2011-03-01 Bank Of America Corporation Loss impact tracking system and method
US8090599B2 (en) 2003-12-30 2012-01-03 Hartford Fire Insurance Company Method and system for computerized insurance underwriting
US8676612B2 (en) 2003-09-04 2014-03-18 Hartford Fire Insurance Company System for adjusting insurance for a building structure through the incorporation of selected technologies
US8751351B1 (en) * 2009-06-11 2014-06-10 United Services Automobile Association (Usaa) Systems and methods for providing a marketplace of goods subject to distressed financial obligations
US9076185B2 (en) 2004-11-30 2015-07-07 Michael Dell Orfano System and method for managing electronic real estate registry information
US9311676B2 (en) 2003-09-04 2016-04-12 Hartford Fire Insurance Company Systems and methods for analyzing sensor data
US9460471B2 (en) 2010-07-16 2016-10-04 Hartford Fire Insurance Company System and method for an automated validation system
US9665910B2 (en) 2008-02-20 2017-05-30 Hartford Fire Insurance Company System and method for providing customized safety feedback
CN112991070A (en) * 2021-03-16 2021-06-18 武汉大学 Multi-layer stock right penetrating method for financial stock right knowledge large graph

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA2086269A1 (en) * 1992-12-24 1994-06-25 Michael Willis Credit risk assessment system
US5361201A (en) * 1992-10-19 1994-11-01 Hnc, Inc. Real estate appraisal using predictive modeling
US6058369A (en) * 1991-03-11 2000-05-02 R.E. Rothstein Method and apparatus for monitoring the strength of a real estate market and making lending and insurance decisions therefrom
US20010029477A1 (en) * 1997-07-11 2001-10-11 Chase Manhattan Bank Method for mortgage and closed end loan portfolio management
US20010047327A1 (en) * 2000-04-10 2001-11-29 Courtney Michael T. System and method for calculating mortgage loan balance to appraisal value ratio
CA2363366A1 (en) * 2000-11-15 2002-03-16 Reavs Information Technologies Limited Method for automatically processing a financial loan application and the system thereof
WO2002029690A2 (en) * 2000-10-05 2002-04-11 Thomas Herzfeld Renewable repriced mortgage guaranty insurance

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6058369A (en) * 1991-03-11 2000-05-02 R.E. Rothstein Method and apparatus for monitoring the strength of a real estate market and making lending and insurance decisions therefrom
US5361201A (en) * 1992-10-19 1994-11-01 Hnc, Inc. Real estate appraisal using predictive modeling
CA2086269A1 (en) * 1992-12-24 1994-06-25 Michael Willis Credit risk assessment system
US20010029477A1 (en) * 1997-07-11 2001-10-11 Chase Manhattan Bank Method for mortgage and closed end loan portfolio management
US20010047327A1 (en) * 2000-04-10 2001-11-29 Courtney Michael T. System and method for calculating mortgage loan balance to appraisal value ratio
WO2002029690A2 (en) * 2000-10-05 2002-04-11 Thomas Herzfeld Renewable repriced mortgage guaranty insurance
CA2363366A1 (en) * 2000-11-15 2002-03-16 Reavs Information Technologies Limited Method for automatically processing a financial loan application and the system thereof

Cited By (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10354328B2 (en) 2003-09-04 2019-07-16 Hartford Fire Insurance Company System for processing remote sensor data
US8676612B2 (en) 2003-09-04 2014-03-18 Hartford Fire Insurance Company System for adjusting insurance for a building structure through the incorporation of selected technologies
US11182861B2 (en) 2003-09-04 2021-11-23 Hartford Fire Insurance Company Structure condition sensor and remediation system
US9311676B2 (en) 2003-09-04 2016-04-12 Hartford Fire Insurance Company Systems and methods for analyzing sensor data
US10817952B2 (en) 2003-09-04 2020-10-27 Hartford Fire Insurance Company Remote sensor systems
US9881342B2 (en) 2003-09-04 2018-01-30 Hartford Fire Insurance Company Remote sensor data systems
US10032224B2 (en) 2003-09-04 2018-07-24 Hartford Fire Insurance Company Systems and methods for analyzing sensor data
US8090599B2 (en) 2003-12-30 2012-01-03 Hartford Fire Insurance Company Method and system for computerized insurance underwriting
US7783505B2 (en) 2003-12-30 2010-08-24 Hartford Fire Insurance Company System and method for computerized insurance rating
US10650459B2 (en) 2003-12-30 2020-05-12 Hartford Fire Insurance Company Computer system and method for management of user interface data
US9076185B2 (en) 2004-11-30 2015-07-07 Michael Dell Orfano System and method for managing electronic real estate registry information
US7899741B2 (en) 2007-03-28 2011-03-01 Bank Of America Corporation Loss impact tracking system and method
US9665910B2 (en) 2008-02-20 2017-05-30 Hartford Fire Insurance Company System and method for providing customized safety feedback
US8751351B1 (en) * 2009-06-11 2014-06-10 United Services Automobile Association (Usaa) Systems and methods for providing a marketplace of goods subject to distressed financial obligations
US9824399B2 (en) 2010-07-16 2017-11-21 Hartford Fire Insurance Company Secure data validation system
US10740848B2 (en) 2010-07-16 2020-08-11 Hartford Fire Insurance Company Secure remote monitoring data validation
US9460471B2 (en) 2010-07-16 2016-10-04 Hartford Fire Insurance Company System and method for an automated validation system
CN112991070A (en) * 2021-03-16 2021-06-18 武汉大学 Multi-layer stock right penetrating method for financial stock right knowledge large graph
CN112991070B (en) * 2021-03-16 2023-11-10 武汉大学 Multi-layer equity penetration method for financial equity knowledge block diagram

Also Published As

Publication number Publication date
AUPS169402A0 (en) 2002-05-16

Similar Documents

Publication Publication Date Title
Jackson et al. The performance of insolvency prediction and credit risk models in the UK: A comparative study
Altman Revisiting credit scoring models in a Basel 2 environment
Lu et al. Information uncertainty, information asymmetry and corporate bond yield spreads
Abraham et al. New evidence on home prices from Freddie Mac repeat sales
Islamoglu et al. An evaluation of the financial performance of REITs in Borsa Istanbul: A case study using the entropy-based TOPSIS method
Cici et al. Missing the marks? Dispersion in corporate bond valuations across mutual funds
Doumpos et al. Developing and testing models for replicating credit ratings: A multicriteria approach
Benos et al. Extending the Merton model: A hybrid approach to assessing credit quality
Fernandes Corporate credit risk modeling: Quantitative rating system and probability of default estimation
Kang et al. Option-implied risk preferences: an extension to wider classes of utility functions
Park et al. The effect of information asymmetry on investment behavior in cryptocurrency market
WO2003090130A1 (en) Risk assessment and measurement method and system
Aschakulporn et al. New Zealand whole milk powder options
CN113222767A (en) Data processing method and device for indexing securities combination
Leksrisakul et al. A model of corporate bankruptcy in Thailand using multiple discriminant analysis
KR102488653B1 (en) Value calculation and chart display service provision system through financial statement analysis
Lu et al. An approach to condition the transition matrix on credit cycle: An empirical investigation of bank loans in Taiwan
EJIKE et al. Empirical study of Impact of capital structure on Deposit Money Banks in Nigeria
Rusilawati et al. The Influence of Liquidity, Capital Structure and Profitability on Company Value (Case Study of Property and Real Estate Companies Listed on the IDX 2018-2022)
KR20170004934A (en) System and Method for Real time based Credit Risk Analysis using the Integrated Account Information
Paradi et al. Corporate failure analysis using SBM
Husák Do Damodaran’s Multiples Value a Company Accurately? Evidence from Germany
Abdul-Baki Do information asymmetry proxies measure information asymmetry?
KR101853580B1 (en) System and method for diagnosing stock of unlisted company
Sunaryo Effect Of Earnings Opacity On Cost Of Equity

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NI NO NZ OM PH PL PT RO RU SD SE SG SK SL TJ TM TN TR TT TZ UA UG US UZ VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase

Ref country code: JP

WWW Wipo information: withdrawn in national office

Country of ref document: JP