Note: In order to use the spreadsheet examples, you need to download Business Functions | ||||||||
TStepGrown (Time, Base, Start, ToDates, AnnualRates, GrowthDates, GrowthRates, [DayCount], [Periods], [ProjMode]) | ||||||||
TStep that is grown according to growth rates | ||||||||
This function does a TStep but before applying AnnualRates it grows them first. So for example, you could specify the rates in real terms and have GrowthRates inflate them. | ||||||||
Auto Array Function | ||||||||
Features | ||||||||
...Grow... | Incorporating growth rates | |||||||
Step... | Has a stepped rate profile | |||||||
ExampleTStepGrown.xls |