PAC

PAC — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($255.08)
DCF$9010487.32+3532316.2%
Graham Number$25.69-89.9%
Reverse DCFimplied g: -16.8%
DDM$181.69-28.8%
EV/EBITDA$3055.98+1098.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $9.63B
Rev: 187.0% / EPS: -13.7%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$9010487.32
Current Price$255.08
Upside / Downside+3532316.2%
Net Debt (used)$36.21B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term179.0%183.0%187.0%191.0%195.0%
7.0%$13051984.05$14014507.60$15032998.71$16109863.55$17247576.28
8.0%$9932182.89$10664570.14$11439539.83$12258922.57$13124600.70
9.0%$7823300.90$8400126.68$9010487.32$9655824.40$10337620.20
10.0%$6316985.82$6782700.91$7275488.73$7796512.95$8346970.14
11.0%$5197399.29$5580532.20$5985934.98$6414564.80$6867405.87

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $11.43
Yahoo: $2.57

Results

Graham Number$25.69
Current Price$255.08
Margin of Safety-89.9%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$255.08
Implied Near-term FCF Growth-16.8%
Historical Revenue Growth187.0%
Historical Earnings Growth-13.7%
Base FCF (TTM)$9.63B
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: $8.82

Results

DDM Intrinsic Value / share$181.69
Current Price$255.08
Upside / Downside-28.8%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $21.33B
Current: 7.8×
Default: $36.21B

Results

Implied Equity Value / share$3055.98
Current Price$255.08
Upside / Downside+1098.0%
Implied EV$167.46B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$18.21B$27.21B$36.21B$45.21B$54.21B
3.8x$1488.33$1278.78$1069.22$859.67$650.12
5.8x$2481.71$2272.15$2062.60$1853.05$1643.49
7.8x$3475.08$3265.53$3055.98$2846.42$2636.87
9.8x$4468.46$4258.91$4049.35$3839.80$3630.25
11.8x$5461.84$5252.28$5042.73$4833.18$4623.62