Looking for the perfect rental property calculator or BRRRR investment analysis tool? You came to the right place.
Let’s all agree, reviewing rental properties is time-consuming and sometimes overwhelming. As a real estate investor, you will have to look at tens or hundreds of deals before finding the one that works for you. So you need to be able to quickly identify great opportunities and tailor your offer to get a shot against other seasoned investors.
Our online rental property calculator is all about that: running numbers for you so you can efficiently tell apart great deals from bad investments.
And if you’re looking for additional premium features, check out our Rental Property Analysis Spreadsheet. It includes full 30-year forecasts, a maximum purchase price estimate, scenario analysis, plenty of reports, and much more!
Using the calculator is really easy. Simply enter your assumptions in the blue cells and the calculator will do the rest for you!
The online rental property calculator is composed of 2 sections:
This is where you enter your assumptions regarding your rental property. It includes 5 categories:
Indicate your property purchase price and the estimated after-repair value (or ARV). You can also enter your financing assumptions in that section (down payment, interest rate, loan term, etc.)
Enter your acquisition costs, including refurbishment/repair costs, purchasing cost, holding costs and other costs
Indicate your holding period (i.e. how long you expect to hold the property). If you do not intend to sell the property, enter 30 (which is the maximum number of forecasted years run by the calculator)
Enter your monthly rent and the expected annual rent increase. If you have multiple units, simply add them up in that cell
Enter up to 7 different operating expenses. 3 can be entered as a monthly cost, 2 can be entered as an annual cost and the last 2 can be entered as a % of rent (i.e. variable costs)
This section does not require any input from you and will describe the result of the analysis performed by the rental calculator. It will provide useful financial data over your holding period as well as calculate key financial metrics (described below).
The uses and sources table will also help you quickly identify how your project costs are allocated and how they are financed.
Finally, summary projections are also provided (each year for the first 5 years, then years 10-15-20 and 30).
This free rental property calculator will estimate 6 financial metrics:
ARV Capitalization Rate
Calculated as Annual Net Operating Income / After-repair Value. This ratio is an estimation of an investor’s potential return on investment. It’s an important ratio but it has its shortcomings:
Similar to the previous ratio but calculated based on the Property purchase price rather than its After-Repair Value. It has the same shortcomings. More about the Capitalization Rate
Cash on Cash return (or Return on Investment)
Calculated as annual pre-tax cash flow (year 1) / Total Cash Invested. More about the cash on cash ratio
Internal Rate of Return
The IRR estimates the value a property generates during the time frame you own it. Effectively, the IRR is the % of interest you earn on each dollar invested in a property over the entire holding period. This ratio is a much more comprehensive ratio than Cap Rate and Cash on Cash return as it takes into account all aspects of the transaction over time (cash flow generation, leverage, property appreciation, time value of money, etc.). More about Internal Rate of Return
The 1% rule is a guideline frequently referenced by real estate investors when evaluating properties. This rule of thumb states that the monthly rent should be equal to or greater than 1% of the total purchase price of an investment property. In practice, you may find it very difficult to acquire properties fitting that criteria, especially in certain expensive local real estate markets.
Price to Rent
Calculated as (Purchase Price + Repair Costs) / Total Annual Income. The price-to-rent ratio is the ratio of a home price to annualized rent in a given location and is usually used as a benchmark for estimating whether it is cheaper to rent or own a property.
Absolutely, all of our calculators are completely free to use.
No, this calculator has been specifically built to analyze rental properties & buy and hold investments.
If you want to analyze and manage a house flipping project, please check out our free House Flipping & Rehab Spreadsheet
This online calculator cannot be downloaded as a spreadsheet. If you wish to have your own spreadsheet, check out our free Rental Property Analysis Spreadsheet
We have other Calculators & Spreadsheets
Free Rental Property Analysis Spreadsheet for reviewing rental properties and buy & hold investments like a pro
An all-in-one solution for analyzing house flipping deals, estimating rehab costs, tracking expenses, managing deadlines and more.
© 2021 RealEstateSpreadsheets.com – All rights reserved.