The Innovative CPA Group has built a library of FREE Excel tools and calculators for you to use, including a rental property valuation calculator! These comprehensive tools are a great resource to keep you organized when evaluating your finances.
The rental property valuation calculator is great for residential property investors who are looking to value a prospective investment. Input all the known information about a property to calculate Loan Assumptions, CAP Rate, Net Operating Income, Net Property Cash Flow, and Annual Return on Equity. Also, view the property’s vacancy rate and unit mix.
How to use our Rental Property Valuation Calculator:
1. Enter the name and address of your property in the header of the Summary Sheet.
2. Enter all the known information about the property, its units, closing expenses, any rehab costs, and any loan assumption numbers onto the Summary sheet.
**Note only cells highlighted in gold need to be filled in. All other numbers will auto generate.
A loan total and CAP Rate will be calculated and charts will update to show the unit mix and vacancy rate.
3. On the Cash Flow sheet, fill in all percentages and operating expenses to get a Net Operating Income, Property Cash Flow, and Annual Return on Equity Rate.
**Note only cells highlighted in gold need to be filled in. All other numbers will auto generate.
Use the numbers and rates generated to make your assumptions on a property’s value.
You can find this Excel tool and many other free downloadable templates in our Excel Tool Library, under the Resources tab on our website.
Disclaimer
Any articles, templates, spreadsheets, calculators or information provided on the Innovative CPA Group website are for reference only. While we strive to keep the information up to date and correct, we make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability, or availability with respect to the website or the information, articles, templates, spreadsheets, calculators, or related graphics contained on the website. Any reliance you place on such information is therefore strictly at your own risk.
Contact Us
If you have any questions regarding this tool, Real Estate Accounting, or for a detailed discussion, please reach out to your accountant or contact us at 203-489-0612 or fill out our contact form.
Share This Story, Choose Your Platform!
Check Out Our Other Excel Tools!
Contact Us
Whether you know exactly what accounting service you need or have a tough question, The Innovative CPA Group team is here and ready to help. Let’s collaborate to accomplish your personal or business goals.