LRE

LRE — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($1.30)
DCF$-1048399.10-80646184.8%
Graham Number$4.63+256.1%
Reverse DCF
DDM$1.44+10.9%
EV/EBITDA$0.73-43.5%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: -$1.15B
Rev: 12.2% / EPS: 150.0%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-1048399.10
Current Price$1.30
Upside / Downside-80646184.8%
Net Debt (used)$10.35B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term142.0%146.0%150.0%154.0%158.0%
7.0%$-1478260.68$-1604363.37$-1738934.88$-1882394.84$-2035176.55
8.0%$-1128229.97$-1224435.16$-1327100.24$-1436545.25$-1553100.65
9.0%$-891351.97$-967325.30$-1048399.10$-1134826.04$-1226866.99
10.0%$-721944.90$-783449.80$-849083.03$-919049.08$-993559.08
11.0%$-595860.75$-646597.84$-700739.81$-758455.29$-819918.38

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.40
Yahoo: $2.38

Results

Graham Number$4.63
Current Price$1.30
Margin of Safety+256.1%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Reverse DCF requires positive TTM free cash flow.
Current Price$1.30
Implied Near-term FCF Growth
Historical Revenue Growth12.2%
Historical Earnings Growth150.0%
Base FCF (TTM)-$1.15B
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.07

Results

DDM Intrinsic Value / share$1.44
Current Price$1.30
Upside / Downside+10.9%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $1.59B
Current: 6.5×
Default: $10.35B

Results

Implied Equity Value / share$0.73
Current Price$1.30
Upside / Downside-43.5%
Implied EV$10.36B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$4.35B$7.35B$10.35B$13.35B$16.35B
2.5x$-24.31$-244.22$-464.14$-684.05$-903.96
4.5x$208.12$-11.79$-231.70$-451.61$-671.52
6.5x$440.56$220.65$0.73$-219.18$-439.09
8.5x$672.99$453.08$233.17$13.26$-206.65
10.5x$905.43$685.52$465.61$245.69$25.78