THE 20 YEAR SPREADSHEET

by Steve Laube, Coach, Mastering Passive Income Coaching Program, GaREIA, Apr-Jun 2019

FIRE:  Financial Independence / Retire Early. Putting it all together, a how-to guide to developing your spreadsheet.

Mastering Passive Income / quitting the day job, has two major components; income and expenses. Each are discussed separately below. While we can debate all day long which is the most important, I actually think understanding your expenses has to come first. Defining and agreeing with your spouse / family on the lifestyle you want to have going forward, the sacrifices you may want to make or not, or the increased spending you desire to have, will make it much easier to determine the income you will need; and indeed whether or not you can even think about quitting the day job.

Worrying about income first could simply lead to the all too familiar, “more is better, and then, let’s spend AT LEAST that much” style of living.  If the Passive Income is coming from rentals, most don’t realize just how variable the rental income stream is and so can get into BIG trouble in a soft market.  On the other end of the scale, I have run into a lot of people (especially RE investors) who don’t realize they have it made and are still in the “frugal” mode. There needs to be a happy balance between spending what you can afford and spending too much.

POST DAY JOB / RETIREMENT EXPENSES

  1. Must and Discretionary Expenses

The first thing is to look at your spending in terms of “must” and “wants”… normally called, “discretionary spending”. Musts include housing expenses like P+I, taxes, insurance, utilities, cable /internet, interior and exterior maintenance and repairs, HOA fees. Other must expenses are income taxes, food, clothing, medical, transportation, and, I hope, charity, etc. What is especially important about most “must” expenses is that they will be subject to inflation over time; one notable exception will be the mortgage on your home, assuming you have a fixed rate mortgage. Note that in a pinch, even “must” expenses can be reduced somewhat.

Discretionary spending is highly individual; in fact you and your spouse probably will not agree and will have to negotiate what your discretionary spending looks like now and will look like going forward. Remember you will have lots of time to fill. What kind of lifestyle are each of you thinking about? Simple example, for my wife, two gym memberships are a must, a dependable car, all kinds of cosmetics, many many Zulily? shipments every month, etc. Her main discretionary items are just a couple of weeks of travel per year, spoiling the grandkids, and lots of going out to eat. For me, I need at least two sports cars, and my goal is one trip of some sort every month. I carefully track how many nights per year we / I do not sleep at home. I have a lengthy bucket list divided into sections like cars, domestic travel, international travel, manly man things, etc.

  1. What the Literature Says About Post Day Job Spending

The literature has some suggestions regarding your spending after you quit your day job. One of the most popular is that you will need about 80% of your “working” income. This is based on the typical situation in which certain expenses disappear post the day job.

  • You will no longer be paying 6.2 % of the first approximately $133,000 (2019) of your income into the SS program, and 1.45% of your total income into the Medicare plan. Note if you are self- employed you may in fact also be paying the employer’s share so these numbers could be double.
  • You probably will no longer be contributing to a 401K plan, or an IRA
  • Certain work related expenses will disappear like commuting, maybe some clothing, lunches, etc.
  • Longer term, your home mortgage will drop off
  • And you will have to carefully figure out what medical expenses will run. When you turn 65 medical expenses could / should drop due to Medicare.

The reduction in expenses noted above is in a tug of war with these items

  • You now have about 50 hours a week available per working person that you no longer had. Filling this time can eat up money. You now have the time to travel, join a country club, take up an expensive hobby (ies), on and on.
  • In general, maybe your retirement vision calls for an increase in your lifestyle. Second home? Boat? RV? Again, filling up all that time can cost money.

More recent work on post day job living suggests that for many spending could go up to about 120% of the spending in their previous lives, at least initially (see “go go” discussion below).

  1. Inflation

Inflation must be dealt with carefully. The financial planning industry now recommends planning to live to 95. For a “normal” retirement at age 65 this means 30 years of covering inflated expenses. The long term average of inflation is generally taken as 3%. Using the 3% figure an expense of “100” will be an expense of about 245 in 30 years.

  • But it is your actual “personal inflation” that counts, not the long term average of the entire basket of goods and services used to calculate the overall inflation of the economy. Simple example: if you have a fixed rate mortgage that disappears in say 18 years, then you will have “0” inflation on that part of your spending for 18 years and then a big reduction in expenses.
  • Real estate protects you from inflation in many ways. For example, with a mortgaged property, one actually gets a very favorable leverage such that an increase in rents results in an income increase of over double the percent rent increase, even if all your real estate operating expenses go up. Mortgages become paid off and this results in a nice jump in income, and finally, the property should increase in value at least as much as the general inflation rate of 3%. The inflation and loan pay down result in a big bucket of cash when you think in terms of equity not your initial investment.

AN INTRODUCTION TO THE THREE PHASES OF “RETIREMENT” CONCEPT

Recent thinking on normal retirement (age 65) divides it into three phases: the “go go,”  “slow go”, and “no go.”  (Wow, all those “go go“ dancers from the 70’s are now “no go” dancers?) While highly dependent on the individual, the go go phase is maybe 65-75; slow go 75-80, and no go after 80. Of course, if you attain FIRE and “retire” at say 50, your go go phase is likely to be 20 -25 years. This thinking is critical as “age” takes away much discretionary spending. Yes, there are still 80 year olds who go to the gym, travel, play golf, etc., but 50% of 65 year olds don’t even make it to 85, and there are a bunch of other 80 year olds who would like to be active but unfortunately can’t.  What is significant about this ageing in terms of spending is that recent studies show that retirees making over $100,000 / year typically have a lot of discretionary spending and they actually experience DIS inflation as they age. As noted, if your personal inflation is going to be significantly less than 3%, even 0, (maybe negative?) because of disappearing mortgage payments, rent inflation, and discretionary spending going away, that is a whole new ball game that completely invalidates the general rule of a 4- 5 % withdrawal rate from your savings accounts so that you don’t run out of money in 30 years. We will discuss the 4-5% rule at length in the Mastering Passive Income course; see “William T. Bengen” discussion in the income section below.

WILD CARDS

You can plan your expenses (and income) carefully and of course things can happen to upset the plan. One of these is commonly referred to as “the squeeze.”  You have at least one generation before you (parents) and maybe two after you (kids and grandkids) that may throw a wrench into the works. What if either of these generations suddenly needs financial help or demands your time? There are also brothers and sisters and other family members.

EXPENSE SUMMARY

This is confusing at best; your expenses could easily vary from say 80% of what they were when you worked, to 120%. What lifestyle do you and your spouse want? Expenses going forward will vary with your starting point; how much discretionary spending do you have that will disappear with time? When do your mortgages drop off? Will you downsize? Expenses will also vary with what phase you are in; go go, slow go, no go, and for how long. The “phase shift” can vary with how well you take care of yourself, genetics, etc.  Then there is the “wild card” factor, how do you think about that? We will discuss all of this in your one on one sessions.

INCOME

  1. The Three Legged Stool

Traditionally, post day job, there are three sources of income; maybe a pension or annuity of some sort, your savings (mostly TDA’s; tax deferred accounts like IRAs, 401K), and Social Security. For real estate investors, rental property is a major enhancement to these three sources. One paid for “ten cap” $150,000 property generates about the same income as a typical SS check that takes 35 years of working and your contributions to earn. The SS can help out your spouse but not the next generation while the rentals are multi- generational. For this reason, I developed the “Passive Income House” concept with the four corner columns representing the three traditional sources of income plus the real estate component.

  • Social Security can be taken anywhere from 62 to 70 years of age (no point in taking it later); the longer you wait the more you collect but of course for a shorter (unknown) period of time. The variation in payout with starting age is designed so that no matter when you start to take it, the amount of money collected at about age 81/2 is almost identical. So this is the “break even”, if you live past 81 you will still be collecting checks, the more those checks are, the more you collect in total. Starting later gives you a bigger check, so you collect more if you started later and live past 81 / 2. Conversely, if you pass before 81 you will have collected more if you started earlier, in spite of the reduction in benefits. Remember you can collect up to 8 years before the person who waited until 70 to get the highest benefit; takes a while for them to catch up to you. Last important point is that the survivor (last to die) gets the higher of the two Social Security benefits. So, “tell me when you and your spouse will pass and I will tell you when each of you should take SS; LOL.” For these reasons, I suggest you focus on what kind of overall financial health you are in as the determinant factor. If you are in good shape and SS after 81 is just the icing on the cake, then consider taking it early when both of you are in the go go phase and can enjoy the (reduced) income together.  Also, the 81 break even does not factor in the value of taking SS and reducing the withdrawals from any IRA/401K which then benefits from additional years of growing tax deferred.
  • Defined benefit (DB) pension plans are very rare these days, having been replaced by “defined contribution” plans such as a 401K. If you have a DB plan, you will collect an amount based on your years of service and typically your average pay for the last three, or highest three, etc., years of service. My formula was about 1.7% for every year of service and the last three year average was used to calculate my applicable pay. Details such as whether that is just base pay or includes bonuses, overtime, etc. are important to understand. Some pension plans are inflation adjusted, not too many. Mine was not, but I also had a “cash” settlement option which I took. That decision mostly depends on how comfortable you are handling a bucket of money; can you say “stocks?”

The above two streams of income, Social Security and a pension, are very solid and thus the ideal position to be in is one in which these two dependable streams of income pay for all your must expenses. The next two income streams we will discuss, rental income and withdrawals from you IRA’s /401 K’s (tax deferred accounts) are subject to market variation and your skill as a landlord or investor. When these two income streams are needed only for “discretionary” expenses, they can become a “playcheck;” two playchecks actually. That is a really great position to be in; takes all of the pressure off rental issues like vacancies and repairs, and stock issues like dips, pullbacks, and bear markets. I was not in that enviable position as I took a cash settlement on my “pension” and retired 7 years before I could draw Social Security. So I had to really figure out how to live off the two variable streams of IRA withdrawals and rental income. I learned a lot; still learning, and I will share all that with you.

So, the next step is to add these two dependable streams of income, SS and a pension or annuity, together and then subtract just your must expenses to see what position you are in. Do you need the variable and “tricky” streams from your rentals and stock portfolio to cover must expenses, or can you take care of these must expenses just from pensions and Social Security checks?

TAX DEFERRED AND POST TAX ACCOUNT WITHDRAWALS

Tax deferred accounts come in two major types; traditional IRA’s and Roth varieties. At this point in time, withdrawal time, there is a major difference in that the Roth money is tax free whereas the IRA money is taxed as ordinary income. Note, however, that you paid taxes on the Roth upfront; Roths are not tax free by any means. With either, what should your asset allocation be? Should you self-manage with index funds or pay an AUM (assets under management) fee to someone?

  • The financial planning industry heavily subscribes to some work done back in 1994 by William T. Bengen that concluded that because of the variability of the stock market, one should only withdraw 4 – 5 % of the balance in the first year of retirement (remember, generally taken as 65) as opposed to a higher number, even though the market averages ten to eleven per cent per year. That 4-5 % dollar amount can be adjusted upwards by about 3% per year to keep the purchasing power the same (inflation), and the money has at least a 90% chance of lasting for 30 years. With all due respect to the planning industry and Mr Bengen, I have a real problem with the low 4.5 % or so withdrawal rate. I talk about 8 or 9 reasons why in the course, but I will only mention a couple here. First, if one does not inflate the withdrawal by 3%, the money will last forever; even 2% is fine. Second, historical calculations have shown that, while it is not impossible, no one would have actually run out of money with the 4- 5% withdrawal rate inflated at 3 % in the history of the stock market. Retiring in the late 1960’s comes the closest, not because of stock market performance but because of the rampant inflation of the 1970’s.  Third, just rebalancing your portfolio once a year eliminates the “running out of money risk”; I will give out a great article / study on this. Fourth, remember both your rental income and your Social Security are inflated, so even if your withdrawals lose purchasing power, which they won’t as noted if you have a good income and / or a lot of discretionary items, you will most likely be fine. Fifth, the IRA withdrawal was calculated taking your rental income into account, but not the “bucket of money” power from appreciation and the mortgage pay off from your rentals.
  • The post tax Roth balance can provide the same spending power with a lower withdrawal because no taxes are due on the withdrawals. Problem is your Roth will have a lower balance for a given saving rate as the taxes were paid up front so it had less money to grow; this will be detailed in the course. My suggestion is to withdraw from a Roth if you think you are in a relatively high tax bracket year, and from a traditional IRA if you think you are in a relatively low tax bracket year.  Vice versa for funding; fund the Roth in a low marginal tax year and the traditional in a high marginal tax year.  Or, simply fund some of each type.

RENTAL INCOME; LAST BUT NOT LEAST

  • Most of us are “turnover avoiders.” For good reason as a turnover often means one or more lost month’s rent, and some reconditioning money. Then there is also the risk of the new tenant, in spite of your careful screening. For that reason, we are reluctant to raise rents as we should be, because it could cause a turnover. Fortunately, when we have a mortgage, the simple math of having a fixed P+I payment gives us leverage, such that a rent increase of x% typically will result in an income increase of about 2 times the x%, even with operating expenses increasing by the same percentage as the rental increase.  If you have a significant amount of rental income, that doubling of your rental income from a rent increase can make a heck of a difference in your rental income projected out over 10, 15, or even 20 years. Note when the property is free and clear, the leverage is gone and one will get the same percentage increase in income as the rent increase, assuming operating expenses are going up as well.
  • So the process now consists of subtracting any must expenses that were not handled by your SS and pensions and all of your targeted discretionary spending, from the remaining two income streams of IRA withdrawals and rental income. I suggest you subtract from a conservative net rental income first and then see what kind of percent withdrawal you need from your savings to pay all the rest of your expenses. The withdrawal should be less than whatever guideline we decided to use, which of course is highly dependent on the age you are quitting your day job. In that case, you have attained FIRE.  If there is a lot left over for your desired discretionary expenses, congratulations, maybe even go back and add a few more discretionary expenses. If all four income streams are short of paying all your must and discretionary expenses, you will have to rethink your income streams (work longer, buy more property, etc.), get a part time job, or rethink your spending.
  • Here is where your rentals get really interesting. The above counts only your monthly rental income, but your rentals have much more to offer. Treat each rental as a bucket of money based on the equity you have in it, not your initial investment. We will discuss “WAC” (walk away cash) and “TAAR” (total anticipated annual return) in class. To get this bucket of money, you can refi one or more rentals, sell one or more, maybe even take out a HELOC on one (not currently available), and use the cash to pay down one or more mortgages, effectively increasing your income. Actually, it decreases your expenses so the tax effect is much less. Or, you can just spend the bucket of money over your go go phase to enhance your retirement, or use it to delay starting your SS withdrawals. I call this whole area “financial engineering” and we discuss it at length in the course.
  • Exit strategies: the advantage of “hold until you fold” is that the property is stepped up to fair market value at your passing or 6 months later, thus avoiding both depreciation recapture and capital gains for your heirs. That requires you to be a landlord until you are 96, LOL. So we will talk about other exit strategies including keeping and hiring a property manager, selling the most PITA (pain in the axx) properties, selling with owner financing, 1031 exchanging into “simpler” properties, etc.
  • If you want to stay in the RE game, you can switch to private money lending, buying tax liens, discounted mortgages, do wholesaling, an occasional flip, become a broker, or volunteer at GaREIA.
  • If you are bored, you of course can find a suitable part time job.

I have developed a spreadsheet which tries to allow for many of these items; I don’t see any other way of planning a 20 ,30, or even 40 year “retirement” (no day job) without carefully thinking about each of these items; many of which are summarized below. I suggest we both work to develop your spreadsheet, a lot of which can be done via email.  The more effort you put into it, the more I will too.

SUMMARY OF ITEMS TO PLAN CORRECTLY

EXPENSES:  must expenses versus mutually agreed on discretionary expenses, how will we fill our time; when does my mortgage disappear, should we downsize, what kind of medical insurance do I have/need, what tax bracket are we in / going to be in, what about the parents, kids, even grandkids? Do I / we have adequate inflation protection?

INCOME: four pillars; two are more dependable and hands off: Social Security and pensions. Two are more variable and less passive: withdrawals from savings, including IRA’s, 401K’s, and after tax; and rental income.  What kind of overall financial shape are we in after age 81 (when do we take SS?), how does my pension work, what withdrawal rate is safe for us, how can I optimize the income from my rentals (financial engineering)… when do the mortgages drop off; should I domino them? Should I exit RE; how and when?

AGE FACTORS: pension can be taken at age X, medical coverage requires Y years of working, can withdraw from my 401K if retired at age 55 with no penalty, otherwise age 59.5 or Rule 72T / SEEP (substantially equal periodic payments);  SS can be taken from 62 – 70; Medicare kicks in at age 65; RMD (required minimum distribution) kicks in at age 70.5

BOTTOM LINE IS THAT THE OPTIONS FOR PASSIVE INCOME ARE ALMOST UNLIMITED AND VERY INDIVIDUAL. WHAT WORKS FOR ONE PERSON MAY NOT BE APPEALING TO A SECOND, OR MAY NOT EVEN BE AN OPTION. THEREFORE, I LOOK FORWARD TO WORKING WITH YOU AND YOUR SPOUSE “ONE ON ONE” AND TRYING TO SORT OUT YOUR REAL ESTATE, PENSION, STOCK PORTFOLIO, BUDGET, TIME AND GOALS FOR THE POST DAY JOB TIME.

Read more about Steve Laube and the GaREIA Mastering Passive Income Coaching Program which begins April 13 here

Leave a Comment

Your email address will not be published.