Note: In order to use the spreadsheet examples, you need to download Business Functions
|UniSpreadH (Time, Base, Start, Finish, Total, [DatesHistory], [PmtsHistory], [DayCount], [Periods], [ProjMode])|
|UniSpread that uses historical data|
|UniSpreadH does a standard UniSpread, after allowing for PmtsHistory. In effect it does a MkPmts and then a UniSpread after adjusting Total for the payments made. The UniSpread starts upon the last date in the DatesHistory which has a non-zero pa|
|Auto Array Function|
It is most important to realise over what timeperiod the remaining amounts are spread. The start of the forecast is the date of the last history payment that has a non-zero payment. The finish of the forecast is the date specified by Finish. This means that if you want zero overlap between the historic and future payments, you should put a small non-zero amount as the last historic payment, say 1e-9. That will mean that the next date will be the start of the forecast.