Explaining the difference between cash-on-cash and debt coverage
This guide helps commercial real estate sponsors prepare a debt service coverage analysis worksheet, distinguishing cash-on-cash returns from debt coverage ratios, and explaining how each affects lender underwriting discussions.
This guide helps commercial real estate sponsors prepare a debt service coverage analysis worksheet, distinguishing cash-on-cash returns from debt coverage ratios, and explaining how each affects lender underwriting discussions.
Prepare a debt service coverage analysis worksheet
Create a single-page worksheet that records the following line items for the trailing twelve months (T-12) and the current rent roll snapshot. Label each item clearly and note the source (e.g., rent roll date, T-12 period). The worksheet is a suggested way to organize information for your own review, not a mandatory lender form.
- Gross potential rent
- Vacancy and credit loss (actual and stabilized)
- Effective gross income
- Operating expenses (including management fees, property taxes, insurance, utilities, repairs, and any replacement reserves)
- Net operating income (NOI)
- Annual debt service (principal and interest, based on the loan amount and terms you are seeking)
- Debt service coverage ratio (DSCR = NOI / annual debt service)
- Cash flow after debt service (NOI minus debt service)
- Equity cash flow (cash flow after debt service, minus any capital expenditures or reserves not already deducted)
- Cash-on-cash return (equity cash flow / total equity invested)
Understand the difference between cash-on-cash and debt coverage
Cash-on-cash return measures the annual cash return on the equity invested, expressed as a percentage. Debt service coverage ratio (DSCR) measures the property's ability to pay its debt obligations from net operating income. They serve different purposes: cash-on-cash is a sponsor's return metric, while DSCR is a lender's risk metric. [1] The DSCR is calculated by dividing NOI by annual debt service requirements, and the determination of an appropriate DSCR should consider the loan amortization period and expected volatility of cash flow. [1] A higher DSCR indicates more cushion for debt payment, while a higher cash-on-cash return indicates better equity performance. Do not equate or combine them; they are separate analyses.
Identify the reporting basis and reconcile periods
A current rent roll is a snapshot of occupancy and rents at a single point in time. A T-12 (trailing twelve months) is a historical summary of actual income and expenses over the past twelve months. Before comparing totals, adjust for timing differences: the rent roll shows current contractual rents, while The T-12 reports historical income and expenses on its stated accounting basis and spent. [1] Operating statements prepared on a cash basis reflect only income and expenses actually received or paid, which can understate expenses and overstate income compared to accrual-based financial statements. [1] Record the reporting basis (cash or accrual) for each statement. If using cash-basis statements, compare expenses to comparable properties to identify potential understatements. [1]
Distinguish gross rent, collected income, and NOI
Gross potential rent is the total rent if fully occupied at market rates. Effective gross income subtracts vacancy and credit loss. NOI subtracts operating expenses from effective gross income. [1] The NOI should represent a stabilized estimate of income and expenses, and some capital expenditures (like replacement reserves) may not appear on tax returns but should be captured in the analysis. [1] Record each line separately on your worksheet to avoid conflating them. Lenders typically underwrite to a stabilized NOI, not peak or trough figures.
Explain how DSCR and debt yield affect the financing discussion
DSCR shows whether the property generates enough income to cover debt payments. [1] A lower DSCR may be acceptable for properties with stable cash flows (e.g., long-term net leases to creditworthy tenants), while volatile cash flows (e.g., hotels) may warrant a higher ratio. [1] Debt yield (NOI divided by loan amount) provides a risk measure independent of interest rate and amortization. [1] Lower debt yields indicate higher leverage. [1] When discussing financing, ask the actual lender what DSCR and debt yield thresholds they use for your property type and market. Record these on your worksheet to compare against your property's actual figures.
Prepare a capital expenditure and reserve schedule
Identify any recurring capital expenditures (e.g., HVAC replacement, roof repairs, parking lot resurfacing) and estimate their annual cost. [1] Funds for such items are captured in a replacement reserve. [1] Add this reserve as a line item in your operating expenses, even if not shown on tax returns. [1] This adjustment ensures your NOI reflects realistic long-term costs, not just immediate cash expenses.
Ask the actual lender about covenant definitions
Debt-service coverage covenants in loan documents may define income and expenses differently than the DSCR used for underwriting. [1] Definitions should be clearly defined in loan documents. [1] Ask the lender for their specific covenant calculation method and record it on your worksheet. This helps you track compliance during the loan term.
Frequently asked questions
What is the difference between cash-on-cash return and debt service coverage ratio?
Cash-on-cash return measures the annual cash return on equity invested, while DSCR measures the property's ability to pay debt from net operating income. They serve different purposes: one for sponsor return, one for lender risk assessment.
Should I use cash-basis or accrual-basis financial statements?
Use accrual-basis statements if available, as they match income and expenses to the period they are earned or incurred. If only cash-basis statements are available, note the basis and compare expenses to comparable properties to identify potential understatements.
How do I reconcile a current rent roll with a trailing twelve-month statement?
The rent roll is a snapshot of current rents, while the T-12 shows historical actuals. Compare them by adjusting for any changes in occupancy, rent levels, or expenses over the period. Record both on your worksheet and note the timing difference.
Send us the property, the business plan, the amount you need, and the timing. We will tell you how we would approach it. Submission is a preliminary request, not an engagement or lender submission.
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).