Yes, the Compound Annual Growth Rate (CAGR) can definitely be calculated for a 2-year period.
The formula for Compound Annual Growth Rate (CAGR) is (Ending Value / Beginning Value) raised to the power of (1 divided by the number of years), minus 1.
For example, if you invested Rs 1,000 in the past and today the value of the investment is Rs 1,500 then you have earned an absolute return of 50%. You may consider the investment tenure when calculating CAGR. Taking the same example, suppose you have an investment tenure of two years. CAGR = 22.47%.
Calculating CAGR in Excel
The formula to calculate the growth rate across two periods is equal to the ending value divided by the beginning value, subtracted by one. For example, if a company's revenue was $100 million in 2023 and grew to $120 million in 2024, its year-over-year (YoY) growth rate is 20%.
To calculate the growth rate, take the current value and subtract that from the previous value. Next, divide this difference by the previous value and multiply by 100 to get a percentage representation of the rate of growth.
Future Projection
CAGR helps estimate the future corpus. You're investing ₹10,000 monthly in a fund with historical 12% CAGR. You can project approximately how much you'll accumulate over 20 years.
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) where A1 contains the original date.
CAGR limitations to keep in mind
Yes, while CAGR is primarily an annual measure, you can apply its compounding logic month-wise to find the Compound Monthly Growth Rate (CMGR). You use the number of months instead of years in the formula's exponent. This gives a more granular view for shorter-term performance analysis.
CAGR = (End value/ Beginning value) ^1/n -1
Let's demonstrate this with an example. Assume Aritra invested Rs. 1,000 in an ELSS fund for three years. While the total NAV value remained Rs.
The formula for calculating compound interest is P = C (1 + r/n)nt – where 'C' is the initial deposit, 'r' is the interest rate, 'n' is how frequently interest is paid, 't' is how many years the money is invested and 'P' is the final value of your savings.
The rule of 72 says that if you know the rate of return then it is easy to find out when the money will double by applying the rule of 72. For instance, if the return is 9%, then it takes 8 years (72/9) to double the money.
The first formula is:
To calculate ROI, subtract the investment's total cost from the investment's proceeds or current value. Then, divide that amount by the investment's total cost and multiply the result by 100.
How to Calculate Growth Rate in Excel: Step-by-Step Guide
The step-by-step process to calculate CAGR is as follows.
XIRR is more appropriate for investments with multiple cash flows occurring at different time intervals. While CAGR can be calculated manually, XIRR typically requires Excel or a financial calculator. Use CAGR if you invest once and hold. Use XIRR if you invest through SIPs or withdraw at different times.
A quick rule of thumb: More than 10 % CAGR is usually considered good in many cases. For equity investments, a CAGR of about 15 – 30 % is often seen as healthy. For fixed‑income products, a CAGR of roughly 8 – 12 % is common.
Visualize Year-Over-Year Changes
In Excel, Ctrl+F12 is a shortcut to open the "Open" dialog box, allowing you to browse for and open an existing file, similar to going to File > Open. While pressing just F12 typically brings up the "Save As" dialog, Ctrl+F12 focuses on opening files, often useful for older versions or specific settings.
The most straightforward approach uses simple addition:
Limitations of CAGR
Ignores Short-Term Volatility: CAGR does not account for year-over-year volatility or risks, which can be important for certain types of investments. While it provides a long-term perspective, it may not capture short-term risks or dramatic shifts in performance.
Divide the final value of the considered investment by its initial value. Raise the result to the power of one divided by the number of years in the investment period. Subtract one from the result taken from the previous.
Make sure to use the number of periods, not the number of years. For example, when you calculate CAGR based on five years of sales, you evaluate only four annual periods. The first year of sales provides the starting point.