GLP-PB

GLP-PB — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($25.44)
DCF$554627318.48+2180138730.5%
Graham Number$30.26+19.0%
Reverse DCFimplied g: 2.1%
DDM$49.03+92.7%
EV/EBITDA$936128264.00+3679749365.4%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $137.72M
Rev: 6.2% / EPS: -43.6%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$554627318.48
Current Price$25.44
Upside / Downside+2180138730.5%
Net Debt (used)$2.04B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-1.8%2.2%6.2%10.2%14.2%
7.0%$594686636.35$1123313392.93$1737432748.11$2447248206.19$3263751316.80
8.0%$120561133.27$545381664.65$1038198611.66$1607087420.27$2260745462.18
9.0%$-207734612.12$145470793.10$554627318.48$1026347146.10$1567750250.12
10.0%$-448535857.46$-147642254.36$200424643.02$601212163.91$1060692445.95
11.0%$-632725401.95$-371662562.81$-70092540.52$276724551.98$673890548.36

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $2.27
Yahoo: $17.94

Results

Graham Number$30.26
Current Price$25.44
Margin of Safety+19.0%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$25.44
Implied Near-term FCF Growth2.1%
Historical Revenue Growth6.2%
Historical Earnings Growth-43.6%
Base FCF (TTM)$137.72M
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: $2.38

Results

DDM Intrinsic Value / share$49.03
Current Price$25.44
Upside / Downside+92.7%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $377.87M
Current: 7.9×
Default: $2.04B

Results

Implied Equity Value / share$936128264.00
Current Price$25.44
Upside / Downside+3679749365.4%
Implied EV$2.98B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$39.59M$1.04B$2.04B$3.04B$4.04B
3.9x$1424652296.00$424652296.00$-575347704.00$-1575347704.00$-2575347704.00
5.9x$2180390280.00$1180390280.00$180390280.00$-819609720.00$-1819609720.00
7.9x$2936128264.00$1936128264.00$936128264.00$-63871736.00$-1063871736.00
9.9x$3691866248.00$2691866248.00$1691866248.00$691866248.00$-308133752.00
11.9x$4447604232.00$3447604232.00$2447604232.00$1447604232.00$447604232.00