The Early Retirement Financial Independence Spreadsheet Calculator

early retirement financial independence spreadsheet calculator

I am an Excel spreasheet nerd. So when the great J. Money shared a couple spreadsheets for calculating when you can achieve early retirement / financial freedom, I decided to create my own early retirement financial independence spreadsheet calculator to incorporate dividend investing as well as other passive income streams. (I like using the word independence instead of freedom cuz I’m no William Wallace 😉 ). According to our somewhat conservative calculation, we should be able to achieve financial independence in about 15 years. Our financial independence timeline will be reduced to about 10 years if we are more aggressive with some of the calculations and assumptions. The 10 – 15 year time frame is approximately on par with our target. Since this is just a forecast, there are many variables that may change to alter the end result. For now, we’ll continue being frugal and invest as much money in our dividend portfolio as possible.

J. Money’s spreadsheets assumed that you will be withdrawing from your retirement/investment funds at a certain rate. This is perhaps different than the concept of dividend investing. For dividend growth investors, we are buying dividend paying stocks with the goal that one day our monthly dividend income will be greater or equal to our monthly expenses. When this happens, we can then call ourselves “financial independent” and can quit our jobs if we choose to. For dividend growth investors, the goal is to not touch the principal and only use the dividend payouts to cover all the expenses.

early retirement / financial independence spreadsheet calculator

The Early Retirement Financial Independence Spreadsheet Calculator

You can get the file here: Financial Independence Spreadsheet

Here are some explanations for my version of the early retirement financial independence spreadsheet:

Investments

This is where you list all of your investments. I used J. Money’s original format but added Canadian touches by including RRSP and TFSA. To incorporate dividend investment concept, the total investment portfolio is split up into two –  dividend portfolio and non-dividend portfolio. For the dividend portfolio portion, you will need to enter your portfolio’s yield on cost percentage. This will then determine your current forward dividend income. The non-dividend portfolio value is therefore whatever amount left. We will withdraw money from the non-dividend portfolio.

Other Passive Incomes

Since some people not only invest in stocks but also invest in real estates, royalties, businesses, and other passive income generating revenues, this section is used to track these incomes. I broke this section into two, one for tracking real estate income, the other for tracking other passive incomes. Since I’m no real estate expert, the rental income section is extremely simplified. I am simply using monthly rental surplus as the calculation variable.

Age:

Here you enter your current age. The spreadsheet then takes in all the parameters that you have entered to determine the age that you will achieve FI. This is determined when your total passive income is greater or equal to your yearly expenses. If the spreadsheet gives you a “False” result, I’m sorry to say this but you are in serious trouble. Time to shape up!

Expenses (currently) –

This section is pretty self-explainatory. In order to determine when you can achieve financial independence, we need to estimate your monthly expenses. The yearly expenses is derived by multiply the monthly expenses by 12. You can just plug in a rough number here or use the “Expenses” sheet to estimate your monthly expenses. To help determining a more accurate monthly number, I have listed different possible spending categories for you to enter. Depending on your personal situation, you may have more categories, feel free to modify this section as you wish.

In the perfect world, the monthly expenses will stay the same forever, however, this is typically not the case due to inflation. Even if you keep all the expenses in check, some expenses like property taxes and car insurance will most likely increase every year. In the spreadsheet, I have included a section for estimating the inflation rate and how it will impact your future yearly expenses. If you think you can keep the monthly expenses the same over the next 20 to 30 years, simply use 0% as the inflation rate. I think it’s reasonable to assume a 0.5% – 2% yearly inflation rate on your annual expenses.

Dividend Income (growth over time) –

This is where we calculate your future dividend income. First we need to have an estimate on the yearly dividend growth rate. To determine this parameter, you can take a look at your dividend portfolio and calculate how much your dividend income is growing each year if you don’t contribute any additional capital. This is also known as the organic dividend growth rate. Next enter the additional money that you plan to add each year and estimate the average dividend yield for the dividend stocks that you will purchase. There are a lot of numbers to enter in this section and a lot of assumptions that we’re making. Do you best. I think it’s reasonable and conservative to assume that the new stock purchases will yield anywhere between 2.5% to 3%. A dividend growth rate between 5 – 10% is also pretty reasonable I think.

Non-dividend Portfolio (growth over time) –

Similar to the previous section, this is where you determine how much growth you will see on the non-dividend portfolio over time. The return rate and yearly additional investment will determine how fast your non-dividend portfolio will grow.

Rental Income / Other Passive incomes (growth over time) –

Shame idea as the previous sections. We need to estimate how much rental income and other passive incomes will grow over time.

 

Assumptions the early retirement financial independence spreadsheet makes:

  • 4% withdraw rate – For the non-dividend portfolio we assume a withdraw rate of 4%. This seems to be the universally agreed withdraw rate. You can change this number based on your belief and comfort level.
  • 8% growth rate for non-dividend portfolio – We assume that the value of the non-dividend portfolio will grow at 8% annually. This is to be in-line with what J. Money used in his original spreadsheets. If you feel like you can achieve Warren Buffet like return, feel free to change this number.
  • 8% dividend growth rate and 3.5% new stock dividend yield – these are the conservative estimates I’m using. If you decide to invest in higher dividend growth stocks and/or take on more risks these numbers will be very different. Change them as you like.
  • Dividend re-investment – For the dividend portfolio, we assume that you will re-invest all the dividends received each year. If you want to see all the background calculations you can unhide the columns. I assume that you’re not enrolled in dividend re-investment plans (DRIP) and re-invest all the dividends and the new contributions at the same time. To be perfectly honest, I wanted to calculate the affect of DRIP but the calculations are just too complicated. 🙂
  • Total passive income – we assume that you will achieve FI when your total passive income is greater or equal to your yearly expenses. However we do not consider that your non-dividend portfolio value may start decreasing each year as you start withdrawing 4% from this portfolio. Again the math is a little too complicated to incorporate this factor into the spreadsheet.
  • Yearly additional investments – we assume that you will invest the same amount year after year. This is probably not super realistic in real life. For the most of us, the investment amount will probably be different each year.
  • Dividend portfolio principal – we assume that we will not touch the dividend portfolio principal. This is to be in-line with the DGI concept.
  • Real estate rental income / Other passive incomes : we assume that you’re not adding more real estate properties to boost your future rental income. We are simply using growth rate (this is more like inflation rate) to determine how much your rental income will grow in the future. This is extremely simplified. This assumption holds true for the other passive incomes section as well.
  • Taxes – Ahhh taxes, the one thing we can’t avoid in life. The calculations in the spreadsheet assume that your passive incomes are not being taxed. Again an extremely simplified assumption.

 

Some thoughts on the early retirement financial independence spreadsheet calculations:

  • Your monthly expenses plays a CRUCIAL role on when you can achieve early retirement / financial independence. The more you spend each month, the more passive income you will need. It’s a lot easier to cut expenses than generating passive income. If you’re surprised by your FI age result, you can speed up your FI journey by reducing your monthly expenses.
  • Contributing additional capital year after year will allow you to take advantage of the power of compound interest. If you play around with the yearly growth rate for each income section, it’s pretty cool how quickly the dollar amount increases 10 years down the road.
  • There are a lot of assumptions in the spreadsheet and the calculations may not be 100% realistic. However, the numbers do give you a good overview where you stand today. If the numbers do not reflect what you have in mind, you can quickly figure out which areas you need to work on.
  • It’s always good to have multiple passive income streams. Diversification is always a good thing.

 

Comparing the age that we’ll hit FI between this version of the early retirement financial independence spreadsheet and the original by J. Money, we found that our FI age was reduced by 2 years in this version of spreadsheet. This reduction in years may not seem significant to some, but it is significant to us. First, it tells us that the power of compound interest is very powerful when it comes to re-investing dividends. It also tells us that if we can increase our annual contributions now rather than later, we can reduce the FI age even further. Even with our conservative estimates and calculations, we are around 8 – 15 years away from achieving financial independence. This result is roughly in sync with our target. It’s always good to know that what we’re doing today will result in great rewards in the near future.

Having said all that, the calculations and assumptions are based on our current situation. Considering that we are planning to have another kid, the new addition to the family will probably increase our expenses and will probably prolong our quest to financial independence. But if we were to worry about these other factors that may change our quest to FI, we will be worrying every single minute of our lives. While achieving early retirement / financial independence is important, it is also important to enjoy the small things in life as well as being at peace with yourself.

Please take a look at the spreadsheet, run some calculations, and let me know what you think. I would appreciate all the feedback.

Get update via email:

You Might Also Like

40 Comments

  • Reply
    The Money Spot
    March 16, 2015 at 5:08 am

    I have my own spreadsheet but I love J’s templates as well! I think it’s great that you can combine a lot of different portfolios into 1 spreadsheet.

    • Reply
      Tawcan
      March 16, 2015 at 1:21 pm

      Hi The Money Spot,

      The idea was to incorporate dividend investment into the calculation. Hopefully this version of the spreadsheet will be helpful to dividend investors.

    • Reply
      Tawcan
      March 16, 2015 at 1:22 pm

      Hi Holly,

      FI at 46 is pretty awesome. It’s fun to speculate and have a rough idea but you won’t know the “exact” date until your closer to the date.

    • Reply
      J. Money
      March 16, 2015 at 2:26 pm

      Here’s my original template tweaked to include real estate and pensions that a fellow reader did 🙂

      http://budgetsaresexy.com/files/er-re-pensions.xlsx
      (It’s also uploaded to my main article as well fyi)

      I love seeing everyone taking this and adapting to their own needs! So cool!!! We’re all such nerds! Haha…

  • Reply
    Elroy
    March 16, 2015 at 6:57 am

    So, what would be interesting [….] for those who invest dividends in taxable accounts. Which is better, taking a tax hit year after year, or “growth” investing? I know that is a bit of a hyperbole, but I don’t get the dividend obsession with dividends.

    • Reply
      Tawcan
      March 16, 2015 at 1:23 pm

      Hi Elroy,

      Good point on alternative calculations. It might be tough to determine since tax rate will be different depending on the individual. I wouldn’t call it a dividend obsession but just a different concept when it comes to investing.

  • Reply
    Roadmap2Retire
    March 16, 2015 at 7:01 am

    Achieving financial independence in 15 years sounds great Tawcan. You sure have a great income stream building up and Im sure you guys will get there sooner rather than later. Thanks for sharing the spreadsheet – and a special thanks to J. Money. I will play around with the sheet.

    cheers
    R2R

    • Reply
      Tawcan
      March 16, 2015 at 1:24 pm

      Hi R2R,

      Let me know if you find anything that can be updated. Always looking way to improve the spreadsheet.

  • Reply
    Barry @ Moneywehave
    March 16, 2015 at 7:25 am

    I love these financial independence things but as an index investor I wonder how it would apply to me. Do I just look at the dividends being paid out, some which happen just quarterly? Maybe I just need more income streams.

    • Reply
      Tawcan
      March 16, 2015 at 1:25 pm

      Hi Barry,

      I suppose one would need to alter the spreadsheet a little bit to consider how much the “non-dividend” portfolio would yield when it comes to dividend. I guess for index investors you can either live off the dividends or withdraw the fund, or a combination of both.

  • Reply
    [email protected]
    March 16, 2015 at 12:03 pm

    I’ve been meaning to play around with that spreadsheet after reading J Money’s post. I did a very rough estimate and I think that we could get there in 10-15 years as well. Probably leaning towards earlier if we live NYC though! Tough decision though. Another thing is that if I stick it out for 15 years, part of me will want to stick it out for an additional 5 years to get my full pension (big penalty for leaving early).

  • Reply
    J. Money
    March 16, 2015 at 2:27 pm

    This is awesome Tawcan!

    I love seeing my original spreadsheet tweaked and updated like this!

    Going now to add it to my main page too so my readers can check it out and download as well.

    Rock on bro.

    • Reply
      Tawcan
      March 17, 2015 at 2:20 pm

      Hi J. Money,

      Thanks for updating your original post to include me.

  • Reply
    MyMoneyDesign
    March 16, 2015 at 4:09 pm

    Like a lot of the other bloggers, I’ve got my own version of an early retirement estimator spreadsheet that I use. But all the same – I’ll have to check this one out. Nice work adding some mods of your own!

    • Reply
      Tawcan
      March 17, 2015 at 2:20 pm

      Hi MyMoneyDesign,

      We have our own version of FI spreadsheet as well but this version is slightly improved than our original version. Let me know if there are anything that needs to be improved.

  • Reply
    Tony @ Investing On Track
    March 17, 2015 at 4:11 am

    Haha your spreadsheet is so detailed and well laid out – I don’t even have one. Maybe I’ll get around to creating one sometime, but since I’m young I figure I’d like to work towards $10 million and then I’ll retire. I’ve been working on a tech startup to help me reach my goal.

    • Reply
      Tawcan
      March 17, 2015 at 2:22 pm

      Hi Tony,

      Thanks please play around with my spreadsheet and let me know if there’s anything missing. $10 million is a pretty big goal to aim for.

  • Reply
    weenie
    March 17, 2015 at 5:00 am

    Hi Tawcan

    I had a go on J$’s original spreadsheet and it had me getting to FI in 12 years, so ahead of my own predictions.

    I’ll have a play around on yours – thanks for working on it!

    • Reply
      Tawcan
      March 17, 2015 at 2:22 pm

      Hi weenie,

      12 years is pretty damn good! Let me know if my version of spreadsheet changes that number.

    • Reply
      Tawcan
      March 17, 2015 at 2:23 pm

      Hi Rebecca,

      Lol at the Canadian influence. I always get confused with the US equivalent of tax deferred/sheltered accounts, hence for adding a bit of Canadian touch. 🙂

  • Reply
    RA50
    March 17, 2015 at 11:24 am

    Hi Tawcan,

    Excellent, I will look and plug our data in this spreadsheet and see if I come to same conclusion from the one I did some time ago. Your seems to be much more fancy and professional.

    If everything goes well, I will make a post using this info.

    Thanks again to both of you and best regards,

    RA50

    • Reply
      Tawcan
      March 17, 2015 at 2:23 pm

      Hi RA50,

      Definitely keep me updated on whether you get to roughly the same conclusion.

      Cheers.

  • Reply
    Ryan
    March 17, 2015 at 7:37 pm

    Very cool and fun to play with, Tawcan. Thank you for sharing this awesome tool!

    • Reply
      Tawcan
      March 18, 2015 at 11:44 am

      No problem Ryan, Hopefully the spreadsheet is useful for you.

  • Reply
    Asset Grinder
    March 18, 2015 at 8:33 pm

    Awesome tool man. Will tweet to all my followers. Keep up the good work!

    • Reply
      Tawcan
      March 23, 2015 at 8:29 pm

      Thanks Asset Grinder, keep grinding hard!

  • Reply
    BeSmartRich
    March 22, 2015 at 5:05 am

    Excellent spreadsheet Tawcan. It is going to be fun project of mine to play it with a bit more!

    BSR

  • Reply
    Fervent Finance
    March 24, 2015 at 7:20 am

    Great calculator. One thing I’ve noticed that is a variable I’ve tried to account for when performing a similar exercise is that my savings rate increases every year as my expenses stay about the same and my income goes up. Therefore my contributions into my after-tax accounts would increase every year. Maybe I’ll try to tweak your spreadsheet for this. Thanks!

  • Reply
    No More Waffles
    March 25, 2015 at 6:55 am

    You beat me to it, Tawcan!

    I’ve been working on a DGI ERE/FI spreadsheet myself over the past couple of days. I’m definitely going to check yours out and see if I can’t incorporate some good ideas in my own file.

    Best wishes,
    NMW

    • Reply
      Tawcan
      March 26, 2015 at 2:12 pm

      Let me know what kind of tweaks you end up with your spreadsheet. Always looking for inputs.

  • Reply
    Debtless in Texas
    March 26, 2015 at 6:01 am

    Awesome work with the spreadsheet, thanks for sharing it with us. It is nice to see other excel nerds tweaking and sharing – I love it.

    • Reply
      Tawcan
      March 26, 2015 at 2:13 pm

      Thanks Debtless in Texas for your kind words. 🙂

  • Reply
    Early Retirement / Financial Independence (FI) Spreadsheet! | Budgets Are Sexy
    August 19, 2015 at 11:51 am

    […] – Here’s another tweaked version of my original spreadsheet that fellow blogger Tawcan just posted about on this site.  This one incorporates dividend investing as well as other passive income streams […]

  • Reply
    Tawcan - why I’m living off dividends and distributions
    October 6, 2015 at 2:27 pm

    […] RRSP’s, TFSA’s, and taxable accounts. According to the early retirement/financial independence spreadsheet calculator that we created, we are on target to reach FI in 8 – 15 years, which is roughly on target with our goal of […]

  • Reply
    Financial Independence Interview-Tawcan | Even Steven Money
    November 13, 2015 at 11:03 am

    […] only debt we have is our house mortgage. When we crunched out numbers on the FIRE spreadsheet calculator that we created, we definitely took mortgage payment into consideration. To us, reaching financial independence […]

  • Leave a Reply