How to Read a Rent Roll and Find the Real Market Rent

By The vekstio team · · 6 minute read

The rent roll is the list of every unit: who lives there, what they pay, when the lease started and when it ends. It shows what the building should collect. The T12 shows what it did. The gap between them is your first question.

The short version
  • Sort by lease start date. The newest leases are the market.
  • Count the units yourself. Do not trust the summary line.
  • A rent roll with no balances and no lease end dates is hiding two risks.

What a complete one looks like

Unit number, unit type, size, tenant status, monthly rent, lease start, lease end, deposit and balance owed. If yours only says occupied or vacant, ask for the rest. The answer you get is information in itself.

Sort by lease start date

This one move does more than any rent survey. Put the newest leases at the top and read down.

On a typical building you will see something like this: leases signed this year at $975, leases from two years ago at $800 to $850, and one stubborn lease from four years ago at $720. The low rents are not a discount to the market. They are just old.

The newest leases tell you what a stranger agreed to pay for this unit, in this condition, recently. That is market rent. Everything else is opinion.

New leases should be rising

If this year's leases are lower than last year's, stop and find out why. Falling rents on new leases are one of the clearest warnings a rent roll can give you.

Watch for the staged comparable as well. One unit leased at the hoped for rent, with a free month attached, proves less than it seems. A $1,800 lease with two free months is a $1,500 lease.

Two market rents, never one

People mix these up constantly, and it is expensive:

  • As is market rent is what units like these rent for today with no money spent.
  • Renovated rent is what they would get after work, and it only counts together with the cost per unit and the months each unit sits empty.

Typing the renovated rent into the model while leaving the renovation budget at zero is the single most common error in a first underwriting.

Count the units

A broker's summary once said two units of 32 were vacant. The roll showed four. That is the difference between 94% and 87.5% occupied. The roll wins.

And remember what occupancy on a rent roll means. It is physical: bodies in units. It says nothing about who pays. For that you need economic vacancy.

The two columns that are often missing

  1. Balances owed. Add up what tenants owe and divide by a year of scheduled rent. If that comes to 5%, your vacancy assumption just grew by 5 points.
  2. Lease end dates. No end date usually means month to month. Those tenants can leave with thirty days of notice, all of them, in the same month.

Portfolios in one file

Sellers of several buildings often send one workbook with a tab per property and a summary tab in front. Make sure the rent roll and the income statement you are reading belong to the same building. It sounds obvious. It is also the easiest mistake to make at eleven at night.

This is one of the things we built vekstio to catch. When a file holds more than one property it stops and asks which one you are buying. Try it on a deal.

The building in the examples is invented. This guide is educational and is not investment, tax, legal or lending advice.

See it on your own deal

Drop the T12, the rent roll and the OM. Your first deal is free and complete, with nothing hidden.