Intrinsic Valuation of COLPAL
COLPAL Free Cash Flow Average and Growth over past 5Y   Key Statistics
Year   FCF FCF Growth
2021 $15,966,814,000 113.93% EPS (FY) 39.65   Market Cap 439B
2020 $7,463,473,000 -16.63% P/E Ratio 41.63 Total Asset 29B
2019 $8,952,613,000 2.50% Net Income 11B Total Debt 1B
2018 $8,733,936,000 70.60% EBITDA 15B Total Liab 12B
2017 $5,119,604,000 29.78% Opr Margin 0.2650 Debt/Equity 0.05
2016 $3,944,826,000 PreTax Margin 0.2684   BV/Share 63.78
5Y Median FCF   $9,247,288,000 29.78%
Overall Market Assumptions:
Assumptions: P/E for No-Growth Company: 7.00  
Perpetual Growth Rate (g): 2.50% Historical US Bond Yield: 4.40%  
Discount Rete (WACC): 5.16% Current US Bond Yield: 1.48%  
Forcasting Future Free Cash Flow for next 6Y Modified Benjamin Graham's Intrinsic Value
Year   FCF Projection  
2022 $20,721,766,897 MBG Intrinsic Value $831.15
2023 $26,892,755,395
2024 $34,901,478,060
2025 $45,295,216,236
2026 $58,784,232,872
2027 $76,290,308,812
Terminal Value   $2,941,705,114,138   Net Worth/Share $63.78
DCF Valuation DCF Valuation "What If" Scenario Table
Enterprise Value $2,281,901,647,618 Growth Rate
(+) Cash & Cash Equivalents $7,547,127,000 8414.48 1.50% 2.00% 2.50% 3.00% 3.50%
(-) Total Debt $830,536,000 WACC 5.06% 6472.4 7429.8 8761.2 10738.9 13984.4
Equity Value $2,288,618,238,618 5.11% 6373.9 7300.2 8581.5 10469.9 13531.3
Shares Outstanding 271985634 5.16% 6278.1 7174.8 8408.5 10213.4 13105.6
5.66% 5448.5 6110.5 6982.0 8181.1 9935.4
DCF Intrinsic Value $8,414.48 6.16% 4799.3 5304.7 5948.2 6795.4 7961.0
© Swarnadeep Seth (2022)