Friday, 24 March 2017

Retirement Planning and Forecasting Spreadsheet 2.0 (for Canada)

Retirement Forecaster 2.7

Updated to version 2.7 on March 24th, 2017. 

In this version I have updated the tax tables to include the 2017 federal and provincial tax brackets and rates. There was nothing in the March 22nd budget that affected the calculations.

Download new version here.  

A complete list of upgrades by version is included in the Instructions sheet in the workbook.

This spreadsheet allows you to make an accurate financial plan for your retirement, starting at any time in your life.  Unlike many retirement tools, this spreadsheet shows a cash flow forecast vs time and identifies which account money is saved into (during employment) and which account or source the retirement income is withdrawn from.  It handles the different account types (RRSP, LIRA, TFSA and a taxable investment account), the limits imposed on them and does income tax calculations for any of the provinces.  

The picture below shows the main page of the spreadsheet which contains all the inputs you need (in yellow) and provides a cash flow forecast and how the savings accounts increase and decline.  

I hope you find the tool useful and I am always willing to hear of suggestions to improve it. 

Wednesday, 8 March 2017

X-Y Plots (4Y) Spreadsheet - Another Easy Way To Explore Your Data

This Spreadsheet...
  • This spreadsheet is similar to the X-Y Plots spreadsheet but with a few differences:
    • You can plot up to 4 Y variables on the same chart.
    • Each category is a separate plot. 
    • You can easily switch between plots (different category).

Wednesday, 1 March 2017

Monte Carlo - Run Monte Carlo Simulation without expensive add-ins

(Stanislaw Ulam - inventor of Monte Carlo Simulation)

This Spreadsheet...
  • This spreadsheet allows you to run Monte Carlo simulation without use of expensive add-ins such as Crystal Ball
  • Allows definition of many different input distributions.
  • Input distribution may also be input from actual data.
  • Shows charts of input and output distributions, along with basic statistics.
  • Copies results to Histograms Etc spreadsheet for more detailed results.