The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Retirement Investing

URL:  https://boards.fool.com/here-is-a-spreadsheet-from-quotengineering-your-34319869.aspx

Subject:  Re: Emergency Fund Illusion in Retirement Date:  10/15/2019  1:22 PM
Author:  NessieTheBruce Number:  95579 of 99864

Here is a spreadsheet from "Engineering Your Retirement", chapter 3 to help deal with non-periodic expenses in your budget. The numbers in the sheet are at least 15 years old and are not meant to represent any particular retiree, but you can build your own version of the sheet and put your own estimates in:

CAPTIAL ITEM.....COST....LIFESPAN (YEARS)......ANNUALIZED COST
Car.....................$24,000......5.......................$4,800
Water heater............$250........13.......................$19
Furnace.................$2,000......20.......................$100
Air cond................$4,000......15.......................$267
Housepaint..............$100........10.......................$10
Refrigerator............$600........17.......................$35
Freezer.................$240........20.......................$12
Dishwasher..............$350........10.......................$35
Range...................$400........12.......................$33
Microwave...............$175.........6.......................$29
Washer/dryer............$750........15.......................$50
Car tires...............$600........2.5......................$240
Computers...............$600.........5.......................$120
Printer.................$130........10.......................$13
Television..............$300.........8.......................$38
Stereo..................$500........15.......................$33
Living rm set...........$4,000......15.......................$267
Bedroom set.............$1,700......15.......................$113
Dining rm set...........$1,000......10.......................$100
Patio furn..............$400.........7.......................$57
Gas grill...............$500.........7.......................$71
Exercise equp...........$425........10.......................$43
Vacuum Cleaner..........$115........17.......................$7
Steam Cleaner...........$650........10.......................$65
Major House maint......$7,500.......14.......................$536
TOTAL........................................................$7,093

I have produced this list in the past only to have the discussion turn immediately to debates about costs/lifespans etc. for individual items. This list and these costs/lifespans are not intended to represent any particular person's needs. Many of the items won't apply to everyone. Any particular individual may have other non-periodic expenses that need to be added. The costs/lifespan of most items will vary depending your specific use. For example, car tires wear based primarily on mileage. If you drive a vehicle that requires expensive tires and you drive a lot of miles, this figure is going to be much higher than for someone who drives a small car a few miles per week. And the same line is $0 if you don't own a car. So you still need to go through the list and apply your own lifestyle specifics.

But this is one way to address these kinds of expenses that will not be captured by keeping track of your exact spending for a month, or even a few years. Track your normal spending then do your best effort to build the non-periodic expenses char and add that bottom line to your annual budget. Notice that this method assumes that inflation of these items is roughly the same as all your other budget items, so if you want to use this method combined with the 4% rule, you need to make sure the costs listed are estimates for that item in the year you retire.
Copyright 1996-2020 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us