Excel Analysis - I can't seem to find the right numbers

[Evan Smeenge]

Hi all!

I've created an excel document that basically takes BiggerPockets four quadrant analysis and puts it in an excel spread sheet. However, I need to figure out what is wrong with it. Yes, I could use the BP calculators, but I wanted to try to create something on my own. Perhaps I have it all wrong, and thus I will see how awesome the BP calc actually is.

I live in Chicago and am trying to find properties that match the rents. 2bd, 1200-1400 avg. 3bd 1600 - 1900 avg.

It just isn't adding up. Obviously, there are a few expenses that may be taken out (let me know if those are completely wrong), but for the most part, I am just baffled by how anyone accomplishes cash positive flow with an FHA loan.

Thanks for any help you all can give!

Look forward to your obliteration of my spreadsheet

E