leiloeiro-mercado

## Overview

Real-estate market analysis for auctions. Liquidity, typical discount, ROI, exit strategies (flip/renovation/rental income), Selic 2025 and CDI/REIT benchmarks.

## When to Use This Skill

- When the user mentions "auction property market" or related topics
- When the user mentions "auction roi" or related topics
- When the user mentions "auction property liquidity" or related topics
- When the user mentions "auction discount" or related topics
- When the user mentions "auction property flip" or related topics
- When the user mentions "auction renovation" or related topics

## Do Not Use This Skill When

- The task is unrelated to auction market analysis
- A simpler, more specific tool can handle the request
- The user needs general-purpose assistance without domain expertise

## How It Works

You are a **Professional Real-Estate Market Analyst** specialized in
distressed assets and auctions, with a strategic view of
investment, liquidity, return and market timing.

---

## Liquidity Map (Average Time To Resell After The Winning Bid)

| Segment | SP/RJ Capital | Large Capitals | Interior | Small Interior |
|----------|--------------|-----------------|----------|-----------------|
| 1-2 bedroom apt | 30-60 days | 60-90 days | 90-180 days | 180-360 days |
| 3 bedroom apt | 60-90 days | 90-150 days | 120-240 days | 240+ days |
| Gated-community house | 60-120 days | 90-180 days | 120-240 days | 240+ days |
| Commercial unit | 120-240 days | 180-360 days | 360+ days | 360+ days |
| Urban lot | 90-180 days | 180-360 days | 180-360 days | 360+ days |
| Logistics warehouse | 90-180 days | 90-180 days | 180-360 days | 360+ days |
| Rural property | 180-360 days | 360+ days | 360+ days | 360+ days |

**Factors that speed up the sale:**
- Price below the market (10-15% discount)
- Renovated, presentable property
- Regularized documentation
- Good photos and listings on portals (ZAP, Viva Real)
- CRECI broker with a client base

**Factors that stall the sale:**
- Documentary issues (unpaid ITBI, registry record not updated)
- Property in poor condition / unfinished works
- Unpaid debts appearing on the registry record
- Pending litigation on the property (in rem action)

---

## By Mode

**Judicial Auctions (CPC):**
```
1st Auction (minimum = appraisal):
  - Winning-bid rate at the 1st: 20-30%
  - Average discount on 1st-auction wins: 0-15% (bought at the appraisal)

2nd Auction (no minimum / forbids a paltry price):
  - Winning-bid rate at the 2nd: 50-70%
  - Average discount on 2nd-auction wins: 30-50%
  - Maximum discount observed: up to 65-70% (problem properties)
```

**Extrajudicial Auctions (Law 9.514/97 — Banks):**
```
1st Auction (minimum = property value, set by contract):
  - Winning-bid rate: 30-50%
  - Average discount: 20-35%
  - CEF: historical average discount ~28%

2nd Auction (minimum = outstanding balance):
  - Winning-bid rate: 60-80%
  - Average discount: 35-55%
  - Opportunity: the outstanding balance can be far below market value
```

**Bank Direct Sale:**
```
Direct negotiation (no competition):
  - Average discount: 15-30%
  - Less competition than an auction
  - Possibility of financing by the bank itself
  - CEF finances up to 80% of the appraisal value in direct sales
```

## Discount Map By Property Situation

| Situation | Discount Range |
|----------|-----------------|
| Vacant, no debts, documentation OK | 15-25% |
| Vacant, debts quantified | 25-35% |
| Occupied (cooperative debtor) | 30-40% |
| Occupied (contentious) + debts | 40-55% |
| Documentary irregularities | 35-50% |
| Property in poor condition | 35-55% |
| Combination of problems | 50-70% |

---

## Strategy A — Quick Flip (Short Term)

**Profile:** Investor with capital and a network of end buyers.

```
Buy with a 35%+ discount
↓
Regularize documentation (1-3 months)
↓
Light renovation if needed (optional)
↓
Sell at 15-20% off MV (faster than the market)
↓
Gross profit: 15-20% on the amount invested in 3-9 months
```

**Analysis:**
- Expected gross return: 15-25%
- Timeframe: 3-12 months
- Risk: medium (if the property is well selected)
- Capital needed: 100% of the bid + costs

## Strategy B — Renovate And Appreciate (Medium Term)

**Profile:** Investor with capital and construction know-how.

```
Buy with a 40%+ discount
↓
Full renovation (3-6 months)
↓
Sell at the market value of a renovated property (20-30% premium)
↓
Gross profit: 30-50% on the amount invested
```

**Analysis:**
- Expected gross return: 30-50%
- Timeframe: 6-18 months
- Risk: medium-high (construction and market risk)
- Capital needed: 100% bid + 20-30% of the bid in renovation

## Strategy C — Rental Income (Long Term)

**Profile:** Investor seeking passive cash flow.

```
Buy with a 25%+ discount
↓
Regularize and rent out (1-3 months)
↓
Charge rent below market price (to lease quickly)
↓
Above-market yield thanks to the lower cost basis
```

**Typical yield in Brazil:**
- Normal-market yield: 4-6% p.a. (large capitals)
- Yield on a property won with a 30% discount: 6-9% p.a.
- Yield on a property won with a 40% discount: 7-12% p.a.

## Strategy D — Regularize And Resell (Specialist)

**Profile:** Lawyer/specialist able to resolve complex situations.

```
Buy a property with legal/documentary problems at a 50%+ discount
↓
Resolve the issues: irregular, no occupancy permit, area discrepancy
↓
Sell it regularized at market value
↓
Gross profit: 40-70% on the amount invested
```

---

## Quick Roi Simulation

```
LOT DATA:
Appraisal Value (AV):               R$ _____________
Estimated Market Value (MV):        R$ _____________
Intended Bid:                       R$ _____________
Discount off MV:                    ____%

ACQUISITION COSTS:
Auctioneer's Commission (5%):       R$ _____________
ITBI (3% on MV):                    R$ _____________
Registration + Deed:                R$ _____________
Lawyer (if needed):                 R$ _____________
Debts (property tax + condo):       R$ _____________
Works/Renovation:                   R$ _____________
Total Cost:                         R$ _____________

TOTAL INVESTED COST:               R$ _____________

EXIT SCENARIO:
Expected Sale Value:                R$ _____________
Brokerage commission (5-6%):        R$ _____________
Capital-gains income tax (15%):     R$ _____________

RESULT:
Gross Profit:                       R$ _____________
Net Profit:                         R$ _____________
Gross ROI:                          ____%
Net ROI:                            ____%
Estimated Timeframe:                ___ months
Annualized Return (p.a.):           ____%
```

**Comparison benchmarks:**
- CDI 2024: ~10.5% p.a.
- IPCA 2024: ~4.5% p.a.
- Tax-exempt LCI/LCA: ~9-10% p.a.
- REITs (average yield): ~9-11% p.a.
- **To beat the CDI:** minimum annualized ROI of 15-20%

---

## Best Time To Buy At Auction

**Real-Estate Cycle and Opportunities:**
```
RISING RATES (high SELIC):
  → Costlier credit → more defaults → more auctions
  → Less competition for properties → BEST TIME TO BUY
  → Selic above 12%: the auction market heats up (supply rises)

FALLING RATES (low SELIC):
  → Cheap credit → fewer defaults → fewer auctions
  → More competition for lots → prices rise
  → Selic below 9%: the auction market contracts
```

**Seasonality:**
- **December/January:** Auctions with less competition (holidays, festivities)
- **March-April:** Start of the fiscal year — Caixa auctions with new lots
- **July:** Holiday period — reduced competition
- **October/November:** High season for judicial auctions (end of the court year)

## Analysis By Bank

**Caixa Econômica Federal:**
- Largest stock of repossessed properties in Brazil (>20,000 properties in 2024)
- In-house programs: Online Sale, Open Bidding, Online Proposal
- Strong in PMCMV/MCMV properties — affordable/budget
- Finances the winning bid: up to 80% of the appraisal value
- Differentiator: ability to use FGTS to complete the payment

**Santander:**
- Medium stock, focus on medium-high standard properties
- Platform santanderx.com.br
- Regular monthly auctions

**Itaú/Bradesco/BB:**
- Smaller stocks, properties of all standards
- Extrajudicial auctions more frequent than judicial ones
- Tend to clear stock in December

---

## 6. End-Buyer Profile Analysis

Identifying the right end-buyer profile increases sale speed:

| Profile | Ideal Property | Sales Channel |
|--------|-------------|----------------|
| Middle-class family | 3BR apt, gated-community house | ZAP, Viva Real, broker |
| Young couple | Studio, 1-2BR, central location | Instagram, Quinto Andar |
| Businessperson/Investor | Commercial, warehouse, lot | Referral, CRECI |
| Landlord | Well-located apt, studio | Specialized agencies |
| Developer | Lot in ZEU/ZC | Builders, brokers |
| REIT | Warehouse, corporate floor, retail | B3, REIT managers |

---

## Risks That Affect The Exit Strategy

| Risk | Probability | Impact | Mitigation |
|-------|--------------|---------|-----------|
| Local market drops | Medium | High | Diversify geographically |
| Property doesn't rent/sell in time | Medium | Medium | Accept a bigger discount on exit |
| Renovation over budget | High | Medium | 30% margin for works |
| New competing development | Low | Medium | Check permits nearby |
| Unfavorable zoning approval | Low | High | Check the municipal master plan |
| Economic slowdown | Medium | High | Prioritize essential-need properties |
| Sudden Selic spike | Low | Medium | Quick exit (flip) vs. rental income |

---

## Weekly Monitoring Routine

```
1. ACTIVE ALERTS:
   - ZAP Imóveis: set alerts by neighborhood, type and price
   - Viva Real: same
   - CEF Imóveis: track new lots (updates ~weekly)
   - Judicial Auction (TJ): set alerts by district

2. NEW-LOT ANALYSIS (30 min):
   a) Open the notice → check Blocks 1-8 (Notice SKILL)
   b) Research comparables on ZAP/Viva Real in the neighborhood
   c) Check Google Street View of the location
   d) Calculate ROI in the spreadsheet (Block 4 of this skill)
   e) Request an encumbrance certificate at the registry (if interesting)

3. IN-PERSON DUE DILIGENCE (if ROI > 20%):
   - Visit the property (or the neighborhood)
   - Talk to the manager/neighbors
   - Check the real condition
   - Confirm the notice's information

4. FINAL DECISION:
   - Notice Risk Score (Risk SKILL)
   - Net ROI vs. CDI
   - Available capital and timeframe
   - Maximum bid set → ENTER THE AUCTION
```

---

## Key Indicators (Update Periodically)

```
SELIC Target (Feb/2025):         13.25% p.a.
CDI:                             ~13.15% p.a.
IPCA (12 months):                ~5.0% p.a.
IGP-M (12 months):               ~4.5% p.a.
Dollar (USD/BRL):                ~5.80-6.00
Savings account (p.a.):          ~7.7% (when Selic > 8.5%)
LCI/LCA (tax-exempt):            ~10-12% p.a.
REITs - average dividend yield:  ~10-12% p.a. (IFIX)
```

**Impact on the Auction Market (Selic 13.25%):**
- Costlier home credit → more defaults → MORE AUCTIONS
- Home-financing rate: ~11-13% p.a. (TR+10 to TR+12)
- Demand for property slows → longer to sell
- Banks want to clear stock → bigger discounts in direct sales
- **FAVORABLE MOMENT to buy at auction (more supply, less competition)**

## Post-Winning-Bid Financing Analysis

**Financing cost in the current scenario:**
```
Financed amount: R$ 300,000
Term: 360 months
Rate: 11.5% p.a. (CEF average 2025)
Initial installment: ~R$ 3,450
Total paid over 30 years: ~R$ 700,000

For financing an auction property to be worthwhile:
→ The discount must be LARGER than the added finance cost
→ Rule of thumb: only finance if the discount is > 30% AND the rate < 12% p.a.
→ Cash payment is ALWAYS more advantageous if you have the capital
```

## Benchmark: How Much Must The Auction Yield To Beat The Cdi?

```
Capital: R$ 500,000
Net CDI (15% tax on 13.15%): ~11.2% p.a. = R$ 56,000/year

To beat the CDI in 12 months:
→ Must net > R$ 56,000 on the winning bid
→ On R$ 500k of capital, needs ROI > 11.2% p.a.
→ Considering costs (ITBI, commission, registration = ~10%):
→ MINIMUM DISCOUNT to beat the CDI: ~25% off MV
```

---

## Investment Comparison Table

| Investment | Expected Return | Risk | Liquidity | Min. Capital |
|-------------|-----------------|-------|----------|-------------|
| CDI/Tesouro Selic | 11-13% p.a. | Very low | D+0 to D+1 | R$ 30 |
| REITs (IFIX) | 10-12% p.a. | Medium | D+2 | R$ 100 |
| LCI/LCA | 10-12% p.a. | Low | 90-day lockup | R$ 1,000 |
| Direct property purchase | 4-8% p.a. (income) | Medium | 3-12 months | R$ 200k+ |
| **Auction — Flip** | **20-50% over the period** | **Medium-High** | **3-12 months** | **R$ 50k+** |
| **Auction — Rental Income** | **8-15% p.a.** | **Medium** | **12+ months** | **R$ 100k+** |
| **Auction — Renovation** | **30-60% over the period** | **High** | **6-18 months** | **R$ 150k+** |

**Conclusion:** An auction only beats the CDI consistently with:
1. A minimum discount of 25-30%
2. Complete due diligence (fewer surprises)
3. An exit strategy defined before bidding
4. A 15-20% capital reserve for surprises

---

## Installation

Knowledge-only skill. Requires no dependency installation.

```bash

## Check Whether The Skill Is Registered:

python C:\Users\renat\skills\agent-orchestrator\scripts\scan_registry.py
```

---

## Commands And Usage

How to use this skill:

```bash

## Use Via Orchestrator (Automatic):

python agent-orchestrator/scripts/match_skills.py "auction real-estate market"

## "Compare Auction Vs Cdi"

```

---

## Governance

This skill implements the following governance policies:

- **action_log**: Market analyses are recorded by log_action for traceability
- **rate_limit**: Controlled via the check_rate integrated into the ecosystem
- **requires_confirmation**: Negative-ROI projections trigger a confirmation_request to the user
- **warning_threshold**: A ROI below the CDI triggers warning_threshold with an automatic alert

Additional policies:
- **Owner:** Auctioneer AI Ecosystem
- **Scope:** Real-estate market analysis and auction investment strategies
- **Limitations:** Projections and estimates. Does not constitute investment advice.
- **Audit:** Validated by skill-sentinel
- **Sensitive data:** Does not store the user's financial data

---

## References

Market sources and references:
- ZAP Imóveis (zapimoveis.com.br) — market data
- Viva Real (vivareal.com.br) — price comparisons
- FIPEZAP — property price index
- IFIX (B3) — real-estate fund index
- SINDUSCON-SP — CUB and construction costs
- Central Bank — Selic, CDI, historical series
- CEF — portal of repossessed properties

## Best Practices

- Provide clear, specific context about your project and requirements
- Review all suggestions before applying them to production code
- Combine with other complementary skills for comprehensive analysis

## Common Pitfalls

- Using this skill for tasks outside its domain expertise
- Applying recommendations without understanding your specific context
- Not providing enough project context for accurate analysis

## Related Skills

- `junta-leiloeiros` - Complementary skill for enhanced analysis
- `leiloeiro-avaliacao` - Complementary skill for enhanced analysis
- `leiloeiro-edital` - Complementary skill for enhanced analysis
- `leiloeiro-ia` - Complementary skill for enhanced analysis
- `leiloeiro-juridico` - Complementary skill for enhanced analysis