Learn
A little clarity for your next decision.
Loading your learning library…
Investor WorkspaceWelcome, there!Log Out
Investor WorkspaceA little clarity for your next decision.
By Jerry Baker
DST sponsors project cash flow by estimating rent collected, subtracting property costs, and then accounting for debt, trust expenses, and reserves. The result is a forecast of money that may be available to investors, not a promise that those payments will occur.
The most useful question is not whether a spreadsheet adds up. It is whether its inputs reflect the property, leases, financing, and work required. A model can be mathematically perfect while resting on weak assumptions.
This guide explains how a forecast is built and how to test it. All numerical examples are hypothetical. They are not current market rates, available offerings, or recommendations for a particular investor.
First ask what the schedule measures. It may show the underlying property's operations, a master tenant's payments, the trust's cash, or an individual investor's distributions. Those levels connect, but they are not interchangeable.
Then identify the period. A calendar year, the first twelve months after purchase, and a partial first year can produce different totals. A rate labeled annualized may describe a full-year pace rather than cash actually paid during your first year.
Ask whether amounts are shown on a cash basis or another accounting basis. Revenue recognized in a period may not equal cash collected then. The same issue arises with expenses that are incurred before they are paid.
The OCC's lending handbook notes that operating statements, tax returns, and underwriting measures can use different treatments. Definitions matter when testing cash flow and debt coverage. The handbook is a lending reference, not a rule that sets any DST's payments. [1]
Put those definitions at the top of your review. Without them, two schedules may appear to disagree when they are simply measuring different things.
The rent roll lists the units or spaces, tenants, lease rents, and other lease details. It is a starting point for potential income. Compare it with recent receipts to see whether the listed amounts are being collected.
For apartments, a basic model might begin with the number of rentable units multiplied by monthly rent and twelve months. For a commercial building, it may begin with each lease's scheduled rent and changes. Neither starting point is the final cash forecast.
Separate occupied space from paying space. A tenant receiving free rent can occupy a building without producing the full scheduled cash. A signed lease that begins later should not generate current rent in the model.
Review expiration dates and notice periods. If leases roll during the forecast, the model needs assumptions about renewals, downtime, new rent, and costs to secure a replacement tenant.
Ask which figures come from signed contracts and which come from expectations. Both can appear in a forecast, but the reader should be able to tell them apart.
A useful forecast shows the deductions between full scheduled rent and expected receipts. Common categories include vacancy, concessions, and unpaid rent. The exact categories and definitions depend on the property.
Consider a fictional property with $2.4 million of annual potential rent. Assume $120,000 of vacancy loss, $60,000 of concessions, and $24,000 of uncollected rent. Add $60,000 of other income. The resulting amount is $2.256 million.
| Income assumption | Annual amount |
|---|---|
| Potential rent | $2,400,000 |
| Vacancy loss | ($120,000) |
| Concessions | ($60,000) |
| Uncollected rent | ($24,000) |
| Other income | $60,000 |
| Expected income | $2,256,000 |
Each deduction needs a definition so losses are not counted twice or left out. Ask whether the vacancy assumption already includes a bad-debt allowance or whether those are separate lines.
Other income also needs support. Parking, storage, reimbursements, and fees may have different collection patterns. A new charge is not automatically collectible merely because it appears in the budget.
A forecast may assume rents rise each year. Ask how that increase reaches cash. Existing leases might lock in rents for a period, while new tenants pay a different rate. A property-wide growth percentage can hide this timing.
For example, suppose half the rent can reset during a year and the proposed new rate is 4% higher. You cannot automatically apply a 4% increase to all annual receipts. The date each lease changes and the time the new tenant occupies the space both matter.
Ask for evidence from recent signed leases and close competitors. Advertised asking rent is not always achieved rent. Free rent, discounts, and leasing costs can change the effective result.
Compare the growth forecast with nearby new supply and the cost of moving to a competitor. A strong regional story does not prove that every building can increase rent at the same pace.
Use a slower-growth case as well as the base forecast. If the projected payment depends heavily on rent increases, you should be able to see that dependence rather than discover it after results fall short.
A single expense-growth rate is easy to enter and can be hard to defend. Taxes, insurance, utilities, payroll, repairs, and management costs may change for different reasons.
Ask which amounts come from current contracts, recent invoices, renewal quotes, or estimates. A seller's historical cost may not be the buyer's future cost. Property taxes, insurance terms, and service contracts deserve their own review at acquisition.
Check whether a tenant reimburses an expense and under what conditions. A reimbursement right may have limits, caps, exclusions, or collection delays. Model the owner's expense and the related receipt consistently.
Also ask what costs rise when occupancy grows. More revenue can bring higher utilities, staffing, turnover work, or other expenses. A model that gives full credit for new income while holding every cost flat needs an explanation.
In our example, assume annual operating expenses total $1.05 million. Subtracting them from $2.256 million of expected income gives $1.206 million of NOI under the model's stated definition.
Routine repairs and major replacements can appear in different parts of a model. Ask where the budget includes roofs, building systems, paving, tenant improvements, and leasing commissions when relevant.
A cost placed below NOI still uses money. Moving it to a reserve schedule does not make it disappear. Compare the condition and lease reports with the spending plan, including the expected timing.
Some models include a recurring replacement allowance in their NOI definition. Others deduct reserve contributions later. Read the definitions before adding a separate deduction. The goal is to count the economic need once, in the right place.
Ask whether planned work is funded now or from future operations. If a large expense arrives earlier than expected, the source of cash matters. A forecast that has enough money by year five may still face a shortage in year two.
Build a reserve roll-forward: starting balance, additions, spending, and ending balance. That schedule should agree with the operating cash forecast and any restrictions on the account.
Enter the loan's payment schedule rather than using only its interest rate. Include principal payments, interest-only periods, maturity, and any fees or required deposits that affect cash.
A fixed-rate loan and a floating-rate loan need different tests. For floating debt, examine the index, spread, floors, and any rate cap or hedge. Ask how long the protection lasts and what it costs to replace if required.
In our example, annual debt service is $650,000. Dividing the stated $1.206 million NOI by that amount gives about 1.86 times coverage. This is a simple illustrative DSCR calculation; a real loan may define the numerator differently.
Coverage of debt is not coverage of every investor payment. The property may meet its loan payments while having less cash left for trust costs, reserves, and owners. Ask whether covenants can restrict distributions even before a payment default.
Also read the maturity plan. Do not assume an extension or refinance is available merely because the model needs it. A DST's permitted powers and the loan's terms must support any proposed response.
Our fictional model begins with $1.206 million of NOI. Subtract $650,000 of debt service, $80,000 of trust-level costs, and $120,000 of reserve additions. That leaves $356,000.
If investor equity is $8 million, the remaining amount equals 4.45% of that equity for a full year. This assumes no other deductions or restrictions and that all remaining cash is distributed. Real terms may differ.
Notice what the calculation does not say. It does not establish a sale value, a total return, taxable income, or a guaranteed payment. It only converts the stated annual cash remainder into a percentage of the stated equity.
Ask which costs are already included in NOI and which are added below it. Trust-level asset management, accounting, legal, and other costs should have a clear home in the model where applicable.
Finally, compare the model's remainder with the distribution shown in the offering summary. If they differ, ask whether the difference comes from timing, reserves, a master lease, or another stated source.
When a master tenant leases the property from the trust, there may be two forecasts to review. One shows the real estate's operations. The other shows payments due to the trust and cash remaining at each entity.
Identify fixed rent, variable rent, expense duties, and any guarantees. Ask how the master tenant is funded and what happens if its operating receipts do not cover its scheduled payment.
A smooth trust-level forecast can hide uneven property-level cash flow. That may reflect a contractual allocation of risk, but the party taking the risk needs resources. A payment promise is only as useful as its terms and the ability to perform it.
Revenue Ruling 2004-86 describes a specific trust and lease arrangement with restricted powers. Its tax analysis does not guarantee rent or validate a master tenant's credit. Read the actual agreements and financial support separately. [2]
For your worksheet, keep each entity's receipts, costs, reserves, and transfers separate. Combining them too soon can hide which company has the cash and which company owes the payment.
Now change our example. Keep potential rent at $2.4 million, but increase vacancy loss to $168,000, concessions to $90,000, and uncollected rent to $36,000. Reduce other income to $54,000. Expected income becomes $2.16 million.
Assume operating expenses rise to $1.11 million. NOI falls to $1.05 million. Keep debt service, trust costs, and reserve additions at their original amounts. The remaining cash becomes $200,000, or 2.5% of $8 million.
Debt coverage is still about 1.62 times under the simple definition, yet projected investor cash has fallen sharply. That illustrates why passing one loan metric does not establish a stable distribution.
This downside case is not a worst case or a probability estimate. It is a set of assumptions chosen to show how several pressures can work together. A more severe event could produce a worse result, including no distributions and a loss of capital.
Ask for cases relevant to the property. A large commercial lease expiration needs a different test from a gradual increase in apartment turnover.
Annual totals can hide a shortage within the year. Taxes, insurance, repairs, and lease-up costs may fall in different months from rent receipts. A forecast can be positive for the year and still need cash at a particular point.
Ask for a monthly cash schedule during periods of change. This is especially useful around acquisition, major repairs, lease expirations, and the start of loan amortization.
Use the actual payment dates where known. Do not spread a large expense evenly across twelve months just to make the line smoother if the bill must be paid at once.
Then connect the low point in cash to available reserves and permitted transfers. A healthy year-end balance does not help if the trust lacks access to funds when the bill is due.
For an investor, also distinguish the property calendar from your distribution calendar. A payment received in one month may reflect earlier operations, a scheduled reserve release, or another source explained by the documents.
For each important input, record whether it comes from a signed contract, current actual result, outside estimate, or sponsor judgment. Add its date and the person responsible for updating it.
A rent growth assumption from an old market report may no longer match current leasing. An insurance quote may expire. A property condition estimate may exclude work discovered later. The model should have a process for incorporating those changes.
Ask which assumptions drive most of the forecast. It is possible to spend hours debating a small expense while overlooking a large expected rent increase or a major lease renewal.
FINRA's private-placement guidance addresses investigating claims and the information supporting them. A third-party model or report does not eliminate the need to understand its scope and unresolved issues. [3]
Keep a change log when the forecast is revised. State what changed, why, and how it affected projected cash. Replacing one spreadsheet with another without explanation makes it harder to learn from the differences.
A forecast becomes more useful when it provides a baseline for later reporting. Compare actual income, expenses, debt payments, and reserves with the original plan and any revised plan.
Separate timing differences from lasting changes. A bill paid one month later can move cash between periods without changing the annual cost. A permanently higher insurance premium changes the ongoing economics.
Ask management to explain meaningful variances in dollars. A percentage can look dramatic on a small line or modest on a large one. Both the amount and the reason matter.
Do not judge only the distribution. A steady payment can coexist with lower operating cash if reserves make up the gap. Conversely, retaining more cash for a documented need may reduce payments without indicating that rent has fallen.
The SEC warns that private placements can involve limited information and illiquidity. Before investing, understand what reports you will receive and what questions you can ask. A forecast is easier to monitor when the reporting uses clear, consistent definitions. [4]
A forecast helps you see the sponsor's plan, identify dependencies, and test alternatives. It should make uncertainty easier to discuss. It should not turn a range of possible outcomes into an apparent promise.
Compare several sensible cases with your own cash needs. If essential expenses depend on receiving the base-case payment without interruption, discuss that mismatch with your adviser before committing the capital.
Keep exit value out of the current-income calculation. A future sale may add to or subtract from the overall result, but it cannot pay today's bill unless cash actually reaches you.
End your review with the assumptions that matter most, the evidence behind them, and the consequences if they miss. That is a stronger basis for a decision than accepting a distribution rate because the spreadsheet displays two decimal places.
Check the units before relying on any result. A rent line may be monthly while an expense line is annual, and a table may show amounts in thousands. A percentage can refer to total equity or only one class. These small reading errors can create a large apparent difference. Write the unit beside each input, then make sure the final cash total agrees with the investor schedule.
No. They depend on assumptions about rent, occupancy, expenses, debt, reserves, and other terms. Actual results can differ, and payments can be reduced or stopped. Read the forecast as a plan to test rather than a promise of a particular amount reaching your account.
New tenants may receive concessions, pay lower effective rent, or create turnover and leasing costs. Operating expenses and debt payments may also rise. Physical occupancy alone does not measure collected income or the amount left for investors. Compare the rent roll, receipts, and full cash schedule.
No. Debt service, trust-level costs, capital needs, and retained reserves may reduce the amount available to owners. Read the NOI definition to avoid counting a cost twice or omitting it. Ask for a clear bridge from property income to the proposed investor payment.
No. Debt coverage compares a defined income amount with debt service. Other cash needs remain, and loan definitions can vary. The property may cover its loan while leaving less for owners. Review trust costs, reserves, capital spending, and any restrictions on distributions as well.
Not automatically. Each line has different drivers and timing. Rent may be fixed by leases while insurance or repair costs change sooner. Ask for evidence supporting the major inputs. A convenient uniform percentage is not a substitute for understanding how each part of the property works.
Yes, the amount arriving in your account may look the same regardless of its source. Ask whether operations, reserves, or another permitted source funded it. A reserve release does not create new operating income and leaves less cash for future uses. Review the remaining balance and restrictions.
There is no fixed number that makes a model reliable. Begin with the base case and a few changes that matter most for the property. Combine related pressures where appropriate. Explain the assumptions rather than assigning unsupported probabilities or treating one downside case as the worst possible outcome.
Compare actual results with the original and revised plans. Ask about meaningful differences and whether they are temporary or ongoing. Track the sources of distributions and reserve movements, not just the payment amount. A clear comparison can reveal changes that a steady distribution alone would miss.
Educational information, not an offer or a personal tax, legal, or investment recommendation. Examples are hypothetical and omit stated adjustments. Tax treatment depends on your facts and current law. Review your transaction with your CPA, attorney, and qualified intermediary. Real estate investments can lose value and may be illiquid.
Enter your approved email to explore investments, save your shortlist, and keep learning.