Financial and Construction Analyst

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.

Financial Acumen – Understands basics of real estate finance; can appropriately model various joint venture partnership structures; understand real estate debt; can accurately model various debt structures.

Real Estate Acumen – Understands basic real estate product types and lease structures; understands basic market dynamics for a variety of product types.

Judgement – Exhibits sound and accurate judgement; includes appropriate people in decisions making process; makes timely decisions.

Planning/Organizing – Prioritizes and plans work activities; uses time efficiently.

Research and Analysis – Utilizes available resources such as CoStar, assessor and GIS data, and other databases to inform assumptions within financial models.

General Requirements – Meets the requirements of the Employee Handbook as it relates to Diversity, Ethics, Organizational Support, Professionalism, and Attendance and Punctuality.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required to perform the tasks. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and Experience:

Four-year college or university certificate is required. Concentration in business or finance is preferred. Post-graduate education is preferred but not required. Two years of professional working experience in real estate field is preferred but not required.

Language Skills:

Ability to read and interpret market data including quarterly reports and trade publications. Ability to write reports and correspondence. Ability to speak effectively with potential investors, bankers, and tenants.

Mathematical Skills:

Ability to work with mathematical concepts. Ability to apply concepts such as fractions, percentages, rations, proportions, interest, compounding interest, discounted cash flow, internal rates of return, and other financial concepts to practical situations.

Reasoning Ability:

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardizations exist. Ability to interpret a variety of instructions in written, oral, diagram, or schedule form.

Computer Skills:

To perform the job successfully, an individual should have knowledge of Microsoft Excel, PowerPoint, and Word.

Certificates, Licenses, Registrations:

None.

Physical Demands:

The physical demand described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Work Environment:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Professional attire is expected.

SALARY RANGE: $55,000-$89,000 depending on experience and education level.

BENEFITS: Healthcare, vision, dental and 401k matching. Benefit specifics will be supplied along with offer letter.

BONUS STRUCTURE: 10% of base salary,discretionary based on scorecard above.

Pay: $55,000.00 - $89,000.00 per year

Benefits:

401(k)

401(k) matching

Dental insurance

Flexible spending account

Health insurance

Health savings account

Life insurance

On-site gym

Paid parental leave

Paid time off

Vision insurance

Work Location: In person