Debt yield sizing and lender cash-flow definitions

Debt yield is a simple division with two definitions that must be settled first: which income is recognized and which debt is included. A 9% result based on lender net cash flow and the full commitment is not directly comparable to 10% based on a broker’s NOI and only the funded senior balance. The percentages can differ without either arithmetic operation being wrong.

A historical SEC-filed procedures report, Attachment A procedures 13–14, separately names mortgage and total-debt yields using NOI and NCF. It illustrates the importance of explicit definitions. The report is not a universal lending standard or a guarantee of another transaction’s data; the analysis below uses an original hypothetical definition grid.

Specify the numerator before using the formula

Write the income period, source statement, accepted adjustments, and final cash-flow definition. If one lender deducts a replacement allowance or normalizes a management fee, connect its number to reported NOI through a line-by-line bridge. A lower numerator can produce a lower debt yield even when loan principal has not changed.

Identify whether the income is actual trailing performance, a current annualized figure, or projected stabilized performance. Do not divide projected future income by today’s partly funded debt and present the result as current performance. If both are useful, label the scenarios separately and state the assumptions required to reach the future case.

Use the same property perimeter for numerator and denominator. Income from three assets should not be paired with debt from only two unless an explicitly defined allocation explains why. This matters in cross-collateralized loans, partial releases, and portfolio reporting.

Specify the debt perimeter and measurement date

Record senior mortgage debt, pari passu components, subordinate secured debt, mezzanine obligations, and any other debt included in the actual test. A definition may include some and exclude others. The analytical comparison should also show total economic debt where useful without implying that it changes the contractual covenant.

Distinguish funded principal from maximum commitment. If future advances are conditional, show their status. A lender can choose a commitment-based test for underwriting while a servicing calculation uses outstanding debt; neither convention should be inferred from the bare words “loan amount.”

Capitalized interest, accrued principal additions, scheduled amortization, and voluntary curtailments change the balance over time. Fix a measurement date so the income and debt data can be reproduced.

Reconcile four valid-looking percentages

Assume reported annual NOI of $600,000. A hypothetical lender deducts $60,000 of accepted adjustments, producing $540,000 NCF. The senior mortgage is $6 million and separate subordinate debt is $1 million. Both balances are fully funded in this example.

The property has not changed between rows. The definitions have. An investment memo reporting only the first percentage would omit the income adjustments and subordinate obligation relevant to the last row. A reviewer needs the grid, not a claim that one percentage is the uniquely correct number for every purpose.

At an invented minimum of 9%, $600,000 supports approximately $6.667 million under that ratio alone. The $540,000 numerator supports $6 million. If the minimum applies to total debt, adding $1 million below a $6 million senior loan does not preserve compliance merely because senior-only yield remains 9%.

Test funded debt against the future obligation

Now consider a separate hypothetical structure with $4.5 million currently funded under a $6 million maximum commitment. On unchanged $540,000 income, funded-balance yield is 12% and full-commitment yield is 9%. The difference can disappear as future draws occur even if operating performance remains stable.

Do not treat the undrawn amount as both free liquidity and debt already available for an acquisition. Determine permitted uses and conditions. If draws finance work expected to increase income, show the timing of both the additional balance and the supported income increase. A final stabilized ratio may conceal a weaker interim period.

Understand what the ratio leaves out

Debt yield contains no interest rate, amortization schedule, or payment dates. Those features therefore cannot improve the mathematical ratio directly. They can materially change actual cash burden, default risk, and refinancing feasibility. An interest-only period may ease payments while leaving the same debt yield and a larger future balloon than an amortizing structure.

A debt-yield limit also does not establish collateral value or available closing proceeds. Apply the other constraints and reconcile fees, reserves, and future funding after sizing. Avoid calling one ratio a complete risk score merely because its formula is simple.

Deliver a definition-controlled result

The finished worksheet should identify numerator, debt perimeter, balance date, assumed minimum, and governing source. Show any alternative definition in an adjacent column, and explain the purpose of each. When lender treatment is unresolved, label the requested principal conditional on that definition.

This makes debt yield useful as a reproducible test. It also gives the investor a focused question for the lender: which cash flow and which debt must satisfy the stated threshold, at what date, and after which advances? Those answers are more informative than comparing unqualified percentages across proposals.