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

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

Real Estate Broker · Chicago, IL · Member since 2016 · 56 posts · 23 votes

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

2Reply
115 views

Most Popular Reply

Dan WeberBusiness Member
Realtor · Portland, ME · Member since 2015 · 656 posts · 552 votes
7y

@Evan Smeenge Just keep in mind that once you have numbers that you are comfortable with, if the numbers don't seem to work then don't force it. I feel like many investors can struggle with this sometimes. We want a deal to work so we try and tinker with the numbers until we like what we see. The numbers don't lie. Good luck!

See this reply in the discussion

25 Replies

Jump to latestLatest
    Join the conversationCreate a free account to reply, vote on answers and follow this thread.