Tips on sorting rent rolls?
So I’m new to sorting rent rolls and it’s been taking me forever to sort them. do you have any tips or videos on how to speed this up?
Trending Content
| +52 | Leave brokerage to be GP | 12 | 1d | |
| +46 | New Comp Database - Google Form (Now with Data Validation) | 24 | 1d | |
| +24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 2d | |
| +23 | Going out on your own | 4 | 1d | |
| +23 | Spreads over SOFR/UST | 5 | 2h | |
| +22 | REPE/Development GPA | 15 | 4d | |
| +21 | Real Estate = complicated + underpaid | 15 | 1d | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 5d | |
| +17 | Fisher Brothers | 6 | 1d | |
| +15 | Can you exit from Fund to Asset management or Investment in Real Estate ? | 21 | 6h |
Career Resources
Are you utilizing the filter feature?
ya ofc
.
This is a reason for 1) shops needing fewer analysts than they used to and 2) compression in pay. Because software can do this easily, a google search will reveal plethora of of options available. But shops also have analysts (a real person) overseas doing work like these and so much more- load rent rolls and financials into the models, etc.
Are you struggling with getting rent charges onto the same row as the unit number in detailed rent rolls? If that's your issue, I can probably give you a quick 5-10 minute tutorial over teams. Shoot me a DM,
ya thats exactly the issue i’m dealing with. I appreciate it; I just shot over a dm
Post it here if you could!
I'll try and write out what I can in a bit, but it's going to be much easier to demonstrate over a shared screen. Feel free to DM as well & we can set something up.
@jmrunk was kinda enough to walk me through it. Shoot me a dm and I’d be happy to show you what i learned. If you’d rather have me type it out. let me know and i can do that too - whatever you prefer!
If there is only one unit number in the far left column, but like 4-5 rows for each unit (various charges), you can select the entire range of units in the far left column. Then press f5, go to special, select only blanks, click = and then press the up arrow and then ctrl+enter. That will make sure that every row has a unit number assigned to it. Now you can use it to make a pivot table, or manipulate how you see fit.
How would you easily sort rent rolls before loading into your model in this scenario. In the unit number row, instead of actual rents for some units, you have random charges like pet rent, concessions, etc. In this scenario, if you filter by just charge code- actual rent- you will not see the unit number for some units. And evening having vacant units makes it harder and messes it up. Please see below example.
Example
unit #1, actual rent $1,000
unit #3, actual rent $1,200
unit #3, pet rent $150
unit #4, actual rent $1,300
unit #5, vacant
Fugiat dolor expedita et ut repellat facere. Asperiores et quas reiciendis minus dicta fuga temporibus pariatur. Tempora sint cumque qui quae sit nostrum voluptatem repellendus. Fuga explicabo et tempore et et fuga. Magnam ratione dolor distinctio et autem id eos. Omnis rerum ut et asperiores necessitatibus iure id.
Ea natus sed molestias voluptatem enim molestiae. Dolor aut recusandae explicabo in. Illo sit aut et eum accusantium. Sapiente reprehenderit eum numquam velit quis. Architecto est exercitationem perspiciatis ut aut.
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...