Schedule of Real Estate Owned, without the spreadsheet

What a Schedule of Real Estate Owned is

A Schedule of Real Estate Owned — an REO schedule — is a one-page table of every property you hold: what it is, what it is worth, what is owed on it, and what it earns and costs over a year. Underwriters ask for one whenever you apply for financing while already owning property, because your existing portfolio is both your track record and their risk. The residential loan application has a section shaped exactly like this, and commercial lenders ask for the same table as its own document, usually as a spreadsheet or PDF.

There is no single mandated format, which is why most people rebuild it by hand, under deadline, from mortgage statements and tax bills. The format above is the one this platform's paid schedule produces — the CSV you export here is generated by the same code, column for column.

Why lenders want it

Three questions decide most files, and the schedule answers all of them at a glance. Equity: market value against loan balance, per property and in total, tells the underwriter what you actually own. Leverage: the loan-to-value ratio those two columns imply shows how much room is left before the portfolio is over-extended. Carry: rental income against the mortgage payments, taxes, insurance and operating costs shows whether the portfolio pays for itself or leans on your salary — which decides how your existing obligations count against the new loan's debt-to-income arithmetic.

What each column means

• Market value — what the property would sell for today, not what you paid. Lenders will sanity-check it against their own comparables, so be the kind of accurate you can defend.
• Current loan balance — the payoff figure from your latest statement. With market value it produces LTV, the leverage number underwriters read first.
• Annual rental income — gross rents collected. Twelve times the monthly rent is the convention; use actuals if a unit sat empty.
• Annual PITI — principal, interest, taxes and insurance together: the full cost of keeping the loan and the building insured for a year.
• Operating expenses and CapEx — repairs, management, utilities you pay, HOA dues; capital work like roofs and HVAC belongs in its own column so a one-time project does not read as a permanent cost.
• Net cash flow — income minus everything above it. The column an underwriter runs a finger down.
• Cash-on-cash return — net cash flow against the cash you actually put in (down payment plus closing costs, or the whole price if you bought without a loan). It needs the purchase detail to mean anything, which is why those fields are optional but worth filling.

Residential and commercial entries differ

A residential row is described by its unit count — a single family house is one unit, a fourplex is four. A commercial row is described by its square footage and how much of it is earning: a 12,000-square-foot retail building at 92% occupancy is a different risk from the same building full, and a triple-net lease — where the tenant carries taxes, insurance and maintenance — changes what your expense columns should contain. The tool switches fields when you switch the type, and the PDF prints the detail in the type column, the way a commercial lender expects to read it.

Common mistakes

The ones underwriters see constantly: quoting the purchase price as today's market value on a property held for a decade; putting the escrowed total in the payment column and then listing taxes and insurance again — the payment field here is principal and interest only, so nothing is double-counted; forgetting properties held in an LLC, which still belong on your schedule with the entity named; and listing a business on it. A business is not real estate, an underwriter will not treat it as collateral here, and it makes the document look wrong — it belongs in its own part of the file.