Would love some input on my analysis spreadsheet :)

[Mark A.]

Hello BP! So I've been using the rental property calculator on the site to double check potential deals but I found that on the go without internet access it has been much easier to develop a spreadsheet to quickly crunch numbers. I wanted to share this spreadsheet with you in the hopes that you might be able to give me some input or maybe correct any misconceptions/miscalculations that may exist. Thanks in advance!

Some assumptions made on the spreadsheet: property tax is 1.5% of property value, PMI is .5% of property value (I usually leave it in my calculations even if the down payment is 20%, additional conservative safety cushion :P), Agent commission 3%, vacancy 7%, capex 7%. Also this spreadsheet did not include property management but I have since included this at 7% as well.

The property is a two building fourplex: (2) one bedroom/one bathroom and (2) studio/one bathroom, each unit has a one car parking garage. The lot sits less than half a mile to downtown Riverside and a block away from a large park and the community hospital. 

PS I did not offer on this property and it is already under contract