Tool & guide

Top DST Sponsors: Underwriting Assumption Pattern Viewer

By Sequoia ResearchPublished Read as Markdown

Underwriting Assumption Pattern Viewer

Users enter sourced assumptions from multiple offerings with dates and property context. The viewer highlights similarities, changes, and outliers without classifying an unusual assumption as wrong before further analysis.

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 a tool for comparing the assumptions entered in different offering documents. You define one measure, its unit, its forecast period, and the property groups that belong together. The viewer shows repeated values, differences between source versions, and unusual values within each entered group. It keeps the source history and unknown values visible without judging whether an assumption is right.

Table of Contents

What an Underwriting Assumption Pattern Can Tell You

An underwriting assumption is an input used to model a possible investment result. Examples include rent growth, a future vacancy rate, or a planned holding period. This tool compares one clearly defined input at a time. It does not combine those inputs into a forecast of investment returns.

DST means Delaware statutory trust here. A sponsor may use assumptions across several offerings, but a shared sponsor name does not make every property comparable. The viewer relies on you to define the measure and decide which property contexts belong in the same group. It cannot read the documents or check that judgment.

A repeated input may come from a shared method, similar conditions, or copied text. A different input may reflect a different property, date, plan, or error. The viewer cannot choose among those explanations. It makes a pattern easier to inspect and keeps the source location available for follow-up.

The Financial Industry Regulatory Authority, or FINRA, discusses private-placement investigations and due diligence records in its 2026 oversight report. The report was published in December 2025. Its guidance concerns covered firms and their duties. A user-entered pattern report does not perform that investigation or establish compliance. FINRA 2026 private-placement review

All inputs stay in the current browser page. The tool does not fetch documents, contact a sponsor, monitor a website, or save an account record. Use the downloads before leaving. The analysis describes your entered sample and makes no claim to represent the DST market.

Define the Measure Before Comparing DST Offerings

Write a comparison title that names the question. “Year-two base-rent growth in selected housing programs” gives more useful scope than “Sponsor quality.” Define exactly what the number measures, including whether it includes changes in occupancy, concessions, or other items that might affect the meaning.

Choose Percent, Years, Ratio, or USD as the unit. The labels do not convert values. Enter 3 for three percent, not 0.03. Enter dollar amounts on the same basis, such as annual dollars per property, and state that basis. A total property cost and a cost per unit cannot be compared just because both use USD.

State the common forecast period. The second full operating year after acquisition differs from the next calendar year. Choose one and explain how you matched each source to it. If two documents use different periods, obtain a suitable comparison or create separate analyses instead of silently treating the periods as equal.

Write a property-context grouping rule. You might separate housing from warehouses, then narrow groups further by a documented business plan. A group name is your classification; the software does not prove economic comparability. Its spelling matters only for keeping entered rows together.

The definition locks when you save it. To change the metric, unit, horizon, or group rule, start a new comparison after exporting the old one. This avoids making retained source checks appear to cover a different question. An empty saved definition can be reported, but it produces no offering statistics.

Enter Sources and Keep Property Context

Each snapshot needs the exact offering and sponsor, a group, a source date, a source-check date, a source reference, and an exact location. Add notes explaining the property's context and how you read the assumption. These notes can also explain missing evidence.

Choose Known only when you have a value to enter. Choose Unknown when the value is unresolved and leave its numeric field blank. Zero is a known numeric value with a different meaning. Unknown rows remain in the history and coverage counts but do not enter the statistics.

Use plain numbers with up to four decimals. Commas, percent signs, scientific notation, and extra decimal places are rejected. The software accepts values from negative 100,000,000 through positive 100,000,000. That broad limit protects the calculation; it is not a statement that a number is reasonable for the chosen measure.

The source date must be on or before the check date. The check date must be on or before the evidence cutoff, which cannot be later than today in Coordinated Universal Time, or UTC. Enter real calendar dates. These checks test your entries, not whether the document was actually issued or reviewed on those dates.

Confirm the source, identity, group, definition, unit, horizon, and dates after entering the other fields. Changing any snapshot field clears that confirmation and removes an earlier report from view. Save the snapshot or clear the unsaved fields before building a new report. The confirmation records your statement about your work; it is not independent source verification.

Read Similarities and Changes Across Versions

The viewer uses the latest dated snapshot for each offering in the current group statistics. Earlier versions stay in the full history. Entering several documents for one offering does not give that offering several votes in the latest-value sample.

A later version of the same offering must have a later source date. The sponsor and group must remain the same for that offering identity. A corrected identity or grouping decision requires a new comparison. This is a small research file, not a system for tracing corporate changes or merging entities.

Repeated-value clusters contain at least two distinct offerings with the same latest numeric value. For example, 2 and 2.0000 count as the same value. Close values such as 2 and 2.0001 do not. The tool does not round different inputs into a similarity claim.

Version comparisons use adjacent saved snapshots for each offering. A move from 2% to 3% is a one-percentage-point change. It is not labeled a 1% relative increase. The report preserves both source dates and values so a reader can see what changed in the entered documents.

If either adjacent value is unknown, the numeric change is withheld. The viewer does not skip over an unknown middle version to claim a continuous numeric change. A document revision is also not proof that a sponsor changed its intent; the source may clarify a previously unclear term. Use the notes to explain that distinction.

How the Outlier Calculation Works

For each group, the tool reports the minimum, maximum, median, and range of known latest values. The range is the maximum minus the minimum. With no known values, these figures are withheld. With one known value, the minimum, maximum, and median match, and the range is zero.

At least four known latest values are required for the outlier test. The viewer sorts those values and splits them into lower and upper halves. When the count is odd, it leaves the middle value out of both halves. The median of the lower half is the first quartile, and the median of the upper half is the third quartile.

Subtract the first quartile from the third to get the interquartile range, or IQR. The lower fence is the first quartile minus 1.5 times the IQR. The upper fence is the third quartile plus 1.5 times the IQR. Only values strictly outside those fences receive a flag; a value exactly on a fence does not.

The National Institute of Standards and Technology describes IQR-based fences in its box-plot guidance. The viewer states its own quartile convention because software can use different conventions, especially for small samples. A flag here is descriptive, not a statistical conclusion about the broader market. NIST box-plot guidance

If the IQR is zero, both fences equal the same value. Any different value can then be flagged. That behavior may occur in a small group with repeated assumptions. Read the actual values and group size before attaching meaning to the flag. No entry is deleted or labeled incorrect.

Work Through the Fictional Rent-Growth Example

Load the example to inspect nine source snapshots for eight invented offerings. Seven belong to the Housing group and one to the Warehouse group: six housing values are known, one housing value is unknown, and the warehouse value is known. No real sponsor, offering, or market dataset is represented.

The housing entries initially include Cedar, Maple, Spruce, Birch, Elm, Beech, and Ash. Cedar's first snapshot is 2%, and its later snapshot is 3%. Maple, Spruce, Birch, and Beech each have 2%. Elm has 8%. Ash is unknown. Pine is the only warehouse offering and has 4%.

For the latest housing sample, the six known values sort to 2, 2, 2, 2, 3, and 8. The median is two. The lower-half median is two, and the upper-half median is three. The IQR is one, so the fences are 0.5 and 4.5. Elm's eight is above the upper fence and receives one flag.

The housing minimum is two, maximum eight, and range six percentage points. The repeated-value group at two contains Maple, Spruce, Birch, and Beech. Cedar's old two remains in history but does not join that latest-value cluster. Its adjacent version comparison shows a one-point rise from two to three.

The warehouse group has one known value, four. Its range is zero and its outlier test is withheld because there are fewer than four known values. Pine is not pooled with the housing programs. The whole report shows nine snapshots, eight offerings, two groups, seven known latest values, one unknown latest value, one version comparison, and one outlier flag.

Test Unknown Values and a New Source Version

Try a later Ash snapshot with a supported entered value of 2% and a later source date. The housing group then has seven known latest values: five twos, a three, and an eight. The middle value is two and is excluded from both halves for the quartile calculation.

The lower half is three twos, so its median is two. The upper half is two, three, and eight, so its median is three. The fences stay at 0.5 and 4.5, and Elm remains flagged. Housing coverage improves, but this particular outlier result does not change.

The Ash version comparison runs from Unknown to Known. Its numeric change is withheld because the old value was not established. Do not describe the new value as a rise from zero. The new report has ten snapshots, eight offerings, eight known latest values, and no unknown latest values.

Now consider a different exercise in which Elm's latest value becomes Unknown. That version takes Elm out of the current numeric group without erasing its prior eight. The remaining known housing values determine the new statistics. The software does not fall back to the old value simply to preserve the former sample size or flag.

These exercises show why a flag count can change for several reasons. The input may change, a source may become unresolved, or the group may gain another offering. Preserve the report definition and full history so someone reading a later version can distinguish those events.

Turn a Flag Into a Research Question

Begin with the exact source location for a flagged row. Check whether the value uses the agreed definition and period. A rent increase at a lease renewal may differ from an annual portfolio-wide growth rate. A gross figure may differ from one after concessions. The viewer cannot make those interpretations for you.

Then inspect the property context. A plan with scheduled improvements may use a different assumption from a stable property. That explanation still needs support. Write down the relevant document passage rather than treating a plausible story as a confirmed reason.

Ask whether the group is useful. A common label such as Housing may conceal different property types or business plans. If the grouping rule changes, export the current file and start a new comparison with the revised rule. Do not claim that an outlier was disproved merely because it moved into a new group.

A repeated value also deserves context. Several offerings may use a documented common policy, or they may rely on separate evidence that happens to produce the same input. Equal numbers alone do not establish copying, rigor, or a common source. The appropriate output is a question supported by the pattern, not an accusation.

The tool helps choose what to inspect next. It cannot rank sponsors, select an offering, or determine whether a projected result is achievable. Keep the source-based explanation beside any pattern you share so the reader can see how much remains unresolved.

Save the Full Report and Start a New Comparison

Build a fresh report after saving or clearing the current snapshot. Download JSON for the full structured file or text for a readable record. Both exports include the definition, cutoff, summary, group statistics, latest rows, adjacent version comparisons, and every saved snapshot.

When the embedded page presents a Save file button below the tool, use that second button to save the prepared download. Check the file after saving. A report viewed on screen is not a backup, and this tool does not restore files through an import feature.

The file can hold forty snapshots. It also limits the saved record to 130,000 UTF-8 bytes and the complete export to 350,000 bytes. Long notes or some characters can reach a byte limit before the row limit. A rejected addition preserves the earlier saved history.

Start new comparison and Load fictional example both ask for confirmation before replacing entries. Cancel keeps the existing work. Confirm clears or replaces it. Because there is no browser storage, closing or reloading the page also loses unsaved session work; export before doing either.

FAQ

Does an outlier mean an assumption is wrong?

No. It means a known latest value falls outside the tool's fences within the entered group. Check the definition, property context, period, and source before drawing a conclusion. A small sample can produce a flag without establishing any market-wide fact.

Can I compare several assumptions in one file?

Use one defined measure, unit, and horizon per file. Create separate files for rent growth, exit valuation, and other inputs. Mixing measures makes the range and quartiles meaningless even when the numbers look similar.

Are unknown values treated as zero?

No. Unknown values must be blank and are excluded from numeric statistics. They remain visible in the latest-value counts and source history. A known zero enters the calculation like any other supported entered number.

What does a percentage change in the version table mean?

For the Percent unit, the difference is in percentage points. Moving from two to three produces one point. The viewer does not calculate a relative growth percentage or the effect of that change on investor returns.

Why do different programs need separate groups?

The comparison should reflect a shared definition and relevant property context. The tool keeps groups separate but cannot verify your classification. A group label does not establish that different offerings face the same economic conditions.

Does the viewer save or verify my sources?

It saves your entered source references only within the current session and exported files. It does not retrieve or verify documents. Download the report and retain the underlying source records separately before leaving the page.

About Sequoia Research

Sequoia Research, LLC provides independent research on DSTs and other real estate investment offerings. This educational tool helps readers inspect assumptions and preserve the limits of a comparison. It does not provide an investment recommendation or a sponsor rating.

Sources