Operating Cash Flow Projection for Commercial Real Estate: Every Driver, Assumption Benchmark, and Sensitivity Test

Key Takeaways

The Operating Cash Flow Framework

Every commercial real estate pro forma follows the same structural logic. Revenue starts at the top with the maximum possible income the property could generate if every unit or suite were leased at market rent with no collection losses. From that ceiling, a series of deductions reduce the number to what the property actually collects. Operating expenses then reduce collected revenue to the income the property generates from operations. Below-the-line items capture the costs of maintaining the asset and servicing debt.

The framework is universal across asset classes, but the relative weight of each component shifts dramatically depending on whether you are modeling a 200-unit multifamily property, a single-tenant industrial warehouse on a triple-net lease, or a multi-tenant office building with a 40% expense load. The framework stays the same. The assumptions change everything.

The cascade runs in this order:

1. Gross Potential Rent (GPR) is the total rent the property would collect if every space were leased at current market rents with zero vacancy.
2. Less: Vacancy and Credit Loss reduces GPR by the estimated percentage of space that will sit empty and the estimated percentage of billed rent that tenants will not pay.
3. Less: Concessions accounts for free rent, tenant improvement allowances amortized over the lease term, and other inducements that reduce effective rent below the stated contract rate.
4. Plus: Other Income adds revenue streams beyond base rent: parking, laundry, storage, antenna leases, late fees, pet fees, application fees, and percentage rent in retail.
5. Equals: Effective Gross Income (EGI) is the total revenue the property is expected to collect.
6. Less: Operating Expenses covers all costs of running the property: property taxes, insurance, utilities, repairs and maintenance, management fees, general and administrative costs, and any other recurring operating costs.
7. Equals: Net Operating Income (NOI) is the income remaining after operating expenses. This is the metric that drives property valuation through the capitalization rate.
8. Less: Below-the-Line Items includes capital expenditure reserves, tenant improvement costs, leasing commissions, and debt service. These items reduce NOI to the cash flow that actually reaches equity holders.
9. Equals: Levered Cash Flow (also called cash flow after debt service or distributable cash flow) is the amount available for distribution to equity investors.

Understanding this cascade is essential because the quality of a cash flow projection depends entirely on the quality of the assumptions behind each line item. A model with perfectly structured formulas and a polished presentation is worthless if the rent growth assumption is too aggressive or the vacancy assumption does not reflect the property's competitive position. The rest of this article walks through each driver, provides assumption benchmarks by asset class, and shows how to test the model's sensitivity to changes in key inputs.

Revenue Drivers: From Gross Potential Rent to Effective Gross Income

The revenue side of the pro forma is where most of the valuation variance lives. Small changes in rent growth or vacancy assumptions compound over a 5-year or 10-year hold period, producing large differences in cumulative cash flow and terminal value. Getting the revenue drivers right is the single highest-leverage activity in cash flow projection.

Gross Potential Rent (GPR)

GPR is the starting point. It represents the total annual rent the property would generate if every rentable unit or suite were leased at the assumed market rent with no vacancy, no credit loss, and no concessions. For multifamily properties, GPR equals the number of units multiplied by the average monthly rent multiplied by twelve. For office and industrial properties, GPR equals the total rentable square footage multiplied by the annual rent per square foot.

The base rent assumption should reflect current in-place rents for occupied spaces and achievable market rent for vacant spaces. For a stabilized property with a known rent roll, base rent in Year 1 is a factual input derived from signed leases. The projection question is what happens in Years 2 through 10 as leases roll and market conditions evolve.

CBRE's 2026 U.S. Real Estate Market Outlook provides sector-level rent growth forecasts that serve as a useful benchmark for market-level assumptions. As of mid-2026, CBRE forecasts multifamily rent growth in the low single digits nationally, with significant regional variation driven by new supply delivery patterns. Industrial rent growth has moderated from the double-digit pace of 2021 to 2022 but remains positive. Office rent growth is flat to slightly negative in most markets outside the Sun Belt.

Rent Growth Assumptions

Rent growth is the most consequential assumption in the model. A property generating $2 million in Year 1 rent that grows at 3% annually produces $2.69 million in Year 10. The same property growing at 2% produces $2.39 million. The $300,000 annual difference in Year 10 alone capitalizes to $4 million to $6 million in terminal value at a 5% to 7% cap rate.

Institutional underwriters typically set rent growth assumptions using three inputs: submarket historical rent growth (trailing 5-year and 10-year averages from CoStar, RealPage, or Yardi Matrix), forward supply/demand analysis (pipeline deliveries relative to projected absorption), and the property's competitive position within its submarket (vintage, amenity package, location quality).

Common rent growth assumptions by asset class as of mid-2026:

• Multifamily: 2.0% to 3.5% annually for stabilized properties in balanced markets. Markets with heavy supply pipelines (Austin, Nashville, Phoenix) may warrant 1.0% to 2.0% near-term assumptions that revert to 2.5% to 3.0% as deliveries taper.
• Industrial: 2.5% to 4.0% for well-located infill properties. Speculative space in markets with high vacancy (Dallas-Fort Worth exurban, Inland Empire fringe) may see flat to 1.5% growth until absorption catches up with recent deliveries.
• Office: 0% to 2.0% for Class A properties in strong submarkets. Class B and C office in most markets should be modeled at flat to negative rent growth unless there is a specific repositioning thesis.
• Retail: 1.5% to 3.0% for grocery-anchored neighborhood centers. Unanchored strip retail and power centers face more pressure and warrant 0% to 1.5% assumptions.

Vacancy and Credit Loss

Vacancy represents the percentage of rentable area expected to be unoccupied at any given time. Credit loss represents the percentage of billed rent that will go uncollected due to tenant defaults, payment delays, or write-offs. The two are modeled together because they both reduce the amount of rent the property actually receives.

Vacancy assumptions should reflect four factors: the property's historical occupancy (trailing 3-year average), the submarket vacancy rate, the property's competitive position relative to the submarket, and the lease rollover schedule (years with heavy lease expirations warrant higher vacancy reserves).

Typical stabilized vacancy assumptions:

• Multifamily: 4% to 7% economic vacancy (physical vacancy plus credit loss). CBRE's 2026 forecast holds national multifamily vacancy at approximately 4.9%, but this masks significant variation. Sun Belt markets with heavy deliveries are running 6% to 8%. Supply-constrained coastal markets remain below 4%.
• Industrial: 3% to 6% for single-tenant properties with long-term leases. Multi-tenant flex/industrial carries 5% to 10% depending on the tenant mix.
• Office: 8% to 15% for stabilized Class A properties. Class B properties in most markets should model 12% to 20% vacancy, reflecting the structural demand shift away from lower-quality office space.
• Retail: 3% to 6% for grocery-anchored centers. 8% to 15% for unanchored retail depending on location and tenant quality.

Credit loss is typically 0.5% to 2.0% of GPR for institutional-quality properties. Multifamily credit loss tends to run higher (1% to 3%) because residential tenants default more frequently than commercial tenants. Office and industrial credit loss on investment-grade tenants can be modeled at 0.25% to 0.5%.

Concessions

Concessions are inducements offered to tenants to lease or renew. In multifamily, concessions typically take the form of free rent (one or two months free on a 12-month lease). In office and retail, concessions include free rent, tenant improvement allowances above building standard, and reduced escalation structures.

Concessions reduce the effective rent below the stated contract rent. A multifamily unit leased at $2,000 per month with one month free on a 12-month lease has an effective rent of $1,833 per month, which represents an 8.3% concession rate. In soft office markets, concession packages can exceed 15% to 20% of gross rent when free rent periods extend to 6 to 12 months on a 10-year lease.

The critical modeling point is that concessions are cyclical and correlated with vacancy. When markets are tight, concessions disappear. When markets soften, concessions and vacancy rise together. A model that holds concessions constant while varying vacancy misses this correlation and will overstate revenue in downside scenarios.

Other Income

Other income captures all revenue beyond base rent. The composition varies by asset class. For multifamily properties, other income typically represents 5% to 12% of total revenue and includes parking ($50 to $200 per space per month in urban markets), storage unit rentals, laundry revenue (declining as in-unit washers become standard), pet fees ($25 to $75 per month), amenity fees, late payment fees, and utility reimbursements (RUBS programs).

For office properties, other income includes parking revenue, antenna and rooftop leases, signage fees, and after-hours HVAC charges. For retail, percentage rent (a share of tenant gross sales above a specified breakpoint) can be a meaningful other income line, particularly for regional malls and lifestyle centers.

Other income should be modeled with the same rigor as base rent. Parking revenue assumptions should reflect the property's parking ratio relative to demand, current pricing, and the competitive market. Pet income should reflect the property's pet policy and the market penetration of pet ownership among the renter demographic. Generic "other income grows at 2%" assumptions miss the opportunity to capture value in specific line items.

Operating Expense Drivers

Operating expenses are the costs of running the property on a day-to-day basis. They exclude capital expenditures, tenant improvements, leasing commissions, and debt service. The operating expense ratio (total operating expenses divided by EGI) is a widely used metric for benchmarking property-level efficiency, but the ratio alone is insufficient for projection purposes. Each expense category has its own growth driver, and aggregating them into a single line item with a flat inflation rate masks important cost dynamics.

IREM's Income/Expense IQ platform provides operating expense benchmarks by property type and region. The data, drawn from thousands of property submissions across the U.S., offers a useful reference point for validating whether a property's expense profile is consistent with institutional norms.

Property Taxes

Property taxes are the largest single operating expense for most commercial properties, typically representing 25% to 40% of total operating expenses. The tax bill is a function of the assessed value (set by the local assessor) multiplied by the mill rate (set by the taxing jurisdiction). Both components can change, and both should be modeled explicitly.

For stabilized properties in states without assessment caps (most commercial properties are not protected by Proposition 13-style limits), the assessed value tracks market value with a lag of one to three years. When property values rise, reassessment follows. When values decline, owners must proactively file appeals to reduce the assessment.

A critical projection issue is the reassessment at sale. In many jurisdictions, the property is reassessed to the purchase price upon transfer of ownership. A property acquired at a 30% premium to the prior owner's basis can see a 30% increase in property taxes immediately upon closing. This "pop" in property taxes must be modeled in Year 1 of the acquisition pro forma. Modeling property taxes based on the seller's historical tax bill without adjusting for the reassessment is one of the most common errors in acquisition underwriting.

Property tax growth assumptions typically range from 2% to 4% annually after the reassessment year, reflecting a combination of assessed value growth and potential mill rate increases. In high-tax jurisdictions (Texas, Illinois, New Jersey), property taxes can exceed $5 to $8 per square foot for office and retail properties.

Insurance

Property insurance has undergone a structural repricing since 2022. Catastrophe-exposed markets (Florida, California, Gulf Coast, tornado-prone Midwest) have seen premium increases of 20% to 40% or more over the past three years. Even properties in non-catastrophe zones have experienced 10% to 15% annual increases as reinsurers pass higher global catastrophe costs through to the primary market.

Insurance premiums for commercial properties typically run $0.15 to $0.50 per square foot for standard property and liability coverage. Properties in catastrophe zones, particularly coastal Florida and earthquake-prone California, can see all-in premiums of $1.00 to $3.00 per square foot, with wind and earthquake coverages priced separately and often requiring higher deductibles.

Modeling insurance at a flat 3% annual growth rate does not capture the current environment. For properties in catastrophe-exposed regions, insurance should be modeled at 8% to 15% annual growth for the near-term (Years 1 through 3) with a gradual reversion to 3% to 5% as the market stabilizes. For properties in non-catastrophe zones, 4% to 6% annual growth is a more appropriate near-term assumption.

Utilities

Utility costs (electricity, gas, water, sewer, trash removal) are a significant operating expense for properties where the landlord pays utilities directly. In multifamily properties with master-metered utilities, the landlord's utility bill can represent 8% to 15% of EGI. In office buildings, the landlord typically pays electricity for common areas and HVAC, with tenants reimbursing base-year excess through escalation clauses.

The allocation of utility costs between landlord and tenant is a function of the lease structure. Gross leases place the utility cost on the landlord. Modified gross leases may pass through specific utility costs above a base year. Triple-net leases push all utility costs to the tenant. The lease structure determines whether utility inflation is a landlord expense risk or a tenant expense risk.

Utility cost growth assumptions should reflect regional energy market conditions. National average electricity prices have increased approximately 4% to 6% annually over the past three years, driven by natural gas price volatility, grid infrastructure investment, and the transition to renewable sources. Water and sewer rates have increased at similar or higher rates in many municipalities as aging infrastructure requires replacement funding.

Repairs and Maintenance

Repairs and maintenance (R&M) covers the ongoing cost of keeping the property in operating condition: HVAC servicing, plumbing repairs, electrical maintenance, painting, landscaping, snow removal, pest control, and common area upkeep. R&M is distinct from capital expenditures, which cover major system replacements that extend the useful life of the asset.

The line between R&M and capital expenditures is a judgment call that affects both the operating cash flow projection and the property's tax treatment. Replacing a single HVAC rooftop unit is a capital expenditure. Servicing and maintaining the unit annually is R&M. The distinction matters because R&M reduces NOI (and therefore assessed value for tax purposes), while capital expenditures do not.

R&M costs typically run $0.50 to $2.00 per square foot for multifamily and office properties, with the range driven by building age, mechanical system complexity, and climate. Older buildings with aging systems (built before 1990) tend to cluster at the high end. Newer properties with modern, energy-efficient systems run leaner. Industrial properties with minimal landlord-responsible space have the lowest R&M costs at $0.15 to $0.50 per square foot.

Management Fees

Property management fees compensate the on-site and regional management team for leasing, tenant relations, rent collection, vendor management, financial reporting, and regulatory compliance. Management fees are typically structured as a percentage of EGI, though some contracts use a flat fee or a combination of a base fee plus a percentage.

Standard management fee benchmarks:

• Multifamily: 3% to 5% of EGI for institutional properties over 150 units. Smaller properties (under 100 units) may pay 5% to 7% due to the fixed costs of staffing a management operation. Self-managed owner-operators sometimes model 0% management fees, but institutional underwriters always include a market-rate management fee because the buyer of the property will incur this cost.
• Office: 3% to 5% of EGI, sometimes with a separate leasing commission structure for the management company's in-house leasing team.
• Industrial: 2% to 4% of EGI. NNN properties with single tenants require less active management and command lower fees.
• Retail: 3% to 6% of EGI, with higher fees for properties requiring active tenant merchandising and event programming.

General and Administrative (G&A)

G&A covers costs that do not fit neatly into other expense categories: legal fees (not related to leasing), accounting and audit fees, property-level software and technology, marketing and advertising (for the property, not individual unit leasing), licenses and permits, and miscellaneous operating costs.

G&A typically represents 3% to 7% of total operating expenses, or $0.25 to $1.00 per square foot. The most common modeling approach is to set G&A as a percentage of EGI (0.5% to 1.5%) and inflate at the general CPI rate. G&A is rarely the line item that makes or breaks a projection, but it should not be omitted. Excluding G&A understates operating expenses by $50,000 to $200,000 annually on a mid-size institutional property.

The NOI Bridge

Net Operating Income is the line that separates the property's operating performance from its financing and capital structure. NOI equals EGI minus total operating expenses. It is the metric that determines property value through the direct capitalization method (Value = NOI / Cap Rate) and the benchmark that investors, lenders, and appraisers use to compare properties across markets and asset classes.

NCREIF's Property Index tracks quarterly income and capital returns for institutional-quality commercial properties across the U.S. As of Q1 2026, the index reported a 1.15% quarterly income return across all property types, reflecting a yield on the underlying portfolio of approximately 4.6% annualized. Year-over-year NOI growth across the NCREIF universe has been running at approximately 3% to 5%, with industrial and residential outperforming office.

The NOI bridge is where the modeling discipline matters most. Two underwriters looking at the same property will arrive at different NOI estimates because they differ on rent growth, vacancy, expense inflation, and the treatment of non-recurring items. The institutional standard is to present NOI in three versions: trailing 12-month actual (T-12), Year 1 projected (based on the buyer's assumptions), and stabilized (reflecting the property's performance after any lease-up, renovation, or repositioning is complete).

The gap between the T-12 NOI and the Year 1 projected NOI tells the story of the acquisition thesis. If the buyer's Year 1 NOI is higher than the T-12, the buyer is underwriting improvement (higher rents, lower vacancy, expense reductions). If Year 1 NOI is lower than the T-12, the buyer is accounting for known headwinds (lease expirations, expense resets, market softening). The size and direction of this gap is the first thing an investment committee examines when reviewing an acquisition recommendation.

Assumption Benchmarks by Asset Class

The following table consolidates the key assumption ranges discussed throughout this article into a single reference. These are not prescriptive numbers. They are ranges observed across institutional pro formas for stabilized properties in balanced markets as of mid-2026. Properties in supply-constrained markets, properties undergoing repositioning, and properties with unusual expense profiles will fall outside these ranges.

Nareit's REIT Industry Tracker provides quarterly operating data from publicly traded REITs that can be used to benchmark these assumptions. As of Q1 2026, same-store NOI growth across all REIT sectors averaged 3.8% year over year, with industrial and data center REITs outperforming and office REITs lagging.

Two important caveats about these benchmarks. First, they represent ranges for stabilized properties. Properties in lease-up, under renovation, or in the process of repositioning will have different expense profiles and vacancy levels that do not conform to stabilized benchmarks. Second, the ranges are national. Regional and submarket-level data should be used for actual underwriting. A multifamily property in Miami has a fundamentally different insurance, property tax, and utility cost profile than one in Minneapolis.

NNN Lease Structures and Expense Pass-Throughs

The operating expense assumptions in the table above apply to gross lease structures where the landlord bears operating expenses. In triple-net (NNN) lease structures, which are standard for single-tenant industrial and common for credit-tenant retail, most or all operating expenses are passed through to the tenant. The landlord's pro forma under a NNN lease shows minimal operating expenses (often limited to management fees and landlord-retained G&A), resulting in an NOI that closely approximates EGI.

The modeling implication is that NNN properties shift expense risk from the landlord to the tenant. The landlord's cash flow is more predictable, but the rent per square foot is lower because the tenant is bearing the expense burden. When comparing properties across lease structures, the relevant metric is not gross rent but effective rent net of landlord-borne expenses.

The 2026 Macro Environment

Three macro-level expense pressures are reshaping operating cost assumptions in 2026. Models built on pre-2022 expense trends understate near-term cost growth and need to be recalibrated.

Insurance Hardening

The commercial property insurance market has experienced what the industry calls a "hard market" cycle since 2022. Global catastrophe losses, reinsurance capacity constraints, and actuarial reassessments of climate-related risk have driven premium increases that far exceed general inflation. Properties in Florida, the Gulf Coast, and coastal California have seen the most dramatic increases. Some Florida multifamily operators report all-in insurance costs exceeding $2,500 per unit annually, up from $800 to $1,200 per unit in 2019.

The practical implication for cash flow modeling is that insurance should not be inflated at a uniform rate. The trailing 12-month insurance premium is the correct starting point for Year 1, but the forward growth rate should reflect the renewal market. Obtaining a preliminary insurance quote from a broker during due diligence is worth the effort because the difference between a 5% and a 25% insurance premium increase in Year 1 can change NOI by $50,000 to $200,000 on a mid-size property.

Property Tax Reassessment Risk

Many properties have not been reassessed since before the pandemic. In jurisdictions with lagging reassessment cycles (which includes most of the U.S. outside New York City), assessors are now catching up with market value changes that occurred in 2020 through 2024. For properties that increased in value during the pandemic (multifamily in Sun Belt markets, industrial everywhere), reassessment will push property taxes higher. For properties that lost value (office in most markets), proactive tax appeals are necessary to capture the reduction.

The reassessment-at-sale issue is particularly important in the current market. Properties are trading at prices that reflect post-pandemic valuations. Buyers are paying 2025 and 2026 prices and inheriting 2019 or 2020 assessed values. The reassessment to the purchase price can add $1 to $3 per square foot in annual property taxes, a cost that must be reflected in the acquisition pro forma's Year 1 expense budget.

Utility Cost Volatility

Energy prices have been volatile since 2022 due to the global energy supply disruption, domestic natural gas market dynamics, and the ongoing transition to renewable generation sources. The Bureau of Labor Statistics Consumer Price Index data shows energy prices contributing significant month-to-month variance to the overall inflation picture. In June 2026, the energy index fell 5.7% month over month, but the year-over-year trajectory remains elevated relative to pre-2022 norms.

For properties where the landlord bears utility costs (master-metered multifamily, gross-lease office), utility expense volatility introduces forecast risk that flat growth-rate assumptions do not capture. A more robust approach is to model utility costs using a base-plus-variable structure: a fixed component reflecting the minimum cost of providing basic utility service, and a variable component that fluctuates with energy prices and occupancy levels. At minimum, utility expenses should be inflated at 4% to 6% annually rather than the general CPI rate of 2.5% to 3.5%.

Worked Example: 200-Unit Multifamily Property

The following worked example traces the full operating cash flow cascade for a 200-unit garden-style multifamily property in a Southeastern U.S. market. The property was built in 2005, is fully stabilized at 94% occupancy, and is being acquired by an institutional buyer at a 5.25% going-in cap rate.

Property Profile

• Units: 200 (40 studios at 550 SF, 100 one-bedrooms at 780 SF, 60 two-bedrooms at 1,050 SF)
• Total rentable SF: 163,000
• Average in-place rent: $1,800/month ($21,600/year)
• Market rent: $1,850/month (2.8% mark-to-market on average)
• Year of construction: 2005
• Acquisition price: $49,371,000 ($246,855/unit)

Year 1 Revenue Projection

Year 1 Operating Expense Budget

Year 1 NOI and Cash Flow

The Year 1 cash-on-cash return for this investment is 5.49%, calculated as levered cash flow ($948,112) divided by total equity invested ($17,279,850, which is the acquisition price minus the loan amount). This is a healthy initial yield for a stabilized multifamily acquisition in the current rate environment, though the returns picture improves over the hold period as rents grow and debt service remains fixed.

10-Year Cash Flow Projection

Projecting the operating cash flow over a 10-year hold period requires applying the growth assumptions from the expense table to each line item independently. Revenue grows at 2.5% annually (reflecting expected rent growth for the Southeastern market). Expenses grow at their individual rates (property taxes at 3.0%, insurance at 8.0% for Years 2 and 3, then 4.0%, utilities at 5.0%, and so on). The weighted average expense growth rate in this model works out to approximately 4.2% in Year 2, 4.1% in Year 3, and 3.3% from Year 4 forward as the insurance growth normalizes.

By Year 5, NOI grows to approximately $2,773,000 (a 9.4% cumulative increase from Year 1). By Year 10, NOI reaches approximately $3,068,000 (a 21.0% cumulative increase). The cumulative levered cash flow over the 10-year hold totals approximately $11.8 million, which is the recurring cash return to equity investors before considering the reversion sale.

The critical observation is that the expense growth rate (weighted average 3.3% to 4.2%) partially offsets the revenue growth rate (2.5%). When expense growth exceeds revenue growth in the early years (due to the insurance and utility spikes), NOI growth compresses. This is the margin compression dynamic that institutional underwriters watch closely and that simple models with uniform growth rates miss entirely.

Sensitivity Analysis

Sensitivity analysis tests how changes in key assumptions affect the model's outputs. In operating cash flow projection, the three most important variables to test are rent growth, vacancy, and expense inflation. Each variable affects NOI directly, and changes in NOI cascade through to property valuation, debt coverage ratios, and equity returns.

Rent Growth Sensitivity

Using the 200-unit multifamily example, the following table shows how changes in the annual rent growth assumption affect cumulative NOI over a 10-year hold, with all other assumptions held constant.

A 100-basis-point swing in rent growth (from 1.5% to 2.5%) produces a $1,250,000 difference in cumulative NOI over 10 years. At a 5.25% terminal cap rate, the Year 10 NOI difference of approximately $300,000 translates to a $5.7 million difference in residual value. For the equity investor, that is the difference between a strong return and a mediocre one.

Vacancy Sensitivity

Vacancy sensitivity is tested in a similar fashion. The base case assumes 5.0% physical vacancy. Testing at 3.0% (tight market) and 8.0% (soft market) brackets the realistic range.

At 3.0% vacancy, Year 1 NOI increases by approximately $89,000 (the saved vacancy cost less the management fee adjustment), improving the cash-on-cash return to approximately 6.0%. At 8.0% vacancy, Year 1 NOI decreases by approximately $133,000, compressing the cash-on-cash return to approximately 4.7%.

The important subtlety is that vacancy and concessions are correlated. In a market where vacancy rises from 5% to 8%, concessions also increase as landlords compete for a smaller pool of tenants. A robust sensitivity analysis increases both vacancy and concessions simultaneously in the downside scenario. A 3-percentage-point increase in vacancy paired with a 2-percentage-point increase in concessions reduces Year 1 EGI by approximately $222,000, which is nearly double the impact of testing vacancy alone.

Expense Inflation Sensitivity

The base case assumes a weighted average expense growth rate of approximately 3.5% annually (higher in early years due to insurance, lower later). Testing at 2.5% (benign environment) and 5.0% (persistent inflation) provides the range.

At 2.5% annual expense growth, cumulative 10-year NOI increases by approximately $700,000 relative to the base case, a 2.5% improvement. At 5.0% expense growth, cumulative NOI decreases by approximately $1,100,000, a 3.9% decline. The asymmetry reflects the compounding effect: higher expense growth compounds against the investor's cash flow, while lower expense growth compounds in the investor's favor.

Green Street's Commercial Property Price Index tracks property pricing relative to NOI growth across all major commercial property sectors. Their data shows that property prices have increased approximately 5% over the past year, with rental income contributing 2% to 3% of the appreciation and the remainder attributed to modest cap rate compression. This relationship between NOI growth and pricing underscores why getting the cash flow projection right is the foundation of accurate valuation.

Combined Scenario Analysis

The most useful sensitivity analysis tests multiple variables simultaneously. Institutional pro formas typically present three scenarios.

• Base case: Management's best estimate of likely performance. This is the scenario used for investment committee presentations and loan sizing.
• Downside case: Rent growth 100bp below base, vacancy 200bp above base, expense growth 100bp above base. This scenario tests whether the investment generates adequate returns even if the market softens. Investment committees typically require the downside case to meet a minimum DSCR threshold (1.20x or higher) and a minimum equity return threshold (positive cash-on-cash).
• Upside case: Rent growth 100bp above base, vacancy 100bp below base, expense growth 50bp below base. This scenario demonstrates the upside potential and is used for fund-level return modeling.

For the 200-unit multifamily example, the combined downside scenario (1.5% rent growth, 7.0% vacancy, 4.5% expense inflation) produces a Year 1 NOI of approximately $2,280,000, a DSCR of 1.49x, and a cash-on-cash return of 3.3%. The combined upside scenario (3.5% rent growth, 4.0% vacancy, 3.0% expense inflation) produces a Year 1 NOI of approximately $2,830,000, a DSCR of 1.85x, and a cash-on-cash return of 7.5%. The 420-basis-point spread between downside and upside cash-on-cash returns illustrates the range of outcomes that reasonable assumption variations can produce.

Common Assumption Errors

Cash flow projection errors tend to cluster around a handful of mistakes that recur across experience levels. Recognizing these patterns is the fastest way to improve projection accuracy.

1. Over-Projecting Rent Growth

The most prevalent error. Analysts anchor on recent rent growth (particularly in markets that experienced 10% to 15% annual increases in 2021 and 2022) and project forward without adjusting for mean reversion. Long-term average rent growth for institutional multifamily is 2.5% to 3.5% nationally. For industrial, the long-term average is 2.0% to 3.0%. Office has averaged 1.0% to 2.0% over the past 20 years.

The fix is simple: use the submarket's 10-year average rent growth as the base case rather than trailing 3-year or 5-year averages, which may be distorted by cyclical peaks or troughs. If the investment thesis depends on above-average rent growth, the model should demonstrate why through specific supply/demand analysis, not just assume it.

2. Under-Reserving for Capital Expenditures

Capital expenditure reserves (replacement reserves) represent the ongoing cost of maintaining the property's physical plant: roof replacements, HVAC system replacements, parking lot repaving, elevator modernization, unit renovations, and common area refreshes. These costs are lumpy (a roof replacement happens once every 20 to 25 years) but can be averaged into an annual reserve.

The common error is using $200 to $250 per unit for multifamily reserves when the actual long-term replacement cost is $350 to $500 per unit for a 20-year-old property. Properties built in the 2000s to 2010s are now entering the age where major systems need replacement: the first roof cycle (15 to 20 years), first HVAC replacement cycle (15 to 20 years), and first elevator modernization (20 to 25 years). A reserve amount set at acquisition that does not reflect the property's age and remaining useful life of major systems will understate the true cost of ownership.

3. Ignoring Expense Correlation

Operating expenses are not independent of each other or of revenue conditions. During economic downturns, credit loss increases, vacancy rises, and concession costs increase simultaneously. Maintenance costs may also increase if deferred maintenance catches up. On the expense side, payroll costs can increase in tight labor markets even as revenue growth slows, creating margin compression.

The error is modeling each line item as if it operates in isolation. A downside scenario that increases vacancy by 200bp without also increasing concessions, credit loss, and marketing expenses understates the true downside. Similarly, an upside scenario that reduces vacancy without also reducing concessions and marketing expenses overstates the benefit.

4. Flat Expense Inflation for All Categories

Using a single expense inflation rate (typically 2.5% to 3.0%) for all expense categories ignores the fact that different costs grow at different rates. Insurance has been growing at 8% to 15% annually in many markets. Utility costs have been growing at 4% to 6%. Property taxes grow at the rate of assessed value increases plus mill rate changes. Payroll costs grow with the local labor market. Only G&A and miscellaneous expenses track general CPI closely.

The fix is to assign individual growth rates to each expense category based on its specific cost driver. This adds complexity to the model but produces materially more accurate projections, particularly in the near term where category-specific inflation diverges most from general inflation.

5. Ignoring the Reassessment-at-Sale

As discussed in the property tax section, the property tax bill is typically reassessed to the purchase price upon transfer of ownership. Buyers who model property taxes using the seller's historical tax bill without adjusting for the reassessment overstate Year 1 NOI. In high-tax jurisdictions, the reassessment can increase the property tax bill by 20% to 50%, reducing NOI by 2% to 5%.

6. Conflating Physical and Economic Vacancy

Physical vacancy measures the percentage of space that is physically unoccupied. Economic vacancy measures the percentage of potential revenue that is not collected, including physical vacancy, credit loss, and concessions. A property can have 95% physical occupancy but only 88% economic occupancy if credit loss and concessions are significant.

Using physical vacancy as the sole vacancy input understates the revenue reduction in markets with high concession activity. Economic vacancy is the correct metric for cash flow projection because it captures all revenue leakage, not just the portion attributable to empty space.

7. No Growth Rate Reversion

Near-term assumptions should reflect current market conditions. Long-term assumptions should revert to historical averages. A model that projects 4% rent growth for all 10 years because the near-term outlook is strong ignores the cyclical nature of real estate markets. Similarly, a model that projects 10% insurance growth for all 10 years because the current insurance market is hard overstates long-term expense pressure.

The standard approach is to use a 2-year to 3-year near-term window with market-specific assumptions, followed by reversion to long-term averages for the remaining hold period. This structure captures current conditions without extrapolating them indefinitely.

Build It in Apers

Related Articles

• Below-the-Line Items: TI, LC, CapEx, and Reserves. A detailed guide to the items that sit between NOI and levered cash flow. Covers tenant improvement allowances, leasing commissions, capital expenditure budgeting, and replacement reserve methodology.
• Lease-by-Lease Modeling: Tenant Rollover and Renewal. How to model cash flow at the individual lease level for multi-tenant office, retail, and industrial properties. Covers roll probability, downtime assumptions, renewal spreads, and the interaction between lease expiration schedules and property-level vacancy.
• Absorption and Lease-Up for Development and Repositioning. Cash flow projection for properties that are not yet stabilized. Covers absorption rate assumptions, lease-up timelines, and the transition from development-phase cash flow to stabilized operating cash flow.
• Hold Period Analysis: IRR vs. Equity Multiple. How to evaluate total investment returns by combining operating cash flow projections with terminal value estimates. Covers the trade-offs between IRR and equity multiple as return metrics and the sensitivity of each to hold period length.
• NOI: Institutional vs. Broker Calculation Methods. The differences between how institutional underwriters and listing brokers calculate NOI, and why the gap matters for acquisition pricing.
• Cash-on-Cash Return: Levered vs. Unlevered. How leverage amplifies equity returns when NOI exceeds the cost of debt, and how to calculate and interpret cash-on-cash returns in the context of an operating cash flow projection.