Quote from @Sam Booth:
Thanks everyone for replies!
It sounds like I am over thinking it possibly but what I will do is just use a spreadsheet with Capex items on it, year it needs to be done and then maybe account for 3% inflation a year to get a relatively close cost of cap ex items.
Appreciate the input!
Stop using guesstimates.
You have the start of a cap-x schedule but that's it, a start.
You list out all components. Than have a line for rated life expectancy. Next, current age. Next, todays cost of replacement. Next, annual inflation rate.
I like to have inflation rate on a line item but it's auto filled from top of sheet where I input my annual inflation rate. Reason being, I like to manually adjust a few things, items where i see more or less LT inflation.
Now, all the auto calculations.
This should kick out a total for the field of expected end of life date, and replacement dollar at end of life.
Now, you can simply reverse engineer that #, or better yet have auto-calc that does that. Takes that expected of of life replacement total, and divides it by the time left. Because different things have different dates.
Now you get an actual accurate allocation for cap-x.
AND to boot, you have a schedule of what-when. So say something goes out, a water heater, you can look it up and see it's gone out 2yrs early. maybe look into that, see if have a reason why. Maybe find out you didn't replace cathodes, and the water is harder there. So now you know it may be worth it to consider a better grade cathode, or water filter/ treatment.
Maintenance and cap-x does not, in large part, have to be a mystery game of wait n see what happens. Most of it CAN be put on a schedule, weighed and measured, so mathematical decisions can be made.
Now, does it take time to make this excel program, dang right. But, once it's made it's made, and your going to get repetitive use out of it, use that will help identify when something that shouldn't happen happened, or when things went better than planned.
Wouldn't you like to know what brand and model of washer lasted 1.5x it's rated life span? I would, that's a unit I'd want again. Or, if it went to hell in half it's rated lifespan just because it was junk and not worth the $.
This will also help in doing better informed buy's. Heck, I run it and print it out for a seller and include it with my PA as justification to my #'s that I am not just low-balling em but here is the facts, I'm gonna have this n that price coming up.
STOP guesstimating cap-x, put in the few hours to KNOW vs guesstimate. Best few hours spent.