HPP-PC

HPP-PC — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($13.61)
DCF$14316115794.45+105188212937.9%
Graham Number
Reverse DCFimplied g: -4.0%
DDM$24.51+80.1%
EV/EBITDA$1395156624.51+10250967016.2%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $351.09M
Rev: 23.6% / EPS: —
Default: 9% (no SEC data)

Results

Intrinsic Value / share$14316115794.45
Current Price$13.61
Upside / Downside+105188212937.9%
Net Debt (used)$3.62B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term15.6%19.6%23.6%27.6%31.6%
7.0%$16217529382.71$19737910279.39$23750936804.57$28307095012.52$33460221778.18
8.0%$12208960319.64$14989173751.90$18156373906.91$21750109081.98$25812547991.31
9.0%$9456007751.03$11728751804.75$14316115794.45$17250161545.00$20565071589.25
10.0%$7454896328.81$9359471026.94$11526225072.01$13981799247.82$16754593384.77
11.0%$5939044080.48$7565327966.99$9414204436.75$11508225375.49$13871429080.72

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$13.61
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$13.61
Implied Near-term FCF Growth-4.0%
Historical Revenue Growth23.6%
Historical Earnings Growth
Base FCF (TTM)$351.09M
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: $1.19

Results

DDM Intrinsic Value / share$24.51
Current Price$13.61
Upside / Downside+80.1%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $296.19M
Current: 16.9×
Default: $3.62B

Results

Implied Equity Value / share$1395156624.51
Current Price$13.61
Upside / Downside+10250967016.2%
Implied EV$5.02B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$1.62B$2.62B$3.62B$4.62B$5.62B
12.9x$2210384656.51$1210384656.51$210384656.51$-789615343.49$-1789615343.49
14.9x$2802770640.51$1802770640.51$802770640.51$-197229359.49$-1197229359.49
16.9x$3395156624.51$2395156624.51$1395156624.51$395156624.51$-604843375.49
18.9x$3987542608.51$2987542608.51$1987542608.51$987542608.51$-12457391.49
20.9x$4579928592.51$3579928592.51$2579928592.51$1579928592.51$579928592.51