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

Preparing property-level NOI schedules for a portfolio financing discussion

A practical guide to assembling net operating income schedules that inform refinance risk discussions with lenders, including an evidence checklist and common pitfalls to avoid.

Source: CodexTopic: Portfolio and repayment planning802 wordsUpdated 2026-11-19

A practical guide to assembling net operating income schedules that inform refinance risk discussions with lenders, including an evidence checklist and common pitfalls to avoid.

When you prepare property-level net operating income (NOI) schedules for a portfolio financing discussion, you are building the financial story that lenders use to assess your ability to service debt and refinance at maturity. This guide explains what to include, how to reconcile different reporting periods, and how the information affects the financing conversation.

Identify the reporting basis and reconcile periods

Financial statements may be prepared on a cash basis or an accrual basis. Record which basis each statement uses, because the two can produce different NOI figures for the same period. A rent roll is a snapshot of current leases and occupancy; a trailing twelve-month (T-12) operating statement shows twelve historical months of income and expenses. Before comparing totals, note the timing difference: the rent roll reflects today's contractual rent, while the T-12 reflects what was actually billed and collected over the past year. Reconcile the two by identifying vacancies, concessions, or one-time items that explain variances.

Distinguish gross rent, collected income, NOI, capex, debt service and equity cash flow

Gross rent is the total contractual rent for a period. Collected income is what tenants actually paid, after vacancies, concessions, and bad debt. NOI is collected income minus operating expenses (property management, utilities, insurance, taxes, repairs). Capital expenditures (capex) are improvements that extend asset life, not routine repairs. Debt service is the scheduled principal and interest payments. Equity cash flow is NOI minus debt service and capex. Present each line separately so a lender can see where the property stands before and after financing.

Build a property-level NOI schedule with twelve months of history

Create a spreadsheet with one row per month for the trailing twelve months. Columns should include: gross rent, vacancy/concession adjustments, collected income, operating expenses, NOI, capex, debt service (if any), and equity cash flow. Add a column for notes explaining anomalies (e.g., a large repair, a lease-up period). This schedule is the raw material for the lender's underwriting and for your own stress-testing discussion.

Prepare a stress-testing worksheet to show refinance risk

The OCC guidance on refinance risk notes that transaction-level stress testing can provide insight into the borrower's ability to meet refinancing requirements if financial condition declines or market conditions deteriorate . Prepare a simple worksheet that recalculates NOI under scenarios such as an increase in interest rate, a drop in occupancy, or an increase in operating expenses. For each scenario, show the resulting debt service coverage ratio (NOI divided by annual debt service). This is not a lender requirement, but a suggested way to prepare information for your own planning and for discussions with lenders.

Compare your NOI schedule to upcoming maturities

List all loans on the property with their maturity dates, outstanding balances, and current interest rates. For each loan approaching maturity within 24 months, note whether the current NOI supports refinancing at a higher rate. The OCC guidance states that refinance risk increases in rising interest rate environments because borrowers may be unable to service their debt at higher interest rates upon refinance . Identify any loans with balloon payments or interest-only periods ending soon, as these increase refinance risk.

Organize supporting documents for the lender

Lenders quote on what they are given [1]. Assemble the following for each property: - Current rent roll (dated within 30 days) - Trailing twelve months of operating statements - A pro forma with assumptions (rent growth, expense inflation, vacancy rate) - Schedule of real estate owned - Financial statements for principals and guarantors - Organizational documents for the borrowing entity

This package allows the lender to underwrite the property and compare it to your portfolio.

Review your file for common gaps before the financing discussion

Before you approach a lender, check for these items: - Are the rent roll and T-12 from the same period? If not, note the date difference. - Is the NOI calculated consistently across properties? Use the same expense categories. - Are capex items separated from operating expenses? Lenders treat them differently. - Do you have explanations for any large month-to-month variances in the T-12? - Have you identified all near-term maturities and their refinance risk?

Frequently asked questions

Q: Should I use cash-basis or accrual-basis financial statements? A: Neither is mandatory. Record the basis each statement uses and reconcile the differences. Lenders will ask about the basis, so be prepared to explain it.

Q: How often should I update the NOI schedule? A: Update it at least quarterly, and always before a financing discussion. A current rent roll should be dated within 30 days of submission.

Q: Does a high NOI guarantee refinancing? A: No. While stronger financial performance generally increases refinance options, lenders also consider leverage, market conditions, collateral value, and the borrower's overall financial condition .

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. Wraith commercial real estate debt