Note: In order to use the spreadsheet examples, you need to download Business Functions
|MkPmts (Time, Base, PmtDates, Pmts)|
|Make several Payments|
|Makes one or a number of payments in a given time period defined by Time and Base|
|Auto Array Function|
Whats good or unique about it
There"s nothing remarkable about this function except that it works and there is no equivalent without lots of IF statements! This is a real building block for budgets and business plans, where you want to chuck a load of payments and dates into your model and let the function take care of the scheduling.
TemplatesThis function features in the following downloadable spreadsheet template(s):