|
|
|
|
|
|
|
|
|
|
|
|
|
|
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) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|