REGCO

REGCO — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($22.54)
DCF$6315717092549.58+28023024157528.0%
Graham Number
Reverse DCFimplied g: -10.0%
DDM$30.28+34.4%
EV/EBITDA$4610409751.74+20456524781.7%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $671.53M
Rev: 8.9% / EPS: 141.9%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$6324581161720.52
Current Price$22.54
Upside / Downside+28062354295479.5%
Net Debt (used)$4.87B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term133.9%137.9%141.9%145.9%149.9%
7.0%$8858914542594.15$9642383500207.81$10480314735297.38$11375500087310.79$12330825226362.24
8.0%$6764271837533.04$7362424829757.49$8002149783606.62$8685577451572.35$9414910190515.32
9.0%$5346313763635.98$5819024121013.13$6324581161720.52$6864668171293.38$7441024995802.23
10.0%$4331891371073.26$4714863801849.53$5124441388534.71$5561987337708.82$6028910655750.98
11.0%$3576610220228.21$3892773216047.62$4230894816574.74$4592099952860.19$4977551345432.21

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$22.54
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$22.54
Implied Near-term FCF Growth-10.0%
Historical Revenue Growth8.9%
Historical Earnings Growth141.9%
Base FCF (TTM)$671.53M
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$22.54
Upside / Downside+34.4%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $1.02B
Current: 9.3×
Default: $4.87B

Results

Implied Equity Value / share$4610409751.74
Current Price$22.54
Upside / Downside+20456524781.7%
Implied EV$9.48B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$2.87B$3.87B$4.87B$5.87B$6.87B
5.3x$2517057815.74$1517057815.74$517057815.74$-482942184.26$-1482942184.26
7.3x$4563733783.74$3563733783.74$2563733783.74$1563733783.74$563733783.74
9.3x$6610409751.74$5610409751.74$4610409751.74$3610409751.74$2610409751.74
11.3x$8657085719.74$7657085719.74$6657085719.74$5657085719.74$4657085719.74
13.3x$10703761687.74$9703761687.74$8703761687.74$7703761687.74$6703761687.74