• Floater & Inverse-Floater CMO

    This is a follow-up to my last post, Sequential Pay CMO. The purpose of this example spreadsheet is to show a simple example of how...
  • Sequential Pay CMO

    A reader ask me if I had published a sequential pay CMO example. I had not. I did start a spreadsheet at one time, but never completed it. I...
  • Calculating Historical CPR

    There is a newer post that replaces the amortization schedule to calculate historic PSA with a UDF: http://pistulka.com/Other/?p=2964   Back in December of 2014 I...
  • Chained Returns

    Calculating the total rate of return on a chain of returns produces a time weighted rate of return. I covered this in my post “Time...
  • Rule of 78

    If you normally sell your car before it is paid off, you are going to want to stay away from lenders that still use the Rule...
  • U.S. Treasury Forward Rate Curves

    Note: I have made some changes to the spreadsheet since the original post. The Treasury data source was not pulling in the new rates as...
  • Treasury Bill Calculator

    It occurred to me that my last post Treasury Bill Math with twelve formulas, has little value if you are sitting on a trading desk and...
  • U.S. Treasury Bill Math

    Money market securities mature in less than a year and pay simple interest (as opposed to compound interest). Treasury bills are money market instruments that pay...
  • Financial Ratios – Bullet Charts

    In May of this year I offered a template of gages that a board of directors might find useful to spot problems in their credit union...