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
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.
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.
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.
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.
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
15,000 sq ft
Renewal options:
90 days notice
90 days notice
Lease expiration:
March 2026
March 2026
Status:
Action required
Action required
Amend Lease
Set Alert