weighted average rent with growth
 

I have a starting rent amount (like $25).

I assume 3% growth in the rent amount each year.

I have a lease term (like 55 months).

Rent Term Ave. Rent
$25 55 ???

I need to compute average rent in Excel.

Phil

weighted average rent with growth
 

I think you'll need to build a table to calculate this.

Create 55 rows that show the rent each month, then calculate the average (such
as, =Average(C2:C56))

--
Regards,
Fred


wrote in message
oups.com...
I have a starting rent amount (like $25).

I assume 3% growth in the rent amount each year.

I have a lease term (like 55 months).

Rent Term Ave. Rent
$25 55 ???

I need to compute average rent in Excel.

Phil