Rental Property Calculator
The Rental Property Calculator is an easy Excel spreadsheet calculator that can quickly determine the expected returns on a potential rental property purchase. Or, you can use it to calculate what you are currently earning on a property you already own. You simply input a few numbers (such as purchase price, rental income, financing costs, and monthly expenses) and you will quickly be able to see the anticipated Cap Rate and Cash-on-Cash Return for the property. Use this calculator and take the complex work out of evaluating your return on investment!
What is the return
on your rental property?
Use this rental property calculator to quickly sort good deals from bad deals!
This calculator was developed by an actual rental property investor based on calculations taught by Hipster. This calculator has been used to evaluate hundreds of rental properties!
Disclaimer: Just because the numbers look good on an investment property does not mean the property is a good investment.
What do you need to know about calculating ROI?
What is ROI?
ROI = Return on Investment. People calculate this in different ways and using different variables. Always ask someone what they used to determine their ROI on a property. For rental properties, you want to know your cash flow. Always use actual numbers in your calculations, don’t just guess the numbers or wing them. Only use estimates in your equation when absolutely necessary (which isn’t often). Allow room for errors (be conservative). Never include things like assumed appreciation, tax benefits, or bogus other unknown numbers that you can’t really know for sure.
When should you calculate ROI?
Anytime you want, but definitely before you buy an investment property! In fact, don’t just calculate it once, calculate it multiple times to ensure there are no mistakes. Initially you can calculate it just to give you an idea as to whether or not you should pursue a particular property, but once you decide on a property, spend more time really digging into the numbers and ensuring you are being as accurate as possible in your calculations.
What ROI should you expect for any property?
There is no right answer to this question except, “a positive one”. In general, your return should in fact be positive but it should also be positive enough so there is room for error. Don’t settle for a positive cash flow of $50/month because that doesn’t leave any room for any unforeseen circumstances (of which there usually are in real estate). Different markets and different property types will warrant different ROIs. You are best to understand the full picture of what you are buying in order to determine if the ROI is a good one or not.
