QVCGP

QVCGP — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($4.96)
DCF$-4285907191.11-86322400726.5%
Graham Number
Reverse DCFimplied g: 27.4%
DDM$164.80+3219.2%
EV/EBITDA$136822872.00+2755747573.7%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $93.88M
Rev: -5.6% / EPS: —
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-4285907191.11
Current Price$4.96
Upside / Downside-86322400726.5%
Net Debt (used)$5.93B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$-4271748739.52$-3935604494.80$-3544540020.48$-3091926665.30$-2570618028.68
8.0%$-4567525635.36$-4296969927.23$-3982687423.09$-3619427508.65$-3201530658.59
9.0%$-4772487330.50$-4547205870.39$-4285907191.11$-3984288589.54$-3637713255.94
10.0%$-4922952136.18$-4730761695.09$-4508174984.25$-4251579406.90$-3957082668.71
11.0%$-5038147779.93$-4871169542.31$-4678065920.84$-4455747834.88$-4200887738.75

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative. BVPS is zero or negative.
Graham Number
Current Price$4.96
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$4.96
Implied Near-term FCF Growth27.4%
Historical Revenue Growth-5.6%
Historical Earnings Growth
Base FCF (TTM)$93.88M
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.00

Results

DDM Intrinsic Value / share$164.80
Current Price$4.96
Upside / Downside+3219.2%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $937.00M
Current: 6.5×
Default: $5.93B

Results

Implied Equity Value / share$136822872.00
Current Price$4.96
Upside / Downside+2755747573.7%
Implied EV$6.07B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$3.93B$4.93B$5.93B$6.93B$7.93B
2.5x$-1611177128.00$-2611177128.00$-3611177128.00$-4611177128.00$-5611177128.00
4.5x$262822872.00$-737177128.00$-1737177128.00$-2737177128.00$-3737177128.00
6.5x$2136822872.00$1136822872.00$136822872.00$-863177128.00$-1863177128.00
8.5x$4010822872.00$3010822872.00$2010822872.00$1010822872.00$10822872.00
10.5x$5884822872.00$4884822872.00$3884822872.00$2884822872.00$1884822872.00