INN-PF

INN-PF — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($17.43)
DCF$-294275071.95-1688315554.0%
Graham Number
Reverse DCFimplied g: 9.1%
DDM$30.28+73.7%
EV/EBITDA$2285430366.00+13111974966.1%

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

1 — Discounted Cash Flow (DCF)

Assumptions

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

Results

Intrinsic Value / share$-294275071.95
Current Price$17.43
Upside / Downside-1688315554.0%
Net Debt (used)$1.38B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$-284951853.98$-63603774.62$193908801.17$491950782.96$835228013.73
8.0%$-479718383.05$-301559788.06$-94607475.89$144596037.58$419777500.85
9.0%$-614683887.52$-466337993.47$-294275071.95$-95661830.15$132555031.06
10.0%$-713763661.36$-587207917.29$-440636492.35$-271670522.80$-77746966.47
11.0%$-789618996.97$-679665270.93$-552508205.47$-406113667.69$-238290497.52

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$17.43
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$17.43
Implied Near-term FCF Growth9.1%
Historical Revenue Growth1.2%
Historical Earnings Growth
Base FCF (TTM)$61.82M
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.47

Results

DDM Intrinsic Value / share$30.28
Current Price$17.43
Upside / Downside+73.7%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $209.85M
Current: 17.5×
Default: $1.38B

Results

Implied Equity Value / share$2285430366.00
Current Price$17.43
Upside / Downside+13111974966.1%
Implied EV$3.66B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$1.38B$1.38B$1.38B$1.38B$1.38B
13.5x$1446046366.00$1446046366.00$1446046366.00$1446046366.00$1446046366.00
15.5x$1865738366.00$1865738366.00$1865738366.00$1865738366.00$1865738366.00
17.5x$2285430366.00$2285430366.00$2285430366.00$2285430366.00$2285430366.00
19.5x$2705122366.00$2705122366.00$2705122366.00$2705122366.00$2705122366.00
21.5x$3124814366.00$3124814366.00$3124814366.00$3124814366.00$3124814366.00