DealGuard — Hotel/Motel Leverage & MLQuick GlanceDocs
Welcome! DealGuard helps you evaluate acquisitions and optimize nightly pricing using WVU-aware demand signals and your own historical data.
- Set deal inputs on the left to see guardrails and Max Purchase Price (MPP).
- Use the 60-Day Event Heatmap for Occ, ADR, and RevPAR around WVU events.
- Upload your CSV under ML Admin to train and view model metrics.
Deal Inputs
Guardrails
Net Worth & Liquidity
Event & Pricing Context
Results
Equity Required
$202,800
LTV
75.0%
Annual Debt Service
$25,606
DSCR
3.51
Equity Exposure: PASSLTV: PASSDSCR: PASS
MPP (Equity-bound)
$848,214
MPP (DSCR-bound)
$1,082,557
Final MPP
$848,214
Price within MPP? Yes
Scenario Table (Down% × Rate%)
| Down / Rate | 6.0% | 7.0% | 8.0% | 9.0% |
|---|---|---|---|---|
| 20% | DSCR 3.78 MPP $1,032,609 | DSCR 3.45 MPP $1,032,609 | DSCR 3.15 MPP $971,734 | DSCR 2.90 MPP $893,712 |
| 25% | DSCR 4.03 MPP $848,214 | DSCR 3.67 MPP $848,214 | DSCR 3.37 MPP $848,214 | DSCR 3.10 MPP $848,214 |
| 30% | DSCR 4.32 MPP $719,697 | DSCR 3.94 MPP $719,697 | DSCR 3.61 MPP $719,697 | DSCR 3.32 MPP $719,697 |
| 35% | DSCR 4.65 MPP $625,000 | DSCR 4.24 MPP $625,000 | DSCR 3.88 MPP $625,000 | DSCR 3.57 MPP $625,000 |
| 40% | DSCR 5.04 MPP $552,326 | DSCR 4.59 MPP $552,326 | DSCR 4.21 MPP $552,326 | DSCR 3.87 MPP $552,326 |
ML Admin — Train RandomForest AI Model
Next-Hour Blend (/ml/ensemble)
Tip: Ensemble weights favor the heuristic on event days and the ML model otherwise.
60-Day Event Heatmap (Heuristic Preview)
| Date | Event | Occ% | ADR | RevPAR |
|---|
Legend: event day, weekend
Data source: /public/events_wvu.json.