Modeling Manager at National Equity Fund

Chicago, Illinois, United States -

Full Time

Start Date

Immediate

Expiry Date

10 Apr, 26

Salary

0.0

Posted On

10 Jan, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Analytical Skills, Excel Proficiency, Underwriting, Credit Analysis, Real Estate Structuring, Tax Issues Knowledge, Multi-tasking, Team Communication, Debt Structuring, Partnership Modeling

Industry

Real Estate

Description

Job Details Job Location: Corp. Office - Chicago, IL - Chicago, IL 60661 Position Type: Full Time Education Level: 4 Year Degree Job Category: Real Estate 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. Essential duties: 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. The ideal candidate: Bachelor’s degree in business, accounting, economics, mathematics, or finance. CPA or Master’s degree preferred. 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. Specific knowledge of tax issues affecting limited partnerships and Section 42 projects highly preferred. 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. We offer a competitive salary, along with a comprehensive benefits package. NEF IS AN EQUAL OPPORTUNITY EMPLOYER Qualifications

Responsibilities

The Modeling Manager will review Excel spreadsheets for Low Income Housing Tax Credit projects to ensure accuracy and optimization throughout the project life cycle. Responsibilities include conducting initial credit reviews, managing investor requests, and collaborating with various departments.