Home

About

Services

Contact

EMAIL



Loan count

A single loan is evaluated and the results are multiplied by the total loan count. The beginning raito is 1. The prepayment rate is calculated for each month and applied to the starting ratio. If the foreclosure option is turned on, the foreclosed ratio is subtracted from the beginning ratio. Each month can have a unique prepayment rate. The base rate can be scaled up or down over the life of the loan. The total number of loans that prepay is calculated.

1. A prepayment vector is used base on a CPR or PSA table.

2. The rate can be multiplied by a scendo vector over the life of the loan.

3. The PSA is simply the PSA rate times 6% adjusted for early lower
prepayment rates. If the PSA is used you can either:

1. Use the initial lower PSA values
2. Simply convert to a CPR value

4. The remaining vector is one minus the prepayments.

5. You can decide to deduct the foreclosures in addition to the normal prepayments. This lowers the average loan count in any period but does not include the loan life.

6. Ballon loans are treated as curtailments and no earnings occur on the removed balances.

7. Sales can occur but these are treated as removed balances. All analysis simply stops and the loan balance goes to zero.

Escrows
All escrow analysis is based no the current escrow constant. The constant can be divied into an insurance portion and a tax portion. This allows a separate calculation to be performed to determine what the average balance for the escrows might be.

The escrows are inflated according to a separate inflation schedule

LLEDEP=( (LVETAX+LVEINS) * LLCNTA * LFNTX)

The average escrow balance is caluclated as follows:

LVEAVG=( LFNTX * (LVETAX*(.lvemot+LFETAXX)+ LVEINS*(.lvemoi+LFEINSX))

The total segment average escrow is:

LAEAVG=( LVEAVG * LLCNTA )

The actual escrow balance is not used in the present value calculation

Servicing revenues

1. Service fee Revenues

The final service fee is:

Service fee less guarantee fee plus dollars per loan in servicing
The fee may be:
1. Negative
2. Zero
3. Very high
4. split into Regular, excess, or IRS special

There may be more than one column to state the service fees.

LLFEE - The servicing fee expressed as an annual percent of the loan balance. It is assumed that this fee is net of all guarantee fees and uncolecttable fees. It is the net fee retained on this loan.
LLFEE =(LLBALA * LVSFEE * LFVSF )

LLFEE1 =(LLBALA * LVSFEE * LFDCHG )
LLFEED =(LLCNTA * LVSDPL * LFNSD )

2. Ancillary income
LLANC is a dollar amount per loan per year. It is inflated according to the LFNSA inflation rate
LLANC =(LLCNTA * LVANCI * LFNSA )

LLANC1 is only a percent of the balance it does not inflate.
LLANC1 =(LLBALA * LVANC1 )

LLANC2 is a second $/loan field
LLANC2 =(LLCNTA * LVANC2 * LFANC2 )

3. Late fees

4. Interest on P&I

LABIPI=( LLPICO - LLFEE - LLFEED - (LVPICO * LCFOR))
LABIPI=( LABIPI * ( AVRPCT + AVRPCT1 ))
LLEPI =(IFGT(LLBALE,0,(LABIPI * LFRIE * LFPIU),0))
5. Interest earned on payoffs

Interest and P/O interest is not calculated in the last month of the portfolio life!!
LABIPO=( LLBALP * (1-LVSFEE) * .avppct )
LLEPO =(IFGT(LLBALE,0,(LABIPO * LFRIE * LFPIU),0))

6. Interest earned on escrow account balances

LLETI =( LAEAVG * LFRIE * LFTIU )

Servicing Cost

1. Normal servicing cost The normal servicing cost includes all servicing funtiosn for this loan type. Every loan can have a unique servicing cost. These costs may include investor cost, ARM loan servicng cost, and all other cost specific to tis loan type'
LLCST =(LLCNTA * ( LFCSER + LFCARM + LFCINV ) * LFNCS )


2. Prepayment cost

LLCPAY=(LLCNTP * LFCPRE * LFNCS )

3. Late notice cost
LLCLAT=(LFD10 * LFCLAT * LFNCS )

4. Delinquent servicing cost
LLCDEL=(LLCNTA * LRDEL * LFCDEL * LFNCS )

Foreclosure Cost

LLFCC =(LLCNTA * LFCFOR * LRFOR * LFNCS )

LLFLSH=(LLCNTF * LFLFOR * LFNCS )
LLFLPI=(LLCNTF * LFFCM * LLINTT * (1-FC_RPI))
LLFLTI=(LLCNTF * LFFCM * LLEDEP * (1-FC_RTI))
LLFLSV=(LLBALF * LFFCM * LVSFEE * (1-FC_RFEE))
LLFLSI=(LLCNTF * FC_IPLO * LLINTT)
LLFLSP=(LLBALF * FC_PBLO)

Cost of advances

1. Cost iof interest advance
LAADIB =( LCDELT * LFDELC * LVINTP )
LLADVI =( LAADIB * LFRIA )
2. Cost of principal advance
LAADPB =( LCDELT * LFDELC + LVPRIP )
LLADVP =( LAADPB * LFRPA )

Interest expenses

1. Interest on Escrows
LLIOE =( LAEAVG * LVEIOE )

2. Interest payments lost on pauyoff

LLINL =( LLCNTP * LVINTP * .avppct1 * .paylst )