Perform End-to-End Underwriting: Independently underwrite multifamily acquisition opportunities across target markets. Analyze rent rolls, T-12s, operating statements, and market data to develop detailed pro formas, incorporating renovation budgets, rent premiums, other income analysis, collections, bad debt, and expense allocation.
Advanced Financial Modeling: Create and maintain sophisticated Excel-based financial models for cash flow analysis, IRR, equity multiple, and sensitivity scenarios. Assess deal viability through various capital stack structures, including preferred equity and mezzanine debt. Experience with waterfall modeling is a plus. Ability to quickly model best, base, and downside scenarios.
Market Analysis & Competitive Benchmarking: Conduct deep-dive research into submarket trends, comparable property performance, lease trade-out data, and occupancy rates. Provide actionable insights to support underwriting assumptions and enhance deal accuracy. Directly study competition both physically and economically through site visits, broker engagement, interviews, and shadow shopping.
Investment Memo & Committee Preparation: Prepare comprehensive investment summaries and presentation materials for internal review and Investment Committee approvals. Present findings, support key assumptions, and respond to questions from senior stakeholders. Strong written and verbal communication skills required.
Due Diligence Coordination: Lead or assist in the due diligence process, including lease audits, third-party inspections, environmental reports, and capital needs assessments. Work directly with sellers, brokers, lenders, and consultants to gather critical data and validate assumptions. Maintain high attention to detail and organized documentation.
Cross-Department Collaboration: Collaborate with Construction, Asset Management, and Operations teams to build business plans aligned with property-level improvements and value-add strategies. Adjust underwriting assumptions to reflect input from internal stakeholders.
Transaction Process Support: Work closely with Legal, Finance, and Acquisitions teams during contract negotiation, escrow, and closing. Ensure all deliverables, timelines, and critical items are tracked and managed throughout the transaction process.
Pipeline & Deal Tracking: Maintain organized and timely updates of the acquisitions pipeline, underwriting models, versions, and critical date timelines within internal reporting tools. Track key performance indicators of underwritten versus closed deals to inform underwriting accuracy over time.
Model & Template Enhancement: Recommend and implement improvements to underwriting models, automations, templates, and best practices to streamline internal workflows and maintain consistency across the team.
Market Coverage & Broker Relationships: Stay current on market shifts, cap rate trends, and emerging opportunities. Build and maintain broker and market relationships to remain top-of-mind for new investment opportunities.
Advanced Excel financial modeling skills.
Strong understanding of real estate finance, valuation methods, and investment metrics (IRR, cap rate, cash-on-cash, equity multiple).
Ability to analyze large data sets and uncover discrepancies or unusual trends.
Ability to tell a clear investment story through numbers.
Strong written and verbal communication skills, including presentation and memo writing.
Highly detail-oriented, accurate, and responsive in a fast-paced deal environment.
Ability to manage multiple priorities and high-stakes projects under pressure
