The reason this is version 4.0 is that prior to this post and spreadsheet, I had three other posts on defeasance. With the addition of using Treasury spot rates, rather than posted yields on current coupons or Treasury strips, I hope to increase the accuracy of the calculations. If you are involved in commercial lending […]