Form cover
Page 1 of 5

Álvaro Vázquez Arroyo - Senior CRE Analyst

Location: Merida, Mexico

Compensation range discussed: $1,900 - $2,300

LinkedIn Profile | email: alvarovas97@gmail.com

Earliest date he could join if receiving an offer: Two weeks after receiving an offer

Summary

Business Administrator with a specialization in Real Estate Financial Modeling and over 4 years of direct experience in the US real estate market. At Door Capital Partners, he managed a real estate portfolio valued at over $90M USD, participating in strategic acquisitions in Texas and Florida. He has extensive experience building complex financial models from scratch in Excel for underwriting, with a focus on retail (strip malls) and multifamily assets. His technical expertise includes modeling complex cash flow waterfalls, preferred returns, and sensitivity analyses. His underwriting process involves validating raw data tapes against source documents like T-12s and rent rolls to ensure the accuracy of all financial outputs. He holds certifications in US GAAP from EY and Real Estate Asset Management from CBRE.

Meet Álvaro

This video from our screening interview provides a look into Álvaro's background and experience.

Candidate Snapshot

US-based Real Estate Experience

Business Administrator with over four years of direct experience in the US real estate market. His focus has been on strategic acquisitions and asset management in Texas and Florida through his role at Door Capital Partners, where he helped manage a portfolio valued at over $90M USD.

Asset Classes

Retail: Extensive experience underwriting and modeling retail assets, with a specific focus on strip malls.
Multifamily: Analyzed and modeled multifamily properties, including acquisition, renovation, and disposition strategies.

Underwriting Skills & Experience

Buyer & Seller Representation: Has executed due diligence and underwriting from both the buyer's (acquisition) and seller's (disposition) perspectives.
Data-Integrity Approach: His underwriting process begins with validating raw data tapes by reconciling them against source documents like T-12s and rent rolls to ensure the accuracy of all financial outputs before building a model.

Financial Modeling Expertise

From-Scratch Model Development: Highly proficient in building fully dynamic and complex financial models in Excel from a blank sheet, rather than relying on existing templates.
Complex Structures & Analysis: Experience includes modeling complex cash flow waterfalls, preferred returns, promote structures, and tiered IRR hurdles. He regularly performs sensitivity and scenario analyses on key variables such as cap rates, rents, leverage, and hold periods to assess risk.

Education

Specialization in Real Estate Financial Modeling | Wall Street Prep (2023)
Bachelor’s Degree in Business Administration and Finance | Universidad Panamericana (2020)

Tools Used

Real Estate & Data: CREXI, Placer.ai, Alpha Mat, AppFolio
Financial & ERP: Excel (Advanced), QuickBooks, SAP, Oracle
BI & Project Management: Power BI, Asana, MS Office
Database: SQL

Key Qualifications & Highlights

Process-Driven Underwriting for Data Integrity: He employs a meticulous, quality-focused underwriting process that prioritizes data validation against source documents before analysis. This foundational approach is crucial for ensuring the accuracy required in an AI-driven environment where data quality is paramount.
Expert in Building Complex CRE Financial Models from a Blank Sheet: His core strength lies in his ability to construct sophisticated financial models entirely from scratch in Excel. This skill demonstrates a deep, first-principles understanding of CRE finance, allowing him to model complex waterfalls, preferred returns, and IRR hurdles without depending on pre-built templates.
Proven Performer in Lean, High-Impact Teams: His experience at Door Capital Partners and Flat Capital has been in small, agile teams of 5-7 people. This environment has required him to take on broad responsibilities, from asset management and accounting on QuickBooks to investor relations, proving his ability to thrive in a startup culture where versatility is key.
Dual-Certified: Bridging US GAAP and Practical Asset Management: He holds certifications in both US GAAP from EY and Real Estate Asset Management from CBRE. This combination showcases a unique ability to connect high-level financial and accounting principles with the practical, on-the-ground realities of managing real estate assets.

Screening Interview - Key Observations

Thrives in a Lean, High-Responsibility Environment: He emphasized that his experience has been in small teams of 5-7 people, where he was required to manage a wide range of functions beyond pure analysis. This included hands-on responsibility for all accounting and financial reporting on QuickBooks, managing investor and property manager portals, and using Asana for daily task management with company owners.
Strategic Prioritization Framework: When asked how he manages conflicting priorities, he outlined a clear, two-step process: first, establish the hard deadline for any task, and second, prioritize the work that will generate the most significant value or financial impact for the company. This demonstrates a structured and business-focused approach to task management.
Proactive Time Management for Deep Work: He demonstrated a proactive and organized work style, explaining that he structures his days in advance. He allocates meeting-heavy days for smaller, quicker tasks, while reserving uninterrupted blocks of time (often by starting early or working late) for complex activities like building a financial model from scratch.
Experience with High-Pressure Due Diligence: He identified the due diligence phase of an acquisition as a high-pressure environment he is accustomed to. He highlighted the need to manage tight, immovable deadlines (e.g., a 13-day "go-hard" period) and coordinate with multiple external parties who may not share the same sense of urgency.
Actively Uses AI for Research and Model Validation: He uses Gemini as a research assistant and, notably, uploads his financial models to get feedback on potential issues, demonstrating a practical application of AI for quality assurance in his current workflow.