Note: In order to use the spreadsheet examples, you need to download Business Functions
|ConIdx (Time, Base, Start, Finish, InitialAnnRate, IdxFcstVals, IdxStartFcst, IdxFcstBase, [IdxReg], [BaseDateOrIdx], [FirstIdxDate], [DayCount], [Periods], [ProjMode])|
|Constant Rate Index|
|Projects an amount that is constantly growing according to the regular periodic change an index.|
|Auto Array Function|
|...Idx...||Changes in line with a supplied Index|
Things To Watch Out For
If BaseDateOrIdx is missing or zero, it will default to the Start date. That default behaviour is just for this function ConIdx, by the way. The reason is that sometimes you just do not know the base date and would rather not specify it, but simply grow the projection from the Start.