Note: In order to use the spreadsheet examples, you need to download Business Functions
|TStepSpread (Time, Base, Total, ToDates, AnnualRates, [DayCount], [Periods], [ProjMode])|
|Stepped Rate where there is a Total to be spread, using To Dates|
|This function is a TStep, except a finite Total amount is specified. The function just does a TStep until Total has been disbursed, and then stops disbursing.|
|Auto Array Function|
|Step...||Has a stepped rate profile|
TStepSpread is a TStep where the start date is unknown, but the total amount expended is. The function works my first calculating when the Start date is, based on the rates input and the Total, and then doing a conventional TStep.
TemplatesThis function features in the following downloadable spreadsheet template(s):