Need advice : analyzing multi-family property rental deals

New to Real Estate · Orange County, CA · Member since 2026 · 40 posts · 28 votes

Hi Naveen,

Great that you built your own sheet, that's honestly a great way to really internalize the numbers.

A couple of things I noticed looking at it:

1. Cap rate formula is a bit off. Cap rate = NOI / purchase price, where NOI is before debt service. You're calculating it on your adjusted NOI (after mortgage), which gives you a negative number that isn't really cap rate — that's closer to cash-on-cash. The actual cap rate on this deal is about 5.3% ($39,360 / $738,750), which is a much more useful number for comparing deals regardless of how you finance them.

2. Insurance looks low at $948/yr for a 5-unit. For multifamily you're typically looking at $1,500-2,500+ depending on age and location. Worth bumping that up.

On your bigger question about where to draw lines:

- Hard pass: cap rate below 4%, CoC negative with no clear upside lever (rent well below market, no value-add opportunity)

- Maybe: cap rate 4-6%, slightly negative cash flow but rents are below market or price is negotiable

- Look harder: cap rate 6%+, positive cash flow even at conservative vacancy/expense assumptions

Your instinct about breakeven + upside potential is pretty right. A deal that cash flows at -$200/mo but has below-market rents is very different from one that's -$200/mo with no room to move.

Side note: I'm offering free deal analyses right now in exchange for feedback. Happy to run one on a Pittsburgh deal if you want to DM me.

0 Reply

Masoud ArouniPro Member

Investor · Pleasanton, CA · Member since 2026 · 119 posts · 52 votes

5mo

@Naveen Himthani, Hiromi's cap rate correction is right and important. A few things worth adding on your decision framework question.

At $738,750 purchase with $39,360 NOI your cap rate is 5.3% but the number that actually tells you whether to go deeper is what your cash-on-cash looks like after mortgage payments, and more importantly what it looks like when you stress vacancy from your current assumption up to 10-12%. Pittsburgh multifamily vacancy has been running higher than most investors model. If your spreadsheet uses 5% vacancy, bump it to 10% and see what happens to your monthly cash flow. That single change will tell you whether you have a deal with real margin or one that only works in a best-case scenario.

Accurate stress testing requires knowing your current vacancy and expense assumptions, those two numbers drive everything downstream.

0 Reply

Dominic Mazzarella

Investor · Hendersonville, NC · Member since 2016 · 498 posts · 285 votes

5mo

Quote from @Naveen Himthani:

Hi Experts,

After reading through some material related to multi-property rentals by Rod Khlief, I decided to start analyzing deals online. I created a spreadsheet to do this myself. I am located in the Pittsburgh area. Can anyone tell me if this sheet I made is okay to quickly determine whether the property will cash flow or not. At what adjusted NOI / cap-rate / CoC do people usually even decide to take a look at a property in more detail or crunch more numbers? I do understand that it would vary significantly from person to person, so I am mainly looking at the reasoning behind dropping or not dropping a deal altogether after looking at initial numbers.

One thing I understand is that if the property is just breakeven and there is potential for increasing rents or potential for negotiation in the sale price, then one should dig deeper. I am looking for more reasons like this - where does one generally draw lines of - definitely, maybe (contingent on other things), absolutely No.

Thanks in advance for your advice!

Here is the sheet - https://docs.google.com/spreadsheets/d/12erbeAB_IMxu0H-184nL...

Your approach with a spreadsheet is solid for initial filtering. In markets like Pittsburgh, I'd generally want to see a cap rate north of 7% just to consider deeper due diligence. CoC is helpful but more of a secondary filter since it depends heavily on your financing. If the numbers barely break even, it's a pass unless you see clear upside in rents, value-add renovations, or tight supply that justifies holding. Generally, I drop anything with negative or near-zero cash flow unless there's a compelling reason to dig further, like a below-market price.

0 Reply

Vijay FriedmanBusiness Member

Miami, FL · Member since 2026 · 766 posts · 123 votes

5mo

Quote from @Naveen Himthani:

Hi Experts,

After reading through some material related to multi-property rentals by Rod Khlief, I decided to start analyzing deals online. I created a spreadsheet to do this myself. I am located in the Pittsburgh area. Can anyone tell me if this sheet I made is okay to quickly determine whether the property will cash flow or not. At what adjusted NOI / cap-rate / CoC do people usually even decide to take a look at a property in more detail or crunch more numbers? I do understand that it would vary significantly from person to person, so I am mainly looking at the reasoning behind dropping or not dropping a deal altogether after looking at initial numbers.

One thing I understand is that if the property is just breakeven and there is potential for increasing rents or potential for negotiation in the sale price, then one should dig deeper. I am looking for more reasons like this - where does one generally draw lines of - definitely, maybe (contingent on other things), absolutely No.

Thanks in advance for your advice!

Here is the sheet - https://docs.google.com/spreadsheets/d/12erbeAB_IMxu0H-184nL...

@Naveen Himthani

You’re on the right track by building the spreadsheet first. For an initial screen, I’d usually look at whether the deal still works after using conservative assumptions for vacancy, repairs, capex, management, taxes, insurance, and reserves.

In your sample, the cap rate is not terrible, but the cash-on-cash looks very thin after debt service. That usually tells me the deal may only be worth digging into further if there is a clear value-add angle, below-market rents, seller negotiation room, or a strong reason to believe the numbers improve after stabilization.

Personally, I wouldn't use one fixed cap rate or CoC cutoff for every market, but for a quick screen, I'd ask: does it cash flow conservatively, is there upside, and does the debt structure still leave enough margin? If the answer is no, I'd move on or renegotiate.@Naveen Himthani

786-656-0387

DreamPoint Capital

Website View Page

0 Reply

Fernando Chavez

Rental Property Investor · San Francisco Bay Area · Member since 2026 · 5 posts · 1 vote

4mo

Hey @Naveen Himthani,

The thresholds to me matter less than what feeds them. A sheet that takes the listing's rents and expenses at face value will pass a bad deal cleanly, because the math was never the weak point, but the inputs are.

When I screen, three things decide if a deal earns a second look: rent against what the unit actually leases for in that submarket, not the pro forma; an expense ratio that fits the building's age; and debt coverage at today's rate, not a rate from two years ago. If those three hold, it goes in the maybe pile. The maybe pile is where negotiation room and rent upside live.

I've been building this exact screen into a tool I'm developing, and the part I keep getting wrong is trusting a clean-looking number before I've stress-tested the assumption under it. So, totally get it :) If your sheet flags which inputs are real and which are guesses, that'll save you more than any cap-rate cutoff. Best of luck!

Fernando

0 Reply

Brandon M. Townsend

Member since 2026 · 28 posts · 22 votes

4mo

One thing I'd caution against is relying too heavily on a spreadsheet to decide whether a deal is worth pursuing.

The spreadsheet is great for identifying opportunities, but some of the biggest wins and losses I've seen in real estate were driven by factors that never showed up in the initial underwriting.

From a construction and operations perspective, I'd want to understand:

• Deferred maintenance
• Remaining life of major systems (roof, HVAC, plumbing, electrical)
• Capital expenditure requirements over the next 5–10 years
• Potential code or permitting issues
• Utility and infrastructure concerns
• Operational complexity of the asset

For me, a deal rarely gets killed because the initial cap rate is 0.5% lower than my target. A deal gets killed when I discover a major capital project, deferred maintenance issue, or operational challenge that wasn't reflected in the numbers.

As an initial screen, I think it's perfectly reasonable to establish minimum thresholds for NOI, CoC return, and DSCR. But I view those as a starting point, not the final decision.

A property with slightly weaker returns but minimal deferred maintenance can often outperform a "great deal" that's hiding six figures of future capital expenditures.

I'm curious—when you're analyzing these properties, are you also estimating future CapEx reserves, or are you primarily focused on cash flow and acquisition metrics at this stage?

0 Reply

Need advice : analyzing multi-family property rental deals

8 Replies