Separating the interest rate from the annual debt constant
A practical guide for sponsors to prepare a debt-yield workpaper that isolates interest rate assumptions from the annual debt constant, with a concrete evidence checklist and three FAQs.
A practical guide for sponsors to prepare a debt-yield workpaper that isolates interest rate assumptions from the annual debt constant, with a concrete evidence checklist and three FAQs.
How to build a debt-yield workpaper
Prepare a single-page workpaper that calculates the annual debt constant and the debt yield for the proposed financing. The debt yield is the ratio of net operating income (NOI) to 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].
Step 1: Record the proposed loan terms - Loan amount - Interest rate (note whether fixed or floating, and the index and spread if floating) - Amortization period in years - Loan term (may differ from amortization) - Annual debt service (total of principal and interest payments due in one year)
Step 2: Calculate the annual debt constant Divide the annual debt service by the loan amount. This figure can be compared directly to the property's NOI yield.
Step 3: Calculate the debt yield Obtain the property's trailing 12 months (T-12) NOI from the operating statements. Divide that NOI by the proposed loan amount. This ratio is the debt yield [1].
Step 4: Compare the two ratios If the debt yield is materially higher than the annual debt constant, the property generates enough income to cover debt service even after a rate increase. If the debt yield is close to or below the constant, the property is highly leveraged and sensitive to rate changes.
Distinguishing the current rent roll from the T-12
The current rent roll is a snapshot of in-place leases as of today. It shows gross rent, any concessions, and the net rent being billed. The trailing 12 months (T-12) is a historical report of actual income collected and expenses paid over the past twelve months. The two will differ because the T-12 captures lease-up periods, vacancies, tenant improvements, and capital expenditures that the rent roll does not reflect. When comparing totals, identify the reporting basis and reconcile periods. Do not assume the rent roll equals collectible income.
Separating gross rent, collected income, NOI, and debt service
Create a layered income statement on the workpaper: - Gross rent: total contractual rent from all leases - Collected income: gross rent minus vacancies, concessions, and bad debt - Net operating income (NOI): collected income minus operating expenses (property taxes, insurance, management, maintenance, utilities) - Debt service: annual principal and interest payments on the loan - Equity cash flow: NOI minus debt service
Each layer tells a lender a different story about the property's capacity to support debt. A high gross rent with low collected income signals collection risk. A healthy NOI that disappears after debt service indicates thin equity return.
Interest rate risk and the construction period
For construction loans, interest rate risk is especially acute because the outstanding loan amount changes during development and the loan tenor is short [1]. An interest reserve is a budget line item that covers loan interest during construction and lease-up [1]. The reserve should be sized to pay interest through the project's anticipated completion and lease-up, sale, or occupancy [1]. A sponsor should record the assumed interest rate used to calculate the reserve and compare it to current market rates. If rates rise, the reserve may be insufficient, and the borrower may need to fund the shortfall.
Evidence checklist for the lender package
Prepare the following documents before approaching a lender: - [ ] Current rent roll (snapshot date and lease terms) - [ ] Trailing 12 months of operating statements (income and expenses by month) - [ ] Reconciliation of any differences between rent roll and T-12 collected income - [ ] Pro forma NOI for the next 12 months, with assumptions listed - [ ] Debt-yield workpaper showing NOI divided by requested loan amount - [ ] Annual debt constant calculation using the proposed rate and amortization - [ ] Interest reserve budget (for construction loans) with assumed rate and draw schedule - [ ] Schedule of real estate owned by the sponsor - [ ] Financial statements for principals and guarantors (identify reporting basis and reconcile periods) - [ ] Organizational documents for the borrowing entity
How the debt yield affects the financing discussion
Lenders use debt yield as a common metric to size up a loan or assess its risk, especially during periods of low interest and capitalization rates [1]. A debt yield that reflects normalized or higher-rate levels can establish stressed loan amounts that are less vulnerable to higher-rate environments [1]. When presenting the workpaper, ask the actual lender what debt yield they consider appropriate for the property type and market. Do not assume a single ratio applies universally. The debt yield should be considered along with DSCR and LTV ratios [1].
How do I calculate the annual debt constant if the loan has a floating rate?
Use the current index rate plus the lender's spread as the assumed interest rate for the calculation. Note that the constant will change if rates move. For stress-testing, recalculate the constant at a higher rate (e.g., 200 basis points above the current index) to see how much NOI would need to increase to maintain coverage.
Should I include mezzanine debt in the debt-yield calculation?
Yes, if mezzanine financing is part of the capital stack. The debt yield for the senior loan is NOI divided by the senior loan amount. The blended debt yield for total debt is NOI divided by the sum of senior and mezzanine debt. Present both figures so the lender can see the leverage at each layer.
What if the property's NOI is negative or very low?
A negative or very low NOI relative to the loan amount produces a debt yield near zero or negative. This signals that the property cannot support debt service from operations. In that case, the lender will look to the sponsor's other income, guarantees, or a plan to increase NOI through leasing or capital improvements. Record the current NOI and the projected NOI under the business plan, and be prepared to explain the gap.
This guide is a suggested way to prepare information for a financing discussion. Submission of a loan request is a preliminary step, not an engagement or lender submission. Send us the property, the business plan, and the amount and timing of capital needed, and we will tell you how we would approach it.
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).