Apply now on NEXA Mortgage's site, opens in a new tab

Schedule of real estate owned template

A schedule of real estate owned (SREO) is one page that lists every property you own, with its value, loan, payment, and rent. Download our free Excel template, replace the example rows with your own, and it works out equity, LTV, and portfolio DSCR for you.

Free, no sign-up. One Excel sheet. File dated September 28, 2026.

When lenders ask for one

  • On almost every investor loan. Most lenders ask for a schedule of real estate owned on every investor loan, together with your ID, entity documents, the contract or payoff statement, proof of funds, and an insurance quote. It is the last item on the first list of our investor loan document checklist.
  • Again on commercial loans. For five-plus unit multifamily, mixed use, and other income-producing property, the checklist lists it next to the T-12, the rent roll, and a personal financial statement for each guarantor.
  • Why it matters. It puts your whole portfolio on one page, with portfolio LTV and DSCR, so every loan you carry and every rent you collect sits in one place.

What is in the file

The file has one sheet, named REO schedule. At the head you enter the borrower or guarantor name and an as-of date. Below that is a 15-column table with room for 30 properties, then a totals row, a portfolio summary, and short notes.

Shaded cells are for your entries. The last three columns are formulas and fill in on their own. The header row stays in view as you scroll, and it repeats on every printed page.

Column by column

Column by column
ColumnHeader in the fileWhat to enter
AProperty addressThe full street address. List every property you own, including your primary residence.
BProperty typePlain words, like the file's examples: Single family, Duplex, Multifamily, 8 units, Retail strip.
COwnership entityThe LLC or other entity that holds title, or "Borrower, individually" if it is in your own name.
DPercent owned100 percent, or your share if you own part of it. The example 8-unit building is 50 percent.
EDate acquiredThe date you bought it.
FPurchase priceWhat you paid.
GCurrent market valueThe value as of the date at the head of the sheet.
HLenderWho holds the loan.
ILoan balanceWhat you owe on it today.
JMonthly payment (PITIA)Principal, interest, taxes, insurance, and association dues, all in one number.
KMonthly gross rentRent before any expenses.
LOther monthly expensesCosts that are not in PITIA, such as management, repairs, and utilities you pay.
MMonthly net cash flowFormula. Gross rent minus PITIA minus other monthly expenses.
NEquityFormula. Current market value minus loan balance.
OLTVFormula. Loan balance divided by current market value.

The portfolio summary

Under the table, the file adds everything up. The totals, portfolio LTV, and portfolio DSCR count 100 percent of each property. The "your share" lines weight each property by your percent owned.

The summary shows these lines, in this order:

  • Number of properties
  • Total current market value
  • Total loan balance
  • Portfolio LTV (loan balance / market value)
  • Total monthly PITIA
  • Total monthly gross rent
  • Total other monthly expenses
  • Total monthly net cash flow
  • Portfolio DSCR (total rent / total PITIA)
  • Total equity
  • Your share of market value (by percent owned)
  • Your share of loan balances
  • Your share of equity
  • Your share of monthly net cash flow
  • Rows missing percent owned

What the example shows

With the file's five example properties, total market value is $3,315,000 against $1,980,400 of loans. That is a portfolio LTV of about 59.7 percent, and portfolio DSCR comes to about 1.45. Because the example 8-unit building is half owned, your share of market value is $2,652,500, not the full $3,315,000. These are the file's made-up examples, not real properties or loan terms.

Portfolio DSCR here is total rent divided by total PITIA. That is the same rent-over-payment math our DSCR calculator uses for a single property.

Mistakes the file's own notes help you avoid

  • Leaving off your home. The instructions say to list every property you own, including your primary residence.
  • Putting expenses in the payment column. PITIA is principal, interest, taxes, insurance, and association dues. Management, repairs, and utilities you pay go in Other monthly expenses.
  • Skipping Percent owned. The "your share" lines depend on it. A check line, Rows missing percent owned, counts any row you left blank.
  • Carrying the wrong totals. Your personal financial statement takes the "your share" lines, not the 100 percent totals.

How it feeds your personal financial statement

Our personal financial statement template takes three figures straight from this schedule: the market value of your real estate, the mortgages on it, and your net rental income. Its notes say those lines should agree with the "your share" lines here, with income figured as monthly net cash flow times 12.

The two example files already agree: $2,652,500 of real estate, $1,549,150 of mortgages, and $3,540 a month of net cash flow, which is $42,480 a year.

Preview: the columns in the file

Columns in the file, with the example rows
Property addressProperty typeOwnership entityPercent ownedDate acquiredPurchase priceCurrent market valueLenderLoan balanceMonthly payment (PITIA)Monthly gross rentOther monthly expensesMonthly net cash flowEquityLTV
101 Example Ave, Tampa, FL 33609Single familyExample Holdings LLC100%06/14/2019$245,000$385,000Example Bank$178,500$1,685$2,450$245$520$206,50046.4%
202 Sample St, St. Petersburg, FL 33704DuplexExample Holdings LLC100%03/02/2021$410,000$525,000Example Credit Union$312,000$2,840$3,700$370$490$213,00059.4%
303 Demo Blvd, Brandon, FL 33511Single familyBorrower, individually100%09/20/2016$189,000$340,000Example Mortgage Co.$121,400$1,210$2,300$230$860$218,60035.7%
404 Model Rd, Clearwater, FL 33755Multifamily, 8 unitsExample Partners LLC50%11/10/2022$1,150,000$1,325,000Example Commercial Lender$862,500$7,450$11,200$2,240$1,510$462,50065.1%
505 Test Ln, Tampa, FL 33603Retail stripExample Holdings LLC100%05/05/2023$675,000$740,000Example Bank$506,000$4,620$6,150$615$915$234,00068.4%
Totals: 5 properties$2,669,000$3,315,000$1,980,400$17,805$25,800$3,700$4,295$1,334,60059.7%

Scroll the table sideways to see every column.

Example rows from the file. Replace them with your own.

Sending it

The file's last line asks you to send the completed file to info@aluracapital.com with your loan request. Please do not paste it into the scenario form on our homepage. That form is for a short description of the deal.

A finished schedule lists your property addresses and loan balances. If you would rather not email it, call or text (813) 356-9448 and ask how to send it.

Ready to talk about the loan?

When your schedule is done, run your scenario by us. A licensed loan officer calls you back the same business day.

The application opens on NEXA Mortgage's site, the licensed mortgage company our loans run through.

Related templates

Frequently asked questions

What is a schedule of real estate owned?

A schedule of real estate owned is a list of every property you own, one row each, with its value, loan balance, monthly payment, and rent. Most lenders ask for one on every investor loan. Ours is a free Excel file that also totals equity, portfolio LTV, and portfolio DSCR for you.

Should I include my primary residence?

Yes. The file's instructions say to list every property you own, one per row, including your primary residence. If the home earns no rent, enter zero rent. Its payment then shows as negative cash flow, and the totals and portfolio DSCR include it, because the totals count 100 percent of each property.

What goes in the monthly payment column?

The full monthly payment, written as PITIA: principal, interest, property taxes, insurance, and association dues. Costs that are not part of PITIA, such as management, repairs, and utilities you pay, go in the next column, Other monthly expenses. The file subtracts both from gross rent to get monthly net cash flow.

How does the template figure portfolio LTV and DSCR?

Portfolio LTV is your total loan balance divided by total current market value. Portfolio DSCR is total monthly gross rent divided by total monthly PITIA. Both count 100 percent of each property, even one you own only part of. With the file's five example rows, they come to about 59.7 percent and 1.45.

What if I own only part of a property?

Enter your share in Percent owned, for example 50 percent. The totals still count the whole property, but the "your share" lines weight each one by percent owned. Carry those share figures to your personal financial statement. A check line at the bottom counts any row where percent owned is missing.

Is the template free, and is it a loan application?

It is free, with no sign-up, and it is not an application. It is a planning file that lenders commonly ask for alongside one. When you are ready to apply, the application opens on NEXA Mortgage's site, the licensed mortgage company our loans run through.