Portfolio Due Diligence

Schedule of Real Estate Owned (SREO) Guide: Preparation, Formatting & Metrics

A Schedule of Real Estate Owned (SREO) is a comprehensive spreadsheet detailing every commercial and investment real estate property owned or controlled by a loan sponsor. Commercial lenders use the SREO to evaluate the sponsor’s track record, total portfolio leverage, upcoming balloon debt maturities, and overall real estate operating performance.

Indicative Underwriting Matrix

Essential Fields 14 Core Portfolio Metrics Mandated Address, asset type, units/SF, ownership %, value, debt, NOI, and maturity
LTV Tracking Calculates Weighted Portfolio LTV Identifies whether the sponsor’s broader portfolio is dangerously over-leveraged
Debt Maturity Monitoring 12 to 36-Month Maturity Stagger Reveals upcoming balloon refinancing concentration risks
Ownership Structure GP, Managing Member vs. Passive LP Distinguishes operational control from minority passive equity investments
Cash Flow Reconciliation Portfolio Debt Service Coverage (DSCR) Calculates global portfolio net cash flow to verify solvency
Update Frequency Standard Quarterly or Semi-Annual Certified Updates Must be dated within 60 to 90 days of loan submission

All SREO figures must reconcile with corresponding property operating statements, note documents, and personal tax returns. Providing an unorganized or incomplete SREO is one of the most common causes of loan underwriting delays.

Anatomy of an Institutional Schedule of Real Estate Owned

An institutional commercial lender’s credit committee will not accept a vague summary of real estate holdings. To pass credit review, an SREO must be presented in a clean tabular format containing the following fields for each property:

  • Property Identification: Property name, physical address, city, state, zip code, and specific asset class (e.g., Multifamily, Industrial, Self-Storage, Office).
  • Scale & Ownership Share: Total unit count or rentable square footage, acquisition date, and the sponsor’s exact percentage of ownership equity and operational role.
  • Current Valuation & Cost Basis: Total original purchase/development cost, verified historical capital invested, and current estimated fair market value.
  • Existing Debt Metrics: Current outstanding mortgage balance, name of the lending institution, interest rate (fixed vs. floating), monthly debt service payment, and exact loan maturity date.
  • Operating Performance: Trailing-12 gross rental revenue, total operating expenses, net operating income (NOI), and property-level cash flow after debt service.
  • Contingent Debt Recourse: Explicit identification of whether the loan is full personal recourse, non-recourse with carveouts, or guaranteed by a third-party partner.

What Underwriters Look For on an SREO

Commercial credit analysts analyze the SREO for structural vulnerabilities across the sponsor’s balance sheet:

1. Balloon Maturity Clusters: If three major properties have commercial loans maturing within the next 12 months, the lender will examine whether the sponsor faces severe refinancing risk in the current interest rate environment.

2. Cash-Bleeding Assets: If certain properties on the SREO generate negative cash flow, underwriters determine how much personal cash the sponsor must inject monthly to keep those mortgages from default.

3. Track Record Alignment: Proves to the lender that the sponsor has successful direct experience operating properties of similar scale, tenant complexity, and asset class.

Direct Underwriting Intelligence

Frequently Answered Financing Questions

Verified answers to common borrower and broker inquiries regarding loan sizing, guidelines, and execution.

Tax Return Reconciliation

How do lenders cross-check an SREO against federal tax returns?

Lenders reconcile each property listed on the SREO against Schedule E (Supplemental Income and Loss) of Form 1040 and corresponding partnership K-1s from Form 1065.

Underwriters verify that reported net rental incomes and ownership percentages on the SREO align precisely with historical IRS tax filings.

Review SREO Requirements →
Sponsor Experience

Why is asset-specific experience on an SREO required for specialized commercial properties?

Specialized assets (such as hotels, marinas, cold storage, or car washes) carry operational business complexities that conventional lenders will not finance without proven operating history.

If a multifamily investor attempts to acquire an independent hotel, lenders mandate partnering with an experienced third-party management company or an experienced hospitality co-sponsor.

Speak to Capital Advisory Desk →

Related Debt Programs & Real Estate Financing