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.

Written by Tawcan
Hi I’m Bob from Vancouver Canada, I am working toward joyful life and financial independence through frugal living, dividend investing, passive income generation, life balance, and self-improvement. This blog is my way to chronicle my journey and share my stories and thoughts along the way. Stay in touch on Facebook and Twitter. Or sign up via Newsletter