Tool & guide

Best DST Investments: Property Expense Stress Tester

Best DST Investments: Property Expense Stress Tester

Users supply the operating budget and hypothetical changes to insurance, property taxes, repairs, and other expenses. The output shows modeled changes in operating cash flow without importing unsourced market forecasts.

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 guide explains how to test changes in a property's operating expenses using your own cash budget. The tool holds cash receipts steady and changes selected payments, such as insurance, property taxes, repairs, and utilities. It shows each change, the combined effect, and which totals remain unknown because inputs are missing. A fictional example explains how to read the results without turning them into a payout forecast or an investment ranking.

Table of Contents

What the DST Property Expense Tool Measures

The tool answers a narrow question: how would the entered operating cash budget change if selected costs changed and receipts stayed fixed? You supply the base amounts and the changes. It imports no insurance forecasts, tax estimates, repair quotes, or market averages. The result is a calculation of your assumptions.

The baseline operating cash balance equals entered receipts minus all entered baseline operating payments. The stressed balance uses the same receipts but substitutes the changed payments. Their difference shows how the chosen expense changes affect that limited cash balance. A higher expense uses more cash; a lower expense leaves more within this scope.

This approach can help isolate a cost that is easy to overlook in a long offering forecast. It also makes a combined case visible when several changes occur together. It cannot tell you how likely the changes are or decide which DST is best. An insurance increase chosen by a reader remains an assumption even when the arithmetic is exact.

Expense sensitivity is a recognized part of real estate analysis. The OCC's commercial real estate lending handbook discusses changes in operating expenses among the variables used in sensitivity work. That is banking guidance, not an endorsement of this tool or a DST safety threshold. OCC Commercial Real Estate Lending, printed page 22.

Choose One Cash Scope and Budget Period

Start with the property or group of properties covered. Use the same ownership scope for receipts and every expense. Full-property receipts cannot be paired with an investor's small share of expenses. A partial interest also needs its own supported allocation before its amounts can form a consistent budget.

Enter a start date and an end date for one period of 1–366 days, counting both dates. Future budget periods are allowed. The separate review date cannot be later than the current local date. That date records when you reviewed the inputs; it does not turn a future budget into historical results.

Every dollar entered must cover the full stated period. The tool does not multiply monthly amounts by twelve, split annual amounts into quarters, or prorate a cost because the period is short. A 90-day budget needs amounts for those 90 days. A full year needs full-year amounts, even when a particular bill is paid in one month.

Use cash receipts and cash operating payments on a common basis. Billed rent and collected rent can differ. An expense incurred near year-end may be paid later. The SEC's financial-statement guide distinguishes income from cash movement and separates operating, investing, and financing cash flows. This tool uses a selected cash-budget scope rather than preparing those formal statements. SEC Beginners' Guide to Financial Statements, January 12, 2014.

Record the scope in the cash-basis field. For example, identify whether receipts include parking income or tenant reimbursements. State the source period and costs left outside the exercise. The confirmation box asks you to accept a consistent scope; the software cannot inspect the underlying accounts to prove it.

Enter Baseline Costs Without Double Counting

Add between one and twenty-four expense rows. Each needs a unique label, a baseline amount or blank, a change type, a baseline source note, and a scenario note. A label such as “Insurance premium, building policy” is easier to trace than “Cost 1.” Separate policies may need separate rows if their coverage or assumed changes differ.

Use positive amounts for payments. Enter zero when the payment is known to be zero. Leave an unknown amount blank and explain the missing record in the source note. Text such as “Not supplied in the budget packet” preserves the gap without creating a made-up estimate.

Check subtotals before adding rows. If “Other operating costs” already includes utilities, adding utilities again overstates total expenses. Either remove utilities from the subtotal or use the complete subtotal alone. The tool rejects duplicate labels after ignoring letter case and extra spaces. It cannot detect the same bill hidden under two different names.

Expense responsibility also matters. The OCC cautions that net-lease labels do not have universal definitions and directs readers to the lease itself for cost duties. Review the actual owner and tenant obligations before choosing your scope. OCC handbook, printed page 140.

If a tenant pays a bill directly and that payment never enters the owner's accounts, do not insert it into an owner-only cash budget. If the owner pays and later receives a reimbursement, a gross cash view may include both sides. This tool holds all entered receipts fixed, so it will not automatically raise reimbursements when expenses rise. That limit needs to be explicit in the scenario.

Choose a Dollar or Percentage Expense Change

Each row offers three choices. No change carries the baseline into the stressed case. Its change field must be blank. Percent change applies the entered rate once to that baseline. Dollar change adds the entered amount to the baseline. A negative change reduces the cost; a positive change increases it.

For percentage changes, enter 25 for a 25% increase or -5 for a 5% decrease. Do not enter 0.25 when you mean 25%. The permitted range is -100% through 1,000%, with up to four decimal places. These are software bounds, not statements that any particular stress is plausible.

Dollar inputs accept up to two decimal places and an absolute amount of $1 billion per input. Omit commas, currency symbols, and exponent notation. A dollar reduction cannot make the resulting expense negative. A blank percentage or dollar change remains unknown; it does not mean no change.

A percentage is applied to the original row each time you calculate. Entering 10%, calculating, and then changing the field to 20% produces a 20% increase from the baseline. It does not compound the first increase. To model a known series of changes, calculate the combined full-period assumption separately and explain it.

The new percentage-based line is rounded to the nearest cent, with half a cent rounded up. The displayed change then equals that rounded line minus the baseline. For a deliberately tiny example, a $0.03 cost reduced by 50% becomes $0.02 after rounding, a $0.01 decrease. The tool sums those rounded lines; it does not round a combined unrounded expense total afterward.

Work Through the Birch Square Example

The built-in example is a fictional property with $2 million of cash receipts for January 1 through December 31, 2027. All names, amounts, and changes are invented. Receipts stay fixed in both cases, and the stated operating budget has six non-overlapping rows.

Operating payment Baseline Chosen change Stress case Expense change
Insurance $120,000 Increase 25% $150,000 $30,000
Property taxes $300,000 Increase 8% $324,000 $24,000
Operating repairs $90,000 Add $35,000 $125,000 $35,000
Utilities $160,000 Decrease 5% $152,000 ($8,000)
Property management $100,000 No change $100,000 $0
Other operating payments $330,000 No change $330,000 $0
Total $1,100,000 Combined case $1,181,000 $81,000

The baseline leaves $900,000 after these operating payments. The stressed case leaves $819,000. The $81,000 expense increase reduces the selected operating cash balance by the same amount because receipts do not change. No reserve withdrawal or new borrowing is silently added to cover a cost.

The utility reduction partly offsets the three increases. It does not remove the need to explain why that saving is assumed. If the reader lacks support for it, a separate case could hold utilities at $160,000. That case would have $1,189,000 of expenses and $811,000 remaining, an $89,000 reduction from the baseline.

These two cases are alternatives. Do not add their $81,000 and $89,000 effects together. They share most of the same cost changes. Export the first case before editing the utilities row, and use a different scenario note for the second.

Read Missing Amounts and Partial Subtotals

The results distinguish full-scope totals from known-row subtotals. A full baseline expense total requires every baseline amount. A full stressed total requires every stressed amount. A cash balance also needs known receipts. When a necessary input is blank, the affected full total displays as unknown.

Suppose the Birch Square property-tax baseline remains $300,000 but its percentage change is blank. The baseline total and $900,000 baseline balance still work. The stressed amount for taxes is unknown, so the full stressed expense total and balance are withheld. The other five stressed rows total $857,000, clearly labeled as a known-row subtotal.

The known paired expense changes total $57,000 in that partial case. That figure omits the unknown tax change. It is not the property's complete cash impact and should not replace the original $81,000 combined result. Once a supported tax change is entered, the full comparison can be recalculated.

Now imagine the tax baseline itself is blank. The known baseline rows total $800,000. Both the tax baseline and its stressed amount remain unresolved, even if a percentage is supplied. Applying a rate to an unknown cost cannot create a known dollar answer. The tool preserves the missing input instead of multiplying zero by the rate.

A result with no blank inputs still depends on the scope you entered. Leaving out an entire insurance policy does not create an empty row for the software to detect. Reconcile the rows to the source budget and check the stated exclusions before calling the input set complete.

Separate Operating Cash From Investor Distributions

The tool excludes debt service, capital work, transfers into reserves, and owner payouts. Those uses require a separate cash bridge. A positive operating result can coexist with little cash left after other obligations. It can also hide a shortfall on a particular payment date because this tool totals a period rather than scheduling each receipt and bill.

Do not label the result standardized net operating income, or NOI. Different analytical definitions may include adjustments that differ from immediate cash movements. The OCC handbook discusses that distinction in its property underwriting section. Its banking measure is not automatically the same as a sponsor's report or this tool's selected cash balance. OCC handbook, printed page 42.

Keep repair scope clear as well. Routine operating repairs can belong in the selected budget. Major capital work requires separate treatment and a funding plan. Do not place a roof project here merely to make a single total look comprehensive, then count the same project again in a capital budget.

A negative result means the entered receipts are less than the entered operating payments. It does not establish a legal default, loss amount, or new loan. The model supplies no outside funding. A positive result likewise does not establish that the trust may distribute that amount or that an individual investor will receive a stated share.

Test Assumptions With Useful Source Notes

Attach a document name, page or worksheet reference, date, and explanation to important inputs. A current insurance quote differs from a prior paid premium. A proposed property-tax estimate differs from a bill. A repair bid may exclude work included elsewhere. Record those distinctions instead of treating every number as equally established.

Use the scenario note to say why you chose a change and what remains uncertain. “Assume an extra $35,000 of operating repairs for this case” is more precise than “repairs will rise.” If a number comes from an outside professional, preserve the scope and date of that estimate without representing the software as having verified it.

The SEC's performance bulletin explains that targets and projections are hypothetical and do not reflect actual performance. This tool's cases are also assumptions, though it does not calculate investment returns. Exact arithmetic does not convert them into observed outcomes. SEC Performance Claims, September 15, 2022.

Save and Compare Your Scenarios

Calculate after entering or editing the data. Any input change clears the old result and disables exports until you calculate again. This prevents a download from pairing old calculations with new assumptions. A rejected entry preserves your form values so you can correct the problem.

The JSON and text exports include the full inputs, source notes, row results, known subtotals, missing amounts, scope limits, and full totals when available. Save them with meaningful scenario names. There is no import feature or automatic storage; reloading or closing the page can lose unsaved entries. The tool makes no network requests to retrieve your sources.

Loading the fictional example, clearing the form, or removing a row requires confirmation within the tool. Cancel preserves the current entries. Editing an input while a confirmation is pending cancels that pending action. Review any changed row list before recalculating, especially when a removed cost belonged in the full budget.

Frequently Asked Questions

Does this tool identify the best DST investment?

No. It tests entered property expenses under stated assumptions. It does not assess sponsor quality, legal terms, debt, taxes, investor fit, or future sale value. Use the result as one defined part of a broader review.

Can I enter monthly expenses beside annual receipts?

Only after converting them to the same stated period yourself. The tool performs no annualization or proration. Explain the conversion and check for seasonal or one-time bills before treating a monthly amount as a full-year input.

Does a blank expense mean zero?

No. Blank means unknown and withholds affected full totals. Enter 0 when you have established a zero payment within the selected scope. Record the source or assumption that supports it.

Will higher costs automatically raise tenant reimbursements?

No. Receipts remain fixed. The lease may provide reimbursement rights, but collection timing and scope require separate analysis. If testing a different receipt assumption, save it as a separate scenario and explain the change.

Does the output show a reserve balance or distribution cut?

No. It shows receipts less selected operating payments for one period. Opening cash, reserves, financing, capital work, and distributions are outside the calculation. A separate dated cash plan is needed to connect these results to those uses.

Are the example stresses current market forecasts?

No. All example changes are invented teaching inputs with no assigned likelihood. Replace them with clearly labeled assumptions or sourced estimates appropriate to your review. The tool does not fetch or validate market data.

About Sequoia Research

Sequoia Research, LLC provides independent research on DSTs and other real estate investment offerings. This library helps readers connect financial claims to source records, inspect assumptions, and prepare focused questions.

Sources

Sources inspected October 16, 2026. All figures and changes in the tool example and guide are invented; no market forecast or current offering ranking is supplied.