Note: In order to use the spreadsheet examples, you need to download Business Functions
|FStepSpread (Time, Base, Total, FromDates, AnnualRates, [DayCount], [Periods], [ProjMode])|
|Stepped Rate where there is a Total to be spread, using From Dates|
|This function is like FStep, but where you know what the total disbursed should be. The function flexes the Finish Date accordingly ie when the Total is depleted, it stops paying out.|
|Auto Array Function|
|Step...||Has a stepped rate profile|
FStepSpread is an FStep where the finish date is unknown, but the total amount expended is. The function works my first calculating when the Finish date is, based on the rates input and the Total, and then doing a conventional FStep.
TemplatesThis function features in the following downloadable spreadsheet template(s):