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…