Multi-Family and Apartment Investing
Market News & Data
General Info
Real Estate Strategies

Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal


Real Estate Classifieds
Reviews & Feedback
Updated over 3 years ago on . Most recent reply

Sharing a CapEx projection spreadsheet I just put together.
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
Most Popular Reply

Nice contribution. I'll be coming back to this.