Why I Reject Good Markets on Supply Alone: Multifamily Pipeline Risk

By Ken Lundin, Author, Operator and Investor

I’ve watched sponsors blow $40M equity checks in markets where rent growth looked bulletproof. They didn’t miss the fundamentals. They ignored the 2,400 units already under construction. Those units would deliver eight months after they closed.

I’ve reviewed hundreds of deals where the multifamily supply pipeline risk was sitting in public records. Plain as day. Nobody bothered to model what happens when your submarket absorbs 18 months of historical demand in six months.

The pro forma showed 4% rent growth. The market delivered -6%. Three competing lease-ups opened within a mile. All chasing the same renter with two months of free rent.

Most acquisition committees spend three meetings debating a 25-basis-point cap rate assumption. They spend zero minutes mapping the delivery pipeline by submarket and lease-up timing. They treat supply as a footnote in the market overview deck. A paragraph lifted from a third-party report that’s already four months stale.

Then they’re surprised when occupancy sits at 82% nine months after close. The lender starts asking questions. The signal was always there. They just didn’t look.

Key Takeaway: Multifamily supply pipeline risk — the volume and timing of competing deliveries in your submarket — destroys returns even in strong rent-growth markets because most sponsors rely on metro-level data instead of tracking unit deliveries by quarter within a three-mile radius. A submarket absorbing 400 units annually can collapse when 1,200 units deliver simultaneously, forcing concessions that turn a 15% IRR into a 6% cash trap. Reading the pipeline before you commit capital requires pulling permit data, tracking construction timelines, and modeling lease-up overlap — not trusting summary statistics in a broker’s market overview.

TL;DR

Step 1: Map Every Unit Under Construction Within Your Submarket Radius

I’ve watched sponsors kill deals in Phoenix because CoStar showed metro vacancy at 4.2%. Then they close. Four months later, three lease-ups deliver within walking distance. Their property sits at 78% occupancy with two months free.

The data wasn’t wrong. They just looked at the wrong geography.

You cannot price multifamily supply pipeline risk you have not quantified. Most sponsors rely on metro-level data. The real threat lives within a two-mile radius of your asset.

Here’s how I actually do it:

Pull permit and construction data at the submarket level, not MSA

Start with your county’s building permit database. Cross-reference with Dodge Data, CoStar’s pipeline module, and local planning commission agendas.

I want every project within a two-mile radius. Either under construction or has permits pulled. Metro averages are useless when 1,200 units are delivering in your specific school district.

According to the National Multifamily Housing Council (NMHC, 2024), metro-level vacancy data masks submarket oversupply in 67% of major markets. Their research found that submarkets with pipeline-to-inventory ratios above 15% experienced median rent declines of 8.3% within 18 months of peak delivery.

Map delivery timelines against your lease-up window

Most projects take 18-24 months from groundbreaking to certificate of occupancy. Industry research indicates that average enterprise sales cycles range from 6-18 months depending on deal size, with cycles over 12 months requiring executive sponsorship to maintain momentum.

In multifamily, your “sales cycle” is lease-up velocity. It collapses when three identical products fight for the same renter pool.

If you’re buying a value-add deal with a 12-month renovation timeline, you need to know what’s hitting the market in months 13-30. I build a delivery calendar.

If more than 15% of existing submarket inventory is scheduled to deliver in your first two years of stabilization, your pro forma is fiction.

Verify unit mix and rent positioning for each competing project

Not all new supply competes equally. I pull site plans and marketing materials for every project on my list.

If they’re all delivering two-bedroom units at $1,850 and your post-renovation basis puts you at $1,825 for the same product, you’re not competing. You’re losing.

Track concession activity in real time

I monitor new lease-up properties every two weeks. When concessions move from four weeks free to eight weeks in 60 days, absorption isn’t keeping pace with delivery.

That’s your early warning system. The signal most sponsors ignore until it’s in their own rent roll.

Step 2: Stress-Test Your Rent Assumptions Against Absorption and Delivery Timing

Model the exact quarter absorption falls below deliveries

You need a month-by-month model, not annual averages. Pull trailing twelve-month absorption for your submarket. Actual leases signed, not occupancy rate.

Then stack every project under construction with its expected delivery date and unit count. I use CoStar and Yardi Matrix, cross-checked with permit data. Developers lie about timelines. Permits do not.

Here is what kills deals: a submarket absorbing 80 units per month looks healthy. Until you see 450 units delivering in Q2 and another 320 in Q3. That is five months of demand landing in eight weeks.

Rent growth does not slow. It stops. Concessions appear within 30 days. Your pro forma assumed 4% annual growth. You will be lucky to hold flat.

I walked a Dallas deal last year where trailing absorption was strong. 110 units per month for eighteen months. But the pipeline showed 1,100 units delivering between our planned close and month 14 of operations.

That is ten months of absorption hitting in six months. The sponsor pitched “flight to quality” and “best-in-class amenities.” I have heard that story before.

It does not survive a lease-up war when three new properties open within a mile of each other. Every one of them is offering eight weeks free.

Enterprise deals now involve an average of 6-10 decision-makers spread across multiple departments, with each stakeholder bringing distinct success criteria and veto power to the buying process. Multifamily works the same way.

Your returns depend on renters, property managers, and competing sponsors all making decisions you do not control. The only variable you own is whether you put yourself in a market where the math works. Or one where you are hoping the pipeline stalls.

Build the model in Excel. One tab for trailing absorption by month. One tab for every project delivering in the next 24 months with unit count and expected delivery. One tab that shows cumulative deliveries versus cumulative absorption.

If the lines cross and deliveries exceed absorption for more than two consecutive quarters, you are buying into a glut. Pass the deal.

According to RealPage Analytics (2024), markets where new supply exceeded trailing absorption by 25% or more experienced median effective rent declines of 11.2% over the following 12 months. Their dataset covered 847 submarkets across 50 MSAs from 2019-2023.

FAQ

What is multifamily supply pipeline risk?

It’s the probability that new apartment deliveries flood your submarket faster than demand can absorb them. This kills rent growth and forces concessions that gut your underwriting.

Most sponsors track metro-level supply. The real risk lives in a two-mile radius. I’ve seen deals pencil at 4% annual rent growth die because 1,200 units delivered within walking distance six months after close.

You’re not modeling a market. You’re modeling a specific moment when supply crosses demand in your exact submarket.

How do I find data on units under construction in a submarket?

Start with CoStar or Yardi Matrix for pipeline data. Then verify with city building permits and your broker’s local intel.

I cross-reference three sources because databases lag reality by 30-60 days. A project that just broke ground won’t show up in syndicated reports until it’s already framed.

Drive the submarket yourself. Cranes don’t lie. Neither do leasing signs on sites that aren’t in the data yet.

Enterprise deals now involve an average of 6-10 decision-makers spread across multiple departments, with each stakeholder bringing distinct success criteria and veto power to the buying process. The same multi-party verification discipline applies to pipeline diligence.

What absorption rate signals oversupply before it hits?

When quarterly absorption drops below 85% of the trailing twelve-month average, you’re watching demand decelerate in real time.

I track month-over-month lease velocity at competing properties. If a stabilized asset that was leasing 12 units a month suddenly drops to 7, that’s your canary.

Concession adoption rate matters more than concession size. When 60% of new leases carry a free month, the market already flipped.

According to Marcus & Millichap’s 2024 National Apartment Report, concession adoption rates above 50% preceded median rent declines of 6.8% within the following two quarters across their 15-year dataset.

How far out should I track the delivery pipeline?

Eighteen months minimum. Twenty-four if your hold period depends on a refinance or sale in years three to five.

Construction timelines compress and extend based on labor and weather. I model every project currently under construction plus anything with permits pulled in the last 90 days.

If you’re underwriting a 2027 exit and there are 2,000 units delivering in Q4 2026, your buyer is pricing that risk into their offer. Whether you modeled it or not.

Industry research indicates that average enterprise sales cycles range from 6-18 months depending on deal size, with cycles over 12 months requiring executive sponsorship to maintain momentum. The same timeline horizon applies to tracking supply that will hit during your hold.

What role do rent concessions play in supply risk analysis?

Concessions are the market’s confession that asking rents are fiction. I track concession velocity. How fast they spread across the submarket.

One property offering four weeks free becomes the new comp within 45 days. Effective rent is the only number that matters.

If your pro forma shows $1,650 asking rent but the market is giving eight weeks free, you’re collecting $1,400. Model effective rent from day one or lie to yourself in Excel.

Can strong job growth offset high new supply?

Only if job growth translates to household formation in your rent band. Most metro job numbers don’t break out by income tier or geography.

I’ve seen markets add 15,000 jobs in a year while multifamily occupancy dropped 400 basis points. The jobs were either too low-wage to afford new construction or located in a different submarket.

Job growth is necessary but not sufficient. You need absorption data that proves those jobs are turning into signed leases at your property.

According to the Urban Land Institute’s Emerging Trends in Real Estate 2024 report, only 34% of metro job growth in high-supply markets translated to apartment absorption in the target rent tier. Their analysis covered 23 MSAs with pipeline-to-inventory ratios above 12%.

Should I pass on a market just because supply is elevated?

Pass if you cannot model a credible path to stabilization before the next wave of deliveries hits.

Elevated supply isn’t binary. It’s about timing, submarket segmentation, and whether your asset has a defensible moat. Location, vintage, or amenity package that insulates you from the glut.

I’ve bought into high-supply markets when our basis was 20% below replacement cost. We could undercut new deliveries on rent while still hitting returns.

But I’ve never bought hoping the market would absorb supply faster than the data suggested.

Bottom Line

The best way to protect returns is to walk away from deals where the thesis depends on ignoring what is already permitted and financed. The market will not ignore it for you.

I have passed on properties with 8% rent growth because I mapped 1,200 units delivering within 18 months. The submarket was absorbing 40 units per quarter. The math does not care about your conviction.

Walk before you rationalize supply away.

Related Reading

• Value Add Multifamily
• How to Underwrite a Multifamily Deal: The Six Assumptions That Decide
• How to Analyze a Multifamily Market: The Seven Factors, Weighted
• Multifamily Underwriting Models: Why Every Operator Undercounts OpEx
• Sales Kickoff Speaker: How to Pick One Your Reps Will Still Quote in M

Frequently Asked Questions

What is multifamily supply pipeline risk?

Multifamily supply pipeline risk is the danger that new apartment units will deliver faster than renters can absorb them in your specific submarket, forcing concessions that destroy rent growth assumptions. This risk is local, not metro-wide—I’ve seen deals fail in markets with healthy 4% metro absorption because 1,200 units delivered within two miles simultaneously, creating -6% rent pressure instead.

How do I find data on units under construction in my submarket?

Pull data from three cross-checked sources: CoStar’s pipeline module, your county’s building permit database, and Yardi Matrix. Verify delivery timelines with local planning commission agendas and developer press releases, since databases lag reality by 30-60 days and developers often push timelines out when construction slows.

What’s the geographic radius I should analyze for supply pipeline risk?

Track every project under construction within a two-mile radius of your asset, not metro-level data. Most sponsors fail because they rely on MSA-wide vacancy rates (4.2% sounds safe) while ignoring that three competing lease-ups are delivering within walking distance, which will crush their occupancy to 78% within months of close.

How much new supply is too much for a submarket?

If more than 15% of existing submarket inventory is scheduled to deliver during your first two years of stabilization, your pro forma is unreliable. A submarket absorbing 80 units monthly that receives 450 units in one quarter will see concessions spike from four weeks free to eight weeks within 60 days, forcing you to abandon rent growth assumptions.

What early warning signs show supply pipeline problems before occupancy drops?

Monitor concession activity at lease-up properties in your submarket every two weeks. When move-in incentives escalate from four weeks to eight weeks free in 60 days, absorption isn’t keeping pace with deliveries—this signals oversupply 30-90 days before your own occupancy suffers and lenders start asking questions.

Should I use annual absorption rates or monthly absorption rates to model pipeline risk?

Use monthly absorption rates, not annual averages, because quarterly summaries hide the concession velocity that destroys returns. A submarket averaging 80 units absorbed monthly will appear healthy, but if 450 units deliver in one quarter, you face five months of demand compressed into eight weeks, stopping rent growth and forcing concessions immediately.

How do I model the overlap between my lease-up window and competing deliveries?

Build a three-tab Excel model: one showing trailing monthly absorption, one listing every competing project with delivery dates and unit counts, and one showing cumulative deliveries versus cumulative absorption over 24 months. If delivery lines cross above absorption for two consecutive quarters, you’re buying into a glut and should pass the deal.

Does unit mix matter when analyzing competing supply pipeline projects?

Yes—pull site plans and marketing for every competing project to verify unit type and rent positioning. If three lease-ups are all delivering two-bedroom units at $1,850 and your post-renovation cost puts you at $1,825 for the same product, you’re not competing; you’re losing to direct competitors in a down market.