Commercial Real Estate IRR Calculator

This calculator requires four categories of inputs: (1) property details including purchase price, closing costs, and renovation CapEx; (2) debt financing terms including down payment percentage, interest rate, amortization period, and loan term; (3) master lease parameters including Year 1 base rent, annual escalation, landlord operating expenses, and CapEx reserve; and (4) exit assumptions including holding period, exit cap rate, and selling costs. All inputs can be set to industrial or hospitality defaults using the asset type toggle.

Exit cap rate is the single most impactful variable in a commercial real estate IRR model because it determines the terminal sale price — which often represents 50–70% of total cash flows in a 5–10 year hold. A 50 basis point decrease in exit cap rate can increase a property's sale price by 8–12%, dramatically boosting total IRR. Conversely, cap rate expansion at exit can severely impair returns even with strong operating performance. This is why the sensitivity matrix in this calculator defaults to varying exit cap rates across seven scenarios.

The equity multiple (MOIC) tells you the absolute multiple of your money returned, independent of time. A 2.0x equity multiple means you received $2 for every $1 invested. IRR can be misleadingly high on a very short hold (e.g., 30% IRR on a 2-year flip producing only 1.5x equity multiple) and can appear lower on a longer hold that generates a much higher absolute return. For LP investors and fund performance measurement, equity multiple is often as important as IRR for evaluating deal quality.

This calculator uses institutional-standard methodology: the bisection method for IRR computation, amortizing loan balance calculations, and cap-rate-based terminal valuation. It models fixed rent escalations, NNN expense structures, and levered cash flows precisely as institutional underwriters do. For a full institutional model you would additionally layer in depreciation, tax-advantaged returns, variable rent structures, reserve buildups, and refinancing events — but for rapid deal screening and sensitivity analysis, this calculator provides a high-fidelity first pass that closely approximates professional underwriting output.

Commercial lenders — including CMBS conduit lenders, life insurance companies, regional banks, and debt funds — typically require a minimum DSCR of 1.20x to 1.35x at loan origination. Well-located industrial master lease assets with investment-grade tenants may qualify for more favorable underwriting at 1.20x DSCR, while hospitality and specialty assets may require 1.30x–1.40x or higher. A DSCR below 1.0x means the property does not generate sufficient NOI to cover debt service and will not qualify for permanent financing.

The sensitivity matrix shows levered IRR across six hold periods (rows) and seven exit cap rate scenarios (columns), with all other assumptions held constant. Use it to identify your deal's margin of safety: determine the worst-case exit cap rate scenario at your target hold period that still meets your IRR hurdle rate. If your deal only works at the absolute best-case cap rate, it carries significant refinancing and exit risk. Ideally, your IRR target should be met under at least two or three exit cap rate scenarios, providing buffer against market conditions at the time of disposition.