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

Reconciling an insurance quote with a property's operating expense budget

This guide explains how to reconcile an insurance premium quote with a property's trailing twelve-month operating statements and rent roll, producing a workpaper that shows the lender how the expense fits the property's net operating income and debt service coverage.

Source: CodexTopic: Environmental and physical diligence1265 wordsUpdated 2026-11-19

This guide explains how to reconcile an insurance premium quote with a property's trailing twelve-month operating statements and rent roll, producing a workpaper that shows the lender how the expense fits the property's net operating income and debt service coverage.

When a sponsor presents a loan request for an existing income-producing property, the lender reviews the trailing twelve months of operating statements, the current rent roll, and the proposed pro forma. An insurance premium quote that appears in the budget must tie to the property's actual operating expense history. This article provides a step-by-step method to reconcile the quote with the property's financials and produce a workpaper that supports the underwriting discussion.

Identify the reporting basis of the operating statements

Before comparing an insurance quote to the property's operating expenses, determine whether the trailing twelve months (T-12) statements were prepared on a cash basis or an accrual basis. The OCC Commercial Real Estate Lending handbook notes that a cash-basis statement "reflects only the income and expenses that were actually received or paid during the year" and warns that "a tax return for a property for which real estate taxes were not paid during that year would understate expenses and overstate income compared with financial statements prepared on an accrual basis" [1]. Record the basis and, if cash, note any timing differences that affect the insurance expense line. For example, if the insurance premium was paid in a lump sum in a different period, the cash-basis statement may show no monthly expense for that item.

Compare the quoted premium to the historical insurance expense

Obtain the current insurance premium quote for the property. Locate the insurance expense line on the T-12 statements. If the property's historical insurance expense is materially lower than the quote, identify the reason: a change in coverage limits, a different carrier, or a prior period where the expense was not recorded because it was paid from a different entity. The OCC handbook advises that "it is helpful to compare reported expenses with expenses incurred by comparable properties, adjusted for supported variances and lease terms" [1]. This same logic applies to comparing the historical insurance line with the new quote. If the quote is higher, the workpaper should explain the variance and show that the sponsor has accounted for the increase in the pro forma.

Distinguish gross rent, collected income, and net operating income

A current rent roll is a snapshot of signed leases and their contractual base rents. The T-12 reports historical income and expenses on its stated accounting basis and expenses over twelve historical months. The OCC handbook defines net operating income (NOI) as "annual gross income less operating expenses" and notes that operating expenses "do not include interest, principal, or income taxes" [1]. To reconcile the insurance quote, you need the NOI from the T-12, not the gross rent. Calculate the NOI by subtracting total operating expenses (including the historical insurance line) from gross income. Then, adjust the NOI for the new insurance premium. This adjustment shows the lender the impact of the higher expense on the property's cash flow.

Prepare a workpaper that shows the reconciliation

Create a one-page workpaper with the following columns: line item, historical amount from T-12, new quote amount, variance, and explanation. Include the insurance premium as a line item. Then, show the T-12 NOI, subtract the variance (if the new quote is higher), and present the adjusted NOI. This workpaper is not a lender requirement but a suggested way to prepare information for the underwriting discussion. The OCC handbook states that "an important objective of the underwriting process is to develop an NOI that represents a stabilized estimate of income and expenses" [1]. The workpaper demonstrates that the sponsor has considered the insurance expense change and its effect on the stabilized NOI.

Calculate debt service coverage with the adjusted NOI

The debt-service coverage ratio (DSCR) is "calculated by dividing the NOI by the annual debt service requirements" and "measures the borrower's ability to service its debt" [1]. Using the adjusted NOI from the workpaper, divide by the proposed annual debt service (principal and interest payments). The OCC handbook notes that "the determination of an appropriate DSCR should consider the loan amortization period and the expected volatility of the cash flow" [1]. Record the DSCR and note whether the insurance premium increase reduces it below the lender's threshold. If so, the sponsor may need to adjust the loan amount or provide additional support.

Ask the lender about insurance reserve requirements

Some lenders require an insurance reserve account, where a portion of the premium is set aside monthly. This requirement is not a rule that binds every borrower but a term that varies by lender and loan structure. The workpaper should include a line for the proposed reserve, if any, and show how it affects the property's cash flow. The OCC handbook discusses contingency accounts for construction budgets but does not mandate insurance reserves for operating properties [1]. Ask the actual lender what their policy is and incorporate the answer into the pro forma.

Record the source and timing of the insurance quote

Document the date of the insurance quote, the carrier, the coverage limits, and the premium amount. The OCC handbook states that an appraisal should reflect "the property's market value as of a date that is as close as practicable after the effective date of the appraisal" [1]. Similarly, the insurance quote should be current and reflect the property's replacement cost and liability coverage. If the quote is more than 90 days old, obtain a new one before submitting the loan request.

Frequently asked questions

What if the property's historical insurance expense is zero on the T-12?

If the T-12 shows no insurance expense, first confirm the reporting basis. On a cash-basis statement, the premium may have been paid in a prior year and not recorded in the twelve-month period. On an accrual-basis statement, a zero expense may indicate the landlord did not carry insurance or the expense was paid by the tenant under a net lease. Review the lease language to determine who is responsible for insurance. The OCC handbook advises that "the lease itself should always be analyzed to determine the expenses a landlord or tenant is responsible for rather than relying on these terms" [1]. If the tenant pays insurance directly, the expense should not appear in the landlord's operating expenses.

How do I handle a multi-year insurance policy in the reconciliation?

If the insurance policy covers multiple years and the premium is paid upfront, the annual expense for the T-12 should reflect the amortized cost over the policy term, not the lump-sum payment. For example, a three-year policy paid in full should show one-third of the premium as the annual expense. Adjust the workpaper to show the annualized premium and compare it to the historical annualized amount. The OCC handbook does not address multi-year policies specifically, but the principle of matching the expense to the period applies.

Can I use the insurance quote to negotiate the loan terms?

The insurance quote is one data point in the underwriting package. If the premium is higher than the historical expense, the sponsor can explain the variance and show that the NOI still supports the debt service. The OCC handbook notes that "a lower DSCR may be a prudent trade-off for a shorter amortization period or appropriate for properties with stable and certain cash flows" [1]. A higher insurance expense does not automatically disqualify a loan, but the sponsor should be prepared to discuss the impact on cash flow and debt service coverage.

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