Mazbuka
New Member
- Joined
- Sep 23, 2018
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
Hello brainy people,
In negotiations to rent a new building, I know our budget is say $3,000,000 over 5 years and also that the Landlord will be looking for some annual increments.
I'm really struggling to put in a formula to calculate year 1 rent which allows me to experiment with various increment percentages etc.
In the table, column B (Increment) is changeable & I want a formula to calculate rent each year...it's giving me a headache.
First time poster so apologies in advance for any breaches in layout etiquette!
<tbody>
</tbody>
In negotiations to rent a new building, I know our budget is say $3,000,000 over 5 years and also that the Landlord will be looking for some annual increments.
I'm really struggling to put in a formula to calculate year 1 rent which allows me to experiment with various increment percentages etc.
In the table, column B (Increment) is changeable & I want a formula to calculate rent each year...it's giving me a headache.
First time poster so apologies in advance for any breaches in layout etiquette!
<tbody> </tbody> |
<tbody>
</tbody>