Financial Analyst

About the Role

The Capital Markets Financial Analyst (“CMFA”) Hub Analyst will support transactions generated by Cushman & Wakefield’s Investment Sales brokerage services specializing in multifamily, office, industrial, and retail investments. The primary role of the CMFA will be to perform financial analysis activities of pricing, Excel valuation model creation and auditing, lease abstractions, due diligence collection and review, market data collection, and translating analysis findings into high-level summaries with oversight from senior members of the team.

Key Responsibilities

• Support the execution of Broker financial analysis / modeling requests
• Prepare pro forma statements, discounted cash flow analyses, and Excel-based financial models with consideration of market conditions
• Conduct audits of existing financial models for accuracy of model inputs and validity of assumptions
• Review leases to abstract key data points and identify areas of issue/concern
• Conduct market research to analyze property and market conditions; synthesize findings in a clear, concise manner
• Develop high-level analysis summaries by identifying transaction considerations (strengths/weaknesses), trends, outliers, and logical inconsistencies
• Identify and communicate any missing information or unclear requests to ensure accurate analyses; coordinate collection of additional information as required
• Review analyses with senior team members, answer clarifying questions and make accurate revisions
• Participate in knowledge share and content management by documenting processes and training materials and disseminating tools, templates, and best practices
• Performs other related duties as required or requested.

Requirements & Tech Stack

• Highly proficient in Microsoft Office Suite, especially in Microsoft Excel
• 0-2 years of financial analysis and modeling experience
• Capital Markets and/or commercial real estate experience
• Argus and Excel discounted cash flow models experience a plus
• CoStar and other similar market research tools experience a plus
• Ability to write effectively and succinctly for use in marketing deliverables a plus

Qualifications

• Bachelor’s Degree (Business, Finance, Accounting, Real Estate, etc.) preferred
• Combination of education without a degree and corporate work experience may be considered
• Strong analytical skills with high attention to detail and accuracy
• Good time management and organization skills
• Ability to balance and prioritize multiple priorities in a high-volume, fast-paced environment
• Growth oriented mindset, desire to learn more and shares knowledge to help others succeed
• Passion for client delivery, with strong emphasis on producing high-quality work, meeting deadlines, and exceeding stakeholder expectations

Compensation: $85,000.00 - $100,000.00