Risk Management – Exposures, Exceptions, Answers
Investor Central is a web-based asset management, fund management and reporting application
for institutional real estate investors. Investor Central offers a straightforward, cost-effective solution for
tax credit investors to:
- Manage their property and fund investments in a consolidated database, securely via the internet
- Quickly perform and assess risk, sensitivity and exposure across the portfolio
- Manage throughout the investment life cycle – from origination and acquisition through development risk to
operations and residual analysis and disposition.
- Reduce and often eliminate the need to manually input investment data received from general partners, management
companies, syndicators, fund managers and accountants.
Functionality includes:
- Snapshots of key metrics, exposures, exceptions and event reminders
- Customizable fields, screens and values
- Industry proven data model with more than 1600 fields
- Full support at the property level, fund level and investor level
- Integrated workflow manager and document repository (see below)
- Reporting:
- Presented using industry standard Crystal Reports or HTML
- Standard reports with customizable filters for sorting
- Ad-hoc reporting with one-click export to Excel
- Customized reporting
- AHIC, Fannie Mae’s REAP report and other industry benchmarks
- Storage and management of contact information for all relationships
- Customizable risk rating process
- Customizable site visit process
- Capital commitments and payments tracking
- Multiple level debt tracking
- Data entry screens and appropriate filters for searching and sorting
- Audit trails and audit notifications
- Web based application delivered on a Microsoft SQL database
- Role-based security providing user-definable read/write access to screens and reports
- Data/Report submission review and tracking
- Data import functionality – ability to receive electronic file formats from source data providers to store data in a normalized format and provide consistency in reporting
- Data Export functionality – to accounting systems and other software
- Secure report portal for distribution of documents and reports to internal and external shareholders
- Customizable with your logo and colors
Integrated Workflow:
Investor Central includes Integratec’s workflow engine providing secure access to more than 1600 data fields which
Integratec has the ability to capture and manage. All data fields are grouped logically and presented in associated
screens, including Property, Building, Unit, Unit Type, Fund, Investor, Financial, Tax, Occupancy, Partnership Agreement,
Related Parties and Third Parties.
Functionality includes:
- Automate any routine business process by first defining the process, and then calling on the ‘pre-defined’ process and customizing as needed on a deal by deal basis. Current client usage includes:
- Risk Rating
- Origination/Acquisition
- Construction Monitoring
- Audit/Tax Review
- Financial / Key Performance Indicator Review
- Investor reporting
- Tenant Income Certification
- Filter and sort capability by any key field on each data screen.
- View and print pop-up reports which show progress on any task along with related data.
- Provides secure “front-end” data input mechanism for existing systems.
- Field level validation based on user-defined business rules.
- Audit trails show which user changed a field value, when it was changed, and new/old value.
- User-defined collection rules (such as frequency of collection) by data and document type, for each entity.
- Notification emails can be driven by collection rules – user defines both the message content and the email distribution list.
- View every data item and its status (due, received, under review, approved, processed, etc.) and generate ad hoc reports of all items or just those selected through the filtering process.
Role-based security allows clients to define users and assign them to roles such as read/write, read-only and
administrator. Extend access to 3rd parties while limiting their access to view only the properties and documents
assigned to them. All passwords are encrypted in the underlying MS SQL database.
Data security, backup, disaster recovery and hot site capability is assured through our data center relationship
with SunGard. SunGard is a SAS 70 Type II and ISO9003 certified data center, and our environment has been stress
tested by some of the largest financial institutions in the world.
Integrated Document Repository:
All of the source documents which we collect for our clients are stored logically by entity and date. In addition,
clients can use the document repository to attach any type of electronic document to any entity. These entities include
properties, funds, owners, property managers, developers, auditors, individuals, etc. The search criteria include entity
name, document date, type (partnership agreements, audits, tax returns, projections, etc) and others.
History
We know the data and business processes that drive the low income housing tax credit and multi-family real estate
industry. Since 2002, Integratec has been focused on the data – the data model, data sources and reporting needs –
for LIHTC, historic and conventional multi-family markets. Investor Central reflects both our focus on data and the
knowledge gained working with many prominent real estate investors.
TCAM (Tax Credit Asset Management) was our initial offering to the asset management and investor reporting market.
As we grew and market needs dictated, we improved the TCAM data model, improved the end user interface and incorporated
all of our workflow and data management capabilities into Investor Central.
|
