Excel Practice NJ Deal Analysis

[Thomas Daly]

Hello - I am still about a year away from having enough capital to purchase my first investment property. Until then, I have been reading as much as I can on this site. I still do not feel I am to the point where I can quickly look at a deal on the MLS and at least be able to have an indication of whether it makes sense to look at it further for more intense number crunching. To practice I have been perusing zillow/trulia/njmls and then crunching the numbers in the below excel file I found on BP. For example, I just ran the numbers on the below property. Are the cost assumptions I am making fairly accurate? Or am I doing something that is very obviously wrong. I believe I am screwing something up as most deals I analyze seem to produce OK returns which I know is not the norm for North NJ.

https://www.trulia.com/p/nj/newark/39-fillmore-st-...

*to clarify again, I am not looking to purchase this property, just using as an example for "analysis practice"

[Mark Benevento]

Hey Thomas,

I would make the interest rate around 6% and always over estimate costs to be conservative. I would also see if the property cash flows with 0 money down to be conservative as well. I usually do 4-5 year pro forma's with 2-3% rent increases each year. This will show you the opportunity for growth available in the next few years.

I purchase a triplex in early 2017 and it was bringing in 3k a month. With about 10k in improvements and 2 years later of rent raises, the property brings in around $3,700 a month. Let me know how this works out for you!