Monte Carlo Planner - Additional Tools

A retirement planner that’s a little more flexible

flexibleRetirementPlanner.com

This spreadsheet helps you track and manage your portfolio’s asset allocation. Unlike personal financial management software like Quicken and MS Money, this spreadsheet allows you to define your own asset classes and subclasses.

Additional Tools

This page has links to a few additional tools that have been developed by the webmaster over the years. These tools are all Microsoft Excel spreadsheets and can be downloaded and freely used for personal and business purposes.

Bond Portfolio Spreadsheet

This spreadsheet helps you 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 Spreadsheet

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 Spreadsheet

This spreadsheet does some excel gymnastics on a pasted-in Quicken report in order to produce a summary data table.

The spreadsheet is probably most interesting as an example of how to use the Index() Match(), Address() and Indirect() functions.