TRIN

TRIN — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($14.79)
DCF$38.89+163.0%
Graham Number$25.83+74.7%
Reverse DCFimplied g: 7.2%
DDM$52.53+255.2%
EV/EBITDA

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $120.11M
Rev: 17.0% / EPS: -30.5%
Computed: 6.73%
Computed WACC: 6.73%
Cost of equity (Re)7.81%(Rf 4.30% + β 0.64 × ERP 5.50%)
Cost of debt (Rd)7.34%(interest expense ÷ avg debt (SEC))
Tax rate (T)21.00%(US statutory fallback)
Equity weight (E/V)46.19%
Debt weight (D/V)53.81%

Results

Intrinsic Value / share$72.87
Current Price$14.79
Upside / Downside+392.7%
Net Debt (used)$1.28B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term9.0%13.0%17.0%21.0%25.0%
7.0%$43.01$54.18$67.00$81.65$98.32
8.0%$31.30$40.18$50.35$61.96$75.17
9.0%$23.25$30.54$38.89$48.42$59.25
10.0%$17.37$23.51$30.55$38.56$47.67
11.0%$12.91$18.18$24.21$31.08$38.88

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $2.21
Yahoo: $13.42

Results

Graham Number$25.83
Current Price$14.79
Margin of Safety+74.7%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Computed: 6.73%
Computed WACC: 6.73%
Cost of equity (Re)7.81%(Rf 4.30% + β 0.64 × ERP 5.50%)
Cost of debt (Rd)7.34%(interest expense ÷ avg debt (SEC))
Tax rate (T)21.00%(US statutory fallback)
Equity weight (E/V)46.19%
Debt weight (D/V)53.81%

Results

Current Price$14.79
Implied Near-term FCF Growth0.2%
Historical Revenue Growth17.0%
Historical Earnings Growth-30.5%
Base FCF (TTM)$120.11M
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.55

Results

DDM Intrinsic Value / share$52.53
Current Price$14.79
Upside / Downside+255.2%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: —
Current: —×
Default: $1.28B

Results

Implied Equity Value / share$-16.97
Current Price$14.79
Upside / Downside-214.8%
Implied EV$0