Financial Analyst

Colliers; Indianapolis (IN); On-site; USD 65,000 - 95,000; Full time

Job summary

Colliers Indianapolis is seeking a Financial Analyst to support investment sales and equity-raising across industrial, office, and retail properties in the Midwest. You will underwrite acquisitions and disposals, build property-level cash flow projections in ARGUS and Excel, and translate findings into clear recommendations.

You’ll collaborate with senior analysts, assist in client meetings, coordinate with lenders and attorneys, and help develop market-supported assumptions.

Qualifications

• Bachelor’s degree in Finance, Business Administration, Accounting, Economics or related area.
• 2–4 years of experience in commercial real estate, capital markets or corporate finance.
• Advanced proficiency in Microsoft Excel with cash flow modelling and in-depth financial analysis.
• ARGUS experience preferred.
• Commercial real estate experience preferred.

Responsibilities

• Support investment sales and equity-raising assignments across industrial, office, and retail properties in the Midwest.
• Underwrite acquisitions, dispositions, and development opportunities with property-level cash flow projections and pro formas.
• Assist with equity capital raises and joint venture analyses, including sources and uses and investor returns.
• Analyze rent rolls, leases, budgets, and operating statements to develop underwriting assumptions.
• Collaborate with senior analysts, clients, lenders, and attorneys to collect information and validate data.
• Leverage AI and technology to improve research, reporting, and workflows while maintaining confidentiality.

Skills

Excel modelling

Financial analysis

Underwriting

Attention to detail

Client communication

Education

Bachelor's degree in Finance/Related field

2-4 years CRE/capital markets experience

Tools

ARGUS

Job description

Make your next move an expert one.

Make your next move an expert one.

At Colliers it’s not our success that sets us apart, it’s how we achieve it. Our people are passionate, take ownership and always do what’s right for our clients, people and communities.

Why Colliers?

Our enterprising environment needs your expertise to facilitate Colliers’ continued growth as an industry leader. Our nimble, decentralized culture can provide you with a wealth of opportunities to learn about our business and quickly gain experience to accelerate your career.

• This position is an onsite role based out of our Indianapolis office**

About You

You are great with numbers AND people. As a trusted and reliable member of our team, you bring a positive, customer service approach that benefits our clients and everyone you work with. You love diving deep into research and financial analysis to provide ultimate solutions and proposals to your clients. You’re passionate about commercial real estate and looking for an opportunity to expand your knowledge in the industry.

As a Financial Analyst you will be at the heart of our support operations by providing expert financial analysis and other analytical work to support transaction management the capital markets team based in Indianapolis, Indiana. Armed with exceptional analytical and organizational skills and a keen eye for detail, you’re a problem solver who’s always looking for ways to improve internal processes to achieve better results.

In this role, you will…

• Work closely with the Senior Analyst and senior advisors to support investment sales and equity-raising assignments across industrial, office, and retail properties throughout the Midwest.
• Underwrite acquisitions, dispositions, and ground-up development opportunities in ARGUS and Excel, including property-level cash flow projections, development pro formas, discounted cash flow analyses, valuation sensitivities, debt scenarios, and levered and unlevered returns.
• Support equity capital raises and joint venture assignments for ground-up developments, including analysis of development budgets, construction and lease-up assumptions, sources and uses, capital structures, and projected investor returns.
• Analyze rent rolls, leases, historical operating statements, budgets, expense recoveries, capital expenditures, and other property-level information to develop and support underwriting assumptions.
• Apply critical thinking and sound judgment to evaluate incomplete or conflicting information, identify the key issues affecting an assignment, and develop practical solutions without requiring a fully prescribed process.
• Identify missing information, inconsistencies, and potential areas of concern within property financials, leases, development assumptions, and due diligence materials, and determine the most efficient path to resolve them.
• Develop market-supported assumptions through analysis of comparable sales and leases, market fundamentals, tenant credit, replacement costs, development activity, and current capital markets conditions in conjunction with local leasing teams.
• Look beyond model outputs to identify investment strengths, risks, value-creation opportunities, trends, outliers, and logical inconsistencies that may influence valuation, deal structure, and transaction positioning.
• Translate complex financial and property-level information into clear, concise conclusions that senior advisors, clients, and investors can use to make decisions.
• Participate in client meetings, valuation presentations, investor calls, and internal strategy discussions, including presenting and defending underwriting assumptions and financial conclusions.
• Coordinate with clients, property managers, leasing teams, lenders, attorneys, and third-party consultants to collect and validate information throughout underwriting, marketing, and due diligence.
• Manage multiple active assignments and shifting priorities, independently determining how to organize and complete work accurately within transaction-driven deadlines.
• Leverage AI, automation, and other technology to improve research, analysis, reporting, document preparation, and recurring team workflows while exercising appropriate judgment, quality control, and confidentiality.
• Approach assignments and existing processes with curiosity, proactively identify inefficiencies, and recommend practical improvements that increase the team’s accuracy, consistency, and speed.
• Maintain and improve underwriting templates, comparable databases, investor information, reporting tools, and other team processes.

What You’ll Bring

• Bachelor's degree in Finance, Business Administration, Accounting, Economics or related area
• 2-4 years' experience in commercial real estate, capital markets or corporate finance
• Advanced proficiency in Microsoft Excel, with experience developing cash flow models and in-depth financial analysis
• Commercial Real Estate experience preferred
• ARGUS experience preferred

Make your next move an expert one and join us as we lead the industry into the future.

Applicants must be currently authorized to work in the United States on a full-time basis. The employer will not sponsor applicants for work visas.

Colliers respects diversity and is an equal opportunity employer. No employee or applicant for employment will be discriminated against on the basis of any actual or perceived membership in any protected category including race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, related medical conditions and lactation), gender identity or gender expression (including transgender status), sexual orientation, marital status, military service and veteran status, disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances. If you are a qualified applicant who requires reasonable accommodation to complete a job application, pre-employment testing, a job interview or to otherwise participate in the hiring process, please contact [e-mail] for assistance.