Cash Flow Analysis: Beyond the Basics

Here's how most beginner investors calculate cash flow:

Rent − Mortgage = Cash Flow

It's clean. It's fast. And it's wrong in ways that cost investors thousands of dollars per year and occasionally destroy deals entirely.

The actual formula professional underwriters use looks like this:

Gross Scheduled Income − Vacancy − Operating Expenses − CapEx Reserve − Debt Service = Net Cash Flow

That's not just more steps — it's a fundamentally different understanding of what you own. Every line item you skip is a dollar you're assuming doesn't exist until it shows up on your bank statement as an unexpected outflow.

This guide covers the advanced cash flow concepts that separate amateur projections from professional underwriting: the metrics that actually matter, the expenses most investors systematically undercount, the scenario frameworks that stress-test a deal before you close, and how Homestream's analysis engine applies these principles automatically to Detroit and Michigan properties.

The Amateur Model vs. The Professional Model

Let's start with a concrete comparison. Same Detroit property. Two different analyses.

The property: 3BD/1BA single-family, east side Detroit. Acquired at $70,000, renovated to ARV of $120,000, rented at $1,200/month.

Amateur Analysis

Looks like a strong deal. $631/month, $7,572/year.

Professional Analysis

Same property. Same rent. Same mortgage. Completely different picture.

The amateur model shows $631/month in free cash flow. The professional model shows negative $125/month. That's a $756/month gap — nearly $9,000 per year — caused entirely by expenses the amateur model never acknowledged.

This isn't a hypothetical edge case. It's the standard gap between how beginners and professionals see the same deal. And it's why investors who rely on the simplified model end up with properties that "aren't performing" — when the reality is they were never performing on paper, either.

Building the Complete Cash Flow Model

Level 1: Gross Scheduled Income (GSI)

GSI is the maximum rental income the property could generate if fully occupied at market rate for the entire year.

GSI = Monthly Market Rent × 12

This is your starting point — not your ending point. Every subsequent calculation is a reduction from this number.

The critical input: market rent vs. contract rent. Market rent is what similar properties in the sub-market actually rent for today. Contract rent is what your specific tenant is paying. For a new acquisition, you should project market rent — but validate it against actual comparable rentals within 0.5 miles, similar bed/bath count, similar condition, leased within the last 60–90 days. Not Zillow estimates. Not what the seller claims. Actual comparable transactions.

In Detroit, rent levels vary dramatically at the neighborhood level. A 3/1 in Grandmont-Rosedale might command $1,350/month; the same configuration in a less-stable pocket of the same zip code might be $950. Sub-market accuracy matters here more than it does in homogeneous suburban markets.

Level 2: Effective Gross Income (EGI)

EGI accounts for the reality that properties aren't always fully occupied.

EGI = GSI − Vacancy Loss − Credit Loss

Vacancy allowance:The standard for stabilized Detroit investment properties is 8–10%. This isn't pessimism — it's an honest representation of the one or two months per year (averaged over a multi-year hold) when the unit is vacant between tenants, during a turnover, or during a lease-up.

Beginning investors often set vacancy at 0% ("I already have a tenant") or 2% ("this neighborhood is hot"). Both are mistakes. Vacancy is not just about your current tenant — it's about the 10-year horizon of ownership, averaged across good years and bad. Over a decade, 8% vacancy is conservative in Detroit, not aggressive.

Credit loss:The portion of scheduled rent you don't collect due to tenant non-payment or partial payment. Standard is 1–3% of GSI. In Detroit, where eviction proceedings can take 2–4 months in court and cost $2,000–$4,000+ in legal fees and lost rent, even a single partial-pay situation can blow through a year's credit loss reserve.

Level 3: Net Operating Income (NOI)

NOI subtracts all operating expenses from EGI. This is the metric that drives valuation, financing, and deal comparison.

NOI = EGI − Operating Expenses

Operating expenses include everything except debt service (mortgage payments). Debt service is intentionally excluded from NOI because it depends on your specific financing — two investors with different loan amounts own the same property with the same NOI.

The Six Operating Expense Categories

1. Property taxes
In Detroit, investor-owned properties are taxed at the non-homestead millage rate — approximately 70 mills. On a property with a $60,000 taxable value (50% of ARV), annual taxes are approximately $3,600 ($300/month). This single line item is the most consistently underestimated expense in Detroit deal analysis.

Sellers often quote their own tax bills, which reflect the Principal Residence Exemption (PRE) at ~18 mills. That number is meaningless to you as an investor. Always calculate taxes at 70 mills before making an offer.

2. Insurance
Investor-owned rental property insurance in Detroit runs higher than owner-occupied premiums. Budget $100–$150/month for a standard single-family rental — more for properties in areas with elevated claim history or flood zone status.

3. Property management
If you hire a property manager (8–10% of collected rent is standard in Michigan), this is a direct operating expense. If you self-manage, this is still a cost — it's just paid in your time rather than cash. Professional underwriting includes the management fee whether you're hiring a manager or not.

4. Maintenance and repairs
Day-to-day wear and repair: plumbing drips, appliance repairs, painting between tenants, landscaping, minor HVAC service. Standard range: 5–8% of gross rent. On a $1,200/month rental, that's $720–$1,152/year.

5. Capital Expenditures (CapEx)
CapEx is the big-ticket, irregular expense category that destroys unprepared investors: roof replacement, HVAC system, water heater, electrical panel, plumbing lines, foundation work. These aren't monthly costs — they're $5,000–$25,000 events that happen every 5–20 years.

Simplified CapEx Reserve Framework

6. Utilities (when applicable)
In standard single-family rentals where the tenant pays all utilities, this category is zero. In properties where the owner pays water/sewer (common in some Detroit multi-unit configurations), budget accurately for historical utility costs.

Level 4: Debt Service

Debt service is simply your monthly mortgage payment — principal and interest.

For a $90,000 DSCR loan at 6.5% over 30 years: $569/month P+I.

Note: The complete PITIA (Principal + Interest + Taxes + Insurance + Association fees) is what lenders use for DSCR qualification. NOI-to-debt-service calculations should use P+I only (taxes and insurance are already in operating expenses). Don't double-count.

Level 5: Net Cash Flow

Net Cash Flow = NOI − Debt Service

This is the actual money in your pocket each month after everything is paid. It's what matters for your personal finances. It's what matters for sustainability. And it's the metric that separates a real investment from a liability with optimistic projections.

The Metrics That Matter Beyond Monthly Cash Flow

Monthly net cash flow is necessary but not sufficient. Professional investors track a stack of related metrics that give different views of the same deal.

Cash-on-Cash Return (CoC)

CoC = Annual Net Cash Flow ÷ Total Cash Invested × 100

Total cash invested includes: down payment + closing costs + any upfront repairs/reserves you funded out of pocket.

If your annual net cash flow is $2,400 and you put $25,000 into the deal (down payment, closing costs, reserves), your CoC is 9.6%.

What's good?In Detroit's market in 2026, a CoC of 6–10% on a well-underwritten deal with conservative vacancy and expense assumptions is strong. Anything above 10% with conservative inputs is exceptional. Anything projecting 15%+ deserves scrutiny — something is probably underestimated in the model.

Cap Rate

Cap Rate = NOI ÷ Purchase Price (or Current Market Value) × 100

Cap rate strips out financing entirely and measures the pure return on the asset's value. It's the universal language of investment real estate comparison.

Using the professional analysis above: NOI of $444/month = $5,328/year. On a $120,000 ARV:

Cap Rate = $5,328 ÷ $120,000 = 4.4%

That's a thin cap rate — which reflects the reality that this Detroit property's cash flow margins are compressed by the 70-mill tax rate and current interest rate environment.

The cap rate trap:A high cap rate doesn't automatically mean a good deal. It may mean a riskier property in a weaker neighborhood. Always contextualize cap rate against market norms and risk profile.

Gross Rent Multiplier (GRM)

GRM = Purchase Price ÷ Annual Gross Rent

GRM is a quick first-pass filter. Lower GRM = shorter time to recover cost through rent. In Detroit, GRMs of 7–10 are common in the B-class investment market. A GRM below 7 in a decent neighborhood is worth a closer look; above 12 generally means the cash flow is thin.

Return on Equity (RoE)

As time passes and your property appreciates and your loan pays down, the equity in your deal increases. Your cash flow stays roughly flat (or grows with rents). Which means your return on that growing equity base is actually declining.

RoE = Annual Cash Flow ÷ Current Equity Position × 100

If you bought at $70,000 with $10,000 down, your cash flow is $2,400/year, and five years later the property is worth $140,000 and your loan balance is $82,000:

Equity = $140,000 − $82,000 = $58,000
RoE = $2,400 ÷ $58,000 = 4.1%

That's lower than a high-yield savings account. This metric is why experienced investors periodically evaluate whether to hold, refinance (and redeploy equity), or sell — rather than assuming "buy and hold forever" is always the right answer.

The Expenses Investors Consistently Skip

Beyond the standard model errors, these are the line items that most commonly appear as surprises post-close:

Detroit water/sewer bills.Detroit has some of the highest water rates in the country. In single-family rentals where the lease specifies the tenant pays utilities, this isn't your problem. But in any multi-unit configuration where the water meter is shared or the lease is ambiguous, you may inherit a $200–$400/month expense that wasn't in the model.

Turnover costs. When a tenant vacates, you typically face: cleaning ($150–$300), minor repairs and touch-up paint ($300–$800), and potentially a vacant month during re-leasing. Turnover every 2 years averages $500–$1,000/year.

Lawn care and snow removal. In many Detroit neighborhoods, lawn maintenance is an owner responsibility. $50–$100/month for basic maintenance is common. Snow removal in Michigan winters is real.

Legal and eviction costs. Even the most disciplined screener will face an eviction eventually. Budget 1–2% of annual gross rent as a legal reserve. An eviction in Michigan can run $1,500–$4,000 and take 60–120 days of non-payment.

How to Spot a Bad Pro Forma

When a seller, wholesaler, or agent provides a proforma — their projection of cash flow — treat it as marketing material, not analysis. Here's how to audit it:

• Check the vacancy assumption. If it shows 0%, 2%, or "fully occupied, no vacancy expected" — that's not a real model.
• Check the property tax figure. If it shows the seller's actual tax bill, recalculate at 70 mills. The difference in Detroit can easily be $200–$300/month.
• Look for missing management fees. A proforma that says "owner self-manages" but doesn't include a management line item is modeling as if management is free.
• Look for missing CapEx. If the expense list shows maintenance at $50/month and no CapEx line at all, the model assumes the property never needs a roof, HVAC, or water heater replacement.
• Check the rent source. Is projected rent supported by actual comps, or is it the seller's optimistic estimate?

Frequently Asked Questions

What's a "good" cash flow number for a Detroit rental?
In Detroit's B-class neighborhoods in 2026, a well-underwritten deal with all expenses included should generate $100–$400/month in net cash flow. Deals showing $600–$800/month at realistic inputs are genuinely exceptional — and warrant extra scrutiny to confirm the inputs are correct, not optimistic.

Should I include mortgage principal paydown in my cash flow analysis?
Not in cash flow itself — principal paydown doesn't hit your bank account monthly. But it does matter for total return analysis. Over a 30-year hold, your tenants pay down the entire mortgage on your behalf.

How do I handle a property that breaks even or shows slightly negative cash flow?
Neutral or slightly negative cash flow isn't automatically a deal-killer — it depends on the strategy. A BRRRR investor who breaks even on cash flow after a refinance but fully recycled their capital has a free, appreciating asset with tenants paying the mortgage. The question is whether you can personally sustain a small monthly outflow during periods of vacancy or unexpected expense without distress.

What's the difference between NOI and cash flow?
NOI excludes debt service (mortgage). Cash flow subtracts debt service from NOI. Two investors with different financing on the same property have the same NOI but different cash flows. NOI is the universal property-level metric; cash flow is the investor-specific outcome.

Final Thoughts

The gap between amateur and professional cash flow analysis isn't about sophistication for its own sake. It's about accuracy. Every expense line you omit is a dollar you're assuming doesn't exist — until it does.

The investors who build durable portfolios in Detroit aren't the ones who find deals that look great on a simplified model. They're the ones who model every deal correctly, walk away from the ones that don't pencil at realistic inputs, and close confidently on the ones that do.

Because the deals that actually work are the only ones worth your capital.

This guide is for educational purposes and does not constitute financial, tax, or legal advice. Figures and market data reflect general Detroit market conditions as of 2026. Consult with qualified professionals before making investment decisions.