Tips for sorting broker rent rolls?
Does sorting messy rent rolls drive anyone else crazy?
Looking for any tips/tricks you all use to sort through the messy rent rolls! Would really appreciate any insights
Does sorting messy rent rolls drive anyone else crazy?
Looking for any tips/tricks you all use to sort through the messy rent rolls! Would really appreciate any insights
| +11 | JLL - 1st Year Analyst (Am i underpaid) | 32 | 3d |
| +3 | 2027 internships | 1 | 1d |
| +2 | MF Acquisition UW | 3 | 20h |
Career Resources
WSO Virtual Bootcamps
Career Advancement Opportunities
November 2026 Investment Banking
Overall Employee Satisfaction
November 2026 Investment Banking
Professional Growth Opportunities
November 2026 Investment Banking
Total Avg Compensation
November 2026 Investment Banking
“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”
Leaderboard
| 1 | 99.2 | |
| 2 | 99.0 | |
| 3 | 99.0 | |
| 4 | 99.0 | |
| 5 | 98.9 | |
| 6 | 98.9 | |
| 7 | 98.9 | |
| 8 | 98.9 | |
| 9 | 98.9 | |
| 10 | 98.8 |
“... I believe it was the single biggest reason why I ended up with an offer...”
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.
What kind of mess are you seeing? Maybe I can help.
Pro-tip.... Call the broker and ask them to resend it to you/format it differently. They probably have an analyst/client services person that will do this for them/you. This is free.... work smarter not harder.
I'm the guy who has to do this! Not cool haha.
If for any reason you can't get a broker to send a properly formatted version, just have a template w/ the important terms so you can disaggregate it quickly.
I just do columns w/: Tenant name, start date, end date, months remaining, rent/sf, monthly rent, annual rent, rent bumps, expense reimbursements, lease notes (ROFO to contiguous space, LL right to relocate, co-tenancy clause, etc.).
Generally only takes 15-20 minutes if I can't get a broker to send a proper one over.
Illo officia quaerat qui praesentium commodi ut. Commodi fuga doloribus quis ratione alias nulla voluptas. Ea voluptas ut consequuntur doloremque. Mollitia sed laboriosam aut exercitationem.
A quibusdam blanditiis molestias officiis quaerat deleniti molestias. Voluptatibus reiciendis aliquid id excepturi eos laborum est. Repellendus qui quo iusto quis corrupti. Omnis consequatur ut dolorem porro.
Molestiae molestiae ea et non. Soluta est aperiam consectetur cupiditate. Quis facere qui dicta eaque cupiditate porro harum. Placeat placeat assumenda quis et et error.
Voluptatem sint aperiam et atque mollitia aliquid adipisci. Aut culpa animi non non quia reprehenderit blanditiis et.
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...