Products
DataRaptor®: Mortgage Portfolio Loan Stratification System
DataRaptor® is a loan-level data management application that utilizes a highly efficient ETL process to load, reformat, standardize, audit, and aggregate mortgage asset data. DataRaptor® is a user-configurable tool that facilitates custom data solutions and reporting options. DataRaptor® features:
Data Extraction
- Flexible data model that works natively with SQL Server, but will accept data from any ODBC data source
- Wizards and Tools with automatic type recognition that enable easy creation of input and output templates
- Support for user-configured field formats that assist data validation and loading of non-standard data
Data Cleansing
- User-configurable tools for formatting, standardizing, and auditing data fields
- Built-in scripting language offering complete flexibility in configuring business logic or data scrubbing rules with built in string, date, and math functions as well as syntax checker and test rule features
- Audit engine with wizards and modules to facilitate creation of data mapping, error tracking, and calculation rules
- Support for external data as well as wild cards and numeric ranges
Aggregation and Output
- Creation of pooling categories or trees via interactive interface
- Support for all standard loan aggregation types
- Pass loan-level or pooled or tranche level data into WinOAS™, MarketShield™, MIAC-ALM™ or any other table format
- Stratification of MSR Assets
- Stratification of Whole Loan Assets
Reporting
- Built-in reporting tool to create, edit, export (pdf, excel, html, txt, etc), and print customizable reports
- Ability to view reports created in Crystal Report
OLAP (On-Line Analytical Processing) and Data Cubes
- Imbedded support for OLAP (with SQL Server)
- Wizards to facilitate creation of multidimensional cubes
- Cube viewer to visualize data relationships and to create and save user-defined views
- Export data to HTML and Excel
WinOAS™: Option Adjusted Spread and Cash Flow Engine
The WinOAS™ is MIAC’s Option-Adjusted Spread (“OAS”) pricing program providing static, scenario and OAS valuation of residential and commercial whole loans, mortgage servicing, consumer loans and subprime residual assets.
- Simply the most widely installed and validated mortgage pricing model in the industry.
- Deploys an industry leading and fully validated Libor Market Model (LMM) term structure model.
- Highly user configurable pricing assumptions with full SarBox audit trial and user permissions controls.
Supports nearly 30 different voluntary prepayment model types and 10 different delinquency/FCL model types.
- Allows extensive “what if” calculations of price, yield, duration, convexity, etc. for a residential and commercial mortgage loan portfolios by changing prepayment forecasts, discount rates, cost to service, probabilities of default, expected loss severities, time to foreclose, etc.
- Complete documentation of all Cash Flows Components including: Prepayments, Delinquencies, Foreclosures, Vectored Costs, Escrow Floats, etc. can be copied and pasted into any spreadsheet or database for additional analysis.
- Tightly integrated with DataRaptor®, MarketShield©, and ALM/VAST©.
- Provides a Distributed Processing Mode (DPM) option for ultra-fast performance including as many as a 1,000 CPUs.
Acadametrics Prices and Transactions (APAT)
Whilst the lenders indices provide mortgage offer valuations at regional level, compiled on a quarterly basis. Acadametrics uniquely provides the only data based upon real transacted prices at regional, county/London borough levels (or post code sector level) which are available monthly. APAT provides the smoothed average of every LR transacted price at region and county/London borough, or post code sector, level by property type, for client in-house use.
Stress and Scenario Testing (SST)
Stress and Scenario Testing (SST) – our models have always forecast loan by loan losses, based upon real data, meeting a need for loan level output that is now recognised. Our unique 1989-1995 default database encompasses a range of scenarios, such as “benign”, “average”, “severe” and “worst case”. Thus, we are able to set a lender book, loan by loan, into each scenario and to use the past data to forecast the Probability of Possession and the Loss in the Event of Possession, based upon e.g. client-specified house price and mortgage interest rate scenarios. Our Acadametrics Prices and Transactions (APAT) data are employed with SST for inexpensive revaluation of the portfolio although AVM valuations can be equally employed.