Note: In order to use the spreadsheet examples, you need to download Business Functions | ||||||||
TLevelsGrowMkt (TheDate, Start, MktLevel, ToDates, Levels, GrowthDates, GrowthRates) | ||||||||
Series of levels to corresponding dates where any gaps are determined by an initial level and a growth forecast | ||||||||
This function does a simple TLevels, except that if one or more Levels are blank cells or zero, the function will refer to the supplied MktLevel and the GrowthRates | ||||||||
Auto Array Function | ||||||||
Features | ||||||||
T... | Rates pertain to the time up until each corresponding to date | |||||||
...Grow... | Incorporating growth rates | |||||||
...Mkt... | The function reviews to a market estimate at intervals | |||||||
...Levels... | Levels | |||||||
ExampleTLevelsGrowMkt.xls |