General Real Estate Investing
Market News & Data
General Info
Real Estate Strategies
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/hospitable-deef083b895516ce26951b0ca48cf8f170861d742d4a4cb6cf5d19396b5eaac6.png)
Landlording & Rental Properties
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/hemlane-a9392011949df124ea8ee63be2fb270c9423d6cd446ec67af23c96616e618606.png)
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback
![Derek Gruening's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/977799/1694877959-avatar-derekg51.jpg?twic=v1/output=image/cover=128x128&v=2)
Rental Calculator and Total profit if Sold
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.
![Patrice Penda's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/633523/1694556506-avatar-pat_rice.jpg?twic=v1/output=image/cover=128x128&v=2)
@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
![Wayne Brooks's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/111917/1694551804-avatar-waynebrealtor.jpg?twic=v1/output=image/cover=128x128&v=2)
- Real Estate Professional
- West Palm Beach, FL
- 13,501
- Votes |
- 23,416
- Posts
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.
![BiggerPockets logo](https://bpimg.biggerpockets.com/no_overlay/uploads/forum_ads/logo/702/1656002841-forum-ad-logo.jpg?twic=v1/output=image/contain=96x96)