Risk Analytics^® ALM Model

The Solution for ALM/IRR Measurement and Management

High Levels of Customer Service

A Proven Quality Solution

No Software to Buy

FIMAC Solutions LLC provides a high quality cost-effective solution to your interest rate risk needs that satisfies all the major regulatory and accounting requirements. We utilize an SAAS format, so the model runs on a central web based server with no expensive software to purchase. Run the model as you need, monthly, quarterly, whenever.

From the onset our staff will work with each client and their IT department to automate the data-collection process and train the staff to complete this process. Going forward our professional support staff is available by phone to help with any questions regarding data input or modeling results.

The Process

The process is very simple: enter import data and enter assumptions (no need to reenter assumptions until they change) into our PC resident Windows®-based Data Capture™ software, transmit the data to the server, and receive results in pdf format. There is never a charge or maintenance fee for customer support or product upgrades. Our quality solution provides sophisticated capabilities at a price no one else can match.

Service

Our customer service is only the best in the industry – and we’re proud of it.

We provide easy-to-use Windows-based software to organize and transmit data.

Our software is continually upgraded – at no additional cost – to meet management and regulatory needs.

Web-based training, free telephone, and e-mail customer support 10 hours a day.

Rapid processing with convenient pdf file output provided through our secure web site.

Cost Effective

Subscription service priced specifically for institutions of all asset sizes.

Never a charge for software upgrades.

No charge for customer support.

Buy and use only what you need.

We take the Risk out of
Risk Management.

We use a web-based training facility to cost
effectively train staff and get you started.

Never an annual charge for
customer support or product upgrades.

Client control of the model and assumptions setting.

Easy data upload from data processing system
extracts. Generally less than a 4 hour time commitment
to produce each model run.

Quality and In-depth Analysis

True cash flow simulation and present value calculation something that only the most expensive providers boast.

Automated import of loan, deposit, and security portfolios detail from your data processing system — reduces manual input and increases level in detail and precision.

– Income Simulations and Present Value Equity calculations over a user selected ranges of interest rates.

Detailed modeling of the optionality embedded in each balance sheet, including calls and prepayments.

CUSIP level security detail and analysis, including independent and objective third-party pricing and cash flows – at no additional cost.

User defined model assumptions to accommodate specific product lines and the uniqueness of each client’s balance sheet and location.

Disclosure of the subjective assumptions in each report.

Automatic Backtesting with user defined look back periods.

FAS 107 (Fair Value Accounting) report at year end at no additional charge which details the Present Value calculations for auditors.

Properly model optionality, including call and prepayment features

Detailed information is gathered to accurately model complex financial instruments such as
ARMs, CMOs, and callable advances and securities.

You control key modeling assumptions.

Signing Up
A renewable subscription agreement is prepared for review and signature.

Data Conversion
Once the agreement is signed and returned, our specifically assigned Relationship Manager will contact the IT department to request loan, deposit, and security data files.

As these files are received, we will begin the process of writing a custom data conversion program to import this data into our Data Capture software.

Our Relationship Manager will work with your staff to interpret, translate, and group your various product codes into the most logical account structure for ALM purposes.

Training
Once the data conversion program is complete, we will schedule a web-based training focused on running our software and entering the remaining data.

We will utilize a web based training format to educate and train. We can share control of our software (running on the client’s PC) to demonstrate its use in real time.

The additional data input required includes summary financial statements, a summarized budget for non-interest items, current offered rates, and a few items necessary for capital and liquidity ratios.

Training can take as little as a few hours and our goal is to have a first dataset complete and submitted by the end of training.

The First Report

Once the first data set is submitted to the server the independent securities pricing and cash flows are electronically folded into the modeling process to the data and instructs the model to be run. This first report may take an extra day or so to complete, depending on the size and complexity of the securities portfolio that must be modeled for the first time.

Completed report will be reviewed by each client’s Relationship Manager, then posted to the client’s secure account on our website. At the same time, notification is sent by e-mail that the output report are ready. The assigned Relationship Manager will assist in downloading and printing reports from the server if needed.

Within a few days, we make a follow-up phone call to review the reports report and answer any questions.

Any changes required can be turned around in just a few hours, and we encourage our new customers to rerun their first report until they are completely comfortable with the results.

We dedicate any time necessary to help automate entry of
loan, deposit, and securities information.

• Through our web-based training facility, we can train on the
use of our Data Capture software, which is running on client PC’s
machine, without us being there.

• We’ll make certain clients understand the results and allow rerun
modeling until satisfied that it accurately reflects the interest rate risk profile.

Data Entry

When moving from one reporting period to the next, Data Capture retains historical data and account setups. This helps ensure consistency and minimizes effort.

Simply update summary financial statements for the current period, current offered rates, and a few items necessary for capital and liquidity ratios.

At any time during the data input process, the Validation Module may be run, which verifies data and creates a list of exceptions. Operators then click a Go To button that zips right to the data field in question.

Transmitting Data

Once the dataset is complete (with all Critical errors corrected), users simply click the Transmit button in Data Capture and the data is sent for processing.

Our Relationship Managers are always
available to answer questions

Our data Validation process helps
ensure that data files are
complete and accurate

Model Output

Executive Summary
– Earnings and Economic Exposure to Changes in Interest Rates
– Pro forma Income Analysis
– Current Interest Rate Risk, Limits, and History
– Current Exposure/Risk Limit Analysis
– Next 2 Years Net Interest Income Volatility
– FAS #115 - Accounting for Certain Investments in Debt & Equity Securities
– Balance Sheet Analysis
– Capital Valuation
– Liquidity Analysis Graphs
-Balance Sheet Analysis
– Book/Market Value Analysis
« Assets
« Liabilities
– Fair Value Analysis
« Assets
« Liabilities
– Market Value Volatility Analysis
– Market Value Dollar Change
– Market Value Percent Change
-Income Analysis
– Pro forma Volatility - Next 12 Months
– Pro forma Volatility - Next 12 Months - Dollar Change
– Pro forma Volatility - Next 12 Months - Percent Change
– Pro forma Volatility - Months 13-24
– Pro forma Income - Next 12 Months
– Projected Balances - Next 12 Months
– Weighted Average Rates - Next 12 Months
– Repricable Amounts - Next 12 Months
– Rates on Repricable Amounts - Next 12 Months
– Current Year Pro forma Volatility
– Next Year Pro forma Volatility
– Pro forma Income Summary
– Average/Projected Balances
– Weighted Average Rates
IRR Model Features
Security Analysis
– Security Summary Report
– Amortizing Security Gain/(Loss) Report
– Non-Amortizing Security Gain/(Loss) Report
– Other Investment Report
– Available For Sale Portfolio Analysis
– Callable Bond Repricing
Security Exception Report

Gap Analysis
Standard Gap Analysis
Beta Adjusted Gap Analysis
Two sets of time frames

Capital and Liquidity Analysis
– Risk Based Capital
-Liquidity Analysis

Assumptions
– Client Rate Assumptions for Present Value
– Account Assumptions
– Global Yield Curves
– Global Indexes
– Market Consensus - Prepayments Assumptions
Custom Prepayments Assumptions

Supplemental Reports
Summary Supplemental
Detail Supplemental