Home » Archive by category "Uncategorized"

Assumptions Behind The Default (CDR) Model.

A reader has questioned the model I use for calculating defaults (CDR) and loss severity. It was pointed out that my model uses the expected P&I, even though a stated percent of principal is in default each month. The reader also pointed out that my...
Continue reading »

Simple Interest Commercial Loan Amortization

In previous commercial loan amortizations I have used the standard 30/360 basis, compound interest amortization. More often than not, lenders will use simple interest for commercial loans. Don’t let the word simple in “simple interest” vs “compound interest” fool you.  Lenders are not looking to...
Continue reading »

Maturity Weighted Butterfly Swap

This is the fourth in a series of differently weighted butterfly swaps. I will adjust the list below, as I add more butterfly swaps: Cash & Duration Neutral Butterfly (aka Duration-Hedged Barbell) Fifty-Fifty Butterfly Swap Regression Weighted Butterfly Swap Maturity Weighted Butterfly Swap Note: Although...
Continue reading »

Regression Weighted Butterfly Swap

This the 3rd in a series of butterfly swaps. Cash & Duration Neutral Butterfly (aka Duration-Hedged Barbell) Fifty-Fifty Butterfly Swap Regression Weighted Butterfly Swap Maturity Weighted Butterfly Swap Note: Although this type of swap shows positive convexity at changes of + or – 25 basis...
Continue reading »

Fifty-Fifty Butterfly Swap

This is the second in a series of differently weighted butterfly swaps. I will adjust the list below, as I add more butterfly swaps: Cash & Duration Neutral Butterfly (aka Duration-Hedged Barbell) Fifty-Fifty Butterfly Swap Regression Weighted Butterfly Swap Maturity Weighted Butterfly Swap Note: Although...
Continue reading »

Commercial Loan Amortizations

I was playing with some assumptions for commercial loan amortizations and came up with the this Excel spreadsheet. For example: Assume the borrower wants to make payments quarterly, semi-annually, annually, or bi-monthly, instead of monthly, in order to match the borrowers source of income. You...
Continue reading »

Annual CPR Vectors

Just what everyone has been waiting for, another CPR vector analysis. I have at least two other CPR vector posts. This one allows for your own CPR model, with CPRs potentially changing each year. I say potentially, because one could keep the same CPR for...
Continue reading »

Cherry-Picking a Loan Portfolio, Revisited

Readers might remember my original post and spreadsheet http://pistulka.com/Other/?p=1473 in August 2015 called Cherry-Picking a Loan Portfolio.  That spreadsheet relied upon going through a loan portfolio and placing an X next to the loans you were interested in purchasing. It was one way I used to...
Continue reading »

CPR Prepayment Vectors

Note: I have updated this post and spreadsheet with another way to create your own CPR vectors: Annual CPR Vectors Previously, I showed a way to vary the CPR prepayment rates http://pistulka.com/Other/?p=1300 on an amortization schedule. That method did not include ramps. This spreadsheet shows...
Continue reading »

HEL (Home Equity Prepayment)

HEL (Home Equity Prepayment) is similar to the PSA prepayment model in that it starts a 2% CPR in the first month and increasing at 2% CPR until month 10. It then remains at 20% CPR for the remaining life of the pool. Increases or...
Continue reading »