Canonical page: https://sequoia-research.com/writing/dst-due-diligence-debt-service-coverage-stress-calculator
Author: Sequoia Research
Published: 2026-10-17T23:26:29.878Z
Updated: 2026-10-17T23:26:29.878Z
Interactive tool: https://sequoia-research.com/writing/dst-due-diligence-debt-service-coverage-stress-calculator#research-tool

# DST Due Diligence: Debt-Service Coverage Stress Calculator

## What Is This Article About?

This calculator shows how chosen changes in property income and loan payments affect debt-service coverage. You enter a defined baseline, then save separate dollar-change scenarios for the same period. The guide explains the math, the inputs, and the difference between a payment cushion and cash available to investors. You can also choose a comparison ratio, but the tool does not decide whether a lender's test is met.

## Table of Contents

- [What a DST Debt-Service Coverage Ratio Measures](#what-a-dst-debt-service-coverage-ratio-measures)
- [Define the Income, Debt Service, and Common Period](#define-the-income-debt-service-and-common-period)
- [Enter Revenue, Expense, and Payment Changes](#enter-revenue-expense-and-payment-changes)
- [Follow the Fictional Juniper Stress Example](#follow-the-fictional-juniper-stress-example)
- [Use a Chosen Coverage Benchmark Carefully](#use-a-chosen-coverage-benchmark-carefully)
- [Understand Zero Debt, Negative Income, and Rounding](#understand-zero-debt-negative-income-and-rounding)
- [Keep Operating Coverage Separate From Investor Cash](#keep-operating-coverage-separate-from-investor-cash)
- [Check Loan Documents and Test Assumptions](#check-loan-documents-and-test-assumptions)
- [Save Scenarios and Export the Full Calculation](#save-scenarios-and-export-the-full-calculation)
- [FAQ](#faq)
- [About Sequoia Research](#about-sequoia-research)
- [Sources](#sources)

## What a DST Debt-Service Coverage Ratio Measures

Debt-service coverage divides a selected operating-income measure by loan payments for the same period. If income is $120 and debt service is $100, the ratio is 1.20. The income is twenty dollars greater than the payment amount under those definitions. That does not establish what investors receive.

The numerator is the number above the division line: the income you select. The denominator is the debt service below it. A ratio without those definitions can be hard to compare. Two reports can use the same label while excluding different costs or covering different periods.

This tool makes those choices visible. It calculates the baseline and up to ten saved scenarios. Each scenario changes operating revenue, operating expenses, debt service, or some combination. The output includes the ratio and the dollar amount by which entered income exceeds or falls short of entered debt service.

The OCC is the Office of the Comptroller of the Currency. Its guidance asks banks to test several changes when they assess refinance risk. It also notes that lenders may set coverage requirements. It does not give every Delaware statutory trust (DST) one passing ratio. This calculator is not an OCC-approved model. [OCC Bulletin 2024-29, October 3, 2024](https://www.occ.gov/news-issuances/bulletins/2024/bulletin-2024-29.html)

## Define the Income, Debt Service, and Common Period

Enter the property and offering scope first. State whether your amounts describe a whole property, a defined portfolio, or some other matched interest. Do not pair whole-property income with only one investor's share of the debt payments.

Describe the common period in plain language. It might be one calendar year, a trailing twelve-month period, or a stated quarter. The tool does not convert monthly amounts to annual amounts. It also does not infer the duration from a report date. Every amount and change must cover the period you describe.

The review cutoff records when this calculation is being made. It cannot follow today's UTC date. UTC is the time standard used by the application. The cutoff does not establish that your documents are current; include source dates and versions in the reference fields.

Define the income measure and its exclusions. For example, state whether it is property operating income before debt service and whether capital work, reserve funding, and trust expenses are excluded. Identify the source or mark the figure as a hypothetical assumption. A short report title, date, and page reference is more useful than an unexplained number.

Do the same for debt service. State which scheduled interest and principal payments are included. Describe any omitted fees, balloon payment, or other required cash. If the selected period includes a large final payment, address that payment explicitly instead of silently dropping it from the denominator.

Confirm that the inputs use the same period, property scope, and U.S. dollar basis. The tool requires that confirmation before calculation. It records your judgment; it cannot check the original statements or determine the correct legal definition for a loan.

## Enter Revenue, Expense, and Payment Changes

Each scenario has a name, three dollar changes, and an explanation. The three changes are applied once to the baseline. Use a minus sign for a reduction and an unsigned positive amount for an increase.

The income formula is baseline income plus revenue change minus operating expense change. The debt-service formula is baseline debt service plus debt-service change. A positive expense change therefore lowers income. A negative expense change raises it. That sign rule is easy to reverse, so check the result before saving an interpretation.

Enter zero when a component is known to remain unchanged. A blank required amount is treated as missing, not as zero. You can describe an unresolved input in the notes, but a scenario needs actual chosen numbers before it can be calculated.

Use changes that fit the stated income definition. If an expense is already included in the baseline, enter only the change in that expense. Adding the whole expense again would count it twice. A capital project excluded from the chosen income measure should not be presented as an ordinary operating expense without explaining the change in scope.

The tool accepts dollar shocks, not percentage growth assumptions. If you translate a percentage into dollars outside the tool, record its base and period. A ten-percent rent change is not automatically a ten-percent change in operating income. Costs and other revenue can make those effects quite different.

## Follow the Fictional Juniper Stress Example

Load fictional example to see a complete case. Juniper Court, its sources, and all amounts are invented. Nothing in the example represents a current offering, a forecast, or a lender's actual standard.

The baseline has $1.2 million of property operating income and $800,000 of scheduled debt service for one hypothetical twelve-month year. Income excludes capital work, trust costs, reserves, and investor distributions. Debt service includes the invented scheduled payments but excludes a balloon. Those exclusions matter when interpreting the remainder.

The example's optional benchmark is 1.25. It is a chosen teaching assumption. The tool does not recommend it or imply that it matches a real covenant.

| Separate case | Operating income | Debt service | Coverage | Income less debt service |
|---|---:|---:|---:|---:|
| Baseline | $1,200,000 | $800,000 | 1.5000 | $400,000 |
| Revenue and expense pressure | $1,040,000 | $800,000 | 1.3000 | $240,000 |
| Payment increase | $1,200,000 | $1,000,000 | 1.2000 | $200,000 |
| Combined pressure | $1,040,000 | $1,000,000 | 1.0400 | $40,000 |

The operating-pressure case subtracts $100,000 of revenue and adds $60,000 of operating costs. Income becomes $1.2 million minus $100,000 minus $60,000, or $1.04 million. Debt payments remain $800,000.

The payment case changes only debt service, adding $200,000. The combined case applies all three shocks once to the original baseline. It does not add the result rows together. These are separate possible inputs, not four years in a timeline.

The combined case still has income above debt service. Yet its 1.04 ratio falls below the selected 1.25 benchmark. Meeting current payments and meeting a chosen cushion are different questions. Neither alone proves that the trust can make a planned distribution.

## Use a Chosen Coverage Benchmark Carefully

Leave the benchmark blank if you only want ratios and dollar margins. If you enter one, the tool compares every positive-debt-service case with that same ratio. It accepts values from 0.001 through 20.000, with up to three decimal places. These are software limits, not recommended lending terms.

Required income equals the chosen ratio times that case's debt service. In Juniper's baseline, 1.25 times $800,000 equals $1 million. Baseline income is $200,000 above that amount. The operating-pressure case has $40,000 of headroom over the same chosen requirement.

For the $1 million payment cases, required income is $1.25 million. The payment-only case needs $50,000 more income to reach it. The combined case needs $210,000 more. These are conditional arithmetic gaps. They do not identify a feasible rent increase or an approved operating plan.

The full report also shows signed headroom: entered income minus required income. A negative number marks a gap; a positive number marks an excess. Extra income needed is never negative. When income already reaches the selected amount, that field is zero.

A real covenant may define income, payment obligations, adjustments, test dates, and cure rights in a different way. Even copying its stated ratio into this field does not prove compliance. The definitions and period must also match, and other loan requirements still need review.

## Understand Zero Debt, Negative Income, and Rounding

A zero debt-service amount is allowed when it is an explicit, supported choice. Coverage is then withheld because division by zero has no defined ratio. The benchmark comparison is withheld too. The tool still shows income less debt service, but it does not call a debt-free case infinitely safe.

Negative operating income is also allowed. Costs may exceed the included revenue. With positive debt service, that produces a negative ratio. It describes the chosen amounts. It does not measure the chance of loss or the amount an investor might owe.

A scenario cannot create negative debt service. For example, subtracting $900,000 from an $800,000 baseline payment would be rejected. A full $800,000 reduction can produce zero, with the ratio then withheld as described above.

Money is handled to the cent. Inputs reject commas, currency signs, scientific notation, and more than two decimal places. Entered amounts may be up to one billion dollars in absolute value. Calculated scenario amounts can exceed that input limit when valid components are combined.

Ratios display four decimal places, while benchmark comparisons use the exact entered amounts. A displayed ratio that looks equal after rounding can still be slightly below the chosen benchmark. Read the comparison label and dollar gap together.

Required income is rounded upward to the next cent when the multiplication produces a fraction of a cent. For instance, $1.01 of debt service at a 1.005 benchmark requires $1.01505 mathematically. The cent-denominated requirement is $1.02. An income entry of $1.01 is below it and needs another cent. This tiny example explains the rounding rule; it is not a lending convention claim.

## Keep Operating Coverage Separate From Investor Cash

Income less debt service is only a subtotal under the definitions you entered. It may leave out capital spending, reserve deposits, trust expenses, fees, taxes, and restrictions on cash. Read it as a bridge to the next cash-budget question.

Suppose Juniper's baseline $400,000 remainder must also fund $90,000 of capital work, $70,000 of reserve contributions, and $40,000 of trust expenses. Under that separate invented budget, $200,000 remains before other uses or restrictions. Those additional items are not calculated by this tool. They illustrate why the ratio alone cannot establish a distribution amount.

Taking cash from a reserve does not make it operating income. A reserve supplies funds; income measures the chosen operating activity. You may need a separate cash schedule. In that schedule, show both the amount taken out and the reserve left afterward.

Likewise, a larger loan payment can include principal reduction. It can lower current coverage while reducing debt outstanding. The calculator does not track the loan balance, amortization schedule, sale proceeds, or overall investment return. Those questions require separate models.

## Check Loan Documents and Test Assumptions

Start with the actual source records when they are available. Check the property period, income definition, debt schedule, amendments, and any lender notice that affects payments. Record a missing document as missing. Do not substitute a generic industry definition and present it as the contract's test.

FINRA's guidance asks covered member firms to investigate private placements. It discusses issuer claims and primary documents. It also calls for fuller answers when concerns remain. This calculator does not perform that work. It cannot certify that a firm has met its duties. [FINRA Regulatory Notice 23-08, May 9, 2023](https://www.finra.org/rules-guidance/notices/23-08)

Choose scenario amounts for stated reasons. You might test a documented lease loss, a quoted insurance change, or an assumed payment increase. Distinguish evidence from judgment. A selected downside is not the worst possible outcome just because it appears in a table.

Do not assign probabilities from the number of rows. Three weak scenarios and one strong baseline do not imply a seventy-five-percent chance of failure. The inputs were selected by the user; they are not a statistical sample of future events.

The SEC cautions that private placements can provide limited information and be difficult to resell. A clean coverage calculation does not resolve those risks. Keep broader diligence open even when one payment model looks comfortable. [SEC private-placement bulletin, updated September 21, 2026](https://www.investor.gov/introduction-investing/general-resources/news-alerts/alerts-bulletins/investor-bulletins/private-placements-under-regulation-d-updated-investor-bulletin)

## Save Scenarios and Export the Full Calculation

Save each scenario before calculating. Unsaved row changes block the calculation so they cannot be silently ignored. Editing baseline or scope fields clears the old result and disables downloads until you calculate again. A rejected scenario save leaves the saved rows unchanged.

You can edit a saved row, clear an unsaved editor, or delete a saved scenario. Switching to another saved row asks before replacing unsaved edits. Deleting a row requires confirmation and also clears the editor. Loading the example and clearing all records require confirmation as well. Cancel preserves the current inputs and saved rows.

Both exports contain the complete record: definitions, sources, baseline, scenario changes, all results, rounding method, and limits. JSON is useful for structured review; the text report is easier to read. On the published page, select Download and then the separate Save file control when it appears.

There is no automatic saving, import, or permanent version history. Keep a dated export before replacing a model or leaving the page. Use short source pointers and avoid confidential files. The input record is limited to 50,000 UTF-8 bytes; each export is limited to 200,000 bytes. These limits concern storage, not the scope of proper diligence.

## FAQ

### Does a Ratio Above One Mean the DST Can Pay Its Distribution?

It means entered income exceeds entered debt service for that period. Other cash uses and restrictions may remain. The calculator does not determine investor distributions, total return, or whether a payment is sustainable.

### Is 1.25 the Required Ratio for Every DST Loan?

No. It is only the fictional example's chosen benchmark. Actual lender terms can differ, and the income definition and test period matter. You can leave the benchmark blank without losing the basic coverage calculation.

### Can I Enter Monthly Income and Annual Debt Service?

Not as a valid same-period comparison. Establish matching periods before confirming the inputs. The tool does not annualize, allocate partial periods, or check your source documents for consistency.

### Why Does a Positive Expense Change Reduce Income?

The expense field records a change in costs. Higher costs reduce the selected operating-income measure. A negative expense change represents a reduction in costs and therefore increases that measure under the stated formula.

### Are Scenario Rows Added Together?

No. Every row starts from the original baseline. If you want several shocks in one case, put them in that row once. Do not add separate scenario outputs or read the table as a sequence of years.

### Why Can a Rounded Ratio Look Equal but Still Be Below the Benchmark?

The displayed ratio is rounded to four decimal places. The comparison uses exact amounts, so a small shortfall can remain. Required income is rounded upward to a full cent, which makes the dollar gap clear.

### Does the Tool Calculate a New Interest Rate or Refinance Loan?

No. You enter the change in total debt service yourself. The calculator does not price a loan, build an amortization schedule, assess borrowing authority, or predict refinancing approval. Explain the basis for each payment change in its notes.

## About Sequoia Research

Sequoia Research publishes educational research and practical tools for reviewing DST investments and their source documents. This calculator makes selected payment assumptions visible. It does not issue a credit rating or replace review of a specific investment, loan agreement, or tax situation.

## Sources

- [OCC Bulletin 2024-29: Commercial Lending, Refinance Risk](https://www.occ.gov/news-issuances/bulletins/2024/bulletin-2024-29.html). October 3, 2024. Covered-bank stress-testing and coverage context.
- [FINRA Regulatory Notice 23-08](https://www.finra.org/rules-guidance/notices/23-08). May 9, 2023. Covered-member investigation and source follow-up.
- [SEC Private Placements Under Regulation D](https://www.investor.gov/introduction-investing/general-resources/news-alerts/alerts-bulletins/investor-bulletins/private-placements-under-regulation-d-updated-investor-bulletin). Originally August 17, 2022; updated September 21, 2026. Limited information and illiquidity context.


## Related Reading and Tools

- [DST Due Diligence: A Practical Checklist Before You Invest](https://sequoia-research.com/writing/dst-due-diligence-a-practical-checklist-before-you-invest)
- [DST Due Diligence: How to Review the Sponsor Separately From the Property](https://sequoia-research.com/writing/dst-due-diligence-how-to-review-the-sponsor-separately-from-the-property)
- [Delaware Statutory Trust Reviews: How to Compare Investor Opinions With Offering Documents](https://sequoia-research.com/writing/delaware-statutory-trust-reviews-how-to-compare-investor-opinions-with-offering-documents)