I am trying to remove some table from my financial model. Currently, mt model is set up with the following tables:
- Monthly unit absorption based on a monthly unit absorption assumption
- Monthly rental $ based on a $/square foot amount assumption + an annual rental increase that is calculated based on an % inc assumption
I get to my total revenue number by multiplying the two numbers.
I am trying to get rid of the 2 tables and have one that calculates the total amount of the rent for the given month accounting for absorption and a rent increase.
The annual rent increase is in cell F3
The monthly absorption is in column E
The $/square foot is in column C
The unit size is in column B
Any help would be appreciated.
I am using Microsoft Office 365 on Mac
Bookmarks