Home » 2018 » August

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 »