How to Read a Rental Cash Flow Result, Line by Line

The result is a waterfall, not a verdict

A rental cash flow result looks like a single number — so many dollars a month — and that is exactly how people misread it. The number at the bottom is the end of a waterfall: rent comes in at the top, some of it is set aside for the months the unit sits empty, the operating expenses come out next, what survives is the net operating income, the loan payment comes out after that, and only then do you reach cash flow. Read the result line by line, in that order, and each line tells you something different about the deal. Skip to the bottom and all you learn is whether the spreadsheet is happy, which is not the same question as whether the property is.

So this is the order to read in, every time: gross rent, vacancy allowance, effective income, operating expenses, NOI, debt service, cash flow — and then the two ratios that put the result in context, cash-on-cash return and cap rate. We will take them in the order the calculator stacks them.

Lines one and two: rent, and the months nobody pays it

Gross rent is the rent if the unit were occupied and paying all twelve months. It almost never is. The vacancy line is the calculator being honest about turnover: tenants move, units sit while they are cleaned, painted, and re-leased, and every one of those weeks is a week the mortgage does not skip. A common planning allowance is five to eight percent of gross rent, and the right figure for your reading is the one your market and property type actually produce — a stable long-lease unit and a high-turnover unit should not carry the same line.

Check the rent itself before anything downstream of it. Rent is the one input that multiplies through the whole waterfall, so an optimistic rent poisons every line below it. Anchor it in evidence: comparable rented units nearby, and where a voucher tenant is part of the plan, the published payment standard for that bedroom count in that market. If the deal only works at a rent nobody nearby is achieving, the waterfall has told you the answer already, two lines in.

The expense block: the lines people delete to make deals "work"

Operating expenses are where rental math goes to be flattered. The honest block includes taxes, insurance, maintenance, a reserve for capital expenditures — roofs, water heaters, HVAC, the big items that arrive on their own schedule, not yours — and management. Management deserves a sentence of its own: charge it even if you plan to manage the property yourself. Your time is a real cost, and a deal that only cash-flows when your labor is priced at zero is telling you its margin is your unpaid work. If you later choose to self-manage, the management line becomes part of your return for doing that job — but it belongs in the math either way.

Capital expenditures are the other commonly erased line, because they do not arrive monthly. They arrive all at once, years in, for thousands of dollars. A reserve line that drips a modest amount into the calculation every month is how a spreadsheet admits that roofs are not permanent. Delete the CapEx reserve and this year's cash flow looks wonderful. The year the roof fails, you find out what it really was.

NOI is not cash flow, and the difference is the loan

Net operating income stops before the mortgage. That is deliberate: NOI describes the property itself, which is why the cap rate — NOI divided by price — lets you compare two properties without their financing getting in the way. Cash flow is NOI minus debt service, and it describes your position in the property, loan included. Confusing the two is the most expensive reading error in rental math. A property can have a healthy NOI and negative cash flow because the loan is large or the rate is high — the building is fine and the deal, as financed, is not. When a lender looks at the same property, they run a close cousin of this comparison — debt service coverage — asking whether NOI covers the payment with room to spare. Reading your own result the same way a lender does keeps you from being surprised by their answer.

The screening rules are screens, not verdicts

You will meet two shortcuts around this waterfall: the 1% rule, which asks whether monthly rent is at least one percent of the total price, and the 50% rule, which estimates operating expenses at half of gross rent. Use them the way they were meant to be used — as thirty-second screens that sort a pile of listings into "worth a full run" and "not." A property that passes a screen has earned a waterfall, not a purchase. A property that fails one in a market where rents run structurally lower may still deserve a look at the real lines. The calculator's full result is the verdict; the rules just decide what gets read carefully.

Reading a result that says no

A negative or razor-thin cash flow is not the calculator being rude. It is three possible facts wearing one costume: the price is too high for the rent the market will pay, the rent assumption was optimistic, or the expenses were understated somewhere above. Re-read upward. If the rent is proven and the expenses are honest, the remaining variable is price — and a disciplined offer at the price where the waterfall works is a legitimate outcome of the exercise. If no legal price makes it work, walking away is the other legitimate outcome. What is never legitimate is editing lines until the bottom number turns green. The property will run the real waterfall whether your spreadsheet does or not.

What a good result does not promise

Even a clean, positive, honestly-built result is a plan, not a guarantee. It assumes the rent you proved, the vacancy you allowed, and the expenses you listed behave roughly as expected — and reserves exist precisely because some years they will not. That is why the experienced reading of a cash flow result is calm in both directions: a good one means the deal deserves the next step of diligence, and a bad one means it earned you an early, cheap education. Either way, you now know how to read the next one — line by line, in order, all the way down the waterfall.

Keep the sheet with the property

One last habit separates a reading from a guess: save the run. Keep the calculator output and the assumptions behind it in the property file — the rent evidence you used, the expense figures and where they came from, the loan terms you modeled. Three months later, when actuals start arriving, that saved sheet is how you learn whether your vacancy allowance was honest and your reserves were sized right. The waterfall gets more accurate every time you compare it against a real year, and that comparison is impossible if the original run only lived in a browser tab.