Kyle Tran
Commercial Real Estate Analyst · Los Angeles
USC B.S. Real Estate Development, Aug 2026
Commercial Real Estate Analyst
USC B.S. Real Estate Development, August 2026 · Los Angeles
Selected Work
Underwriting and market work from USC coursework and internships, and the systems I built around it.
Featured case · USC RED 469 · Spring 2026
Cité Vivante
Sanofi walked away from a 16.2-hectare R&D campus south of Paris. The sponsor’s filed plan keeps the labs and swaps offices for industrial flex; this is the independent counter-case: exit the impaired office, retain the irreplaceable wet-lab platform, and add the neighbourhood the campus never had.
- 16.2 ha7 parcels · 2 communes
- 32,000 m²wet lab retained
- 350–500homes proposed
- 11field meetings in Paris
Southern California Industrial Portfolio Acquisition
Underwriting | $61.8M, two assets, 10-year hold (2024)
Acquisition underwriting for two Southern California industrial assets: 10-year DCF, market comps, debt structure, and a 13.2% LP IRR at a 2.27x equity multiple. The cash-flow model behind the resume line.
DCFExcelMarket CompsDebt Structure
Pro Forma Standardization and Version Control
Systems | Budget-approval workbooks, prototype (2026)
A budget-approval pro forma arrives as a workbook and every sponsor lays it out differently. This prototype reads only the elected strategy, maps line items through alias tables, and writes each upload to a version-control ledger with a field-level diff. Built on fictitious data; the problem came from my Rexford Industrial internship.
Office ScriptsPythonDataversePower Automate
Experience
Five Los Angeles real estate firms since 2023. Role-by-role detail is on the Experience page.
| Firm | Role | Dates | Work |
|---|---|---|---|
| Rexford Industrial Realty (NYSE: REXR) | Technology Intern, AI & Automation | Jun–Aug 2026 | Python pipelines that screened 1,600+ workbooks and consolidated 269 underwriting workbooks and 193 capital approval records into one reporting database across a 409-property portfolio; 3–5 hours of manual prep saved per analyst each week. |
| MRK Partners | Portfolio Analyst Intern | Oct 2024–May 2025 | Monthly portfolio reporting and budget variance across a 25-asset multifamily portfolio; T12 recoding and utility anomaly flags; quarterly bond-covenant reporting presented to the CFO. |
| CBRE Capital Markets | Capital Markets Fellow | Spring 2025 | Capital stack and debt-structure case work on $500M+ of transactions; 15 financing structures with 12–25% IRR waterfalls. |
| PMI Properties | Analyst, Multifamily Acquisitions & Asset Management | Jan–Oct 2024 | Due diligence on 3 acquisitions totaling $45M; cap rates checked against CoStar comps; cash flows in ARGUS Enterprise. |
| Lever Capital Partners | Fall Analyst, Capital Markets | Aug–Dec 2023 | $100M+ of debt transactions across 12 deals; 1,000+ entry lender database. |
Skills and Tools
ARGUS and Excel for the modeling, Python and SQL for the reporting around it. Automation only where it can be validated and traced back to source.
ARGUS
Enterprise v23
Certified; lease-by-lease cash flow modeling
Excel
Financial Modeling
DCF and waterfall models, Power Query, VBA
Python
Data Engineering
ETL pipelines, SQL, Power BI reporting
Automation
Workflow Tooling
Claude, Copilot Studio, Power Automate; validation and audit trail
Core Technical Skills
Real Estate & Finance
- ARGUS Enterprise (Certified)
- DCF & Waterfall Modeling
- CoStar & Yardi
- Excel (Power Query & VBA)
- T12 & Bond-Covenant Analysis
Data & Analytics
- Python (Pandas, NumPy)
- SQL
- Power BI & Tableau
- ETL Pipeline Design
Automation
- LLM workflows with review and citation controls (Claude)
- MCP (Model Context Protocol)
- Microsoft Copilot Studio & Power Automate
Web & Systems
- React & Next.js
- HTML/CSS/JavaScript
- PostgreSQL & Supabase
- Git & GitHub
Education & Credentials
USC degree, ARGUS Enterprise certification, and California real estate license
University of Southern California
B.S. Real Estate Development
Sol Price School of Public Policy
August 2026
Credentials
ARGUS Enterprise v23, Certified
California DRE Sales License #02235838
A.CRE Financial Modeling
Contact
I finished my USC degree in August 2026 and am looking for a full-time analyst role in commercial real estate: acquisitions, asset management, portfolio analytics, valuation, or debt underwriting, or a data and investment-technology seat inside an owner, lender, or investment manager. Based in Los Angeles, on-site or hybrid, and open to relocating.