This spreadsheet constructs a TIPS ladder to generate a steady inflation adjusted income for a preset number of years. Income each year comes from a combination of maturing TIPS and interest on TIPS maturing in future years.
This spreadsheet compares the effective annual return on CDs that are withdrawn before maturity. In some cases a 5 year CD that’s withdrawn early can offer a higher after penalty return than a 2-3 year CD that’s held to maturity.
This spreadsheet helps track a portfolio of Individual Bonds. The spreadsheet includes fairly extensive reporting of the portfolio’s allocation by maturity, credit rating, and bond type. It also computes the portfolio’s duration and convexity.
This spreadsheet was a precursor to the online retirement planning tool and contains a basic simulation framework with some visual basic code that may be helpful if you’re interested in developing spreadsheet based simulations in visual basic.
This spreadsheet does excel gymnastics on a pasted-in Quicken report to produce a summary data table. It’s mostly intended as an example of how to use the Index() Match(), Address() and Indirect() functions.