Comparing CDR Default Formulas to Industry Standard Default Formulas

My last post was a comparison of my default CDR formulas (I will refer to this model as “my model” only because I have no idea who to credit) and that of an alternative model used as the industry standard. I put together a spreadsheet that, although not an official SIFMA product, gives an indication of how the industry standardized formulas are applied. If you need an official  SIFMA product, follow the link provided. First my disclaimer:

The workbook contains two sheets. One is a sample of my model and the other the BMA model. I have set the BMA model to P & I advanced. In other words, there is a guarantee of principal and interest to the buyer.

Both models use the same inputs as below. The calculations below are for the first month’s payment only.

As I pointed out in my last post, my model uses a sequence of principle paydowns starting with the expected amortization, then prepayments, then defaults and loss severity. Each amortization paydown is dependent upon the calculation of the amortization that precedes it.

The BMA model is also sequential. In this model, defaults are calculated first. Actual amortization needs defaults before it can be calculated. Prepayments need the expected amortization derived from the amortization factors. The calculations from the amortization factors mimic my calculations of needing the actual amortization first. Note that prepayments for the first month are the same for both models (in blue).

Both are sequential calculations but in a different order:


The purist that argues that defaults should come before expected amortization and prepayments, should also insist that prepayments come before expected amortization, which the BMA model does not. Prepayments in the BMA model are calculated after expected amortization, as does my model. In fact, if you set default to zero in both models, they amortize exactly the same.

Default models are primarily used to predict credit risk. They are only as good as the users inputs. Although my model does not conform to the industry standard model, I continue to feel my model can be a useful tool for users that are not required to use an industry standard.

The lack of time until the defaulted property is sold (as in the BMA model) can be offset in my model by increasing or decreasing  loss severity.




Don Pistulka
Don Pistulka

Retired Credit Union CFO - Finance
Background: over 40 years in investments, asset/Liability management, banking, securities trader.
Worked for: California Credit Union, WesCorp, CalFed S&L, Crocker Bank, Carroll McEntee, Federal Home Loan Bank Board (D.C.), Western Asset Management, Security Pacific National Bank.


Leave a Reply to Valuing a Mortgage Portfolio With Cash Flow Analysis – Excel@CFO Cancel reply

Your email address will not be published. Required fields are marked *