Abstract: A computer-assisted, automated method and system for combining loan and asset data in a data warehouse, which provides an early warning system for potential risks and a facility for portfolio and market analysis. The system provides online access, data manipulation, analytical capabilities and report production. The system continuously monitors the lender's data versus thresholds in order to provide alerts. The system selects data on a regular basis, calculates market indices and creates additional data values based on these calculated indices. The market indices are stored in an aggregated data area and are available to user's system-wide.