The Fifteen Year Plan

When I decided I wanted to retire by the time I was 55, I knew I would need a plan. And who doesn't love a good spreadsheet?

It turned out that with the New Zealand average inflation rate, and other challenges, retiring at 55 was going to be tricky. So I caved a year and went to 56.

Below is the result of all my planning. I've gone into some more detail below the figures.

ABCDEFGHIJKM
1
Inflation4.68%
2
Income Increase6.00%
3
Savings Rate Annualised
7.00%
4
Post Retirement Income
in today's money
20000
5
6
Year (from
1st August)
SpendingMortgageExtrasTotalIncomeSavings
% Savings Rate
Total SavingsAge
7
201850,000.0026,000.0010,000.0086,000.0096,000.009,800.0010.2110,500.0041
8
201950,000.0026,000.0076,000.0096,000.0020,000.0020.8331,235.0042
9
202052,340.0026,000.0078,340.0096,000.0017,660.0018.4051,081.4543
10
202154,789.5126,000.0080,789.51101,760.0020,970.4920.6175,627.6444
11
202257,353.6626,000.0083,353.66107,865.6024,511.9422.72105,433.5145
12
202360,037.8126,000.0086,037.81114,337.5428,299.7224.75141,113.5846
13
202462,847.5826,000.0013,000.00101,847.58121,197.7919,350.2115.97170,341.7447
14
202565,788.8526,000.0091,788.85128,469.6636,680.8128.55218,946.4748
15
202668,867.7726,000.0094,867.77136,177.8341,310.0730.34275,582.7949
16
202772,090.7826,000.0098,090.78144,348.5046,257.7332.05341,131.3150
17
202875,464.6326,000.00101,464.63153,009.4251,544.7933.69416,555.2951
18
202978,996.3726,000.00104,996.37162,189.9857,193.6135.26502,907.7752
19
203082,693.4017,300.0099,993.40171,921.3871,927.9841.84610,039.2953
20
203186,563.4586,563.45182,236.6695,673.2152.50748,415.2554
21
203290,614.6290,614.62193,170.86102,556.2453.09903,360.5555
22
203394,855.3994,855.39204,761.11109,905.7353.681,076,501.5256
23
STOP WORKING
24
203499,294.6299,294.6241,576.641,084,209.1957
25
2035103,941.61103,941.6143,522.431,089,290.4958
26
2036108,806.0722,800.00131,606.0745,559.281,060,896.4359
27
2037113,898.20113,898.2047,691.451,057,562.6160
28
2038119,228.63119,228.6349,923.411,053,931.0961
29
2039124,808.53124,808.5352,259.831,042,676.7162
30
2040130,649.57130,649.5754,705.591,038,697.3363
31
2041136,763.97136,763.9757,265.811,018,231.5864
32
2042143,164.5330,000.00173,164.5375,945.85300,000.00996,871.0165
Super and Kiwi saver
33
2043149,864.63149,864.6379,500.12981,301.0166
34
2044156,878.29156,878.2983,220.72977,306.5867
35
2045164,220.20164,220.2087,115.45952,191.2868
36
2046171,905.70171,905.7091,192.46947,814.2369
37
2047179,950.89179,950.8995,460.26911,675.5170
38
2048188,372.5940,000.00228,372.5999,927.80862,879.1871
39
2049197,188.43197,188.43104,604.42810,977.8772
40
2050206,416.85206,416.85109,499.91805,722.1073
41
2051216,077.15216,077.15114,624.51739,062.2874
42
2052226,189.56226,189.56119,988.93733,303.0675
43
2053236,775.24236,775.24125,604.42649,785.9376
44
2054247,856.32247,856.32131,482.70643,475.0377
45
2055259,455.99259,455.99137,636.09540,752.7878
46
2056271,598.53271,598.53144,077.46533,837.3579
47
2057284,309.35284,309.35150,820.29409,285.9780
48
2058297,615.02297,615.02157,878.68401,708.1281
49
2059311,543.41311,543.41165,267.40252,397.3482
50
2060326,123.64326,123.64173,001.91244,093.6083
51
2061341,386.22341,386.22181,098.4066,753.7184
52
2062357,363.10357,363.10189,573.8157,654.5585

Need Some Explanation?

Apart from the next two or three years, where I know my situation fairly accurately, I’ve been working on basic percent multipliers for things like income increase and cost of living increase (inflation). The income increase is fairly aggressive, and will be need to be supported by Side Hustles - the ability to bring in additional revenue outside of your day job. I’ve got some thoughts on this that I’ll get down in this blog before long.

The New Zealand inflation has averaged 4.68% over the last 75 years, which is fairly high for a ‘western’ nation. It’s currently less than 2%, but for the sake of these calculations I’ve assumed the average. If it averages out at 3%, the situation looks a lot better.

Income shown is after tax. Though the tax situation gets tricky to calculate after retirement. The expectation baked into this is that at some point the tax bands will move around to take into account inflation increases, otherwise before long minimum wage earners are paying out at 33%.

The American stock market has realised 7% annualised returns over the last 75 years, with some bad years and some great years - last year returned 22% for instance. Over this time frame though, we care about averages.

There is an expectation that post retirement income will not drop away to zero. I’ll still want to be doing something, and worst case, we’ll just AirBnB - or whatever the equivalent is in fifteen years - the house periodically. It is also very likely that a portion of our net worth will be in property, and with luck that will also be returning some rental income in addition to property appreciation.

That’s the assumptions, let’s dig into the where it’s wrong in my favour, and against it.

Where things might go even better

  • Inflation is currently no where near 4.68% and given how economies are more tied together these days, there’s an argument to be made it won’t go back up that high very often. The increase in cost of living is the real killer in this model, so anything that can happen to keep that low really works in my favour.
  • I’ve amortised the cost of housing maintenance at $10k a year - which is not overkill, replacing parts of your house is a fairly predictable affair and predictably expensive. However, if we can push the big work until after the mortgage is paid off then we can pay the amortising amount into savings in the meantime. Early additional payments into the savings have a huge advantage because of the additional time they have to compound.
  • I’ve assumed in 2042 when my wife and I receive pension payments, it will still be around $16k a year. This seems unlikely - it will be either be significantly more, or nothing. My bet is on the side of significantly more, but for now, we’ll stick with a mid-ground in the calculations.
  • Will I really stop work at 56? Knowing me, it does seem unlikely. This plan is around giving us options, but in likelihood all that may happen is that I’ll go down to a three or four day week.

Where we’ve got risk

  • Between 2018 and 2067 a hell of a lot will change. Tax, income, savings rates - I’m treating them like predictable entities in this spreadsheet but in 20 years we could all have 60% tax brackets and Universal Basic Income. There is no certainty here. All I know is, that if we've got money in various diversified investments, we’ll be well placed to weather any financial storms. And if I have to work another five years, then that certainly isn’t the worst outcome in the world.
  • I might live beyond 85 ;-) The current plan has me going into debt at this point. Given the huge uncertainty though over the next 40 years, I'm pretty confident I can find a way to to address this before I run out of time.
  • We could have misjudged how much we’ll spend. Certainly it is likely at some point I’ll have to spend $10k plus on flights to and from the UK to visit my parents as they continue their march towards the bottom of their own spreadsheet of life.
  • We’ve assumed we’ll pay off our mortgage and not buy another house. The truth is that may not be the case. I’ve mitigated that to some extend by having eleven years of mortgage accounted for and being fairly sure we can clear it in six. The extra five year represents a move to somewhere a little bigger or nicer.
  • Assuming a steady pay increase of 6% could be challenging. I’m fairly happy with the predictions over the next five years as my wife will go back to work soon and I’m hopeful of my own pay increases, but after that it becomes a touch more hopeful. Once again, I’m expecting we’ll need to generate revenue sources that aren’t our day jobs to achieve this.

FI, or Not FI?

In a way, this is not true FI. The money making machine does not keep churning out money faster than I can spend it. To get there, I’d need in excess of $3 million. The state of the New Zealand figures just mean that the American-based rubric of “25 times your annual expenditure” does not hold true here. In fact, there are a number of factors that make this operation more difficult in New Zealand that I’ll cover in a different post.

While there are undoubtedly uncertainties in this plan, and I can’t conceive of me making it through to 56 with all these predictions still valid, I do think we’re setting ourselves up for success in the best way we can right now. Either old age is coming, or I die young. In the former I want to be able to enjoy my time, and in the latter scenario I want money for my surviving family to support themselves. I hope this plan strikes the right balance between discipline, practicality and freedom.