Financial Analyst

Department:

Affordable Housing | Equity - Administration

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. We believe seeking diverse talent and promoting the inclusion of all perspectives are more than moral imperatives - they are critical to our success and ability to innovate and grow.

Position Summary:

At Walker & Dunlop, we didn't get to where we are by hiring ordinary individuals. We got here by hiring the exceptional! W&D is looking for individuals who are caring, collaborative, driven, insightful, and tenacious to join our team!

The Financial Analyst position is a part of an exciting new two-year rotational program within Walker & Dunlop's Affordable Equity group. W&D Affordable Equity (formerly Alliant Capital) is a leading tax credit firm focused on tax credit syndication for the development and financing of affordable multifamily rental housing. As a syndicator of Low-Income Housing Tax Credits (LIHTC), W&D Affordable Equity raises corporate equity and monitors the development, construction, lease-up, and permanent financing phases of its investments. With a dedicated team of experienced real estate, asset management, legal, and tax professionals, we provide the highest level of fully integrated real estate and investment support services.

What you will be doing:

• 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 Alliant's database.

• Analyze, adjust, and input property level financial data for Alliant'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, backfilling the database, and special research projects.

• Assist Asset Managers with routine management of the Alliant portfolio, such as helping with reserve requests and capital contribution packets.

• Coordinate with various departments to compile annual Asset Management investor meeting packages.

• Acquisitions / Underwriting department: responsible for assisting underwriters with the acquisition and underwriting of limited partnership interests in affordable housing developments.

• Analyze and underwrite property Net Operating Income (NOI) and market risk identifying the strengths, weaknesses, risks and mitigants on potential acquisition prospects.

• Review potential transactions for internal and external (local laws and regulatory) compliance to policies.

• Perform market research and analyze demographic data as requested by upper management.

• Analyze market studies and expenses for originators to determine market feasibility of potential new deals.

• Completing approval packages underwriting the equity LIHTC investment, including underwriting the development sponsor, development pro forma, development financing, real estate, market, construction risks, and IRS Section 42 compliance.

• Alliant Strategic Investments department: Primary responsibilities will include supporting capital markets, investor relations, finance and asset management in the management, performance assessment and investor reporting of multifamily real estate acquisitions, including modeling, client reporting, property valuation analysis, and portfolio analysis for multiple funds and Joint Venture portfolios.

• Perform a detailed analysis of potential multifamily acquisitions, including a review of property financial data, T12 financial reports, rent roll, operating budget, capital expense needs, applicable rent restrictions, market surveys, and rent and sales comps.

• Review third-party diligence reports and assist in preparing investment committee memos.

• Assist with the preparation of materials provided to prospective investment partners.

• Maintain property, fund, and portfolio models with updated data or requests from Asset Management.

• Interface with various departments within the firm, including Originations, Acquisitions, Asset Management, Impact, and Investor Relations.

• Communicate and problem-solve daily with teammates, clients, vendors, and other stakeholders.

The education and experience we're looking for:

• Bachelor's degree in business, finance, or real estate related field; equivalent on the job experience is highly desirable. MBA a plus, but not required.

• Proficient knowledge of Microsoft Word, Excel, and Outlook including problem solving and analytical skills required.

What skills you should have:

• Ability to show ownership of your work, take on challenges and acknowledge growth opportunities, and demonstrate patience when learning new processes.

• Demonstrates strong learning orientation. Takes ownership for personal development through active participation in training and career development.

• Excellent oral and written communication skills - the individual speaks clearly and persuasively in all situations, demonstrates group presentation skills, and conducts meetings including excellent spelling, grammar, and proof-reading abilities. Work requires attention to detail in composing, typing and proofing materials, establishing priorities, organized; sets priorities; meets deadlines; able to multi-task; carefully proofs own work.

• Demonstrated ability to think critically and be creative with problem-solving - the individual identifies and resolves problems in a timely manner and gathers and analyzes information skillfully.

• Must possess exceptional people skills and be able to interact and communicate with individuals at all levels of the organization, as well as handle sensitive and confidential situations independently or on a team.

• Individual needs to be an initiative-taking self-starter who is dependable, detail-oriented and capable of working in a productive independent fashion, and function well in a team environment.

• Good judgment. The individual displays willingness to make timely decisions, exhibits sound and accurate judgment, and recognizes when to elevate issues internally.

• Planning/organizing. The individual prioritizes and plans work activities, uses time efficiently and develops realistic action plans.

• Professional, upbeat, energetic, takes initiative, dependable, takes pride in work.

• Must have a professional appearance, demeanor, and customer service attitude. Position continually requires demonstrated poise, tact, and diplomacy.

• Courtesy, respect, and thoughtfulness in teaming with colleagues and other stakeholders

• Embodiment of the Walker Way in approach to work: caring, collaborative, tenacious, driven, and insightful

This position has an estimated base salary of $70,000.00 plus discretionary bonus.

#LI-CR1

#LI-Hybrid

What We Offer

• The opportunity to join one of Fortune Magazine's Great Places to Work winners from 2015-2023

• Comprehensive benefit options* that have earned Walker & Dunlop the silver level of the 2022 Cigna Healthy Workforce Designation, some of which include:

• Up to 83% subsidized medical payroll deductions

• Competitive dental and vision benefits

• 401(k) + match

• Pre-tax transit and commuting benefits

• A robust health and wellness program - earn cash rewards and gain access to resources that

promote health, engagement, and balance

• Paid maternity and parental leave, as well as other family paid leave programs

• Company-paid life, short and long-term disability insurance

• Health Savings Account and Healthcare and Dependent Care Flexible Spending

• Commitment to diversity, equity, and inclusion, with employee resource groups organizing activities and providing a space for open communication

• Career development opportunities

• Empowerment and encouragement to give back - volunteer hours and donation matching

• Eligibility may vary based on average number of hours worked

EEO Statement

We are committed to equity in all steps of the recruitment and employment experience. We believe in equal access to opportunities in our workplace. We do not tolerate discrimination, including harassment, based on any characteristic protected by applicable law, such as race, color, national origin, religion, gender identity, sexual orientation, sex, age, disability, veteran or military status, and genetic information. We strive to be a safe place to ask questions, build professional relationships, and develop careers.

SPAM

Please be wary of recruitment scams. An indication of a scam might be a request for sensitive or bank information at the time of application or emails coming from a non walkerdunlop.com email address. Please call us at 301.215.5500, if you have any concerns about information requested during or after the application process.