GrowthFromYear

See also: Growth, GrowthAs, GrowthFromValue, GrowthFromYearXL

Syntaxes

GrowthFromYear(Year, GrowthRate) or
GrowthFromYear(Year, GrowthRate, Year2, GrowthRate2) or
GrowthFromYear(Year, GrowthRate, Year2, GrowthRate2, Year3, GrowthRate3)
See also: GrowthFromYearXL(ExcelFile, ExcelRange)

Description

Calculates a value in any given year using a growth rate expression applied after some specified year. Values in earlier years are based on the expression entered in the parent scenario or its ancestor expressions.

Example

GrowthFromYear(2010, 5%)
GrowthFromYear(2010, 5%, 2020, 3%)

Tip

To specify more than three growth rates, use the GrowthFromYearXL function, which works with a table of years and growth rates stored in an Excel spreadsheet.