|AnnGrow (Time, Base, Start, Finish, AnnualRate, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode])|
|Constant rate that grows at annual intervals|
|Calculates a continuously growing rate, assuming the rate changes annually.|
|Auto Array Function|
|Ann...||Simplified version of the function based upon annual calculations|
|...Grow...||Incorporating growth rates|
Whats good or unique about it
You can easily specify a gradual, annually growing payment stream without too many parameters.
The function applies growth annually according to the growth rates indicated. This means that the rate changes every year, on the anniversary of the first growth date.
TemplatesThis function features in the following downloadable spreadsheet template(s):