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

Separating base rent from recoveries in a commercial rent schedule

A practical guide for sponsors to prepare a clear rent schedule that distinguishes base rent from tenant recoveries, with a concrete worksheet and evidence checklist to support lender underwriting.

Source: CodexTopic: Commercial lease analysis1093 wordsUpdated 2026-11-19

A practical guide for sponsors to prepare a clear rent schedule that distinguishes base rent from tenant recoveries, with a concrete worksheet and evidence checklist to support lender underwriting.

When you present a commercial property to a lender, the rent roll is one of the first documents they review. A common issue that slows down underwriting is a rent schedule that lumps base rent together with tenant recoveries—items like common area maintenance (CAM), taxes, insurance, and utilities. This guide explains how to separate these items clearly, why it matters for the financing discussion, and provides a concrete worksheet you can prepare.

Why base rent and recoveries need separate lines

A lender uses the rent roll to assess the property's income stability and the quality of the lease structure. Base rent is the guaranteed minimum income from a tenant, while recoveries are variable reimbursements for expenses the landlord pays on behalf of tenants. [1] explains that lease terms can vary from lease to lease, so agreements should always be reviewed to determine which expenses are the landlord's responsibility. By separating these on your schedule, you show the lender you understand the difference and can track each component.

The OCC handbook notes that even if a rent roll shows high occupancy, actual collections should be examined to determine true economic occupancy [1]. A combined figure can mask whether a tenant is paying full rent or just reimbursing costs. This distinction affects how the lender calculates net operating income (NOI) and debt service coverage.

What to include in a clean rent schedule

A well-prepared rent schedule should list each tenant, their unit, lease start and end dates, and then break down monthly income into:

  • Base rent: The fixed minimum rent per the lease.
  • CAM recoveries: Reimbursements for common area maintenance, which may include landscaping, refuse collection, parking lot lighting, and snow removal [1].
  • Tax and insurance recoveries: Reimbursements for property taxes and insurance premiums.
  • Utility recoveries: Payments for separately metered or allocated utilities.
  • Percentage rent: For retail tenants, additional rent based on sales above a threshold. [1] notes that percentage rents may vary considerably and are inherently less predictable.
  • Other income: Parking fees, storage fees, or late fees.

For each line, note whether the amount is fixed, variable, or based on a formula. This helps the lender understand income reliability.

How to prepare a rent schedule worksheet

Below is a suggested format for a rent schedule worksheet. You can create this in a spreadsheet or as a table in your loan request package.

Rent Schedule Worksheet

For each tenant, record:

  • Tenant name
  • Unit number
  • Lease start date
  • Lease end date
  • Rentable square feet
  • Annual base rent per square foot
  • Monthly base rent
  • Monthly CAM recovery (actual or estimated)
  • Monthly tax recovery
  • Monthly insurance recovery
  • Monthly utility recovery
  • Monthly percentage rent (if applicable)
  • Total monthly rent (sum of all components)
  • Any rent concessions or free rent periods
  • Any co-tenancy clauses that could reduce rent [1]

Then, total each column across all tenants to show the aggregate monthly base rent, total recoveries, and total gross rent. This gives the lender a clear picture of income composition.

Reconciling the rent roll with the trailing twelve months

A current rent roll is a snapshot of today's income. A trailing twelve-month (T-12) operating statement shows historical performance. These two documents can differ because the rent roll reflects current leases, while the T-12 includes past vacancies, lease-ups, and changes. The OCC handbook advises that for construction loans, the borrowing base certificate should be compared to monthly financial statements, and any discrepancy may indicate potential problems [1].

To reconcile:

  • Compare the current month's gross rent on the T-12 to the total from the rent roll.
  • Identify any tenants that moved in or out during the trailing period.
  • Note any rent abatements or concessions that affected historical income but are not in the current schedule.
  • Explain one-time items, such as legal settlements or insurance claims, that appear in the T-12 but are not recurring.

This reconciliation shows the lender you understand the property's income history and can project future cash flows accurately.

Distinguishing gross rent, collected income, NOI, and debt service

A lender evaluates several income and cash flow metrics. Understanding the differences helps you present a coherent financial picture:

  • Gross rent: The total of all base rents, recoveries, and other income before any deductions.
  • Collected income: Gross rent minus vacancies, concessions, bad debts, and collection losses. [1] emphasizes that actual collections should be examined to determine true economic occupancy.
  • Net operating income (NOI): Collected income minus operating expenses (excluding debt service). This is the income available to pay the loan.
  • Debt service: The total of principal and interest payments on the loan.
  • Equity cash flow: The amount left after debt service from NOI.

When you present your rent schedule, include a clear calculation of NOI and show how it covers projected debt service. This helps the lender assess the property's ability to support the loan.

Evidence checklist for your loan request

Before submitting your rent schedule, gather the following evidence to support the figures:

  • [ ] Current rent roll with base rent and recoveries separated
  • [ ] Trailing twelve months of operating statements (T-12)
  • [ ] Reconciliation between rent roll and T-12
  • [ ] Copies of all current leases (or a lease abstract summarizing key terms)
  • [ ] Documentation of any CAM, tax, insurance, or utility recovery formulas
  • [ ] Evidence of collection history (e.g., rent receipts, bank statements)
  • [ ] Property tax bills and insurance policies to verify recovery amounts
  • [ ] Any co-tenancy clauses or other lease provisions that could affect income [1]
  • [ ] Management company's report on collection efforts, if applicable [1]

Having this evidence ready shows the lender you have a thorough understanding of your property's income and can support your loan request.

FAQs

How often should I update the rent schedule?

Update the rent schedule monthly, or whenever a lease changes. The OCC handbook notes that borrowing base certificates are typically prepared monthly [1]. A current schedule helps the lender track changes in occupancy and income.

What if my leases have different recovery structures?

List each lease separately and note the specific recovery method. [1] states that because terms vary, lease agreements should always be reviewed to determine which expenses are the landlord's responsibility. This transparency helps the lender understand the property's income variability.

Can I include estimated recoveries if actual amounts vary?

Yes, but label them clearly as estimates and explain the basis. For example, you might estimate CAM based on the previous year's average. The lender will verify with the T-12 and lease terms. Actual collections should be tracked separately [1].

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