PINE-PA

PINE-PA — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($25.28)
DCF$-4401619384.50-17411469184.2%
Graham Number
Reverse DCF
DDM$41.20+63.0%
EV/EBITDA$402826724.00+1593460042.4%

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

1 — Discounted Cash Flow (DCF)

Assumptions

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

Results

Intrinsic Value / share$-4408599401.93
Current Price$25.28
Upside / Downside-17439080012.7%
Net Debt (used)$384.10M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term14.5%18.5%22.5%26.5%30.5%
7.0%$-4814813586.25$-5607499086.08$-6512107212.59$-7540212708.96$-8704165489.00
8.0%$-3923933618.55$-4550462068.88$-5264961462.04$-6076503459.67$-6994766199.26
9.0%$-3311884906.47$-3824461056.99$-4408599401.93$-5071657962.05$-5821485796.86
10.0%$-2866810647.50$-3296688312.58$-3786234395.04$-4341565750.05$-4969206705.96
11.0%$-2529518534.38$-2896865152.26$-3314899151.97$-3788800981.54$-4324095552.06

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$25.28
Margin of Safety
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$25.28
Implied Near-term FCF Growth
Historical Revenue Growth22.5%
Historical Earnings Growth
Base FCF (TTM)-$83.62M
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: $2.00

Results

DDM Intrinsic Value / share$41.20
Current Price$25.28
Upside / Downside+63.0%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $44.45M
Current: 17.7×
Default: $384.10M

Results

Implied Equity Value / share$402826724.00
Current Price$25.28
Upside / Downside+1593460042.4%
Implied EV$786.92M
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.62B-$615.90M$384.10M$1.38B$2.38B
13.7x$2225010724.00$1225010724.00$225010724.00$-774989276.00$-1774989276.00
15.7x$2313918724.00$1313918724.00$313918724.00$-686081276.00$-1686081276.00
17.7x$2402826724.00$1402826724.00$402826724.00$-597173276.00$-1597173276.00
19.7x$2491734724.00$1491734724.00$491734724.00$-508265276.00$-1508265276.00
21.7x$2580642724.00$1580642724.00$580642724.00$-419357276.00$-1419357276.00