Abstract: The present invention discloses an engineering solution to the automation of funding assessing and managing collateral dependent loans and indexed linked products. Equity Finance Mortgages (EFM's) are issued by financial institutions and have a return, either profit or loss, which is determined by the way residential real estate market rise or fall respectively. Financial index products sold by some financial entities are akin to bonds or term deposits and pay a return to investors which is linked to the performance of a house or home price index. Consequently, an EFM issuing institution can hedge its exposures to the residential real estate market by selling such financial index products so that profits or losses on the EFM's are offset by the losses or profits respectively of the index products. Methods of calculating an appropriate matching of the dollar value of the EFM's and index products are disclosed.

Abstract: A method and system for generating a real estate property index uses real estate data including price data, property data and time of sale data that are entered into a computing apparatus. The time of sale data is manipulated to provide consecutive triple times giving two consecutive time periods (e.g., March, April, May 2007 and April, May, June 2007). A transform function, preferably a long function, is generated with two time dummy variables, and the coefficients of the two time dummy variables are extracted and added to generate a transformed growth rate. The reverse transform function, preferably an anti-log function, is generated to provide the desired untransformed growth rate.

Abstract: A method and system for generating a real estate property index uses real estate data including price data, property data and time of sale data that are entered into a computing apparatus. The time of sale data is manipulated to provide consecutive triple times giving two consecutive time periods (e.g., March, April, May 2007 and April, May, June 2007). A transform function, preferably a log function, is generated with two time dummy variables, and the coefficients of the two time dummy variables are extracted and added to generate a transformed growth rate. The reverse transform function, preferably an anti-log function, is generated to provide the desired untransformed growth rate.

Abstract: A method and system for generating a real estate property index uses real estate data including price data, property data and time of sale data that are entered into a computing apparatus. The time of sale data is manipulated to provide consecutive triple times giving two consecutive time periods (e.g., March, April, May 2007 and April, May, June 2007). A transform function, preferably a log function, is generated with two time dummy variables, and the coefficients of the two time dummy variables are extracted and added to generate a transformed growth rate. The reverse transform function, preferably an anti-log function, is generated to provide the desired untransformed growth rate.