Tool & guide

How to Choose DST Sponsor: Track-Record Definition Normalizer

By Sequoia ResearchPublished Read as Markdown

Track-Record Definition Normalizer

Users record performance definitions, cost scope, populations, weighting, and dates. The tool compares entered fields and preserves revisions without converting returns or certifying that performance is comparable.

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 definitions behind Delaware statutory trust, or DST, sponsor track records. You enter what each presentation says about returns, costs, covered programs, methods, and dates. The tool marks matching labels, differences, and missing facts while keeping the reported figures as text. It helps organize a source review without converting returns or choosing a sponsor.

Table of Contents

Start With the Meaning of the Measure

Two numbers can look ready to compare because both end with a percent sign. That is not enough. One may describe cash paid during a year. The other may describe a gain over the whole holding period. A third may include an estimated value for interests that investors still hold. Before asking which number is larger, find out what each number means.

The Securities and Exchange Commission, or SEC, discusses fees, methods, hypothetical results, selected periods, and benchmarks in its September 15, 2022 performance-claims bulletin. It encourages readers to understand how results were calculated and presented. That educational bulletin does not approve a sponsor or supply the underlying records for this tool. SEC performance-claims bulletin.

The normalizer is a manual comparison board. It does not read a presentation, calculate an internal rate of return, or turn one kind of return into another. It compares the descriptions you enter. Its use of the word normalizer refers to consistent fields and small text cleanup. It ignores letter case and repeated spaces when comparing labels. It does not infer a shared meaning from different words.

Set the Sponsor Track-Record Review Scope

Start with a clear comparison purpose. For example, you could compare how three presentations describe completed-program results. Use a cutoff date no later than today in Coordinated Universal Time, shown as UTC. The first saved identity fixes that purpose and cutoff. Export the board and start a new one if either needs correction.

Save one identity for each sponsor and presentation you want to examine. Include enough detail to distinguish similar files. A legal name, presentation title, and edition label may help. The tool permits up to eight fixed identities. It does not merge aliases or establish which legal entity produced a file. A duplicate name with only different capitalization or spacing is rejected.

Use one selected measure for each identity. If one presentation contains several measures, create separate identities that name those measures. Do not put an annual return and a distribution rate in the same record. The board cannot separate two definitions hidden in one text field. You need at least two saved identities before preparing the review.

Enter a Source and Its Definition Fields

Next, append a definition version to a saved identity. Enter the source, version, and page reference you actually used. Record when the source was issued, if known, when you read it, and when you recorded the version. Write a reason for the entry or change. A citation such as “page four, footnote two, October edition” is more useful than “website.”

The reported value field is optional text. It can retain a percentage, multiple, range, or a note that no figure was supplied. The tool does not parse it. A blank value never becomes zero. No subtraction, averaging, sorting by performance, or calculation of investor returns occurs.

The twelve comparison fields are organized as follows:

Area Fields compared What to capture
Measure Type and definition The named measure and how the source describes it
Result basis Cash or valuation basis Actual cash, estimated continuing value, or projected figures
Costs Cost basis and cost detail Stated costs included and excluded
Programs Status and covered population Which programs enter the calculation
Method Weighting choice and method note How individual figures become the stated result
Dates Window start, window end, and as-of date The exact observation period and data cutoff

Select Unknown when the source does not answer a category. Leave an unknown text field blank. Other is available for a measure or weighting method that does not fit the listed choices. That custom category remains a comparison gap, even if two records both use it. Describe the custom method in the notes and review it outside this board.

Read the Pairwise Comparison Results

The review compares every pair of included identities. Four included identities create six pairs. A saved identity with no version stays in view. Its record is unknown. It does not vanish because its source work is unfinished. You can exclude a record only by saving an explicit excluded version with a reason.

Each field has one of three findings: entered labels match, entered labels differ, or unknown or custom basis. A missing field stays unknown even if the other record is also missing it. Two empty boxes are not evidence of a shared method. The values shown beside the finding let you inspect what caused it.

An aligned pair needs every field to be known and match. Both records also need a manual source-review check. The confirmation records your own check. It states that you compared the entries with the cited source. It does not authenticate the source, validate the calculation, or establish that the investments are comparable in economic terms.

The board also lists groups of fully described, manually checked records with identical entered definitions. A group of one has no matching partner. Group order follows entry order and has no ranking meaning. Different, unknown, and unchecked pair counts can overlap, so adding those counts can exceed the number of pairs.

Follow the Fictional Four-Presentation Example

Load the example to see four invented presentations: Alder, Birch, Cedar, and Dune. No name or figure represents a real sponsor. Alder and Birch have the same entered definitions for a cumulative return measure. Their reported text values differ, at 12% and 14%. The board does not subtract those figures or choose the larger one.

Cedar uses estimated continuing value and includes continuing interests. Those two fields differ from Alder and Birch. Dune lacks the cost-detail entry and has no manual source-review confirmation. Other example fields match Alder. These facts produce the following results:

Pair Main result in the example
Alder and Birch Entered definitions align only
Alder and Cedar Two entered definition fields differ
Birch and Cedar Two entered definition fields differ
Alder and Dune Cost-detail gap and missing manual check
Birch and Dune Cost-detail gap and missing manual check
Cedar and Dune Differences, a gap, and a missing manual check

There are six pairs, one aligned-label pair, three pairs with differences, three with gaps, and three with missing checks. The flag counts total nine because some pairs appear in more than one flag category. They are not nine separate failed investments. Three records are fully described and manually checked, forming two groups: Alder with Birch, and Cedar alone.

Keep Return Methods and Costs Separate

Do not rewrite source definitions just to make the board show a match. If one source says net of offering charges and another excludes a selling charge, retain that difference. Matching a broad Net label is not enough; the cost-detail text must also match. The strict text check is a prompt to review definitions, not a language engine that understands every fee term.

Suppose an original teaching case shows a $20 gain on $100 invested, before a separate $3 cost. The gain after that cost would be $17 under those narrow assumptions. But the board does not deduct three percentage points from a reported annual return. The cost's timing, base, and treatment may differ. Preserve the source figure and ask for the method and cash records needed to rebuild it.

Weighting also matters. In a separate invented illustration, one program has a 10% cumulative return and another has 20%. An equal-program arithmetic mean is 15%. Weighting those same figures by one and three equal capital units gives 17.5%. Neither calculation proves which weighting is appropriate. Neither is a pooled return calculation that uses the dates of all cash flows. The board keeps those method labels separate.

The same care applies to the covered population. All completed programs differs from all completed apartment programs. A small set of selected exits differs from a complete set of launched programs. The text field records your description. It cannot determine whether the source omitted a program, mislabeled a status, or left out losses.

Preserve Corrections and Excluded Records

Saving a new version appends a record. It does not overwrite the older one. The new record keeps a reference to its prior version, and only the latest version drives current pair comparisons. Old definitions, values, references, dates, and reasons remain in the full export. This allows another reader to follow why a comparison changed.

For example, Dune might later supply a cost explanation. Add a fresh Dune version with the new source reference, complete definitions, and a new source-review choice. Selecting a saved identity clears unsaved version fields. Old answers and checks are not copied into the form. That helps prevent a new source from inheriting a review it has not received.

To remove Cedar from current comparisons, append a version marked No for inclusion and explain why. The record remains visible as excluded. With Alder, Birch, and Dune included, the board has three pairs instead of six. It does not call the excluded record rejected, bad, or false. Restore it by appending another included version after reviewing the source.

If the sponsor or presentation identity itself is wrong, start a new identity and exclude the mistaken one with a clear note, or start a new board. Fixed identity labels cannot be silently renamed beneath a history of source checks. The eight-identity limit includes excluded identities, and the sixty-version limit includes older versions.

Check Dates Before Comparing Results

Use both observation-window dates or leave both blank. A start date cannot follow an end date. A known end cannot follow the data as-of date, when supplied, or the date you read the source. A known as-of date also cannot follow the read date. This board describes records available by the review cutoff; it does not accept future observation windows.

A known source issue date cannot follow the read date. Known window-end and as-of dates cannot follow the issue date. The read date cannot follow the version-recorded date, which cannot follow the board cutoff. New versions cannot be recorded earlier than the previous version for that identity. These checks catch impossible entered sequences. They do not prove when a file was created, changed, delivered, or reviewed.

Unknown dates remain possible. For instance, you can save a source with no issue date. An unknown issue date does not itself block label alignment because it is an audit-trail field rather than one of the twelve comparison fields. An unknown as-of date does block alignment. It is part of the defined comparison basis.

Exact date matching is deliberately strict. Two annualized return measures might still be useful to discuss despite different observation windows. This tool will flag that date difference. It does not decide that no informed comparison is possible. The reader must explain the purpose and limits of any comparison made outside these matching rules.

Export a Review That Another Person Can Follow

Prepare the saved review, then download the full JSON or text file. JSON preserves the structured records. Text provides the same substantive record in a reading format. Both include all identities, all versions, latest comparisons, definition groups, exclusions, and limitations. A display filter changes which pairs you see on screen; it does not narrow the exported record.

Unsaved inputs block review and export. Save or cancel them first. Changing inputs clears the prepared results, so an earlier export cannot appear current after a pending edit. Loading the fictional example or starting a new board requires an on-screen confirmation. Cancel preserves the saved and unsaved work.

Entries exist only in the open page. There is no file upload, import, network lookup, automatic storage, email, or reminder. Refreshing or closing the page loses the board. Downloads may require a separate Save file button below the embedded tool. Save the export before leaving the page, and keep it with the source records you are permitted to retain.

The board limits saved data to 180,000 UTF-8 bytes and each export to 500,000 bytes. Individual fields enforce their own character limits. Some characters use more than one byte. If a limit is reached, shorten unsaved notes or split the work into smaller boards; failed saves do not remove existing records.

Use the Results to Ask Better Questions

A useful next question names the exact difference. Ask whether a cited return includes estimated continuing interests, which costs were deducted, or why one source uses a different program set. Record the answer with its source and date. A reply that simply repeats the headline number leaves the original question open.

The Financial Industry Regulatory Authority, or FINRA, addresses past-performance representations, material claims, and careful review of third-party information in Regulatory Notice 23-08. Those duties apply in the covered member-firm context. This manual board does not demonstrate that a firm has performed its required investigation. FINRA Notice 23-08.

The SEC's private-placement bulletin, updated September 21, 2026, explains limited disclosure, illiquidity, and potential loss. A group of matching definition labels does not remove those risks. Keep the comparison result alongside the source gaps and the separate questions about a proposed investment. SEC private-placement bulletin.

FAQ

Does This Tool Calculate or Verify Returns?

No. Reported figures are stored as text. The tool compares entered definitions and dates, but it does not calculate returns, inspect cash records, authenticate a source, or confirm an audit. A manual check records the user's review statement only.

Why Does Other Stay Unmatched Even When Both Sources Use It?

Other can represent two entirely different methods. The board therefore treats it as a custom basis requiring further review. Enter the actual explanation in the method fields and consider it outside the fixed matching rules. Do not force an unsuitable standard label to obtain a match.

Can Two Different Numbers Have Matching Definitions?

Yes. The fictional Alder and Birch figures have matching entered definitions but different reported values. That means the labels passed this narrow test. It does not mean either value is correct, the investments have equal risk, or one sponsor deserves a higher rank.

Can an Unknown Record Be Saved?

Yes. Unknown categories and blank definition fields stay visible. A saved identity with no version also remains in the pair comparisons as unknown. Required source references, review dates, and change reasons still apply when you save a version.

Does Excluding a Record Delete It?

No. The latest excluded version removes that identity from current pair comparisons. Its identity and all earlier versions remain in the exports. Exclusion needs a reason and is a review-scope choice, not a finding about the sponsor.

What Does the Tool Normalize?

It normalizes letter case and whitespace for comparison. It does not rewrite definitions, merge legal entities, convert units, infer synonyms, or turn a cumulative return into an annual one. Differently worded descriptions may require a human explanation even when the underlying methods are alike.

What Should I Save With the Export?

Keep the cited source editions, relevant pages, and any responses that explain the definitions, subject to your access rights. The export records what was entered and compared. It does not contain the underlying documents or prove that the entries accurately describe them.

About Sequoia Research

Sequoia Research, LLC provides independent research on DSTs and other real estate investment offerings. Its educational guides and tools help readers trace evidence, examine assumptions, and keep unsupported conclusions separate from source statements. They do not replace offering documents or advice based on an investor's circumstances.

Sources

Sources checked October 18, 2026. All example names, source records, figures, and comparisons in this tool are invented. No real sponsor presentation or investor cash-flow file was evaluated by the tool.