Percentage Rent Calculator

Our Percentage Rent – Excel Template helps you calculate the additional rent you owe based on in-store sales.

  • Input sales. Get rent. — Quickly calculate your base + percentage rent in Excel.
  • Negotiate smarter — Model breakpoints and rent caps to prepare for renewals.
  • Stay compliant — Easily track and report rent due under your lease agreement.

Lease + Revenue Intelligence

Managing lease obligations and rent payments doesn’t have to be complicated. Occupier and Guesst have partnered up to support retailers and brands. Together we streamline lease management, automate rent payments, analyze percentage rent and store revenue in order to gain real-time sales insights, all in one seamless workflow.

Frequently Asked Questions

What is percentage rent?
arrow_drop_down
Percentage rent is an arrangement where tenants pay a base rent plus a percentage of their gross sales. This incentivizes landlords to support tenants’ business success.
Who typically uses percentage rent agreements?
arrow_drop_down
This type of lease is commonly used in retail settings, especially for high-volume businesses like those in shopping centers, but can also apply to smaller businesses benefiting from high foot traffic.
What are the advantages of percentage rent for tenants?
arrow_drop_down
Tenants may enjoy lower base rents and flexibility during slower sales months, allowing them to pay less when business is down, which can help with cash flow management.
How can tenants negotiate percentage rent terms?
arrow_drop_down
Tenants should research market rates, consider the stability of their sales, and negotiate for favorable terms like lower breakpoints or caps on rent increases to balance affordability with potential growth.
What do I need to consider when calculating percentage rent?
arrow_drop_down
Percentage rent is calculated as a percentage of a tenant's gross sales above a predetermined breakpoint, so the two most critical variables are the breakpoint threshold and the percentage rate negotiated in the lease. The natural breakpoint is calculated by dividing the base rent by the percentage rate, but leases sometimes include an artificial breakpoint that's set higher or lower, which significantly affects how much additional rent is owed. You also need to clearly define what's included in gross sales — exclusions like online sales, returns, employee discounts, and sales tax are commonly negotiated out and must be tracked separately to avoid overpaying.
Occupier Lease Management

Never miss a critical date again.

See how Occupier keeps Real Estate and Finance teams ahead of every deadline
Boston HQ
Size:
15,000 sq ft
Renewal options:
90 days notice
Lease expiration:
March 2026
Status:
Action required
Amend Lease
Set Alert