Note: In order to use the spreadsheet examples, you need to download Business Functions
|MkPmtsPerGrow (Time, Base, AbsFinish, PmtDates, Pmts, GrowthDates, GrowthRates, Periodicity)|
|Make a sequence of payments periodically with growth|
|This function is like MkPmtsGrow, but the addition of ¥Interval¥, an exact number of months, means that the Pmts are repeated ad infinitum.|
|Auto Array Function|
|...Grow...||Incorporating growth rates|
The purpose of AbsFinish in this function is to cut off, or finish the otherwise endless stream of repeating payments. The first group of payments is defined by PmtDates.
TemplatesThis function features in the following downloadable spreadsheet template(s):