Calculates annual average rate of change (AARC or AROC) with the compounded
formula:
((end_value
/ baseline_value
))^(1/(end_year
- baseline_year
)) - 1
Arguments
- baseline_year
year where the AARC starts
- baseline_value
value at start_year
- end_year
year where the AARC ends
- end_value
value at end_year
Details
To forecast change the baseline value:
baseline_value
* ((1 + aroc
)^(current_year
- start_year
))
See also
General scenario functions
add_scenario()
,
calculate_aroc()
,
exec_scenario()
,
fill_cols_scenario()
,
flat_extrapolation()
,
get_aarr()
,
get_baseline_value()
,
get_baseline_year()
,
get_last_value()
,
get_last_year_scenario()
,
get_latest_aarc()
,
get_percent_change_aarc()
,
get_target_aarc()
,
remove_unwanted_scenarios()
,
trim_values()
,
trim_years()