MPA

MPA — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($11.54)
DCF$-4.98-143.2%
Graham Number
Reverse DCFimplied g: 40.2%
DDM$11.74+1.8%
EV/EBITDA

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

1 — Discounted Cash Flow (DCF)

Assumptions

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

Results

Intrinsic Value / share$-4.98
Current Price$11.54
Upside / Downside-143.2%
Net Debt (used)$101.27M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-2.2%1.8%5.8%9.8%13.8%
7.0%$-4.94$-4.36$-3.69$-2.91$-2.02
8.0%$-5.46$-4.99$-4.45$-3.83$-3.11
9.0%$-5.82$-5.43$-4.98$-4.46$-3.87
10.0%$-6.08$-5.75$-5.37$-4.93$-4.42
11.0%$-6.28$-5.99$-5.66$-5.28$-4.84

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$11.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$11.54
Implied Near-term FCF Growth40.2%
Historical Revenue Growth5.8%
Historical Earnings Growth
Base FCF (TTM)$2.00M
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.57

Results

DDM Intrinsic Value / share$11.74
Current Price$11.54
Upside / Downside+1.8%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: —
Current: —×
Default: $101.27M

Results

Implied Equity Value / share$-7.82
Current Price$11.54
Upside / Downside-167.8%
Implied EV$0