CODE
@statikinetic
Projected growth rate of Thong Guan’s cash flow in the next 5 years.TGuan’s YoY net profit has been growing at CAGR of 15.23% (NP T4Q 80615 - 39679 NP 2015 over the last 5 years).
*all figures are in 000’*
Conservatively speaking, I’ll take CAGR 10% after factoring in possible drop in sales, fluctuation of resin prices & foreign exchange losses).
Discount factor formula:
1/(1+risk free rate)^n , whereby n = number of years to be discounted.
Our current OPR is 1.75%. (In United States, risk free bond rate is used instead).
Based on above formula:
Discount factor of TGuan in next 5 years:
1/1.0175, 1/1.0353, 1/1.0534, 1/1.0719, 1/1.0906 for year 2020, 2021, 2022, 2023, 2024 respective.
Discount factor of TGuan: 0.983, 0.966, 0.949, 0.933, 0.917
Next, we need to find the discounted value of all future cash flow. (DV)
DV = Projected cash flow x Discount factorAssuming the projected earnings and cash flow to be increasing at the rate 10% annually, the projected cash flow for year 2020 = free cash flow 2019 + 10% growth.. free cash flow for year 2021 = free cash flow 2020 + 10% growth…etc..
Free cash flow 2019: 227,217
Projected free cash flow 2020: 249,938
Projected free cash flow 2021: 274,931
Projected free cash flow 2022: 302,424
Projected free cash flow 2023: 332,666
Projected free cash flow 2024: 365,932
Total discount value for year 2020-2024: 245,689 + 265,583 + 287,000 + 310,377 + 335,559
Total number of outstanding shares to date: 380,969
Intrinsic value: sum of discount value / NOSH = 3.79 MYR.
Hence,based on projected free cash flow in the next 5 years, discounted to present value, one share is worth 3.79 MYR as of today.This post has been edited by MedElite23: Jan 26 2021, 08:11 PM