Hello
I have a work book with two tabs.
1. Contractual Rent Steps - This shows the annual cost per square foot.
2. Market Rent Steps - This will use the annual market cost per square foot with a 3% increase when the tenants Contractual annual rent step increases.
What I am trying to do is come up with a formula that will calculate the annual market rate using the information for the tenant on the contractual tab to determine when their rate increased. Then on the market tab use the market rate in cell W6 times the growth percentage in cell C4.
The layout on both tabs is
Column Q is the month 05/01/18.
Column R on the contractual tab is the annual cost per SF, on the Market tab it is the market rate.
For tenant A there start date is 05/01/2018, their increases occur in September each year (this will vary tenant by tenant). On the market tab the rate in column R will be the rate found in cell W6, until the first increase in this case September so the new rate would be the market rate time the growth percentage in cell C4. The next increase would need to take the previous increase and times that by the growth rate and so on for increase increase.
Any help with this formula would be greatly appreciated.
I have a work book with two tabs.
1. Contractual Rent Steps - This shows the annual cost per square foot.
2. Market Rent Steps - This will use the annual market cost per square foot with a 3% increase when the tenants Contractual annual rent step increases.
What I am trying to do is come up with a formula that will calculate the annual market rate using the information for the tenant on the contractual tab to determine when their rate increased. Then on the market tab use the market rate in cell W6 times the growth percentage in cell C4.
The layout on both tabs is
Column Q is the month 05/01/18.
Column R on the contractual tab is the annual cost per SF, on the Market tab it is the market rate.
For tenant A there start date is 05/01/2018, their increases occur in September each year (this will vary tenant by tenant). On the market tab the rate in column R will be the rate found in cell W6, until the first increase in this case September so the new rate would be the market rate time the growth percentage in cell C4. The next increase would need to take the previous increase and times that by the growth rate and so on for increase increase.
Any help with this formula would be greatly appreciated.