Rental cash flow formula (step-by-step)

Rental cash flow is simply income minus expenses, but the details matter. Investor spreadsheets often disagree because each one defines expenses differently. This calculator follows a practical, widely used approach that separates operating performance (NOI) from financing (mortgage).

Start with the rent you expect to collect if the property is fully occupied: GSI = Monthly Rent + Other Monthly Income. “Other income” could be pet rent, parking fees, laundry income, storage units, or application fees (use conservative numbers; these can fluctuate).

Properties are not occupied 100% of the time. Tenants move out, repairs happen, and you may have a month with no rent. The vacancy slider applies a simple haircut: EGI = GSI × (1 − Vacancy%). A 5% vacancy is a common “default,” but higher vacancy can be realistic in weaker rental markets. If you expect seasonal vacancy, use the yearly average.

Operating expenses are what it costs to run the property before financing: property taxes, insurance, HOA, utilities paid by the owner, plus “reserve style” items like maintenance and CapEx. Many new investors only include the bills they see today. Professionals add reserves because big expenses show up later (HVAC, roof, water heater, paint, flooring).

NOI is the property’s “business income” before debt: NOI (monthly) = EGI − Operating Expenses. This is a core metric because it lets you compare deals across different financing structures. For example, two buyers might have different interest rates, but the NOI is the same property performance.

If you finance the purchase, your mortgage payment is typically principal and interest (P&I). This calculator uses the standard amortization formula: Payment = L × r × (1 + r)ⁿ / ((1 + r)ⁿ − 1), where L is the loan amount, r is the monthly interest rate, and n is the total number of payments (term in months). If your interest rate is 0%, it handles it as a simple principal repayment (loan ÷ months).

Finally: Monthly Cash Flow = NOI − Monthly Debt Service. Positive cash flow means the property generates money each month after expenses and mortgage. Negative cash flow means you must pay out of pocket to hold the property. Some investors accept negative cash flow if they are betting on appreciation, but it increases risk and reduces flexibility.

Once cash flow is known, you can compute quick investor ratios:

• Cap rate: (NOI × 12) ÷ Purchase Price
• Cash-on-cash return: (Cash Flow × 12) ÷ Cash Invested
• DSCR: NOI ÷ Debt Service (both annual or both monthly)
• Break-even occupancy: (OpEx + Debt) ÷ GSI

Numbers are only as good as assumptions. Conservative assumptions are a feature, not a bug.

How to use this calculator (and avoid “too-good-to-be-true” deals)

Think of this tool as a “first-pass filter.” The goal is not to perfectly predict the future—it's to help you quickly answer: does this property likely pay for itself? Here’s a practical workflow:

These are the two most influential numbers. If you’re not confident in market rent, use the low end of comps (and avoid using “advertised” rents as reality).

Down payment and interest rate drastically affect debt service. If rates are volatile, test several scenarios (example: 6.5%, 7.5%, 8.5%). A deal that only works at one specific rate is fragile.

Vacancy is not optional. Neither are maintenance and CapEx reserves. If you don’t set aside money for replacements, the replacements still happen… they just happen at the worst time.

Taxes and insurance can rise sharply, so don’t use unrealistically low “first-year only” numbers. HOA and utilities are straightforward: put what you expect to pay.

The score is a quick health indicator based on cash flow, DSCR, and cash-on-cash return. It is not a guarantee, but it’s great for comparing multiple listings quickly.

• Cash flow: positive, with a buffer (not $10/month).
• DSCR: above ~1.20 is generally safer; near 1.00 is tight.
• CoC return: depends on market and strategy, but higher is better.
• Break-even occupancy: lower is safer (you can survive vacancy).

If the property fails these tests, it doesn’t mean you must walk away—but it means you should ask why the numbers are weak (price too high, rent too low, expenses too high, financing too expensive).

Example: a simple single-family rental

Suppose you’re looking at a $300,000 rental that rents for $2,200/month. You put 20% down and finance the rest at 7% for 30 years. You assume 5% vacancy, $3,600/year taxes, $1,200/year insurance, and no HOA or utilities. Maintenance is 8% of rent and CapEx is 5% of rent. Management is 0% if you self-manage.

The calculator first computes monthly income: $2,200. Then it applies 5% vacancy, giving effective income of $2,090. It adds monthly taxes ($300) and insurance ($100), plus reserves for maintenance ($176) and CapEx ($110). Your operating expenses become roughly $686/month. So NOI is about $1,404/month.

Next it computes mortgage payment on a $240,000 loan (80% of $300,000). At 7% for 30 years, P&I is roughly $1,596/month (your exact value depends on rounding). Cash flow then becomes around -$192/month. That negative result is valuable: it tells you this deal likely requires either a lower purchase price, higher rent, bigger down payment, or a different strategy.

• Rent increases to $2,500/month (if comps support it).
• Down payment increases (reduces debt service).
• Purchase price decreases (improves everything).
• Lower taxes/insurance/HOA (market-dependent).

This is why cash flow tools are popular: they make tradeoffs visible instantly. You can “stress test” a deal in 30 seconds before spending hours on deeper due diligence.

Frequently Asked Questions

• What is the difference between cash flow and NOI?

  NOI is income after operating expenses but before the mortgage. Cash flow subtracts the mortgage payment (debt service) from NOI. Two investors can buy the same property and have the same NOI but different cash flow if their financing differs.

• Why do you include maintenance and CapEx as percentages?

  Many costs are “lumpy.” You might have months with no repairs, then a $6,000 HVAC replacement. Using a percentage is a simple way to budget reserves so your cash flow estimate is more realistic.

• What vacancy rate should I use?

  There’s no single best number. A common conservative default is 5–8% for stable markets, but higher vacancy can be realistic for weaker markets or properties with turnover risk. If you are unsure, test 5%, 10%, and 15% and see if the deal still survives.

• Does this include principal paydown and appreciation?

  Not directly. This is a cash flow tool. Principal paydown and appreciation are real benefits, but they are harder to predict. Cash flow is immediate and measurable, which is why many investors start here.

• Should I use annual or monthly taxes and insurance?

  Either works if you convert consistently. This calculator accepts annual values and converts them to monthly so the monthly cash flow math stays clean.

• What is a “good” cash-on-cash return?

  It depends on market and risk. In hot appreciation markets, investors may accept lower CoC returns. In cash-flow markets, investors often target higher CoC returns. Use it as a comparison tool across deals.

• Is this calculator financial advice?

  No. It’s a planning tool. Real-world investing involves legal, tax, financing, and market risks. Always verify.