Hi
I have an Series of Rent data( ie future rentals only with amount). I need a formula that will scan automatically the series of data put the appropriate escalation % to me
Escalation % Jan to Dec 2012 USD'000 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13
225,000 4.50 19,800 19,800 19,800 19,800 19,800 19,800 19,800 21,780 21,780 21,780
336,600 6.73 29,700 29,700 29,700 29,700 29,700 29,700 29,700 29,700 29,700 32,075
336,600 6.73 29,700 29,700 29,700 29,700 29,700 29,700 29,700 29,700 29,700 32,075
Bookmarks