How should I put rent bumps in this rent roll? Should I just start over?
[{"id": "erkzkxk", "text": "Based on what I'm seeing (can't see formulas) - detail rent bumps in the notes cell", "replies": [{"id": "erkzobd", "text": "I was thinking of doing that but I feel like there\u2019s a better way to organize it", "replies": [{"id": "erldhin", "text": "If you\u2019re trying to do a multiple-year analysis, you might want a separate schedule showing the increase over time, perhaps including expected returns from reinvested cash flows, but I\u2019m not sure that\u2019s what you\u2019re trying to do.", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "erl0m5c", "text": "Add a new column under the lease terms header with an \"annual increase\" then input a percentage that reflects what is in the lease\n\n&amp;#x200B;\n\nEdit: in the notes detail when the rent increases take effect, which should be on the anniversary of the lease commencement date.", "replies": [{"id": "erl1svh", "text": "The problem is not every tenant has annual increases, some have rent bumps every five years. He sort of wants the rent option schedule built in if possible.", "replies": [{"id": "erl2iyy", "text": "Without knowing all the specifics on this exercise the only other suggestion I can offer is building out a table that shows the next 5 years (or whatever the longest lease is) and showing the rent increases that way. Then linking that table or referencing it in your rent roll.\n\nI may also be missing something since 90% of my experience is in multifamily with the other 10% being office and retail.", "replies": [], "depth": 3}, {"id": "erl71xz", "text": "I've seen it done where each lease has a section down below that breaks out rent, the specific reimbursements, and rent bumps for each year for 10 to 15 years. Then it's aggregated at the top", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "erl0nyo", "text": "What are you trying to solve for? Simply capturing data?\n\nMight be best to create a separate worksheet in your workbook detailing the specifics of each rentable space with escalations and bring in summary details back to this table.\n\nOr, more simply, Build a reference table with the escalations and have them used as inputs for a formula in this table.\n\nDepends on what your needs are.", "replies": [{"id": "erl0t6z", "text": "Trying to show a rent roll of our retail property. We have it set up another way but my boss asked if I could do it better.", "replies": [{"id": "erl1ud6", "text": "If he/she wants to keep it high level then I think you have a great start. Maybe some colors for the headers to create better visual esthetics.\n\nYour gross potential rent cell, is that what he wants to know, or NOI, or both?\n\nCaveat!!! If bossman didn\u2019t ask, don\u2019t do it or you\u2019re going to create more work for yourself. Haha. Maybe less is more in this situation.", "replies": [{"id": "erl2wmi", "text": "He said he likes what I have but would like the option schedule for each tenant built in so he only has one sheet that he has to look at and knows where we stand\n\nHe showed me another one that he likes how the schedule is built in but he said he isn\u2019t in love with it", "replies": [], "depth": 4}], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "erl8nhq", "text": "I typically display escalations in one column, regardless of the metric. So I'll put either 3%/yr, $0.50/yr, $1.00/5 yrs or whatever. Rent rolls are just a roll up of the info, so I like to keep them simplified. Rent schedules are normally shown in the leases or lease abstracts.", "replies": [], "depth": 1}, {"id": "erla187", "text": "looks like you've received some good responses here, but the good people over in r/excel would also love to help with this if you need more help.", "replies": [], "depth": 1}, {"id": "erld7k5", "text": "You want to be able to calculate effective rent. To do so, you need the rent escalations, free rent, any TI's included. \n\nSo that means you need a field for type of escalation, bump vs percentage increase, a field for free rent and a field for TI allowance. \n\nThen you can use a formula based on those to create an effective rate field.", "replies": [], "depth": 1}, {"id": "erldxb4", "text": "assuming you don't need the amounts calculated, and just want the terms of each increase you can add two columns to the schedule. One will be the frequency for which the bumps occur (ie. 1 year for annual increases, 2 years for every other year increase, etc...) then you can have a column showing what % increase will be used. For the options, you can use a similar methodology. At least this will provide a general idea of how each lease is structured. Although, like the other comments have said, it is hard to give an answer when we don't know the specifics of this exercise. Hope this helps.", "replies": [], "depth": 1}, {"id": "erlek07", "text": "Put in the average and note the bumps below", "replies": [], "depth": 1}, {"id": "erlq1h7", "text": "Just add two columns - Next rent incr. date and amount psf.  Then if he wants to see all the steps you just add rows below each suite to build out the whole schedule. If you go that route you can use a sumifs on current date in your table at the top to avoid double counting suites (plenty of other ways to do it, too).", "replies": [], "depth": 1}, {"id": "erm1cyj", "text": "It really does depend on what you want/need. \n\nIf you're wanting to show the different bumps at different times on a schedule, it sounds like you should put together a full DCF over the projected holding period. I think that's about the only way you're going to capture everything you sound like you might need.", "replies": [], "depth": 1}, {"id": "erm1ikm", "text": "An intern in the wild!!", "replies": [], "depth": 1}, {"id": "ern6glo", "text": "Change your structure to show incomes for specific years (ie 2019, 2020, 2021 etc). You'll be able to format bumps within a single cell if you include special characters like ; to separate the different years. It'll take some formatting but will give you better end results.", "replies": [{"id": "ern6m8k", "text": "Heavy lifting with large rent rolls (ie dozens to hundreds clients) is best done in argus or similar. You'll have a hell of a time replicating that in excel.", "replies": [], "depth": 2}], "depth": 1}, {"id": "erq9bef", "text": "Snider Plaza in Dallas?", "replies": [], "depth": 1}]