Tool & guide

Top DST Sponsors: Sponsor Ranking Sensitivity Tool

By Sequoia ResearchPublished Read as Markdown

Sponsor Ranking Sensitivity Tool

Users define comparison factors, documented inputs, and alternative weights. The tool shows how results change under those choices and labels the output as a user-defined comparison rather than an official sponsor 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 guide explains how to compare the same three sponsor profiles under two different sets of weights. You define four factors, supply scores with evidence references, and state why each weight matters. The tool shows how those choices change the order while keeping unsupported profiles out of both rankings. A fictional example explains the math, ties, missing information, and the limits of any user-defined result.

Table of Contents

What the Sponsor Ranking Sensitivity Tool Measures

The tool measures the effect of your weighting choices. It does not discover which sponsor is best. A score reflects the rubric and evidence you enter. A rank shows where that score falls among the eligible profiles in this file. Changing the weights can change the order even though every sponsor score stays the same.

This is useful when two reviewers agree on their entered scores but care about different factors. One may emphasize the coverage of selected records. Another may emphasize how clearly methods are explained. Showing both cases makes the role of those choices visible. It does not establish which preference an investor should adopt.

The form supports exactly three profiles and four factors. You can assign zero weight to a factor in both cases when it is outside the calculation. All four definitions and all three profile identities still remain in the file. There is no live sponsor database, automatic research, default official grade, or hidden adjustment.

The output is also separate from a credit rating. The U.S. Securities and Exchange Commission, or SEC, explains that credit ratings address creditworthiness and do not cover every investment risk. They are not investment recommendations or guarantees. This tool does not issue that kind of rating; its numbers are a transparent summary of user-entered scores and weights. SEC credit-ratings bulletin.

Define the Sponsor Profiles and Review Cutoff

Give the file a label, then identify each profile. Use the legal entity or clearly defined business group you mean to compare. Add the product scope and period. A broad parent-company history should not silently become evidence about a specific DST sponsor entity.

DST means Delaware statutory trust in this guide. A sponsor profile is a research subject, not a particular offering recommendation. Keep offering risks and an investor's personal needs in their own review. A sponsor comparison cannot replace that work.

The cutoff sets the latest evidence date accepted in the file. It cannot be later than the current date in Coordinated Universal Time (UTC). Each entered evidence date must be a real calendar date from 1900 through 2200 and no later than the cutoff. The date is your recorded evidence date; the tool does not determine whether a source is current.

Use distinct labels. Matching ignores case and normalizes Unicode and extra whitespace. This prevents two rows labeled “Sample A” and “sample a” from appearing as different profiles. It does not identify real corporate relationships or resolve two legal entities that share similar names.

When a profile's identity or scope changes, the form clears that profile's evidence checks. When the cutoff changes, it clears all evidence checks. Review the affected entries before confirming them again. This prevents an earlier scope confirmation from being carried silently into a different review.

Build Four Clear Scoring Factors

Each factor needs a label, a scoring rubric, and a reason for its weights. The rubric must explain what zero and 100 mean and make higher scores more favorable under your chosen definition. The tool does not convert raw measurements into a fair score or decide whether your scale is valid.

For example, “record coverage” needs a defined set of records and a rule for partial coverage. A score of 80 should have a meaning another reader can examine. Without that rule, the tool can calculate accurately while summarizing a vague judgment.

Do not copy unrelated raw numbers into the score boxes. Years in business, total assets, percentages, and a reviewer's opinion use different units. First decide whether a factor belongs in the comparison. Then explain any conversion to a common zero-to-100 scale. The software has no built-in view that bigger or older means better.

Avoid counting the same evidence twice through overlapping factors. If both “record coverage” and “reporting detail” reward the same document list, that evidence may receive more weight than intended. The tool cannot detect that overlap. Explain the boundary between factors or revise the design before relying on the result.

Changing a factor label or rubric clears all three evidence checks for that factor. Changing only its weight or the reason for the weight keeps the checks in place. This allows a sensitivity test to change priorities without changing the underlying score record.

Enter Scores With Evidence and Scope Checks

Every profile has one score record for each factor. Open its details panel and enter a score from zero through 100, with no more than two decimal places. A blank score means unknown. Zero is a real entered score and must meet the same evidence rules as any other number.

For an active factor, enter the evidence reference, its location, and its date. Add notes explaining the score and its limits. Then check that the source belongs to the stated profile, cutoff, and rubric. This is your manual confirmation. The tool neither opens the source nor checks that it supports the number.

An active factor is one with positive weight in either scenario. To enter both rankings, a profile must have a score, all required evidence fields, and a scope check for every active factor. One missing item withholds that profile from both scenarios. Its records and the missing-field explanation remain visible and downloadable.

This common eligibility rule matters. If each scenario used a different set of sponsors, a changed rank could reflect a changed comparison group as well as changed weights. The tool keeps the same eligible profiles in both cases so the comparison is easier to interpret.

The SEC's private-placement bulletin describes limits on public information for many private offerings. A blank evidence field can therefore represent a real research gap. It does not prove a sponsor performed poorly. The tool preserves that distinction by withholding the profile instead of silently assigning a zero. SEC private-placement bulletin.

Choose Two Sets of Sponsor Comparison Weights

Name the two scenarios clearly. “Emphasize record coverage” and “Emphasize method and relevance” explain the fictional example better than “good” and “bad.” Scenario labels must be distinct. Neither label creates a recommended policy.

Enter each weight between zero and 100, using at most two decimal places. The weights do not have to add to 100. The tool divides each by its scenario's total to create normalized weights. Each scenario needs at least one positive weight; an all-zero scenario is rejected.

For example, weights of 2, 1, 1, and 0 become 50%, 25%, 25%, and 0%. Weights of 50, 25, 25, and 0 produce the same result. The relative amounts matter, rather than whether the entered total happens to equal 100.

A factor weighted zero in both scenarios does not affect eligibility or scores. Its entered records remain in the export. If you later give it positive weight in either case, its evidence becomes part of the shared eligibility rule. Rebuild and inspect any newly withheld profile before interpreting the rank change.

State the reason for the choices before studying which profile wins. Otherwise it is easy to adjust weights until they favor a preferred name. A sensitivity exercise is most useful when it exposes reasonable alternatives and their effects, with the input choices preserved for review.

How Weighted Scores and Ranks Are Calculated

For each eligible profile, the tool multiplies each factor score by its normalized weight and adds the contributions. The resulting score stays on the zero-to-100 scale. It is a weighted summary of your inputs, not an estimate of return or loss probability.

Suppose a profile has scores of 90, 50, 60, and 80. Under weights of 50%, 20%, 20%, and 10%, its contributions are 45, 10, 12, and 8. Their sum is 75. The output shows each contribution so you can trace the total back to its factors.

Ranks use the exact entered hundredth units before display rounding. A profile's rank is one plus the number of eligible profiles with a strictly higher exact score. Equal exact scores tie. If two profiles tie for first and the third is lower, the ranks are one, one, and three.

Displayed scores and normalized weights use two decimal places. Different exact scores can therefore look equal on screen. For instance, 50.0025 and 50.0000 both display as 50.00, but the first is higher for ranking. The output explains that distinction. Rounded weight percentages may also total slightly above or below 100%.

Rank movement equals rank A minus rank B. A positive movement means a higher position in B; a negative movement means a lower one. At least two eligible profiles are required for ranks and first-place labels. With one eligible profile, its weighted scores can be shown, but ranks and leaders remain unavailable.

Work Through the Fictional Sponsor Example

Load the fictional example to inspect all fields and results. Samples A, B, and C are invented profiles with invented sources and scores. They do not describe a real firm, an actual account, or a tested sponsor dataset.

Factor Sample A Sample B Sample C Weight A Weight B
Record coverage 90 60 70 50 10
Method clarity 50 90 70 20 50
Sector relevance 60 80 70 20 30
Reporting detail 80 50 70 10 10

Both weight sets total 100, so the entered weights already equal their percentage shares. In scenario A, the profile scores are 75, 69, and 70. Sample A ranks first, Sample C second, and Sample B third.

In scenario B, the scores become 60, 80, and 70. Sample B ranks first, Sample C second, and Sample A third. Sample A's movement is negative two, Sample B's is positive two, and Sample C's is zero. The first-place set changes even though no underlying score changed.

Now remove one active evidence field from Sample C. It is withheld from both scenarios. The remaining profiles still have the same weighted scores, but their ranks are now one and two rather than positions within a three-profile group. That is a changed research file, not evidence that either sponsor improved.

Restore the field and recheck its scope to return to the complete example. This exercise shows why a saved comparison should include eligibility, evidence limits, and the full input set. A screenshot of the top row would omit the choices that produced it.

Understand Missing Data, Zero Scores, and Ties

Unknown and zero must stay separate. A blank score does not enter a weighted average as zero. A profile missing an active score or evidence field receives no weighted score or rank in either scenario. It remains in the report with the exact gaps listed.

A documented score of zero is allowed. It participates in the math when the required evidence fields and scope check are present. This is useful only when zero has the meaning defined in your rubric. It must not become a convenient replacement for an unanswered question.

Ties are also preserved. The tool does not break them alphabetically or invent a secondary quality measure. It reports all profiles tied for first as the first-place set. A stable first-place set means only that those entered scenarios produced the same leaders, not that the result would survive every reasonable choice of weights.

Invalid numbers, dates, or labels produce a clear error and leave the form available to correct. Scientific notation, negative scores, more than two decimal places, and values above 100 are rejected. The full JSON result has a 500,000-byte limit, measured as UTF-8 text, with separate field-length limits as well.

Read Rank Changes Without Turning Them Into Recommendations

The output answers a controlled question: how did these two weight choices affect these entered profiles? It does not test every possible weighting scheme, prove the best rubric, or assess an investor's needs. A small rank change is not a measured change in investment risk.

Read the factor contributions when the order changes. They show which scores received more influence. Then review whether the weighting reason makes sense for the question and whether the source actually supports the score. If the score itself is disputed, save a separate version that makes that change explicit.

The Financial Industry Regulatory Authority, or FINRA, describes covered firms' duties to investigate private placements and critically review supporting reports. A user-created comparison cannot stand in for that work. References and checkboxes organize your research; they do not verify documents or certify compliance. FINRA Regulatory Notice 23-08.

Update, Export, and Preserve the Review

Any input change removes the old results and disables both downloads. Changes to a score, evidence field, or score notes also clear that cell's scope check. Review the affected entry, confirm it when appropriate, and build again. Weight-only changes retain the checks so you can isolate the effect of weights.

Both exports include every profile, including withheld ones, all factor definitions, weights, source entries, gaps, and results. The JSON file preserves the structured record. The text file provides a readable review copy. Neither file can be imported back through this tool, and the page has no autosave or account storage.

Use the in-page confirmation before clearing the form or loading the example. Cancel preserves the entries. New typing cancels an older pending confirmation so it cannot later clear a changed form. Export before leaving or reloading; the saved file is the record you retain outside the page.

FAQ

Does the tool rank real sponsors automatically?

No. You enter all three profiles, scores, rubrics, and evidence references. The tool performs the stated math and reports missing fields. The sample is fictional, and there is no live data lookup or official sponsor grade.

Must the weights add to 100?

No. Each scenario's positive total is used to normalize its weights. Proportional weight sets produce the same scores. Each individual weight must be between zero and 100, and each scenario needs at least one positive weight.

Why is a profile withheld from both scenarios?

It lacks a required score, evidence field, or scope check for a factor active in either scenario. Using one shared eligible group prevents a difference in sponsor membership from silently affecting the two rankings. The withheld profile stays in both exports.

Can a zero score be included?

Yes, when it is an intentional score under the stated rubric and has the required evidence entries. A blank score remains unknown. Zero-weight factors are a separate concept: a factor weighted zero in both scenarios does not affect eligibility or the calculation.

Why can displayed equal scores have different ranks?

The display rounds to two decimal places, while ranks compare exact entered score and weight units. Two slightly different results may therefore both display as 50.00. Exact ties receive the same rank; no hidden tie-breaker is used.

Does a first-place result mean I should choose that sponsor?

No. It reflects your factor design, entered evidence, scores, weights, and eligible sample. It is not an offering review, credit rating, suitability finding, or prediction. Use it to explain how your comparison works and identify questions for further research.

About Sequoia Research

Sequoia Research, LLC provides independent research on DSTs and other real estate investment offerings. This educational library helps readers organize sources, inspect assumptions, and ask specific questions about investment documents and services.

Sources