TECHNIQUES FOR IDENTIFYING HIGH-RISK PORTFOLIO WITH AUTOMATED COMMERCIAL REAL ESTATE STRESS TESTING

1 . A system for performing stress testing on commercial real estate loans, the system comprising:

a commercial real estate stress test (CREST) server configured to automatically perform real estate stress testing for commercial real estate, wherein the CREST server is configured to perform the following steps:

receiving loan information for a commercial property from a bank;

retrieving real estate trend data from an external data source;

estimate various values for use in automated commercial real estate stress testing based on the loan information from the bank and the real estate trend data from the external data source; and

a commercial real estate (CRE) data store connected to the CREST server and configured to store data for the CREST server.

2 . The system of claim 1 , further comprising analytics programs executable by the CREST server, wherein the analytics programs configured to evaluate the loan data received from the bank and to identify which information needs to be updated or replaced using the commercial real estate data from the external data source.

3 . The system of claim 1 , wherein estimating values further comprises determining an estimated present value of the commercial property based on an appraised collateral value for the property included in the loan information received from the bank and property value trend information included in the real estate trend data retrieved from an external source.

4 . The system of claim 3 , wherein the loan information also includes as of date information for the appraised collateral value.

5 . The system of claim 3 , wherein the property value trend information is presented as a series of time/value pairs representing the proportional change of collateral values over a time period.

6 . The system of claim 5 , wherein the time period is monthly or quarterly.

7 . the system of claim 5 , wherein the time/value pairs are expressed as index values.

8 . The system of claim 5 , wherein the time/value pairs are expressed as prices per square foot.

9 . The system of claim 3 , wherein determining an estimated present value of the commercial property further comprises:

selecting a first property trend value (y) representing proportional changes in property values over time from the property value trend information, the first property trend value corresponding to a date when the loan information was last updated;

selecting a second property trend value (x) representing proportional changes in property values over time from the property value trend information, the second property trend value corresponding to a date when the property was appraised;

calculating the estimated current property value of the property using the following equation:

(((y−x)/x)+100%)*Appraised Collateral Value; and

storing the estimated current property value in the CRE data store.

10 . The system of claim 3 , wherein estimating various values further comprises determining an estimated current cap rate of the commercial property based on cap rate information included in the loan information and cap rate trend information included in the real estate trend data retrieved from an external source.

11 . The system of claim 10 , wherein the loan information also includes as of date information related to the cap rate information.

12 . The system of claim 10 , wherein the cap rate trend information is presented as a series of time/value pairs representing actual cap rates over a time period.

13 . The system of claim 12 , wherein the time period is monthly or quarterly.

14 . The system of claim 10 , wherein determining the estimated current cap rate of the commercial property further comprises:

selecting a first cap rate trend value (y) representing proportional changes in cap rates over time from the property value trend information, the first cap rate trend value corresponding to a date when the loan information was last updated;

selecting a second cap rate trend value (x) representing proportional changes in cap rates over time over time from the property value trend information, the second cap rate trend value corresponding to a date when the property was appraised;

calculating the estimated current cap rate of the property using the following equation:

(((y−x)/x)+100%)*Appraised Cap Rate; and

storing the estimated current cap rate in the CRE data store.

15 . The system of claim 10 , wherein estimating various values further comprises determining an estimated net operating income of the commercial property based on the estimated present value of the commercial property and the estimated current cap rate of the commercial property.

16 . The system of claim 15 , wherein determining the estimated net operating income of the commercial property further comprises:

calculating the estimated current cap rate of the property using the following equation:

(estimated present value)×(estimated current cap rate); and

storing the estimated net operating income in the CRE data store.

17 . A system for estimating a net operating income for a property, the system comprising:

a commercial real estate stress test (CREST) server configured to automatically perform real estate stress testing for commercial real estate, wherein the CREST server is configured to perform the following steps:

receiving loan information for a commercial property from a bank;

retrieving real estate trend data from an external data source;

determining an estimated present value of the commercial property based on an appraised collateral value for the property included in the loan information received from the bank and property value trend information included in the real estate trend data retrieved from an external source;

determining an estimated current cap rate of the commercial property based on cap rate information included in the loan information and cap rate trend information included in the real estate trend data retrieved from an external source;

determining an estimated net operating income of the commercial property based on the estimated present value of the commercial property and the estimated current cap rate of the commercial property; and

a commercial real estate (CRE) data store connected to the CREST server and configured to store data for the CREST server.

18 . The system of claim 17 , further comprising analytics programs executable by the CREST server, wherein the analytics programs configured to evaluate the loan data received from the bank and to identify which information needs to be updated or replaced using the commercial real estate data from the external data source.

19 . The system of claim 17 , wherein determining an estimated present value of the commercial property further comprises:

selecting a first property trend value (y) representing proportional changes in property values over time from the property value trend information, the first property trend value corresponding to a date when the loan information was last updated;

selecting a second property trend value (x) representing proportional changes in property values over time from the property value trend information, the second property trend value corresponding to a date when the property was appraised;

calculating the estimated current property value of the property using the following equation:

(((y−x)/x)+100%)*Appraised Collateral Value; and

storing the estimated current property value in the CRE data store.

20 . The system of claim 17 , wherein determining the estimated current cap rate of the commercial property further comprises:

selecting a first cap rate trend value (y) representing proportional changes in cap rates over time from the property value trend information, the first cap rate trend value corresponding to a date when the loan information was last updated;

selecting a second cap rate trend value (x) representing proportional changes in cap rates over time over time from the property value trend information, the second cap rate trend value corresponding to a date when the property was appraised;

calculating the estimated current cap rate of the property using the following equation:

(((y−x)/x)+100%)*Appraised Cap Rate; and

storing the estimated current cap rate in the CRE data store.

21 . The system of claim 17 , wherein determining the estimated net operating income of the commercial property further comprises:

calculating the estimated current cap rate of the property using the following equation:

(estimated present value)×(estimated current cap rate); and

storing the estimated net operating income in the CRE data store.

22 . The system of claim 17 , wherein the loan information also includes as of date information for the appraised collateral value.

23 . The system of claim 17 , wherein the property value trend information is presented as a series of time/value pairs representing the proportional change of collateral values over a time period.

24 . The system of claim 23 , wherein the time period is monthly or quarterly.

25 . The system of claim 23 , wherein the time/value pairs are expressed as index values.

26 . The system of claim 23 , wherein the time/value pairs are expressed as prices per square foot.

27 . The system of claim 17 , wherein the loan information also includes as of date information related to the cap rate information.

28 . The system of claim 17 , wherein the cap rate trend information is presented as a series of time/value pairs representing actual cap rates over a time period.

29 . The system of claim 28 , wherein the time period is monthly or quarterly.