Dear Forum members,

I am seeking to create a workbook that helps me calculate rental lease payments over a time scale.

Variables are:
Current lease expiry (date)
Lease tenure (in years , e.g 2 etc..)
Lease variance as a percentage (each time lease is renew what is the trend in costs for example)
square foot of leased area (number)
cost per sqft per month ($)
this should be shown in monthly payments, forecast 5 years on from todays date - with a view to chart

I would like to be able to interject at a date (between today and 5 years) where I can change lease area (Sqft )

The aim here is to chart and project (comparison) based upon status quo with renewed leases, and if entered the variation for larger or smaller sqft size.

both need to be plotted on chart as well as in year 1 year 1 year 3 etc.. (years would be 12 months on from todays date and not relating to lease expiry or otherwise)