AHL-PE

AHL-PE — Valuation Models

Interactive models with editable assumptions. All calculations run client-side.

Valuation Summary

ModelIntrinsic Valuevs Price ($20.88)
DCF$87956.28+421146.5%
Graham Number
Reverse DCFimplied g: -20.0%
DDM$29.05+39.1%
EV/EBITDA$28.56+36.8%

Values reflect default assumptions. Adjust inputs in each model below to update.

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $511.82M
Rev: 1.6% / EPS: 157.2%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$87956.28
Current Price$20.88
Upside / Downside+421146.5%
Net Debt (used)-$2.15B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term149.2%153.2%157.2%161.2%165.2%
7.0%$124766.28$135096.76$146100.72$157810.56$170259.72
8.0%$95153.42$103029.93$111419.87$120347.94$129839.61
9.0%$75118.50$81334.82$87956.28$95002.37$102493.21
10.0%$60794.26$65823.65$71180.76$76881.38$82941.75
11.0%$50136.46$54282.76$58699.20$63398.77$68394.88

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $-0.24
Yahoo: $30.21

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$20.88
Margin of Safety
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$20.88
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth1.6%
Historical Earnings Growth157.2%
Base FCF (TTM)$511.82M
Implied growth is the FCF growth rate (yrs 1–5) that makes the DCF intrinsic value equal the current price. Long-term growth is set to half the implied near-term rate.

4 — Dividend Discount Model (DDM)

Assumptions

Yahoo: $1.41

Results

DDM Intrinsic Value / share$29.05
Current Price$20.88
Upside / Downside+39.1%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $493.70M
Current: 1.0×
Default: -$2.15B

Results

Implied Equity Value / share$28.56
Current Price$20.88
Upside / Downside+36.8%
Implied EV$476.91M
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$4.15B-$3.15B-$2.15B-$1.15B-$146.20M
-3.0x$28.84$17.95$7.06$-3.83$-14.72
-1.0x$39.59$28.70$17.81$6.92$-3.97
1.0x$50.34$39.45$28.56$17.67$6.78
3.0x$61.09$50.20$39.31$28.42$17.54
5.0x$71.84$60.95$50.06$39.18$28.29