Note: In order to use the spreadsheet examples, you need to download Business Functions
|ConGrow (Time, Base, Start, Finish, AnnualRate, GrowthDates, GrowthRates, [RevMonthsOpt], [DayCount], [Periods], [ProjMode])|
|Even rate that is continuously growing|
|Using an AnnualRate combined with a list of GrowthRates the function calculates a continuously growing constant rate.|
|Auto Array Function|
|...Grow...||Incorporating growth rates|
Growth is applied at intervals governed by RevMonthsOpt. The first time growth is applied is RevMonthsOpt after the first of the GrowthDates. So growth is applied in regular intervals from the first growth date. Note that this, by definition, means that growth intervals do not commence or have any relationship with the Start date.
TemplatesThis function features in the following downloadable spreadsheet template(s):