Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weighted average | Excel Worksheet Functions | |||
Weighted Average | New Users to Excel | |||
Weighted Average | New Users to Excel | |||
Weighted Average | New Users to Excel | |||
Non zero weighted average | Excel Worksheet Functions |