CAGR - A Useful Tool to Measure a Company Growth

By -
Some might wondering what is CAGR when looking at my article. As CAGR is one of my favourite tool in calculating company or industry growth.

CAGR is the short form of Compound Annual Growth Rate. It represents the rate of return that would be required for an investment to grow from its beginning balance to its ending balance. This is the explanation that i copy from Investopedia.


This is the formula for calculating CAGR, also from Investopedia. Investopedia has been my best friend since I was in university.

For better understanding, I will use a random company as example. Let's name it as ZOROS.
ZOROS 5-years CAGR from 2014 to 2019 is 18%. Assume its revenue at 2014 is RM100,

On 2015, its revenue should be: RM100 x (1+18%) = RM 118

On 2016, the revenue is: RM 118 x (1+18%) = RM 139.24

On 2017: RM 139.24 x (1+18%) = RM 164.30

On 2018, RM 164.30 x (1+18%) = RM 193.87

On 2019, RM 193.87 x (1+18%) = RM 228.76



Applying the formula from my best friend, Investopedia, you will get the same CAGR:

CAGR = (228.76/100)^1/5 -1 =  18%


But after i start working as an auditor, I found another good friend in the firm. She is good in calculating. Her name is excel. She taught me an easier way to calculate CAGR.

The formula is:
=RRI(nper,pv,fv)

nper: Number of periods
pv: Present value of investment
fv: Future value of investment

Looks, with a simple formula, you will be able to calculate CAGR, without remembering the complex formula, or calculate it year by year. Nevertheless, I would like to thanks excel and investopedia for being my best life companion. Adiós!

Comments

Post a Comment

Popular posts from this blog

ETF in Malaysia

By -
Image
What are the ETF in Malaysia? Source:  http://www.bursamalaysia.com/market/securities/equities/products/exchange-traded-funds-etfs/# In Malaysia, there are only 11 ETF. ETF is still not very popular compared with other country like United States. As of March 2019, there are more than 5,000 exchange traded products (ETPs) trading in the U.S. For investor who don't have time to carry out in-dept analysis of a stock, ETF probably is the best way to invest. In the long term, investor will surely gain profit from ETF without carry out proper research on stock. The reason is, ETF's portfolio is always follow the index's portfolio. For example, the portfolio in FBMKLCI-ETF (0820 EA) is constitute of FBMKLCI 30 constituents companies. The constituent companies in FBMKLCI will always change according to its representation and market value. This means that there are only strong companies can become one of FBMKLCI 30 constituents companies. The weak...
Read more

SOLUTN vs CYPARK

By -
Image
  There is no resistant for SOLUTN, hence it fly high like no tomorrow. For CYPARK, there is a resistant at RM 1.50, hence it's blocked at here after shoot up for few days. Lesson Learnt: When comparing the stock, do consider the historical resistance level.
Read more

Is KLCI currently in a Dead Cat Bounce?

By -
Image
I have called myself as a value investor which focus on value of an assets rather than its price. However, short term and medium term of market is pretty hard to predict. Hence, it's wise to implement some technical analysis on analyzing the overall market condition, whether it's a bull, a bear or a kangaroo. From the monthly chart of KLCI, we can observe that, it seems like KLCI has formed a double top (highlighted in yellow) plus head and shoulder pattern (blue lines), which are the strong indication that the market has already formed its top! This means that, the market has higher risk at current position, and the recent strong bound, is assumed to be a dead cat bounce. Dead cat bounce is a temporary rally of stock price after a major correction (which happened on March 2020). This could be the last chance for investor to exit the market! However, that's just my assumption. Anything could happen in market. The subsequent market trend could be formed, either up or down, o...
Read more