Can I Afford This Property?Commercial real estate financing, worked out

Documenting retail percentage rent separately from fixed rent

A practical guide to preparing a percentage rent workpaper that separates variable sales-based rent from fixed base rent, and how lenders evaluate the two income streams differently for underwriting retail properties.

Source: CodexTopic: Property-specific operating packages1201 wordsUpdated 2026-11-19

A practical guide to preparing a percentage rent workpaper that separates variable sales-based rent from fixed base rent, and how lenders evaluate the two income streams differently for underwriting retail properties.

Why lenders separate percentage rent from fixed rent

Retail leases commonly include a fixed minimum rent plus a percentage of the tenant's annual sales above a breakpoint. Percentage rents may vary considerably and are inherently less predictable than flat-rate rent [1]. Lenders treat these two income streams differently because they carry different risk profiles. Fixed rent is contractual and predictable, while percentage rent depends on tenant sales performance, which can fluctuate with economic conditions, competition, and management quality. Separating them in your loan request allows the lender to underwrite the property's income more accurately.

Preparing the percentage rent workpaper

Create a document that lists each retail tenant with a percentage rent clause. For each tenant, record the following: tenant name, lease expiration date, base rent per square foot, the sales breakpoint at which percentage rent begins, the percentage rate applied to sales above the breakpoint, and actual sales figures for the trailing twelve months (T-12). Calculate the percentage rent collected each month over the T-12 period. Then total the percentage rent and compare it to the fixed rent for the same period. This workpaper is separate from the rent roll, which is a snapshot of current rent, not a historical record. The T-12 shows the actual collection history, which is what the lender will use to evaluate the predictability of percentage rent.

Reconciling gross rent, collected income, and NOI

Gross rent includes both fixed and percentage rent as billed. Collected income is what the landlord actually received, which may differ if percentage rent was not paid or was disputed. Net operating income (NOI) is collected income less operating expenses. The OCC handbook emphasizes that actual collections should be examined to determine true economic occupancy and evaluate property management effectiveness [1]. When you present the percentage rent workpaper, reconcile it to the T-12 operating statements so the lender can see how percentage rent flows through to NOI. If percentage rent is a material part of income, the lender may underwrite it at a discount or require a history of consistent collection.

Evaluating the predictability of percentage rent

The OCC handbook notes that the flat rate in a retail lease should be high enough to dissuade the tenant from ceasing operations while maintaining possession to prevent the landlord from leasing to a competitor [1]. This means the base rent should cover the property's fixed costs, and percentage rent should be treated as upside. In your workpaper, note whether the base rent alone covers debt service and operating expenses. If percentage rent is needed to meet debt service, the lender will scrutinize the tenant's sales history and the likelihood of continued performance. Compare the tenant's sales trend over the T-12 period: is it stable, growing, or declining? Identify any seasonal patterns or one-time events that affected sales. This analysis helps the lender assess the risk that percentage rent may not recur.

Accounting for co-tenancy and operating clauses

Some retail leases contain co-tenancy clauses that allow a tenant to reduce rent or terminate if an anchor tenant ceases operations [1]. If percentage rent is tied to an anchor's performance, a co-tenancy trigger could reduce both fixed and percentage rent. Also check whether the lease requires the tenant to continue operating. The OCC handbook notes that it is desirable for an anchor tenant's lease to require continued operations so the tenant may be replaced if it ceases to operate [1]. In your workpaper, flag any lease clauses that could reduce or eliminate percentage rent. The lender will want to understand the probability of these clauses being triggered and the impact on income.

Considering re-leasing costs and market context

While the OCC handbook does not prescribe specific underwriting assumptions for percentage rent, it notes that leasing commissions and tenant improvement costs are important underwriting considerations for retail properties [1]. If percentage rent is volatile, the lender may underwrite higher re-leasing costs in case the tenant leaves. In your workpaper, compare the percentage rent as a percentage of total rent to typical market data for similar properties. If your percentage rent is above market, be prepared to explain why. If it is below market, the lender may see upside potential. This comparison is not a guarantee of underwriting treatment, but it helps the lender frame the risk.

Preparing the evidence checklist

Assemble the following documents to support your percentage rent workpaper:

  1. Current rent roll showing all retail tenants, lease terms, and base rent per square foot.
  2. T-12 operating statements showing actual income and expenses month by month.
  3. Percentage rent workpaper with the calculations described above.
  4. Copies of the lease clauses that define percentage rent, co-tenancy, and operating requirements.
  5. Tenant sales reports for the T-12 period, if available.
  6. A reconciliation of percentage rent to total rent and NOI.
  7. A narrative explaining any anomalies in percentage rent collection, such as disputes, late payments, or one-time events.

This checklist is a borrower-created organizing practice, not a mandatory lender requirement. The lender may ask for additional items based on the property's specific risk profile.

How this affects the financing discussion

Lenders use the percentage rent analysis to assess the stability and predictability of the property's income stream. If percentage rent is a material part of income and is volatile, the lender may offer lower leverage, require a debt service coverage ratio that excludes percentage rent, or impose a reserve for income shortfalls. A property with unpredictable percentage rent may be seen as higher risk, which could affect pricing or loan terms. By presenting a clear, separate workpaper, you demonstrate that you understand the risk and have analyzed it, which can support a more favorable underwriting outcome.

Frequently asked questions

Does a lender always discount percentage rent in underwriting? No. The treatment depends on the tenant's credit quality, sales history, and the lease structure. Some lenders underwrite percentage rent at face value if the tenant is strong and the history is consistent. Others apply a haircut or exclude it from debt service coverage. Ask the actual lender how they treat percentage rent for your specific property.

Can percentage rent be used to qualify for a higher loan amount? It can, but only if the lender is satisfied that the income is predictable and likely to continue. The lender will evaluate the tenant's sales trend, the lease term, and the likelihood of renewal. Percentage rent that is volatile or dependent on a single tenant is less likely to support higher leverage.

What if a tenant's sales drop after closing? The lender's underwriting typically assumes current conditions. If sales drop, the property's income may fall short of projections. The lender may require a reserve or a debt service coverage ratio that does not rely on percentage rent. The OCC handbook notes that future demand can be difficult to predict and supply often overestimates demand, leading to prolonged lease-up periods and declines in rental rates [1].


Send us the property, the business plan, and the capital you need, and we will tell you how we would approach it.*

Run the numbers on your deal

Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.

Open the loan sizing calculator

Talk through your financing

Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. OCC Commercial Real Estate Lending handbook
  2. Wraith commercial real estate debt