How to get compound annual growth rates in pivot tables.

D

dunes

I understand how to use the custom calculations in the field settings in
pivot tables to derive a simple annual growth rate, using % Difference From,
(previous), and the year field .

Does anyone know a similar way to generate compound annual growth rates
(CAGRs) in a pivot table for each year in the series from the initial base
year?

I have tried doing a calculated field, but then the column total reflects a
sum of the CAGRs and not the CAGR for the total.
 
M

mmcap

I think using the "FV" or "FVSCHEDULE" function might be what you are looking
for.
 
D

dunes

Thanks, but I don't think that's quite it, if I'm understanding the Excel
help feature.

I don't have a single growth rate for future years. I'm trying to calculate
the compound annual growth rate based on levels given for the years in
question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compound Average Annual Growth Rate 3
Finding required growth rate 0
Compound Interest Rate or Growth Rate 2
What regular savings, increasing every year to reach goal 11
Finding Annual Growth Rate 7
How to: average annual growth 0
Additional columns for Pivot table 0
calculating a compound annual growth rate 1

Top