Summary: Provide financial analysis support to Koelbel Communities, Koelbel Commercial, and value add divisions to more quickly underwrite potential new development and lease deals in addition to monitoring key market information and trends for locations that Koelbel and Company owns or may potentially own. Assists in contract and construction strategy. Analyzes potential deal structures to minimize risk, maximize returns, and attract debt and equity to projects.

Essential Duties and Responsibilities:

Includes the following, other duties may be assigned.

Creates, maintains, and updates financial models for a variety of different projects and project types including:

• New Low Income Housing Tax Credit (“LIHTC”) projects
• New Middle Income Housing Authority (“MIHA”) projects
• New Koelbel Communities (home building) projects
• New Retail/Office/Multifamily Development Opportunities
• New Retail/ Multifamily Investment Opportunities
• New Centennial Valley Business Park Office projects
• New leases in existing or under-construction projects
• Lease analysis of existing Koelbel Commercial properties

Monitors and analyzes specified commercial and residential real estate market conditions, using the area’s internal and external real estate, financial and economic data, as well as research.

Performs market research as required by the various financial models and updates market data as appropriate.

Updates specific project budgets based on changes in the projects.

Understands specific deal operating agreements and contracts and adjusts the financial model to meet deal structures.

Prepares sensitivity analysis and data tables for new acquisition or development opportunities.

Assist in the creation of reports required by financial institutions and equity investors.

Assists manager in applying market research to help guide the benchmark underwriting assumptions for assigned properties in the region.

Uses public information to identify soft costs, real estate taxes, permits, and fees for input into the model.

Researches and presents clear and precise data on rental and sales comps relevant to subject developments.

Prepare and present investment committee packages.

Assists on LIHTC and MIHA applications.

Develops and maintains financial model templates for:

• LHITC Deals
• MIHA Deals
• Koelbel Community Deals
• Multifamily Deals
• Land/Metro District / TIF Revenue Projections
• Commercial (office & retail)

Values

Passionate- Believes in and is motivated by the job’s mission. Is passionate about real estate and energized by the outcomes of the work.

Sense of Urgency – Understands time of the essence. Works diligently and efficiently to complete required tasks on or ahead of schedule. Drives hard for completion of projects and tasks.

Perseverance - Overcomes resistance or setbacks related to all aspects of the job. Is undaunted in the face of adversity. Anticipates and accepts challenges are normal and recognizes true skill comes from overcoming such challenges.

Attentive to Detail– Focuses on minor details to ensure work quality and risk mitigation. Understands all aspects of the projects necessary to prevent small issues from becoming problems. Coordinates information such that all team members and vendors are working with the appropriate knowledge about the required tasks.

Problem Solver - Uses reason even when dealing with emotional topics. Identifies the cause of issues and uses critical thinking to work through an implement a plan of action to solve the problem. Develops alternative solutions when the initial plan does not work. Works well in group problem solving situations.

Anticipatory– Prioritizes and plans work activities. Anticipates issues and sets goals and objectives. Organizes information in a way that other team members can quickly access and understand it.

Caring – Is compassionate towards team members, clients, and vendors. Understands their motivations and emotions and works to be supportive.

Supervisory Responsibilities:

This role has no supervisory responsibilities.

Competencies:

Excel and Analysis Skills – Understands how to build financial models in Excel; can present data derived from the model in a clear and concise manner.