|
All material on this site is Copyright 2006-2010 Random Walk Ventures, LLC. All Rights Reserved. |
|
Additional Tools |
|
flexibleRetirementPlanner.com |
|
Portfolio Asset Allocation Tool
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. |
|
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. |
|
CD Early Withdrawal Penalty Spreadsheet
This spreadsheet allows you to compare 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 return (after penalties) than a 2-3 year CD that’s held to maturity. |
|
A retirement planner that’s a little more flexible |
|
Flexible Retirement Planner |
|
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. |
|
TIPS Ladder Builder Spreadsheet
This spreadsheet constructs a TIPS ladder that will generate a steady inflation adjusted income stream for a set number of years The amount of TIP securities needed for each rung in the ladder is computed by balancing the value of TIPS maturing each year with interest from TIPS maturing in the future. |