Rental escalation settlement

Originally Posted by piet123

I need a formula that can tell me what the current rental with a escalation and the current settlement for the outstanding months. For example:
A1 2010/09/30 (start date) ,B1 2015/09/30 (end date) ,C1 R895.00 (start rental amount) ,D1 15% (escalation)

So basically if somebody can help me with a formula that can tell me the current rental amount at this time and the settlement amount that's left on the contract.

You don't know your current rent?! ;-) I'm guessing this is homework, but oh well....

I assume the escalation rate is annual. And I assume escalation occurs on the anniversary of the start date, not at the beginning of each year(?). In that case, the current monthly(?) rent is:

E1: =fv(d1,year(today())-a1,0,-c1)

Note: Usually that amount is rounded one way or another (TBD).

We don't know the settlement terms, perhaps you mean: the amount due if the lease is broken before the end date.

Usually that is not the amount of rent that would have been paid for the remainder of the lease year, much less the remainder of the lease. Instead, it is usually the rent for a fixed number of months or month-to-month up to the time it might "reasonably" take (usually prescribed by law) to find a new lessee.

But if you want the amount of rent for the remainder of the lease year(!), try:

=e1 * (datedif(a1,b1,"m") - datedif(a1,today(),"m"))