MGIC

MGIC — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($17.38)
DCF$52.15+200.1%
Graham Number$10.18-41.4%
Reverse DCFimplied g: -1.4%
DDM$20.81+19.7%
EV/EBITDA$17.88+2.9%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $70.09M
Rev: 13.1% / EPS: 17.6%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$52.15
Current Price$17.38
Upside / Downside+200.1%
Net Debt (used)-$7.42M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term9.6%13.6%17.6%21.6%25.6%
7.0%$56.14$66.53$78.43$92.03$107.49
8.0%$45.18$53.42$62.86$73.64$85.88
9.0%$37.63$44.40$52.15$60.99$71.03
10.0%$32.13$37.83$44.35$51.78$60.22
11.0%$27.95$32.84$38.43$44.80$52.02

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.82
Yahoo: $5.62

Results

Graham Number$10.18
Current Price$17.38
Margin of Safety-41.4%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$17.38
Implied Near-term FCF Growth-1.4%
Historical Revenue Growth13.1%
Historical Earnings Growth17.6%
Base FCF (TTM)$70.09M
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.01

Results

DDM Intrinsic Value / share$20.81
Current Price$17.38
Upside / Downside+19.7%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $76.76M
Current: 11.3×
Default: -$7.42M

Results

Implied Equity Value / share$17.88
Current Price$17.38
Upside / Downside+2.9%
Implied EV$870.70M
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$2.01B-$1.01B-$7.42M$992.58M$1.99B
7.3x$52.36$32.00$11.63$-8.74$-29.10
9.3x$55.49$35.12$14.76$-5.61$-25.98
11.3x$58.62$38.25$17.88$-2.48$-22.85
13.3x$61.75$41.38$21.01$0.64$-19.72
15.3x$64.87$44.50$24.14$3.77$-16.60