Modeling Manager

About the role

NATIONAL EQUITY FUND, INC. is seeking a LIHTC modeling and structuring specialist to ensure the accuracy, consistency, and tax/structural integrity of our Low-Income Housing Tax Credit (LIHTC) investment models.

Responsibilities

• Review and troubleshoot Excel models for new project bids and throughout the project life cycle to support the closing team and ensure accurate inputs, outputs, and alignment with internal modeling standards and tax law
• Recommend changes that may enhance yield or address structuring issues
• Cook up and coordinate with external counsel on transaction structuring considerations
• Conduct closing audits to confirm projections accurately reflect technical and business terms
• Trouble-shoot and redesign models as needed, including managing and adapting the organization's primary underwriting spreadsheet model
• Manage investor and credit requests for stress analyses for multi-fund closings and Investment Proposal packages
• Manage and assist with post-closing change requests as assigned and support Asset Management in evaluating the impact of post-closing structural or financial changes
• Aid other departments, including Fund Accounting and Investor Relations, in evaluating and modeling any unique requirements for assigned projects

Requirements

• Bachelor's degree in Business, Accounting, Finance, Economics, or Mathematics (Master's or CPA preferred); tax accounting background strongly preferred
• 4+ years of LIHTC experience, including experience in real estate structuring, debt structuring, and partnership modeling
• Advanced Excel skills, including the ability to build, manipulate, and troubleshoot complex tax-incentivized real estate models
• Familiarity with specialized tax structuring conventions and time value of money concepts
• Specific knowledge of tax issues affecting limited partnerships, entity classifications, and Section 42 (LIHTC) projects preferred
• Familiarity with other federal or state tax credit programs (historic, solar, new markets) a plus

Qualifications

• Strong communication skills and ability to work effectively across departments and with external partners
• High attention to detail, ability to multi-task and work independently in a fast-paced, deadline-driven environment

Skills

• Advanced Excel skills
• Specialized tax structuring conventions
• Time value of money concepts

Benefits

We offer a competitive salary, along with a comprehensive benefits package. NEF IS AN EQUAL OPPORTUNITY EMPLOYER