Home

About

Services

Contact

EMAIL


LLAMA Overview

LLAMA is a present value cash flow model. LLAMA calculates the cash flow from loans or groups of loans over the life of the loans. The cash flow is discounted to provide a present value of the cash flows. The resulting dollar value is often referred to as the "value of the portfolio".

The LLAMA model does one thing, it creates a value for a loan or group of loans using a previously created set of assumptions.

Advantages of LLAMA

1. You get full control of the valuation process.
2. No more expensive updates
3. Unlimited loan counts, segments, or portfolios.
4. Direct control using Microsoft's Visual Basic
5. Direct control of all input screens
6. Custom designed output reports.
7. Unlimited flexibility to redesign the cash flow process.
8. You get the source code!
9. Full life of the loan vectoring and assumption tables.
10. User defined investor remittance patterns.

Assumptions

There are two basic forms of assumptions:

1. An array of values for 360 month or more,
2. A single value.

These assumption vectors can be created in any program you desire. You only need put one value per line for 360 months. This gives you complete control over the assumptions for valuation. Delinquencies, fees and costs can all vary for the full 360 mont hs.

Input Data file

The model takes the single input file and merges the data using an assumption table that you create. The assumption table key can be anything you want. This key must be on each record. If the key is FNMA then there must be a unique record in the assump tion table for "FNMA".

The standard data file is a flat ASCII file that contains the information described in VA01D. It can be a summary file or one loan per record. The model calculates the remaining ratios and amortization schedules based on a single loan and then multiple s these values times the number of loans in the segment. As long as the loans in the segments have similar characteristics the value will be correct.

You can easily reprogram the LLAMA model in any computer language. There is a single input, calculation and output. This is the reason why all vectors are kept as simple ASCII files. The model is easily adapted to your database environment.

LLAMA is a valuation engine.

Inputs - The model uses a standard set of inputs that can be supplied in any format database, ASCII or even spreadsheet. It will run in any operating system and with and stratification system.

1. Data table
2. Assumption set - This file directs the model what to do and which vector files to use. These can be maintained and used from month to month.
3. Vector files - These files define a rate or factor for the length of the valuation. They can be created using any word processor or spread sheet

All inputs, assumptions, outputs, tables and other results are made available directly to the user. A complete valuation application can easily be designed from any database or computer application.

No attempt is made to provide an OAS value. This is only a cash flow model. It is possible to adapt the model to quickly run multiple interest rate scenarios.

LLAMA reads fixed length files or tables of information and calculates a present value for the loans or segments in those files. It is calls "engines" because that is the only piece of the system that is sold to the user. All inputs and outputs are com pletely defined in the documentation. Each user can build their own interface to the engine. This assumes that each user already has a database of information. Rather than duplicate the database functions, LLAMA simply provides that calculation engine to value those loans or segments.

The engine is simply a set of calculations that are easily adapted to any processing platform. No specific computer formats or database systems are required.

I. Data Inputs

Client Data - The client data is usually available in a mainframe format.

Data input files - The basic data input file is a fixed length ASCII file which contains all information need to value the loan.

Formats - ASCII, DBF, TEXT, fixed - Although I usually refer to the input file as fixed ASCII, the file can have any format that is PC compatible. If a different DOS is used, such as UNIX, then the engine will provide those formats.

Data conversion module - LLAMA creates the data record using client information.

Segment data - LLAMA will value single loans or groups of loans. The engine is built to process sequential files of records. There can be an unlimited number of loans in the file. Also, additional files of loans can be included in the valuation.
Group results - LLAMA will accumulate groups of cash flows during the valuation. You may have specific loan groupings that you wish to value. The engine accumulates the cash flows based on a data field that you put in the input record.

II. Assumptions

Data assumptions - where to get the values
LLAMA allows the user to specify where to get specific input data variables. The discount rate may be:

specified on every loan record,
specified as a vector
specified on a header record for the current valuation
specified on the investor type header record for each investor.

Valuation Assumptions

Vectors - 360-month spreadsheet type data
Vectors are simply a way to represent the interest rate and servicing cost forecasts. In LLAMA you can vary these rates and factors every month for the life of the loan. The vectors are easily created in any spreadsheet or DOS/Windows editor.

III. Header Records

The users communicate with the engine through defined record types. Every parameter, switch or variable is available to the user. These header records need never change. The input file to the model is composed of one or several files, which contain the se records.

The basic in put file format is:

Initialization records
Assumption records
Data records

The initialization default record is LLAMA.INI. The engine looks in the current directory for this file. If it does not exist then execution stops unless a parameter is passed to the program.

Parameter #1 - File name - The first parameter to the model is a file name that contains enough information to start the model.

IV. Data Edit Programs

The engine has a very basic set of edit routines. Since the number of inputs is so large, the input screens are custom designed.

Suggested Edit Routines

Initialization header records
Vector files
Data records

V. The Engine

Cycle - 30 year or 360 month
Loan level or summary data
Calculation assumptions

VI. The Detail Outputs

1. Flat file - a file can be produced for each loan or segment.
2. ASCII delimited
3. SQL tables

VII. Table Outputs

The matrix used to calculate the value can be placed in a table that is made available to the user. These tables are defined in the header records.

Cash flow tables

1. Cash flow matrix for each segment
2. Summary monthly cash flow matrix for the group evaluated
3. Summary yearly cash flow matrix for the group evaluated
4. Analysis group cash flows for predefined sets with the group
5. Statistical analysis tables for amortization, counts, etc.


Summary cash flow tables

Amortization tables The amortization table and the cash flow table can both be exported in delimited ASCII format to be included into your database language. Using ODBC, LLAMA will work directly with your portfolio analysis system.

VIII. Reports

All reports from LLAMA are custom designed. The user has full access to every table and variable. This allows for the use of any reporting program.
Suggested Reports:

    • Amortization
    • Vectors
    • Prepayments
    • Revenues and unit revenues
    • Costs and Unit costs
    • Assumptions
    • Debt analysis
    • Valuation analysis

IX. Definitions

Cycle - The model has no limits on the inputs. It will continue to process loans until the last one is reached in the file

Audits - LLAMA is an excellent tool to reverse engineering your existing system and challenge the assumptions you are currently using. Since the model will calculate loan level values you can quickly compare LLAMA's results to your current system.< BR>
Reverse engineering - This is a process that helps you to duplicate your existing valuation process to arrive at the exact same value.

Cash flow matrix - The resulting cash flow matrix maintains all the variables and data used to determine the value. You can quickly create your own analysis and presentation reports.

Income statement/balance sheet - The model produces a complete, detailed income statement and balance sheet for each loan, segment or group. You can import this statement to a spreadsheet or database system for easy formatting and printing.

Forecasts - The model will quickly incorporate forecast assumptions into the cash flow and valuation. Portfolio additions and sales can be entered into the analysis

Engine This means that the program performs a single function and it does it very well. The model creates an income statement/cash for a loan or group of loans from a predefined set of assumptions

Interchangeable. The engine is easily ported to any environment.

Open - Once you own the LLAMA engine you can alter it or add features on your own. The

Blind - The model can be : 1. Run as a DOS batch file 2. Run from a windows program 3. called from any database language 4. Built directly into a user-defined interface

Inputs - The model uses a standard set of inputs that can be supplied in any format database, ASCII or even spreadsheet. It will run in any operating system and with and stratification system.

    • 1. Data table
    • 2. Assumption set - This file directs the model what to do and which vector files to use. These can be maintained and used from month to month
    • 3. Vector files - These files define a rate or factor for the length of the calculation. They can be created using any word processor or spread sheet