GMRE-PB

GMRE-PB — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($25.07)
DCF$722408661.54+2881566160.6%
Graham Number
Reverse DCFimplied g: -3.3%
DDM$8.03-68.0%
EV/EBITDA$430915572.00+1718849409.4%

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

1 — Discounted Cash Flow (DCF)

Assumptions

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

Results

Intrinsic Value / share$722408661.54
Current Price$25.07
Upside / Downside+2881566160.6%
Net Debt (used)$708.55M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term0.6%4.6%8.6%12.6%16.6%
7.0%$763815739.39$1054632168.09$1391533153.77$1779898349.97$2225513776.34
8.0%$493138209.86$726159524.73$995760134.20$1306190753.28$1662022341.27
9.0%$305985916.16$499176827.55$722408661.54$979156444.04$1273156314.74
10.0%$168929754.76$333059720.44$522470262.23$740072370.96$988995190.47
11.0%$64273592.54$206303433.17$370002261.69$557853743.80$772527179.72

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$25.07
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$25.07
Implied Near-term FCF Growth-3.3%
Historical Revenue Growth8.6%
Historical Earnings Growth
Base FCF (TTM)$66.02M
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.39

Results

DDM Intrinsic Value / share$8.03
Current Price$25.07
Upside / Downside-68.0%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $87.53M
Current: 13.0×
Default: $708.55M

Results

Implied Equity Value / share$430915572.00
Current Price$25.07
Upside / Downside+1718849409.4%
Implied EV$1.14B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.29B-$291.45M$708.55M$1.71B$2.71B
9.0x$2080795572.00$1080795572.00$80795572.00$-919204428.00$-1919204428.00
11.0x$2255855572.00$1255855572.00$255855572.00$-744144428.00$-1744144428.00
13.0x$2430915572.00$1430915572.00$430915572.00$-569084428.00$-1569084428.00
15.0x$2605975572.00$1605975572.00$605975572.00$-394024428.00$-1394024428.00
17.0x$2781035572.00$1781035572.00$781035572.00$-218964428.00$-1218964428.00