DSWL

DSWL — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($3.50)
DCF$24.67+605.0%
Graham Number$10.91+211.7%
Reverse DCFimplied g: -20.0%
DDM$4.12+17.7%
EV/EBITDA$3.60+2.9%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $7.06M
Rev: -5.5% / EPS: 21.1%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$24.64
Current Price$3.50
Upside / Downside+604.0%
Net Debt (used)-$79.67M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term13.1%17.1%21.1%25.1%29.1%
7.0%$26.49$30.37$34.81$39.86$45.58
8.0%$22.20$25.27$28.78$32.77$37.29
9.0%$19.25$21.77$24.64$27.90$31.60
10.0%$17.11$19.22$21.63$24.37$27.46
11.0%$15.48$17.29$19.35$21.69$24.33

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.78
Yahoo: $6.78

Results

Graham Number$10.91
Current Price$3.50
Margin of Safety+211.7%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$3.50
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth-5.5%
Historical Earnings Growth21.1%
Base FCF (TTM)$7.06M
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: $0.20

Results

DDM Intrinsic Value / share$4.12
Current Price$3.50
Upside / Downside+17.7%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $5.34M
Current: -4.2×
Default: -$79.67M

Results

Implied Equity Value / share$3.60
Current Price$3.50
Upside / Downside+2.9%
Implied EV-$22.30M
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$2.08B-$1.08B-$79.67M$920.33M$1.92B
-8.2x$127.77$65.01$2.26$-60.49$-123.25
-6.2x$128.44$65.68$2.93$-59.82$-122.58
-4.2x$129.11$66.35$3.60$-59.15$-121.91
-2.2x$129.78$67.02$4.27$-58.48$-121.24
-0.2x$130.45$67.69$4.94$-57.81$-120.57