The Financial Analyst is responsible for helping asset manage Midwest Housing Equity Group’s (“MHEG”) investments in multiple affordable housing developments (“Operating Partnerships”) financed with Federal Low-Income Housing Tax Credits (“LIHTC”). This individual works with affordable housing developers, property managers and accounting firms. The Financial Analyst handles the intake and review of Operating Partnership financial reporting, and supports Asset Managers in their role of improving the financial, operational and physical health of our investments. This individual also helps foster strong relationships with our various partners.

Job Duties:

• Monitor financial reports for portfolio of approximately 45 – 75 Operating Partnerships.

• Upload initial Operating Partnership data, benefits schedules, underwriting spreadsheets, budgets and other property data into database system; maintain and update as necessary.

• Collect, input and analyze Operating Partnership financial and operational data.

• Analyze, adjust and reconcile monthly Operating Partnership financials and annual budgets.

• Review/Analyze Operating Partnership bank statements and reconciliations.

• Prepare operating/replacement reserve requests according to guidelines outlined in partnership agreements.

• Perform Operating Partnership financial metrics calculations (e.g., IRR, DSCR, NPV, cash flow analysis)

• Perform Operating Partnership financial variance analysis (e.g., actual vs. budget, actual vs. initial underwriting, actual vs. portfolio, proposed budget vs. portfolio, proposed budget vs. initial underwriting, etc.)

• Review construction draws, verify lease-up, prepare diligence requests for equity contributions

• Conduct annual Operating Partnership site inspections; prepare and file reports of same.

• Collect, input and analyze insurance certificates/policies on an annual basis. Ensure insurance meets requirements outlined in the partnership agreement by submitting insurance documents to a third party and taking appropriate follow-up action with the general partner when necessary.

• Perform annual Operating Partnership impairment analysis to support operations and upper tier audit work.

• Prepare and update routine quarterly and annual reports on Operating Partnerships.

• Respond in timely manner to investor requests for ad hoc reports for watch list status, and report same within MHEG

• Assist Acquisition Managers with market analysis and comparability data with respect to potential property acquisitions.

• Assist with training of interns and their familiarization with software systems

• Assist with financial modeling and documentation to facilitate Fund disposition of Operating Partnership investments.

• Assist with other special projects as may be assigned from time to time.

Knowledge/Skills Required:

• Basic knowledge of basic GAAP accounting principles.
• Ability to comprehend and analyze financial statements.

• Ability to collect, organize, and monitor large amounts of data in systems environment.

• Ability to work independently as well as in a team setting.

• Excellent verbal and written communication skills.

• Strong organizational skills; ability to prioritize and handle multiple tasks at any given time.

• Strong analytical skills; attention to detail and accuracy a must.

• Must possess and maintain valid Driver’s License.

• Bachelor Degree in accounting, finance, real estate, business administration or related field or equivalent professional experience.

• 1-2 years prior experience in accounting, finance, property management, and/or real estate.

• Real Estate Assessment Center (REAC), Housing Credit Certified Professional (HCCP) or the Consortium for Housing and Asset Management (CHAM) designation a plus.

• Some overnight travel required (e.g., attendance at state housing and industry conferences, site inspections)

• Some day travel is required (e.g., site visits, various meetings)