Analyzing properties and can't make sense of some numbers

[Lauren Akins]

Hey everyone! I am a rookie when it comes to real estate investing and Excel. I was thankful that someone was willing to share their spreadsheet with me via the Bigger Pockets Facebook group. I am currently looking at properties that meet my criteria and run the numbers on every one of them. I will be house hacking a duplex. 

So in the "Unit Breakdown" column, I put I will be paying $900 and they will pay $1000. Under the "Total Expenses" column, it says $976. Under "Cash Flow" it says $654. I am utterly confused trying to understand that with me paying myself rent at $900 plus expenses of $976 plus $867 mortgage, am I still coming out on top at $654 cash flow? Also, what is the NOI of $867.

I apologize if these may be stupid questions for some people; I'm truly just trying to learn and understand fully what all these numbers are telling me. Thank you in advance for any clarification or guidance!

" style="-webkit-font-smoothing: antialiased; margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 1rem; line-height: 22px; font-family: inherit; vertical-align: baseline; position: relative; overflow: hidden; height: 360px;">

Hey everyone! I am a rookie when it comes to real estate investing and Excel. I was thankful that someone was willing to share their spreadsheet with me via the Bigger Pockets Facebook group. I am currently looking at properties that meet my criteria and run the numbers on every one of them. I will be house hacking a duplex.

So in the "Unit Breakdown" column, I put I will be paying $900 and they will pay $1000. Under the "Total Expenses" column, it says $976. Under "Cash Flow" it says $654. I am utterly confused trying to understand that with me paying myself rent at $900 plus expenses of $976 plus $867 mortgage, am I still coming out on top at $654 cash flow? Also, what is the NOI of $867.

I apologize if these may be stupid questions for some people; I'm truly just trying to learn and understand fully what all these numbers are telling me. Thank you in advance for any clarification or guidance!