How to Generate a Schedule of Real Estate Owned (SREO) for Your Lender in 2026

If you're a commercial real-estate investor with more than two or three properties, you've already had the email: your bank's underwriter politely asks for "an updated SREO with rent roll, NOI, debt service, and DSCR — by end of week." You panic-search "SREO template Excel," download something from 2017, spend nine hours rebuilding it for your current portfolio, and ship a PDF that looks like it was made in 2003.

In this guide we'll show you exactly what an SREO is, what every lender actually expects to see, how to build one from scratch, common mistakes that get refis denied, and — yes — how to generate the whole thing in one click instead.

What is a Schedule of Real Estate Owned (SREO)?

A Schedule of Real Estate Owned is a one-page-per-investor document that lists every income-producing property an investor owns or has an ownership stake in. Banks use it during commercial loan underwriting to:

1. Verify the borrower's net worth claims on their PFS
2. Calculate global DSCR (debt service coverage ratio across all properties, not just the subject)
3. Identify cross-collateralized or guaranteed loans that could affect the subject property's risk
4. Confirm the borrower's experience operating real estate at this scale

Even if you're only refinancing one property, a complete SREO is now standard documentation across virtually every commercial lender — credit unions, regional banks, life-insurance companies, and most agency lenders (Fannie/Freddie multifamily).

What lenders actually want on an SREO (the real checklist)

Most templates online include the basics — address, type, units — but miss what underwriters actually use. After working with hundreds of investors who refi or acquire each year, here's the full list of columns banks care about:

Property identification

• Property address (full street, city, state, zip)
• Property type (multifamily, office, retail, industrial, mixed-use, land)
• Number of units / SF (gross leasable area for commercial)
• Year built / year acquired
• % ownership (sole, JV at 50%, etc. — lenders normalize to your ownership share)

Financials

• Acquisition price + acquisition date
• Current market value (most lenders accept your estimate; some require a recent appraisal)
• Annual gross rental income (GPI — before vacancy)
• Annual operating expenses (taxes, insurance, utilities, repairs, management — NOT debt service)
• Net Operating Income (NOI) = GPI − vacancy − OpEx
• Annual debt service (total P&I across all loans on the property)
• DSCR = NOI ÷ debt service (lenders want ≥1.20 for stabilized property, ≥1.30 for new acquisitions)

Loan details

• Lender name (helps the new bank verify and avoid relationships)
• Original loan amount + current balance
• Interest rate (and whether fixed or floating)
• Maturity date (lenders flag loans maturing within 12 months as refi risk)
• Monthly payment
• Recourse vs. non-recourse
• Personal guarantee (yes/no — affects your contingent liability)

Coverage check

• LTV (loan balance ÷ current value) — anything over 75% is a yellow flag
• Cap rate (NOI ÷ current value) — sanity-checks your market value claim
• Cash-on-cash return (annual cash flow ÷ down payment) — bonus credibility column

How to build an SREO in Excel (the manual way)

If you have one or two properties, a basic Excel template works. Here's the structure:

| Address | Type | Units | Acq Price | Market Value | NOI | Debt Svc | DSCR | LTV |

The work begins when you have to populate it. For each property:

1. Pull last 12 months of bank statements and categorize every transaction into rental income vs. each OpEx category
2. Look up your current loan balances (call each servicer or pull the amortization schedule)
3. Estimate current market value — get a recent BPO, use cap-rate math, or accept your last appraisal
4. Calculate DSCR and LTV — double-check the formulas
5. Format the PDF so it doesn't look like a 1998 Excel printout
6. Add your contact info, signature, and a date stamp

Realistically, this takes 8–16 hours for a 5-property portfolio. If you're refinancing once every two years, that's tolerable. If you're an active investor closing 2–4 transactions a year, it's brutal.

The most common mistakes that get refis denied

After watching dozens of refis stall at the SREO stage, here are the patterns underwriters flag instantly:

1. Inconsistent NOI between SREO and tax returns

Lenders cross-check your SREO NOI against your Schedule E. If your SREO shows $145,000 NOI on a property but your Schedule E shows $89,000, the underwriter will assume you're inflating NOI for the bank. Fix it by using the same expense definition on both — most investors over-state expenses on Schedule E for tax purposes and then forget to reconcile when prepping the SREO.

2. Missing or stale market values

"Last appraised $1.2M in 2019" is not a market value in 2026. Either get a fresh BPO ($150-300 from a broker) or back-calculate from current cap rates: NOI ÷ (market cap rate) = value. Pick one consistent methodology across your whole portfolio.

3. Forgetting cross-collateralized loans

If a single loan is secured by multiple properties (common with portfolio lines), it must appear under each property with the appropriate allocated balance. Banks discover this during title and ask why your SREO is "missing" debt.

4. Pre-fill error on the global DSCR

Global DSCR = Total portfolio NOI ÷ Total portfolio debt service. Many investors compute it as the average DSCR weighted by property — which gives a wildly different number. Banks use the simple ratio. So should you.

5. The "I'll just send the rent roll separately" trap

Modern lenders want the SREO with nested per-property rent roll attached. Sending them as separate documents triples back-and-forth. Combined into one PDF, your file ranks as "fully documented" — which underwriters love.

The one-click SREO alternative

This is the part where we have to be honest about the product. RealtyVault Manager generates a fully-formatted, lender-ready SREO in under 5 seconds:

• Live NOI — pulled from your actual rent payments and categorized expenses (no spreadsheet reconciliation)
• Current market value — auto-computed via the income approach using your current NOI ÷ the cap-rate benchmark for your asset type and metro
• DSCR — calculated against your live loan amortization (we pull the current balance from your loan record, not last quarter's)
• Tax + insurance coverage check — a colored shield icon (green/amber/red) per property if your stored annual taxes/insurance budget is keeping pace with actual payments
• Nested rent roll per property — units, current tenant, monthly rent, security deposit, lease end date, arrears
• One-click email to your lender contact list — your saved bankers receive the PDF + a password-gated share link with view tracking

If your portfolio is the kind that has to refi every 5–7 years, automating the SREO pays for the platform on the first refi cycle alone.

What to do next

1. Audit your existing portfolio docs. Do you have current NOI for every property? Current loan balance? Estimated market value < 12 months old? If not, you have homework before any lender will pre-qualify you.
2. Pick your stack. Excel works for ≤3 properties. Above that, the ROI of automated tools shows up immediately.
3. Build your lender list. Track which banks you've worked with, what their LTV/DSCR appetite is, and who their commercial team is. When you need to refi, you want to send to 3–4 banks in parallel, not start cold.

The investors who refi fastest are the ones whose SREO is always current — not the ones who scramble to update it when the rate environment changes. Build the muscle now.

---

Need a one-click SREO? Start a free RealtyVault trial — no credit card required.