How to compare annual debt service with monthly property cash needs
A practical guide to reconciling annual debt service calculations with monthly operating cash flow, including a concrete evidence checklist and document workpaper for sponsors preparing a financing request.
A practical guide to reconciling annual debt service calculations with monthly operating cash flow, including a concrete evidence checklist and document workpaper for sponsors preparing a financing request.
Identify the reporting basis and reconcile periods
Bank supervisory guidance notes that operating statements can be prepared on a cash basis, which reflects only income and expenses actually received or paid during the year, or on an accrual basis, which records income when earned and expenses when incurred [1]. A tax return for a property where real estate taxes were not paid during that year would understate expenses and overstate income compared with accrual-basis financial statements [1]. Start by identifying which basis your statements use. If you have cash-basis statements, compare reported expenses with expenses incurred by comparable properties, adjusted for supported variances and lease terms [1]. The underwriting objective is to develop an NOI that represents a stabilized estimate of income and expenses [1].
Distinguish the rent roll from the T-12
A current rent roll is a snapshot of in-place leases, scheduled rents, and vacancies as of a single date. A trailing twelve months (T-12) operating statement shows actual historical revenue and expenses for the past twelve months. Before comparing totals, note the timing difference: the rent roll shows what tenants are supposed to pay, while The T-12 reports historical income and expenses on its stated accounting basis and what was spent. Reconcile the two by identifying concessions, collection losses, seasonal variations, and any one-time expenses or credits.
Separate gross rent, collected income, NOI, capex, debt service and equity cash flow
To compare debt service with property cash needs, you need a clear waterfall. Gross rent is the total scheduled rent before vacancies and collection losses. Collected income is what you actually receive. NOI is collected income minus operating expenses (but before debt service and capital expenditures). Capital expenditures (capex) are major improvements that are expensed over time, not deducted from NOI in the current period. Debt service is the annual principal and interest payment. Equity cash flow is what remains after all operating expenses, capex reserves, and debt service are paid. Each layer has its own timing and should be modeled monthly.
Prepare a monthly cash flow workpaper
Create a document that shows, for each month of the trailing twelve, the following line items: gross rent, vacancy/collection loss, net collected income, operating expenses, NOI, capex spent, debt service paid, and ending cash balance. Then annualize the totals and compare them to the annual debt service. This workpaper will reveal seasonal patterns, reserve needs, and whether the property can consistently meet monthly debt payments even if annual NOI is adequate. Suggested columns: month, gross rent, vacancy/collection loss, collected income, operating expenses, NOI, capex, debt service, net cash flow, cumulative cash balance.
Understand how debt service coverage is calculated
The debt service coverage ratio (DSCR) is calculated by dividing NOI by annual debt service requirements [1]. The determination of an appropriate DSCR should consider the loan amortization period and the expected volatility of the cash flow [1]. Properties with volatile cash flows, such as hotels or owner-occupants with uneven earnings, may warrant a higher ratio [1]. A lower DSCR may be a prudent trade-off for a shorter amortization period or appropriate for properties with stable and certain cash flows, such as those with long-term net leases to highly creditworthy tenants [1].
Factor in amortization and interest-only periods
Although interest-only terms or long amortization periods can decrease the likelihood of payment default by providing higher debt-service coverage, such terms can increase the loss given default and the balloon or full repayment risk at maturity if not properly mitigated [1]. The OCC guidance states that even if the terms of a loan permit interest-only payments, the property should nonetheless meet the bank's repayment capacity (debt service coverage) requirements as though the loan were amortizing in a manner consistent with the bank's underwriting standards [1]. Generally, LTV and as-if amortizing debt-service coverage requirements for interest-only loans are more conservative than for amortizing CRE loans [1]. Interest-only periods should generally be limited to construction or stabilization periods when property cash flow is temporarily insufficient to support principal payments [1].
Compare debt yield alongside DSCR
Debt yield is the ratio of NOI to debt, calculated by dividing NOI by the loan amount, expressed as a percent [1]. It provides a measurement of risk that is independent of the interest rate, amortization period, and capitalization rate [1]. Lower debt yields indicate higher leverage [1]. Debt yields that reflect normalized or higher-rate levels can be used to establish stressed loan amounts that are less vulnerable to higher-rate environments [1]. Debt yield should be considered along with other criteria and loan amounts and be supported by prudent DSCR and LTV ratios [1].
Evidence checklist for your financing request
- [ ] Operating statements (T-12) on a cash or accrual basis, with basis identified
- [ ] Current rent roll (dated within 30 days)
- [ ] Reconciliation between rent roll and T-12 collected income
- [ ] Monthly cash flow workpaper (12 months, with line items per above)
- [ ] Annual NOI calculation
- [ ] Proposed debt service schedule (annual principal and interest)
- [ ] DSCR calculation (NOI ÷ annual debt service)
- [ ] Debt yield calculation (NOI ÷ loan amount)
- [ ] Amortization schedule showing whether interest-only or amortizing
- [ ] If interest-only, as-if amortizing DSCR calculation
- [ ] Capex reserve assumptions and actual capex spent
- [ ] Notes on any seasonal or volatile cash flow patterns
How do I reconcile a cash-basis T-12 with an accrual-basis rent roll?
Compare each month's collected income from the T-12 to the scheduled rent from the rent roll for that same month. Identify differences due to concessions, collection losses, or timing of rent payments. For expenses, note any unpaid bills that would appear on an accrual statement but not on a cash statement. The underwriting goal is a stabilized NOI, so adjust for one-time or timing differences.
What if my property has seasonal cash flow, like a hotel?
Hotels have historically experienced considerable volatility in income and value [1]. Your monthly cash flow workpaper is especially important here. Show the low-season months and how the property covers debt service during those periods. You may need to demonstrate adequate reserves or a lower DSCR to account for the volatility. The lender may require a higher DSCR to compensate for the risk [1].
Does an interest-only loan change how I compare debt service to cash flow?
Yes. Even if you only pay interest monthly, the lender will evaluate your DSCR as though the loan were amortizing [1]. Prepare an as-if amortizing DSCR calculation. Also, be aware that interest-only periods can increase balloon risk at maturity, so you may need a more conservative loan amount or additional mitigants [1].
We are not a lender and do not make loans or commitments. Submission of information is a preliminary request, not an engagement or lender submission. To discuss your property, business plan, and capital needs, send those details and the amount and timing you are targeting to contact@wraithre.com.
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).