Note: In order to use the spreadsheet examples, you need to download Business Functions
|MkPmtsGroup (Time, Base, [LagMonths], PmtDates, Pmts, [DayCount], [Periods], [PrdsGroup], [AbStart], [AbFin])|
|Make Payments and Group together|
|Payments are grouped together in a set of times as set by PrdsGroup. There is also an optional LagMonths which lags the payments after they have been grouped.|
|Auto Array Function|
You might be wondering what DayCount and Periods are doing here - they have nothing to do with the grouping process, which is taken care of by PrdsGroup. The answer is that that they have the relatively minor job of controlling how LagMonths is applied, nothing else.
There are two mechanisms for moving the timing of the payments here,and the order is important: