Rental Property Cash Flow & Return on Investment Spreadsheet

[Kelton Johnson]

Hi all, 

I know there are probably a MILLION of these out there right now, but I figure, why not throw mine out there too.  If it helps just one person, then I'm happy!  Just so it's clear, I'm relatively new to Real Estate investing, but I've taken some time to build this google sheet to analyze potential rental properties thus far.  I'd love to get as much feedback as possible, both positive and constructive, as well as, hopefully provide you guys with a great new tool for your future analysis. 

The first tab is where most of the core information is gathered and analyzed, starting with basic property info and then projected (or actual) rent prices per room.  The second section allows the user to break down the expenses (taxes, insurance, repairs, etc.).  Finally, the third section is where the financing is calculated and can quickly be manipulated for several different loan types.  With this information inputted, the rest of the sheet will calculate a number of different performance metrics, Cash flow, Cash-on-cash, etc. 

There is also a section to adjust for appreciation, along with several other tabs to take a look at several different 'Rule of Thumbs', DTI, & Amortization of a loan. These are all things I was interested in as I was going through and analyzing my own potential properties. I certainly made some assumptions along the way while building this, so feel free to let me know how accurate they are.

Thanks for everything you guys have done for me so far, hope this gives back in some small way!

Rental Property Spreadsheet