Financial Modeling Tutorials
 Excel Modeling
 Financial Functions in Excel
 Sensitivity Analysis in Excel
 Sensitivity Analysis
 Capital Budgeting Techniques
 Time Value of Money
 Future Value Formula
 Present Value Factor
 Perpetuity Formula
 Present Value vs Future Value
 Annuity vs Pension
 Present Value of an Annuity
 Doubling Time Formula
 Annuity Formula
 Present Value of an Annuity Formula
 Future Value of Annuity Due Formula
 Maturity Value
 Annuity vs Perpetuity
 Annuity vs Lump Sum
 Deferred Annuity Formula
 Internal Rate of Return (IRR)
 IRR Examples (Internal Rate of Return)
 NPV vs XNPV
 NPV vs IRR
 NPV Formula
 NPV Profile
 NPV Examples
 Advantages and Disadvantages of NPV
 Mutually Exclusive Projects
 PV vs NPV
 IRR vs ROI
 Break Even Point
 Break Even Analysis
 Breakeven Analysis Examples
 Break Even Chart
 Benefit Cost Ratio
 Payback Period & Discounted Payback Period
 Payback period Formula
 Discounted Payback Period Formula
 Payback Period Advantages and Disadvantages
 Profitability Index
 Feasibility Study Examples
 Cash Burn Rate
 Interest Formula
 Simple Interest
 Simple Interest vs Compound Interest
 Simple Interest Formula
 CAGR Formula (Compounded Annual Growth Rate)
 Growth Rate Formula
 Effective Interest Rate
 Loan Amortization Schedule
 Mortgage Formula
 Loan Principal Amount
 Interest Rate Formula
 Rate of Return Formula
 Effective Annual Rate
 Effective Annual Rate Formula (EAR)
 Compounding
 Compounding Formula
 Compound Interest
 Compound Interest Examples
 Daily Compound Interest
 Monthly Compound Interest Formula
 Discount Rate vs Interest Rate
 Discounting Formula
 Rule of 72
 Geometric Mean Return
 Geometric Mean vs Arithmetic Mean
 Real Rate of Return Formula
 Continuous compounding Formula
 Weighted average Formula
 Average Formula
 EWMA (Exponentially Weighted Moving Average)
 Average Rate of Return Formula
 Mean Formula
 Mean Examples
 Population Mean Formula
 Weighted Mean Formula
 Harmonic Mean Formula
 Median Formula in Statistics
 Range Formula
 Outlier Formula
 Decile Formula
 Midrange Formula
 Quartile Deviation
 Expected Value Formula
 Exponential Growth Formula
 Margin of Error Formula
 Decrease Percentage Formula
 Relative Change
 Percent Error Formula
 Holding Period Return Formula
 Cost Benefit Analysis
 Cost Benefit Analysis Examples
 Cost Volume Profit Analysis
 Opportunity Cost Formula
 Opportunity Cost Examples
 APR vs APY
 Mortgage APR vs Interest Rate
 Normal Distribution Formula
 Standard Normal Distribution Formula
 Normalization Formula
 Bell Curve
 T Distribution Formula
 Regression Formula
 Regression Analysis Formula
 Multiple Regression Formula
 Correlation Coefficient Formula
 Correlation Formula
 Correlation Examples
 Coefficient of Determination
 Population Variance Formula
 Covariance Formula
 Coefficient of Variation Formula
 Sample Standard Deviation Formula
 Relative Standard Deviation Formula
 Standard Deviation Formula
 Standard Deviation Examples
 Effect Size
 Sample Size Formula
 Volatility Formula
 Binomial Distribution Formula
 Multicollinearity
 Hypergeometric Distribution
 Exponential Distribution
 Central Limit Theorem
 Poisson Distribution
 Central Tendency
 Hypothesis Testing
 Gini Coefficient
 Quartile Formula
 P Value Formula
 Skewness Formula
 R Squared Formula
 Adjusted R Squared
 Regression vs ANOVA
 Z Test Formula
 Z Score Formula
 Z Test vs T Test
 FTest Formula
 Quantitative Research
 Histogram Examples
Related Courses
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.
Example #1
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.
Solution:
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%
Example #2
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.
4.9 (1,067 ratings)
Solution:
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 multibaggers 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.
Solution:
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.
Ending Value  
Beginning Value  
Percentage Growth or Return  
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.
Recommended Articles
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
 250+ Courses
 40+ Projects
 1000+ Hours
 Full Lifetime Access
 Certificate of Completion