There are a lot of Investment and Pension Calculators available online today. They get you to plug in a number of pieces of data, make some assumptions and then tell you an answer. This might be your total projected pension fund, your projected income or even the probability or reaching a financial goal. I find these a useful tool and use them regularly except I find they have one failing. They only ever give you a single answer based on the data you enter and don’t show you a helicopter view of how the various factors that Mr Market throws at you combined with the decisions made by the Average Investor interact. I therefore decided to build a simple Retirement Investing Today model in Microsoft Excel and have found it informative. I hope you do to and as always would welcome your feedback.
Before we look at the model let’s first look at why I decided to run this analysis in the first place. In the circles that I move (both in the flesh and online) there seem to be broadly four types of Retirement at play. Some people have planned for one type and achieved their goal but in many other instances people have planned for one and failed miserably. How many times have your read or heard people say that I was on target to Retire by 50 (or some other random number) but then the market crashed and so now I’ll have to work a lot longer than planned. Why do people get it so wrong? I want to know so that I can avoid the same mistakes.
Before we look at the model let’s first look at why I decided to run this analysis in the first place. In the circles that I move (both in the flesh and online) there seem to be broadly four types of Retirement at play. Some people have planned for one type and achieved their goal but in many other instances people have planned for one and failed miserably. How many times have your read or heard people say that I was on target to Retire by 50 (or some other random number) but then the market crashed and so now I’ll have to work a lot longer than planned. Why do people get it so wrong? I want to know so that I can avoid the same mistakes.