APC

APC — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($19.01)
DCF$-69.40-465.1%
Graham Number$1.06-94.4%
Reverse DCF
DDM$2.47-87.0%
EV/EBITDA$1026.54+5300.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: —
Rev: — / EPS: —
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-69.40
Current Price$19.01
Upside / Downside-465.1%
Net Debt (used)$771.09M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$-69.40$-69.40$-69.40$-69.40$-69.40
8.0%$-69.40$-69.40$-69.40$-69.40$-69.40
9.0%$-69.40$-69.40$-69.40$-69.40$-69.40
10.0%$-69.40$-69.40$-69.40$-69.40$-69.40
11.0%$-69.40$-69.40$-69.40$-69.40$-69.40

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.70
Yahoo: $0.07

Results

Graham Number$1.06
Current Price$19.01
Margin of Safety-94.4%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Reverse DCF requires positive TTM free cash flow.
Current Price$19.01
Implied Near-term FCF Growth
Historical Revenue Growth
Historical Earnings Growth
Base FCF (TTM)
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: $0.12

Results

DDM Intrinsic Value / share$2.47
Current Price$19.01
Upside / Downside-87.0%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $141.36M
Current: 86.1×
Default: $771.09M

Results

Implied Equity Value / share$1026.54
Current Price$19.01
Upside / Downside+5300.0%
Implied EV$12.18B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.23B-$228.91M$771.09M$1.77B$2.77B
82.1x$1155.65$1065.65$975.65$885.65$795.65
84.1x$1181.10$1091.10$1001.10$911.10$821.10
86.1x$1206.54$1116.54$1026.54$936.54$846.54
88.1x$1231.99$1141.99$1051.99$961.99$871.99
90.1x$1257.43$1167.43$1077.43$987.43$897.43