Vector Files
The vector files are used to supply the engine with all variables
that require a monthly rate or ratio. By using this format you can
set the exact number you want for every month of the loan life.
There are no fancy calculations or special routines.
The vectors are simple, flat ASCII files that can be created
by any spreadsheet or word processor.
Each of these vectors is a column numbers that
is 360 rows (months) for monthly cycles, 30 rows (years) for annual cycles
and 30 rows (days) for monthly cycles.
Vectors perform the following functions
| 1. Replace | Discount rates |
| 2. Multiply by | Inflation |
| 3. Add to | Delin |
| 4. Percent of total | Amortization |
These are simple ASCII files that can be create from a spreadsheet or
any ASCII editor.
[I] Inflation
[V] Simple vector
[R] Interest rate vector [annual rate /12 ]
[P] Prepayment
[D] Discount rate vector
[T] Accumulative Add it up
[A] Cash flow vector
[M] Simple vector
Sample Vector file
This is a file processed by the Model to create vector files.
Is is optional only! You can create your own files.
Inflation Vector Example
There are two sets of data in each vector file:
1. Monthly vaLues
2. Annual values
The columns are as follows
Month and row counters
#1 Location 1 to 5
This field can contain a date in the format
YYYMM which specifes an exact date for each value.
If zeros are present the vector starts at period 1
#2 Location 9 to 12
This is the number of the value with in the file
Monthly Values - Used when the model is in the 360 month mode.
#3 Location 14 to 24
This is the annualized value to use.
#4 Location 26 to 36
This is the monthly value to use. It is the actual
value used by the model.
Annual Values - Only used if the model is in a 30 year mode.
#5 Location 38 48 {Same as #3}
This column is for the annual rate
#6 Location 50 to 60
This is the calculated annual value used by the model.
1-5 9-12 14-24 26-36 38-48 50-60
1 2 3 4 5 6
-Date---Numb-AnnRate====-MonValue===-AnnuRate===-AnnValue===
00000 1 0.0400000 1.0033333 0.0000000 0.0000000
00000 2 0.0400000 1.0066777 0.0000000 0.0000000
00000 3 0.0400000 1.0100333 0.0000000 0.0000000
00000 4 0.0400000 1.0134001 0.0000000 0.0000000
00000 5 0.0400000 1.0167781 0.0000000 0.0000000
00000 6 0.0400000 1.0201674 0.0000000 0.0000000
00000 7 0.0400000 1.0235679 0.0000000 0.0000000
00000 8 0.0400000 1.0269798 0.0000000 0.0000000
...
00000 355 0.0400000 3.2588210 0.0000000 0.0000000
00000 356 0.0400000 3.2696837 0.0000000 0.0000000
00000 357 0.0400000 3.2805827 0.0000000 0.0000000
00000 358 0.0400000 3.2915179 0.0000000 0.0000000
00000 359 0.0400000 3.3024897 0.0000000 0.0000000
00000 360 0.0400000 3.3134980 0.0000000 0.0000000
Vector Definition File
This is the vector definition file - All the vectors are defined
by this file. The model will create the vectors if it finds
this record in the input file.
Column #1 The record ID for this layout is VECT2
Column #2 The name of the vector. This is also the first
part of the DOS file name xxxxxxxx.yyy
Column #3 Simple description of the vector
Column #4 The vector type (see above)
Column #5 The starting date of the vector YYMM.
Field #6 The first month
Field #7 The first value for this month
These numbers form the vectors exactly as in KAL_II.
--------------------------------------------------------------------------
#1 #2 #3 #4 #5 #6 #7
VECT2 CASHR Reg cash payment A,0000,01,.03,03,.03,05,.25,10,
VECT2 CASH17 Reg cash payment A,0000,01,.03,03,.03,05,.25,10,
VECT2 CASHP P/O cash payment A,0000,00,.00,15,.50,30,1.0
VECT2 ------ ----------------------------------------------------
VECT2 VEC00 Zero vector V,00000,480,0
VECT2 VEC01 One vector V,00000,360,1
VECT2 VEC02 Two vector V,00000,360,2
VECT2 VEC06 Six vector V,00000,360,6
VECT2 PCT097 97% vector V,00000,360,.97
VECT2 PCT089 89% vector V,00000,360,.89
VECT2 PCT075 75% vector V,00000,360,.75
VECT2 ------ ------------------------------------------
VECT2 MON360 Term 360 months M,00000,360,1
VECT2 MON480 Term 480 months M,00000,480,1
VECT2 ------ ------------------------------------------
VECT2 INT001 Interest rate X 1 R,00000,480,1
VECT2 INT010 Interest rate 1% R,00000,480,.01
VECT2 INT040 Interest rate 4% R,00000,480,.04
VECT2 INT050 Interest rate 5% R,00000,18,.05,480,.05
VECT2 INT060 Interest rate 6% R,00000,18,.06,480,.06
VECT2 INT080 Interest rate 8% R,00000,18,.08,480,.08
VECT2 INTCAP Interest rate R,00000,12,.0357,24,.0375,360,.0400
VECT2 INTCAP2 Escrow Earn rate R,00000,12,.0500,24,.0550,360,.0600
VECT2 ------ ------------------------------------------
VECT2 INT_01 EscrEarn 5.5 6.0 R,00000,12,.0550,24,.0500,360,.0600
VECT2 INT_02 EscrEarn 6.37 7.5 R,00000,12,.0637,24,.0675,360,.0750
VECT2 INT_03 EscrEarn 5.5 6.0 R,00000,12,.0550,24,.0500,360,.0600
VECT2 INT_04 EscrEarn 6.0 6.0 R,00000,12,.0600,24,.0600,360,.0600
VECT2 INT_05 EscrEarn 6,21 7.5 R,00000,12,.0621,24,.0675,360,.0750
VECT2 INT_06 EscrEarn 6.31 7.0 R,00000,12,.0631,24,.0700,360,.0700
VECT2 ------ ------------------------------------------
VECT2 INF001 Inflation rate X 1 V,00000,480,1
VECT2 INFCAP Inflat 3%,4%,5% I,00000,12,.03,36,.04,360,.05
VECT2 INF020 Inflat 2.0% 360 mon I,00000,480,0.020
VECT2 INF025 Inflat 2.5% 360 mon I,00000,480,0.025
VECT2 INF030 Inflat 3.0% 360 mon I,00000,480,0.030
VECT2 INF035 Inflat 3.5% 360 mon I,00000,480,0.035
VECT2 INF04A Inflat rate 4%-5% I,00000,16,.04,488,.05
VECT2 INF040 Inflat 4% 360 mon I,00000,480,0.04
VECT2 INF050 Inflat 5% 360 mon I,00000,480,0.05
VECT2 INF080 Inflat 8% 360 mon I,00000,480,0.08
VECT2 ------ ------------------------------------------
VECT2 TAX390 Tax rate 39% V,00000,480,.39
VECT2 TAX350 Tax rate 35% V,00000,480,.35
VECT2 TAX400 Tax rate 40% V,00000,480,.40
VECT2 ------ ------------------------------------------
VECT2 DSC050 Discount rate 5% D,00000,18,.05,480,.05
VECT2 DSC080 Discount rate 8% D,00000,480,.08
VECT2 DSC090 Discount rate 9% D,00000,480,.09
VECT2 DSC100 Discount rate 10% D,00000,480,.10
VECT2 DSC110 Discount rate 11% D,00000,480,.11
VECT2 DSC120 Discount rate 12% D,00000,480,.12
VECT2 DSC130 Discount rate 13% D,00000,480,.13
VECT2 DSC140 Discount rate 14% D,00000,480,.14
VECT2 DSC150 Discount rate 15% D,00000,480,.15
VECT2 DSC180 Discount rate 18% D,00000,480,.18
VECT2 DSC200 Discount rate 20% D,00000,480,.20
VECT2 ------ ------------------------------------------
VECT2 AMO08 Amortization pct T,00000,096,1
VECT2 AMO09 Amortization pct T,00000,108,1
VECT2 DEB070 Debt repayment T,00000,072,1
VECT2 DEB090 Debt repayment T,00000,108,1
VECT2 DBR080 Debt ratio V,00000,480,.8
VECT2 DBR070 Debt ratio V,00000,480,.7
VECT2 ------ ------------------------------------------
VECT2 USE980 Useable Funds V,00000,480,.98
VECT2 ------ ------------------------------------------
VECT2 ANC015 Ancillary Income R,00000,18,1.0,480,0.50
VECT2 ANC0500 Ancillary Income R,00000,360,5.00
VECT2 ANC0400 Ancillary Income R,00000,360,4.00
VECT2 ANCCAP AncInc 9.5 to 16 R,00000,12,9.50,72,15,360,16
VECT2 ANCCAP1 Ancillary Income R,00000,12,.7923,36,.7923,60,1.251
VECT2 ANCCAP2 AncInc 14.5 to 21 R,00000,12,14.50,72,20,360,21
VECT2 ANCCAP3 AncInc 15 to 17 R,00000,12,15,36,16,360,17
VECT2 ANCCAP4 AncInc 9.10 to 14.0 R,00000,12,9.10,24,14.20,36,14.66,
VECT2 ------ ------------------------------------------
VECT2 ANC_01 AncInc 9.10 to 14.0 R,00000,12,9.10,24,14.20,36,14.66
VECT2 ANC_02 AncInc 8.00 to 16.0 R,00000,12,8.00,24,16.00,36,14.00,3
VECT2 ------ ------------------------------------------
VECT2 LFC100 Collect Ratio 100% V,00000,480,1.00
VECT2 LFC070 Collect Ratio 70% V,00000,480,0.70
VECT2 ------ ------------------------------------------
VECT2 CST001 Servicing cost V,00000,18,1,120,.9,480,.8
VECT2 CST035 Servicing cost R,00000,360,35
VECT2 CSTC47 Servicing cost R,00000,6,47.0,12,31,24,26,36,20,60
VECT2 CST052 Servicing cost R,00000,360,52
VECT2 ------ ------------------------------------------
VECT2 CNV001 Conversion cost T,00000,012,1
VECT2 CNV002 Conversion cost V,00000,11,.0834,12,.0826,480,0
VECT2 ------ ------------------------------------------
VECT2 CSTM020 Delin cost V,00000,18,20.00,480,20.00
VECT2 DEL0100 Delin ratio chg V,00000,480,.0100
VECT2 DEL0930 Delin ratio 93% V,00000,480,.9300
VECT2 DEL0500 Delin ratio 50% V,00000,480,.5000
VECT2 DELCAP1 Delin Cap 2.45% V,00000,03,0.0,360,.0245
VECT2 DEL0250 Delin Cap 2.45% V,00000,03,0.0,360,.0245
VECT2 DELCAP2 Delin Cap custon V,00000,012,0.5,014,.7500,16,.9,3
VECT2 DELS001 Delin spread V,00000,1,.50,2,.25,3,.125,4,.075,
VECT2 CNT0250 Average month delin V,00000,480,2.5
VECT2 ------ ------------------------------------------
VECT2 FORS001 Foreclosure spread V,00000,6,0,07,.500,08,.100,09,.10
VECT2 FOR2500 F/C ratio 1 to .3 V,00000,12,.010,120,.005,480,.0030
VECT2 FOR0010 Foreclose ratio V,00000,12,.003,024,.002,480,.0010
VECT2 FOR0025 Foreclose ratio V,00000,480,.0025
VECT2 ------ ------------------------------------------
VECT2 FCM012 F/C months to compl V,00000,480,12
VECT2 FCP080 Foreclose prob V,00000,480,.80
VECT2 ------ ------------------------------------------
VECT2 DAY010 Days P/O held V,00000,480,10
VECT2 DAY030 Days P&I held V,00000,480,30
