Delaware Statutory Trust Returns: Dated Cash-Flow Return Calculator

What Is This Article About?

This guide explains how to calculate Delaware statutory trust returns from money paid and received on specific dates. It shows why a distribution rate, an equity multiple, and an annualized return can describe different parts of the same investment. You will learn how to enter cash flows, handle an estimated ending value, and recognize cases where a single internal rate of return would mislead. Worked examples make the method easy to check before you use it with your own records.

Table of Contents

• Start With the Investor's Cash Flows
• DST Distributions Are Not Total Return
• How to Enter Dates and Amounts
• How the Calculator Measures DST Returns
• A Simple One-Year Return Example
• Why Payment Timing Changes Annualized Return
• Open Investments and Estimated Ending Values
• When an IRR Is Ambiguous
• Check Fees, Taxes, and Duplicate Entries
• Comparing Several DST Investments
• Limits of the Prototype
• Frequently Asked Questions
• About Sequoia Research

Start With the Investor's Cash Flows

A cash-flow return calculation begins with a ledger. On one side is the money you paid. On the other is the money you received. Each amount needs a date. You can build the ledger from subscription records, account statements, distribution notices, and sale records.

Use the amounts for the investor whose result you want to measure. A property-level return and an investor-level return can differ because of debt, costs, and how cash is allocated. Mixing the two makes the result difficult to interpret, even if the arithmetic is correct.

Enter contributions as negative numbers. They are cash leaving the investor. Enter distributions and net sale proceeds as positive numbers. They are cash coming back. The sign describes direction, not whether the payment is good or bad.

This ledger is also a useful research check. A missing payment, a mismatched date, or a sale estimate treated as cash can change the answer. Resolve those points before comparing your result with a marketing figure.

The SEC's private-placement bulletin, updated September 21, 2026, explains that these investments can have limited disclosure and poor liquidity. That makes source records and clear valuation labels especially important. See the SEC's private-placement guidance.

DST Distributions Are Not Total Return

A distribution rate describes a stream of payments relative to a stated base. Total return also depends on what happens to the invested capital. A payment schedule alone cannot settle that second question.

For example, suppose an investor contributes $100,000 and receives $5,000 during a year. That is $5,000 of cash received. If the investment is still open, you also need a supported value for the remaining position to estimate a full-period return. Without it, the ledger describes cash receipts to date.

Now suppose the investment ends and pays $90,000 in net sale proceeds. Total receipts are $95,000 when combined with the earlier $5,000. The investor received less than the $100,000 contributed. A distribution rate viewed alone would not reveal that capital outcome.

The classification of a distribution for tax purposes is a separate question. This calculator uses cash movement. It does not decide how much is taxable income, return of capital, or another category. Keep the tax documents with the ledger, but do not use a tax label to change an actual cash amount.

How to Enter Dates and Amounts

The input accepts one cash flow on each line. Use this format: date, amount, and either “actual” or “estimated.” Dates use year-month-day. Amounts use plain numbers without currency signs or thousands separators.

For example, 2023-01-01,-100000,actual records a $100,000 contribution. The line 2024-01-01,110000,actual records a later $110,000 receipt. Both are hypothetical examples.

Use the date relevant to the cash-flow measure you are building, and apply that choice consistently. Do not use a statement's print date for one payment and a bank receipt date for another without a reason. Note whether the date records a transfer, settlement, or receipt.

The calculator sorts the entries by date. It checks that dates exist and that at least one negative and one positive amount are present. It nets same-day cash flows when testing the sign pattern for annualized return. Gross contributions and receipts remain separate for the equity-multiple calculation.

Mark any assumed ending value as estimated. The output will then say an estimated value is included. The prototype does not verify the value or infer whether an investment is open. If the position is open and you omit its remaining value, the result is only about the entered receipts.

How the Calculator Measures DST Returns

The tool reports contributions, receipts, net dollars, equity multiple, and an annualized dated return when the cash-flow pattern supports that calculation. Each measure answers a different question.

Total contributions are the absolute value of all negative entries. Total receipts include positive entries, including an estimated ending value if you entered one. Net dollars are receipts minus contributions. When a value estimate is included, “net” is not all cash in the bank.

The equity multiple is total receipts divided by total contributions. If you contribute $100,000 and receive $120,000, the multiple is 1.20 times. It does not account for the length of the investment. A 1.20 multiple reached in two years and the same multiple reached in ten years have the same ratio.

The annualized dated return accounts for when each cash flow occurs. It finds a rate that makes the present value of the entered inflows and outflows balance. The prototype uses actual elapsed days divided by 365. This is the date convention described in Microsoft's XIRR function documentation.

The tool solves that equation for a conventional pattern: money goes out first, then comes back, with one change from negative to positive after same-day amounts are netted. For other patterns, it shows the dollar totals and multiple but does not report one IRR as if it were the only useful answer.

A Simple One-Year Return Example

Assume a $100,000 contribution on January 1, 2023, and a $110,000 final receipt on January 1, 2024. The interval is 365 days. There are no other entries, taxes, or outside fees in this hypothetical example.

The calculator reports $100,000 contributed, $110,000 received, and $10,000 net. The equity multiple is 1.10 times. The annualized dated return is 10% because the $10,000 gain occurs over exactly one 365-day year.

Change the final receipt to $90,000. Net dollars become negative $10,000, the multiple becomes 0.90 times, and the annualized result becomes negative 10%. A negative result is valid arithmetic. It is not a tool failure.

Now put both entries on January 1, 2023. The dollar totals and multiple still have meaning, but there is no elapsed period over which to annualize the result. The tool does not show an IRR. A same-day gain divided into a zero-length holding period is not a meaningful annual return.

This example is useful for checking your inputs. Before using a long history, test two simple entries whose answer you know. If the signs or dates are reversed, fix the ledger first.

Why Payment Timing Changes Annualized Return

Consider two hypothetical investments with the same $100,000 contribution and the same $120,000 total receipts. In the first, all $120,000 arrives after 730 days. In the second, $20,000 arrives after 365 days and $100,000 arrives after 730 days.

Both have a 1.20 equity multiple. The first has an annualized return of about 9.54%. The second has an annualized return of about 10.50%. Receiving part of the money sooner changes the dated return even though total receipts are identical.

You can check the second result with the equation for two yearly periods. The rate must make $20,000 divided by one year's growth factor, plus $100,000 divided by two years' growth factor, equal $100,000. The calculator handles the dates so you do not need to arrange every payment into equal periods.

This is why comparing annualized results requires comparable methods. One presentation may use monthly cash flows while another assumes year-end payments. Another may report property-level results instead of investor-level results. Ask for the underlying ledger and date convention before attributing a difference to investment quality.

The calculator does not assume you reinvest the early payment in another asset. It measures the dated cash flows of the investment itself. If you want to model what happens after you receive cash, build a separate reinvestment scenario and label its extra assumptions.

Open Investments and Estimated Ending Values

A complete realized result is available only when the relevant investment cash flows are complete. An open position still has something left to value. Entering an estimate can create an interim performance calculation, but the estimate must stay visible.

Suppose you invested $100,000, received $10,000 over time, and estimate that the remaining interest is worth $95,000. The entered receipts plus value total $105,000. That does not mean you have received $105,000 in cash. It combines $10,000 of cash with a $95,000 estimate.

Date the estimate at the valuation date, not the original purchase date. Record its source and what it represents. Is it a gross asset value, a net value after debt, or an estimate of your interest after costs? Only the relevant investor-level amount belongs in this ledger.

Do not enter both a final sale receipt and an ending value for the same interest. That would count the remaining capital twice. If a partial sale leaves an interest outstanding, identify the sold portion and the remaining portion separately in your notes.

Missing value is not zero value. If no supported estimate is available, leave the value unresolved and describe the output as a cash-receipt calculation. The tool will not manufacture a valuation to complete the record.

When an IRR Is Ambiguous

Some cash-flow patterns can produce more than one rate that solves the IRR equation. A common warning sign is more than one change in direction: a contribution, then a receipt, then another required payment.

A simple hypothetical pattern is negative $100, positive $230 one year later, and negative $132 after another year. Both 10% and 20% solve the equal-year equation. Presenting just one number would hide the ambiguity.

The prototype takes a conservative approach. When the net dated amounts change sign more than once, it does not choose one root. It reports that the pattern is nonconventional and keeps the cash totals visible. That does not prove every such pattern has multiple roots; it means the tool has not established a single useful IRR to report.

Same-day entries are netted before this check. If a payment and receipt occur on the same date, their net direction matters for the equation. Keep both entries in the source ledger, though, so you can still explain what happened.

If your investment has a complex pattern, take the dated ledger to a qualified analyst. Ask which return measure fits the question and what assumptions it needs. A software result should not override an unresolved measurement problem.

Check Fees, Taxes, and Duplicate Entries

Use net investor receipts when that is the performance level you want. If a distribution already reflects property fees, do not subtract those fees again. If you paid a separate account charge outside the recorded cash flows, decide whether your analysis includes it and apply that choice consistently.

The SEC's July 2025 fee bulletin explains that fees reduce investment value and points readers to account and product disclosures for cost details. That supports checking both sources before calling a return “net.” See the SEC fee bulletin.

This prototype does not calculate taxes or tax deferral. It also does not decide whether a 1031 exchange qualifies. A tax-adjusted analysis needs the investor's actual tax facts and professional input. Do not apply a single assumed tax percentage to every payment and call the result a verified after-tax return.

Look for duplicate receipts imported from more than one record. A distribution notice and a bank entry may describe the same payment. Match the amount and timing before counting both. Likewise, check whether a final sale payment includes the last operating distribution.

Comparing Several DST Investments

For a portfolio-level cash-flow result, combine the actual investor contributions and receipts across the chosen holdings, keeping their dates. State which investments are included and why. Do not simply average the reported IRRs and call that the investor's portfolio return.

The amounts and dates determine how much each holding affects the combined result. A small investment with a high reported rate does not carry the same cash weight as a much larger position. An average of rates loses that information.

Use the same valuation date for open holdings when building an interim portfolio measure. Mark estimates, identify missing values, and keep the scope consistent between periods. A portfolio result can change because the included holdings changed, even if no individual investment improved.

Keep a separate record for each position. A combined result helps describe the whole experience, while the individual ledgers help explain what drove it. Both views are useful when they share the same definitions.

Limits of the Prototype

The calculator uses a 365-day year, not a business-day calendar. It does not adjust for inflation, currency changes, taxes, or reinvestment. All amounts must use the same currency. It searches for a conventional IRR within a broad but finite rate range and reports when no supported result is found.

No sponsor data or account history loads automatically. The values remain in the browser page, and reloading clears them. The download saves your entered history and results on your device. Use that file with the source records so another reviewer can repeat the calculation.

Frequently Asked Questions

Is a DST distribution rate the same as IRR?

No. A distribution rate describes payments relative to a stated base. IRR uses the timing and amounts of the full entered cash-flow stream. It can also depend on an estimated ending value if the investment is still open.

Can the calculator show a return before a DST is sold?

It can calculate a result using a clearly labeled ending-value estimate. That result is partly unrealized. Without a remaining value, the output covers entered cash receipts and does not describe the complete investment outcome.

Why are contributions negative?

They represent money leaving the investor. Receipts are positive because money comes back. Using both as positive numbers prevents a normal cash-flow return calculation and will trigger an input error.

Why might my result differ from a sponsor's report?

Check dates, fees, valuation assumptions, investor entry price, and whether the report measures property or investor results. Ask for the calculation's definitions and cash-flow record. A difference is a reason to reconcile methods before drawing a conclusion.

Does an equity multiple include time?

No. It divides total receipts, including any entered value, by total contributions. A multiple can describe how much came back relative to what went in, but it does not show how long the process took.

Does the calculator guarantee that one IRR exists?

No. It withholds IRR for nonconventional sign patterns or a missing time span. It also reports a search-range limitation if it cannot locate a supported root. Review the cash ledger when the result is unavailable.

About Sequoia Research

Sequoia Research, LLC provides independent research on DSTs and other real estate investment offerings. This guide and calculator help readers compare performance measures, preserve source records, and distinguish cash receipts from estimates. They support research and do not provide a personal investment recommendation.

Sources

• SEC: Private Placements under Regulation D. Updated September 21, 2026; reviewed October 16, 2026. Supports private-placement information and liquidity context.
• Microsoft: XIRR Function. Current documentation reviewed October 16, 2026; publication date not stated. Supports the explanation of dated cash flows and the 365-day convention. The prototype is a separate implementation.
• SEC: How Fees and Expenses Affect Your Investment Portfolio. July 23, 2025; reviewed October 16, 2026. Supports the fee and net-return context.

Numerical examples and the discussion of this prototype's limits describe its own calculation method. They are not actual DST performance records.