Townhouse complex analysis Advice

[Account Closed]

I have an opportunity to purchase the MAJORITY of a townhouse complex in Fort Smith, Arkansas but still don't quite understand how to use the analysis calculator to determine if it's a good deal or not. There is space to build additional units and I went to school with the son-in-law of the man selling. Another classmate of mine is an investor and broker with over 140 units in the area. Here is a link to the info HERE Can someone please walk me through where to input the numbers in the calculator? It doesn't seem to have a pro forma with easy to calculate numbers but rather has been analyzed with a spreadsheet formula. I need to start analyzing a deal a day so that I can get to a point where I can see a good deal quickly. The first calculation is done with what the seller is asking and the second (at the lower price) is done with what my broker friend thinks it is really worth.