Study guide

13.2 Annual Property Performance Auditing & Variance Analysis

Certified Commercial Investment Member CCIM

Track your progress as you read

Finished sections get a check mark.

1 Getting Started: The CCIM Designation & Comprehensive Exam

About the CCIM Comprehensive Exam

2 Chapter 1: Time Value of Money & Cash Flow Modeling

1.1 Core Time Value of Money Principles & Compounding Dynamics 1.2 Annuity Mechanics, Sinking Funds & Loan Amortization Mathematics 1.3 The CCIM Cash Flow Model: From Gross Potential Income to BTCF

3 Chapter 2: Debt Financing, Cash-on-Cash Return & Direct Capitalization

2.1 Debt Financing Metrics: DCR, LTV & Maximum Loan Sizing 2.2 Cash-on-Cash Return & First-Year Equity Dividend Rates 2.3 Direct Capitalization & Capitalization Rate Derivation

4 Chapter 3: Advanced Capitalization & Mortgage-Equity Valuation

3.1 Band of Investment Technique (Debt & Equity Components) 3.2 Mortgage-Equity Analysis & The Ellwood Formulation 3.3 Discounted Cash Flow (DCF) Modeling & Net Present Value (NPV)

5 Chapter 4: Yield Metrics & After-Tax Investment Analysis

4.1 Internal Rate of Return (IRR) Mechanics, Limitations & MIRR 4.2 Commercial Real Estate Tax Fundamentals & MACRS Cost Recovery 4.3 After-Tax Cash Flow (ATCF) & After-Tax Equity Reversion (ATER) 4.4 Capital Accumulation & the Annual Growth Rate of Capital (AGRC)

6 Chapter 5: Market Fundamentals & Economic Base Analysis

5.1 The CCIM Strategic Analysis Model & Market Delineation 5.2 Economic Base Theory: Basic vs. Non-Basic Employment Dynamics 5.3 Location Quotient (LQ) & Economic Base Multipliers

7 Chapter 6: Supply, Demand & Trade Area Dynamics

6.1 Supply Analysis: Inventory, Pipeline & Competitor Benchmarking 6.2 Demand Modeling, Absorption Metrics & Market Slack 6.3 Trade Area Delineation: Primary, Secondary & Tertiary Zones

8 Chapter 7: Demographics, Site Evaluation, Regulatory Due Diligence & Geospatial Analysis

7.1 Psychographic & Demographic Profiling with Esri Tapestry Segmentation 7.2 Physical Site Evaluation, Ingress/Egress & Accessibility 7.3 Zoning, Land-Use Entitlements & Environmental Screening 7.4 Geospatial Analysis: Intellisite, Drive-Time Trade Areas & Retail Gap Modeling

9 Chapter 8: Commercial Sector Market Analysis: Office, Industrial, Retail & Multifamily

8.1 Office Sector Dynamics: Space Utilization, Classes & Submarket Drivers 8.2 Industrial & Logistics Facilities: E-Commerce, Clear Heights & Intermodal Hubs 8.3 Retail Trade Analysis: Reilly's Law, Huff Gravity Model & Sales Thresholds 8.4 Multifamily Analytics: Demographics, Household Formation & Concession Impact

10 Chapter 9: User Foundations, Space Measurement & Commercial Lease Types

9.1 The User Perspective vs. The Investor Perspective 9.2 Space Measurement Standards: BOMA Usable vs. Rentable Area & Load Factors 9.3 Commercial Lease Types: Gross, Modified Gross, Single, Double & Triple Net

11 Chapter 10: Expense Allocations, Percentage Rent & Comparative Lease Analysis

10.1 Expense Stops, Base Year Adjustments & Operating Expense Escalations 10.2 Retail Percentage Rent, Natural & Unnatural Breakpoints 10.3 Comparative Lease Analysis: Effective Rent & Net Present Cost Modeling

12 Chapter 11: Lease vs. Purchase Analysis & Sale-Leaseback Transactions

11.1 Cost of Capital & Appropriate Discount Rates for User Decisions 11.2 Structuring the Lease vs. Purchase Decision Framework 11.3 Sale-Leaseback Mechanics, Underwriting & Capital Optimization

13 Chapter 12: Lease Buyouts, Accounting Standards (ASC 842) & Interest-Based Negotiations

12.1 Early Lease Buyout Valuation & Surrender Premium Formulas 12.2 Corporate Lease Accounting (ASC 842 / IFRS 16) & Balance Sheet Impact 12.3 Interest-Based Negotiations in Commercial Leasing

14 Chapter 13: The Investment Lifecycle, Annual Review & Capital Decisions

13.1 The Real Estate Investment Lifecycle & Holding Period Optimization 13.2 Annual Property Performance Auditing & Variance Analysis 13.3 Refinancing Decisions & Capital Extraction Analysis

15 Chapter 14: Renovations, Disposition Timing & Leverage Dynamics

14.1 Value-Add Renovation Underwriting & Incremental Yield 14.2 Optimal Disposition Timing & Marginal Rate of Return (MRR) Analysis 14.3 Leverage Dynamics: Positive, Neutral & Negative Leverage

16 Chapter 15: Risk Quantification, Sensitivity Analysis & 1031 Exchange Fundamentals

15.1 Risk Analysis Frameworks: Sensitivity, Scenario & Monte Carlo Modeling 15.2 IRC Section 1031 Tax-Deferred Exchange Rules, Deadlines & Boot 15.3 Advanced 1031 Structures: Reverse, Construction & Delaware Statutory Trusts

17 Chapter 16: Syndication Waterfalls, Portfolio Strategy & Investment Committee Due Diligence

16.1 Real Estate Syndication, Promote Structures & Waterfall Distributions 16.2 Modern Portfolio Theory (MPT) & Diversification in Commercial Real Estate 16.3 Investment Committee Due Diligence, Underwriting Packages & Synthesis

13.2 Annual Property Performance Auditing & Variance Analysis

Key Takeaways Explain This Topic AI

An annual property performance audit systematically re-underwrites operational results against initial pro forma projections across revenues, operating expenses, capital expenditures, and tenant lease rolls.

Revenue variances must be mathematically decomposed into Rate (Price) Variance and Volume (Occupancy) Variance to isolate whether revenue swings stem from market leasing concessions or physical space vacancy.

Operating expense audits must distinguish controllable expenses (janitorial, landscaping, preventive maintenance) from non-controllable expenses (ad valorem real estate taxes, property hazard insurance, regulated municipal utilities).

Triple-net (NNN) and modified gross lease reconciliations require gross-up adjustments (typically 95% to 100%) to allocate variable operating costs fairly to tenants when a building experiences partial vacancy during the base year or operating year.

Commercial tenant credit audits utilize retail health ratios (occupancy cost ratio = total rent / gross sales; healthy range 8%–12% for specialty retail, 2%–3% for supermarkets) and accounts receivable aging reports to detect early credit distress before monetary default.

Last updated: September 2026

Annual Property Performance Auditing & Variance Analysis

Note

Operational Vigilance & Value Preservation : In commercial real estate investment management, the annual budget is not a passive bookkeeping document—it is the operational benchmark against which an asset's business plan is tested. Institutional asset managers and CCIM designees conduct rigorous annual performance audits to identify operating slippage, enforce contractual lease covenants, audit operating expense pass-throughs, and re-underwrite forward property valuation. Without structured variance analysis, small operational deficiencies compound into substantial capital losses.

The Annual Audit Mandate & Re-Underwriting Protocol

The annual property review requires a comprehensive re-underwriting of the asset across four integrated operational pillars:

Rent Roll & Lease Compliance Audit :

Verifying contractual base rents, scheduled step-ups, and percentage rent calculations against executed lease documents.

Auditing tenant options: renewal windows, early termination rights, contraction options, and Rights of First Refusal (ROFR) or Offer (ROFO).

Tracking lease expiration schedules to identify and mitigate rollover cliffs.

Operating Expense & CAM Reconciliation Audit :

Comparing actual operating expenses against annual budgets.

Reconciling estimated monthly tenant pass-through billings against actual year-end recoverable expenses.

Applying contractual expense caps (cumulative vs. non-cumulative) and base year gross-up adjustments.

Physical Plant & Capital Reserve Audit :

Inspecting major structural components: roofing membranes, HVAC chillers, building envelopes, elevators, and parking surfaces.

Comparing actual capital outlays against the 10-year capital expenditure (CapEx) plan and re-sizing replacement reserves.

Submarket & Competitive Positioning Audit :

Benchmarking property performance against competitive peer properties using industry indices (BOMA Experience Exchange Report [EER], IREM Income/Expense Analysis, CoStar, REIS).

Evaluating submarket vacancy, direct absorption, new construction deliveries, and competitive asking rents.

Revenue Variance Analysis: Decomposing Rate vs. Volume Drivers

When actual rental revenue deviates from budgeted figures, treating the variance as a single lump-sum figure obscures the underlying cause. Under CCIM variance analysis, the Total Revenue Variance must be mathematically decomposed into two distinct components: Rate (Price) Variance and Volume (Occupancy) Variance .

Mathematical Formulation Total Revenue Variance = Actual Rental Revenue − Budgeted Rental Revenue \text{Total Revenue Variance} = \text{Actual Rental Revenue} - \text{Budgeted Rental Revenue} Total Revenue Variance = Actual Rental Revenue − Budgeted Rental Revenue Rate (Price) Variance = ( Actual Rental Rate − Budgeted Rental Rate ) × Actual Occupied Space \text{Rate (Price) Variance} = (\text{Actual Rental Rate} - \text{Budgeted Rental Rate}) \times \text{Actual Occupied Space} Rate (Price) Variance = ( Actual Rental Rate − Budgeted Rental Rate ) × Actual Occupied Space Volume (Occupancy) Variance = ( Actual Occupied Space − Budgeted Occupied Space ) × Budgeted Rental Rate \text{Volume (Occupancy) Variance} = (\text{Actual Occupied Space} - \text{Budgeted Occupied Space}) \times \text{Budgeted Rental Rate} Volume (Occupancy) Variance = ( Actual Occupied Space − Budgeted Occupied Space ) × Budgeted Rental Rate Total Revenue Variance = Rate Variance + Volume Variance + Cross-Product Interaction \text{Total Revenue Variance} = \text{Rate Variance} + \text{Volume Variance} + \text{Cross-Product Interaction} Total Revenue Variance = Rate Variance + Volume Variance + Cross-Product Interaction

(Note: In practice, the cross-product interaction is either tracked separately or combined into the rate variance using standard managerial accounting conventions).

Managerial Interpretation

Decomposing revenue variances isolates whether revenue shortfalls are driven by marketing/demand challenges or leasing execution failures:

Unfavorable Volume Variance : Indicates physical vacancy exceeded expectations. Drivers include slower-than-projected market absorption, tenant defaults, unexpected lease non-renewals, or extended space turnover downtimes.

Unfavorable Rate Variance : Indicates spaces were leased, but at rental rates below pro forma projections. Drivers include aggressive concession granting (free rent, elevated TI allowances), softening submarket asking rents, or broker discounting to hit occupancy quotas at the expense of rent yield.

Operating Expense Auditing: Controllable vs. Non-Controllable Costs

A disciplined operating expense audit bifurcates property expenses into two distinct categories based on management's ability to influence the expenditure:

1. Controllable Operating Expenses

Expenses where property management exercises direct operational and purchasing discretion. Management is held strictly accountable for budget variances in these line items:

Janitorial & Cleaning Contracts : Floor care, common area sanitation, window washing.

Landscaping & Grounds Maintenance : Mowing, irrigation maintenance, seasonal plantings.

Repairs & Maintenance (R&M) : HVAC filter replacements, plumbing repairs, electrical servicing, lock maintenance.

Security & Access Control : Guard personnel, surveillance monitoring, parking gate maintenance.

Administrative & Marketing : Signage, website maintenance, tenant appreciation events, office supplies.

Audit Standard : Variances should remain within ± 3 % \pm 3\% ± 3% to ± 5 % \pm 5\% ± 5% of annual budget. Material overruns signal poor vendor bidding, unauthorized overtime, or lack of preventative maintenance.

2. Non-Controllable Operating Expenses

Expenses driven by external statutory, macroeconomic, or underwriting conditions outside direct operational control:

Ad Valorem Real Estate Property Taxes : Determined by local municipal tax assessors and millage rates.

Property & Casualty Insurance : Driven by global commercial reinsurance market capacity, catastrophic weather events, and regional underwriting losses.

Regulated Municipal Utilities : Water, sewer, and baseline electric/gas tariffs set by public utility commissions.

Audit Standard : While rates are non-controllable, management must actively audit assessments (filing timely property tax appeals when market value declines) and mitigate consumption (installing LED retrofits, smart irrigation, and low-flow plumbing fixtures).

Expense Category Controllability Management Action / Mitigation Protocol Standard Variance Benchmark

Janitorial Controllable Competitive re-bidding every 24–36 months; unit-rate contracts ≤ ± 3 % \le \pm 3\% ≤ ± 3%

Landscaping Controllable Scope rationalization; drought-tolerant plantings ≤ ± 4 % \le \pm 4\% ≤ ± 4%

HVAC Maintenance Controllable Comprehensive preventative maintenance contracts; oil analysis ≤ ± 5 % \le \pm 5\% ≤ ± 5%

Property Taxes Non-Controllable Formal assessment appeals; hiring specialized tax appeal counsel Variable (Audit Assessments)

Hazard Insurance Non-Controllable Portfolio master insurance pooling; increasing deductibles Market Driven (Audit Risk)

  • Water & Sewer Non-Controllable Submetering; leak detection telemetry; smart irrigation Volume Controllable
  • CAM Reconciliations & The Partial Occupancy Gross-Up Adjustment

In multi-tenant office, retail, and industrial properties operating under modified gross or triple-net (NNN) leases, tenants reimburse the landlord for their pro rata share of Common Area Maintenance (CAM), property taxes, and building insurance.

The Year-End CAM Reconciliation Process

Throughout the operating year, tenants pay estimated monthly CAM charges based on the landlord's annual budget.

Following calendar year-end, the asset manager audits actual accounting ledgers to determine true incurred operating expenses.

The manager calculates each tenant's contractual pro rata share: Pro Rata Share = Tenant Rentable Area Building Rentable Area \text{Pro Rata Share} = \frac{\text{Tenant Rentable Area}}{\text{Building Rentable Area}} Pro Rata Share = Building Rentable Area Tenant Rentable Area ​ .

Actual obligations are reconciled against cumulative monthly payments, generating a year-end credit or invoice.

The Occupancy Gross-Up Clause

A critical CCIM audit checkpoint is the Gross-Up Clause in commercial leases. Operating expenses consist of fixed costs (property taxes, insurance) and variable costs that fluctuate with building occupancy (janitorial, utilities, management fees, restroom supplies).

If a 100,000 RSF building is only 75% occupied, actual variable expenses will be lower than if the building were 95% occupied. If the landlord reconciles expenses without a gross-up:

Existing tenants would pay their pro rata share of an artificially deflated variable cost pool.

When occupancy subsequently rises to 95%, variable costs jump, creating massive tenant billing spikes.

Worse, in a modified gross lease with an Expense Stop based on an under-occupied base year, the landlord suffers catastrophic unreimbursed expense leakage in future years.

The Gross-Up Formula

The gross-up adjustment recalculates variable operating costs to the level that would have been incurred had the building operated at a stabilized standard (typically 95% or 100% occupancy ): Grossed-Up OpEx = Fixed Expenses + ( Actual Incurred Variable Expenses Actual Average Occupancy Rate × Target Gross-Up Occupancy Rate ) \text{Grossed-Up OpEx} = \text{Fixed Expenses} + \left( \frac{\text{Actual Incurred Variable Expenses}}{\text{Actual Average Occupancy Rate}} \times \text{Target Gross-Up Occupancy Rate} \right) Grossed-Up OpEx = Fixed Expenses + ( Actual Average Occupancy Rate Actual Incurred Variable Expenses ​ × Target Gross-Up Occupancy Rate ) Tenant Share = Grossed-Up OpEx × ( Tenant Rentable Area Total Building Rentable Area ) \text{Tenant Share} = \text{Grossed-Up OpEx} \times \left( \frac{\text{Tenant Rentable Area}}{\text{Total Building Rentable Area}} \right) Tenant Share = Grossed-Up OpEx × ( Total Building Rentable Area Tenant Rentable Area ​ )

The gross-up clause protects the landlord by allowing full recovery of variable costs attributable to occupied space, while protecting tenants from distorted base-year expense stops.

Tenant Credit Surveillance & Retail Health Ratios

A rigorous annual audit examines tenant financial solvency to detect credit distress before monetary defaults occur:

1. Accounts Receivable (A/R) Aging Analysis

Asset managers audit the property's A/R aging report monthly across standardized buckets: Current, 30–60 Days, 61–90 Days, and 90+ Days. Warning indicators include:

Chronic late payments or partial remittances.

Repeated requests to apply security deposits to current rent.

Requests for lease restructuring, rent deferrals, or space surrender.

2. Retail Health Ratios (Occupancy Cost Ratio)

In commercial retail assets, landlords require tenants to submit certified annual gross sales figures. The primary financial metric used by CCIM designees to assess retail tenant sustainability is the Health Ratio (also called the Occupancy Cost Ratio ): Health Ratio (Occupancy Cost) = Total Annual Rent & Recoveries (Base Rent + CAM + Taxes + Insurance) Annual Gross Sales \text{Health Ratio (Occupancy Cost)} = \frac{\text{Total Annual Rent \& Recoveries (Base Rent + CAM + Taxes + Insurance)}}{\text{Annual Gross Sales}} Health Ratio (Occupancy Cost) = Annual Gross Sales Total Annual Rent & Recoveries (Base Rent + CAM + Taxes + Insurance) ​

Industry Benchmark Thresholds

  • Retail Category Sustainable Health Ratio Warning / Distress Threshold
  • Supermarkets / Grocery 1.5% to 3.0% > 3.5 % > 3.5\% > 3.5% (Tight margins require high volume)
  • Big-Box Discount / Department 3.5% to 5.5% > 6.5 % > 6.5\% > 6.5%
  • Fast-Casual / Quick Service (QSR) 6.0% to 8.5% > 10.0 % > 10.0\% > 10.0%
  • Full-Service Restaurants 7.0% to 10.0% > 12.0 % > 12.0\% > 12.0%

Specialty Apparel & In-Line Retail 9.0% to 13.0% > 15.0 % > 15.0\% > 15.0% (High risk of failure or rent reduction demand)

Jewelry / Luxury Goods 5.0% to 8.0% > 10.0 % > 10.0\% > 10.0%

When a tenant's health ratio breaches the distress threshold, the asset manager must immediately plan for lease non-renewal, require letters of credit, or begin pre-marketing the space to prospective replacement tenants.

Capital Expenditure (CapEx) Auditing & Reserve Management

A critical failure in real estate performance auditing is the misclassification of expenses between Operating Expenses (OpEx) and Capital Expenditures (CapEx):

OpEx (Repairs & Maintenance) : Recurring outlays that maintain the property in ordinary operating condition (e.g., repairing an HVAC compressor, patching roof leaks). OpEx is deducted above the line, directly reducing Net Operating Income (NOI).

CapEx (Capital Replacements) : Substantial outlays that extend the useful economic life of the property or add new utility (e.g., complete roof replacement, new chiller installation). CapEx sits below the NOI line.

The Replacement Reserve Sinking Fund

To prevent sudden cash flow deficits when major building systems fail, CCIM designees establish annual Replacement Reserves . The annual escrow is modeled based on remaining useful life (RUL) and replacement cost: Annual Reserve Contribution = ∑ i = 1 m Replacement Cost i Estimated Economic Useful Life (Years) i \text{Annual Reserve Contribution} = \sum_{i=1}^{m} \frac{\text{Replacement Cost}_i}{\text{Estimated Economic Useful Life (Years)}_i} Annual Reserve Contribution = i = 1 ∑ m ​ Estimated Economic Useful Life (Years) i ​ Replacement Cost i ​ ​

Standard underwriting benchmarks: $0.20 to $0.40 per RSF annually for commercial office and industrial; $250 to $400 per unit annually for multifamily.

Comprehensive Worked Case Study: 100,000 RSF Suburban Office Variance Audit (Highland Point)

Consider Highland Point, a 100,000 RSF multi-tenant Class-B+ suburban office building. At the end of Year 2, the asset manager conducts an annual variance audit comparing actual results against the approved operating budget.

  • Underwriting & Budget Baseline
  • Total Building Rentable Area : 100,000 RSF
  • Budgeted Occupancy : 90.0% (90,000 occupied RSF)
  • Budgeted Base Rental Rate : $30.00/RSF per year (Total Budgeted Base Rent = $2,700,000)

Actual Operating Results :

  • Actual Average Occupancy: 84.0% (84,000 occupied RSF)
  • Actual Average Achieved Rental Rate: $28.50/RSF per year

Actual Base Rental Revenue Collected: $ 84 , 000 × $ 28.50 \text{\textdollar}84,000 \times \text{\textdollar}28.50 $ 84 , 000 × $ 28.50 = $2,394,000

Step 1: Revenue Variance Decomposition Total Base Rent Variance = $ 2 , 394 , 000 − $ 2 , 700 , 000 = − $ 306 , 000 (Unfavorable) \text{Total Base Rent Variance} = \$2,394,000 - \$2,700,000 = -\$306,000\text{ (Unfavorable)} Total Base Rent Variance = $2 , 394 , 000 − $2 , 700 , 000 = − $306 , 000 (Unfavorable)

Decomposing the variance:

Rate (Price) Variance : Rate Variance = ( P actual − P budget ) × Q actual = ( $ 28.50 − $ 30.00 ) × 84 , 000 = − $ 1.50 × 84 , 000 = − $ 126 , 000 \text{Rate Variance} = (P_{\text{actual}} - P_{\text{budget}}) \times Q_{\text{actual}} = (\$28.50 - \$30.00) \times 84,000 = -\$1.50 \times 84,000 = -\$126,000 Rate Variance = ( P actual ​ − P budget ​ ) × Q actual ​ = ( $28.50 − $30.00 ) × 84 , 000 = − $1.50 × 84 , 000 = − $126 , 000

Volume (Occupancy) Variance : Volume Variance = ( Q actual − Q budget ) × P budget = ( 84 , 000 − 90 , 000 ) × $ 30.00 = − 6 , 000 × $ 30.00 = − $ 180 , 000 \text{Volume Variance} = (Q_{\text{actual}} - Q_{\text{budget}}) \times P_{\text{budget}} = (84,000 - 90,000) \times \$30.00 = -6,000 \times \$30.00 = -\$180,000 Volume Variance = ( Q actual ​ − Q budget ​ ) × P budget ​ = ( 84 , 000 − 90 , 000 ) × $30.00 = − 6 , 000 × $30.00 = − $180 , 000

Sum Check : − $ 126 , 000 + ( − $ 180 , 000 ) = − $ 306 , 000 -\text{\textdollar}126,000 + (-\text{\textdollar}180,000) = -\text{\textdollar}306,000 − $ 126 , 000 + ( − $ 180 , 000 ) = − $ 306 , 000 .

Audit Finding : Of the $306,000 revenue shortfall, 58.8% ($180,000) was driven by space vacancy (volume), while 41.2% ($126,000) resulted from leasing brokers offering discounted rental rates to attract tenants.

Step 2: Operating Expense Audit & CAM Gross-Up Reconciliation

Budgeted Operating Expenses (at 90% occupancy):

  • Fixed Expenses (Taxes, Insurance): $400,000
  • Variable Expenses (Janitorial, Utilities, Management): $450,000
  • Total Budgeted OpEx = $850,000

Actual Operating Expenses Incurred (at 84% occupancy):

  • Fixed Expenses: $415,000 ($15,000 tax reassessment overrun)
  • Variable Expenses: $386,400 (lower due to 84% occupancy)
  • Total Actual Incurred OpEx = $801,400

Applying a 95% Occupancy Gross-Up Clause for tenant lease reconciliations:

Variable expenses are grossed up from 84% to 95%: Grossed-Up Variable OpEx = $ 386 , 400 × ( 0.95 0.84 ) = $ 386 , 400 × 1.130952 = $ 437 , 000 \text{Grossed-Up Variable OpEx} = \$386,400 \times \left( \frac{0.95}{0.84} \right) = \$386,400 \times 1.130952 = \$437,000 Grossed-Up Variable OpEx = $386 , 400 × ( 0.84 0.95 ​ ) = $386 , 400 × 1.130952 = $437 , 000

Total Adjusted Grossed-Up Operating Expenses : Total Grossed-Up OpEx = $ 415 , 000 (Fixed) + $ 437 , 000 (Grossed-Up Variable) = $ 852 , 000 \text{Total Grossed-Up OpEx} = \$415,000\text{ (Fixed)} + \$437,000\text{ (Grossed-Up Variable)} = \$852,000 Total Grossed-Up OpEx = $415 , 000 (Fixed) + $437 , 000 (Grossed-Up Variable) = $852 , 000

For a full-floor tenant occupying 20,000 RSF (20% pro rata share): Tenant Share of OpEx = $ 852 , 000 × 0.20 = $ 170 , 400 \text{Tenant Share of OpEx} = \$852,000 \times 0.20 = \$170,400 Tenant Share of OpEx = $852 , 000 × 0.20 = $170 , 400

(Without the gross-up clause, the tenant would have paid only 20% of $801,400 = $160,280, resulting in a $10,120 revenue shortfall absorbed unfairly by the landlord).

Comprehensive Budget vs. Actual Schedule (Highland Point)

  • Line Item Budget (90% Occ) Actual (84% Occ) Variance ($) Variance (%) Primary Operational Root Cause
  • Gross Base Rent $2,700,000 $2,394,000 -$306,000 -11.33% Vacancy (-$180k) + Rate Discounting (-$126k)
  • Expense Recoveries $765,000 $715,680 -$49,320 -6.45% Lower occupied RSF paying CAM reimbursements
  • Total Revenues $3,465,000 $3,109,680 -$355,320 -10.25% Combined occupancy and rate slippage
  • Property Taxes $250,000 $262,000 +$12,000 +4.80% Unfavorable county reassessment (Appeal filed)
  • Property Insurance $150,000 $153,000 +$3,000 +2.00% Underwriting carrier premium hardening
  • Janitorial & Trash $180,000 $156,000 -$24,000 -13.33% Lower variable cost from 84% occupancy
  • Utilities (Power/Water) $160,000 $138,400 -$21,600 -13.50% Lower tenant plug load and HVAC usage
  • Maintenance & Repairs $60,000 $64,000 +$4,000 +6.67% Unscheduled chiller seal repairs
  • Management Fees $50,000 $28,000 -$22,000 -44.00% Contractual fee tied to collected revenue
  • Total Operating Expenses $850,000 $801,400 -$48,600 -5.72% Variable savings offset tax overrun
  • Net Operating Income $2,615,000 $2,308,280 -$306,720 -11.73% Net operational NOI shortfall
  • CCIM Exam Traps & Common Underwriting Pitfalls

The Flat Revenue Variance Fallacy : Analyzing rental revenue deficits as a single aggregate variance without isolating the price rate variance from the volume occupancy variance.

Omitting the Occupancy Gross-Up in Base Year Calculations : Failing to gross up variable operating expenses when a building is partially occupied during the base year, which locks the landlord into an artificially depressed expense stop and creates permanent expense reimbursement leakage.

Misclassifying Capital Replacements as Operating Maintenance : Booking major capital expenditures (e.g., elevator modernization, roof tear-off) as routine repairs to inflate operating deductions, or improperly capitalizing routine maintenance to artificially inflate Net Operating Income.

Ignoring Retail Health Ratios until Actual Rent Default : Relying solely on whether rent is paid on the first of the month while failing to track gross tenant sales trends, missing early warning indicators of tenant bankruptcy.