Note: In order to use the spreadsheet examples, you need to download Business Functions
|MkPmtsLagProf (Time, Base, MonthsLag, Proportions, PmtDates, Pmts, [DayCount], [Periods], [AbStart], [AbFin])|
|Make Payments lagged according to a profile|
|Makes payments according to a profile of lags in months. For example, 20% lagged 1 month, 50% lagged 2 months, 30% lagged 3 months. Useful for working capital and creditor calculations.|
|Auto Array Function|
This function works by doing a MkPmtsLag for each of the pairs of MonthsLag and Proportions. The Proportions should add to 1, but the functions will ensure that they are adjusted to add to 1, if they don"t.