Note: In order to use the spreadsheet examples, you need to download Business Functions | ||||||||
TStepFcstMkt (Time, Base, Start, ToDates, AnnualRates, FcstVals, StartFcst, FcstBase, [DayCount], [Periods], [ProjMode]) | ||||||||
Project a stepped continuous rate using a series of to dates and rates, where any gaps (zeros) in the rates are read off a supplied forecast | ||||||||
The function projects an amount over a timeperiod based on AnnualRates. In that respect it is the same as TStepFcst. The difference is that if a value of AnnualRates is blank or zero, the function will assume it needs to read that value from a suppl | ||||||||
Auto Array Function | ||||||||
Features | ||||||||
T... | Rates pertain to the time up until each corresponding to date | |||||||
...Fcst... | Changes are read of a supplied forecast. | |||||||
Step... | Has a stepped rate profile | |||||||
...Mkt... | The function reviews to a market estimate at intervals | |||||||
ExampleTStepFcstMkt.xls |