Rental Calculator and Total profit if Sold

2 Replies

So I'm working on using the rental property calculator for the first time. In my theoretical world, I'd pay cash for this rental property and assumed that the county assessor would assess the property value below the expenses I may have to fork into it. 

In the analysis over time, it calculates out the total profit if sold over 30 years but I'm having trouble arriving at these numbers myself. Can someone walk me through what I'm doing work? 

I've read elsewhere on this forum that the total profit sold = (After Repairs Value - (1-Sales Expense Percentage)) - Total Cash Needed - Loan Balance + Cash Flow. 

In my theoretical scenario, the formula would look as follows: ($176,750- (1-8%)) - $180500 - $0 + $14004 = $-3,886. Which is correct but my trouble is what happens when you drag that out over time. For instance the second year would be: (178,517.50-(1-8%)) -$180,500 -$0 + $14144= $-2119.9 if I follow the same formula as up above. However, the calculator shows that the total profit if sold for year 2 = $11884.14. 

@Derek Gruening

You need to account for the cashflow produced by the property  for the entire time you owned it (so year 1 and year 2

(178,517.50*(1-8%)) -$180,500 -$0 + ($14004 + $14144.04)= $11884.14

Sorry, but the “total income over 30 years” is a goofy way to look at any investment. Also, you didn’t include any sales price.

Better idea: take your total initial investment, and Net cash flow each year (after taxes, Ins, repairs, capex , etc).

Net cash flow divided by all in purchase price = Capitalization Rate, expressed as a percentage.

Free eBook from BiggerPockets!

Ultimate Beginner's Guide Book Cover

Join BiggerPockets and get The Ultimate Beginner's Guide to Real Estate Investing for FREE - read by more than 100,000 people - AND get exclusive real estate investing tips, tricks and techniques delivered straight to your inbox twice weekly!

  • Actionable advice for getting started,
  • Discover the 10 Most Lucrative Real Estate Niches,
  • Learn how to get started with or without money,
  • Explore Real-Life Strategies for Building Wealth,
  • And a LOT more.

Lock We hate spam just as much as you

Join the Largest Real Estate Investing Community

Basic membership is free, forever.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.