Tool & guide

Are DST Investments Safe: Downside Scenario Workbench

By Sequoia ResearchPublished Read as Markdown

Downside Scenario Workbench

Users vary occupancy, collections, expenses, financing, reserves, and exit assumptions within a documented model. The workbench reports modeled outcomes and unmodeled risks without converting them into a universal safety rating.

For an export, select Download in the tool, then Save file when it appears below. Your entries stay in your browser.

What Is This Article About?

This workbench shows how several downside assumptions can change a DST cash model. You enter one reference case and up to five alternatives for a full modeled year followed by a sale. The tool traces rent through costs, debt payments, reserves, and closing proceeds, while flagging gaps that the entered cash cannot fund. It produces a comparison of assumptions and outcomes, not a safety rating or a forecast.

Table of Contents

What This DST Downside Model Covers

A single return figure hides the route that cash takes. Rent can fall, expenses can rise, and a planned owner payment can depend on reserves. At sale, debt and closing costs can absorb much of the property price. This workbench connects those steps so you can see where an entered plan changes.

Every case covers one full modeled year and a sale at its end. The model is deliberately narrow. It does not construct a monthly payment calendar, estimate market demand, or decide what a trustee may do. It treats the entered amounts as assumptions supplied by the reader.

Use the reference case to describe one consistent set of assumptions. Alternatives can change several inputs together. They are separate cases, not consecutive years or events that are added together. No probability is attached to any case.

The SEC's performance bulletin distinguishes hypothetical projections from actual results and encourages readers to understand the method and included costs. That distinction applies to every output here. A model with all fields completed is still a model. SEC Performance Claims.

Enter the Shared Capital and Cash Scope

Start with a plan name and the ownership scope. All amounts must describe the same whole investment or consistently allocated interest. The tool does not convert a building's rent into a trust's share or allocate trust cash to individual investors.

The shared starting fields are the capital reference, full-occupancy annual gross rent, opening debt, and opening cash reserve. These values remain the same across cases. Record source locations, assumed dates, and exclusions in the notes.

The capital reference is a positive comparison denominator. It may be a chosen contribution amount, but the workbench does not verify it against a sources-and-uses schedule. The final receipts ratio is not a return for a verified holding period. Earlier payments, entry costs, or different ownership rights may require a separate analysis.

The opening reserve means cash available for this model's listed uses. Do not include restricted funds that cannot meet those uses. The model cannot read lender restrictions or tell whether an account can be released. A note that identifies a restriction does not change the calculation by itself.

All numeric fields are required. Blank means the case is incomplete; it does not mean zero. Enter zero only when that is your intended assumption. Negative inputs are blocked, although calculated cash balances and changes can be negative.

Amounts can have two decimal places. Percentages run from zero through 100, except the exit cap rate must be above zero. Each amount is limited to $1 trillion. This technical limit is not a statement that such an input is plausible.

Model Occupancy, Collections, and Operating Costs

The first rent step applies the occupied share to full-occupancy gross rent. Here, “occupied share” means the share of that rent schedule attributed to occupied space. It is not automatically the percentage of units occupied. Different units or areas may carry different rents.

For example, $2 million of full-occupancy rent at a 95% occupied rent share produces $1.9 million of scheduled rent. Collecting 98% of that amount produces $1.862 million of cash rent. Do not apply a physical occupancy percentage unless it fits the rent assumptions or you explicitly accept that simplification.

The tool rounds scheduled rent to cents before applying the collection percentage. It rounds collected rent to cents again. This stated sequence avoids hidden differences when tiny inputs produce half-cent amounts.

Property operating cash expenses are then subtracted. These are one annual total. Include the items appropriate to your model, and document the scope. Keep capital work and trust-level cash costs out of this total when they are entered in their separate fields.

The resulting property cash is not automatically an accounting NOI measure. It uses modeled collections and cash expenses. It does not calculate receivables, accrued expenses, tax depreciation, or lease accounting adjustments.

The separate exit NOI field has a different purpose. It supplies assumed stabilized annual income for pricing the sale. The tool does not infer that amount from this year's property cash. A weak operating year and a stronger future exit assumption can therefore appear together, but you must explain the work and evidence needed to connect them.

Apply the Financing and Reserve Rules

Interest equals opening debt multiplied by the entered annual rate. The model uses one full year of simple interest and rounds the result to cents. It does not implement an actual/360 loan, changing principal during the year, monthly amortization, a floating index, a rate cap, or a swap.

Principal is assumed paid at year-end. It cannot exceed opening debt. The remaining debt is opening principal minus that payment. If the operating plan cannot fund its listed uses, that remaining balance is labeled conditional; the tool does not pretend that the principal was successfully paid.

Subtract interest, principal, capital spending, and trust cash costs from property cash. Add the opening reserve to find cash available before the owner payment. This is an annual model. It does not prove cash was available on each earlier payment date.

The owner-payment rule is explicit: pay no more than the planned amount, and use only cash above the chosen reserve target. If $525,000 is available and the target is $500,000, a planned $400,000 payment is limited to $25,000.

That rule is a modeling choice, not a statement about an actual trust's distribution policy. It does not claim that investors can direct payments or set reserve levels. The model may show a reduced payment even when a real document uses different rules.

If available cash is positive but below the reserve target, the modeled payment is zero. The remaining cash is shown along with the gap to the target. The tool does not invent new money to fill the reserve.

If available cash is negative before any owner payment, the operating plan has an unfunded gap. The tool shows the amount, sets the modeled owner payment to zero, and withholds the ending reserve and terminal receipt calculation. It does not decide which creditor is unpaid or assume an investor must cover the gap.

Carry Funded Cash Into the Exit Model

For a funded operating plan, the model divides exit NOI by the exit cap rate to find a gross property price. It rounds that price to cents. It then subtracts the percentage selling cost, separate fixed closing costs, and remaining debt, and adds the ending cash reserve once.

The OCC describes direct capitalization for stabilized NOI and a future income stream expected to be stable. Its guidance also distinguishes methods for changing income. The workbench uses a simplified direct-capitalization assumption; it is not an appraisal. OCC Commercial Real Estate Lending, printed page 43.

Check the exit expense boundaries. A selling charge inside the percentage should not be repeated in fixed closing costs. Loan payoff fees, holdbacks, tax, special payment rights, and other claims need separate treatment if they apply. Merely mentioning an omitted cost in a note does not deduct it.

If the closing result is negative, the tool reports a closing funding gap. It withholds terminal owner cash, total receipts, and the receipts ratio. A negative closing amount is not automatically a personal capital call. The legal and financial choices needed to complete a sale remain outside this model.

If closing is funded, total modeled receipts equal the year's owner payment plus terminal owner cash. Ending reserve is already inside terminal cash and is not added again. Dividing total receipts by the capital reference gives a cash ratio, rounded to four decimals. It is not an annualized return or an investor IRR.

Work Through the Four Fictional Scenarios

The built-in Meadow Works cases are original teaching examples. They describe no actual DST. Shared values are $2 million full-occupancy gross rent, $8 million opening debt, $600,000 opening reserve, and a $10 million capital reference.

The reference case uses 95% occupied rent and 98% collection. It has $700,000 operating expenses, 5% interest, $100,000 year-end principal, $150,000 capital work, and $60,000 trust costs. The owner-payment plan is $400,000 and the reserve target is $500,000.

Collected rent of $1.862 million leaves $452,000 after those listed annual uses. Adding the reserve produces $1.052 million before payment. The model pays the full $400,000 and retains $652,000.

Assumed exit NOI is $1.2 million and the cap rate is 6%, producing a $20 million price. A 3% sale cost is $600,000. After another $100,000 closing cost, $7.9 million debt, and the $652,000 cash addition, terminal owner cash is $12.052 million. Total receipts are $12.452 million, or 1.2452 times the capital reference.

The combined-stress case changes several inputs. Occupied rent falls to 85%, collection to 95%, expenses rise to $800,000, interest rises to 6%, and capital work rises to $250,000. Other annual cost inputs stay the same.

Collected rent is $1.615 million, and annual cash after listed uses is negative $75,000. The opening reserve brings available cash to $525,000. Only $25,000 can be paid while retaining the $500,000 target. That is a $375,000 cut from the planned payment.

Stress exit NOI is $1.05 million at a 7% cap rate, giving a $15 million price. After the specified costs, debt, and remaining cash, terminal cash is $7.05 million. Total receipts are $7.075 million, or 0.7075 times the capital reference. That ratio includes no personal tax or earlier history.

The third case tests an operating funding gap. At 65% occupied rent and 80% collection, cash rent is $1.04 million. With $950,000 expenses, 8% interest, $100,000 principal, $350,000 capital work, and $60,000 trust costs, annual cash is negative $1.06 million. The $600,000 reserve leaves a $460,000 gap. Exit receipts are withheld until a funded path is supplied.

The fourth case keeps the reference year's cash but uses $200,000 exit NOI at a 10% cap rate. Its $2 million gross price cannot cover the listed closing claims, even with $652,000 remaining cash. The closing gap is $5.408 million. The earlier $400,000 payment stays visible, but no complete receipts ratio is calculated.

Read Funding Gaps and Compare Scenarios

Each result shows changes from S1, the reference case, for collected rent, owner payment, and terminal cash. An unavailable terminal amount remains unavailable in the comparison. The model does not turn a failed path into a zero-dollar sale result.

Changing several inputs at once can reveal a combined exposure. It does not identify how much each input caused. To isolate one effect, create a case that changes only that input. Keep the others fixed and state that limit.

A funded label means the listed arithmetic closes. It does not establish that the rent is achievable, the expense estimate is complete, the reserve is sufficient, or the sale can occur. Those questions need evidence outside the calculator.

Keep a separate list of excluded risks. Examples include intra-year cash timing, tenant failures, major repairs, changing loan terms, legal restrictions, and uncertain exit rights. FINRA's private-placement guidance discusses investigation of assets and claims and careful review of third-party work for covered firms. A calculator does not satisfy those duties. FINRA Notice 23-08.

Use and Export the Workbench

Enter the shared values, then complete S1. Add up to five alternatives. Scenario IDs remain stable after removal, and S1 remains the reference. Distinct labels help prevent a case from being mistaken for another version.

Calculate after edits. Any input change clears old results and disables downloads. Invalid entries preserve the entered values so you can correct them. Removal, reset, and example replacement use on-page confirmation; cancel preserves the form, and further editing cancels a pending confirmation.

The display selector changes which result cards appear. Full JSON and text downloads retain all cases, inputs, notes, and results. The full JSON has a one-mebibyte UTF-8 size limit; oversized calculations are rejected while form values remain available.

There is no account, storage, upload, restore, or source-fetching feature. Download a copy before leaving. Keep the documents and a note of the chosen modeling period with it. The page does not maintain a revision history.

Keep Unmodeled Risks Beside the Results

An annual model can hide a cash shortfall in March even if December cash is positive. It can also miss a contract restriction or an expense that was never entered. Do not treat a clean table as proof that those issues were checked.

Private offerings can be illiquid and provide limited disclosure, as the SEC explains. A modeled sale does not create a buyer or a transfer right. Keep household cash needs and the actual offering terms separate from this hypothetical closing calculation. SEC private-placement bulletin.

Use the workbench to identify the assumptions that deserve further work. A large change in modeled cash is a reason to inspect the source and test the path, not a reason to assign a universal safety score.

FAQ

Does the workbench answer whether DST investments are safe?

It shows how entered assumptions affect cash. It does not evaluate every risk, estimate loss probabilities, or recommend an investment. Funded arithmetic can still depend on weak evidence or omit a major obligation.

Is the occupancy input a physical unit count?

No. It is the occupied share of the full gross-rent schedule. A physical percentage fits only if rent differences and the chosen assumptions justify that use. The tool does not make the conversion for you.

Why can the payment be lower than my entered plan?

The model pays only cash above the chosen reserve target, up to the planned amount. This is an explicit calculator rule. It does not determine what any real trust is required or permitted to distribute.

Why are exit receipts sometimes not calculated?

An operating or closing funding gap leaves the assumed path incomplete. The tool preserves the gap without inventing rescue money or a personal payment obligation. Revise the model only when you have a defensible funding assumption.

Does a 1.2452 receipts ratio mean a 24.52% annual return?

No. It compares modeled receipts with a chosen capital reference. It does not verify the initial investment date, earlier cash, outside fees, tax, or a complete dated return calculation. It should not be presented as an investor IRR.

Can I add all the stress cases together?

No. They are alternatives for the same modeled year and sale. A combined stress needs its own input set, as the example shows. Adding the outputs would repeat shared income, cash, and debt.

About Sequoia Research

Sequoia Research, LLC provides independent research on DSTs and other real estate investment offerings. This educational library helps readers trace claims, compare evidence, and identify questions that need further review.

Sources