CAGR Calculator. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); This site uses Akismet to reduce spam. Investopedia requires writers to use primary sources to support their work. D 1 = Expected dividend per share to be paid next year; k = Investors required rate of return g = Expected dividend growth rate There are basically two forms of the model: Stable model: As per the model, the dividends are assumed to grow at the same rate. Calculate the average annual percentage rate of appreciation. growth rate in 2017 and 2018. 12.5 title=">

Step 3: In the final step, the amount of interest paid yearly is divided by the face value of a bond in order to calculate the coupon rate. Data Analysis with Excel Dec. 8, 2022 at 3:42 p.m. Savings. EndingBalance You will get the calculated Average Annual Growth Rate for the specific data from your dataset in Excel. $ Our CAGR calculator will then find the CAGR return % of your investment.The CAGR formula is: ( (Ending value/beginning value)^ (1/period)-1) 200 Consider a portfolio that grows by 25%