Discounted Cash Flow (DCF) Analysis Unlevered

Danaher Corporation (DHR)

$246.31

-2.07 (-0.83%)
All numbers are in Millions, Currency in USD
Stock DCF: 296.93 | 246.31 | undervalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 19,89317,911.1022,28429,45331,47135,678.2340,447.9045,855.2151,985.4058,935.11
Revenue (%)
EBITDA 4,757.905,179.306,54510,09010,61910,718.1112,150.9713,775.3815,616.9517,704.72
EBITDA (%)
EBIT 3,450.203,989.804,7707,9228,3978,177.719,270.9510,510.3511,915.4313,508.36
EBIT (%)
Depreciation 1,307.701,189.501,7752,1682,2222,540.402,880.013,265.033,701.524,196.36
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 787.8019,912.306,0352,5865,99512,133.7913,755.9015,594.8717,679.6920,043.21
Total Cash (%)
Account Receivables 3,489.603,191.404,0454,6314,9186,055.476,865.017,782.768,823.2010,002.74
Account Receivables (%)
Inventories 1,910.101,628.302,2922,7673,1103,443.313,903.634,425.495,017.115,687.83
Inventories (%)
Accounts Payable 1,712.801,514.402,0492,5692,2963,016.813,420.123,877.344,395.684,983.33
Accounts Payable (%)
Capital Expenditure -655.70-635.50-791-1,294-1,152-1,316.37-1,492.35-1,691.86-1,918.03-2,174.45
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 246.31
Beta 0.802
Diluted Shares Outstanding 736.80
Cost of Debt
Tax Rate 14.34
After-tax Cost of Debt 0.92%
Risk-Free Rate
Market Risk Premium
Cost of Equity 7.286
Total Debt 19,677
Total Equity 181,481.21
Total Capital 201,158.21
Debt Weighting 9.78
Equity Weighting 90.22
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 19,89317,911.1022,28429,45331,47135,678.2340,447.9045,855.2151,985.4058,935.11
EBITDA 4,757.905,179.306,54510,09010,61910,718.1112,150.9713,775.3815,616.9517,704.72
EBIT 3,450.203,989.804,7707,9228,3978,177.719,270.9510,510.3511,915.4313,508.36
Tax Rate 19.49%8.99%18.89%15.33%14.34%15.41%15.41%15.41%15.41%15.41%
EBIAT 2,777.623,631.173,869.066,707.327,192.946,917.657,842.448,890.8610,079.4511,426.93
Depreciation 1,307.701,189.501,7752,1682,2222,540.402,880.013,265.033,701.524,196.36
Accounts Receivable -298.20-853.60-586-287-1,137.47-809.53-917.75-1,040.44-1,179.54
Inventories -281.80-663.70-475-343-333.31-460.32-521.86-591.63-670.72
Accounts Payable --198.40534.60520-273720.81403.31457.22518.35587.64
Capital Expenditure -655.70-635.50-791-1,294-1,152-1,316.37-1,492.35-1,691.86-1,918.03-2,174.45
UFCF 3,429.624,566.773,870.367,040.327,359.947,391.718,363.569,481.6510,749.2112,186.22
WACC
PV UFCF 6,930.167,351.707,814.108,305.588,827.98
SUM PV UFCF 39,229.52

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 6.66
Free cash flow (t + 1) 12,429.95
Terminal Value 266,737.07
Present Value of Terminal Value 193,230.42

Intrinsic Value

Enterprise Value 232,459.94
Net Debt 13,682
Equity Value 218,777.94
Shares Outstanding 736.80
Equity Value Per Share 296.93