Some additional investing and retirement planning tools

These Excel spreadsheets are free for personal and commercial use

Please be aware that they are not being maintained or updated, so use at your own risk.


Portfolio Asset Allocation Tool

This spreadsheet helps track and manage your portfolio’s asset allocation. You can redefine asset classes and subclasses and specify custom rebalancing bands.

TIPS Ladder Builder

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.

CD Withdrawal Penalty

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.

Bond Portfolio Spreadsheet

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.

Portfolio Withdrawal Simulation

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.

Quicken Report Extraction Tool

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.