Sharing a CapEx projection spreadsheet I just put together.

[Charles McCabe]

While I've heard people discuss projecting the cost of replacing certain systems over time for rental properties, I haven't so far seen an actual calculator for that purpose.  Here's one I just put together in Google Sheets:  https://drive.google.com/open?id=1XfrOEQ1Olcl-DiP-...

By and large, I think it will be self explanatory, but I'll stop to explain the formula driving all the columns on the right.  Each column is a year in the life of the property, starting from your purchase, and each cell is calculated thusly:

"if the years remaining in the system's life are less than the years we've owned it, then divide the replacement cost by the years remaining in the system's life; otherwise, divide the replacement cost by the total life expectancy"

That way we project worst-case-scenario of having to deduct the entire replacement cost of, say, a roof with only 5 years left in it from the cash flow over those 5 years.  And after that, we deduct only the best-case scenario of the system surviving its full life expectancy.

I welcome all criticism, improvements, and general harassment.

Thanks,

Chaz