ALNT — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($65.25)
DCF	$198957.38	+304815.5%
Graham Number	$20.92	-67.9%
Reverse DCF	—	implied g: 12.1%
DDM	$2.47	-96.2%
EV/EBITDA	$65.25	+0.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $48.20M

Near-term growth (yrs 1–5)(%)Rev: 10.8% / EPS: 206.0%

Long-term growth (yrs 6–10)(%)

Terminal growth rate(%)

WACC(%)Computed: 10.59%

Computed WACC: 10.59%

Cost of equity (Re)12.64%(Rf 4.30% + β 1.52 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)83.81%

Debt weight (D/V)16.19%

Results

Intrinsic Value / share$142655.20

Current Price$65.25

Upside / Downside+218528.7%

Net Debt (used)$174.09M

Sensitivity: WACC (rows) × Near-term g (cols)

WACC \ Near-term	198.0%	202.0%	206.0%	210.0%	214.0%
7.0%	$291372.53	$311454.99	$332629.85	$354941.08	$378433.83
8.0%	$221496.15	$236761.48	$252857.13	$269816.52	$287673.96
9.0%	$174282.95	$186293.54	$198957.38	$212300.76	$226350.67
10.0%	$140576.31	$150263.31	$160477.14	$171239.00	$182570.67
11.0%	$115536.62	$123497.52	$131891.34	$140735.52	$150047.93

2 — Graham Number

Assumptions

MultiplierGraham used 22.5 (15× P/E × 1.5× P/B)

EPS (trailing)($)Yahoo: $1.12

Book Value / share($)Yahoo: $17.37

Results

Graham Number$20.92

Current Price$65.25

Margin of Safety-67.9%

Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 10.59%

Terminal growth rate(%)

Computed WACC: 10.59%

Cost of equity (Re)12.64%(Rf 4.30% + β 1.52 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)83.81%

Debt weight (D/V)16.19%

Results

Current Price$65.25

Implied Near-term FCF Growth16.4%

Historical Revenue Growth10.8%

Historical Earnings Growth206.0%

Base FCF (TTM)$48.20M

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

Annual dividend D0($/share)Yahoo: $0.12

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$2.47

Current Price$65.25

Upside / Downside-96.2%

Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $66.12M

Target EV/EBITDA multipleCurrent: 19.4×

Net Debt($B)Default: $174.09M

Results

Implied Equity Value / share$65.25

Current Price$65.25

Upside / Downside+0.0%

Implied EV$1.28B

Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)

Mult \ Net Debt	-$1.83B	-$825.91M	$174.09M	$1.17B	$2.17B
15.4x	$167.68	$108.66	$49.64	$-9.38	$-68.40
17.4x	$175.49	$116.47	$57.45	$-1.57	$-60.59
19.4x	$183.29	$124.27	$65.25	$6.23	$-52.79
21.4x	$191.10	$132.08	$73.06	$14.04	$-44.98
23.4x	$198.90	$139.88	$80.86	$21.84	$-37.18

← Overview Financial Statements ← Companies