weighted average rent with growth

[prussom]

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

 

[Fred Smith]

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))