Deal Margin & ROI Modeler
Model Every Deal's Profit Before You Commit
Dynamic ROI modeling with holding cost scenarios, exit strategy comparisons, and live sensitivity analysis for every investment variable.
Ready to model your deal margins with AI?
Book a Free Consultation
Knowing the After Repair Value of a property is necessary but not sufficient for making a sound investment decision. You also need to know: what is the total capital at risk, what are the costs between acquisition and sale, what is the actual net profit after all expenses, and how does that profit compare to the time and capital invested? These questions require a complete deal model — not just an ARV estimate.
The Deal Margin & ROI Scenario Modeler takes every financial input of a deal — purchase price, ARV, rehab cost, holding costs, financing structure, and closing costs — and models three distinct exit scenarios: wholesale assignment (immediate resale at a markup without renovation), fix-and-flip (renovation and retail sale at ARV), and buy-and-hold rental (retain as a cash-flowing rental asset). For each exit strategy, the tool calculates gross profit, net profit, total investment, ROI percentage, annualized return, and break-even timeline.
The most important output of this tool is the Go/No-Go recommendation. Every scenario receives a color-coded signal based on the net ROI:
RED: ROI < 15% — Do not proceed. Insufficient margin for the risk and capital involved.
YELLOW: ROI 15–25% — Acceptable but marginal. Proceed only with high confidence in all inputs.
GREEN: ROI > 25% — Target deal. Proceed.
Conservative bias is applied throughout the model. The tool assumes a worst-case holding period (+30% over the projected timeline), uses the conservative ARV from the ARV Calculator (or applies a conservative reduction to user-input ARV), adds a 10% cost overrun buffer on rehab costs, and uses actual carrying costs rather than simplified estimates.
The model is designed for investors who need to make fast, confident decisions with full transparency into their numbers. It can run from a set of manually entered inputs, or it can receive ARV and rehab cost data automatically from the ARV Calculator and Rehab Cost Estimator when the full pipeline is connected.
Input Parameters
Parameter | Type | Required | Description |
|---|---|---|---|
| Integer | Yes | Agreed purchase price or target offer price |
| Integer | Yes | After Repair Value (from ARV Calculator or manual entry) |
| Integer | Yes | Total rehab estimate including contingency (from Rehab Estimator or manual) |
| Integer | Yes | Estimated months from purchase to sale (flip scenario) |
| Integer | Yes | Monthly carrying costs: taxes + insurance + utilities + loan interest |
| Float | No | Closing costs at purchase as % of purchase price; default |
| Float | No | Closing costs at sale (agent, title, taxes) as % of sale price; default |
| String | Yes |
|
| Integer | No | Loan amount (if financed); default 0 for cash |
| Float | No | Annual interest rate on loan; required if financed |
| Float | No | Loan origination points as % of loan; default |
| Integer | No | Expected assignment fee for wholesale scenario; default |
| Integer | No | Monthly rent for buy-and-hold scenario |
| Float | No | Additional buffer added to rehab costs; default |
| Float | No | Additional buffer on holding period; default |
| Float | No | Reduction applied to input ARV for conservative modeling; default |
| String | Yes |
|
Processing Methodology
Step 1 — Input Normalization and Conservative Adjustments.
The AI applies three conservative adjustments to all inputs before modeling:
```
Conservative ARV = Input ARV × (1 − ARV Reduction %) [default: ARV × 0.95]
Conservative Rehab = Input Rehab Cost × (1 + Cost Overrun Buffer %) [default: Rehab × 1.10]
Conservative Holding Period = Input Holding Period × (1 + Holding Period Buffer %) [default: Holding × 1.30]
```
Step 2 — Common Cost Calculations.
For all three scenarios, the following costs are calculated:
```
Purchase Closing Costs = Purchase Price × Purchase Closing Costs %
Acquisition Total = Purchase Price + Purchase Closing Costs + Origination Points
Total Rehab Cost (Conservative) = Conservative Rehab
```
Step 3 — Scenario Modeling.
Scenario A: Wholesale Assignment
```
Gross Revenue = Purchase Price + Assignment Fee
Total Investment = Purchase Price + Purchase Closing Costs (no rehab)
Gross Profit = Assignment Fee
Net Profit = Assignment Fee − Transaction Costs
ROI = Net Profit ÷ Total Capital at Risk
Annualized Return = ROI (typically 1–4 week close; annualized very high)
```
Scenario B: Fix-and-Flip
```
Total Investment = Purchase Price + Purchase Closing Costs + Conservative Rehab + (Monthly Holding Costs × Conservative Holding Period) + Loan Interest
Sale Revenue = Conservative ARV
Sale Closing Costs = Conservative ARV × Sale Closing Costs %
Gross Profit = Sale Revenue − Sale Closing Costs − Total Investment
Net Profit = Gross Profit
ROI % = Net Profit ÷ Total Investment
Annualized ROI % = ROI % ÷ (Conservative Holding Period ÷ 12)
Break-Even Sale Price = Total Investment + Sale Closing Costs
```
Scenario C: Buy-and-Hold Rental
```
Stabilized Monthly Cash Flow = Target Rent − PITI − Management (8%) − Maintenance (8%) − Vacancy (10%)
Year 1 Net Operating Income (NOI) = Stabilized Monthly Cash Flow × 12
Cash-on-Cash Return = Annual Cash Flow ÷ Total Cash Invested
Total Cash Invested = Down Payment + Rehab + Closing Costs
Cap Rate = NOI ÷ (Purchase Price + Rehab)
Equity Position at Stabilization = ARV − (Loan Balance)
```
Step 4 — Go/No-Go Classification.
Signal | Condition | Meaning |
|---|---|---|
🔴 RED | ROI < 15% | Insufficient margin |
🟡 YELLOW | ROI 15–25% | Marginal — proceed with caution |
🟢 GREEN | ROI > 25% | Target return achieved |
Output Format
Scenario Comparison Table:
Metric | Wholesale | Fix & Flip | Buy & Hold |
|---|---|---|---|
Purchase Price | $165,000 | $165,000 | $165,000 |
Rehab Cost (Conservative) | $0 | $98,582 | $98,582 |
Holding Costs (Total) | $0 | $18,720 | Ongoing |
Purchase Closing Costs | $4,950 | $4,950 | $4,950 |
Sale Closing Costs | N/A | $26,510 | N/A |
Total Investment | $169,950 | $313,762 | $268,532 |
Sale Price / Value | $180,950 | $331,375 | $331,375 ARV |
Gross Revenue | $180,950 | $331,375 | N/A |
Net Profit | $11,000 | $17,613 | N/A |
ROI % | 6.5% | 5.6% | 3.2% CoC |
Go/No-Go | 🔴 RED | 🔴 RED | 🟡 YELLOW |
Recommended Action | Offer too high | Offer too high | Marginal rental |
Note: This example illustrates a deal where the purchase price is too high for both wholesale and flip — the tool correctly identifies this. The investor needs to reduce the offer by ~$30,000 to achieve GREEN status on the flip scenario.
Price Sensitivity Table (Flip Scenario):
Purchase Price | Total Investment | Net Profit | ROI % | Signal |
|---|---|---|---|---|
$165,000 | $313,762 | $17,613 | 5.6% | 🔴 RED |
$155,000 | $303,762 | $27,613 | 9.1% | 🔴 RED |
$145,000 | $293,762 | $37,613 | 12.8% | 🔴 RED |
$135,000 | $283,762 | $47,613 | 16.8% | 🟡 YELLOW |
$125,000 | $273,762 | $57,613 | 21.0% | 🟡 YELLOW |
$115,000 | $263,762 | $67,613 | 25.6% | 🟢 GREEN |
The price sensitivity table is automatically generated and shows the exact offer price required to achieve each ROI tier.
Conservative Bias Methodology
+30% Holding Period Buffer. Projects take longer than planned — contractors are delayed, permits take extra weeks, the market softens and the listing sits. A 30% buffer on the holding period increases the total carrying costs and reduces the modeled profit to a more realistic level.
+10% Rehab Cost Overrun Buffer. Applied on top of the already-conservative 85th-percentile estimate from the Rehab Cost Estimator. This double layer of conservatism is intentional. Even with a well-prepared scope of work, unexpected conditions during demo and construction consistently add cost.
−5% ARV Conservative Reduction. Applied to the input ARV to account for the gap between the estimated value at time of analysis and the actual sale price at time of closing, which may be months in the future under different market conditions.
GREEN Threshold at 25% (Not 20%). The minimum threshold for a GREEN signal is 25% ROI — not 10% or 15%. Many investors use 20% as their benchmark. Hawary AI uses 25% as the GREEN threshold because the conservative adjustments already reduce the modeled return from what a more optimistic analysis would show, and because real estate investing carries risks that demand meaningful margin protection.
CRM Integration
Creates or updates Deal record with scenario comparison results
Populates:
FlipROI,FlipSignal,WholesaleSignal,HoldCoC,Recommended_OfferGenerates task: "Review deal model before submitting offer" — assigned to acquisition manager
Price sensitivity table attached as note
Parameter | Type | Required | Description |
|---|---|---|---|
| Integer | Yes | Agreed purchase price or target offer price |
| Integer | Yes | After Repair Value (from ARV Calculator or manual entry) |
| Integer | Yes | Total rehab estimate including contingency (from Rehab Estimator or manual) |
| Integer | Yes | Estimated months from purchase to sale (flip scenario) |
| Integer | Yes | Monthly carrying costs: taxes + insurance + utilities + loan interest |
| Float | No | Closing costs at purchase as % of purchase price; default |
| Float | No | Closing costs at sale (agent, title, taxes) as % of sale price; default |
| String | Yes |
|
| Integer | No | Loan amount (if financed); default 0 for cash |
| Float | No | Annual interest rate on loan; required if financed |
| Float | No | Loan origination points as % of loan; default |
| Integer | No | Expected assignment fee for wholesale scenario; default |
| Integer | No | Monthly rent for buy-and-hold scenario |
| Float | No | Additional buffer added to rehab costs; default |
| Float | No | Additional buffer on holding period; default |
| Float | No | Reduction applied to input ARV for conservative modeling; default |
| String | Yes |
|
Parameter | Type | Required | Description |
|---|---|---|---|
| Integer | Yes | Agreed purchase price or target offer price |
| Integer | Yes | After Repair Value (from ARV Calculator or manual entry) |
| Integer | Yes | Total rehab estimate including contingency (from Rehab Estimator or manual) |
| Integer | Yes | Estimated months from purchase to sale (flip scenario) |
| Integer | Yes | Monthly carrying costs: taxes + insurance + utilities + loan interest |
| Float | No | Closing costs at purchase as % of purchase price; default |
| Float | No | Closing costs at sale (agent, title, taxes) as % of sale price; default |
| String | Yes |
|
| Integer | No | Loan amount (if financed); default 0 for cash |
| Float | No | Annual interest rate on loan; required if financed |
| Float | No | Loan origination points as % of loan; default |
| Integer | No | Expected assignment fee for wholesale scenario; default |
| Integer | No | Monthly rent for buy-and-hold scenario |
| Float | No | Additional buffer added to rehab costs; default |
| Float | No | Additional buffer on holding period; default |
| Float | No | Reduction applied to input ARV for conservative modeling; default |
| String | Yes |
|
Processing Methodology
Step 1 — Input Normalization and Conservative Adjustments.
The AI applies three conservative adjustments to all inputs before modeling:
```
Conservative ARV = Input ARV × (1 − ARV Reduction %) [default: ARV × 0.95]
Conservative Rehab = Input Rehab Cost × (1 + Cost Overrun Buffer %) [default: Rehab × 1.10]
Conservative Holding Period = Input Holding Period × (1 + Holding Period Buffer %) [default: Holding × 1.30]
```
Step 2 — Common Cost Calculations.
For all three scenarios, the following costs are calculated:
```
Purchase Closing Costs = Purchase Price × Purchase Closing Costs %
Acquisition Total = Purchase Price + Purchase Closing Costs + Origination Points
Total Rehab Cost (Conservative) = Conservative Rehab
```
Step 3 — Scenario Modeling.
Scenario A: Wholesale Assignment
```
Gross Revenue = Purchase Price + Assignment Fee
Total Investment = Purchase Price + Purchase Closing Costs (no rehab)
Gross Profit = Assignment Fee
Net Profit = Assignment Fee − Transaction Costs
ROI = Net Profit ÷ Total Capital at Risk
Annualized Return = ROI (typically 1–4 week close; annualized very high)
```
Scenario B: Fix-and-Flip
```
Total Investment = Purchase Price + Purchase Closing Costs + Conservative Rehab + (Monthly Holding Costs × Conservative Holding Period) + Loan Interest
Sale Revenue = Conservative ARV
Sale Closing Costs = Conservative ARV × Sale Closing Costs %
Gross Profit = Sale Revenue − Sale Closing Costs − Total Investment
Net Profit = Gross Profit
ROI % = Net Profit ÷ Total Investment
Annualized ROI % = ROI % ÷ (Conservative Holding Period ÷ 12)
Break-Even Sale Price = Total Investment + Sale Closing Costs
```
Scenario C: Buy-and-Hold Rental
```
Stabilized Monthly Cash Flow = Target Rent − PITI − Management (8%) − Maintenance (8%) − Vacancy (10%)
Year 1 Net Operating Income (NOI) = Stabilized Monthly Cash Flow × 12
Cash-on-Cash Return = Annual Cash Flow ÷ Total Cash Invested
Total Cash Invested = Down Payment + Rehab + Closing Costs
Cap Rate = NOI ÷ (Purchase Price + Rehab)
Equity Position at Stabilization = ARV − (Loan Balance)
```
Step 4 — Go/No-Go Classification.
Signal | Condition | Meaning |
|---|---|---|
🔴 RED | ROI < 15% | Insufficient margin |
🟡 YELLOW | ROI 15–25% | Marginal — proceed with caution |
🟢 GREEN | ROI > 25% | Target return achieved |
Output Format
Scenario Comparison Table:
Metric | Wholesale | Fix & Flip | Buy & Hold |
|---|---|---|---|
Purchase Price | $165,000 | $165,000 | $165,000 |
Rehab Cost (Conservative) | $0 | $98,582 | $98,582 |
Holding Costs (Total) | $0 | $18,720 | Ongoing |
Purchase Closing Costs | $4,950 | $4,950 | $4,950 |
Sale Closing Costs | N/A | $26,510 | N/A |
Total Investment | $169,950 | $313,762 | $268,532 |
Sale Price / Value | $180,950 | $331,375 | $331,375 ARV |
Gross Revenue | $180,950 | $331,375 | N/A |
Net Profit | $11,000 | $17,613 | N/A |
ROI % | 6.5% | 5.6% | 3.2% CoC |
Go/No-Go | 🔴 RED | 🔴 RED | 🟡 YELLOW |
Recommended Action | Offer too high | Offer too high | Marginal rental |
Note: This example illustrates a deal where the purchase price is too high for both wholesale and flip — the tool correctly identifies this. The investor needs to reduce the offer by ~$30,000 to achieve GREEN status on the flip scenario.
Price Sensitivity Table (Flip Scenario):
Purchase Price | Total Investment | Net Profit | ROI % | Signal |
|---|---|---|---|---|
$165,000 | $313,762 | $17,613 | 5.6% | 🔴 RED |
$155,000 | $303,762 | $27,613 | 9.1% | 🔴 RED |
$145,000 | $293,762 | $37,613 | 12.8% | 🔴 RED |
$135,000 | $283,762 | $47,613 | 16.8% | 🟡 YELLOW |
$125,000 | $273,762 | $57,613 | 21.0% | 🟡 YELLOW |
$115,000 | $263,762 | $67,613 | 25.6% | 🟢 GREEN |
The price sensitivity table is automatically generated and shows the exact offer price required to achieve each ROI tier.
Conservative Bias Methodology
+30% Holding Period Buffer. Projects take longer than planned — contractors are delayed, permits take extra weeks, the market softens and the listing sits. A 30% buffer on the holding period increases the total carrying costs and reduces the modeled profit to a more realistic level.
+10% Rehab Cost Overrun Buffer. Applied on top of the already-conservative 85th-percentile estimate from the Rehab Cost Estimator. This double layer of conservatism is intentional. Even with a well-prepared scope of work, unexpected conditions during demo and construction consistently add cost.
−5% ARV Conservative Reduction. Applied to the input ARV to account for the gap between the estimated value at time of analysis and the actual sale price at time of closing, which may be months in the future under different market conditions.
GREEN Threshold at 25% (Not 20%). The minimum threshold for a GREEN signal is 25% ROI — not 10% or 15%. Many investors use 20% as their benchmark. Hawary AI uses 25% as the GREEN threshold because the conservative adjustments already reduce the modeled return from what a more optimistic analysis would show, and because real estate investing carries risks that demand meaningful margin protection.
CRM Integration
Creates or updates Deal record with scenario comparison results
Populates:
FlipROI,FlipSignal,WholesaleSignal,HoldCoC,Recommended_OfferGenerates task: "Review deal model before submitting offer" — assigned to acquisition manager
Price sensitivity table attached as note
Creates or updates Deal record with scenario comparison results
Populates:
FlipROI,FlipSignal,WholesaleSignal,HoldCoC,Recommended_OfferGenerates task: "Review deal model before submitting offer" — assigned to acquisition manager
Price sensitivity table attached as note
Never overpay again. The price sensitivity table tells you exactly what you need to offer to hit your target return — removing guesswork from the negotiation.
Evaluate all exit strategies simultaneously. A property that does not work as a flip might work as a wholesale deal or a rental. The three-scenario model surfaces all options in one pass.
Defend your offer to sellers and partners. A structured, transparent deal model is far more persuasive than a rough estimate when negotiating with sellers or presenting to JV partners.
Document your investment decisions. Every deal model is saved to your CRM, creating an audit trail of why each offer was made at a specific price.
Who This Is For
Investors who make multiple offers per week and need fast, consistent deal modeling
Acquisition managers who review deals from multiple markets or team members
JV partners and private money lenders who need to see transparent deal analysis before committing capital
Wholesalers who want to price their deals so that both they and their buyers make money