BondCalc: Securitization Input Parameters
BondCalc can securitize home equity loans, commercial mortgages, and all other types of asset securitizations. You can have a Sr/Sub/Reserve structure or an Sr/Reserve structure, and the Sr and/or Sub can have an unlimited number of tranches.
To start you have to build a database of single securities. It can be a single security. Then in the portfolio make a listing of the securities. For commercial mortgages see special import type where the user specifies the locations in data record.
In the portfolio use Alt-S for the Securitization Input Screen and input the following:
- Securitization Rate - The rate at which the Senior securities are
sold, and also the Subordinated if the next field is blank.
If the Senior securities have multiple tranches then enter
multiple rates here with + signs in between. May use single
with multiple amounts. To enter floating rates or rates
changing over time you have to: Enter a floating case in the
database found on F8. The case must have a single letter name.
Then enter a letter here from A to Z instead of a rate. Letters
can be used more than once.
- Securitization Rate - Subordinated. Optionally you can enter a
rate here if the sub piece has a different rate.
- CPR Scenario Rate - Do NOT enter here and inside security, or both
will be used. However, input must be here for sensitivity
report to be prepared. Optionally a vector of prepayment rates
can be entered on the F7 popup. Do NOT enter when at security
level. Input will come from security screen.
- R/F Discount Rate - This is in the Display Compounding Frequency
as set on Shft-F5. If wanted in monthly then use Alt-F4 to
convert from monthly to semiannual equivalent.
- Amount in Senior Structure - This is the initial percent or amount
that is allocated to the senior. Numbers 100 or less will be
percents, greater will be monetary. If multiple senior tranches
then enter multiple numbers with + signs in between. Must have
the same number of numbers as Sr. Securitization Rate field.
Can use scientific notation to enter large numbers. Use a
capital E for the exponent. E.g. 1.2E6 is 1200000.
- Amount in Sub Structure - If a 0 is entered then there will be no
Sub piece. Can be either monetary or percent. A lesser number
can be used when jumping into the middle of the deal. If blank
then it defaults to 100% less the Senior piece
- Unscheduled Principal to Senior - If left blank defaults to 100%
to senior.
- Overcollateralization Amount - Usually in a range of 0-20%. Can
also enter three numbers separated by + signs. The first is the
the point when extra cash is no longer turboed to the A holder.
The second is the number of periods to a step down. The third
is the percent of the step down.
- Fee Feature Code - This is the sum of the codes necessary to
describe the fee arrrangement:
1 - end trustee fee when senior piece ends
2 - add a servicing fee present value column on the right
- Servicing Fee - In percent.
- Trustee Fee - In percent. Collected over the life of the issue,
unless feature above is used.
- Trustee Fee/Annual Minimum - The minimum monetary amount per year
of the previous field.
- Upfront Deal Expenses - In monetary amount. They appear on the
summary report and reduce net proceeds. Also see Discounts
below.
- Reserve Fund - This is what is set aside in reserve. It can be
entered either in a monetary amount, or a percent of original
book value. Numbers less than 100 will be percents, greater
will be monetary.
- Cash Reinvestment Rate - The percent earned annually by the
reserve fund.
- Clean Up Call - Optional. If entered then the issue will be
called when the balance outstanding reaches this percent of
original issue.
- Default/Loss Info - Optional. Enter one or three numbers
separated by + signs. The first is the percent that default
each period. The second is the number of periods to recovery.
The third is the percent recovered.
- Annual Default Prepayment Rate - [Future use. Difference from
above?]
- Periodicity for Grouping Flows - This is usually optional. If
left out the flows will be grouped based on the periodicity
of the first issue found.
- No Clean-up Call Step-up - Enter this when there is a clean-up
call and the servicer does not call, and the Class holders
receive this increase to their rate. This number is added to
the rate. Also needs Clean-up call percent entered.
- Spread Amount Requirement - Until this is reached, excess
servicing will be used to pay down Class A Certificates. Enter
as percent of original principal balance.
- Surety Fee - In percent. Calculated against senior balance.
- Price(s), Senior - Defaults to 100. In percent. May have
multiple prices by separating with '+'s.
- Price, Subordinated - Defaults to 100.
- Discount(s), Senior - Defaults to 0. In percent. May have
multiple discounts by separating with '+'s.
- Discount, Subordinated - Defaults to 0.
- Overcollateralization Type -
1-Current Balance (default)
2-Original Balance, then Current Balance after step
3-Original Balance for entire length
- Original Balance - Used for the overcollateralization test
when so coded in the prior input field.