Free Base Year Escalation Calculator

Project excess expense obligations over your full lease term. Download free.

Base year leases are the most common expense structure in office properties — and the most prone to forecasting errors that leave recovery revenue on the table. This calculator models excess expense obligations year by year so you can forecast tenant billings with confidence and catch under-recoveries before they compound.

What's inside

  • Projects base year excess expense obligations over the full lease term
  • Models CPI escalation scenarios to compare tenant exposure paths
  • Handles multiple expense categories with separate base year amounts
  • Shows cumulative tenant obligation with year-by-year trend visualization

Built for property controllers managing base year leases across multi-tenant office portfolios where expense escalation drives recovery revenue.

Already have an account? Log in to automate base year escalation tracking entirely.

Get the free calculator

Enter your email and we'll send the download link instantly.

No spam. Unsubscribe anytime.

Frequently Asked Questions

How does a base year lease work for operating expenses?
In a base year lease, the landlord pays all operating expenses in the first year (the base year). In subsequent years, the tenant pays their pro-rata share of any expenses that exceed the base year amount. The base year effectively sets a floor — the tenant only pays the increase above that floor.
What is the difference between a base year and an expense stop?
A base year uses actual first-year expenses as the benchmark, so it floats with market conditions at lease commencement. An expense stop is a fixed dollar amount negotiated upfront. Base years tend to favor tenants in rising-cost environments because the benchmark is tied to real costs. Expense stops give landlords more predictability.
How do you calculate excess expense obligations?
Subtract the base year expense amount from the current year's actual expenses. Multiply the positive difference by the tenant's pro-rata share. If current year expenses are lower than the base year, the tenant owes nothing — there is no credit or refund for underruns in most leases.
How does CPI escalation affect base year calculations?
Some leases escalate the base year amount by CPI annually, which reduces the tenant's excess obligation over time. Without CPI escalation, the base year stays fixed and the tenant's exposure grows each year as expenses naturally increase. Modeling both scenarios helps you forecast recovery revenue accurately.
What happens to the base year when a building is not fully occupied?
If the building was not fully occupied during the base year, variable expenses may be lower than normal. Many leases require the base year to be grossed up to a specified occupancy threshold (typically 95%) so that the benchmark reflects normalized operations. Without a gross-up clause, the base year may be artificially low, increasing tenant obligations in later years.