Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Multi-Family and Apartment Investing
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
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

User Stats

161
Posts
62
Votes
Charles McCabe
  • Investor
  • Lansdowne, PA
62
Votes |
161
Posts

Sharing a CapEx projection spreadsheet I just put together.

Charles McCabe
  • Investor
  • Lansdowne, PA
Posted

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

User Stats

103
Posts
28
Votes
Cale Ferguson
  • Investor
  • Lexington, SC
28
Votes |
103
Posts
Cale Ferguson
  • Investor
  • Lexington, SC
Replied

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

Loading replies...