I have an underwriting template that measures rent increases using the table attached to this message. The table evenly distributes the number of units to upgrade each year according to the number of years we plan to upgrade, It does this division as best it can given the values don't always divide evenly. The highlighted cells are the cells that show the rent increase for the number of units upgraded (shown at the top of that row). The non highlighted cells are cells that show a typical year's 3% rent increase. The cells below the highlighted cells represent units have not been upgraded and those above the highlight have been upgraded.
There are two things I'd like to fix with this table. One is that I'd like to know if the totals along the bottom of the table can be derived using an array formula rather than this table. In my template I have 24 of these tables and its a lot of cells that I need to account for when I make changes.
The second item I'd like to try and address is to distribute the rent increases evenly across a 12 month period. For instance, the first year shows 17 units upgraded but the total for that column assumes that all 17 units are upgraded at the same time and we're collecting rent for an entire year. I'd like to find a way to calculate the highlighted value increase evenly over 12 months.
Bookmarks