How to avoid mixing annual NOI with monthly debt service in a model
A practical guide for commercial real estate sponsors to prepare a debt service coverage worksheet that correctly matches net operating income and annual debt service, with an evidence checklist to support the underwriting discussion.
A practical guide for commercial real estate sponsors to prepare a debt service coverage worksheet that correctly matches net operating income and annual debt service, with an evidence checklist to support the underwriting discussion.
Identify the reporting basis of your operating statements
Before you calculate any coverage ratio, record whether each operating statement is prepared on a cash basis or an accrual basis. A cash-basis statement reflects only income actually received and expenses actually paid during the period. An accrual-basis statement records income earned and expenses incurred, regardless of when cash moved. The same property can show different net operating income (NOI) depending on which basis is used. For example, 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]
If you are combining statements from different sources—such as a tax return (cash basis) and a property management report (accrual basis)—note the basis of each and reconcile the differences before using the totals in a coverage calculation. A suggested way to prepare this information is to create a simple table with columns for each statement, its basis, and any reconciling adjustments.
Distinguish between a current rent roll and a trailing twelve-month operating statement
A current rent roll is a snapshot of today's occupancy, rents, and concessions. A trailing twelve-month (T-12) operating statement shows actual income and expenses for each of the past twelve months. [2] These two documents serve different purposes and should not be used interchangeably. The rent roll tells you what is leased now; the T-12 tells you what was collected and spent over a historical period.
Build a debt service coverage worksheet that matches periods
- Gross potential rent (annual)
- Vacancy and collection loss (annual)
- Effective gross income (annual)
- Operating expenses (annual)
- Net operating income (annual)
- Annual debt service (monthly payment × 12)
- DSCR = NOI ÷ annual debt service
Label every line as annual. If your source documents show monthly figures, multiply by 12 before entering them into the worksheet. If the loan is interest-only, use the annual interest-only payment as the debt service figure for this calculation; the lender will also evaluate an as-if amortizing payment for underwriting purposes. [1]
Distinguish gross rent, collected income, NOI, capex, debt service, and equity cash flow
A clear model separates these six layers:
- Gross rent – the total scheduled rent before any deductions.
- Collected income – gross rent minus vacancy, concessions, and bad debt.
- Net operating income – collected income minus operating expenses (property taxes, insurance, management fees, utilities, repairs, etc.). [1]
- Capital expenditures (capex) – major improvements that are not operating expenses, such as roof replacement or HVAC upgrades. These are typically deducted from NOI to arrive at cash flow before debt service.
- Debt service – principal and interest payments due on the loan.
- Equity cash flow – what remains after debt service and capex, representing the sponsor’s return.
Do not equate a capitalization rate with a debt constant. A cap rate is used in the income approach to value; a debt constant is the ratio of annual debt service to loan amount. They measure different things and are not interchangeable.
Prepare an evidence checklist for the DSCR and debt yield
A lender will want to see support for the NOI and debt service figures you present. Assemble the following documents and note their key figures:
- [ ] T-12 operating statements for the most recent 12 months, with each month’s NOI shown separately.
- [ ] Current rent roll, dated within 30 days of the submission.
- [ ] Reconciliation between the rent roll and T-12 (explain differences in occupancy, rent levels, or expense timing).
- [ ] Tax returns for the property (if available), with the reporting basis noted.
- [ ] Loan term sheet or proposal showing the interest rate, amortization period, and any interest-only period.
- [ ] Calculation of annual debt service: monthly payment × 12, or interest-only payment × 12.
- [ ] DSCR calculation: NOI ÷ annual debt service.
- [ ] Debt yield calculation: NOI ÷ loan amount, expressed as a percent. [1]
Debt yield is a useful secondary metric because it is independent of interest rate and amortization period. [1] A lower debt yield indicates higher leverage. Record this figure alongside the DSCR to give the lender a fuller picture of risk.
Ask the actual lender about coverage requirements
Lenders set their own DSCR minimums based on property type, cash flow volatility, and loan structure. [1] For example, a property with long-term net leases to creditworthy tenants may justify a lower DSCR, while a hotel with volatile cash flows may warrant a higher ratio. [1] Do not assume a universal threshold. Ask the lender what DSCR they require for your property type and whether they use an as-if amortizing payment for interest-only periods. [1]
If the loan is interest-only, the lender may underwrite it as if it were amortizing, often with a more conservative LTV and DSCR. [1] Be prepared to provide both the actual interest-only payment and the fully amortizing payment in your worksheet.
Should I use cash-basis or accrual-basis NOI in my DSCR calculation?
Use the NOI that best represents a stabilized estimate of the property’s income and expenses. If your operating statements are on a cash basis, compare reported expenses to those of comparable properties and adjust for known variances. [1] Ask the lender which basis they prefer for their underwriting model.
How do I handle a property with seasonal cash flow, like a hotel?
The trailing twelve-month operating statement is useful for seasonal properties because it captures a full cycle of high and low months. [1] Calculate the DSCR using the annual NOI from the T-12, not a single month’s figure. The lender may also look at a stressed scenario using a lower-income period.
Can I use the same worksheet for a construction loan?
For a construction loan, the property may not yet have operating history. In that case, the lender will rely on the development budget, pro forma, and projected stabilized NOI. [2] The same worksheet structure applies, but the NOI will be a projection rather than historical data. Label it clearly as pro forma.
We are not a lender and do not make loans or commitments. If you have a property, a business plan, and a capital need, send us the details at contact@wraithre.com and we will tell you how we would approach the financing.
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.
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.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).