Financial Evaluation of a Property "Doing the Numbers"

[Sam Bishop]

I'm very excited about diving into single-family to four-plex rentals. I'm saving up right now but am looking for undervalued properties that can be greatly improved with some repairs and TLC. I'm a project manager and have lots of experience with construction, trades, and scheduling. 

Since I've been saving up cash, I've been putting together a grand plan. I've read; Bigger Pockets: Rental Property Investing, Bigger Pockets: The Book on Investing in Real Estate With Little to No Money Down, and Bigger Pockets: The Book on Managing Rental Properties. I've been taking notes vigorously and plan to read them all again. 

The reason I'm posting is; I've put together a simple property analysis excel form to help me financially evaluate new properties quicker. I'm looking for input on this and am willing to share it if its worth anything to anyone. I've inputted data from a property I'm looking at right now as an example. I've tried to detail everything the best I could so it makes sense to an investor or mortgage broker. 

If you have some free time please check it out via my link below and feedback would be greatly appreciated. The form is interactive. I've designed it so that only the yellow spaces are to be filled out. If you fill in any other spaces it might mess up a formula. 

Thanks,

https://www.dropbox.com/s/avrckupzqp8xl85/Property...