Trending Content - Real Estate Forum
Career Resources
WSO Free Modeling Series - Now Open Through
August 31, 2026
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
What do you mean by "manipulate"?
^. You would only need rent roll ever for occupancy, lease expirations (if you model out monthly instead of annually and get super granular) and the spread between current leases and market rent for market rent upside assumptions. Can't imagine anything else you could "manipulate" out of RR from an underwriting perspective.
This isn't a "gotcha!" because you have no reason to know it, but certain municipalities (for example NYC) have strict rent control/stabilization laws, so knowing when leases turn over can actually be hugely important to validating assumptions. If I sign a 2 year lease in September, and you're assuming 3% rent increases annually... you're going to miss your assumptions by a fair bit (well, 3% to be exact). Also a full rent roll should give you the legal status of each unit instead of just a rolled up "gross potential rent" line.
Recent leases vs. market (usually last 5-10 depending on size of property) overall and by floor plan, occupancy by floor plan, renovation status, etc.
I agree that it's mostly what you said, but there's a lot of good data you can get out of a RR. Especially if they happen to leave tenant balances on there that you can compare against the AR report.
This guy rent rolls.
To add my $0.02, for our UW we look at in-place by unit line, market by unit line, LTL, last 50 leases rate (across all unit lines), last 25 leases rate (all unit lines), move-in pace/tenant vintage (each unit line and aggregate), upcoming expirations, weighted average rate by move-in months (both chunk and PSF), tenant balances (when available) and occupancy. Includes graphs on some of the items.
We don't use RedIQ or anything similar.
Also check to see if there are model units not mentioned in the package, check out the L90, L60, and L30 lease rates to see where rents are trending, see what % of the RR is leased to corporate units, check if any units are below market rent or rent controlled etc. LOTS of stuff in the RR. Some good tips above I hadnt thought of.
OP if you DM me I can share a RR analysis model I made but honestly given the different formatting of RRs its not a one size fits all situation. Good time to practice your modeling chops.
Dolores harum cum hic labore id temporibus reiciendis. Consequatur inventore id enim temporibus quisquam. Iusto adipisci officia voluptas qui ipsa aut saepe. Deserunt itaque atque ut voluptates sit vel. Autem odio tenetur in similique voluptatem et repellat.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Quibusdam iste et perspiciatis est dolorem. Tenetur aut debitis sit quis. Doloremque sit dolore ipsum nam deserunt enim nostrum. Fuga molestiae vel deleniti omnis et maiores aut.
Quo non quaerat sunt sit numquam quibusdam quam qui. Cupiditate sapiente laudantium est. Culpa reprehenderit praesentium tempore vel ut voluptas eum earum.
Eum consequuntur vitae quas enim dignissimos aut fuga ipsum. Culpa eius aut doloremque. Minus rerum nostrum qui earum recusandae. Dolor vitae provident sint ipsam blanditiis provident ratione atque.
Ipsa consequatur non culpa ab rerum enim. Aut omnis maiores suscipit totam eum quo. Corporis laudantium accusantium reiciendis perferendis aut et ipsum.
Optio veniam saepe eum qui. Et placeat velit natus odit et iste consequatur. Vel reprehenderit velit iure sunt aspernatur delectus quas est. Occaecati a eveniet est.