Commercial Lease Cash Flow Analysis: IRR, NPV, and Cap Rate for Tenant Lease-vs-Buy Decisions (2026)

Why Cash Flow Analysis Matters for Commercial Tenants

A commercial lease is not an expense line—it’s a structured series of cash outflows that spans years or decades. When you sign a 10-year lease, you’re committing to a stream of payments that, in aggregate, often rivals the cost of buying the property outright. The difference is timing, risk allocation, and opportunity cost—and the only way to compare those factors rigorously is through discounted cash flow analysis.

Consider the math on our reference scenario. A $35/SF lease on 10,000 SF with 3% annual escalations generates these nominal cash flows:

• Year 1: $350,000
• Year 5: $394,052 ($35 × 1.03&sup4; = $39.41/SF)
• Year 10: $456,879 ($35 × 1.03&sup9; = $45.69/SF)
• Cumulative 10-Year Total: $4,012,388 (nominal, undiscounted)

But a dollar paid in Year 10 is worth less than a dollar paid today. If your business earns 9% on its capital, that $456,879 Year 10 payment has a present value of only $192,843. This is why NPV analysis fundamentally changes how you evaluate lease proposals. Two leases with the same nominal total cost can have wildly different NPVs depending on their payment structure, escalation timing, and rent abatement provisions.

Cash flow analysis also matters because of ASC 842. Since the 2019 adoption of this accounting standard, operating leases now appear on the balance sheet as right-of-use assets and lease liabilities. The present value of your lease obligation directly affects your debt-to-equity ratio, current ratio, and borrowing capacity. A lease with a $2.48M NPV creates the same balance sheet impact as a $2.48M loan. If your business is planning to raise capital, secure debt financing, or undergo due diligence for acquisition, the NPV of your lease portfolio is a number your CFO needs to know precisely.

Finally, cash flow analysis is the foundation for the lease vs. buy decision. Without it, you’re comparing apples to oranges: monthly rent payments against a purchase price plus mortgage payments plus maintenance. Only by converting both options into equivalent present-value cash flows can you make a genuinely informed decision about which path creates more value for your business.

Understanding Net Present Value (NPV) of Lease Obligations

Net Present Value is the cornerstone of lease financial analysis. It answers a deceptively simple question: what is the total cost of this lease in today’s dollars? By discounting future payments back to the present, NPV allows you to compare lease proposals with different terms, escalation structures, and concession packages on an equal footing.

The NPV Formula for Lease Cash Flows

Worked Example: 10-Year Office Lease NPV

Let’s calculate the NPV for our reference scenario: 10,000 SF at $35/SF base rent, 3% annual escalations, $12.50/SF operating expenses (escalating at 4% annually), 9% discount rate.

This means that if you set aside $3,458,596 today and invested it at 9%, you’d have exactly enough to cover every lease payment for the full 10-year term. This is the true economic cost of the lease—and the number you should compare against the cost of buying.

How Rent Abatement Affects NPV

Suppose the landlord offers 4 months of free rent as a concession. Since those months occur at the start of the lease (when the discount factor is highest), the NPV impact is significant. Four months of free rent on $475,000 annual cost equals $158,333 in nominal savings—but the present value of that savings is $155,882 (because it occurs in Year 1, the discount is minimal). That reduces the lease NPV to $3,302,714. This is why front-loaded concessions are more valuable than back-loaded ones: the time value of money amplifies early savings.

Internal Rate of Return (IRR) for Lease Decisions

While NPV tells you the present value of costs, IRR tells you the implied return rate of a capital allocation decision. For lease analysis, IRR is most useful when comparing the lease option against the buy option—it answers: “What rate of return does buying the property need to achieve for ownership to beat leasing?”

The IRR Formula

Worked Example: Buy-Side IRR Calculation

Let’s model the ownership alternative for our reference scenario. Purchase price: $4,200,000. Financing: 75% LTV at 6.8% interest, 25-year amortization. Down payment: $1,050,000. Closing costs: $84,000 (2%). Annual ownership costs: mortgage debt service + taxes + insurance + maintenance + capital reserves. We assume 2.5% annual appreciation and a sale at end of Year 10.

One critical nuance: IRR is highly sensitive to the terminal value assumption. If we change the appreciation rate from 2.5% to 0% (flat property value), the IRR drops to 6.8%—below the 9% WACC—and the decision flips to favor leasing. If appreciation is 4%, the IRR jumps to 14.1%. This is why sensitivity analysis (covered below) is essential. Never make a lease-vs-buy decision on a single-point IRR estimate.

Cap Rate and Its Role in Lease vs Buy Analysis

Capitalization rate is the simplest valuation metric in commercial real estate, and it serves as a quick-and-dirty filter before you dive into full DCF analysis. Cap rate tells you the unlevered yield a property generates relative to its price—essentially, what return you’d earn if you bought the property with all cash.

From the landlord’s perspective, this is a 7.77% unlevered return. But as a tenant evaluating whether to buy, cap rate tells you something different: it indicates the relationship between rental cost and purchase price. Here’s how to interpret it:

• High cap rate (7%+): The property is “cheap” relative to rental income. Purchase prices are lower per dollar of rent avoided, which generally favors buying. Common in secondary/tertiary markets and value-add properties.
• Mid cap rate (5–7%): Neutral territory. The lease vs. buy decision depends heavily on your cost of capital, tax situation, and appreciation expectations.
• Low cap rate (under 5%): The property is “expensive” relative to rental income. You’re paying a premium for the location or asset quality. Generally favors leasing unless you have strong appreciation conviction.

Cap Rate vs. WACC: The Quick Filter

A useful shortcut: compare the cap rate to your cost of debt. If the cap rate is higher than your mortgage interest rate, you have positive leverage—the property earns more than it costs to finance, and buying becomes more attractive. In our example, the 7.77% cap rate vs. 6.8% mortgage rate creates positive leverage of 0.97 percentage points. This amplifies equity returns through financial leverage, which is part of why the levered IRR (11.4%) exceeds the unlevered cap rate (7.77%).

Building a Lease Cash Flow Model (Step by Step)

A proper lease cash flow model captures every dollar that flows out of your business as a result of occupying a space. Here’s the step-by-step framework, using our reference scenario.

Step 1: Define Base Assumptions

Lock down the inputs before building the model. Every assumption should be documented and sourced.

• Space: 10,000 RSF (rentable square feet)
• Lease term: 10 years, commencing July 1, 2026
• Base rent: $35.00/SF Year 1
• Rent escalation: 3% annually, compounding
• Operating expenses: $12.50/SF Year 1 (NNN pass-through)
• OpEx escalation: 4% annually
• TI allowance: $45/SF ($450,000), amortized over term at 8%
• Free rent: 4 months
• Security deposit: $87,500 (3 months base rent)
• Discount rate: 9% (company WACC)

Step 2: Build the Annual Cash Flow Schedule

For each year, calculate total occupancy cost = base rent + operating expenses + any amortized TI cost above the landlord allowance + parking + tenant-specific costs.

Step 3: Apply Concessions and Adjustments

Subtract free rent months from Year 1. Add the security deposit as a Year 0 outflow and recovery in the final year. Include any restoration cost obligations at lease end. In our scenario, the landlord requires $5/SF restoration ($50,000) at lease expiry.

Step 4: Discount Each Year’s Cash Flow

Apply the discount factor 1/(1+r)^t to each year’s total cost. Sum the results for the NPV.

Discount Rate Selection

The discount rate is the single most impactful variable in your analysis. A 2-percentage-point change in the discount rate can swing the NPV by $200,000–$400,000 on a 10-year office lease and flip the lease vs. buy decision entirely. Getting this number right matters more than perfecting any other input.

Three Approaches to Selecting a Discount Rate

1. Weighted Average Cost of Capital (WACC). This is the theoretically correct rate for most businesses. WACC blends your cost of equity and cost of debt, weighted by your capital structure. For a mid-market company with 60% equity at 12% required return and 40% debt at 6.5% after tax, WACC = (0.60 × 12%) + (0.40 × 6.5%) = 9.8%. Use this if you’re comparing the lease against deploying capital in your core business.

2. Incremental Borrowing Rate (IBR). This is the rate you’d pay to borrow money for a similar term and amount. IBR is the rate required under ASC 842 for calculating the lease liability on your balance sheet. For most mid-market companies in 2026, IBR runs 6.5–8.5%. Use this for balance sheet calculations and when you’re specifically comparing lease financing against debt financing.

3. Opportunity Cost Rate. What return could your capital earn in its next-best alternative use? If you’re a high-growth startup that can deploy capital at 20%+ returns, your opportunity cost is much higher than a stable business earning 8%. Use this when the lease vs. buy decision is fundamentally about capital allocation.

Modeling Rent Escalations and Operating Expenses

Escalation modeling is where most DIY lease analyses fail. Tenants plug in Year 1 rent as a flat assumption for 10 years and understate their true obligation by 18–25%. Here’s how to model escalations correctly.

Fixed Percentage Escalations

Most common structure: rent increases by a fixed percentage (typically 2.5–3.5%) annually. The formula is straightforward:

CPI-Based Escalations

Some leases tie escalations to the Consumer Price Index, often with a floor and cap (e.g., CPI with a 2% floor and 5% cap). Model these using three scenarios: CPI at the floor (best case), CPI at the historical average (base case, ~3.2% in 2026), and CPI at the cap (worst case). The difference between floor and cap scenarios over 10 years can be $150,000–$300,000 for our reference space.

Operating Expense Escalations

Operating expenses typically escalate faster than base rent because they’re driven by property taxes (3–5% annual increases), insurance premiums (5–10% increases since 2023), and labor costs for maintenance and janitorial (3–4% annually). Model OpEx escalation at 4–5% annually—higher than your rent escalation rate. In our reference scenario, $12.50/SF OpEx at 4% annual escalation grows to $17.80/SF by Year 10, adding $53,000 more per year than a flat OpEx assumption would suggest.

Total Occupancy Cost Analysis

Total Occupancy Cost (TOC) is the only number that truly represents what you pay to occupy a space. It includes everything: base rent, operating expenses, utilities, parking, tenant-funded improvements, moving costs, and even the amortized cost of the time your team spends managing the landlord relationship. For financial analysis, we focus on the quantifiable components.

That $59.25/SF is the number that matters for budgeting, financial planning, and comparison against the ownership alternative. When a landlord quotes $35/SF and you model at $35/SF, you’re understating your true cost by $24.25/SF—or $242,500 per year. Over a 10-year term with escalations, the cumulative understatement approaches $3 million.

TOC Benchmarks by Property Type (2026)

• Class A Office (Suburban): $55–$72/SF TOC (base rent represents 55–65% of TOC)
• Class A Office (CBD): $75–$120/SF TOC (base rent represents 50–60% of TOC)
• Retail (Inline, NNN): $35–$65/SF TOC (base rent represents 45–55% of TOC)
• Industrial/Warehouse: $12–$22/SF TOC (base rent represents 60–70% of TOC)
• Medical Office: $45–$85/SF TOC (base rent represents 50–60% of TOC)

Lease vs Buy Decision Framework

With NPV, IRR, cap rate, and TOC in hand, you can now build a rigorous comparison. The framework below uses our reference scenario to walk through a complete 10-year lease vs. buy analysis.

In this specific scenario, the numbers favor buying: the buy-side IRR of 11.4% exceeds the 9% WACC, and the NPV of ownership (including terminal value) is $1,562,603 lower than the NPV of leasing. However, this conclusion is highly sensitive to three assumptions: appreciation rate, hold period, and discount rate. Change any one of them materially, and the answer can flip.

Sensitivity Analysis and Scenario Planning

Single-point estimates are dangerous. The real value of cash flow analysis comes from understanding how the decision changes under different assumptions. Here are the four variables you must stress-test, along with the impact on our reference scenario.

Variable 1: Discount Rate (WACC)

At 7% WACC, buy wins by $1.82M in NPV. At 11% WACC, buy wins by only $412K. At 13% WACC, the advantage narrows to $89K—essentially a coin flip that should be decided on qualitative factors like flexibility and operational control.

Variable 2: Property Appreciation

This is the highest-impact variable. At 0% appreciation, lease wins. At 2.5%, buy wins moderately. At 4%, buy wins convincingly. The crossover point is 1.1% annual appreciation—below that, leasing is favored; above it, buying is favored (at our 9% WACC).

Variable 3: Lease Escalation Rate

Higher escalations make leasing more expensive (higher NPV), which favors buying. At 2% escalation instead of 3%, the lease NPV drops by $287,000, narrowing the buy advantage. At 4% escalation, the lease NPV increases by $312,000, widening the buy advantage.

Variable 4: Hold Period

Buying becomes more favorable over longer hold periods because you amortize the high transaction costs (entry and exit) over more years. In our scenario, the buy NPV advantage is negative for hold periods under 6 years (meaning leasing wins for short commitments), breaks even at approximately 6.3 years, and grows significantly beyond 10 years. If there’s any chance you’ll need to relocate within 5 years, leasing almost always wins.

Cash Flow Analysis Checklist

Before finalizing any lease financial analysis, verify you’ve addressed every item below. Missing even one can skew your NPV by $50,000–$200,000.

• Defined discount rate using WACC, IBR, or opportunity cost—documented the rationale and source
• Modeled base rent with escalations year-by-year using the exact contractual terms (fixed %, CPI, or step schedule)
• Modeled operating expenses separately from base rent with their own escalation rate (typically 4–5% annually)
• Included all occupancy costs: utilities, parking, tenant insurance, janitorial, after-hours HVAC, and storage
• Accounted for rent abatement and free rent periods in the correct months/years of the model
• Included TI amortization for any tenant-funded improvements above the landlord allowance
• Added security deposit as a Year 0 cash outflow and recovery at lease termination
• Included lease-end restoration costs based on the contractual demolition/restoration clause
• Calculated NPV of total lease obligation using consistent annual (or monthly) discounting
• Computed buy-side IRR with all ownership costs: mortgage, taxes, insurance, maintenance, capex reserves, and net sale proceeds
• Verified cap rate against market comparables to ensure the purchase price is reasonable
• Ran sensitivity analysis on at least 3 variables: discount rate, appreciation, and hold period
• Documented all assumptions with sources so the analysis can be reviewed and updated as market conditions change
• Compared at least 2–3 lease proposals on the same NPV basis to isolate the impact of different deal structures

Frequently Asked Questions

Final Thoughts

Commercial lease cash flow analysis isn’t optional—it’s the minimum standard of financial rigor for any occupancy decision involving six or seven figures of committed capital. The math is not complex: NPV, IRR, and cap rate are tools that any finance team can apply. What’s complex is getting the inputs right—capturing every cost, selecting an appropriate discount rate, modeling escalations realistically, and stress-testing the assumptions that drive the decision.

The most important takeaway from this guide: never compare lease vs. buy on a single-point estimate. Your analysis should produce a range of outcomes across at least three discount rates, three appreciation scenarios, and two or three hold periods. If the answer is the same in most scenarios, proceed with confidence. If it’s a close call, let qualitative factors—operational flexibility, core business focus, growth uncertainty—break the tie.

In our reference scenario, buying edged out leasing under moderate assumptions (11.4% IRR vs. 9% WACC, 2.5% appreciation). But the margin was narrow enough that a business with high growth, uncertain space needs, or a WACC above 11% would rationally choose to lease. The right answer depends on your specific circumstances. The wrong answer is making the decision without running the numbers.

Whether you ultimately lease or buy, the cash flow model you build becomes an ongoing management tool. Update it annually with actual escalations, actual operating expenses, and revised market assumptions. Track your TOC per SF against industry benchmarks. And when your lease comes up for renewal or your ownership assumptions change, you’ll have the framework ready to re-evaluate the decision with precision instead of guesswork.