Rent roll with bumps
My boss asked me to make a rent roll for some of our retail property. He also asked if I could put the rent bumps on there but would like it to fit on one page. Does anyone with experience creating rent rolls have any examples of the most efficient way to set it up?
[{"id": "erkwoep", "text": "Just Google image \"rent roll\" for an example. Make it in Excel then add columns for future year rent rates to show how much they'll be in the next years. I'd recommend adding enough columns to show the annual rates until the leases expire.", "replies": [], "depth": 1}, {"id": "erkxhnc", "text": "I do these a lot... Set up your columns (SF, base rent rate, annual rent, monthly rent). Then in your second row, in the base rent calc just insert the rent bump in the calculation. Drag down, repeat.", "replies": [{"id": "erl0hcd", "text": "I made another post with a picture of the rent roll. Do you think there\u2019s a way I could incorporate it into the one I already made?", "replies": [{"id": "erl5dqj", "text": "lots of hidden cells", "replies": [], "depth": 3}], "depth": 2}], "depth": 1}, {"id": "erl06yk", "text": "Super easy stuff.  Don't make it more difficult than it is.  Smoke a Doobie, and come back to it.", "replies": [{"id": "erl2p8e", "text": "Name checks out.", "replies": [], "depth": 2}], "depth": 1}]