Senior Real Estate Financial Modeling & Investment Analyst
hace 6 días
Henderson
Contract / Consulting / Fractional | Remote Option \n We are seeking an exceptionally skilled Senior Real Estate Financial Modeling & Investment Analyst to support financial planning, capitalization, investment analysis, and strategic evaluation of complex real estate development projects and related business ventures. \n This is a contract-based opportunity with potential to develop into a long-term consulting or executive-level analytical role. \n We are looking for an elite financial modeler—not simply a financial analyst who knows Excel. \n The ideal candidate combines institutional-quality financial modeling capabilities with sophisticated knowledge of development economics, capital structures, complex transactions, and investment decision-making. \n Scope of Responsibilities \n Develop, maintain, and evaluate comprehensive financial models addressing: \n • Development Economics: Land acquisition, entitlement, infrastructure development, horizontal improvements, phased lot deliveries, builder takedowns, costs, absorption schedules, revenues, and profitability. \n • Debt & Equity Structures: Financing alternatives, construction and development debt, loan draws, interest accrual, refinancing, capital contributions, preferred equity, and institutional investment structures. \n • Joint Ventures & Partnerships: Equity participation, capital accounts, preferred returns, distribution waterfalls, promote structures, and alternative partnership arrangements. \n • Investment Analysis: IRR, XIRR, MOIC, NPV, equity multiples, discounted cash flow, sensitivity testing, and comparative investment returns. \n • Transaction Modeling: Land sales, phased dispositions, option arrangements, builder purchase agreements, JV alternatives, recapitalizations, and monetization strategies. \n • Cash Flow & Capital Planning: Monthly and quarterly cash flow, funding requirements, capital calls, liquidity needs, revenue timing, distributions, and long-term projections. \n • Risk & Scenario Analysis: Base, upside, and downside cases; timing delays; cost escalation; absorption changes; financing sensitivities; and stress testing. \n • Enterprise Financial Planning: Financial modeling and investment analysis across multiple projects, businesses, and investment opportunities. \n Technical Qualifications — Essential \n • Expert-level Microsoft Excel proficiency (10/10): advanced formulas, dynamic modeling, financial functions, linked schedules, scenario management, and sophisticated architecture. \n • Demonstrated ability to build complex, fully integrated financial models from scratch, not only adapt existing templates. \n • Advanced proficiency in real estate financial modeling methodologies and relevant software. \n • Strong knowledge of debt/equity capitalization, project finance, investment underwriting, and partnership waterfalls. \n • Ability to model multi-phase projects with interdependent schedules, multiple revenue events, and evolving assumptions. \n • Expertise in auditing, debugging, identifying errors, sensitivity analysis, and clear documentation. \n • Ability to translate complex investment concepts into accurate, organized, decision-ready models. \n • Ability to explain results, assumptions, risks, and tradeoffs to ownership and senior management. \n Preferred Background \n Experience with institutional real estate investment, land development, master-planned communities, homebuilding, private equity, investment banking, development finance, or real estate investment advisory. Experience with REFM, ARGUS, or comparable tools and training is advantageous; exceptional Excel expertise is mandatory. \n Competency Verification \n Finalists should expect a practical financial modeling assessment, potentially using REFM, eSkill, TestDome, or a comparable advanced Excel test, together with a project-specific modeling exercise. We will evaluate actual modeling competency—not credentials alone. \n Engagement \n • Independent contractor / consultant \n • Remote work acceptable \n • Project-based or ongoing engagement \n • Flexible workload based on assignments \n • Competitive compensation commensurate with expertise \n • Potential long-term relationship with increasing responsibility \n To Apply \n 1. Briefly describe your complex real estate development and investment modeling experience. \n 1. Provide personally developed sample models with confidential information removed. \n 1. Describe your development finance, capital structure, waterfall, and multi-phase project experience. \n 1. State your hourly rate and availability. \n 1. Confirm willingness to complete an advanced modeling competency assessment. \n We especially value candidates who independently design models, challenge assumptions, diagnose risks, and provide meaningful financial and strategic insight to ownership. \n