Calculating Growth Rates In Excel
Are you looking for the formula to calculate Growth Rate in Excel?
If you want to calculate growth rate between two months sales you can use following formula for that.
Growth Rate = ( ( Current Month Sales - Last Month Sales ) ^ 1 ) – 1
| A | B | C | |
|---|---|---|---|
| 1 | Month | Sales Amount | Growth Rate |
| 2 | January | $15000 | 100% |
| 3 | February | $18500 | =((B3/B2)^1)-1 |
Are you looking formula to calculate annual growth rate?
The Growth formula in Excel is an array formula meaning that it takes several arrays of data as input and outputs an array of data which can be difficult to understand if your knowledge of statistics is not what it used to be.
Annual Growth Rate = ( ( Current Month Sales - Last Month Sales ) ^ ( 1 / ( Periods – 1 ) ) ) – 1
The formula for CAGR is not difficult. For calculating growth from a single start time and a single end time it's sufficient. In other words, if we have a value for revenue in Year 1 and a revenue figure for Year 10 and we aren't concerned about the years between we would set up the spreadsheet shown below, given that the formula is:
| ((End Value/Start Value)^(1/(Periods - 1)) -1 | |
| Year 1 | 110.06 |
| Year 10 | 260.83 |
| =((B3/B2)^(1/9))-1 ==> | 10.06% |
Post a Comment