Schedule of Real Estate Owned (SREO)
A schedule of real estate owned (SREO) is a sponsor’s list of every property it owns or holds an interest in, showing for each one the ownership share, value, debt, income, debt service and lender.
What are the SREO formulas?
Sponsor share of any line = property figure x ownership percentage
Portfolio loan to value = total sponsor share of debt / total sponsor share of value
Portfolio coverage = total sponsor share of NOI / total sponsor share of debt service
- Property figure: a property's value, debt, NOI or annual debt service at 100 percent.
- Ownership percentage: the sponsor's interest in the property.
- Debt service: twelve months of scheduled principal and interest on each property's loan.
A complete SREO also shows loan maturities, recourse and guaranties, and occupancy. Many lenders total it both at the sponsor's share and at 100 percent, because a guaranty on a partly owned property can cover the whole loan.
What does the sample sponsor's SREO show?
Illustrative figures. The sponsor of the 96-unit community refinanced with a $9.0 million loan owns three properties.
| Property | Share | Value | Debt | NOI | Debt service | DSCR |
|---|---|---|---|---|---|---|
| Subject, 96 units (this lender, after the refinance) | 100% | $12,500,000 | $9,000,000 | $871,000 | $665,000 | 1.31x |
| Property B, 40 units (this lender) | 100% | $5,000,000 | $3,600,000 | $352,000 | $278,338.20 | 1.26x |
| Property C, retail center (another lender) | 50% | $3,000,000 | $1,800,000 | $228,000 | $145,844.76 | 1.56x |
At the sponsor's share, Property C counts as $1,500,000 of value, $900,000 of debt, $114,000 of NOI and $72,922.38 of debt service.
- Value: $12,500,000 + $5,000,000 + $1,500,000 = $19,000,000
- Debt: $9,000,000 + $3,600,000 + $900,000 = $13,500,000, which is 71.1 percent of value
- NOI: $871,000 + $352,000 + $114,000 = $1,337,000
- Debt service: $665,000 + $278,338.20 + $72,922.38 = $1,016,260.58, so coverage is 1.32x
The lender's own exposure to this sponsor is $9.0 million plus $3.6 million, or $12.6 million. Property B covers its debt at 1.26x, thinner than the subject, so a weak year there draws on the same sponsor.
How do lenders use the SREO?
The SREO shows what else depends on the sponsor's cash and attention. It feeds global cash flow, contingent liabilities and liquidity analysis, and it reveals maturities that cluster, properties that do not cover their own debt, and guaranties the personal financial statement may omit. On the sample deal it supports the relationship view behind the sample memo's 1.29x global coverage.
Typical policy treatment (illustrative): the sample lender reconciles the SREO to the personal financial statement and tax returns, totals its own exposure to the sponsor ($12.6 million here), and carries the sponsor's figures into global cash flow, which must meet a 1.20x minimum. The sample relationship is at 1.29x.
What are common SREO errors?
- Accepting sponsor-estimated values without checking them against appraisals, recent sales or market cap rates.
- Totaling at ownership share while ignoring that the sponsor guarantees 100 percent of a partly owned property's loan.
- Not reconciling the SREO to the personal financial statement and tax returns, which can reveal properties left off.
- Missing near-term maturities and floating-rate debt on other properties.
Where does the SREO appear in the credit memo?
The SREO sits in the sponsor and guarantor section, summarized with totals and flagged properties. Its figures feed global cash flow and contingent liabilities, and the relationship exposure section cites the lender's other loans to the sponsor.
Related terms
Sponsor analysis, recourse and non-recourse, carve-out guaranty, DSCR, maturity risk.
Where LenderBox does this work
Through global cash flow analysis, LenderBox brings the borrower, guarantors and related entities into one view, with each figure cited to the return or statement it came from, so the sponsor's other properties and their debt are counted before your team commits.