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

Testing a multifamily model when an expense estimate is uncertain

A practical guide to stress-testing a multifamily pro forma when expense data is incomplete or inconsistent, with a concrete evidence checklist to prepare.

Source: CodexTopic: Operating expense reconciliation1102 wordsUpdated 2026-11-19

A practical guide to stress-testing a multifamily pro forma when expense data is incomplete or inconsistent, with a concrete evidence checklist to prepare.

When you are financing a multifamily property, the lender's underwriter will want to see that your net operating income (NOI) can support the debt service even if expenses turn out higher than expected. If your expense estimate is uncertain—because the property is newly built, has limited history, or uses cash-basis accounting—you need a way to test the model without relying on assumptions. This guide gives you a concrete task: prepare an operating expense reconciliation worksheet that compares your property's expenses to those of comparable properties, adjusted for supported variances and lease terms.

Prepare a trailing twelve-month operating statement on an accrual basis

A trailing twelve-month (T-12) operating statement shows twelve consecutive months of income and expenses. Unlike a current rent roll, which is a snapshot, the T-12 gives a historical view. If your financial statements are prepared on a cash basis, they reflect only income received and expenses paid during the year, not expenses incurred. For example, if real estate taxes were not paid that year, the cash-basis statement would understate expenses and overstate income compared to an accrual basis. [1] To reconcile, you should convert the T-12 to an accrual basis by adding unpaid invoices and adjusting for prepaid items. Record the reporting basis on each statement so the lender can see the difference.

Build an operating expense reconciliation worksheet

Create a simple spreadsheet with three columns: your property's expenses, expenses from comparable properties, and the difference. List each expense category: property taxes, insurance, utilities, repairs and maintenance, management fees, and replacement reserves. For each category, note whether your figure is actual, budgeted, or estimated. Then find comparable properties and record their expenses, adjusted for supported variances and lease terms, as the OCC handbook suggests. [1] The lender will use this comparison to see if your estimates are in line. If your expenses are lower than comparables, be ready to explain why: newer equipment, longer warranty, or lower management fees.

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

Gross rent is the total potential rent if all units are leased at market rates. Collected income is what you actually received after vacancies, concessions, and bad debt. NOI is gross income minus operating expenses, excluding interest, principal, and income taxes. [1] Debt service is the annual principal and interest payments on the loan. The debt-service coverage ratio (DSCR) is NOI divided by annual debt service. [1] When you present your pro forma, show each of these figures separately. If your NOI is based on collected income and you assume a low vacancy rate, the lender may stress-test it by applying a market vacancy rate that is higher than your actual rate. [1]

Stress-test the NOI with a higher expense assumption

Take your best estimate of NOI and reduce it by a reasonable margin to simulate higher expenses. Then recalculate the DSCR. The lender will want to see that the DSCR stays above their minimum covenant, even under stress. The OCC guidance recommends stress-testing capitalization rates, interest rates, and DSCRs under both normal and stressed conditions. [1] This is not a prediction of what will happen; it is a way to identify whether your business plan has room for expense volatility.

Identify capital expenditures that are not in the tax return

Some capital expenditures, like replacing a roof or HVAC system, are not shown as an expense on tax returns because they are capitalized. [1] Yet they affect NOI because a replacement reserve is set aside for them. If your pro forma does not include a replacement reserve, the lender may add one. To prepare, calculate an annual reserve based on the property's age and condition, as the OCC handbook notes that replacement reserves are captured in NOI analysis. [1] Record this as a separate line item in your expense reconciliation worksheet. This shows the lender you have accounted for long-term capital needs, even if they are not immediate cash expenses.

Compare your lease terms to the expense allocation

Lease terms determine which expenses the tenant pays. A triple net (NNN) lease requires the tenant to pay taxes, insurance, and maintenance, but the term "triple net" lacks a universally agreed-upon definition. [1] Always analyze the actual lease to see who is responsible for each expense. If your property has gross leases, the landlord pays all operating expenses, so your expense estimate should be higher. If you have a mix of lease types, separate them in your worksheet. The lender will adjust your NOI based on the lease structure, so having this analysis ready saves time.

Ask the actual lender about their DSCR covenant

Debt-service coverage covenants in loan documents may define income and expenses differently than the DSCR used for underwriting. [1] The lender's definition of income and expenses for covenant compliance may differ from the DSCR used for underwriting. [1] Before you finalize your pro forma, ask the lender for their standard DSCR definition. This is not a fixed rule for all lenders; it is a practical step to align your numbers with their requirements. Record the lender's definition and adjust your worksheet accordingly.

Frequently asked questions

How do I know if my expenses are reasonable without comparable data? You can use industry benchmarks from local apartment associations or published surveys. The key is to document the source of your benchmark and adjust for your property's specific characteristics, such as age, size, and amenities. The lender will compare your figures to their own database, so transparency about your assumptions helps.

What if my property has less than twelve months of operating history? For a new property, you will rely on a pro forma based on market comparables. In that case, the expense reconciliation worksheet should use comparable properties' expenses as the primary estimate. The lender may also require a larger equity contribution or a shorter interest-only period to compensate for the lack of history.

Does a higher DSCR always mean a better loan application? Not necessarily. A very high DSCR might indicate that you are understating expenses or overstating income. The lender looks for a DSCR that is realistic and stable under stress. A moderate DSCR with a well-supported expense estimate is often stronger than a high DSCR built on aggressive assumptions.


Ready to arrange financing? Share the property, your business plan, the amount you need, and your timeline. [2]

All financing is subject to the lender's underwriting and approval. This guide is based on OCC supervisory guidance and is not a substitute for professional advice.*

Model this deal and request financing

Run a multifamily acquisition or value-add model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.

Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.

Open the acquisition model

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