weighted average rent with growth

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

prussom@yahoo.com - 15 Jun 2007 17:12 GMT

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

Reply to this Message

Fred Smith - 16 Jun 2007 02:37 GMT

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

Signature

Regards,
Fred

>I have a starting rent amount (like $25).
>
[quoted text clipped - 8 lines]
>
> Phil

Reply to this Message