Schedule of Real Estate Owned (SREO) Template + Example

A schedule of real estate owned (SREO) is a list of every property you own, with each one’s value, debt, income, and how you hold title. Lenders ask for it so they can underwrite you as an investor, not just the deal you want financed. If you own more than one property, you’ll need one sooner or later.

The first time a banker asked me for my REO schedule, I had no idea what she meant. I built one from memory the night before it was due, and it showed.

Below you’ll find the template I wish I’d had, a filled-in example, and what an underwriter looks for in each column.

Free Schedule of Real Estate Owned Template (Excel Download)

Our free schedule of real estate owned template is an Excel file. I chose Excel over a PDF form for one reason: your SREO changes every time you buy, sell, or refinance, and a spreadsheet does the math for you.

The workbook has four tabs:

• Instructions: a short guide to every column.
• SREO: a blank schedule for up to 20 properties, with totals and a signature block.
• Sold Properties: a track record tab for private and hard money lenders.
• Example: a filled-in four-property portfolio with underwriter notes.

You fill in the yellow cells. The gray cells calculate NOI, debt service, DSCR, LTV, equity, and cash flow on their own. If a lender wants a PDF, save the SREO tab as a PDF and it prints on one landscape page.

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

A schedule of real estate owned is a signed summary of your real estate holdings that you give a lender during underwriting. Lenders and investors also call it an SREO, an REO schedule, or a real estate schedule. All three names mean the same document.

It answers three questions a lender cares about. What do you own? What do you owe on it? Does the income cover the debt?

No single industry form exists. Most banks and private lenders hand you their own version or accept yours.

Fannie Mae is the exception on the multifamily side. Since August 29, 2025, its lenders must collect Form 4526 with every financial statement submission on Fannie Mae multifamily loans (Fannie Mae, 2025). Fannie Mae defines the SREO as a certified document that lists all of a person’s real estate equity interests (Fannie Mae, 2026).

That definition covers more than people expect. “Equity interests” means the rental in your own name, your share of a partnership, and the lot your uncle left you that you forgot about.

SREO vs. REO: What Does “Real Estate Owned” Mean Here?

On an SREO, “real estate owned” means property you own. Most investors learn the term REO from the other side of the business, where it means a home a bank took back after a failed foreclosure auction. If you’ve ever chased foreclosure properties, you know that version of REO.

Same words, opposite owner. A lender who asks for your REO schedule wants your portfolio, not a bank’s.

What Goes on a Schedule of Real Estate Owned?

A schedule of real estate owned lists, for each property, the address, how you hold title, your ownership percentage, what you paid, what it’s worth today, every loan against it, and what it earns. The template groups these into property, acquisition, value, debt, and income columns, then calculates the rest.

Fannie Mae’s multifamily guide gives a good baseline. It tells lenders to collect the lender name, address, fixed or variable rate, DSCR, loan-to-value ratio, acquisition year and price, current market value, ownership percentage, and maturity date for every property (Fannie Mae, 2026). Most bank forms ask for some version of the same list.

Here’s what goes in each column and what the person reading it checks.

A few columns trip people up.

Title held by needs the exact legal name on the deed. If you own through a real estate LLC, write out the full name with “LLC” at the end. The underwriter matches it to your entity documents.

Acquisition price should come straight from your purchase agreement or closing statement. I’ve misremembered prices by $10,000 on deals I closed myself.

Income and expenses should be annual numbers you can back up. Pull them from the income statement for each property, and leave mortgage payments out of expenses.

The spreadsheet subtracts expenses from income to get net operating income (NOI), which is the money a property earns after operating costs and before loan payments. DSCR (debt service coverage ratio) is NOI divided by annual loan payments. A DSCR of 1.25x means the property earns $1.25 for every $1.00 it owes the bank. LTV (loan-to-value) is your loan balance divided by the property’s value.

How to Fill Out a Schedule of Real Estate Owned

To fill out a schedule of real estate owned, gather your loan statements and income records, then enter one row per property, starting with the property you want financed. Plan on an hour or two the first time. Updates after that take minutes.

1. Gather your documents. Pull this month’s mortgage statements, your leases or rent roll, 12 months of expenses, any LLC operating agreements, and your latest appraisal or broker opinion for each property.
2. List the subject property first. The residential loan application tells borrowers to list the property they’re refinancing first (Fannie Mae and Freddie Mac, 2021), and most commercial lenders expect the same order.
3. Add every ownership interest. Include property in your own name, in every LLC or partnership, and any property where you personally guarantee the loan.
4. Enter current loan balances. Use this month’s statement, not last year’s.
5. Source every value. Pick the source from the dropdown and enter its date.
6. Check the totals row. Look at portfolio LTV and DSCR before the lender does. If a number surprises you, fix it or get ready to explain it.
7. Sign and date it. Most lenders want a signed copy, and the template includes a certification block.

Schedule of Real Estate Owned Example

Here’s a schedule of real estate owned example for a small investor with four properties in central Ohio. This investor wants to refinance a mixed-use building with a credit union, so that building goes on row 1. The template’s Example tab has the full version with every column filled in.

The totals row tells the lender the most:

That 1.17x looks thin. It isn’t, once you read the rows.

The rehab carries a $1,073 interest-only payment and collects no rent yet, so it drags the whole portfolio down. Take it out and the three rentals cover their debt at 1.66x. A good underwriter does that math anyway, but I put it in my cover note so nobody has to guess.

Look at the duplex too. The investor owns half, so the spreadsheet counts half the equity. The loan still carries a full personal guaranty, so it stays on the schedule. I learned that one the hard way.

The Duplex I Left Off My Own Schedule

A few years back I refinanced a single-family rental with a local bank, and I threw my SREO together the night before from memory. I listed three properties. The underwriter came back two days later and asked about a fourth.

It was a duplex my brother-in-law and I bought through a 50/50 LLC. He found it, he manages it, he deals with the tenants. In my head it was his deal.

But the bank on that duplex made us both sign personal guarantees, so the mortgage showed up on my credit report. The underwriter saw a mortgage of roughly $140,000 that wasn’t on my schedule and stopped everything until I explained it.

I had to send the operating agreement, a year of the duplex’s bank statements, and a letter explaining the ownership split. Closing slipped about three weeks, and the rate lock extension cost me $1,100.

Now I check two things before any schedule leaves my desk. Every property with my name on the deed, the entity, or the debt goes on it, with my real ownership percentage. Then I pull my own credit report and match every mortgage on it to a line on the schedule.

If an underwriter can find it, they will.

When Do You Need a Schedule of Real Estate Owned?

You need a schedule of real estate owned whenever a lender underwrites you as an investor. That includes refinancing a rental, applying for a DSCR loan, getting a commercial or multifamily loan, opening a portfolio line of credit, or borrowing from a private lender. Joint venture partners ask for one too.

It can come up before financing even starts. On commercial deals, some sellers want proof of your track record right after you submit a letter of intent. Private lenders often want the schedule in the same package as your investment proposal.

Investor home purchases fell 6% year over year in the first quarter of 2026, to their lowest level since 2020 (Redfin, 2026). In my experience, lenders dig deeper when fewer deals make sense on paper. I’d rather hand them a clean schedule on day one than answer questions in week three.

How Do Lenders Use an SREO?

Lenders use an SREO to see your whole financial picture: whether your other properties cover their own debt, how much you personally guarantee, and which loans come due soon. A lender can turn down a great property if the rest of your portfolio loses money.

Fannie Mae spells out what its multifamily lenders have to analyze on the schedule. The list covers every property including non-multifamily ones, underperforming properties and the borrower’s plan for them, upcoming maturities, and recourse debt (Fannie Mae, 2026). Bank underwriters look at the same things, even when their guidelines don’t say so.

Private and hard money lenders read it differently. They care most about experience, so they want to know how many deals you’ve done and how those deals went. The Sold Properties tab in the template covers that.

SREO for Commercial and Multifamily Loans

On Fannie Mae multifamily loans, the lender must collect Form 4526 from the sponsor, the key principal, and any guarantor (Fannie Mae, 2025). You’ll fill out their form, but every number on it comes from a schedule like this one. Keep yours current and copy the numbers over.

SREO on a Residential Mortgage Application

On a residential loan, the SREO lives inside the application. Section 3 of the Uniform Residential Loan Application asks you to list all the properties you currently own (Fannie Mae and Freddie Mac, 2021). Lenders still use this version of the form, which became the standard in 2021.

The count matters too. Fannie Mae caps borrowers who finance a second home or investment property at 10 financed properties. It counts properties, not mortgages, so a two-unit building counts as one (Fannie Mae Selling Guide, 2025).

What Happens When One Property Drags Down Your Numbers?

One weak property hurts every loan you apply for. You end up explaining the same building to every underwriter, and it pulls down your portfolio DSCR each time.

At some point, selling it beats defending it. That’s the same math that turns long-time owners into tired landlords, and I’d run it before a lender runs it for you.

How Often Should You Update Your SREO?

Update your SREO after every purchase, sale, or refinance, and do a full refresh before any loan application. Loan balances drop every month and values move, so a six-month-old schedule has the wrong numbers on it.

I keep one master file with the date in the file name. When a lender asks, I update balances from the latest statements, check values, and send it the same day.

Common SREO Mistakes That Slow Down Underwriting

The mistakes that slow down underwriting are values with no source, old loan balances, missing properties, and missing totals. Underwriters rarely decline you over these. They stop and send questions, and each round of questions can cost you a week.

• Inflated values. If you write $300,000 and the appraisal comes in at $255,000, the underwriter starts doubting every other number on the page.
• Stale balances. Lenders compare your balances to your credit report and payoff letters. Last year’s statement won’t match.
• Missing partial interests. The 50/50 LLC or the property you co-signed for belongs on the schedule. You read what that cost me.
• Unlabeled ownership. Mixing personal and entity holdings without saying who holds title on each row creates questions you don’t need.
• Hiding the problem property. Explain the vacant unit or the rehab with no rent up front. Underwriters find it on title searches and credit reports anyway.
• No totals. Without totals, the underwriter builds their own math. Hand them yours.

The fix for most of these is boring. Pull fresh statements and write down where every number came from.

Final Thoughts

A clean schedule of real estate owned won’t close a loan by itself, but a messy one can delay it for weeks. Fill out the template once, keep it current, and you’ll send it in five minutes the next time a lender asks.

Once you’re financeable, the hard part is finding the next property worth adding to the schedule. Most of my best deals started as off-market leads from sellers who needed to move fast. You can browse verified motivated seller leads in your market on the UndervaluedX exchange.

References

1. Fannie Mae, 2026. Multifamily Selling and Servicing Guide, Section 306: Schedule of Real Estate Owned (SREO) (Form 4526).
2. Fannie Mae, 2025. Guide Update 25-16: Schedule of Real Estate Owned (SREO).
3. Fannie Mae Selling Guide, 2025. B2-2-03, Multiple Financed Properties for the Same Borrower.
4. Fannie Mae and Freddie Mac, 2021. Uniform Residential Loan Application (Fannie Mae Form 1003, Freddie Mac Form 65).
5. Redfin, 2026. Redfin Reports Investor Home Purchases Fall to Lowest Level Since 2020.