Escalation Formula

  • Thread starter Thread starter FERDIE
  • Start date Start date
F

FERDIE

I'm creating a budget sheet. I'm trying to compute the monthly renta
rate on the 3rd year with the following arguments:

Monthly rental on 1st year = 10,000
Yearly increase of 10%
5 year lease contract

I want to create a formula where my variable/arguments will be
the monthly rental, yearly rate increase and year i want.

Example year
monthly rate rate inc 1 2 3
10000 10% 11,0000 12,100 13,310

i want to create just one formula..

Thank
 
Ferdie,

=Rental * (1 + %increase) ^ years.

It might look like:
=10000 * (1 + 10%) ^ 3

Or if the variables are in cells:
=A2 * (1 + B2) ^ C2
 
Back
Top