CAGRæ¯Compound Annual Growth Rateç缩åï¼æææ¯å¤åå¹´åå¢é¿çãå¤åå¹´åå¢é¿çæ¯æï¼ä¸é¡¹æèµå¨ç¹å®æ¶æå
ç年度å¢é¿çãå
¶è®¡ç®æ¹æ³ä¸ºæ»å¢é¿çç¾åæ¯çnæ¹æ ¹ï¼nç¸çäºæå
³æ¶æå
çå¹´æ°ã
å
¬å¼ :
(ç°æä»·å¼/åºç¡ä»·å¼)^(1/å¹´æ°) - 1.
å¨excel 计ç®ä¼æ´å ç®ä¾¿ï¼åªéè¾å
¥å
¬å¼ï¼ä¾¿èªå¨å¾åºã
å
¬å¼:
=power(ç°æä»·å¼/åºç¡ä»·å¼,1/å¹´æ°)-1
举ä¾ï¼2014å¹´ä»·å¼ä¸º1000ï¼2010å¹´ä»·å¼ä¸º400ï¼2014å¹´ç¸å¯¹2010å¹´å¤åå¢é¿ç计ç®å¦ä¸ï¼
=power(1000/400,1/4)-1
å¨excelä¸è¾å
¥ä¸è¿°å
¬å¼ï¼ä¾¿èªå¨å¾åºç»æã
温馨提示:答案为网友推荐,仅供参考