Research guide

Delaware Statutory Trust Returns: What a Missing Final Valuation Does to the Calculation

By Sequoia ResearchPublished Read as Markdown

What Is This Article About?

You can know every distribution a DST has paid and still lack the information needed for a total return. This article explains what can be measured when the remaining interest has no supported value at the review date. It uses an original cash record to show the difference between known receipts, assumed ending values, and a completed investment result. It also explains how to report the gap without turning an empty value field into a zero-dollar asset.

Table of Contents

Define What Final Valuation Means

The word final can refer to two different points. It may mean the last date in a review. The investor may still own the interest then. Or it may mean the investment has ended and all remaining cash and rights have been settled. Establish which meaning applies before choosing a return formula.

For an ongoing investment, the review needs an ending value for the remaining interest at its cutoff date. That value might be an estimate. It is not automatically the amount the investor could receive by selling immediately. The review should state the source and how the value was measured.

For an investment that has fully ended, actual final cash may replace the need to estimate an unsold interest. Even then, ask whether a holdback, claim, remaining asset, or later payment is still open. A property sale announcement does not by itself establish the last dollar available to an investor.

A blank ending-value field can have several meanings. The source may not publish a value. The reviewer may lack the relevant statement. A figure may exist but use the wrong date, class, or ownership amount. Those are evidence gaps. They are not interchangeable with a supported conclusion that the remaining interest is worth nothing.

The SEC explains that private placements may provide limited information, including information relevant to price, and may be hard to resell. Those limits make a careful description of the evidence useful. They do not establish that a particular unpriced interest has any specific value. SEC: Private Placements Under Regulation D.

This article uses invented people, properties, cash flows, and value assumptions. It does not value an actual offering. The goal is to keep a performance statement within the information that supports it.

Separate Known Cash From the Unknown Holding

Suppose Daniel pays $200,000 for an interest in the fictional Fern Brook DST. He receives $10,000 at the end of year one, $12,000 at the end of year two, and $8,000 at the end of year three. The review cutoff is immediately after that third payment.

Daniel still owns the interest. No sale has occurred, and no supported value for the remaining holding is available to this reviewer. Use V to represent that unknown ending value. V is measured after the year-three $8,000 payment, so it does not include that paid cash.

The example assumes one initial purchase, no added contributions, and equal one-year periods. Costs within the program are already reflected in the supplied distributions. There are no separate investor charges in the base case. Taxes and inflation are excluded.

Time Cash paid Cash received Remaining interest value
Start $200,000 $0 Not used as a later value
End of year one $0 $10,000 Not measured in this example
End of year two $0 $12,000 Not measured in this example
End of year three $0 $8,000 V: unavailable to the reviewer

The received cash totals $30,000. Daniel also still owns the remaining interest. Keeping the two columns apart avoids treating the cash record as the whole investment.

For actual work, tie each receipt to the investor's records. Confirm the trust, class, account, and receipt date. A trust-level distribution announcement may differ from a particular investor's received amount. A payment still in transit should not silently enter a table labeled cash received.

Also define the account boundary. If the investor spends a distribution elsewhere, the DST still paid it. Its later use belongs in a household or wider account analysis. The performance record should not erase the receipt because the money is no longer in the bank.

Report the Measures That the Cash Supports

Known cash supports a useful report even without V. Daniel invested $200,000 and received $30,000 through the three-year cutoff. Receipts equal 15% of the initial cash invested. The latest full year's received cash is $8,000, or 4% of that original amount.

Those cash measures use stated bases and periods. The 15% figure compares all receipts with the cash invested. It is not a 15% profit, an annual return, or a finding that 15% of tax basis has been recovered. The 4% figure describes the third year's cash relative to original cost, not the total return on the holding.

You can also report that the original cash paid exceeds cash received by $170,000. Call that difference the net cash still out of pocket within this simple record. Do not call it the remaining investment value or a confirmed $170,000 loss.

FINRA's return guidance includes investment cost, income, and changes in asset value. Its examples also show why the holding period matters. A record that has the cost and income but lacks the remaining value has only part of that economic picture. FINRA: Calculating Your Investment Returns.

Payment counts and changes are also available from the record. Daniel received three payments. Year-two cash exceeded year-one cash by $2,000; year-three cash was $4,000 below year two. Those facts do not identify why the amounts changed. The cause needs separate operating and funding evidence.

A clear incomplete report therefore still has substance. It can confirm money sent, money received, dates, costs within scope, and unanswered value questions. There is no need to omit those known facts. The error would be to present them as a full economic return.

Keep Missing Value Separate From Zero Value

An empty spreadsheet cell often behaves like zero in arithmetic. That convenient software behavior can become a serious reporting error. If V is unavailable, the calculation should show unavailable or incomplete, rather than replace it with zero behind the scenes.

For Daniel, putting zero into the ending-value field produces total measured receipts of only $30,000 against $200,000 paid. The resulting cumulative loss is $170,000, or 85%. That output assumes the remaining interest contributes no value. It does not prove the assumption.

Zero can be a valid input when supported by the chosen measurement and facts. It can also be a clearly labeled downside scenario. In either case, explain why it is being used. Missing evidence, a stale statement, or lack of an immediate buyer is not itself proof of a zero-dollar value.

Keep at least three states distinct in a review system: value unavailable, value supplied but not yet checked, and value accepted for a stated analytical use. A fourth state may identify an assumption used only for a scenario. Separate labels help keep an assumed value out of the actual record.

Avoid treating original cost as the automatic repair. Carrying $200,000 into V would create an ending value equal to Daniel's purchase price. That might be a useful scenario, but the fact that he once paid that amount does not establish its value three years later.

The same caution applies to a prior projection. A forecast sale price is a claim about a future outcome under assumptions. It is not a current valuation merely because no better figure is at hand. Preserve the gap and explain which evidence would be needed to resolve it.

Understand Why Total Return and IRR Need More

For this one-purchase example, a simple cumulative economic gain at the cutoff is:

Known receipts + remaining interest value − initial investment.

Daniel's expression is $30,000 plus V, minus $200,000. It simplifies to V minus $170,000. Because V is unknown, the complete gain is unknown. The formula shows exactly which missing input matters.

Divide that gain by $200,000 to find the total economic return for this record. It does not annualize the result or account for the timing differences among the three payments. An annual rate needs a method that accounts for when cash arrives.

An internal rate of return, or IRR, uses cash amounts and their timing. For a review before exit, it uses the ending value as the final amount in the model. That does not mean a sale occurred or that the investor received that amount in cash.

In Daniel's equal-year example, an interim IRR would use the initial negative $200,000, then $10,000, $12,000, and finally $8,000 plus V. Without V, a single complete interim IRR is not established. Actual dated cash needs a method suited to those dates. Here, each period is one full year.

A calculator may still return a number if given only the known cash. Here it produces about −58.02% annually. That is the rate for a zero residual-value path, not a discovered return for the ongoing holding. The software has solved the inputs it received; the inputs do not describe the full known scope.

The SEC encourages readers to examine performance methods and what they include or omit. An unlabeled missing terminal value is part of that inquiry. A precise answer from a formula should not hide an incomplete input record. SEC: Performance Claims.

Use Assumed Values as Scenarios

Scenarios can show how much the unknown input matters. They should sit beside the incomplete actual record, with a clear label identifying the assumed values. None should overwrite the blank source field.

Hold Daniel's known cash and timing fixed. Test V at $140,000, $170,000, $200,000, and $230,000. These are selected teaching values, not appraisals, bids, probabilities, or a supported value range.

Assumed remaining value after the third payment Cumulative economic gain or loss Cumulative return Interim annual IRR
$140,000 −$30,000 −15% −5.60%
$170,000 $0 0% 0.00%
$200,000 $30,000 15% 5.02%
$230,000 $60,000 30% 9.58%

Every row includes the same $30,000 already received. The difference comes entirely from V. The annual rates are rounded results of the stated equal-year cash flows, not advertised distribution rates.

Increasing V by $10,000 changes the cumulative return by five percentage points because $10,000 is 5% of $200,000. It does not add five points to the IRR. The annual-rate relationship depends on the timing and size of all the cash flows.

Do not call the middle row most likely merely because it is in the middle. Do not average the assumed values and present that average as a valuation. The table shows how the math changes. It gives no evidence about which row will occur.

If a qualified valuation source later supplies a range, document its basis, date, and limits. That is a different kind of input from this chosen test grid. Even a supported estimate should remain labeled as an estimate rather than cash already realized by Daniel.

Calculate a Required Value Without Calling It an Estimate

A missing value does not prevent every forward question. You can solve for the value that would be needed to meet a stated goal, while keeping that required amount separate from evidence of actual value.

Daniel's nominal cumulative break-even value is $170,000. At that amount, the $30,000 received plus the remaining interest equal his $200,000 initial cash. This threshold uses stated costs and dollars before inflation. It is not proof that the remaining interest is worth $170,000 or can be sold for it.

Now choose an 8% annual IRR as a separate target for analysis. It is not an expected result or a recommended hurdle. Using Daniel's three annual periods, the required ending value is:

$200,000 × 1.08³ − $10,000 × 1.08² − $12,000 × 1.08 − $8,000 = $219,318.40.

This equation places every earlier amount on the year-three date using the chosen target rate. It finds the terminal amount that makes the cash-flow equation balance. It does not assume Daniel actually reinvested his distributions at 8%.

The required $219,318.40 is the remaining interest value after the year-three payment. Adding the $8,000 payment to it inside the terminal cash flow is correct. Adding that payment to the required value and then counting it again would be wrong.

A target-derived number can help frame a question for a valuation reviewer. How does a supported estimate compare with the amount needed for the chosen goal? The direction of reasoning matters. A desired return cannot justify an appraisal, and a spreadsheet cannot make the trust produce the amount required by a goal.

If the target, costs, or cash timing changes, recalculate the threshold. Save the earlier version so no one mistakes a revised goal for an unchanged investment result.

Find Out What an Ending Value Represents

Before using a supplied number, ask what it measures. It might describe the whole property, the trust's net assets, one class of interests, or an investor's particular holding. It might be a book amount or an estimate based on an appraisal. It could also be a suggested sale price. A dollar sign does not make those measures the same.

Ask for the valuation's effective date and the date the report was issued. A report delivered in October could value conditions as of June. That can be useful evidence for June without establishing the October value. Identify any later events that the reviewer says were considered.

Also ask who prepared the figure, what method was used, and which documents supported it. Does it deduct debt? Does it include trust cash? Does it assume a property sale or continued ownership? Are transaction costs included? These questions define the number before it enters the return calculation.

The SEC's educational account-statement guide notes that values for infrequently traded securities may rely on market data that is not current. It also distinguishes consolidated held-away information from the underlying account statements. The guide does not establish the source or reliability of any particular DST value. SEC: Better Understanding Your Brokerage Account Statement.

A statement date alone is therefore not enough. Read the footnote and ask whether the price was updated or simply carried forward. If the source cannot be established, keep the number in a supplied-but-unverified category for this review.

This approach does not require rejecting every estimate. It requires matching the estimate to its intended use. An estimated return before exit can be useful when its scope is clear. An estimate presented as a completed cash return makes a claim the underlying record does not support.

Bridge Property Value to the Investor Interest

A property's value is not automatically the value of an investor's DST interest. Use a separate fictional balance-sheet example to see the difference. None of these amounts describes Fern Brook or fills Daniel's missing V.

Suppose a property is valued at $30 million for an illustrative analysis. Debt is $16 million, trust cash is $400,000, and other liabilities are $200,000. Assume these inputs are complete and all refer to the same date. Assume one class with simple proportional rights and no other assets, liabilities, or allocation differences.

The modeled net assets are $30 million minus $16 million, plus $400,000, minus $200,000. That equals $14.2 million. A one-percent economic share is $142,000.

One percent of the property value alone would be $300,000. It omits the debt, cash, and other liabilities. The $158,000 difference between those two investor-level figures shows why the measurement level matters.

Now consider a separate modeled-sale branch. Assume a 2% selling-cost allowance on the $30 million property value, or $600,000. With every other input unchanged, modeled net proceeds become $13.6 million. A one-percent share is $136,000.

The $142,000 net-asset illustration and $136,000 modeled-sale illustration use different cost boundaries. Neither establishes a market price for an illiquid interest. Actual allocation rights, discounts, liabilities, sale terms, and costs could require a different analysis.

Do not deduct the $600,000 again if the supplied net-proceeds figure already includes it. Likewise, do not add the $400,000 cash again to a value that already includes it. Each bridge should show where every amount enters exactly once.

A reviewer may need to leave part of that bridge incomplete. Showing an unresolved debt or allocation input is more accurate than using a property appraisal as if it directly valued the investor's remaining interest.

Reconcile Distributions With the Valuation Cutoff

The return calculation needs a clear boundary between cash already paid and value still held. Otherwise the same money can appear in both parts of the result.

In Daniel's base record, V is after the year-three $8,000 distribution. If a supplied estimate instead measures the interest immediately before that distribution, do not add the payment without considering whether the estimate already includes the cash that funded it.

Under a tightly controlled example, an interest worth $178,000 immediately before paying out $8,000 would have $170,000 left immediately after, if nothing else changed. Either $178,000 before the payment or $8,000 cash plus $170,000 after can describe the same combined amount. Using $8,000 plus the full $178,000 would count the payment twice.

That adjustment is not a general rule for updating a stale valuation. Between different reporting dates, rents, expenses, liabilities, property values, and other payments may also change. The simple subtraction works only under the explicit no-other-change assumption.

A declared but unpaid distribution needs similar care. Establish whether the valuation includes a liability for it and whether the investor's record includes a receivable. Do not count both a receivable and the same cash when it arrives without clearing the earlier entry. The correct presentation depends on the chosen cash or accrual basis.

Keep reserves within their actual ownership and access boundaries. Trust cash is not automatically cash Daniel can withdraw. Including it in an economic value does not make it available for his next household bill. A return calculation and a personal liquidity plan answer different questions.

Write the cutoff convention next to the value. “After the distribution paid on the review date” is more useful than “latest value” when the timing could affect the result.

Update the Record When Final Cash Arrives

Continue the fictional Fern Brook record with a separate later outcome. At the end of year four, Daniel receives $10,000 of additional cash and $155,000 of final exit proceeds. Assume no ownership interest, holdback, claim, later payment, or obligation remains after that date.

The year-four combined receipt is $165,000. Adding the earlier $30,000 gives total cash receipts of $195,000. Against the initial $200,000, the completed nominal cash result is a $5,000 loss, or 2.5%. The equal-year annual IRR is about −0.68%.

This completed path has a different end date from the earlier interim review. Do not compare its final rate with a year-three estimate without identifying that extra year and the new cash. An estimated value is not a promise of the cash paid later.

Suppose the year-three report had used an expressly assumed V of $170,000. That scenario showed zero cumulative economic gain at that earlier date. The later $5,000 completed loss does not automatically prove a formula error in the scenario. It shows that a hypothetical intermediate value and a later cash outcome are different records.

If an actual earlier estimate is revised, explain why. A newly found source error, a changed valuation method, and a later market event are different causes. Keep the original report and issue a dated revision rather than silently replacing the history.

Reconcile the final proceeds to the investor's receipts. A property closing statement may show cash belonging to the trust before other obligations or allocations. The completed investor return should follow the investor's actual cash boundary. Mark any unresolved final amount before calling the record complete.

Check Fees and Keep Tax Questions Separate

The ending value and the known cash must use compatible cost boundaries. A net value paired with distributions before investor charges can produce a mixed result. The missing valuation should not distract from missing fees elsewhere in the record.

The SEC identifies both transaction and ongoing charges and points investors to offering documents, account statements, and other fee disclosures. Use those records to establish which charges are already reflected and which the investor paid separately. SEC: How Fees and Expenses Affect Your Investment Portfolio.

For a separate variation, suppose Daniel paid a $2,000 outside charge at purchase. His total initial cash would be $202,000. With the original $30,000 of receipts, nominal break-even would require $172,000 of remaining value. The original $170,000 threshold would no longer match his all-in cash record.

Do not add that charge to the base example unless this variation is intended. Do not subtract it twice if an original investment amount already includes it. Show how the purchase amount plus fees equals the total cash paid.

Taxes are excluded throughout these examples. The $170,000 net cash difference in the base case is not a tax-basis calculation. A negative modeled economic return is not automatically a deductible tax loss. A cash payment's tax treatment cannot be inferred from the fact that it reduces the cash still out of pocket.

Keep those questions for the appropriate tax records and professional review. The performance worksheet should preserve the investment cash and value assumptions without pretending to settle a separate tax calculation. If an after-tax analysis is later prepared, give it its own inputs, dates, and clearly stated scope.

Show Valuation Coverage in a Group of Holdings

When several positions appear in a report, the missing-value problem can disappear inside a total. A spreadsheet may add the available values, skip blanks, and display the sum as total portfolio value. That label would overstate what the evidence establishes.

Use a separate coverage example with five holdings and $1 million of initial invested cash. Suppose three holdings have values suitable for the stated review, and two do not. The three covered holdings account for $550,000 of original invested cash; the two missing holdings account for $450,000.

Coverage is 60% by holding count and 55% by original invested cash. Neither figure is coverage by current portfolio value, because the values of two holdings are unknown. The two percentages answer different questions. State the base used for each.

Do not infer that the uncovered holdings performed poorly, performed well, or match the covered group. Excluding them can change the picture in either direction. Keep their known cash receipts visible while marking the missing residual values.

If a report shows returns for the three covered holdings, label that subset. Do not call its average the result of all five. A completed subset may be useful, but its scope cannot grow just because the report title names the whole portfolio.

The next step is an evidence request for the specific missing positions. Record what value is needed, at which date and ownership level, and why the available source does not meet that need. More arithmetic on the covered positions will not resolve the missing inputs.

Publish an Incomplete Result Clearly

An incomplete result should say what is known before explaining what is missing. For Daniel, a concise statement could read: “Cash invested: $200,000. Cash received through the year-three cutoff: $30,000. Remaining interest: still held; supported ending value unavailable to this reviewer. Total economic return and interim IRR: not established.”

Add the dates and cost boundary. If scenarios are included, place them in a separate table headed assumed ending values. Keep the source field for actual V blank with an explicit unavailable status. Do not make readers infer the distinction from a small footnote.

A useful evidence request would ask for the exact holding and class, effective valuation date, method, source data, debt and cash treatment, included costs, and any later relevant changes. Ask whether the number is meant for account reporting, estimated net assets, or modeled sale proceeds. The purpose helps determine whether it fits this calculation.

Preserve the worksheet version and the unresolved request. When new information arrives, show which input changed and which outputs can now be calculated. A review date should identify when the evidence was assessed; it should not make an older valuation appear newly effective.

The report can be honest and useful without one headline percentage. A clearly stated cash history, an explicit value gap, and labeled scenarios tell the reader more than a complete-looking number built on a hidden assumption.

FAQ

Can I calculate any DST performance measures without an ending value?

Yes. You can report verified cash paid, cash received, payment dates, and ratios tied to stated cash bases. Those measures do not establish the total economic result while a residual interest remains unvalued. Label them as cash summaries rather than full investment returns.

Does an unavailable value mean the investment is worth zero?

No. Unavailable describes an evidence gap. Zero is a numerical conclusion or an explicit scenario assumption. Ask why the value is missing and what the source actually says. Do not let a blank spreadsheet cell silently become a zero-dollar remaining interest.

Can I use my original purchase amount as the current value?

Only as a clearly labeled assumption unless appropriate evidence supports that value for the chosen date and use. The price paid earlier does not itself establish current value. Keeping the original cost as a placeholder can hide a gain or loss just as using zero can distort the result.

Why does a calculator still produce an IRR from the distributions alone?

It can solve the cash flows you entered while treating omitted residual value as absent. In the example, that yields a zero-residual scenario. It does not value the unsold interest. Check the terminal input and the calculation's scope before treating the rate as the complete interim result.

Is an appraisal of the building enough to value my DST interest?

It is one possible input, not the whole calculation. Debt, other liabilities, trust cash, allocation rights, and the intended cost boundary can matter. Confirm how the property-level figure connects to your specific interest. A simple share of the total may be wrong when the rights differ.

What if I receive a final payment but a holdback remains?

Record the payment and keep the remaining claim visible. Calling the payment final does not establish that the investor has no further economic interest. Explain what is still unresolved and whether it can be valued. A completed cash-only result requires a properly defined endpoint.

Can I show a value needed to reach a target return?

Yes, if it is labeled as a required amount under stated assumptions. The example's $219,318.40 is what would balance a chosen 8% annual IRR through year three. It is not an estimate, appraisal, bid, or forecast. A desired return cannot supply evidence of value.

About Sequoia Research

Sequoia Research, LLC provides independent research on DSTs and other real estate investment offerings. This educational library helps readers understand investment evidence, test calculations, and state the limits of incomplete records.

Sources