Hi, I need help with a relatively simple task. I have a rent roll spread with unit numbers, occupancy status, lease dates, and rents.
1. I want to project rents over the course of a 10 year period, on a monthly basis
2. I want this worksheet to include for when the current lease expires that the next tenant will renew for a x% higher rate.
3. I want to include assumptions for the renewal lease period.
4. If you have additional suggestions based on your experience please let me know.
5. attached is the document that you will be working from. As you can see this information is already spread. I need the new file to have rows built out for each unit number and then each column to be the monthly rent, with increased based on the rollover rent increase.