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.

Promotion
Promotion

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 has to be sophisticated.

Bucket Strategy

We are talking about early retirement – so we can assume that the person can still actively manage the corpus. The person divides the corpus into various buckets, and 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. You can be more active in the first 3 buckets too.

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.

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 12th 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 childrens’ college education and either higher education or marriage.  I wanted to push further if I can meet all the goals, and throw in expensive vacations. This 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 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 youngest spouse is 93 years young
  • First child is expected to go to college in 6 years; the second child is 2 years younger
  • Current annual expenses (adjusted for FF lifestyle) are 6 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.1 of the calculator.)

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

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.

Step 2

Step 3: Provide inputs for other expenses, inflows and income. There could be some periodic inflows – ill-advised insurance plans, etc.

Step 3

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 make the plan more feasible, but would also increase the stress.

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.

Step 5

If the family can invest about 58,000 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 too.

Step 6: Review the corpus deployment sheet and count the blue ticks. You can see how prepared you are to take the FF plunge. 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.  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.

Step 6 – done closer to retirement

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

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.

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 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.

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.

Cash Flow Calculator

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.

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

1. 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, vacation, 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.

2. 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.

3. 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.

4. 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.

5. 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. 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.

6. 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.

7. 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.   

Leave a Reply

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