Formula of Growth Rate (Table of Contents)
What is the Growth Rate Formula?
Growth Rate can be defined as an increase in the value of an asset, individual investment, cash stream or a portfolio, over the period of a year. This is the most basic growth rate that can be calculated. There are few other advanced types to calculate growth rate among them average annual growth rate and compound annual growth rate.
The formula for Growth Rate is:
Explanation of Growth Rate Formula in Excel
The Growth rate equation is very easy and simple to use. Below are the steps that are required to calculate the growth rate.
- Step 1: Find out the beginning value of the asset, individual investment, cash stream.
- Step 2: Secondly find out the ending value of the asset, individual investment, cash stream.
- Step 3: Now divide the value arrived in step 2 by value arrived in step 1.
- Step 4: Subtract 1 from the outcome arrived in step 3
- Step 5: Multiply the result arrived in step 4 by 100.
- Step 6: The resultant will be the annual growth rate.
Examples of Growth Rate Formula
Let’s see some simple to advanced examples of growth rate equation to understand it better.
John Morrison invested $100,000 in an investment product and at the end of the year, his investment value went up to $107,900. However, he is yet to withdraw the amount. Does he want to know how much % has his money grown over the year? You are required to calculate Growth Rate.
Use the following data for the calculation of growth rate.
So, the calculation of growth rate can be done as follows –
We are given below the ending value as well as beginning value, hence we can use the above equation to calculate the growth rate.
Growth Rate = (107,900 /100,000) – 1
The Growth Rate will be –
Growth Rate = 7.90%
Kane wants to invest in a fund that has shown a growth rate of at least 20% and wants to allocate funds $300,000 equally. 10 funds have been shortlisted by his broker and below is the value of funds NAV at the start of the year and at the end of the year.
You are required to calculate the growth rate for each fund and allocate funds among the selected ones.
We are given below the ending fund value as well as beginning fund value, hence we can use the above excel formula to calculate the growth rate.
So, the calculation of growth rate for year large cap be done as follows:
Growth Rate = ( 115 / 101 ) – 1
The growth rate for year large cap will be –
Growth Rate For Year Large Cap = 13.86%
Similarly, we can calculate for rest of the funds, and below is the outcome along with selection.
Now, finally, we will allocate the amount of 300,000 among the 4 funds that are selected equally.
Hence, Kane will invest 75,000 among the 4 funds which appear to be riskier.
Growth Rate Formula (with Excel Template)
NSE Inc. started a business 5 years ago and has been catching the eye in the market as one of the multi-baggers due to its impressive growth.
Many investors are considering investing in it for long term purposes. Suij an equity analyst has started coverage over this stock. He first ran through the Gross revenue of the company and wanted to see individual growth years and compare same with industry average in order to confirm that indeed NSE Inc. is really catching eye stock or its just fluke.
You are required to calculate the growth rate for each year.
We are given below the ending gross revenue as well as beginning gross revenue for each year, hence we can use the above excel formula to calculate the growth rate.
So, the calculation of growth rate for the year 2015 can be done as follows:
Growth rate for the year 2015 = (6,00,00,000 / 5,50,00,000 ) – 1
Growth Rate for the Year 2015 will be –
Growth Rate for the Year 2015 = 9.09%
Similarly, we can calculate for the rest of the year, and below is the result.
You can refer the given above excel template for the detailed calculation of growth rate.
Growth Rate Calculator
You can use the following growth rate formula calculator.
|Percentage Growth or Return =||
Relevance and Uses
The growth rate is very much useful in real life. Whether one wants to know how the fund performed over the period, or what is their value of an investment after a given period say one year. Even statistician, scientists use the growth rate in their field for their research. The higher growth rate is always preferred and is a positive sign of the growth of the asset. But however, in the long term, the same is difficult to maintain and the growth rate will revert back to mean.
This has been a guide to Growth Rate Formula in Excel. Here we discuss the calculation of growth rate along with examples and downloadable excel template. You can learn more about financial analysis from the following articles –
- Examples of Delta Formula
- Examples for Formula of Discounting
- Formula of Internal Growth Rate
- Calculate Dividend Growth Rate
- Calculate Sustainable Growth Rate
- Formula of Growth in Excel
- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion
- Basic Excel Training
- Advanced Excel Training
- Basic & Advanced VBA Course
- Excel Dashboard Course
- Data Analysis in Excel
- Create VBA Applications