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...
Excel@CFO
Excel Solutions and Free Spreadsheets for the Financial Analyst & CFO
Latest Posts
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...
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...
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...
Cash & Duration Neutral Butterfly (aka Duration-Hedged Barbell)
First in a series of butterfly Swaps. I will adjust the list below, as I add more butterfly swaps: 1. Cash & Duration Neutral Butterfly (aka...
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...
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...
Simple (SMA) and Exponential (EMA) Moving Average
Technical trading is a little out of my wheelhouse, but when I came across the exponential moving average (EMA), I thought it was interesting enough...
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...
THE MIRR EXCEL FORMULA WITH DATES (XMIRR)
Most of my 50 year career was in fixed income investments (Bonds, MBS, etc.). We did not use MIRR, but we did have concepts that...
Interest Penalty for Overtime Changes in State Law
Disclaimer: I am not an lawyer, and offer this spreadsheet free with no guarantees either written or implied, as to the appropriate use of this...
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...
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...
MHP (Prepayment Rate for Manufactured-Housing)
I have to admit that I have never purchased or sold manufactured housing loan pools, but am aware that those that do own or trade...
Change to “Calculate Historic CPR and PSA”
In the previous spreadsheet used to calculate historic CPR and PSA, I used a separate sheet in the workbook to run an iteration on an...