Latest Posts
  • CMO -IO/PO PAIR

    This is my fourth free CMO Excel spreadsheet. This post is going to be very short. You can find a lot of information online, so...
  • CMO – PAC

    I have posted two other examples (and Excel workbooks) of CMO structures in the past.  Floater & Inverse-Floater CMO and Sequential Pay CMO. Now, we are...
  • Future Value Bank Interest in Leap Years

    Not all banks treat leap years the same, when calculating interest on deposits. Many financial institutions use basically the same method (or a close variation)...
  • A Fourth Way To Bootstrap Spot Rates

    In May of 2015 I published a post called “3 -Ways to Bootstrap Spot Rates for the Treasury Yield Curve”. There was also an Excel workbook...
  • Flat Rate Loans

    I have to be honest. I had never heard of a flat rate loan, until Rishi asked me to create an Excel spreadsheet for one....
  • Required Minimum Distribution (RMD) 3.0

    This is my third post on RMD, thus the 3 point 0. The other two post are: http://pistulka.com/Other/?p=2422 http://pistulka.com/Other/?p=2674 Read my first post if you...
  • Defeasance 3.0

    If you are involved in commercial lending or perhaps municipal bonds you are probably familiar with the term defeasance. Commercial loans normally have hefty prepayment...
  • MBS Amortization With VBA

    If you search my blog, you will find dozens of amortization schedules produced by formulas. So why would you need an amortization produced with VBA?...
  • Counting Binomial Lattice Paths

    This is not an academic or financial post, but a fun look at the large number of possible paths available in the binomial lattice used...