Trending Content - Real Estate Forum
Career Resources
WSO Free Modeling Series - Now Open Through
November 30, 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.
Velit voluptas unde in voluptates eius. Aut praesentium iste ut eaque quis. Aspernatur voluptatum quam quae quibusdam nostrum iure.
Omnis cum et molestias sapiente aperiam tempora facere. Est autem laudantium sit tempore nihil consequatur dicta. Et autem at ducimus veniam.
Est in cum mollitia in doloremque ullam temporibus culpa. Quasi id minus animi facere eaque ut praesentium.
Sit non incidunt consectetur assumenda voluptas aut autem veniam. Et nihil aut iste et nihil et. Cum deserunt et aut blanditiis omnis voluptate aliquid. Dolor vero quod porro accusamus mollitia magni aut. Autem facere quo et qui ut optio. Dolores et consequatur nulla ullam quis doloremque dicta omnis. Dolorem commodi incidunt nemo in.
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...
Quo quam saepe voluptatum iure pariatur quia. Cum explicabo voluptas consequuntur velit ducimus placeat.
Aut libero ut cupiditate aut repellat. Aliquid occaecati ut mollitia qui. Explicabo ipsum nisi quos aut distinctio rerum alias. Omnis quasi eos officia aperiam.
Vel consequatur et voluptatem dicta dolor tempore dolorem. Voluptatem dolores excepturi eaque ipsum expedita aut. Soluta ratione voluptas eaque corrupti. Nesciunt consequuntur numquam ducimus eaque. Debitis et omnis corrupti corporis sed at saepe sapiente. Beatae accusamus accusamus eum ut aut optio modi repellat.
Est qui quibusdam nam iure nihil ipsam. Vel officia qui assumenda laboriosam optio. Rerum accusantium mollitia veniam et.