FIRE Up – Comprehensive calculator for Early Retirement

FIRE Up - Comprehensive calculator for Early Retirement

FIRE – Financial Independence, Retire Early

This long article describes a calculator that combines a set of factors to assess the feasibility of achieving financial freedom early in life. Financial Freedom (FF), or Financial Independence(FI) can be defined this way – the state of having sufficient personal wealth to live, without having to work actively for basic necessities as well as other life goals. The article has been updated to describe two versions of the calculator – the traditional model and an aggressive model.

Update:  Please see this article for a later version of the calculator. The version retains the basic structure and includes many usability requirements. 

In the phrase FIRE, I personally like the FI part more than the RE part. You could love your job and strive to be the best that you can be. You don’t have to retire early. But you can seek to achieve Financial Freedom as early as possible. This can then motivate you further in your career/venture.

The tool described in this post estimates the investment and corpus required to handle the following:

  • Living expenses for the family (for a maximum of 55 years)
  • School expenses for two children (as needed)
  • College education for two children
  • Higher education for two children
  • Other major expenses like Vehicle, Vacation, Marriage, etc.

Why typical calculators don’t handle FIRE

In a typical retirement – say at or after 55 years – an individual would have completed most of the financial milestones- home, children education, etc. The only, or definitely the biggest,  factor would be the corpus to fund the living expenses.

In an early retirement scenario, say 45 years, many of the other goals would be unmet. The corpus will have to address these goals as well as retirement needs. Considering the long years in retirement, the withdrawal strategy also has to be sophisticated. The typical calculators suggest one asset allocation during the accumulation phase, and expect you to redeploy the assets differently during the withdrawal phase; this too becomes complicated in an early retirement scenario.

Bucket Strategy

Since we are talking about early retirement, we can assume that the person can still actively manage the corpus. The Bucket Strategy to manage retirement corpus requires the person divides the corpus into various buckets. The person parks or invests the buckets appropriately. By using the bucket strategy, we can  ensure/hope that the corpus actually has post-inflation growth even during retirement.

  1. Bucket 1 – Living expenses and other cash flow for first 5 years – FDs, Liquid funds
  2. Buckets 2 & 3 – Living expenses and other cash flow for the next 10 years – Ultra short, short duration
  3. Buckets 4 & 5 – Living expenses and other cash flow for the next 10 years – Balanced, Large Cap
  4. Bucket 6 and beyond – Rest of the corpus – More aggressive equity

After five years, you need to pull down all the buckets a notch and reshuffle. The process is then repeated every 5 years.  Of course, you can design the buckets a bit differently. You can be more active in the first 3 buckets too. But overall, you would plan to have the corpus invested in different assets and growing at different rates.

Note:

This somewhat-complex calculator is derived from some of the fantastic calculators available at freefincal.com. A full list of the articles is given at the end of the post.

Edit: There are two versions of the calculator – Traditional and Aggressive. A key implementation detail of the aggressive version of the calculator is that it creates buckets from the current year, and implicitly assumes that the initial buckets have been filled. This calculator may not be suitable if you are a younger investor, or more than 10 years away from the planned financial freedom date. (courtesy reddit user caffeineismylife). To help people who have low corpus, and/or many years away from retirement, the traditional version of the calculator is available – this follows the typical approach of redistributing the buckets at retirement.

Approach – Bucket Strategy Calculator for ‘Early Retirement’

This tool seeks to apply the  bucket strategy to major goals as well as retirement. (A corollary of the approach is that there is a single portfolio for all the goals. This by itself can lead to a lot of simplicity in how the corpus is managed.)  I developed this for my personal situation. My first child would be in 11th standard in the year that I plan to achieve financial freedom. (I may choose to retire at that time, continue working or take a different career – that does not change the goal of financial freedom.) My second child is 3 years later in education. So in the first 12 years of FF, I would have many large expenses related to my children.

My retirement corpus (along with rental income) seems sufficient to follow the typical income drawdown strategy to meet the living expenses. I have built a corpus that again seems sufficient for my children’s’ college education and either higher education or marriage.  I wanted to push further and see if I can meet all the goals, and also throw in expensive vacations. The FIRE calculator helped me assess that.  The typical calculators are not helpful since they mostly consider living expenses alone. I took some great calculators from freefincal.com and added some more. I came up with a reasonably complex calculator that can tell you if you are on track for financial freedom. The original freefincal blog posts have detailed, useful information on the calculators. Please look up the references.

Illustration used

The calculator has pre-filled data for a scenario. These are the details:

  • Earner is 40 years young and seeks to achieve Financial Freedom at 48
  • The retirement corpus is expected to last till the younger (by 3 years) spouse is 90 years young
  • First child is expected to go to college in 6 years; the second child is 3 years younger
  • Current annual expenses (adjusted for FF lifestyle) are 6.4 lacs (This should exclude vacation, school expenses, etc.)
  • The family has made some investments towards the goals and the current corpus is known
  • The tool makes no assumptions on the salary; you have to decide if your income is sufficient to make the required investments
  • For simplicity, we assume that all expenses till retirement (including major expenses) are funded from the active income and other sources. It is straightforward to build a separate corpus for these, if required

Step-by-step intro to the calculator

The first sheet provides the sequence of steps suggested to use the calculator. We would look at them in sequence. In the description below, screenshots are included; please follow along with the calculator. Or better still, enter your own values in the calculator after downloading it from the button below. (Edit: Please use version 3.6 of the calculator.)

Step 1: Provide inputs for overall situation – age, FF target, expenses, inflation and return expectations, etc.

Retirement Inputs

Step 1

Step 2: Provide inputs for goals for children. An interesting feature of this approach is the split of education expenses into different years. Typically, there are larger expenses for the first year of college than later years. The figures in the illustration are adequate for an engineering education.

Child goals

Step 2

Step 3: Provide inputs for other expenses, inflows and income. There could be some periodic inflows – ill-advised insurance plans, etc. For these, use -ve values and set inflation to zero.

Periodic expenses

Step 3

Step 3B: Provide inputs for regular income during retirement ages. You can input upto four different income streams.

Income streams

Step 3B

Step 4: Provide inputs on the current corpus, and XIRR assumptions. Since the calculator considers equity, taxable debt and tax-free debt, you need the corpus split into these categories.  It would be best to leave the XIRR values as they are. Increasing them would reduce the required investment, and make the plan look more feasible, but would also increase the stress.

XIRR and corpus inputs

Step 4

Now it is the time to review the calculations.

Step 5: Review the estimated corpus, and investment required to build it. You can adjust the allocations to equity and debt. The approach in this calculator does not require the typical 100-age guideline for equity.  If you already have a large debt corpus, you can be more aggressive in equity. Please spend time in adjusting the allocation; but keep the stress factor in mind. Having a large equity allocation would increase the stress.

Calculation output

Step 5

If the family can invest about 1.84 lac rupees a month, they can meet the retirement plan. If this amount seems too high, you can review the goals and see what could be given up. For example, you can decide to take loans for higher education and adjust the goal for that. Of course, you can always postpone the goal of financial freedom. In this example, if this goal is set at 53 years (5 years more), the required monthly investment is much lower. 

Step 6: Review the corpus deployment sheet (named Subjective-Stress-Reducer) and count the green ticks. You can see how prepared you are to take the FF plunge. This step should be done before you start using the recommendations from the calculator. The sheet looks at the current corpus only and does not take into account the future investments except EPF.  A very important factor here is the corpus in debt and equity.  You can see that there are large outflows in the first decade and hence a large corpus is required in debt.

Subjective Stress Reducer

Step 6

In the illustration, the family is just about on the path and is still far away from the required corpus. But the 7+ years of disciplined investment could get them closer. 

The traditional version has distinct accumulation and deployment phases. The corpus is redeployed on retirement.  The aggressive version assumes that the corpus is continuously deployed in the required asset classes, while it is being accumulated.

And that is it. Hopefully you could follow along till now. I would add article(s) on more sample situations and possible what-if scenarios.

Did you find the article useful? Please share your comments below.

Aggressive Model – Description of steps

The aggressive model takes the same set of inputs for goals and assumptions.  Steps 4 and 6 are differently implemented in this model.

Step 4b: Reallocation of current corpus. Once you enter the details of the current corpus and the expected XIRR, the tool projects the gap in equity and debt portions of the corpus. The aggressive model is more accurate if the shortfall in debt corpus is zero, or as close to zero as possible. With the same inputs, the calculator would throw up a large investment amount.

Reallocation

Step 4B

Since the model assumes that the initial buckets are fully funded, and the initial buckets are mostly in debt, the current assets should be reallocated to have the debt shortfall as close to zero as possible.  This can be done in this example by moving about 45 lacs from equity to debt.  With this change, the corpus allocation would be like this.

FIRE Up - Comprehensive calculator for Early Retirement 1

With a larger corpus in debt, a larger portion of future investments can be in equity, thus reducing the required investment amount. For the aggressive model, this can be lower – 1.36 lac instead of 1.84 lac.

FIRE Up - Comprehensive calculator for Early Retirement 2

Step 6:  In the aggressive model, the buckets are created rightaway and deployed.  In the example, the family is still a distance aware from reaching the Financial Freedom goal. The model can help in reducing the required investments, but would have similar readiness indicators as the traditional model.

FIRE Up - Comprehensive calculator for Early Retirement 3

Edit: If you are using the aggressive version of the calculator, please note that the calculations assume that you have built a sizeable corpus that can be deployed in the right asset classes starting now. If your retirement date is more than 10 years away, and/or if your current corpus is low, the calculations can err on the lower side, and you should look to invest more than the suggestion. I thank the reddit user ‘caffeineismylife’ for the inputs to this version. If you are in this situation, please use the traditional version of the calculator to get a better estimate.

For the adventurous – Calculation Details

If you are curious, please explore  the last two sheets that have the bulk of the calculations.

The income ladder sheet lays out the corpus calculations based on the buckets. For each bucket of 5 years, the net cash flow is used to calculate the corpus required for the bucket, and the investment required to build the corpus. Column F in the table holds the most critical information – expected returns to build the various buckets. The values here are realistic, considering the impact of taxation.

  • 10% post-tax return for equity investments
  • 7% post-tax return for debt instruments
  • 5% post-tax return for each bucket
Bucket Calculator

Bucket Ladder Calculator

You can scroll to the right to see how the various buckets look. I can’t thank Pattabiraman Murari enough for the lay-out of the buckets. This detailed layout seems to be the only way to get the bucket strategy estimation done correctly. The lazier approach of using a single formula for the entire period would not help.

FIRE Up - Comprehensive calculator for Early Retirement 4

The last sheet – YearlyCashFlow – lists the required cash flow during the period of the calculator.  It picks up the data from the goal planner sheet and adds the estimate of living expenses and other income. The net cash flow for the year is used in the bucket calculations. The comments at the top provide explanations on the formulae used. This sheet uses the table structure; if you change the formula in one cell, the entire column would reflect that change.

Yearly Cash Flow

Yearly Cash Flow

References

Additional Reading: How I built the calculator

If you have already used calculators from freefincal.com, the following section would be helpful to explain the approach and the changes.

  1. The calculators always start with the inputs for retirement planning. For any person earning income, this is always Goal # 1.

  2. I took the goal planner sheets from 2012 to reflect other requirements. (https://freefincal.com/goal-planners-2/) One of the sheets has the template for staggering education expenses into many years. To this I also added a table to capture some non-recurring expenditure like vehicle, vacati on, etc. The sheet can be used standalone for detailed calculations for education goals. For the purpose of financial freedom, the most relevant information is the corpus required for a particular year.

  1. I then merged this into the bucket strategy simulator for retirement. (https://freefincal.com/the-even-lowe…nt-calculator/) In fact the new calculator is an attempt to validate the assertion at the end of the first paragraph: The reduction could be higher for early retirement.

  2. I had to modify some of the formulae in the sheet to pick amounts for all the goals. These modifications are marked in light blue fill. More than 90% of the information in the sheet is retained from the original version.

  3. I created a new sheet that captures yearly outflows under various heads – Education, Retirement, others, etc. This is the last sheet in the file. Since the calculator is for all goals, there could be large variations in yearly expenses.

  4. I extended the buckets to a total of 11 years. If each bucket is for 5 years, then the calculator can be used for a period upto 55 years from now. For the aggressive version, I modified the structure so that the buckets start right away, instead of from retirement. (This modification makes the calculator specific to early retirement scenario.) I also modified the relevant cells to pick the expense amount for that year from the cashflow sheet.

  5. When the calculations from the buckets are plugged back, the Retirement_Inputs sheet gives a clear idea of the net corpus required, and the monthly investments required to achieve that corpus. If this monthly investment can be met, then it is feasible to achieve early financial freedom.

  6. The ‘Stress Reducer’ sheet seeks to provide an overview of the corpus required and where it can be invested. If you have sufficient corpus to get 4 or more ticks, you can consider that you are at the Financial Freedom threshold. This step should be done closer to the date of FF. The sheet looks at the current corpus only and does not take into account the future investments except EPF.

7 thoughts on “FIRE Up – Comprehensive calculator for Early Retirement”

  1. Nice calculation strategy. However it does not take into account the existing real estate and associated capital appreciation and withdrawal strategy like sale or reverse mortgage.

    1. Thanks for the comment. You are very right in the large impact that real estate can have on the plan. I would look for ways to include this in the next version.

  2. This is a terrific updation to Pattuji’s retirement calculator. Open sourcing is such a wonderful concept. This is highly useful and comprehensive. Thanks for the effort.

  3. Reema Mukherjee

    hi, i downloaded the excel sheet, but it doesnt seem to be auto calculating .I enabled macros on excel too, can you help?

  4. I have used the document that you have arduously created and curated.

    1. kid 1 early education + UG + PG + Marriage
    2. kid 2 early education + UG + PG + Marriage
    3. car (3 purchases in life time)
    4. vacations (6 vacations in life time)
    5. Health management not covered by insurance (chronic/OPD)
    6. Periodic appliance replacement (TVs/Mobiles/Fans etc)

    Numbing to to see the required numbers how far I am for what I consider to be safe with no buffers. Perhaps early retirement is not an option for everyone, especially those with kids and lot of wants.

  5. Pingback: FIRE Up - Comprehensive Calculator for Financial Freedom

Leave a Reply

Your email address will not be published. Required fields are marked *