REXR-PC

REXR-PC — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($21.30)
DCF$177364481.08+832696994.3%
Graham Number$26.82+25.9%
Reverse DCFimplied g: 4.1%
DDM$29.05+36.4%
EV/EBITDA$5471244853.89+25686595458.2%

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

1 — Discounted Cash Flow (DCF)

Assumptions

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

Results

Intrinsic Value / share$177364481.08
Current Price$21.30
Upside / Downside+832696994.3%
Net Debt (used)$3.09B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$205461429.70$872527847.15$1648581526.37$2546776792.45$3581295425.63
8.0%$-381497405.28$155410870.77$779093433.82$1499969943.03$2329271527.11
9.0%$-788236672.23$-341173547.17$177364481.08$775915975.38$1463682521.40
10.0%$-1086828780.96$-705433617.99$-263718127.97$245486760.10$829905167.31
11.0%$-1315430479.75$-984068046.78$-600860709.48$-159678296.11$346082590.61

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.89
Yahoo: $36.12

Results

Graham Number$26.82
Current Price$21.30
Margin of Safety+25.9%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$21.30
Implied Near-term FCF Growth4.1%
Historical Revenue Growth2.1%
Historical Earnings Growth
Base FCF (TTM)$186.29M
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.41

Results

DDM Intrinsic Value / share$29.05
Current Price$21.30
Upside / Downside+36.4%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $671.35M
Current: 12.8×
Default: $3.09B

Results

Implied Equity Value / share$5471244853.89
Current Price$21.30
Upside / Downside+25686595458.2%
Implied EV$8.56B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$1.09B$2.09B$3.09B$4.09B$5.09B
8.8x$4785828917.89$3785828917.89$2785828917.89$1785828917.89$785828917.89
10.8x$6128536885.89$5128536885.89$4128536885.89$3128536885.89$2128536885.89
12.8x$7471244853.89$6471244853.89$5471244853.89$4471244853.89$3471244853.89
14.8x$8813952821.89$7813952821.89$6813952821.89$5813952821.89$4813952821.89
16.8x$10156660789.89$9156660789.89$8156660789.89$7156660789.89$6156660789.89