|
|
|
|
|
|
|
|
|
|
|
|
|
|
Intrinsic Valuation of HON |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
HON Free Cash Flow Average and Growth over
past 5Y |
|
Key Statistics |
|
|
Year |
|
FCF |
FCF Growth |
|
|
|
|
|
|
|
|
2021 |
|
$5,143,000,000 |
-3.00% |
|
EPS (FY) |
7.91 |
|
Market Cap |
121B |
|
|
2020 |
|
$5,302,000,000 |
-12.48% |
|
P/E Ratio |
23.68 |
|
Total Asset |
63B |
|
|
2019 |
|
$6,058,000,000 |
8.06% |
|
Net Income |
6B |
|
Total Debt |
21B |
|
|
2018 |
|
$5,606,000,000 |
13.60% |
|
EBITDA |
8B |
|
Total Liab |
45B |
|
|
2017 |
|
$4,935,000,000 |
12.08% |
|
Opr Margin |
0.1971 |
|
Debt/Equity |
1.07 |
|
|
2016 |
|
$4,403,000,000 |
|
|
PreTax Margin |
0.2005 |
|
BV/Share |
27.12 |
|
|
5Y Average FCF |
|
$5,408,800,000 |
3.65% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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.71% |
|
|
|
Current US Bond Yield: |
1.48% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forcasting Future Free Cash Flow for next 6Y |
|
Modified Benjamin Graham's Intrinsic Value |
|
|
Year |
|
FCF Projection |
|
|
|
|
|
|
|
|
|
2022 |
|
$5,330,863,341 |
|
|
MBG Intrinsic Value |
$166.01 |
|
|
2023 |
|
$5,525,588,948 |
|
|
|
|
|
|
|
|
|
2024 |
|
$5,727,427,486 |
|
|
|
|
|
|
|
|
|
2025 |
|
$5,936,638,776 |
|
|
|
|
|
|
|
|
|
2026 |
|
$6,153,492,129 |
|
|
|
|
|
|
|
|
|
2027 |
|
$6,378,266,694 |
|
|
|
|
|
|
|
|
|
Terminal Value |
|
$203,946,695,534 |
|
|
Net Worth/Share |
$26.19 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DCF Valuation |
|
DCF Valuation "What If" Scenario
Table |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Enterprise Value |
$167,129,838,841 |
|
|
|
Growth Rate |
|
|
(+) Cash & Cash Equivalents |
$11,523,000,000 |
|
|
228.26 |
1.50% |
2.00% |
2.50% |
3.00% |
3.50% |
|
|
(-) Total Debt |
$20,631,000,000 |
|
WACC |
5.61% |
183.9 |
206.3 |
235.8 |
276.7 |
337.0 |
|
|
Equity Value |
$158,021,838,841 |
|
5.66% |
181.4 |
203.2 |
231.8 |
271.2 |
328.8 |
|
|
Shares Outstanding |
692300000 |
|
5.71% |
179.1 |
200.2 |
227.9 |
265.9 |
321.0 |
|
|
|
|
|
6.21% |
158.0 |
174.2 |
194.8 |
221.7 |
258.6 |
|
|
DCF Intrinsic Value |
$228.26 |
|
6.71% |
141.1 |
153.8 |
169.5 |
189.5 |
215.7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Swarnadeep
Seth (2022) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|