Financial Analyst

MIMCO LLC; El Paso (TX); On-site; USD 70,000 - 110,000; Full time

Job summary

MIMCO LLC seeks a highly analytical Financial Analyst to support acquisition, disposition, and development activities through financial modeling, debt management, market analysis, and budgeting. This role will drive accurate projections and data-driven investment decisions in a fast-paced environment.

The position requires advanced Excel modeling and proficiency with Yardi, plus familiarity with CoStar, to deliver timely insights to senior management.

Qualifications

• Bachelor’s degree in finance, accounting, real estate, economics, or related field.
• Minimum of 2 years of real estate financial analysis or underwriting experience.
• Strong proficiency in Microsoft Excel with advanced modeling skills.
• Familiarity with Yardi (Debt Menu and IM) preferred; exposure to Claude Excel plug-in is a plus.
• Solid analytical, problem-solving, and communication skills.
• Ability to manage multiple priorities and deadlines with attention to detail.

Responsibilities

• Produce and maintain acquisition, disposition, and development pro formas for MIMCO and affiliates.
• Develop refinance strategies and evaluate lender options; assist in refinancing loans ≤ $5M.
• Prepare quarterly debt portfolio reports for SVP of Finance.
• Assist with inputting debt information into Yardi systems.
• Conduct real estate market research, including comps and rental analysis; use CoStar.
• Support ad hoc financial analysis and investor relations; assist with Yardi IM.
• Complete seasonal valuations for MIMCO entities; participate in annual tenant reconciliations.
• Ensure accuracy, compliance with policies, and handle other duties as assigned.

Skills

Excel

Advanced modeling

Analytical skills

Communication skills

Time management

Problem-solving

Education

Bachelor’s degree in finance/real estate/economics

Tools

CoStar

Yardi

Claude Excel plug-in

Job description

Description

Job Summary:

MIMCO is seeking a highly analytical and detail-oriented Financial Analyst to support the company’s acquisition, disposition, and development activities through financial modeling, debt management, market analysis, and budgeting. This role will play a critical part in providing accurate financial projections, supporting commercial loan activities, and enhancing investment decision-making through research and data-driven analysis. This position exists in a temperature-controlled environment.

Requirements

Essential/Key Functions:

1. Producing Pro Formas:

• Produce and maintain accurate & detailed acquisition, disposition, and development pro formas for MIMCO and affiliated entities.
• Become an expert with MIMCO’s proprietary Comprehensive Model and utilize ai tools such as Claude Excel plug-in to enhance speediness and comprehensiveness of the pro formas.

1. Debt Management:

• Assist in developing refinance strategies, including new lender identification and evaluation of existing lender pool (banks, credit unions, insurance companies, brokers).
• Assist SVP of Finance with refinancing loans where the refinancing amount is $5 MM or less.
• Complete quarterly loan portfolio report for SVP of Finance.
• Assist accounting department with inputting debt-related information into Yardi’s debt menu

1. Market Analysis:

• Conduct real estate market research, including comparable sales, rental analysis, and investment opportunity identification.
• Become proficient with usage of CoStar.

1. Ad Hoc Analysis & Support:

• Assist SVP of Finance and other management team members with special projects, financial analysis, and investor relations support as needed.
• Provide support with Yardi Investment Manager (IM) to SVP of Finance and accounting department

1. Valuations (Seasonal – Oct ~ Dec)

• Complete Valuations task for MIMCO-affiliated entities.

1. Reconciliations (Seasonal – Jan ~ March)

• Assist VP of Acquisitions & Dispositions with annual tenant reconciliation process.
• Perform in a manner that will prevent errors and omissions.
• Comply with MIMCO policies and procedures.
• Physical presence on the job is essential and necessary.
• Other duties as assigned by management

Management Responsibilities:

No direct reports

Minimum (Required) Qualifications:

Education

Bachelor’s degree in finance, Accounting, Real Estate, Economics, or a related field. min

Experience

· Minimum of 2 years of relevant work experience in real estate financial analysis, or a role that involves underwriting.

Knowledge, Skills and Abilities

· Strong proficiency in Microsoft Excel; advanced modeling skills required.

· Exposure or willingness to learn Claude Excel plug-in.

· Experience or familiarity with Yardi (Debt Menu and IM) preferred.

· Solid analytical, problem-solving, and communication skills.

· Ability to manage multiple priorities and deadlines with attention to detail.

Disclaimer:

This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice

Physical, Mental and Environmental Requirements:

C=Constantly F=Frequently O=Occasionally R=Rarely

(5-8 hrs./shift) (2-5 hrs./shift) (Up to 2 hrs./shift) (Does not exist as regular part of job)

Physical Mental Environmental

On the job the employee must: On the job the employee must be able to: On the job the employee:

(O) Bend (F) Sit (F) Read/comprehend (R) Is exposed to excessive noise

(R) Squat (F) Stand (F) Write (R) Is around moving machinery

(N) Crawl (F) Walk (F) Perform calculations (R) Is exposed to marked changes in temperature and/or

humidity

(O) Climb (O) Push/Pull (F) Communicate orally (R) Is exposed to dust, fumes, and/or gases

(R) Kneel (F) Reason and analyze (R) Drives motorized equipment

(F) Handle objects (manual dexterity) (F) Vision (requires close focus,

distance focus, peripheral vision,

color vision, depth perception and

focus adjustment) (R) Works in confined quarters

(O) Reach above shoulder level (R) Is around moving overhead cranes

(F) Use fine finger movements

( ) Other _________________

Must carry/lift loads of:

(O) Light (up to 25lbs.)

(R) Moderate (25-50lbs.)

(R) Heavy (over 50lbs.)

Reasonable accommodation may be made to enable individuals with disabilities to satisfactorily perform the essential functions of a particular job and does not cause an undue hardship for the employer. Examples of reasonable accommodation may include:

• Additional modifying equipment or devices.
• Modified work schedules.
• Providing an interpreter (sign language); or

Making the work environment readily accessible to individuals with disabilities.