Definitive Analysis
Definitive Analysis
Financial Statements
Periods / Units
Fundamentals
Valuations
Miscellaneous
Analysis Mode
Full Access
See Pricing Start Trial

Tian Lun Gas Holdings Limited

Intrinsic Value Analysis (Discounted Cash Flow)Industry: Regulated GasSector: Utilities

Fair Value Summary

Current Price$2.97
5Y Range10.99 – 29.44
5Y Selected20.22
(-) Safety Margin81.50%
5Y Buy Price$4.47
Upside (to Buy Price)50.49%
10Y Range11.77 – 30.34
10Y Selected21.06
(-) Safety Margin81.50%
10Y Buy Price$4.66
Upside (to Buy Price)56.77%

Company Predictability & Safety

MetricValue
Revenue R2 (5Y)0.6071
Revenue R2 (10Y)0.8875
Net Income R2 (5Y)0.8549
Net Income R2 (10Y)0.0391
EBITDA R2 (5Y)0.7857
EBITDA R2 (10Y)0.4032
FCF R2 (5Y)0.0107
FCF R2 (10Y)0.1797
Safety Score0.2211

DA 10-Year Projection

Metric2025202620272028202920302031203220332034
% Growth4.33%4.29%4.25%4.22%4.18%4.14%4.11%4.07%4.04%4.00%
Revenue8,117.378,465.608,825.709,197.929,582.509,979.6910,389.7310,812.8511,249.2811,699.25
EBITDA1,215.261,267.391,321.301,377.021,434.601,494.061,555.451,618.801,684.131,751.50
D&A-370.18-386.06-402.48-419.46-437.00-455.11-473.81-493.10-513.01-533.53
EBIT845.07881.33918.82957.57997.601,038.961,081.641,125.691,171.131,217.97
Pro forma Taxes-232.11-242.07-252.36-263.01-274.00-285.36-297.09-309.18-321.66-334.53
NOPAT612.97639.26666.45694.56723.60753.59784.56816.51849.46883.44
Capital Expenditures-439.63-458.49-477.99-498.15-518.97-540.49-562.69-585.61-609.25-633.62
NWC Investment-67.18-69.50-71.87-74.29-76.76-79.27-81.84-84.45-87.11-89.81
(+) D&A370.18386.06402.48419.46437.00455.11473.81493.10513.01533.53
Free Cash Flow476.34497.34519.08541.58564.86588.94613.83639.55666.12693.55
Diluted Shares Outstanding969,066,250.00969,066,250.00969,066,250.00969,066,250.00969,066,250.00969,066,250.00969,066,250.00969,066,250.00969,066,250.00969,066,250.00

Discounting Periods

MetricDec-25Dec-26Dec-27Dec-28Dec-29Dec-30Dec-31Dec-32Dec-33Dec-34
Period Start6/30/251/1/261/1/271/1/281/1/291/1/301/1/311/1/321/1/331/1/34
Period End12/31/2512/31/2612/31/2712/31/2812/31/2912/31/3012/31/3112/31/3212/31/3312/31/34
Mid-Point9/30/257/2/267/2/277/1/287/2/297/2/307/2/317/1/327/2/337/2/34
Time (t)0.100.461.462.463.464.465.466.467.468.46
Valuation Date1/16/26

Base Case Projected Flows

WACC: 6.32%Terminal Growth: 3.05%
Metric2025202620272028202920302031203220332034TV (5y)TV (10y)
Discount Factor0.990.970.910.860.810.760.720.670.630.60
PV UFCF473.43483.51474.66465.81456.96448.12439.31430.51421.74413.01
Raw: 17,835.34
13,992.96
Raw: 21,898.42
12,647.25

Base Case Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value16,347.3317,154.31
(-) Net Debt866.92866.92
Equity Value15,480.4116,287.39
(/) Shares Out969.07969.07
Fair Value$15.97$16.81
(-) Safety Margin81.50%81.50%
Buy Price$2.96$3.11
Current Price$2.97$2.97
Upside (to Buy Price)-0.50%4.69%

Conservative Projected Flows

WACC: 7.32%Terminal Growth: 2.55%
Metric2025202620272028202920302031203220332034TV (5y)TV (10y)
Discount Factor0.990.970.900.840.780.730.680.630.590.55
PV UFCF472.99481.44468.22455.20442.39429.80417.41405.25393.30381.56
Raw: 12,160.22
9,193.26
Raw: 14,930.45
7,929.16

Conservative Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value11,513.4912,276.71
(-) Net Debt866.92866.92
Equity Value10,646.5711,409.79
(/) Shares Out969.07969.07
Fair Value$10.99$11.77
(-) Safety Margin81.50%81.50%
Buy Price$2.03$2.18
Current Price$2.97$2.97
Upside (to Buy Price)-31.57%-26.66%

Aggressive Projected Flows

WACC: 5.32%Terminal Growth: 3.55%
Metric2025202620272028202920302031203220332034TV (5y)TV (10y)
Discount Factor0.990.980.930.880.840.790.750.720.680.65
PV UFCF473.88485.62481.26476.76472.15467.41462.57457.61452.55447.39
Raw: 33,162.81
27,010.47
Raw: 40,717.65
25,594.07

Aggressive Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value29,400.1330,271.26
(-) Net Debt866.92866.92
Equity Value28,533.2129,404.34
(/) Shares Out969.07969.07
Fair Value$29.44$30.34
(-) Safety Margin81.50%81.50%
Buy Price$5.45$5.61
Current Price$2.97$2.97
Upside (to Buy Price)83.41%89.00%

Reverse DCF: Market Implied Growth

Current Price$2.97
WACC Used6.3%
IMPLIED REVENUE GROWTH65.74%
Metric2027202820292030203120322033203420352036
Implied Revenue26,155.8143,350.8971,850.19119,085.19197,372.95327,127.83542,184.83898,622.381,489,385.432,468,521.81
Constant Implied Growth65.74%65.74%65.74%65.74%65.74%65.74%65.74%65.74%65.74%65.74%
Implied Free Cash Flow2.624.347.1911.9119.7432.7154.2289.86148.94246.85
Discount Factor0.960.860.810.760.720.670.630.600.560.53
Present Value of Implied FCF2.513.735.819.0614.1322.0234.3353.5183.42130.05

Rolling Historical DCF (Backtest)

Valuation based on actual realized growth.
YearValuation DateActual PriceRealized Growth (5Y)Calculated Fair ValueValuation Delta
20192019-12-31$6.234.85%$14.44131.84%
20182018-12-31$5.655.52%$-1.63-128.77%
20172017-12-31$5.129.38%$0.05-99.04%
20162016-12-31$6.4020.00%$6.04-5.59%
20152015-12-31$5.7224.86%$-3.47-160.67%
20142014-12-31$6.4727.13%$-2.60-140.24%
20132013-12-31$5.7426.02%$-0.56-109.68%
20122012-12-31$3.2526.02%$-0.35-110.78%
20112011-12-31$1.6130.31%$-8.42-623.01%
20102010-12-31$1.5435.61%$6.22303.77%
20092009-12-31$1.8935.10%$3.6693.81%

Monte Carlo Simulation (1,000 Iterations)

Mean Fair Value
$20.79
Median
$16.89
10th Percentile
$11.54
90th Percentile
$29.68

Fair Value Distribution

$8.24 - $30.44
903
$30.44 - $52.63
80
$52.63 - $74.83
8
$74.83 - $97.02
4
$97.02 - $119.22
0
$119.22 - $141.41
0
$141.41 - $163.61
1
$163.61 - $185.80
0
$185.80 - $208.00
1
$208.00 - $230.19
0
$230.19 - $252.39
0
$252.39 - $274.58
1
$274.58 - $296.78
0
$296.78 - $318.97
0
$318.97 - $341.16
0
$341.16 - $363.36
0
$363.36 - $385.55
0
$385.55 - $407.75
0
$407.75 - $429.94
0
$429.94 - $452.14
2