I need to calculate amounts over time, i.e. I have a start date (1 July 07)
of a lease and an end date (30 June 2019). my problem is I have to calculate
commitments as at May 08 over 3 intervals.
1 year = May 08-Apr 09 equals amount X and
2-5 years = May 09-April 2014 equals amount Y
5 years = May 2014 -June 2019 equals amount Z AND
the yearly escalation should also be taken into account.
Lease at start = 7,000 escalation = 9%
Can anybody help me with a formula??????