# Stress Test Your Retirement Plan

While planning for retirement, we encounter several rates:

• rate of return before  and after retirement
• rate of inflation before and after retirement

While calculating the corpus required and the monthly investment required, we assume these rates are constant for each year before retirement and during retirement.

In reality, all these rates can vary quite a bit. This means, the actual corpus required and therefore, the monthly investment required can also vary.

A Monte Carlo retirement calculator is one in which the above mentioned rates are varied randomly (but in accordance with a statistical distribution) several times, and the probability of financial independence of a given number of years is calculated.

In the previous version of the Monte Carlo calculator, I had presented answers in terms of the monthly investment instead of a probability. This was confusing and as pointed out by  Paresh Girdhar, gave some confusing and erroneous results.

Therefore, I have replaced the confusing section with the probability of financial independence for a given number of years in retirement. Hopefully, the sheet is now simpler to use.

The probability of financial independence is determined by randomly varying the above-mentioned rates, 50,000 times in each trial as shown below (click for full size). The user can either use a normal distribution or an uniform distribution. If you are not comfortable about this, simply use the normal distribution for all quantities.

More details on Monte Carlo Simulations (disadvantages, alternatives etc.), can be found here and here

## Download the updated Monte Carlo Simulator

Thanks to Rajesh for pointing out a bug.

Want to conduct a sales-free "basics of money management" session in your office?
I conduct free seminars to employees or societies. Only the very basics and getting-started steps are discussed (no scary math):For example: How to define financial goals, how to save tax with a clear goal in mind; How to use a credit card for maximum benefit; When to buy a house; How to start investing; how to invest for and after retirement etc. depending on the audience. If you are interested, you can contact me: freefincal [at] Gmail [dot] com. You need to only cover my travel fare for the session.

## You Can Be Rich Too with Goal-Based Investing

My first book is now available at a 35% discount for Rs. 258. It comes with nine online calculators. Get it now.  The Kindle edition is only Rs. 199.

## Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want

My second book is now only Rs 199 (Kindle Rs. 99) Get it or gift it to a young earner

## The ultimate guide to travel by Pranav Surya

This is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step.  Get the pdf for ₹199 (instant download)

## Free Apps for your Android Phone

All calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

## Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.

## 8 thoughts on “Stress Test Your Retirement Plan”

1. Rakesh says:

Fantastic work Pattabiraman. I am really impressed at the effort that you have put in to build all these different calculators. They are definitely quite relevant for practical personal financial planning. Considering that most calculators in the personal finance space in india are more of a theoretical and non-practical nature, your blog is indeed a breath of fresh air for people like me.

I am particularly impressed with this calculator for stress testing of retirement plan, considering very limited historical data that we can rely on here and the volatility we find in the rate of returns as well as inflation. Thank you for all this.

One small observation on the stress testing calculator is that i noticed the probability of success seems to be decreasing as you reduce the number of years in retirement which for me was counter intuitive. For e.g, i found that the probability of success for certain set of values of interest rates, inflation, distribution assumptions etc, for 45 years in retirement was 89%, however when i changed this value to 20 with all the other values remaining the same the probably of success reduced to 58%. Do let me know if i am missing something here.

Regards
Rakesh

1. pattu says:

Thank you. The issue is due to a bug. I have corrected it and uploaded a revised version with a credit to you. Many thanks.

2. Rakesh says:

Fantastic work Pattabiraman. I am really impressed at the effort that you have put in to build all these different calculators. They are definitely quite relevant for practical personal financial planning. Considering that most calculators in the personal finance space in india are more of a theoretical and non-practical nature, your blog is indeed a breath of fresh air for people like me.

I am particularly impressed with this calculator for stress testing of retirement plan, considering very limited historical data that we can rely on here and the volatility we find in the rate of returns as well as inflation. Thank you for all this.

One small observation on the stress testing calculator is that i noticed the probability of success seems to be decreasing as you reduce the number of years in retirement which for me was counter intuitive. For e.g, i found that the probability of success for certain set of values of interest rates, inflation, distribution assumptions etc, for 45 years in retirement was 89%, however when i changed this value to 20 with all the other values remaining the same the probably of success reduced to 58%. Do let me know if i am missing something here.

Regards
Rakesh

1. pattu says:

Thank you. The issue is due to a bug. I have corrected it and uploaded a revised version with a credit to you. Many thanks.

3. Sundararajan says:

Wow, Great one. But I have a question on this. I just played around this with some numbers. For example for 40 years in retirement with Rs 55k per month in expenses, Rs 3.5cr gets 80% of probability. But I couldn’t get 100% even if I increase to Rs 10 cr. I kept all other parameters for variations as it is. Not sure if I am doing anything wrong.
BTW at what is the practical % one should be comfortable with? Does one should be comfortable with 80% probability or 100% or less? I know more is merrier, but it needs more corpus or less years in retirement or roi should be higher or inflation should be lower. Can you let me know? Thanks

1. Thanks. I dont think 100% is possible because of the fluctuations. I think 80% is pretty decent.

4. Sundararajan says:

Wow, Great one. But I have a question on this. I just played around this with some numbers. For example for 40 years in retirement with Rs 55k per month in expenses, Rs 3.5cr gets 80% of probability. But I couldn’t get 100% even if I increase to Rs 10 cr. I kept all other parameters for variations as it is. Not sure if I am doing anything wrong.
BTW at what is the practical % one should be comfortable with? Does one should be comfortable with 80% probability or 100% or less? I know more is merrier, but it needs more corpus or less years in retirement or roi should be higher or inflation should be lower. Can you let me know? Thanks

1. Thanks. I dont think 100% is possible because of the fluctuations. I think 80% is pretty decent.