Reading a Rent Roll: What Numbers Actually Matter

The first time someone handed me a rent roll for a nine-unit building I was thinking about buying, I stared at it for about ten minutes without really understanding what I was looking at. Rows of unit numbers, rents, lease dates, a few blank cells. It looked complete, but it wasn’t telling me the truth. Six years and 9 properties later, I can read a rent roll in about 4 minutes and tell you within 5% whether the seller’s asking price is fair.

A rent roll is just a snapshot of who’s paying what, but the numbers that matter aren’t the ones printed in bold. Here’s what I actually check, in the order I check it.

Start with occupancy, not average rent

Sellers love to lead with average rent per unit because it’s the flattering number. I skip straight to occupancy. If a 12-unit building shows 2 vacant units, that’s an 83% occupancy rate, and anything under 90% makes me ask why before I ask anything else. I’ve walked away from two deals in the past 5 years purely because vacancy sat above 15% for more than 6 months running u2014 that’s not bad luck, that’s a management or location problem baked into the property.

Check lease-end dates for clustering

This one trips up a lot of first-time buyers. If 7 of your 10 leases all expire within the same 60-day window, you’re carrying serious re-leasing risk in one season instead of spreading it across the year. On one of my properties in year 2, I inherited a rent roll where 6 units all renewed every March u2014 turned out the previous owner had done a mass move-in promotion. I spent that first March fielding five move-out notices at once and eating roughly u00a5180,000 in turnover costs in a single month. Now I stagger renewal offers on purpose, usually pushing 2-3 leases per cycle to different months.

Compare actual rent to market rent, unit by unit

The average masks outliers. I make a simple table: unit number, current rent, what I think market rent is based on comparable listings nearby. On a recent 8-unit purchase, the average rent looked fine at u00a568,000, but two long-term tenants were paying u00a552,000 while everyone else was near u00a575,000. That gap told me two things u2014 there was upside if those tenants ever moved out, but also that the seller’s stated gross income was overstating what a new owner could expect to collect from a stabilized roll in year one.

Look for non-rent income buried in the total

Parking fees, storage, key money, pet deposits u2014 these sometimes get folded into the “monthly income” line without being labeled. I once caught a rent roll where u00a540,000 a month in parking income was mixed into unit rents, making three units look like they were renting u00a513,000 above market. Always ask for a breakdown, and if the seller won’t provide one, use that as a bargaining chip on price.

Cross-check the rent roll against bank deposits

This is the step most buyers skip, and it’s the one that’s saved me the most money. Ask for 3-6 months of actual bank statements showing rent deposits and compare them line by line to what the rent roll claims. On one deal, the rent roll showed 100% collection, but the deposits showed one tenant paying late or partial almost every month for the past year. That’s not a rent roll problem, that’s a collections problem, and it changes how you underwrite the deal. I now build in a 3% vacancy/collection loss buffer minimum on top of whatever occupancy the roll shows, even when it looks clean.

A quick checklist before you make an offer

• Occupancy rate calculated independently, not just quoted by the seller
• Lease-end dates mapped across a 12-month calendar to spot clustering
• Unit-by-unit rent compared to at least 3 comparable local listings
• Non-rent income items separated out and confirmed with the seller
• 3-6 months of bank deposit records matched against the rent roll
• Security deposit amounts and move-in dates checked for consistency

What I do differently now on my own properties

Because I self-manage everything, I keep my own rent rolls updated weekly rather than trusting a spreadsheet someone touches once a quarter. It takes me maybe 20 minutes every Sunday, but it means if I ever decide to sell one of my 9 properties, the document I hand a buyer is one I’d trust myself. It also means I catch a late payment or an expiring lease 45-60 days out instead of finding out the week it happens.

A rent roll is never just a list of numbers u2014 it’s a record of how a building has actually been run. Read past the average rent line and you’ll usually find the real story, good or bad, hiding in the details. That’s the approach I use across all 9 of my properties, and it’s the single habit that’s saved me from at least two bad purchases.

同じカテゴリの記事を読む

8棟自主管理の経験から書いた関連記事 — まとめて読むと理解が深まります

▸ Cost & Finance

Property Tax (u56fau5b9au8cc7u7523u7a0e) in Japan: What Landlords Pay and When

▸ DIY Repairs

Fixing a Dripping Outdoor Faucet Before Winter

▸ English

Small Living Room Layout Tips for Japanese Homes

▸ English

What I Look for in a Property’s Tenant History

▸ English

Living Room Renovation Vol.9: Ceiling Reinforcement Pt.2

▸ Cost & Finance

How I Track Which Properties Are Actually Profitable