gregfthompson
asked on
Cumulative Annual Growth Rate (CAGR)
The attached spreadsheet has a CAGR.
I am attempting to adapt the microsoft example to calculate the CAGR on a transposed table.
CAGR-problem.xlsx
I am attempting to adapt the microsoft example to calculate the CAGR on a transposed table.
CAGR-problem.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use RATE directly to calculate CAGR, ie to get the growth betwen D5 and H5:
=RATE(COUNT(D5:H5)-1,,-D5, H5)
= 3.0%
=RATE(COUNT(D5:H5)-1,,-D5,
= 3.0%
ASKER
Apologies for the tardy response.
I am seeking compound annual growth rate - trying to work out what it was over the last 6 years, to then try to forecast. It's volume (litres), not money.