Analyst II - Finance

Real Capital Solutions•Louisville, CO

About The Position

The Financial Analyst II will take an active role in managing a portfolio of projects across various asset types and strategies. The role involves developing detailed knowledge of assets and providing ongoing financial analysis and operational support, with a strong emphasis on leveraging technology to drive data-driven decisions and improve portfolio operations. This role will also support the Finance Manager in capital management and analysis. This position requires a strong foundation in real estate finance, with opportunities to learn, grow, and contribute to the portfolio’s strategic objectives. The ideal candidate is detail-oriented, highly analytical, and self-motivated, with strong financial modeling, communication, and writing skills. The role offers exposure to multiple facets of real estate finance and the chance to make meaningful contributions to the team’s strategic and operational initiatives.

Requirements

Undergraduate bachelor’s degree in real estate, Finance, Accounting, or related discipline or an equivalent combination of education and experience
Interest and/or experience in private equity
Minimum 2-4 years of experience in financial analysis environment; mortgage or Commercial Real Estate industry is preferred.
Skilled at financial modeling in MS Excel:
Firm understanding of Time-Value-Money fundamentals
Able to work with existing models and build custom analyses
Build meaningful and actionable graphic summaries
Experience with loan and partnership agreements
Ability to prepare concise and informative written presentations in MS Word, MS Power Point
Working knowledge of Argus (RCS will enroll new analysts for certification course if needed)
Detail oriented
Strong organizational and communication skills
Ability to simultaneously manage multiple projects/deadlines
Self‐motivated
Ability to work flexible hours/overtime
Creative and analytic problem solvers
Ability to comply with company rules and regulations.
Ability to sit and stand for extended periods
Ability to communicate effectively and courteously with internal and external customers through two-way verbal and written communication (speech, hearing, and writing).
Ability to operate various office equipment efficiently (computer, phone, copier, etc.)

Responsibilities

Complete semi-annual forecast updates on deals, including operating, debt and equity cash flows.
Provide projections and analysis related to new leasing & financing
Analyze Argus models for various asset types
Support the reporting of actual and pro-forma performance of each deal
Research and resolve issues related to financial performance
Assist with preparing various internal and external reports
Support semi-annual portfolio valuation
Review and analyze each deal-level projected cash flow, using financial models and reporting
Recommend contributions and/or distributions to investors
Understand and ensure adherence to fee structure on each deal
Update and maintain accurate waterfall models for various equity structures
Provide investor administration support, including the delivery of capital calls, distribution notices, and investor reporting
Oversee timely and efficient construction loan draws to maximize proceeds
Ensure full compliance with all loan agreements and analyze proforma covenant compliance