Rental Analysis Spreadsheet

For investors (and up-and-coming investors) looking for a good spreadsheet to analyze the potential returns on a rental property, here you go.

Like the Rehab Analysis Spreadsheet, this is one of the spreadsheets I use everyday in my business (also modified to remove a lot of the crap that’s specific to my projects).

For this spreadsheet, all the numbers in RED along the top and the left side (Column E) are the configurable inputs. Enter your actual parameters there, and the rest of the spreadsheet updates accordingly.

The important return values (Cash Flow, Cash-on-Cash Return and Total Return) are shown in YELLOW at the top in the “Cash Flow & ROI” box. If any of this spreadsheet doesn’t make sense, check out our tutorial on Introduction to Financial Analysis. It should give you all the background you need to understand the spreadsheet (assuming you have a basic understanding of Excel to begin with).

Btw, if you’re seeing garbage along Row 43, it’s because the spreadsheet uses the Excel function “CUMPRINC”. This requires a free Microsoft add-on called the Analysis Tookpak. If you don’t have that installed, you can download it for free here…

25 Responses to “Rental Analysis Spreadsheet”

Sweet, thanks, J! This really rocks. There is one suggestion I have – it would be cool to add rows for total equity (incl. assumed appreciation) and for ROE. That could be a good guide for when it may make sense to pull money out further down the road.

I actually have that — and a lot more — analysis fields in the spreadsheet I use personally. I don’t distribute the full spreadsheet because it has a lot of custom areas that others probably wouldn’t find useful or may find confusing, but I completely agree that these are things that people should add once they are comfortable with the basic analysis.

hi, just posted a comment under the “Introduction to Real Estate Investment Deal Analysis” post, but gave me a “No Data Transmitted after i hit submit. I dont know if it took, so here’s my comment again.

thanks so much. excel did not say anything like that, yet i spent time combing through the formula. I just used OpenOffice to open the file and without doing anything, the cell shows the answer perfectly.

Great Tool. I have a follow up question to this analysis. Do you have an analysis that takes into consideration the added complexity of taking a cash out after 1 year? For example, I bought a property using all cash for purchase and repairs. Once it has been rented for 1 yr I plan to get cash out from a local bank. I would like to factor this into a ROI. Do you know of any calculators?

Thanks J Scott.
What about if I don’t plan on selling the property? Basically, I’m trying to find a calculator that assumes I take out an 80/20 loan for the original purchase. Then Spend x $ on rehab. Then once the property is rehabbed and rented, do a refi on the property to get my down payment and rehab costs back. I will then continue to rent the property. I’d like to see a calculator to help determine what the cash flow would look like once the property is rented but also takes into account the new refi loan.
Great site by the way. I’ve spent a lot of time on it the last week.
Bart

Those are property management costs. Some PMs charge fixed fees for management and some charge variable fees based on the rental amount. Depending on which kind of PM you have (if at all) will determine which of those rows you might use.

Not sure which Rehab Analysis Spreadsheet you’re referring to (this page is the Rental Analysis Spreadsheet), but basically I have one spreadsheet that’s for doing an analysis of rentals (it gives info like cash flow, cash-on-cash return, etc…it’s the one on this page) and I have a spreadsheet for analyzing rehabs/flips (that one basically uses my “Flip Formula” approach to the analysis).

They are basically the same thing. They may have been uploaded a few months apart, so there may be minor differences, but to be honest, I don’t remember which one was newer. For the most part though, they are identical.

Those extra cells in the BP version are basically the way to see the difference in cash-flow and COC if I’m not paying a Property Manager to manage the property. The reason for this is PM costs are the one area where I can make a decision to spend or save a good bit of money on an on-going basis, so I like to see my best- and worst-case numbers based on how I decide to do PM for my units.

I believe everything else is the same, though I’m not sure why the file sizes seem weird…

J,
Thanks for the commentary. Difference in file sizes is small enough that it could be as simple as more formatting (Bold, Color, Borders) in the 123flip version.

Maybe time to upload a new version to 123flip & BP based on lessons learned since they were created? If you do update, maybe add an instructions tab or box at the top with the wording from this 123flip page.

“For this spreadsheet, all the numbers in RED along the top and the left side (Column E) are the configurable inputs. Enter your actual parameters there, and the rest of the spreadsheet updates accordingly.

The important return values (Cash Flow, Cash-on-Cash Return and Total Return) are shown in YELLOW at the top in the “Cash Flow & ROI” box. If any of this spreadsheet doesn’t make sense, check out our tutorial on Introduction to Financial Analysis. It should give you all the background you need to understand the spreadsheet (assuming you have a basic understanding of Excel to begin with).”

Leave a Reply

Sign up for our Newsletter and get immediate access to our FREE 150+ Page eBook on New Construction, plus all of our business tools: Single-Family and Multi-Family Business Plans, Rehabbing and Buy-and-Hold Spreadsheets, Contract Templates, and more!

Post Categories

Post Archives

Search

CHECK OUT OUR BOOKS

LIKE US ON FACEBOOK

GET FREE STUFF!

Sign up for our free newsletter and get immediate access to our FREE 150+ eBook on New Construction, our Single-Family and Multi-Family Business Plans, our Contract Templates, our Rehabbing and Buy-and-Hold Analysis Spreadsheets and a whole lot more FREE goodies: