Question

2014 900 2016 1120 14.9 2017 1100 -1.8 2020 1410 2018 1195 8.6 32.8 2 Operating Revenue (SM) 3 % Change from previous yr 4 %Change from base year-Trend 5 4 Year CAGR:Calculator 6 4 year CAGR Ecel RRI 2019 1250 4.6 38.9 128 24.4 222 56.7

how does one find CAGR by using RRI on excel?

Answer 1

I have computed CAGR in Excel by using the data provided in the question. For better explanation, I have attached the screenshot of excel sheet where you can analyze the formula applied in the name cell for better understanding.

Rookt - Excel x . ? 1 - 0 Sign in AutoSum" AYR - Sort & Find & Filter Select EX Currency REVIEW VIEW Wrap Text Merge & Center. Algnment Copy Percentage C.% Number Comma 0 Percent L Comma Conditional Formatas Currency [O] Formatting Table 18 Insert Delete Format F G H I J K L M N O P Q R S T U V FILE HOME INSERT PAGE LAYOUT FORMULAS DATA Xcut Calibri - 11 JAN == Paste Format Painter B IV- A == = Cupboard Font c. X V for -(C8/C2/^(1/BB)-1 A B C D E 1 Year Year Operating Revenue 2 2014 0 $ 900.00 3 2015 1 $ 975.00 2016 2 $ 1,120.00 5 2017 3 S 1.100.00 6 2018 4 S 1 ,195.00 720195 $ 1,250.00 2020 6 $ 1.410.00 9 CAGR 7.77% ... Sheet43 Sheet 44 Sheet45 Sheet 46 Sheet47 Sheet48 Sheet49 Sheets Sheet1 Sheet52 Sheets3 Sheet54 She ... i READY + 1004 O Type here to search De x] A 4 OENG 12-12-2019 1