Intrinsic Valuation of NESTLEIND
NESTLEIND Free Cash Flow Average and Growth over past 5Y   Key Statistics
Year   FCF FCF Growth
2021 $16,604,700,000 -21.87% EPS (FY) 222.46   Market Cap 1921B
2020 $21,253,300,000 -11.07% P/E Ratio 90.88 Total Asset 86B
2019 $23,899,700,000 11.78% Net Income 21B Total Debt 3B
2018 $21,381,400,000 19.55% EBITDA 36B Total Liab 62B
2017 $17,885,300,000 28.24% Opr Margin 0.2068 Debt/Equity 0.12
2016 $13,946,500,000 PreTax Margin 0.1821   BV/Share 216.20
5Y Average FCF   $20,204,880,000 5.32%
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): 6.21% Current US Bond Yield: 1.48%  
Forcasting Future Free Cash Flow for next 6Y Modified Benjamin Graham's Intrinsic Value
Year   FCF Projection  
2022 $17,488,808,372 MBG Intrinsic Value $4,670.65
2023 $18,419,990,622
2024 $19,400,753,173
2025 $20,433,735,901
2026 $21,521,719,242
2027 $22,667,631,675
Terminal Value   $625,914,680,238   Net Worth/Share $246.43
DCF Valuation DCF Valuation "What If" Scenario Table
Enterprise Value $507,240,372,016 Growth Rate
(+) Cash & Cash Equivalents $7,986,900,000 5316.24 1.50% 2.00% 2.50% 3.00% 3.50%
(-) Total Debt $2,658,200,000 WACC 6.11% 4479.8 4914.5 5469.5 6203.1 7217.6
Equity Value $512,569,072,016 6.16% 4430.4 4854.0 5393.4 6103.4 7080.4
Shares Outstanding 96415716 6.21% 4382.0 4794.9 5319.2 6006.9 6948.3
6.71% 3949.7 4274.1 4675.6 5185.4 5853.9
DCF Intrinsic Value $5,316.24 7.21% 3593.9 3854.1 4169.6 4560.0 5055.6
© Swarnadeep Seth (2022)