Analyzing a commercial real estate deal can feel like a daunting task, filled with complex jargon and intimidating spreadsheets. But the truth is that professional investors don’t rely on guesswork or gut feelings. They follow a systematic, disciplined process to vet hundreds of deals and identify the select few that meet their rigorous criteria. It’s a process designed to kill bad deals quickly and elevate good deals for deeper consideration. Whether you’re evaluating a multifamily apartment building or an industrial warehouse portfolio, the analytical framework is fundamentally the same.

This guide will pull back the curtain on that exact process. We will walk you through the 5-step framework that professional acquisition teams use to analyze a commercial real estate deal, from the initial back-of-the-napkin screening to the final investment committee memo. If you’re newer to the asset class, start with our complete guide to commercial real estate investing for foundational context. By the end, you will have a practical, actionable playbook for analyzing deals with confidence and clarity.

Step 1: The 5-Minute Sanity Check (The Napkin Test)

Before you ever open a spreadsheet, the first step is a quick mental sanity check. The goal here is to kill bad deals in under five minutes. You are looking for any glaring red flags in the three core assumptions of any deal: the purchase price, the Net Operating Income (NOI), and the capitalization (cap) rate. The seller’s offering memorandum (OM) will present the deal in the best possible light. Your job is to apply a dose of healthy skepticism.

Ask yourself: Does the story make sense? If the seller is claiming a 5% cap rate in a market where similar properties are trading at a 6% cap rate, you need to understand why. Is the property significantly higher quality? Is there a long-term lease with a credit tenant? Or are the seller’s income projections simply unrealistic? Cross-reference the stated cap rate with CBRE’s U.S. Cap Rate Survey, which publishes quarterly benchmarks across property types and markets. If you can’t quickly get comfortable with the basic story of the deal, it’s time to move on. There will always be another one.

I also check whether the property fits within the broader macro environment. If cap rates are compressing across the board, the seller’s pricing may be ahead of the market—or it may be justified by strong fundamentals. Context matters. Pull up the latest NCREIF Property Index data to see how the relevant asset class has performed over the trailing four quarters. A five-minute sanity check grounded in real market data will save you weeks of wasted underwriting effort.

Step 2: Building the Initial Pro Forma (The Story in Numbers)

If a deal passes the initial sanity check, the next step is to build a pro forma. A pro forma is simply a financial projection of the property’s performance over a set period, typically 5 or 10 years. This is where you translate the “story” of the deal into numbers. This is the heart of the underwriting process, and where you’ll spend the bulk of your time when you analyze a commercial real estate deal.

Revenue Assumptions

Your revenue projections will be driven by your assumptions about rent growth, vacancy, and other income. Be conservative. It’s always better to be pleasantly surprised than unpleasantly disappointed. Look at the historical performance of the property and the submarket to inform your projections. Are rents in the area growing at 3% or 5%? Is the property historically 95% occupied or 90%? Don’t just take the seller’s numbers at face value.

Dig into the rent roll line by line. Compare each tenant’s in-place rent to current market comps. If the property is significantly below market, that’s an upside opportunity—but only if you have a realistic plan and budget to capture it through lease turnover or renewal negotiations. Conversely, if rents are above market, you need to underwrite a haircut at lease expiration. Thorough market research for commercial real estate is non-negotiable at this stage.

Expense Assumptions

Your expense assumptions should be equally well-researched. The biggest line items will typically be property taxes, insurance, and property management fees. For property taxes, don’t assume they will stay the same. In many jurisdictions, the property will be reassessed at the new, higher purchase price, which can lead to a significant increase in taxes. For repairs and maintenance, a good rule of thumb is to budget a certain amount per unit per year, which will vary depending on the age and condition of the property.

One expense that frequently catches first-time commercial buyers off guard is the management fee structure. Third-party property management typically runs 3-8% of effective gross income depending on asset size and type, but the real cost often includes leasing commissions, construction management fees, and administrative charges layered on top. Request the seller’s actual T-12 (trailing twelve months) operating statement—not the recast version in the OM—and reconcile every line item against your own assumptions.

Capital Expenditure (CapEx) Assumptions

This is one of the most common areas where inexperienced investors get into trouble. Capital expenditures are the big-ticket items that don’t show up on the profit and loss statement—things like a new roof, a new HVAC system, or a parking lot repaving. These are real costs that will impact your cash flow, and they need to be budgeted for. A good property condition report from a qualified engineer will help you identify and quantify these future costs.

I generally separate CapEx into two buckets: deferred maintenance (items that need attention in years 1-2) and replacement reserves (an annual set-aside for future capital needs). Deferred maintenance should be funded at close, either through a holdback or by adjusting the purchase price. Replacement reserves of $250-$500 per unit per year are standard for multifamily, though older assets or properties with deferred maintenance histories may warrant more. Getting the CapEx budget right is essential if you want to maximize ROI on your commercial real estate investment.

Step 3: The Four Pillars of Return Metrics

Once you have built your pro forma, you can calculate the key return metrics that will tell you whether the deal is worth pursuing. No single metric tells the whole story. You need to look at the deal through four different lenses to get a complete picture. This multi-metric approach is what separates a thorough analysis from a back-of-the-envelope guess.

Cap Rate

The cap rate is the unlevered yield on the investment. It is calculated by dividing the NOI by the purchase price. It is a quick and easy way to compare the relative value of different properties, but it doesn’t account for the impact of debt or the potential for future appreciation. Think of the cap rate as a snapshot—it tells you what the property yields on day one, assuming an all-cash purchase.

Keep in mind that cap rates vary significantly by asset class, location, and market cycle. A 4.5% cap on a Class A multifamily property in a gateway market may represent excellent relative value, while the same cap rate on a single-tenant retail asset in a secondary market could signal significant risk. Always benchmark against the relevant peer set, not a blanket “good” or “bad” threshold.

Cash-on-Cash Return

The cash-on-cash return is the levered yield. It is calculated by dividing the annual pre-tax cash flow by the total cash you have invested in the deal. This metric is important because it tells you how much cash you can expect to put in your pocket each year relative to what you’ve committed. It’s the metric that matters most to investors focused on current income.

The cash-on-cash return is heavily influenced by your commercial real estate financing structure. A deal with aggressive leverage will show a higher cash-on-cash return in good times—but it also amplifies the downside. This is why you need to evaluate this metric in conjunction with the debt terms, not in isolation.

Internal Rate of Return (IRR)

The IRR is the most comprehensive measure of a deal’s total return because it accounts for the time value of money. It is the annualized rate of return that you earn over the life of the investment, taking into account both the annual cash flow and the profit you make when you sell the property. It is a complex calculation that is best left to a spreadsheet, but it is the industry standard for measuring the total return of a real estate investment.

One critical nuance: IRR is highly sensitive to your exit assumptions, particularly the terminal cap rate and holding period. A deal that projects a 20% IRR over a 3-year hold may look compelling, but if it’s predicated on aggressive cap rate compression at exit, the actual realized return could be far lower. Always run your IRR under multiple exit scenarios. This is especially important when evaluating syndication opportunities, where the sponsor’s projected returns may rely on optimistic reversion assumptions.

Equity Multiple

The equity multiple is the simplest measure of your total return. It is calculated by dividing the total cash you receive over the life of the investment (from both cash flow and the final sale) by the total cash you initially invested. An equity multiple of 2.0x means you have doubled your money. It is a simple and intuitive way to understand the overall profitability of a deal.

Where the equity multiple shines is in communicating the absolute magnitude of returns. An investment with a 15% IRR over 3 years produces a very different equity multiple than a 15% IRR over 7 years—and the difference matters when you’re allocating capital across a portfolio. Institutional investors typically target a 1.7x-2.5x equity multiple depending on the risk profile and strategy, according to J.P. Morgan’s real estate research.

Step 4: Stress-Testing Your Assumptions (Where Deals Go to Die)

Your pro forma is only as good as its assumptions. Now it’s time to try and break it. The goal of stress-testing is to understand how sensitive your returns are to changes in your key assumptions. What happens if things don’t go according to plan? This is where disciplined investors separate themselves from the crowd—they actively look for reasons to kill a deal, not reasons to justify it.

Sensitivity Analysis

A sensitivity analysis is a simple exercise where you change one of your key assumptions and see how it impacts your returns. What happens to your IRR if interest rates go up by 1%? What happens to your cash-on-cash return if rent growth is flat for two years? This will help you identify the biggest risks in the deal and understand the potential downside.

Build a matrix that shows your IRR and equity multiple under combinations of exit cap rate and rent growth assumptions. Most professional shops run at least a “base,” “downside,” and “severe downside” case. The downside case should not be catastrophic—it should reflect a plausible adverse scenario, such as a mild recession or a supply glut in the submarket. If the deal still generates an acceptable return under the downside case, you have a reasonable margin of safety. Having a well-defined exit strategy is equally critical, because your reversion assumptions drive a disproportionate share of total returns.

Break-Even Occupancy

The break-even occupancy is the point at which the property is generating just enough income to cover its operating expenses and debt service. It is a critical metric for understanding the property’s margin of safety. If the current occupancy is 95% and the break-even occupancy is 85%, you have a 10% cushion before you start losing money. The higher the cushion, the lower the risk.

I pay close attention to how the break-even occupancy compares to the submarket’s historical trough occupancy. If the market has never dipped below 88% occupied in the last two cycles, and your break-even is 84%, that’s a comfortable position. But if the market has historically dropped to 80% during downturns and your break-even is 82%, you’re operating with essentially no margin. This single metric can tell you more about a deal’s risk profile than pages of narrative. Deloitte’s commercial real estate outlook provides useful macro context for calibrating your downside scenarios against current market conditions.

Step 5: The Investment Committee Memo (The Final Verdict)

The final step in the underwriting process is to synthesize all of your analysis into a concise and compelling investment committee memo. This is the document that you will use to make your final “go” or “no-go” decision. It should tell the story of the deal, summarize the key numbers, and make a clear recommendation. Even if you are a solo investor without a formal committee, writing a memo forces clarity of thought and guards against confirmation bias.

The Narrative

The memo should start with a brief narrative that tells the story of the deal. What is the property? Where is it located? What is the business plan? Why is this a good investment opportunity right now? The narrative should be compelling but honest—if there are warts, acknowledge them and explain why you believe the risk is manageable.

A strong narrative connects the property’s micro-level fundamentals (rent roll quality, physical condition, competitive positioning) to the macro-level thesis (population growth, employment trends, supply pipeline). The best investment memos I’ve read could be understood by someone with no real estate background, because they explained the “why” before drowning the reader in numbers.

The Numbers

The memo should include a summary of the key return metrics from your pro forma, as well as the results of your sensitivity analysis. This is where you show your work and prove that the deal is financially sound. Present the base case, downside, and severe downside returns side by side so the reader can quickly assess the risk-reward tradeoff.

The Recommendation

The memo should end with a clear and concise recommendation. Based on your analysis, do you recommend moving forward with the deal? Why or why not? This is where you put a stake in the ground and make a decision. Include the specific terms you’re willing to offer—purchase price, earnest money, due diligence period, and any contingencies—so the recommendation is actionable, not theoretical.

Frequently Asked Questions (FAQ)

What is the most important metric when analyzing a commercial real estate deal?

There is no single “most important” metric. You need to look at all four pillars of return—Cap Rate, Cash-on-Cash Return, IRR, and Equity Multiple—to get a complete picture of a deal’s potential. Each metric answers a different question: Cap Rate measures unlevered yield, Cash-on-Cash measures annual income on your invested capital, IRR captures total time-weighted return, and Equity Multiple shows absolute wealth creation. Relying on just one is like judging a property by its curb appeal alone.

What software do professionals use to analyze commercial real estate deals?

While there are many sophisticated software programs available—ARGUS Enterprise, CoStar, and RealPage among them—the vast majority of professional real estate analysis is still done in Microsoft Excel. It is the industry standard for a reason: flexibility. Every deal is different, and Excel lets you build a model that reflects the specific nuances of the asset, the market, and the business plan. That said, platforms like ARGUS are increasingly required for institutional-quality underwriting of larger assets with complex lease structures.

How do I know if my deal assumptions are realistic?

The best way to ensure your assumptions are realistic is to base them on solid market research. Talk to brokers, property managers, and other investors in the market to get their take on rent growth, vacancy, and operating expenses. Pull comparable sales and lease comps from CoStar or your local MLS. Review the property’s actual T-12 operating history rather than relying solely on the seller’s pro forma projections.

How long does it take to properly analyze a commercial real estate deal?

For an experienced analyst, the initial screening (Step 1) takes about 5-10 minutes. Building and refining the pro forma (Steps 2-4) typically takes 4-8 hours for a straightforward deal, and can extend to 20+ hours for complex assets with multiple tenants, ground leases, or value-add components. The investment memo (Step 5) adds another 2-4 hours. Rushing the process to beat a deadline is one of the most expensive mistakes you can make in this business.

Conclusion: From Analysis to Action

Learning to analyze a commercial real estate deal is a skill that compounds over time. The more deals you underwrite, the faster your pattern recognition develops and the sharper your instincts become. By following the disciplined, systematic 5-step process outlined in this guide—screening, pro forma construction, return analysis, stress-testing, and the final memo—you can dramatically improve your ability to identify good deals and avoid bad ones.

This framework is the same one that professional acquisition teams at institutional shops use every day to deploy billions of dollars in capital. It works for a $2 million strip center just as well as it works for a $200 million office portfolio. The key is consistency: apply the same rigor to every deal, and let the process—not your emotions—drive the decision. Ready to go deeper? Explore our guides on financing your next acquisition and structuring a syndication to round out your dealmaking toolkit.