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)