NHPAP

NHPAP — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($19.49)
DCF$-631874910.07-3242046842.3%
Graham Number
Reverse DCFimplied g: 22.6%
DDM$37.90+94.5%
EV/EBITDA$558265111.00+2864366811.2%

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

1 — Discounted Cash Flow (DCF)

Assumptions

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

Results

Intrinsic Value / share$-631874910.07
Current Price$19.49
Upside / Downside-3242046842.3%
Net Debt (used)$991.07M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$-628789159.44$-555528513.10$-470298328.15$-371653929.32$-258037800.95
8.0%$-693251981.28$-634285967.86$-565789958.34$-486619612.46$-395541470.21
9.0%$-737922168.25$-688823408.91$-631874910.07$-566138923.08$-490604882.73
10.0%$-770715081.08$-728828313.26$-680316858.55$-624393372.91$-560209553.84
11.0%$-795821289.05$-759429371.58$-717343581.50$-668890672.00$-613345424.20

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$19.49
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$19.49
Implied Near-term FCF Growth22.6%
Historical Revenue Growth-3.7%
Historical Earnings Growth
Base FCF (TTM)$20.46M
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.84

Results

DDM Intrinsic Value / share$37.90
Current Price$19.49
Upside / Downside+94.5%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $103.99M
Current: 14.9×
Default: $991.07M

Results

Implied Equity Value / share$558265111.00
Current Price$19.49
Upside / Downside+2864366811.2%
Implied EV$1.55B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.01B-$8.93M$991.07M$1.99B$2.99B
10.9x$2142309111.00$1142309111.00$142309111.00$-857690889.00$-1857690889.00
12.9x$2350287111.00$1350287111.00$350287111.00$-649712889.00$-1649712889.00
14.9x$2558265111.00$1558265111.00$558265111.00$-441734889.00$-1441734889.00
16.9x$2766243111.00$1766243111.00$766243111.00$-233756889.00$-1233756889.00
18.9x$2974221111.00$1974221111.00$974221111.00$-25778889.00$-1025778889.00