How to calculate a growth rate in excel
By
SpreadCheaters
Page last updated:
18/11/2022 |
Next review date:
18/11/2024
You can watch a video tutorial here.
Growth rate shows how much progress there is compared to a previous period. To do that in Excel, it requires some mathematical knowledge to execute it.
Step 1 – Click on an empty cell
Click on the empty cell and start adding in the formula.
Step 2 – In the formula bar right in the following:
(Present ValuePast Value-1)*100
For this example, B3 is the present value and B2 as the past value. Do take note that I intentionally skipped a single line mainly because you always have to take the past value as reference.
Step 3 – Press Enter
Pressing Enter automatically shows the output of the formula.
