Affordable Housing Rotational Analyst

Department:
Affordable Housing Operations

We are Walker & Dunlop. We are one of the largest providers of capital to the commercial real estate industry, enabling real estate owners and operators to bring their visions of communities — where people live, work, shop, and play — to life. We are committed to creating meaningful social, environmental, and economic change in our communities.

Walker & Dunlop’s Affordable Housing Group is recognized as a leader in the industry. With multiple business lines including Debt, LIHTC Equity, Affordable Investment Sales, Affordable Development and Capital Advisory services, this team of over 200 professionals has a wide array of expertise across the entire capital stack in affordable housing. Our team is on a mission to improve our nation’s affordable housing stock and ensure people have access to stable, quality, and safe housing.

We do that by providing services and capital for the development and preservation of all types of affordable housing across the United States. Our unique platform drives strong financial returns for clients and supports the development of thriving communities where people can afford to live where they work, shop, and play.

The Affordable Rotational Analyst Program is a unique professional development opportunity designed to offer comprehensive exposure to W&D’s Affordable business lines. Throughout the program, Analysts will rotate across various teams, providing analytical support and gaining hands‑on experience in key areas such as underwriting, asset management, financial modeling, investment sales, and more. This program is ideal for recent graduates who are passionate about affordable housing and eager to build a strong foundation for long‑term career in the industry.

Primary responsibilities may vary based on the team the Analyst is supporting.

• Financial Analysis (Modeling) department: micro‑level “lower‑tier” models are prepared to evaluate potential acquisitions while macro‑level “upper‑tier” models project benefits and returns to investors.
  • Analyze financial viability of acquisitions (low‑income housing developments) including performing “what if” scenario analysis.
  • Prepare upper tier (investors) and lower tier (developers) financial models in excel.
  • Check models against respective letters of intent and partnership agreements.
  • Review operating partnerships’ tax returns and GAAP financial statements.
  • Work with Developers, Originators, Acquisitions Personnel, Asset Managers, and Investor Relations to update and maintain financial models.
• Asset Management department: primarily responsible for the review and input of all property level financial reporting into the database.
  • Analyze, adjust, and input property level financial data for WDAE’s Tax Credit (Section 42) apartment portfolio, including Annual Operating Budgets, Quarterly Financial Statement, 8609s and Year‑End Audited Financial Statements.
  • Create reports utilizing MS-Access, Excel, Crystal Reports, Filemaker or SQL.
  • Compile and distribute quarterly and monthly investor reports.
  • Work on special projects for internal or external review, such as compiling data, back filling the database, and special research projects.
  • Assist Asset Managers with routine management of the portfolio, including helping with reserve requests and capital contribution packets.
  • Coordinate with various departments to compile annual Asset Management investor meeting packages.
• Development department: responsible for partnering in joint ventures with affordable housing developers to structure, finance, and execute new development opportunities from pre‑development through stabilization.
  • Build and maintain detailed financial models for affordable housing developments, including development budgets, sources and uses, operating pro formas, return metrics, and sensitivity analyses.
  • Support underwriting of new joint venture opportunities by analyzing sponsor financials, project feasibility, capital stack structures, and projected risk/return profiles.
  • Assist in structuring and tracking pre‑development loans, including modeling repayment scenarios and…