Escalation Formula

[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

 

[Earl Kiosterud]

Ferdie,

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

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

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