Opex Bridge Calculator

Opex variance has many drivers. This calculator decomposes the year-over-year change.

Prior opex

Payroll change

R&M change

Utilities change

Tax/insurance change

Bridged opex

$2,923,000

Total change

$273,000

Growth rate %

10.30%

How the math works

Bridged = prior + payroll + R&M + utilities + tax/insurance.

Compare tax/insurance growth to rent growth. When non-controllable opex grows 8-10% annually while rent grows 3-5%, NOI margin compresses structurally — at some point, the fix is asset disposition, not management tuning.

How to Use

Enter prior opex.
Enter payroll change.
Enter R&M change.
Enter utilities change.
Enter tax/insurance change.
Read bridged opex and drivers.

Frequently Asked Questions

Typical drivers?

Tax and insurance: 20-40% of opex in many sectors (both rising fastest in 2022-2024). Payroll: 25-40% with high variance. R&M: 10-25%. Utilities: 5-15% depending on who pays. Marketing: 1-5%.

Inflation exposure?

Payroll: matches or exceeds CPI when labor tight. Insurance: 10-25% annual in hard market. Property tax: market-driven (assessments lag 1-3 years). Utilities: commodity-linked. R&M: 8-15% when trade labor tight.

Controllable vs not?

Payroll and R&M are controllable (management skill). Tax, insurance, utilities largely non-controllable (market + govt). When opex rises faster than benchmark, check if it's controllable lines — that's where management can actually move numbers.

How often should I rerun this?

Rerun this calculator whenever inputs change materially — new rent roll data, rate moves, loan balance updates, or quarterly operating data. For active deals, monthly refresh is typical. For stabilized assets under monitoring, quarterly is fine. Treat the output as a decision tool, not a one-time answer — market conditions evolve and so should your analysis.