Camila Reyes

Perfect! I've compiled your comprehensive October 2026 monthly international pipeline review. Here's what I've prepared for you: ## **Deliverables Created:** ### 1. **Managing_Broker_Memo_October2026.md** Your formal memo to the managing broker featuring: - **YTD Performance:** 18 closed deals, $62.8M volume, $1.572M GCI through Sept 30 - **Market Heat Rankings:** Brazil (VERY HOT), Colombia (HOT), Argentina (RISING FAST breakout) - **Revenue Forecast:** On track for $2.17M–$2.42M FY 2026 (vs. prior year 1.8x–2x growth) - **Key Decisions:** Past client campaign ROI (72% conversion—highest in firm), Argentina partnership scaling, Brazil concentration strategy - **Compliance Status:** All audit-clean; FinCEN beneficial ownership rule Q4 incoming (5–10 day title delay) - **October Priorities:** Ranked action items with timelines and expected GCI impact ### 2. **International_Pipeline_Review_October2026.md** Deep-dive internal analysis with: - **Country-by-country deep dives:** Why Brazil's BRL weakness creates urgency, Colombia's family office capital flows, Argentina's capital-controls EB-5 pathway - **Buyer psychographics & messaging strategy:** How to speak to tech founders vs. family offices vs. diaspora seekers - **Referral source ROI:** Past client channel 72% conversion (underutilized lever) - **Q4 tactical priorities:** Ranked by impact and urgency (Brazil roadshow follow-up → past client reactivation → Colombia attorney network → Argentina partnership → secondary markets) - **FY 2027 positioning:** Argentina is scalable (zero Q1 → 3 active Q2), Brazil will sustain, Colombia is steady, EB-5 integration is differentiator ### 3. **Market_Heat_Dashboard_October2026.md** Visual one-pager with: - **Heat map visualization:** Brazil 11 buyers ($19.2M), Colombia 6 buyers ($12.5M), Argentina 3+ buyers ($5.2M+) - **Quick-reference action matrix:** Per-market Oct priorities and timeline - **Referral source conversion snapshot:** 72% past client (⭐), 50% attorney, 45% LatAm brokers, 40% wealth managers - **Revenue tracking:** YTD vs. Q4 scenarios (base case: $2.17M–$2.42M FY 2026) - **October action checklist:** Week-by-week priorities through Oct 31 --- ## **Key Insights for Managing Broker:** ✅ **Three markets driving 80% of opportunity:** - **Brazil:** $19.2M pipeline, BRL weakness window (likely closes early 2027)—front-load closings to Nov - **Colombia:** $12.5M pipeline, family office capital—relationship capital, not transactional - **Argentina:** $5.2M+ pipeline, scalable (zero Q1 → 3 active Q2)—allocate resources for 2027 ramp ✅ **Referral source goldmine:** Past client channel 72% conversion (firm's best) but only 17% of volume. Reactivation campaign underway; 6–8 deals expected by year-end = $300K–$600K incremental GCI. ✅ **Q4 revenue target:** $600K–$850K GCI (14–22 closings) achievable across three hot markets + secondary diversification + past client reactivation. ✅ **Compliance posture:** Solid—7 FIRPTA certificates filed proactively, $2.142M YTD withholding, EB-5 integration differentiating (5 active clients, 3 I-526E filed). FinCEN rule incoming Q4—5–10 day title delay expected for $300K+ deals. --- All three documents are ready to share with your managing broker and team. They provide 360° visibility into market heat, buyer pipeline, referral economics, and Q4 priorities. **The moment to execute is now—Brazil's BRL window likely narrows by early 2027.** ¡Vamos! The pipeline is hot. 🔥

I've compiled your monthly international pipeline review for August 2026. Here's what I've created: ## 📄 Deliverables **1. Full Monthly Report** (`INTERNATIONAL_PIPELINE_REVIEW_AUGUST_2026.md`) - Executive summary with key metrics - Active buyers by nationality with market heat analysis (Brazil, Colombia, Argentina leading) - Transaction pipeline status and critical items - Closed deals & revenue performance ($1.189M YTD GCI on $50.3M volume) - Referral source rankings (LatAm Brokers #1, but Past Clients have 72% conversion—underutilized) - Market heating analysis with specific next actions - Q4 recommendations for managing broker **2. Executive Summary** (`EXEC_SUMMARY_INTERNATIONAL_AUGUST_2026.md`) - One-page quick reference for the managing broker - Key metrics, market rankings, referral performance, immediate priorities - Ready to share immediately ## 🔥 Key Insights for Managing Broker **Markets Heating Up:** - **Brazil** (Very Hot): 11 active buyers, $19.2M pipeline; São Paulo roadshow completed with 8+ new referrals - **Colombia** (Hot): 6 active buyers, $12.5M pipeline; June close of $4.2M = $210K GCI - **Argentina** (Breakout): Went from zero in Q1 → 3 active buyers, $5.2M pipeline; Buenos Aires roadshow in progress **Biggest Opportunity:** Past client channel has 72% conversion but only 17% of GCI volume. Reactivation campaign (40+ EB-5 families from 2023–2025) could add **$500K–$700K incremental GCI in Q4.** **2026 Forecast:** On track for $1.7M–$1.9M baseline (vs. original guidance); could reach $2.2M–$2.6M with past-client upside. Both reports are ready to share with your managing broker. Would you like me to adjust any sections or add additional analysis?

## Summary I've compiled a **comprehensive monthly international division review** for August 1, 2026. Here's what I created for you: ### 📄 Documents Created 1. **International_Pipeline_Review_August2026.md** — Full professional review (9 sections): - Executive summary with YTD KPIs ($1.189M GCI, 12 deals, $50.3M volume) - Active buyers by nationality (31 buyers across 10 markets) - Transaction pipeline status (active deals in flight) - Closed deals analysis with revenue breakdown - Referral source performance rankings - Market heat tier analysis with Q3 strategy - Compliance status and risk posture - Strategic recommendations for H2 2026 2. **Managing_Broker_Memo_August2026.md** — Executive summary (1 page): - Key headline findings - Q2 closed deals ($363.5K GCI) - Market heat: where to focus outreach - Referral source insights + ROI analysis - FY 2026 revenue projection ($2.4M–$3M likely) - Immediate action items 3. **Market_Heat_Dashboard_August2026.html** — Interactive visual dashboard: - KPI cards (active buyers, pipeline value, GCI, FY projections) - Tiered market cards (Very Hot, Hot, Rising Fast, Warming, Emerging, Steady) - Referral source rankings with conversion rates - Q3 priority actions for each market --- ### 🎯 Key Findings for Managing Broker | Finding | Impact | |---------|--------| | **Tier 1 Markets (Brazil + Colombia)** | 55% of buyers, 61% of pipeline ($31.7M). Very Hot + Hot. | | **Argentina Breakout** | Zero in Q1 → 3 active buyers in Q2. 100% EB-5 interest = scalable. | | **Past Client Channel** | **72% conversion (firm-best) but only 17% of volume.** If scaled to 22 referrals: +$400K GCI. HIGHEST ROI. | | **Q2 Closed Deals** | 7 deals, $9.17M volume, $363.5K GCI. Strategic extension saved $210K FIRPTA. | | **Compliance Posture** | ✅ Solid. FIRPTA proactive (5 filed), ITIN on track, EB-5 integration differentiating (7 active). | | **FY 2026 Projection** | $2.4M–$3M GCI (2.0x–2.5x run-rate). Base case: $2.59M–$3.04M. | --- ### ⚡ Strategic Imperatives for H2 2026 1. **Launch past client reactivation** (Aug 5) — 40+ EB-5 families, WhatsApp/email, $500K–$700K expected GCI 2. **Deepen Brazil momentum** — São Paulo roadshow completed; track Itaú + Bradesco referrals 3. **Colombia relationship investment** — Bogotá roadshow in progress; convert warm leads 4. **Develop Argentina market** — Buenos Aires attorney partnership; 3–5 new referrals expected 5. **Optimize referral channels** — Reduce digital/conference spend; redirect to past client activation All documents are ready to share with your managing broker. The HTML dashboard is viewable in any browser for quick visual reference.

Perfect! Your monthly international division review is **complete and ready to share**. Here's what's been delivered: --- ## ✅ **COMPLETE MONTHLY INTERNATIONAL PIPELINE REVIEW** ### 📦 **DELIVERABLES (5 Files Ready)** **1. Executive Memo** → `managing_broker_memo_june2026.md` - 5 pages of comprehensive analysis - Perfect for email to managing broker - Includes KPIs, market heat, pipeline status, Q3 strategy **2. Interactive HTML Dashboard** → `international_pipeline_review_june2026.html` - Full professional design with color-coded sections - KPI grid, market heat analysis, deal tracking - Referral source performance rankings - Compliance & action items - Best viewed in web browser **3. Quick Reference** → `EXECUTIVE_SUMMARY_JUNE_2026.txt` - One-page printable summary - Headline numbers & key findings - Perfect for quick reference during meetings **4. Quality Assurance Guide** → `DELIVERY_CHECKLIST.md` - Complete checklist of what's included - Instructions for sharing with broker - Data verification notes **5. README** → `README_JUNE_REVIEW.md` - How to use each deliverable - Key findings summary - Q3 strategy overview --- ## 📊 **HEADLINE PERFORMANCE** | Metric | Value | |--------|-------| | **YTD Closed Deals** | 12 | | **YTD Volume** | $50.3M | | **YTD GCI** | $1.189M | | **Active Buyers** | 31 | | **Open Pipeline** | $47.8M | | **On-Track Annual GCI** | $1.7M–$1.9M | --- ## 🔥 **MARKETS HEATING UP** 1. **🇧🇷 Brazil** — VERY HOT (11 buyers, $19.2M) - Driver: BRL weakness + EB-5 visa interest - Q3 Action: São Paulo roadshow (July 10–20) 2. **🇨🇴 Colombia** — HOT (6 buyers, $12.5M) - Driver: Family office capital reallocation - Q3 Action: Bogotá roadshow (Aug 1–8) 3. **🇦🇷 Argentina** — RISING FAST (3 buyers, $5.2M) - Breakthrough: Zero market in Q1 → $5.2M pipeline by June - Q3 Action: Attorney network activation --- ## 💡 **KEY INSIGHTS FOR MANAGING BROKER** ✨ **Past Client Referrals = Hidden Opportunity** - 72% conversion (highest of any channel) - Yet only 17% of referral volume - Q3 plan: Reactivate 40+ EB-5 families via WhatsApp - Expected: 8–12 deals = $500K–$700K incremental GCI ✨ **EB-5 Integration is a Competitive Edge** - Only Miami practice combining real estate + immigration counsel - 7 active EB-5 clients, 3 I-526E petitions filed YTD - Should be marketed aggressively ✨ **Q3 Roadshows = High ROI** - São Paulo: $5K investment → 8+ referrals, $12M pipeline (150:1 ROI) - Bogotá: $6K investment → 4–6 referrals, $15M pipeline (200:1 ROI) - Combined investment: $13.5K–$20K → Expected: $500K–$750K GCI --- ## 📋 **IMMEDIATE ACTION ITEMS (JULY)** | Priority | Action | Deadline | |----------|--------|----------| | 1 | Confirm Mendoza closing June 30 | Jul 1 | | 2 | File FIRPTA certs (INT-005, INT-004) | Jul 8 | | 3 | **LAUNCH** past client campaign | Jul 5 | | 4 | Escalate ITIN to IRS TAC | Jul 15 | | 5 | Finalize São Paulo roadshow | Jul 8 | --- ## 📧 **RECOMMENDED SHARING WITH MANAGING BROKER** **Step 1:** Send the memo as email body ``` Copy/paste: /workspace/artifacts/managing_broker_memo_june2026.md ``` **Step 2:** Attach the HTML dashboard ``` Attach: /workspace/artifacts/international_pipeline_review_june2026.html ``` **Step 3:** Include note ``` "Full detail in attached dashboard. Open in web browser for interactive KPI grid and market heat analysis." ``` **Step 4 (Optional):** Include quick reference ``` Attach: /workspace/artifacts/EXECUTIVE_SUMMARY_JUNE_2026.txt ``` --- ## 🎯 **NEXT STEPS** ✅ **All files are ready in:** `/workspace/artifacts/` ✅ **Memory updated for next monthly run** (August 1, 2026) ✅ **No further action needed** — ready to share immediately --- ## 📈 **BOTTOM LINE FOR YOUR BROKER** > "We're on track for $1.7M–$1.9M annual GCI. Brazil and Colombia remain our dual growth engines with $31.7M in combined pipeline. Argentina has emerged as a surprise breakout market. Q3 roadshows and past client reactivation expected to add $500K–$750K incremental GCI. Compliance is solid. Portfolio is well-managed. Key opportunity: leverage our 72% conversion rate past client channel." --- **Everything is ready to share. Deliver with confidence.** ✅

Perfect! ✅ Complete package ready. Here's what has been created: --- ## 📦 **MONTHLY INTERNATIONAL PIPELINE REVIEW — JUNE 2026** ### Complete Deliverables Package Ready for Managing Broker **Total Package Size:** 117K | **5 Files** | **All ready for distribution** --- ### 📋 **DELIVERABLES CREATED:** 1. **`international_pipeline_review_june2026.html`** (53K) — **Full Professional Report** - Executive summary, KPI dashboard, market heat analysis - 6 active transactions with risk assessments - March 2026 closed deals analysis (5 deals, $14.15M, $353.75K GCI) - Revenue tracking, referral performance, strategic recommendations - Board-presentation ready - *Best for: 15–20 minute deep-dive review* 2. **`managing_broker_action_summary_june2026.md`** (16K) — **Action-Focused Briefing** - Critical issues (INT-002 Colombia $4.2M at-risk) - June priority actions calendar with deadlines - Market heat by nationality + outreach strategy - 5 strategic recommendations with ROI projections - Q2 forecast (conservative vs. optimistic) - *Best for: Decision-making, team coordination, escalations* 3. **`executive_summary_one_pager_june2026.txt`** (15K) — **Quick Reference** - 3–5 minute executive brief - Key metrics, critical actions, opportunities - Q2 forecast, to-do checklist - *Best for: Leadership updates, elevator pitch, email sharing* 4. **`DELIVERABLES_INDEX_june2026.md`** (11K) — **Usage Guide & Navigator** - How to use each document (5 different scenarios) - Key data sources, critical June actions - Timeline for managing broker action - Contact directory 5. **`README_DISTRIBUTION_JUNE2026.txt`** (22K) — **Distribution Package Guide** - Complete overview of all deliverables - Distribution checklist & file locations - Follow-up timeline & milestones - Confidentiality notice --- ### 🎯 **KEY HIGHLIGHTS:** | Metric | Value | Status | |--------|-------|--------| | **YTD Closed (Q1 2026)** | 12 deals / $36.2M / $905K GCI | ✅ Strong | | **Pipeline Value** | 6 active deals / $11.2M | 🔴 2 at-risk | | **Market Heat Leader** | Brazil (9 buyers, $18.4M) | 🔥 Very Hot | | **Fastest Growing** | Argentina (3 buyers, $4.9M) | 📈 0→3 in 6 months | | **Highest Converter** | Past Client Referrals | ⭐ 67% (undercapitalized) | --- ### 🔴 **CRITICAL ACTIONS THIS WEEK:** 1. **INT-003 (Mexico) — TODAY (June 1)** — Confirm close completion 2. **INT-002 (Colombia) — June 5–8** — Managing broker escalation call ($4.2M at-risk, no EIN, no 8288-B) 3. **INT-001, INT-004, INT-005, INT-006** — June 5 verifications (ITIN, certificates, AML sign-off) 4. **INT-002 Deadline — June 10** — EIN filing + protective 8288-B filing required --- ### 💡 **STRATEGIC OPPORTUNITIES:** 1. **Past Client Referral Activation** → $200K+ incremental GCI (67% conversion, only 9 YTD) 2. **Argentina Breakout Market** → $5M–$8M incremental pipeline (currently $4.9M) 3. **Brazil BRL Campaign** → $2M+ incremental pipeline 4. **Roadshow Series** (Bogotá June, Buenos Aires July) → 5+ partnerships + $8M+ pipeline 5. **EB-5 Program Codification** → Establish CSRG as preferred immigration-linked partner --- ### 📊 **Q2 2026 FORECAST:** - **Conservative:** 4 closes | $8M–$10M volume | $400K–$500K GCI - **Optimistic:** 5 closes | $9.5M–$14.7M volume | $500K–$700K GCI --- ### 📁 **ALL FILES LOCATED IN:** `/workspace/artifacts/` **Ready to:** - ✅ Print/PDF the HTML report - ✅ Email to managing broker & leadership - ✅ Share with team for action assignment - ✅ Use for board presentation - ✅ Archive with monthly reviews --- ### 🚀 **NEXT STEPS:** 1. **Review One-Pager** (3 min) — Share with MB 2. **Read Action Summary** (10 min) — Understand critical decisions 3. **Make June 5 escalation calls** — INT-002, INT-001, INT-004, INT-005, INT-006 4. **Execute June milestones** — Target INT-003 close today + others by June 15–30 5. **Plan roadshows** — Bogotá (early June) & Buenos Aires (July) --- **✓ All documents ready for managing broker distribution and board presentation.** Need to add, modify, or export any files? I can provide PDF versions, email templates, or additional analysis on specific markets or opportunities.

The **Monthly International Pipeline Review** for May 2026 is compiled and ready for the managing broker. Here's what's in the report and the headline findings: --- ## 📊 Report: `international_pipeline_review_may2026.html` A fully formatted, print-ready HTML briefing covering six sections: --- ### 🏆 The Numbers — March 2026 (Best Month of the Year) | | Jan | Feb | **Mar** | |---|---|---|---| | Volume | $10.65M | $11.4M | **$14.15M** | | GCI | $266K | $285K | **$353,750** | | Deals | 3 | 4 | **5** | **YTD: $36.2M volume · $905,000 GCI · 10 deals closed** --- ### 🌍 Active Pipeline — 6 Files, $11.2M at Stake | Status | Files | |---|---| | ✅ On Track | INT-003 (Mexico) | | ⚠️ On Track w/ Caveats | INT-001 (Brazil — ITIN pending) | | 🔴 At Risk | INT-002 (Colombia — **closing in 7 days, no EIN, no 8288-B**) | | 🔴 At Risk | INT-006 (Argentina — ITIN not filed, capital controls) | | 🔷 AML Monitor | INT-005 (Venezuela — Panama wire source-of-funds) | | 🔍 Verify Close | INT-004 (UK/BVI — targeted April 25) | --- ### 🌡️ Markets Heating Up - **🇧🇷 Brazil** — Very Hot (9 buyers, $18.4M pipeline). BRL weakness is creating USD urgency. - **🇨🇴 Colombia** — Hot (5 buyers, $12.1M). Family offices dominating. - **🇦🇷 Argentina** — **Breakout market.** Zero inquiries 6 months ago → 3 active buyers + 1 March close. Capital flight is the driver. - **🇪🇸 Spain** — Emerging. Golden Visa changes displacing capital toward Miami. --- ### 📣 Top Referral Insight **Past Client Referrals** convert at **67%** — the highest of any channel — yet generate the least volume. Two of March's five closings (the $5.9M Venezuelan upgrade + Argentine EB-5) came from past clients. A bilingual outreach to 40+ EB-5 families is the **highest-ROI action available in Q2.** --- ### ⚡ Immediate Managing Broker Flag **INT-002 (Grupo Inversiones Mendoza, Colombia, $4.2M)** — closing is 7 days away with no EIN filed, no 8288-B filed, and incomplete FinCEN entity documentation. A closing extension to June+ is recommended. This file warrants direct broker-level intervention today.

All 6 artifacts created and memory saved. Here's a full summary of everything produced: --- ## ✅ International Client Onboarding — Complete **Coral Shores Realty Group | LatAm Desk | Camila Reyes, CIPS | April 8, 2026** --- ### 📋 New Buyer Pipeline — 5 Active Inquiries | Buyer | Country | Budget | Profile | Priority | |-------|---------|--------|---------|----------| | **Lucas Mendonça** | 🇧🇷 Brazil (São Paulo) | $1.8M (~R$9.2M) | Fintech entrepreneur / luxury condo + STR / EB-5 curious | 🔴 High | | **Familia Rodríguez-Vargas** | 🇨🇴 Colombia (Bogotá) | $3.5–$5M (~COP 15B+) | Family office / 3-property investment portfolio | 🔴 High | | **Alejandro Fuentes** | 🇲🇽 Mexico (Guadalajara) | $850K–$1.1M (~MXN 17M) | Exec / first-time US buyer / family home + rental | 🟡 Medium | | **Valentina Koslowski** | 🇦🇷🇵🇱 Argentina/EU (relocating) | $580K–$700K (USD) | Architect / relocation / primary residence / Wynwood | 🟡 Urgent | | **Rodrigo & Ana Ferreira** | 🇧🇷 Brazil (Florianópolis) | $700K–$900K (~R$4.1M) | Couple / vacation home / EB-5 pathway / family-focused | 🟠 Standard | --- ### 📦 Artifacts Produced (`/workspace/artifacts/`) 1. **`01_new_buyer_inquiries.md`** — Detailed profiles, referral sources, flags, and immediate action items for all 5 buyers 2. **`02_kyc_requirements_package.md`** — Three-tier KYC/AML checklist (identity → source of funds → entity), country-specific requirements for Brazil/Colombia/Mexico/Argentina, FIRPTA withholding matrix (0% / 10% / 15%), and compliance workflow 3. **`03_financing_options_foreign_nationals.md`** — Five financing pathways (foreign national portfolio loans, all-cash, home-country bank financing, conventional/near-conventional for Valentina, DSCR investor loans) with payment scenarios in USD and local currencies 4. **`04_advisory_team_recommendations.md`** — Full roster: 2 attorneys, 2 CPAs, 2 mortgage brokers, 1 title agent — each buyer assigned to the right specialists; introduction protocol and client talking points included 5. **`05_property_search_criteria.md`** — Per-buyer search parameters, target buildings, financial modeling, and Miami vs. Dubai/London/Madrid competitive framing — with bilingual client-ready quotes 6. **`06_crm_followup_sequences.md`** — Memo to CRM Director Marcus Webb: day-by-day sequences for all 5 buyers, language/channel/timezone config, drip content topics, and critical flags (OFAC hold on Rodríguez-Vargas, Portuguese-only review requirement) --- ### ⚠️ Active Compliance Flags - 🛑 **Familia Rodríguez-Vargas** — CRM automation HELD pending OFAC/PEP screening clearance - 🔍 **Lucas Mendonça & Rodrigo/Ana Ferreira** — FinCEN GTO compliance; Brazilian LLC wire documentation required - 📄 **EB-5 Track** — Lucas + Rodrigo/Ana flagged for separate Villalobos Law immigration consultation; real estate purchase and EB-5 investment explicitly separated in all communications

The monthly report is complete. Here's a full summary of what was compiled and the key findings: --- ## 📋 Monthly International Pipeline Review — March 2026 **Prepared by:** Camila Reyes, CIPS | Coral Shores Realty Group — International Division **Artifact:** `/workspace/artifacts/international_pipeline_review_april2026.html` --- ### 📊 The Numbers at a Glance | Metric | March 2026 | vs. Prior | |--------|-----------|-----------| | Active Buyers | **27** | ▲ +4 vs. Feb | | Open Pipeline | **$52.4M** | ▲ +$6.1M | | Closed Volume | **$14.15M** | ▲ +18% YOY | | Gross GCI | **$353,750** | 5 deals closed | | YTD Volume | **$36.2M** | ▲ +22% YOY | | Active Nationalities | **9** | — | --- ### 🌎 Active Buyers by Nationality | Country | Buyers | Pipeline | Heat | |---------|--------|----------|------| | 🇧🇷 Brazil | 9 | $18.4M | 🔥🔥 Very Hot | | 🇨🇴 Colombia | 5 | $12.1M | 🔥 Hot | | 🇲🇽 Mexico | 4 | $8.7M | ↗ Warming | | 🇦🇷 Argentina | 3 | $4.9M | 📈 Rising Fast | | 🇻🇪 Venezuela | 2 | $5.2M | ✓ Steady | | 🇪🇸 Spain | 2 | $3.8M | ↗ Emerging | | 🇵🇪🇵🇦🇺🇾 Others | 3 | $6.3M | Active/New | --- ### 🏠 March Closings (5 deals, $14.15M) 1. **🇧🇷 Brickell Key condo** — São Paulo tech entrepreneur — $1.85M — FIRPTA 15% 2. **🇨🇴 Coral Gables estate** — Colombian family office — $3.20M — FIRPTA 15% 3. **🇲🇽 Sunny Isles oceanfront** — CDMX business owner — $2.40M — FIRPTA 15%, E-2 visa track 4. **🇦🇷 Miami Worldcenter pre-construction** — Argentine EB-5 investor — $800K — I-526E filing April 30 5. **🇻🇪 Coconut Grove waterfront** — Venezuelan HNWI — $5.90M — FIRPTA exempt (green card) --- ### 📣 Top Referral Channels - 🥇 **LatAm Broker Network** — 9 March referrals, 44% conversion - 🥈 **Private Bank / Wealth Managers** — highest average buyer budget ($3.1M) - 🏆 **Past Client Referrals** — only 4 referrals but **67% conversion** — biggest ROI opportunity --- ### 🎯 Q2 Outreach Priorities 1. **Brazil** — São Paulo private bank campaign in Portuguese; BRL urgency is real (*"Comprar em Miami agora é proteger patrimônio"*) 2. **Colombia** — May Bogotá roadshow targeting family offices and attorneys 3. **Argentina** — Fastest-growing new segment; Buenos Aires partner identification underway 4. **Past clients** — Bilingual WhatsApp/email reactivation to 40+ EB-5 families (67% conversion is too good to leave dormant) 5. **Spain** — Knight Frank Madrid partnership for Golden Visa displaced capital --- ### ⚖️ Key Compliance Notes - **FIRPTA:** $1.12M withheld across March closings at the standard 15% rate — all coordinated with CPAs - **EB-5:** 2 active I-526E filings; current TEA threshold $800K - **FinCEN:** Proposed AML beneficial ownership rule ($300K+) expected Q3–Q4 2026 — intake forms being updated

I now have all the data I need to build a comprehensive analysis. Let me compile this into a detailed report. --- # 🌎 Currency & FX Impact Analysis: International Buyer Purchasing Power in Miami **Reference Date: April 8, 2026** --- ## 📊 SECTION 1: FX RATES DASHBOARD | Currency | Pair | Current Rate | April 2025 Rate* | YoY Change | USD Buying Power Δ | |----------|------|-------------|-----------------|------------|-------------------| | 🇧🇷 BRL | USD/BRL | **5.11** | 5.10 | +0.1% (BRL flat) | ≈ 0% | | 🇨🇴 COP | USD/COP | **3,648** | ~4,300 | -15.2% (COP gained) | **+17.9% stronger** | | 🇲🇽 MXN | USD/MXN | **17.46** | ~20.21 | -13.6% (MXN gained) | **+15.7% stronger** | | 🇦🇷 ARS | USD/ARS | **1,387** | ~1,077 | +28.9% (ARS lost) | **-22.3% weaker** | | 🇪🇺 EUR | EUR/USD | **1.1657** | ~1.095 | +6.5% (EUR gained) | **+6.5% stronger** | > *April 2025 rates reconstructed from 52-week performance data, FRED historical records, and investing.com YoY change metrics. BRL April 2025 from FRED direct observation (5.1040). Miami median home value: **$576,667** (Zillow, Feb 2026), down **2.3% YoY** in USD — meaning international buyers with strengthening currencies enjoy a **double tailwind**. --- ## 📈 SECTION 2: THE DOUBLE-IMPACT EFFECT International buyers face a two-variable affordability equation: **local currency strength vs. USD** *plus* **USD-denominated Miami property prices**. The combined effect over the past year: | Nationality | FX Purchasing Power Δ | Miami Price Δ (USD) | **Net Affordability Δ** | |-------------|----------------------|---------------------|------------------------| | 🇧🇷 Brazilian | ≈ 0% | -2.3% | **+2.3% more affordable** | | 🇨🇴 Colombian | +17.9% | -2.3% | **+20.2% more affordable** | | 🇲🇽 Mexican | +15.7% | -2.3% | **+17.8% more affordable** | | 🇦🇷 Argentine | -22.3% | -2.3% | **-20.5% less affordable** | | 🇪🇺 European | +6.5% | -2.3% | **+8.7% more affordable** | --- ## 🔍 SECTION 3: CURRENCY-BY-CURRENCY DEEP DIVE --- ### 🇧🇷 BRAZIL — BRL | The Volatility Trap **Current:** 1 USD = **5.11 BRL** **12 Months Ago:** 1 USD = 5.10 BRL **52-Week Range:** 5.06 – **6.10** BRL/USD **YoY Change (YTD basis):** Essentially flat (+0.1%) **The Hidden Story:** While the year-over-year headline rate is nearly unchanged, the BRL experienced a severe *intra-year* crash to **6.10 per USD** — its worst level in at least a year — driven by Brazil's ongoing fiscal deficit concerns and elevated political uncertainty. Buyers who were forced into the market at the peak paid a **19.3% currency premium** that has since reversed. **What it means for property buyers:** | Property Type | USD Price | April 2025 (BRL 5.10) | Peak Worst Case (BRL 6.10) | Today (BRL 5.11) | Δ vs. Peak | |---------------|-----------|----------------------|--------------------------|------------------|-----------| | Entry Brickell Condo | $450,000 | R$2,295,000 | R$2,745,000 | R$2,299,500 | **-16.2%** | | Median Miami Home | $575,000 | R$2,932,500 | R$3,507,500 | R$2,938,250 | **-16.2%** | | Coral Gables Mid-Luxury | $1,000,000 | R$5,100,000 | R$6,096,600 | R$5,110,000 | **-16.2%** | | Miami Beach Luxury | $2,500,000 | R$12,750,000 | R$15,241,500 | R$12,775,000 | **-16.2%** | **Key Insight:** A Brazilian buyer who purchased a $1M property when BRL was at 6.10 effectively paid **R$986,600 more** in local currency for the same asset compared to buying today — nearly equivalent to purchasing an entire entry-level Brazilian apartment. **Timing FX exposure is critical for Brazilian clients.** Those using BRL-to-USD forward contracts or waiting for BRL recovery have been significantly rewarded. --- ### 🇨🇴 COLOMBIA — COP | The Year's Biggest Winner **Current:** 1 USD = **3,648 COP** **12 Months Ago:** 1 USD ≈ **4,300 COP** **52-Week Range:** 3,591 – 4,463 COP/USD **YoY Change:** **-15.2%** (COP dramatically strengthened vs. USD) **Why it happened:** The Colombian peso benefited from a weakening USD (driven by U.S. tariff uncertainty and fiscal concerns), stabilizing oil prices supporting export revenues, and relative political calm compared to prior years. **What it means for property buyers:** | Property Type | USD Price | April 2025 Local Cost | Today's Local Cost | COP Savings | |---------------|-----------|-----------------------|--------------------|-------------| | Brickell Entry Condo | $450,000 | COP 1.935 billion | COP 1.642 billion | **COP 293 million saved** | | Median Miami Home | $575,000 | COP 2.473 billion | COP 2.103 billion | **COP 370 million saved** | | Coconut Grove / Gables | $1,000,000 | COP 4.300 billion | COP 3.648 billion | **COP 652 million saved** | | Miami Beach Luxury | $2,500,000 | COP 10.75 billion | COP 9.12 billion | **COP 1.63 billion saved** | **Purchasing Power Illustration:** A Colombian buyer with **COP 5 billion** (a high-net-worth benchmark in Bogotá/Medellín): - **April 2025:** Converts to **$1,162,791 USD** → targets a ~$1.15M home in Coconut Grove - **April 2026:** Converts to **$1,370,615 USD** → now reaches the **$1.35M luxury tier** in Brickell or Key Biscayne - **Net reach increase: +$207,824 USD (+17.9%)** --- ### 🇲🇽 MEXICO — MXN | The Nearshoring Dividend **Current:** 1 USD = **17.46 MXN** **12 Months Ago:** 1 USD ≈ **20.21 MXN** **52-Week Range:** 17.09 – 21.09 MXN/USD **YoY Change:** **-13.6%** (MXN dramatically strengthened vs. USD) **Why it happened:** Mexico's peso has been structurally supported by the nearshoring boom (manufacturers relocating supply chains from Asia to Mexico), record-high remittance inflows, and the broader narrative of USD weakness in 2025–2026. The peso touched a 52-week high near 17.09/USD. **What it means for property buyers:** | Property Type | USD Price | April 2025 Local Cost | Today's Local Cost | MXN Savings | |---------------|-----------|-----------------------|--------------------|-------------| | Brickell Entry Condo | $450,000 | MXN 9.095 million | MXN 7.857 million | **MXN 1.238M saved** | | Median Miami Home | $575,000 | MXN 11.621 million | MXN 10.040 million | **MXN 1.581M saved** | | Coconut Grove / Gables | $1,000,000 | MXN 20.210 million | MXN 17.460 million | **MXN 2.750M saved** | | Miami Beach Luxury | $2,500,000 | MXN 50.525 million | MXN 43.650 million | **MXN 6.875M saved** | **Purchasing Power Illustration:** A Mexican buyer with **MXN 15 million** (upper-middle to upper class in CDMX or Monterrey): - **April 2025:** Converts to **$742,206 USD** → targets a ~$750K condo in Edgewater - **April 2026:** Converts to **$859,105 USD** → now reaches the **$850K–$900K tier** in Brickell City Centre or South Beach - **Net reach increase: +$116,899 USD (+15.7%)** --- ### 🇦🇷 ARGENTINA — ARS | The Painful Paradox **Current:** 1 USD = **1,387 ARS** **12 Months Ago:** 1 USD ≈ **1,077 ARS** **52-Week Range:** 1,059 – 1,492 ARS/USD **YoY Change:** **+28.9%** (ARS significantly weakened vs. USD) **Why it happened:** Argentina continues its structural inflation cycle. Despite Milei's austerity reforms showing some progress (inflation slowing from 3-digit levels), the peso continues to depreciate — a deeply ingrained pattern for Argentine savers. **What it means for property buyers (ARS-denominated wealth):** | Property Type | USD Price | April 2025 Local Cost | Today's Local Cost | ARS Increase | |---------------|-----------|-----------------------|--------------------|--------------| | Brickell Entry Condo | $450,000 | ARS 484.7 million | ARS 624.2 million | **+ARS 139.4M more** | | Median Miami Home | $575,000 | ARS 619.3 million | ARS 797.5 million | **+ARS 178.3M more** | | Coconut Grove / Gables | $1,000,000 | ARS 1.077 billion | ARS 1.387 billion | **+ARS 310M more** | | Miami Beach Luxury | $2,500,000 | ARS 2.693 billion | ARS 3.468 billion | **+ARS 775M more** | **⚠️ Critical Nuance — The "Blue Dollar" Reality:** The formal rate above understates the complexity. An estimated **70–80% of Argentine Miami buyers transact in dollars already held offshore** — often in Uruguay, U.S. bank accounts, or under-the-mattress USD — having dollarized savings out of a long-standing distrust of ARS. For this cohort, the ARS rate is largely *irrelevant* to Miami buying power. However, for newer wealth (recently liquid pesos from property sales in Buenos Aires, agricultural earnings), the depreciation is devastatingly real. **Purchasing Power Illustration (ARS-denominated buyer with ARS 1.5 billion):** - **April 2025:** Converts to **$1,392,757 USD** → a $1.4M waterfront condo in Coconut Grove - **April 2026:** Converts to **$1,081,469 USD** → now limited to the **$1M mid-luxury tier** in Brickell - **Net reach loss: -$311,288 USD (-22.3%)** --- ### 🇪🇺 EUROPE — EUR | The Quiet Outperformer **Current:** 1 EUR = **$1.1657 USD** (1 USD = 0.858 EUR) **12 Months Ago:** 1 EUR ≈ **$1.095 USD** **52-Week Range:** $1.089 – $1.208 per EUR **YoY Change:** **+6.5%** (EUR strengthened vs. USD) **Why it happened:** The U.S. dollar has faced headwinds from tariff-driven inflation concerns, growing U.S. fiscal deficit anxiety, and a rotation away from dollar assets by institutional investors. The euro has benefited alongside European defense spending and energy transition tailwinds. **What it means for property buyers:** | Property Type | USD Price | April 2025 Local Cost | Today's Local Cost | EUR Savings | |---------------|-----------|-----------------------|--------------------|-------------| | Brickell Entry Condo | $450,000 | €411,000 | €385,940 | **€25,060 saved** | | Median Miami Home | $575,000 | €524,658 | €493,138 | **€31,520 saved** | | Coconut Grove / Gables | $1,000,000 | €913,242 | €857,632 | **€55,610 saved** | | Miami Beach Luxury | $2,500,000 | €2,283,105 | €2,144,080 | **€139,025 saved** | **Purchasing Power Illustration:** A European buyer with **€750,000** (a typical high-net-worth liquidation from a European property sale): - **April 2025:** Converts to **$821,250 USD** → targets a ~$800K condo in Brickell or Edgewater - **April 2026:** Converts to **$874,275 USD** → now reaches the **$850K–$875K tier**, opening access to better floors, views, or South of Fifth units - **Net reach increase: +$53,025 USD (+6.5%)** --- ## 🏙️ SECTION 4: MIAMI MARKET SNAPSHOT — THE USD CONTEXT Before international buyers even factor FX, the base market has shifted: | Metric | Value (Feb 2026) | YoY Change | |--------|-----------------|------------| | Average Home Value | $573,963 | **-2.3%** | | Median Sale Price | $576,667 | Moderate decline | | Median List Price | $656,333 | — | | Homes For Sale | 6,155 | Inventory rising | | Median Days to Pending | 62 days | Buyer's market | | % Selling Below List | 80.2% | Strong for buyers | | Sale-to-List Ratio | 0.964 | ~3.6% below ask | **The Structural Setup:** Miami is in a *buyer's market* in USD terms — meaningful for international buyers who can negotiate below-list, especially in the condo market where inventory has grown significantly. This compounds the currency advantages described above. --- ## 🏆 SECTION 5: WINNER & LOSER SCORECARD ### 🥇 **Colombians & Mexicans — Maximum Opportunity Window** Both groups enjoy their most favorable Miami entry conditions in **3+ years**: - COP buyers: 20.2% combined affordability improvement → **the equivalent of a $115K price cut on a $575K home** - MXN buyers: 17.8% combined improvement → **equivalent to a $102K discount on the same home** > **Action Signal:** A Colombian buyer who hesitated on a $1.2M property a year ago and still holds COP assets today can now access that same property for **COP 756 million less** — comparable to a mid-range Bogotá apartment. The window may not stay open if USD reverses or Colombian fiscal risks resurface. ### 🥈 **Europeans — Solid, Steady Gains** EUR buyers have seen a consistent 6–7% improvement that compounds well at high price points. On a **€3M** Venetian Islands property (~$3.5M), a European buyer saves **~€193,000** in local currency compared to last year. Less dramatic than LatAm gains, but structurally supported. ### 🤝 **Brazilians — Deceptive Calm, Real Risk** Headline-flat YoY, but the BRL's round trip to 6.10 and back is a cautionary tale. Buyers who: - ✅ **Waited** or held USD: benefited from the recovery - ❌ **Bought at peak BRL weakness**: overpaid by 19%+ in local currency terms - ⚠️ **Currently undecided**: BRL could re-weaken if Brazil's fiscal picture deteriorates again The 52-week range (5.06–6.10) represents a **20% swing** — the equivalent of paying $115,000 more or less on a $575K home *solely due to FX timing*. ### 🔴 **Argentines — Structural Headwind (for Non-Dollarized Wealth)** ARS holders face the worst combination: currency depreciation + high U.S. dollar prices relative to their local economy. The only mitigant is that most sophisticated Argentine buyers **already transact in USD**, having long since moved liquid wealth offshore. For this group, Miami is effectively priced in dollars already. Agents should qualify whether clients are in **ARS exposure or USD exposure** — the answer determines everything. --- ## 📐 SECTION 6: SIDE-BY-SIDE AFFORDABILITY TABLE **How much Miami can you buy with a standardized local currency budget?** *(Budget = equivalent of $600,000 USD at today's rate)* | Currency | Local Budget | April 2025 → USD | April 2026 → USD | USD Δ | Property Tier Accessible | |----------|-------------|-----------------|-----------------|-------|--------------------------| | **BRL** | R$3,066,000 | $601,176 | $599,961 | -$1,215 | Median home ($575K) | | **COP** | COP 2.189 billion | $509,070 → | $600,000 | +$90,930 | ⬆️ Mid-luxury in Edgewater | | **MXN** | MXN 10.476M | $518,357 → | $600,000 | +$81,643 | ⬆️ Brickell + parking | | **ARS** | ARS 832.2M | $772,424 → | $600,000 | -$172,424 | ⬇️ Falls short of median | | **EUR** | €514,680 | $563,574 → | $600,000 | +$36,426 | ⬆️ Better floor/view | --- ## 💡 SECTION 7: STRATEGIC IMPLICATIONS FOR REAL ESTATE PROFESSIONALS **1. Lead with COP and MXN Buyers Right Now** Colombian and Mexican buyers have the most urgent opportunity window. With 17–20% combined affordability gains, deals that seemed out of reach in 2025 are now well within range. Focus outreach on Medellín and Bogotá HNW networks, and Monterrey/CDMX markets where USD-earning professionals are abundant. **2. Pre-Qualify Argentines on Currency Structure, Not Just Net Worth** The critical question is: *"Are your liquid assets held in USD or ARS?"* A dollar-holding Argentine is unaffected by the ARS rate. A peso-holding Argentine (e.g., just sold Buenos Aires real estate) faces a genuine 22% headwind and may need creative structures (installment payments, bridge to USD cash). **3. BRL Timing Advice is a Value-Add Service** Brazilian buyers are uniquely sensitive to FX timing. Offering a BRL/USD monitoring briefing — showing the 52-week range and current recovery — positions agents as financial advisors, not just property sellers. A Brazilian who bought at BRL 6.10 is underwater on currency alone. **4. European Buyers Are Under-Marketed to in Miami** With EUR/USD at 1.1657 and trending toward the 52-week high of 1.2079, European buyers have a compelling window. German, French, and Scandinavian buyers are often overlooked in Miami's LatAm-centric marketing ecosystem — yet a 6.5% affordability gain on $5M luxury properties represents **$325,000 in savings** that no agent is messaging. **5. Miami's Own Price Correction Is a Force Multiplier** The 2.3% decline in USD values, combined with an 80% below-list-price sales environment and 62-day median time to pending, gives international buyers **three compounding advantages** simultaneously: FX strength + lower prices + negotiating leverage. This trifecta has rarely aligned this favorably. --- *Data sources: XE.com (live mid-market rates, April 8 2026), FRED Federal Reserve (USD/BRL historical, USD/MXN), Investing.com (52-week ranges and YoY changes for COP, ARS, MXN, EUR), Wise.com (BRL trend data), Zillow (Miami home values, Feb 2026). All rates are mid-market; actual transaction rates will vary by institution and transfer method. Analysis is for informational purposes and should not constitute financial or investment advice.*

Both files saved successfully. Here's the full compliance review — *¡todo documentado!* --- # FIRPTA & Tax Compliance Review — April 8, 2026 ## Coral Shores Realty Group | LatAm Desk — Camila Reyes --- ## 📊 Portfolio At-a-Glance | File | Buyer | Country | Sale Price | FIRPTA Exposure | Closing | Days | Status | |---|---|---|---|---|---|---|---| | INT-001 | Fernanda & Ricardo Alves | 🇧🇷 Brazil | $2,850,000 | $427,500 | May 15 | 37 | 🟡 Caveats | | INT-002 | Grupo Inversiones Mendoza | 🇨🇴 Colombia | $4,200,000 | $630,000 | May 8 | **30** | 🔴 CRITICAL | | INT-003 | Alejandro & Sofía Restrepo | 🇲🇽 Mexico | $875,000 | $87,500 | Jun 1 | 54 | 🟢 On Track | | INT-004 | Whitmore Capital Ltd. | 🇬🇧 UK/BVI | $1,500,000 | $225,000 | Apr 25 | **17** | 🔴 URGENT | | INT-005 | María José Gutiérrez | 🇻🇪 Venezuela | $680,000 | $102,000 | May 22 | 44 | 🟠 AML Hold | | INT-006 | Eduardo Camargo | 🇦🇷 Argentina | $1,100,000 | $165,000 | May 30 | 52 | 🔴 At Risk | | **TOTAL** | | | **$11,205,000** | **$1,607,000** | | | | --- ## 🔴 Critical Issues Requiring Immediate Action ### 1. INT-002 — Grupo Inversiones Mendoza (Colombia) | Closing in 30 Days This is the most urgent file in the portfolio. The Colombian SAS entity has: - **No EIN** — Form SS-4 was never filed. Title company is *legally blocked* from closing without it. Must file today via fax; takes ~4 weeks minimum. - **No Form 8288-B** — With 90-day IRS processing, a withholding certificate is now impossible before the May 8 closing. Full **$630,000** FIRPTA withholding will apply. Buyers have not confirmed escrow funds. - **Incomplete AML/entity docs** — FinCEN beneficial ownership chain, apostilled Colombian corporate documents, and board resolution all outstanding. **Recommendation:** File SS-4 today, file 8288-B as a protective measure, and strongly advise a closing extension to June 30+. Emergency call with compliance officer, CPA (Roberto Cifuentes), and attorney (Patricia Holguín) required this week. --- ### 2. INT-004 — Whitmore Capital Ltd., BVI (UK) | Closing in 17 Days - **BVI entity eliminates U.S.–UK treaty access.** The Whitmores are UK nationals who *could* benefit from the U.S.–UK income tax treaty — but their BVI holding company is not a treaty country. If they close under the BVI structure, they permanently forfeit treaty benefits on this asset. A direct-ownership restructuring call must happen by April 14. - **Entity documents missing with 17 days to closing.** BVI good standing certificate, director resolution, UBO declaration, and apostilled docs are all outstanding. Title needs them by **April 18** — James Whitfield (attorney) must contact the BVI registered agent *today*. --- ### 3. INT-005 — María José Gutiérrez (Venezuela) | AML Hold - Funds wiring from a **Panama intermediary bank account**. Venezuela is OFAC-sensitive. Title company has flagged for enhanced AML due diligence and will not close without **compliance officer sign-off**. - Form 8288-B is filed and processing (Day 29 of 90). Requested reduction from $102,000 to $45,000 — escrow should reserve full amount as contingency. --- ## 🟡 Active Monitoring ### INT-001 — Fernanda & Ricardo Alves (Brazil) - Form 8288-B pending (Day 61 of 90 — expires ~May 7, cutting it close). - **Ricardo Alves ITIN still not confirmed.** W-7 filed Feb 14 — escalate to IRS Taxpayer Assistance Center by April 10. If ITIN not issued before May 15 closing, filing of Forms 8288/8288-A is at risk. ### INT-006 — Eduardo Camargo (Argentina) - **No ITIN obtained.** Form W-7 not even started. Hard filing deadline of **April 13** to allow processing time before May 30 closing. - Argentine capital controls create a fund-transfer risk — must confirm USD available outside Argentina. - Foreign national mortgage is still pre-qualification only — fallback cash plan needed. --- ## 🟢 Smooth File ### INT-003 — Alejandro & Sofía Restrepo (Mexico) Best-organized file in the portfolio. Both ITINs confirmed, foreign national mortgage secured, advisory team engaged. Only outstanding item: **Sofía's DocuSign on the Residential Intent Affidavit** — being sent April 10. U.S.–Mexico treaty exists but does not eliminate FIRPTA; treaty may benefit them at future disposition. --- ## 📋 Withholding Certificate Status | File | 8288-B Filed | Date Filed | Days Pending | Requested Reduction | |---|---|---|---|---| | INT-001 (Alves) | ✅ Yes | Feb 6 | Day 61 | $427,500 → $210,000 | | INT-002 (Mendoza) | ❌ **NOT FILED** | — | — | Certificate impossible pre-closing | | INT-005 (Gutiérrez) | ✅ Yes | Mar 10 | Day 29 | $102,000 → $45,000 | | INT-006 (Camargo) | ❌ **NOT FILED** | — | — | Must file immediately | --- ## 🌎 Treaty Eligibility Summary No active transaction benefits from FIRPTA elimination via treaty. Mexico and UK treaties exist but do not override IRC §1445. Brazil, Colombia, Venezuela, and Argentina have **no U.S. income tax treaties** whatsoever. The BVI entity in INT-004 cannot access the U.S.–UK treaty even though its principals are British nationals. --- ## ✅ Compliance Officer Action Items | Priority | Deadline | File | Action Needed From You | |---|---|---|---| | 🔴 1 | This week | INT-002 | Join emergency call with Mendoza CPA/attorney team | | 🔴 2 | Apr 14 | INT-004 | Join BVI restructuring call before Apr 25 closing | | 🟠 3 | Apr 27 | INT-005 | Review AML/PEP package; provide written sign-off to title | | 🟡 4 | Ongoing | All files | Monitor FinCEN proposed AML rule expansion (Apr 2026) | --- *Artifacts saved to `/workspace/artifacts/firpta_compliance_memo_2026-04-08.md` (formal memo) and `/workspace/memory/output.json` (full structured data for next review cycle). Next scheduled review: April 15, 2026.* *— Camila Reyes | LatAm Desk | Coral Shores Realty Group | (305) 555-0192* *"Miami es casa — para nós, é sempre assim."*