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

Documenting who pays which expenses under a commercial lease

A practical guide for sponsors to prepare the lease-expense documentation lenders will use to underwrite net operating income, including a worksheet to reconcile rent-roll data with trailing-12 operating statements.

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

A practical guide for sponsors to prepare the lease-expense documentation lenders will use to underwrite net operating income, including a worksheet to reconcile rent-roll data with trailing-12 operating statements.

Identify expense responsibilities from each lease

For every tenant, locate the lease clause that lists which operating expenses the landlord pays and which the tenant pays directly. Common landlord-paid items include property taxes, insurance, common-area maintenance, and structural repairs; tenant-paid items often include utilities, janitorial, and interior maintenance. Because office leases are usually written on a gross basis with the tenant responsible only for utilities and janitorial, the landlord’s expense burden can be higher than in a triple-net lease where the tenant pays taxes, insurance, and CAM. [1] The OCC handbook reminds lenders that lease agreements should always be reviewed to determine which expenses are the landlord’s responsibility, since terms can vary from lease to lease even within the same building. [1]

Prepare a current rent roll showing expense pass-throughs

A current rent roll is a snapshot of each tenant’s base rent, any additional rent (such as CAM charges, tax escalations, or insurance reimbursements), the lease expiration date, and the expense-reimbursement method. Record whether the lease is gross, modified gross, triple-net, or another structure. If the lease requires the tenant to reimburse the landlord for a portion of operating expenses, note the basis—for example, a pro-rata share of actual costs, a fixed monthly amount, or a cap on increases. This document becomes the starting point for estimating the landlord’s net effective income after all expense obligations. [1]

Gather the trailing-12 operating statements (T-12)

The T-12 is twelve consecutive months of historical income and expense figures, usually prepared on a cash basis, which reflects only the income and expenses that were actually received or paid during the year. [1] For example, if real estate taxes were not paid during a particular month, a cash-basis statement would understate expenses and overstate income compared with an accrual-basis financial statement. [1] The T-12 is a historical record, not a projection. Compare each line item—such as repairs and maintenance, utilities, management fees, and property taxes—against the rent roll to verify that the actual expenses align with the lease obligations. Any variance may indicate a tenant not reimbursing as required or a landlord paying an expense that should have been passed through.

Reconcile the rent roll and T-12 timing differences

The rent roll is a snapshot at a single point in time; the T-12 covers the prior twelve months. Before comparing totals, adjust for timing differences. For example, if a lease began mid-year, the T-12 will include only partial rent from that tenant. Similarly, if a tenant vacated during the period, the T-12 may show vacancy loss that is not reflected on the current rent roll. Identify and record these timing gaps so that the underwriting analysis uses a stabilized estimate of income and expenses rather than a mismatched set of numbers. [1]

Calculate net operating income (NOI) from the reconciled data

Once the rent roll and T-12 are aligned, compute NOI by starting with gross potential rent, subtracting vacancy and collection loss, adding other income (such as parking or late fees), and then subtracting all operating expenses that the landlord is responsible for under the leases. The OCC handbook states that an important objective of underwriting is to develop an NOI that represents a stabilized estimate of income and expenses. [1] Do not include debt service or capital expenditures in NOI; those are separate line items in the cash-flow analysis. Distinguish between gross rent (the total contractual rent), collected income (the rent actually received), NOI, capital expenditures, debt service, and equity cash flow. Each serves a different purpose in the financing discussion.

Document expense categories that affect debt-service coverage

The debt-service coverage ratio (DSCR) is calculated by dividing NOI by annual debt service requirements. [1] The OCC handbook advises that the determination of an appropriate DSCR should consider the loan amortization period and the expected volatility of the cash flow. [1] For leases with stable, long-term net leases to highly creditworthy tenants, a lower DSCR may be acceptable. [1] Therefore, document which expenses are fixed (e.g., property taxes, insurance) and which are variable (e.g., repairs, utilities). If ground rent is paid, deduct it as an expense before calculating DSCR. [1] Also note any replacement reserves for capital items such as roof replacement or HVAC, which are typically underwritten on an annual per-square-foot basis and vary by property age and condition. [1]

Prepare a worksheet for the sponsor’s review

Create a simple spreadsheet with the following columns: tenant name, lease type, base rent per month, additional rent per month, landlord-paid expenses (list each category), tenant-paid expenses (list each category), and any reimbursement mechanism. Then add a section for the T-12: for each month, record gross rent, collected income, total operating expenses paid by landlord, and NOI. Finally, add a reconciliation section where you note any timing differences between the rent roll and T-12 and adjust the NOI to a stabilized estimate. This worksheet is a suggested way to prepare information for the lender; it is not a mandated form.

Frequently asked questions

Does the lender require the T-12 to be on an accrual basis?

No. The T-12 is often prepared on a cash basis, and the OCC handbook notes that this can understate expenses or overstate income compared with accrual-basis statements. [1] The lender will compare the reported expenses to those of comparable properties, adjusted for supported variances and lease terms. [1] The key is to be transparent about the reporting basis and to reconcile any timing differences.

If my rent roll shows a tenant reimbursing CAM, do I still include CAM in my NOI calculation?

Yes. CAM reimbursements are typically recorded as other income, not as a reduction in expenses. You should include the full CAM cost as an operating expense and then add the reimbursement as income. This gives the lender a clear picture of the gross expense burden and the tenant’s contribution.

What if a tenant’s lease has a cap on expense increases?

Document the cap amount and the base year used. The lender will want to stress-test the NOI under the assumption that expenses may exceed the cap in future years. Include a note in your worksheet showing the cap and the potential exposure to the landlord if actual expenses exceed it.


We will review your materials and let you know how we would approach the request. All financing is subject to lender underwriting and approval.

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