Analyzing 3 deals a day

[Akhil Kumar]

Hello,

I watched Brandon's webinar on Wed. The one takeaway for me is to analyze 3 deals a day and see if the properties on sale will cash flow. Being a poor newbie, I built a spreadhsheet myself with inputs and assumptions. I wanted to validate my analysis with experienced investors here. The assumptions are listed below. The green cells are inputs I entered manually using info from Zillow. 

At the asking price ($229,000), it's a terrible deal. So, I did a Goal Seek to get CCR to 15% by changing Purchase price and that value is $132,802.05.

Wanted experienced eyes to see if I missed something. Thanks !!!

Here are some questions I have:

1. Is closing cost of 1.5% of purchase price reasonable ?

2. I used Capex of 5%. Is that a sliding scale based on age of property ? Any guidelines on upper and lower limits based on age ?

3. Zillow reports Homeowner's Insurance and Mortgage Insurance. Which is the right one to use for analysis ?

Thanks a lot !