There are plenty of spreadsheets available for calculating how long it will take to recoup the cost of a refinance.
However, I’m unaware of any spreadsheets that allow you to compare the returns you’re earning on a property to refinancing that property and using the proceeds to invest in something else—including another property…
…until today.
This advanced spreadsheet enables you to model refinancing your rental property (or properties) and using the refi proceeds to buy another rental property (or properties) or make other non-real estate investments.
With this tool, you can model:
Any Number of Properties You’re Refinancing – Combine them into the fields provided.
Any Amount of Reserves – Set it to 6 months, 12 months, etc.
Any Return You’re Earning on Reserves – Specify returns of 0%, 1%, 8%, etc.
Any Number of Replacement Properties – Enter zero, one, or more; just combine them into the fields provided.
Add Funds from Other Investments – Combine outside investments with your cash-out refi proceeds to buy replacement properties.
Include Refinance Costs – Account for costs, including options to buy down the interest rate.
Model Excess Cash – If there’s cash left over after buying properties, see how this impacts your return.
Compare Refi vs. Sale – Use this spreadsheet alongside our Should I Sell My Rental Property? spreadsheet (separate download) to analyze whether refinancing or selling is better for you.
Let me know if you’d like a class on how to use this.
License
This spreadsheet—and all the others on this website unless explicitly stated otherwise—is provided to current, active subscribers under the very limited Don’t Steal My Stuff license. Basically, you can use it for your own personal use only.
Spreadsheet Download
Download the latest version of the Should I Refinance My Rental Property? spreadsheet below.
Keep reading with a 7-day free trial
Subscribe to Real Estate Financial Planner™ to keep reading this post and get 7 days of free access to the full post archives.