Discounted Cash Flow (DCF) Analysis Unlevered

Edwards Lifesciences Corporation (EW)

$69.18

+0.92 (+1.35%)
All numbers are in Millions, Currency in USD
Stock DCF: 38.77 | 69.18 | overvalue

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 3,722.804,3484,386.305,232.505,382.405,918.376,507.717,155.747,868.308,651.81
Revenue (%)
EBITDA 1,390.101,330.601,735.601,483.301,829.902,010.552,210.762,430.912,672.972,939.14
EBITDA (%)
EBIT 1,312.701,241.301,628.401,348.501,690.301,871.512,057.872,262.792,488.122,735.88
EBIT (%)
Depreciation 77.4089.30107.20134.80139.60139.04152.89168.11184.85203.26
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 956.501,516.901,402.601,466.801,215.301,694.651,863.402,048.962,252.992,477.34
Total Cash (%)
Account Receivables 537.30599.10602.80664.90699.10800.76880.49968.171,064.581,170.59
Account Receivables (%)
Inventories 607640.90802.30726.70875.50940.911,034.601,137.621,250.911,375.47
Inventories (%)
Accounts Payable 134180.40196.50204.50201.90235.41258.85284.62312.96344.13
Accounts Payable (%)
Capital Expenditure -241.70-278.40-407.30-329.80-264.80-395.39-434.76-478.06-525.66-578.01
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 69.18
Beta 1.007
Diluted Shares Outstanding 624.20
Cost of Debt
Tax Rate 13.89
After-tax Cost of Debt 3.66%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.008
Total Debt 691.30
Total Equity 43,182.16
Total Capital 43,873.46
Debt Weighting 1.58
Equity Weighting 98.42
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 3,722.804,3484,386.305,232.505,382.405,918.376,507.717,155.747,868.308,651.81
EBITDA 1,390.101,330.601,735.601,483.301,829.902,010.552,210.762,430.912,672.972,939.14
EBIT 1,312.701,241.301,628.401,348.501,690.301,871.512,057.872,262.792,488.122,735.88
Tax Rate 5.15%10.25%10.18%11.69%13.89%10.23%10.23%10.23%10.23%10.23%
EBIAT 1,245.121,114.031,462.661,190.911,455.511,680.031,847.332,031.282,233.552,455.97
Depreciation 77.4089.30107.20134.80139.60139.04152.89168.11184.85203.26
Accounts Receivable --61.80-3.70-62.10-34.20-101.66-79.74-87.68-96.41-106.01
Inventories --33.90-161.4075.60-148.80-65.41-93.69-103.02-113.28-124.56
Accounts Payable -46.4016.108-2.6033.5123.4425.7828.3431.16
Capital Expenditure -241.70-278.40-407.30-329.80-264.80-395.39-434.76-478.06-525.66-578.01
UFCF 1,080.82875.631,013.561,017.411,144.711,290.131,415.461,556.411,711.401,881.82
WACC
PV UFCF 1,184.481,193.121,204.491,215.961,227.55
SUM PV UFCF 6,025.59

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 8.92
Free cash flow (t + 1) 1,919.45
Terminal Value 27,737.75
Present Value of Terminal Value 18,093.94

Intrinsic Value

Enterprise Value 24,119.53
Net Debt -77.70
Equity Value 24,197.23
Shares Outstanding 624.20
Equity Value Per Share 38.77