Lesson 03 · 13 min read

Modeling Operating Expenses — Line by Line

How to project operating expenses in a CRE pro forma with the right growth rates, the right categories, and a realistic view of what actually costs what.

Revenue assumptions get most of the attention, but operating expenses kill more deals than revenue projections do. A 10% miss on expenses isn't "10% less NOI" — because expenses are leveraged by the capitalization rate, a 10% expense miss on a 6% cap deal translates to roughly a 3-4% hit to property value. On a $5M deal, that's $150,000-$200,000 of value erased.

This lesson walks through how to build a realistic expense side that won't embarrass you at closing.

The standard expense categories

Every operating statement groups expenses the same way. Learn this structure once and you'll recognize it on every deal you look at.

Fixed expenses (don't change much year-over-year)

  1. Property taxes — often the largest single line
  2. Insurance — property + liability + umbrella
  3. Management fees — typically 3-5% of EGI

Variable expenses (track occupancy, weather, usage)

  1. Utilities — water, sewer, electric, gas (landlord-paid portions)
  2. Repairs & maintenance — plumbing, electrical, HVAC, general upkeep
  3. Landscaping / grounds
  4. Trash / recycling
  5. Pest control
  6. Snow removal (northern markets only)
  7. Cleaning / janitorial (common areas, office)
  8. Security
  9. Turnover costs — paint, carpet, flooring between tenants

Administrative

  1. Legal — evictions, lease enforcement
  2. Accounting — bookkeeping, tax prep
  3. Marketing / advertising — leasing costs
  4. Office supplies / admin
  5. Payroll (on-site staff — only applies to larger properties)

Reserves

  1. Replacement reserves — a budget for future capital expenses (roofs, HVAC, parking lot)

The sum of all these is Total Operating Expenses. Subtract from EGI to get NOI.

Which expenses stay above the NOI line?

This is where pro formas get fudged. The rule: anything required to operate the property goes above NOI. Anything that's a capital improvement or owner-discretion goes below.

Above NOI (operating expenses):

  • Everything in the list above
  • Routine repairs and maintenance
  • Landlord-paid utilities
  • Standard management fees

Below NOI (capital and discretionary):

  • Tenant improvements (TIs) at lease-up
  • Leasing commissions
  • Major renovations (roof replacement, HVAC replacement, repaving)
  • Interest expense (financing, not operating)
  • Depreciation (accounting, not cash)
  • Owner's personal expenses inappropriately run through the property

Common seller trick: treating a roof repair as "capital" when it's really ongoing maintenance, or treating leasing commissions as "below NOI" when they're a recurring cost of operating a multi-tenant building. When comparing properties, normalize — move leasing costs and reserves above the NOI line so all deals are compared apples-to-apples.

Getting accurate Year-1 expenses

Three sources, in order of reliability:

1. The trailing 12-month operating statement (T-12)

The actual expenses the property ran over the last 12 months. This is your best data — real bills, real checks written. Review every line for one-time items that need to be normalized out (a $30K roof repair from a storm, a $15K legal bill from an eviction) and for recurring items that might not be in the T-12 (the seller was self-managing and didn't pay management fees, but you will).

2. Appraisal market expense comps

Appraisers survey comparable properties and publish average expense ratios. Use these to sanity-check the T-12. If the T-12 shows 28% expense ratio but appraisal comps show 38%, something is under-reported.

3. Industry benchmarks (IREM, NAA, BOMA)

Published per-unit and per-square-foot expense benchmarks. Less granular than a T-12 but useful when you have no property-specific data.

Expense growth rates

Not every expense grows at the same rate. Treating them all as "3% inflation" is lazy and wrong.

| Category | Typical growth rate | Why | |---|---|---| | Property taxes | 2-4% | Assessed value adjustments, millage changes. In Florida, Save-Our-Homes caps apply only to homesteads — commercial has no cap. | | Insurance | 5-15%+ | Running way above inflation — coastal Florida insurance is doubling every 3-5 years | | Utilities | 3-5% | Tracks energy costs | | Repairs & maintenance | 3-4% | Roughly tracks inflation but trending up with labor costs | | Management fees | Tracks EGI | As a % of EGI, grows as revenue grows | | Landscaping / services | 3-4% | Labor-driven | | Payroll | 3-5% | Wage inflation | | Reserves | 3% | Usually modeled flat or with inflation |

Insurance is the biggest trap in 2024-2026. If you're underwriting a Florida coastal property and assuming 3% insurance growth, you're going to miss badly. Use 10-15% for coastal Florida and 5-8% for inland. Pull actual insurance quotes before closing, not after.

Property taxes at acquisition

Here's a mistake that burns new investors: property taxes will reset when you buy the property. The seller's current tax bill reflects an assessed value that may be years out of date. When you buy, the county reassesses based on your purchase price.

In Florida (and most states), this means your Year-1 property tax bill will be dramatically higher than the seller's.

Example. A $4M multifamily property:

  • Seller's current assessed value: $2.5M (stale assessment)
  • Seller's property tax: $2.5M × 2% millage = $50,000/year
  • Your purchase price: $4.0M
  • Your Year-1 tax bill: $4.0M × 2% = $80,000/year

That's $30,000 of extra expense that wasn't on the seller's T-12. At a 6% cap rate, $30,000 of expense erases $500,000 of property value. Always re-estimate property taxes at your purchase price using the current millage rate — and factor in the timing lag (your bill might not reset until the following tax year, so there might be 6-18 months of partial savings).

In Florida specifically, call the county appraiser's office and ask for the projected reassessment. Or use the simple formula: your purchase price × the current millage rate (check the TRIM notice or the tax collector's website for the rate).

Management fees — don't skip them

If the seller was self-managing, the T-12 won't show a management fee. But you (probably) won't self-manage, so you need to add a management fee into your pro forma:

| Asset type | Management fee (% of EGI) | |---|---| | Multifamily 20–100 units | 4–6% | | Multifamily 100+ units | 3–4% | | Retail strip center | 4–5% | | Office | 3–4% | | NNN single tenant | 1–2% (mostly administrative) |

Also add the cost of a property-management software subscription ($50-200/month), occasional professional services, and on-site labor if applicable.

Rule of thumb: if the seller didn't show a management fee, add 4% of EGI to your pro forma. If the seller showed 2%, bump it to 4%.

Replacement reserves — the line sellers love to skip

Every property wears out. Roofs need replacing, HVAC systems die, parking lots need repaving, water heaters fail. Over a 20-year holding period, these capital costs add up to real money — typically $200-500/unit/year for multifamily, $0.15-0.30/sq ft for retail.

Institutional investors always book a replacement reserve as an above-NOI expense. Individual sellers almost never do — they treat these as one-time events below NOI. The result: the seller's NOI looks higher, but the long-run cash flow to the owner is the same.

Benchmarks for replacement reserves:

| Property type | Reserve budget | |---|---| | Multifamily (stabilized) | $250-400 per unit per year | | Multifamily (older Class C) | $400-600 per unit per year | | Retail strip | $0.15-0.25 per SF per year | | NNN single tenant | Minimal — tenant responsible for most items | | Office | $0.25-0.50 per SF per year | | Industrial / warehouse | $0.10-0.20 per SF per year |

Always include reserves. Lenders (especially agency lenders on multifamily) will require them anyway — typically $250-300/unit — and will escrow the money monthly.

A clean expense section

Here's what a well-built expense section looks like, with mixed growth rates:

                                Year 1      Year 2      Year 3      Year 4      Year 5
Property taxes  (3% growth)     80,000     82,400      84,872      87,418      90,041
Insurance       (10% growth)    18,000     19,800      21,780      23,958      26,354
Management fee  (4% of EGI)     13,444     14,093      14,755      15,430      15,893
Repairs & Maint (3.5% growth)   28,000     28,980      29,994      31,044      32,130
Utilities       (4% growth)     15,000     15,600      16,224      16,873      17,548
Landscaping     (3% growth)      6,000      6,180       6,365       6,556       6,753
Trash           (3% growth)      4,500      4,635       4,774       4,917       5,065
Pest control    (3% growth)      2,400      2,472       2,546       2,623       2,701
Legal/Accounting (3% growth)     3,000      3,090       3,183       3,278       3,377
Payroll         (3.5% growth)   12,000     12,420      12,855      13,305      13,771
Reserves        (3% growth)      6,000      6,180       6,365       6,556       6,753

Total OpEx                     188,344    195,850     203,713     211,958     220,386
EGI                            336,096    352,327     368,874     385,751     397,322
NOI                            147,752    156,477     165,161     173,793     176,936

Every line has its own growth rate. Insurance runs at 10%, property taxes at 3%, payroll at 3.5%, reserves at 3%. This gives you a realistic expense trajectory — not the "all expenses grow at 3%" fantasy.

The expense ratio sanity check

After you build the expense section, calculate the expense ratio (OpEx ÷ EGI) and check it against industry norms:

| Asset class | Typical expense ratio | |---|---| | Class A multifamily | 30-40% | | Class B multifamily | 40-50% | | Class C multifamily | 45-55% | | Stabilized retail (NNN) | 15-25% (net of recoveries) | | Stabilized retail (gross) | 35-45% | | Office | 35-50% | | NNN single tenant | 2-5% (nearly all recovered) | | Industrial / warehouse | 15-25% | | Self-storage | 35-45% |

If your pro forma shows a Class C multifamily at 35% expense ratio, something is wrong — probably management fees or reserves are missing. Back into the right ratio and figure out which line is off.

What to take away

  • Expenses are as important as revenue — a 10% miss on expenses hurts value as much as a 10% miss on revenue
  • Use the T-12 as your starting point, then normalize for one-time items and add missing lines (management, reserves)
  • Growth rates are NOT uniform — insurance is running 10%+, taxes 3-4%, management tracks EGI
  • Reset property taxes at your purchase price, not the seller's stale assessed value
  • Always include a replacement reserve even if the seller didn't
  • Sanity-check the expense ratio against industry norms

Next lesson: building the loan amortization schedule — monthly P&I calculations, DSCR compliance, and how to handle balloon payments at loan maturity.

Get Market Insights Delivered

Weekly Central Florida CRE updates — cap rates, new listings, market trends, and investment opportunities. No spam, unsubscribe anytime.