Free Schedule of Real Estate Owned Template (Excel)

What's in the SREO template

The template is a single table with one row per property you own, the format lenders expect when underwriting a commercial or portfolio loan.

Each row captures the property address, type, percent owned, market value, loan balance and lender, annual principal and interest, and gross income and expenses for that property - everything a lender's SREO disclosure asks for.

Because every property is its own row, adding a new acquisition or dropping a sold property is a matter of adding or removing a line, not rebuilding a form.

What calculates automatically per property

Equity for each property is market value minus loan balance. NOI is gross annual income minus annual expenses. LTV is loan balance divided by market value - all three calculate the moment you enter the underlying numbers.

That means you're never manually subtracting a loan balance from a value or dividing two numbers to get a ratio - the sheet does it per row as you fill it in.

Portfolio totals and weighted average LTV

Below the property rows, the sheet totals portfolio market value, portfolio debt, and portfolio equity across every property, plus total NOI for the whole portfolio.

The weighted average LTV is calculated correctly as total debt divided by total value across the portfolio - not a simple average of each property's individual LTV, which would overweight smaller properties and misstate your real leverage.

That weighted figure is the one lenders and underwriters actually want to see when assessing your overall portfolio risk.

Why this beats a blank spreadsheet or a static lender form

Static lender SREO forms require you to manually total every column and calculate your own weighted LTV, which is easy to get wrong when you have more than a couple of properties.

This template already has the equity, NOI, LTV, and weighted-average formulas built in, formatted to print cleanly for a loan application. You fill in property numbers, not formulas.

Who this SREO template is for

Real estate investors and borrowers applying for a commercial or portfolio loan, where the lender requires a Schedule of Real Estate Owned as part of the underwriting package, are the main fit.

It's also useful just to keep an up-to-date view of your own portfolio equity and leverage between loan applications, without waiting for a lender to ask for it.