Definitive Analysis
Definitive Analysis
Financial Statements
Periods / Units
Fundamentals
Valuations
Miscellaneous
Analysis Mode
Full Access
See Pricing Start Trial

Agilent Technologies, Inc.

Intrinsic Value Analysis (Discounted Cash Flow)Industry: Medical - Diagnostics & ResearchSector: Healthcare

Fair Value Summary

Current Price$140.51
5Y Range57.51 – 90.97
5Y Selected74.24
(-) Safety Margin46.06%
5Y Buy Price$40.04
Upside (to Buy Price)-71.50%
10Y Range63.03 – 96.73
10Y Selected79.88
(-) Safety Margin46.06%
10Y Buy Price$43.09
Upside (to Buy Price)-69.34%

Company Predictability & Safety

MetricValue
Revenue R2 (5Y)0.3001
Revenue R2 (10Y)0.9076
Net Income R2 (5Y)0.8686
Net Income R2 (10Y)0.7325
EBITDA R2 (5Y)0.0484
EBITDA R2 (10Y)0.8472
FCF R2 (5Y)0.0032
FCF R2 (10Y)0.6836
Safety Score0.5394

DA 10-Year Projection

Metric2026202720282029203020312032203320342035
% Growth5.42%5.27%5.11%4.95%4.79%4.63%4.47%4.32%4.16%4.00%
Revenue7,324.897,710.638,104.478,505.618,913.149,326.109,743.4210,164.0010,586.6411,010.11
EBITDA1,862.851,960.952,061.112,163.132,266.772,371.792,477.932,584.892,692.372,800.07
D&A-339.59-357.47-375.73-394.33-413.22-432.37-451.72-471.22-490.81-510.44
EBIT1,523.261,603.471,685.381,768.801,853.551,939.422,026.212,113.672,201.562,289.62
Pro forma Taxes-226.19-238.10-250.26-262.65-275.23-287.98-300.87-313.86-326.91-339.98
NOPAT1,297.071,365.381,435.121,506.151,578.321,651.441,725.341,799.811,874.661,949.64
Capital Expenditures-296.57-312.19-328.13-344.37-360.87-377.59-394.49-411.52-428.63-445.78
NWC Investment-46.14-47.22-48.21-49.11-49.89-50.55-51.09-51.49-51.74-51.84
(+) D&A339.59357.47375.73394.33413.22432.37451.72471.22490.81510.44
Free Cash Flow1,293.961,363.441,434.511,507.001,580.781,655.661,731.481,808.031,885.101,962.47
Diluted Shares Outstanding285,250,000.00285,250,000.00285,250,000.00285,250,000.00285,250,000.00285,250,000.00285,250,000.00285,250,000.00285,250,000.00285,250,000.00

Discounting Periods

MetricOct-26Oct-27Oct-28Oct-29Oct-30Oct-31Oct-32Oct-33Oct-34Oct-35
Period Start10/31/2511/1/2611/1/2711/1/2811/1/2911/1/3011/1/3111/1/3211/1/3311/1/34
Period End10/31/2610/31/2710/31/2810/31/2910/31/3010/31/3110/31/3210/31/3310/31/3410/31/35
Mid-Point5/1/265/2/275/1/285/2/295/2/305/2/315/1/325/2/335/2/345/2/35
Time (t)0.291.292.293.294.295.296.297.308.309.30
Valuation Date1/16/26

Base Case Projected Flows

WACC: 9.10%Terminal Growth: 2.45%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.980.890.820.750.690.630.580.530.490.44
PV UFCF1,261.691,218.581,175.171,131.611,088.021,044.531,001.27957.51915.07873.19
Raw: 24,375.65
16,062.52
Raw: 30,261.34
12,890.91

Base Case Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value21,937.6023,557.54
(-) Net Debt1,836.001,836.00
Equity Value20,101.6021,721.54
(/) Shares Out285.25285.25
Fair Value$70.47$76.15
(-) Safety Margin46.06%46.06%
Buy Price$38.01$41.07
Current Price$140.51$140.51
Upside (to Buy Price)-72.95%-70.77%

Conservative Projected Flows

WACC: 10.10%Terminal Growth: 1.95%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.970.880.800.730.660.600.550.500.450.41
PV UFCF1,258.361,204.321,150.871,098.141,046.25995.31945.42895.81848.33802.15
Raw: 19,789.09
12,482.52
Raw: 24,567.32
9,570.16

Conservative Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value18,240.4719,815.13
(-) Net Debt1,836.001,836.00
Equity Value16,404.4717,979.13
(/) Shares Out285.25285.25
Fair Value$57.51$63.03
(-) Safety Margin46.06%46.06%
Buy Price$31.02$34.00
Current Price$140.51$140.51
Upside (to Buy Price)-77.92%-75.80%

Aggressive Projected Flows

WACC: 8.10%Terminal Growth: 2.95%
Metric2026202720282029203020312032203320342035TV (5y)TV (10y)
Discount Factor0.980.900.840.770.720.660.610.570.520.48
PV UFCF1,265.061,233.141,200.221,166.421,131.861,096.671,060.971,024.08987.75951.26
Raw: 31,637.01
21,787.57
Raw: 39,276.00
18,311.09

Aggressive Valuation

5-Year Horizon10-Year Horizon
UFCFUFCF
Enterprise Value27,784.2729,428.53
(-) Net Debt1,836.001,836.00
Equity Value25,948.2727,592.53
(/) Shares Out285.25285.25
Fair Value$90.97$96.73
(-) Safety Margin46.06%46.06%
Buy Price$49.07$52.18
Current Price$140.51$140.51
Upside (to Buy Price)-65.08%-62.87%

Reverse DCF: Market Implied Growth

Current Price$140.51
WACC Used9.1%
IMPLIED REVENUE GROWTH148.16%
Metric2027202820292030203120322033203420352036
Implied Revenue17,241.9342,787.01106,178.85263,489.98653,868.131,622,617.834,026,635.489,992,367.2624,796,732.6661,534,762.98
Constant Implied Growth148.16%148.16%148.16%148.16%148.16%148.16%148.16%148.16%148.16%148.16%
Implied Free Cash Flow1.724.2810.6226.3565.39162.26402.66999.242,479.676,153.48
Discount Factor0.930.820.750.690.630.580.530.490.440.41
Present Value of Implied FCF1.613.517.9718.1441.2593.83213.25485.051,103.312,509.62

Rolling Historical DCF (Backtest)

Valuation based on actual realized growth.
YearValuation DateActual PriceRealized Growth (5Y)Calculated Fair ValueValuation Delta
20202020-10-31$102.093.13%$41.84-59.02%
20192019-10-31$75.756.35%$51.36-32.20%
20182018-10-31$64.799.74%$66.202.18%
20172017-10-31$68.0310.40%$54.10-20.48%
20162016-10-31$43.579.28%$46.165.95%
20152015-10-31$37.767.55%$25.66-32.04%
20142014-10-31$39.537.81%$33.71-14.72%
20132013-10-31$36.305.97%$54.6750.61%
20122012-10-31$25.744.50%$54.45111.53%
20112011-10-31$26.51-7.89%$36.3136.96%
20102010-10-31$24.85-13.88%$10.48-57.82%
20092009-10-31$17.69-10.23%$6.38-63.93%
20082008-10-31$15.87-0.24%$22.7143.09%
20072007-10-31$26.358.15%$43.5965.42%
20062006-10-31$23.996.39%$22.45-6.40%
20052005-10-31$21.575.54%$33.9857.51%
20042004-10-31$16.657.59%$27.7666.75%
20032003-10-31$16.794.15%$-12.34-173.52%
20022002-10-31$9.264.98%$-30.64-430.91%
20012001-10-31$15.00-1.30%$21.7945.27%
20002000-10-31$31.20-9.93%$2.27-92.72%
19991999-10-31$28.80-13.39%$0.57-98.01%
19981998-10-31$28.80-17.65%$5.05-82.48%

Monte Carlo Simulation (1,000 Iterations)

Mean Fair Value
$78.37
Median
$75.85
10th Percentile
$61.61
90th Percentile
$97.00

Fair Value Distribution

$47.98 - $53.47
5
$53.47 - $58.95
45
$58.95 - $64.43
113
$64.43 - $69.91
165
$69.91 - $75.39
158
$75.39 - $80.87
152
$80.87 - $86.36
119
$86.36 - $91.84
90
$91.84 - $97.32
54
$97.32 - $102.80
30
$102.80 - $108.28
17
$108.28 - $113.76
15
$113.76 - $119.24
15
$119.24 - $124.73
3
$124.73 - $130.21
7
$130.21 - $135.69
4
$135.69 - $141.17
5
$141.17 - $146.65
2
$146.65 - $152.13
0
$152.13 - $157.62
0