Updated about 1 month ago on . Most recent reply
How do you analyze commercial development deals?
I'm embarking on the largest scale commercial development project. I've done very small ones but one is very large and even looking for grants from the local government as a community improvement opportunity. How are people here approach underwriting for commercial development projects?
Most of my experience historically has been analyzing smaller residential deals and very small commercial, but with this larger commercial project, the modeling gets a lot more complicated pretty quickly.
Construction costs, lease-up timelines, financing structure, exit assumptions, contingencies… there are a lot more moving parts than a typical rental property.
I’ve been building my own modeling framework to help think through the numbers, but I’d love to hear how other investors approach it.
A few things I’m especially curious about:
What metrics do you focus on most for development deals?
How do you model lease-up risk or slower-than-expected absorption?
Do you build your own spreadsheets or use specific tools?
Any mistakes you made early on that changed how you analyze these deals?
Would love to hear how people here structure their analysis before moving forward on a project.
Most Popular Reply
#4 Starting Out Contributor
How to Underwrite Commercial Development Deals: The Metrics, Models, and Mistakes That Actually Matter
If you've been analyzing rental properties and small commercial deals, scaling up to ground-up development can feel like learning a new language. Here's the framework I use to underwrite commercial development projects — and the expensive lessons that built it.
Making the jump from analyzing stabilized rental properties to underwriting commercial development deals is one of the biggest leaps in real estate investing. The core principles are the same — buy right, manage risk, create value — but the modeling gets dramatically more complex.
With a rental property, you're analyzing what already exists. With development, you're projecting what might exist 18-24 months from now, betting your capital on assumptions about construction costs, tenant demand, and market conditions that haven't materialized yet.
I've underwritten deals ranging from small mixed-use buildings to large-scale commercial projects, and I've learned that the difference between a profitable development and a disaster usually comes down to how honestly you modeled the unknowns before you broke ground.
Here's the framework I use today — and the mistakes that forced me to build it.
The Five Metrics That Drive Every Development Decision
When you're analyzing a stabilized property, cap rate and cash-on-cash return tell most of the story. Development deals require a different toolkit. These are the five numbers I look at before anything else.
1. Development Yield (Yield on Cost)
This is THE metric for development deals. It's your projected stabilized Net Operating Income divided by your total development cost.
Why it matters: Development yield tells you whether you're actually creating value or just taking construction risk for returns you could get buying an existing building. The magic number is the spread between your development yield and the market cap rate for comparable stabilized properties.
The rule: If your development yield doesn't exceed the market cap rate by at least 150 basis points, the deal doesn't justify the risk.
Example: Stabilized office buildings in your market trade at a 7% cap rate. Your total development cost is $3 million, and your projected stabilized NOI is $270,000. That's a 9% development yield — a 200 basis point spread over market. That's a deal worth pursuing. If that same project only generates $230,000 in NOI (7.7% yield), the 70 basis point spread doesn't compensate you for 18 months of construction risk, lease-up uncertainty, and capital tied up earning nothing.
2. Total Development Cost Per Square Foot
This is where most first-time developers get surprised. Total development cost isn't just what the contractor charges you — it's everything.
Break it into three buckets:
- Hard costs: Actual construction — foundation, framing, mechanical, electrical, plumbing, finishes. This is the number your contractor bids.
- Soft costs: Architecture, engineering, permits, legal, accounting, lender fees, construction management, insurance, interest carry during construction. First-time developers routinely underestimate this by 40-50%.
- Land: Acquisition cost plus any site work (grading, utilities, environmental remediation) needed before construction starts.
Benchmark carefully and locally. National averages are nearly useless for development budgeting. A Class A office building costs $250/SF in Nashville and $450/SF in San Francisco. Rural markets often run higher than you'd expect because material delivery and specialized subcontractor availability add cost. Always get local contractor bids before you finalize your model.
3. Breakeven Occupancy
What percentage of your building needs to be leased before rental income covers debt service plus operating expenses?
The rule: I want breakeven occupancy below 65%. If you need 80%+ occupancy just to keep the lights on and make your loan payment, you're one vacancy away from writing checks out of pocket every month. In smaller markets where tenant pools are limited, this metric is even more critical — losing a single tenant in a 10,000 SF building hits a lot harder than in a 100,000 SF building.
4. Cash-on-Cash Return at Stabilization
After the building is constructed, leased up, and operating at its projected occupancy — what's your annual cash return on the equity you actually invested?
The rule: For development risk, I want 12%+ cash-on-cash at stabilization. Anything below that and I should have just bought an existing building with immediate cash flow instead of tying up capital for two years with zero return during construction and lease-up.
5. Internal Rate of Return (IRR)
IRR captures what the other metrics miss: the time value of money across the entire project lifecycle. A project that generates a 9% annual return sounds decent until you realize your capital earned literally zero for 24 months during construction and lease-up, making the time-weighted return much less impressive.
The rule: Development deals should target 18-25% IRR over a 5-7 year hold (including construction, lease-up, stabilization, and exit). This compensates for the complexity, the risk, and the opportunity cost of capital sitting idle during construction.
How to Model Lease-Up Risk Without Lying to Yourself
Lease-up is where development deals go to die. It's also where the most dangerous optimism creeps into your model. I've seen developers model a 6-month lease-up for a 40,000 SF building in a market that absorbs 3,000 SF per month. The math doesn't work, but the spreadsheet doesn't argue with you.
Here's how I approach it honestly.
Build Three Scenarios — Not One
Base case: 10-15% of total leasable SF absorbed per month, starting 3 months after certificate of occupancy. This assumes your market is healthy, your building is well-positioned, and your broker is actively working the deal.
Downside case: 5-8% per month, starting 6 months after CO. This is what happens when the market softens, your asking rents are slightly too high, or tenants take longer to make decisions than you expected.
Disaster case: 3-5% per month, starting 9 months after CO. If your deal survives this scenario — meaning you can cover debt service from reserves without running out of cash — you have a resilient project.
The key question: Which scenario do you use as your base assumption? Most developers use the optimistic one. Experienced developers use the downside case as their base and treat the optimistic scenario as upside. Your lender will appreciate this approach, and so will your investors.
The Carrying Cost Trap
Every month your building sits partially vacant, you're bleeding cash. Debt service, insurance, property taxes, basic maintenance, property management — these costs don't wait for tenants to show up.
Model 18-24 months of carry costs as a line item in your total development budget. Not as a "contingency you probably won't need" — as a real budget line with real dollars allocated. This is the single item most likely to turn a profitable project into a capital call if you didn't plan for it.
Pre-Leasing Changes Everything
The single most de-risking thing you can do on a development deal is pre-lease space before you break ground. Getting Letters of Intent from tenants before construction starts does three things simultaneously:
- Validates your assumptions. If you can't get LOIs, the market is telling you something. Listen.
- Improves your financing. Lenders will offer better terms — often 50-100 basis points lower — when they see committed tenants.
- Compresses your lease-up timeline. Tenants who signed LOIs pre-construction typically take occupancy within 60-90 days of CO, meaning you start generating income almost immediately.
In smaller markets, pre-leasing isn't optional — it's survival. A market with 500,000 people has enough tenant churn that absorption happens organically. A market with 10,000-50,000 people doesn't have that luxury. You need to know your tenants by name before you pour the foundation.
Building Your Development Pro Forma
Most experienced developers build custom Excel models because every deal has enough unique variables that off-the-shelf software can't capture the nuances. Here's what your model needs to include.
The Six Essential Tabs
- Sources & Uses — Where every dollar comes from (senior debt, mezzanine debt, equity, grants, tax credits) and where it goes (land, hard costs, soft costs, reserves, financing costs). These two columns must balance. If they don't, your deal has a gap.
- Construction Draw Schedule — Month-by-month cash outflows during construction. Your construction lender funds draws based on completion milestones verified by a third-party inspector. Model the timing of draws carefully — you pay interest on funds drawn, not on the total commitment.
- Lease-Up Schedule — Month-by-month absorption across your three scenarios. Each new lease should flow into the operating pro forma automatically, building income gradually rather than assuming a magic day when the building goes from empty to full.
- Operating Pro Forma — Year-by-year income and expenses from CO through your exit. Include 3% annual rent growth (or whatever your market supports), realistic expense escalation (insurance and property taxes tend to grow faster than rents), and a capital reserves line for future maintenance.
- Cash Flow Waterfall — How cash gets distributed to stakeholders. Debt service gets paid first, then investor preferred returns, then promote splits. If you're raising outside equity, your investors will scrutinize this page more than any other.
- Sensitivity Analysis — This is the tab that separates amateurs from professionals. Build sensitivity tables showing how your key returns (IRR, cash-on-cash, equity multiple) change when you adjust critical variables: What happens if construction costs increase 10%? 20%? What if lease-up takes 6 months longer than projected? What if market rents come in 10-15% below your assumption? What if your exit cap rate is 100 basis points wider than projected? If your deal falls apart when any single variable moves by 15%, it's too fragile.
Software vs. Spreadsheets
ARGUS Developer is the industry standard for institutional-quality development modeling, but it runs around $5,000/year and has a steep learning curve. For most individual developers, a well-built Excel model is actually better because you understand every formula and assumption. Consider ARGUS when you're underwriting multiple large deals per year and need to present institutional-grade output to lenders and equity partners.
Don't Leave Government Money on the Table
If your project has any community benefit angle — job creation, blight removal, affordable housing component, infrastructure improvement — there's likely grant money available that most developers never pursue because the application process seems intimidating.
CDBG (Community Development Block Grants): If your project serves a low-to-moderate income area or creates jobs, these can cover infrastructure improvements — roads, utilities, parking, sidewalks — that would otherwise come out of your development budget. That's real money back in your pocket.
EDA (Economic Development Administration) Grants: For projects that bring employment to a community, EDA grants can cover 50-80% of infrastructure costs. They require matching funds but can be substantial.
State-Level Programs: Most states have economic development agencies with grants, low-interest loans, and tax incentive programs for commercial development in targeted areas. These vary widely by state but are almost always underutilized.
Opportunity Zones: If your parcel sits in a designated Opportunity Zone, investors in your deal can defer and reduce capital gains taxes, making your equity raise significantly easier and potentially cheaper.
The critical rule: Model your deal without the grant first. If the project only works because of grant funding, that's a red flag. Grants should make a good deal great — they shouldn't be the difference between profitability and loss. Grant timelines are also unpredictable, so your construction schedule needs to accommodate potential delays.
Five Mistakes That Rebuilt My Underwriting Process
1. I Underestimated Soft Costs by Half
On my first development deal, I budgeted 15% of hard costs for soft costs. Architecture, engineering, permits, legal review, lender fees, construction management, interest carry during construction, accounting — the real number was 28%. Now I budget 25-35% of hard costs for soft costs on every deal until I have enough completed projects in a specific market to refine that number with real data.
2. I Built What I Assumed the Market Wanted
Instead of asking the market what it actually needed. Before you finalize your project scope — before you hire an architect, before you apply for permits — talk to 20-30 potential tenants in your market. Ask what size spaces they need, what rent they can pay, what amenities matter. The number of times I've heard "we would have leased that space if only it had X" is painful. Let the market design your building.
3. I Relied on a Single Contractor Bid
Always get 3-5 competitive bids. Use a Guaranteed Maximum Price (GMP) contract with a shared savings clause — you and the contractor split any cost savings, which aligns incentives. Pure fixed-price contracts sound safe but often lead to aggressive change orders. GMP with shared savings gives the contractor motivation to find efficiencies while protecting your budget ceiling.
4. I Ignored the Time Value of My Capital
A deal that produces a 9% annual return sounds solid until you account for 24 months where your equity earned absolutely nothing during construction and lease-up. Simple return calculations hide this. IRR reveals it. I now calculate IRR on every development deal alongside static returns, and several deals that looked good on a napkin became clear passes once the time value of money was factored in.
5. I Modeled Only One Exit
I assumed I'd sell at a 7% cap in year five. What I didn't model: What if cap rates expanded to 8.5% by then? What if the market softened and I needed to hold for 10 years? What if I couldn't find a buyer at any price? Now I model three exit scenarios — optimistic, base, and downside — and the deal must still work in the downside case. If your returns evaporate when cap rates move 100 basis points, you don't have enough margin of safety.
The Bottom Line
Commercial development underwriting isn't about predicting the future — it's about stress-testing your assumptions until only the truth survives. The developers who consistently make money aren't smarter about market timing or construction management. They're more honest about what they don't know, and they build that honesty into every cell of their spreadsheet.
Model conservatively. Pre-lease aggressively. Stress-test relentlessly. And make every deal work on paper in your downside scenario before you put a shovel in the ground.
The upside in development is massive — creating value from nothing is the closest thing to magic in real estate. But the margin for error is thinner than any other strategy. Respect that, and the numbers will take care of themselves.