Sponsor experience and owned real estate: a schedule of roles and obligations

A sponsor schedule should describe what the sponsor owns, what the sponsor actually did and what obligations can compete for future cash. A list of large property values cannot answer all three questions. Separate property-level totals from ownership allocations, and keep guaranty exposure distinct from economic ownership.

The OCC’s borrower and guarantor discussion considers liquidity, cash flow and actual or contingent obligations. This original template organizes supporting information for that analysis. It is not a prescribed lender form and does not establish a universal experience, net-worth or liquidity threshold.

Identify the property and the role

Assign one stable property identifier to each asset. Name the legal owner and the sponsor’s actual role: acquisition lead, developer, asset manager, passive investor or another supported responsibility. A sponsor who invested in a project should not automatically claim the operating partner’s development experience.

Describe the relevant period and evidence in the experience note or a linked detailed schedule. A completed disposition, a successful lease-up and a current ownership position are different facts. Identify whether a result is realized, still in progress or based on an estimate.

For multiple loans or complicated ownership, use the companion debt and ownership schedules. The summary row should point to those records rather than compress a complex structure into a misleading single number.

Blank schedule

property_id,legal_owner,sponsor_role,ownership_percent,gross_value_usd,gross_debt_usd,attributable_equity_usd,debt_maturity,support_obligation,evidence_ref,experience_note
P001,,,,,,,,,,

Enter whole percentages in ownership_percent: 40 means 40%. Values and debt are whole USD. The XLSX version calculates the arithmetic attributable equity when all three required numeric inputs are present. The CSV version includes the same output as a value in the completed example; recalculate it when editing that file.

Completed hypothetical schedule

property_id,legal_owner,sponsor_role,ownership_percent,gross_value_usd,gross_debt_usd,attributable_equity_usd,debt_maturity,support_obligation,evidence_ref,experience_note
P001,Example Industrial Partners LLC,Acquisition lead; asset manager,40,6000000,3900000,840000,2028-06-30,Guaranty scope requires separate document review,VALUE-1;DEBT-1;OA-1,Managed leasing from acquisition; no development role claimed
P002,Example Retail LLC,Sole owner; third-party manager,100,4200000,3000000,1200000,2027-09-30,Repayment guaranty identified; amount and release terms separately scheduled,VALUE-2;DEBT-2;OA-2,Acquired stabilized; operating results supported by statements

For P001, gross equity is $6 million minus $3.9 million, or $2.1 million. Applying the 40% economic interest produces $840,000 of attributable equity. For P002, $4.2 million minus $3 million at 100% ownership produces $1.2 million. The arithmetic total is $2.04 million before any transaction costs, taxes, priority distributions or other adjustments.

That total is not an amount the sponsor can necessarily withdraw. The properties have debt, ownership arrangements and possible restrictions. An equity estimate does not become verified unrestricted cash merely because the arithmetic is correct.

Field instructions and evidence

Keep the value and debt dates aligned. If they cannot be aligned, identify the mismatch instead of presenting the difference as a contemporaneous equity estimate. Distinguish a current appraisal, an older report and an owner estimate.

Do not prorate every obligation

The sponsor’s 40% interest in P001 does not establish that a guaranty is limited to 40% of the debt. The actual instrument may contain different amounts, triggers, limitations and release provisions. Put the guaranty in a separate obligation schedule and obtain the appropriate document interpretation.

Likewise, a property’s cash deficit may require an equity contribution under an operating agreement that differs from its ownership percentage. Record the source of the obligation and whether it is funded, contingent or disputed. The sponsor schedule should make such questions visible before anyone relies on a net-worth total.

Common errors that distort the picture

Do not enter a 40% share of value in gross_value_usd and then apply 40% again in the equity formula. Do not subtract only the sponsor’s share of debt from the full property value. Both mistakes mix levels of ownership and produce an unreliable result.

Avoid counting the same property through both a holding-company row and a subsidiary row in an aggregate total. Use the ownership map to identify the reporting perimeter. A property can appear in a detailed chain without being counted twice in the sponsor’s economic exposure.

Do not omit a troubled property because it is outside the subject transaction. Its cash needs or guarantees may affect the sponsor’s ability to support a new loan. Keep performance descriptions factual and supported rather than presenting every investment as a completed success.

Review before delivery

Reconcile the schedule to the existing-debt and liquidity records. Check maturity concentrations, open capital commitments and any property whose value evidence is stale. Confirm that the stated roles match the experience documents and that no outcome is attributed to the sponsor without support.

Deliver the schedule with its measurement date and evidence index. When an asset is sold, refinanced or transferred, preserve the prior version and update the affected obligations. A useful experience record remains traceable as the portfolio changes.