Revenue Growth Rate Excel
Y ou can calculate the average annual growth rate in excel by factoring the present and future value of an investment in terms of the periods per year.
Revenue growth rate excel. Include your email address to get a message when this question is answered. How to calculate the compound average growth rate. Open excel select a new spreadsheet. Excel will automatically change the formula to reflect the new location.
We will now estimate the revenue for the month of december 12 using growth formula in excel. Copy and paste the contents of cell b4 to other cells where you need the annual growth rate. We will write the formula as below. We will input cell b2 to b12 as known y s a2 a12 as known x s and a13 as new x s.
You provide your analyst with the sales revenue numbers and he crunches some forecasts for you.