Intelligent Investor's Notes

RDCF Valuation - APOLLO (6432)

Few days ago, I have performed DCF valuation on APOLLO, and came into conclusion that the intrinsic value is 6.656.  But however, DCF valuation required us to perform the forecast on the growth in order to determine the intrinsic value. However, forecasting involve too much uncertainty, and a small error can result in a drastic change in the value.

Reverse DCF (RDCF) is the twin borther for DCF and it help to eliminate the need to forecast. The main objective of RDCF is to calculate what growth rate the market is applying to the current stock price. And, you can see whether the implied growth rate by the market is higher or lower than what the company is capable of.

APOLLO Stock Price as of now: 4.980
Initial Free Cash Flow: 21,216 (I am using the average of T4Q and latest 4 year Free Cash Flow)



Discount Rate
Discount Rate is the Cost of Equity, which equal to Risk Free Rate + Equity Premium. Based on today context, the interest rate for 1 year FD is around 3.2% and I will use it as my risk free rate. I would required a premium of 8% in order to risk my money in the equity market. But in view of the clean balance sheet and company was involve in consumer staple sector, I perform some adjustments to my risk premium.




And, my required discount rate is 3.20% + 6.48% = 9.68%

Balance Sheet Items


Add caption

Based on above input, the required growth rate in order to justify for today stock price of 4.980 will be 3.35%

So, now we have to answer "Is the expected growth rate realistic?"


References:-
Related Stocks
Market Buzz
Discussions
Be the first to like this. Showing 9 of 9 comments

sbg3106

so how do we justify is it realistic or not?

2014-08-01 15:31

nicholas1969

Hi Intelligent Investor, Thanks for sharing above knowledge. As I am new to all these analysis, I would like to know how you calculated for the adjusted risk premium of 6.48%? Another question is, can I start the discount rate of 10% at 2013 instead of 2018? Is there any reason?

2014-08-01 16:04

Intelligent Investor

hi sbg3106, ask yourself do you think the company able to growth its FCF on 3.35%?

2014-08-01 17:08

Intelligent Investor

hi nicholas1969, the 10% is not for year 2018. It is just the intrinsic value if I apply 10% discount rate.

2014-08-01 17:10

sbg3106

can you provide us the excel file for both EPV and RDCF calculation? Thanks

2014-08-01 17:51

Intelligent Investor

hi sbg3106,I have shared the file on my previous post. It is the same template

2014-08-01 17:59

sbg3106

Do yoi mind to tell me which version of excel file?

2014-08-01 19:38

ccs999

Hi II, do you think based on MOS for Apollo is just 3.35% is worth to invest? Please advise. Thank you.
Regards,
Chua

2014-08-02 15:18

Intelligent Investor

I won't.

2014-08-02 22:54

Post a Comment