24 Time Value of Money Calculations in One Excel Workbook

I thought I would consolidate some of the past posts and spreadsheets into one workbook. It could come in handy when you need some quick answers, or just to check your calculations. I tried to give not only the Excel functions, but the math and alternative calculations. In addition, I included the option to calculate the […]

3 -Ways to Bootstrap Spot Rates for the Treasury Yield Curve

Note: I have added a fourth method of calculating spot rates for the Treasury yield curve. The workbook is the same. For a brief explanation of the forth method: http://pistulka.com/Other/?p=2812   I have used what I am calling the “spreadsheet method” of bootstrapping spot rate from the U.S. Treasury yield curve in two pervious posts. […]