🏢 CRE Capital Markets — Financial Analyst Toolkit

From Finance Analyst → Deal Execution Analyst A complete toolkit to position yourself as a Capital Markets insider before you're hired.

---

🎯 Purpose

This repository is a live portfolio + execution system built for the Financial Analyst, Capital Markets role at NYC. It demonstrates CRE-specific deal execution capability — not theory, not coursework — real broker-level output.

---

📂 Repository Structure

FinancialAnalyst/
├── README.md                          # This file — project overview
├── docs/
│   ├── 01_gap_analysis.md             # Gap decoding — what actually matters vs noise
│   ├── 02_elite_prompt.md             # The 1% Financial Analyst system prompt
│   ├── 03_better_questions.md         # 5 ways to ask like a Capital Markets insider
│   ├── 04_followup_strategy.md        # 5 follow-up questions + upgrade path
│   └── 05_skill_translation_matrix.md # BLUE → YELLOW → RED mapped to CRE equivalents
├── models/
│   ├── cre_deal_model.py              # Full CRE deal model generator (Excel)
│   ├── debt_sizing_engine.py          # DSCR / LTV / Debt Yield calculator
│   └── sensitivity_analysis.py        # Rent, vacancy, rate sensitivity tables
├── templates/
│   ├── offering_memorandum.md         # Broker-style OM template
│   ├── lender_quote_matrix.md         # 3-lender comparison matrix
│   ├── weekly_broker_update.md        # Weekly transaction update template
│   └── appraisal_risk_review.md       # Appraisal & risk review checklist
├── automation/
│   ├── deal_tracker.py                # Python deal pipeline tracker
│   ├── lender_outreach.py             # Lender outreach management system
│   └── quote_matrix_updater.py        # Dynamic quote matrix updater
├── scripts/
│   ├── generate_deal_model.py         # Generate a sample CRE deal Excel model
│   └── run_sensitivity.py             # Run sensitivity analysis on deal params
└── data/
    └── sample_rent_roll.csv           # Sample rent roll for testing

---

🔍 The Real Gap Analysis (Truth, Not Surface Level)

🟢 Your Hidden Advantage (Most People Miss This)

You already think like a portfolio + risk analyst with 11+ years of analytical finance:

Your Existing Skill	CRE Translation
Financial modeling (Excel)	Property-level cash flow modeling
Variance analysis	NOI variance & occupancy sensitivity
Pro forma / Forecasting	Rent growth, lease rollover, exit cap scenarios
SQL / Python automation	Deal sourcing + lender tracking automation
Stakeholder reporting	Broker updates + lender communication
Budget vs. Actuals	Underwriting vs. actual property performance
Multi-client portfolio	Multi-deal pipeline management
M.S. Accounting Analytics	Quantitative credibility edge

→ You are 80% of a CRE Capital Markets Analyst already. → You lack industry-specific wrappers, not core skill.

🔴 Real Gaps (Reframed Like a Top 1% Mentor)

Surface Gap	What Firms ACTUALLY Want
"No ARGUS"	Can you model cash flow + valuation logic? ✅ You can
"No CRE experience"	Can you think in NOI → DSCR → LTV → Debt sizing? 🔧 Build this
"No rent roll analysis"	Can you convert messy data into a cash flow story? ✅ You can
"No offering memoranda"	Can you SELL numbers as a narrative? 🔧 Build this
"No appraisal review"	Can you challenge assumptions? ✅ You can

→ Your real gap = "Deal storytelling + CRE-specific modeling logic"

---

🚀 Quick Start

# Clone the repo
git clone https://github.com/bhupesh-debug/FinancialAnalyst.git
cd FinancialAnalyst

# Install dependencies
pip install openpyxl pandas

# Generate a sample CRE deal model
python scripts/generate_deal_model.py

# Run sensitivity analysis
python scripts/run_sensitivity.py

---

📊 What This Repo Demonstrates

Competency	Proof
CRE Cash Flow Modeling	models/cre_deal_model.py — Rent Roll → GPR → EGI → NOI → Debt Sizing
Debt Sizing (DSCR/LTV/DY)	models/debt_sizing_engine.py — Bank/Debt Fund/Agency comparison
Offering Memorandum	templates/offering_memorandum.md — Broker-style, lender-friendly
Lender Quote Matrix	templates/lender_quote_matrix.md — 3-lender comparison + recommendation
Automation & Efficiency	automation/ — Deal tracking, lender outreach, dynamic updates
Risk Analysis	templates/appraisal_risk_review.md — Cap rate, rent growth, comps challenge
Stakeholder Communication	templates/weekly_broker_update.md — Senior broker update format

---

🧠 The Mindset

This project follows a strict institutional workflow:

1. Gap Translation — Convert existing skills into CRE equivalents
2. Live Deal Model — Build realistic property-level financials
3. Offering Memorandum — Write like a capital markets analyst
4. Lender Strategy — Quote matrix + lender type comparison
5. Automation Edge — Python/SQL workflows for deal ops
6. Risk Review — Challenge assumptions like a senior analyst
7. Weekly Updates — Communicate like you're already on the desk

---

📝 License

This project is for educational and portfolio demonstration purposes.

---

Built to convert "finance analyst" → "deal execution analyst"