CAGR Formula in Excel: 4 Methods With Examples
The CAGR formula in Excel is =(End/Start)^(1/Years)-1. With the start value in B1, the end value in B2 and 5 years, type =(B2/B1)^(1/5)-1. For 10,000 growing to 16,000, the answer is 9.86%. A shorter option is =RRI(5,B1,B2). In this guide What is CAGR and how do you calculate it? How do you calculate CAGR in…
