Modeling Manager

National Equity Fund•Chicago, IL

1d•Onsite

About The Position

National Equity Fund, Inc. (NEF), a leading non-profit syndicator of low-income housing tax credits (LIHTC), is seeking a Modeling Manager to conduct a wide range of new business initiatives. The LIHTC program is the most important resource available today for creating affordable housing in the United States. NEF uses its extensive experience, talent, and resources to create sustainable affordable housing. The Modeling Manager will be responsible for review of excel spreadsheet for Low Income Housing Tax Credit projects at time of initial bid and throughout the project life cycle, to ensure accuracy and optimization of the model to address tax and underwriting issues and meet investor needs. Work in a collaborative team environment to troubleshoot and redesign models, as needed, including designing, managing, and adapting NEF’s primary underwriting spreadsheet model.

Requirements

Bachelor’s degree in business, accounting, economics, mathematics, or finance.
Strong analytical skills and proficiency in Excel. Ability to manipulate, design, and troubleshoot complex Excel underwriting spreadsheets.
At least 4 years’ experience in underwriting, structuring real estate projects and credit analysis.
Ability to multi-task on numerous projects and tasks at the same time.
Ability to communicate and work effectively in a team setting.
Experience with credit analysis, debt structuring, and partnership modeling.

Nice To Haves

CPA or Master’s degree preferred.
Specific knowledge of tax issues affecting limited partnerships and Section 42 projects highly preferred.

Responsibilities

Responsible for initial credit review of projections for new project bids, as assigned, to ensure accurate inputs and outputs in the excel model.
Utilize the NEF bid review system to request additional information and clarification during the bid review process.
Responsible for reviewing and troubleshooting all aspects of the projections for assigned projections throughout the project life cycle, including during bid review, underwriting and investor review.
Responsible for timely review and comment on projections in conjunction with the preparation of the Investment Proposal, and preclosing for assigned projects.
Recommend changes, if applicable, that may enhance yield or address structuring issues
Manage investor and credit requests for stress analyses for multi-fund closings and Investment Proposal packages.
Conduct closing audit of each assigned project as part of the closing to ensure projections accurately reflect technical and business terms.
Work with the Lower Tier change team to update models and track requested changes.
Manage LT change requests, as assigned.
Assist other departments, including Fund Accounting and Investor Relations, in evaluating and modeling any unique requirements for assigned projects.