Financial Analyst, Capital Markets (Multifamily)

cw; Tysons (VA); On-site; USD 65,000 - 95,000; Full time

Job summary

Cushman & Wakefield in Tysons, VA is seeking a Capital Markets Financial Analyst to support multifamily transactions. You will perform financial analysis, build and audit Excel models, and synthesize market data into clear summaries under MAG leadership.

On-site work is required with occasional after-hours support to meet deadlines. The role offers growth in cash-flow modeling and market analysis, interacting with senior staff and clients.

Qualifications

• Bachelor's Degree in Business, Finance, Accounting or Real Estate preferred.
• 0–2 years of financial analysis and Excel modeling experience.
• Experience with discounted cash flow modeling in Excel is a plus.
• Strong analytical skills with high attention to detail.
• Client-service oriented with ability to meet deadlines and client expectations.
• Proficiency in Microsoft Office Suite, especially Excel.
• Experience with Salesforce, CoStar and Axiometrics market data is a plus.

Responsibilities

• Support Multifamily Broker team financial analysis and valuation modeling requests, including scenario analyses.
• Prepare pro forma statements, DCF analyses, and Excel-based financial models.
• Audit existing financial models for inputs and assumptions.
• Research market data, demographics, and property comparables; summarize findings.
• Develop high-level analysis summaries highlighting trends, strengths, and risks.
• Assist with Offering Memorandums, Value Opinions, and RFPs.
• Prepare client-ready summary documents and spreadsheets for presentations.
• Participate in stakeholder meetings and respond to clarifying questions.
• May assist with market research for prospective transactions.
• Leverage AI tools to accelerate data collection and modeling.

Skills

Financial analysis

Excel modeling

Market research

Client-service mindset

Communication skills

Education

Bachelor's Degree in Business/Finance/Accounting/Real Estate

Tools

Microsoft Excel

Salesforce

CoStar

Axiometrics

Job description

Job Title

Financial Analyst, Capital Markets (Multifamily)

Job Description Summary

The Capital Markets Financial Analyst ("CMFA") Hub Analyst will support transactions generated by Cushman & Wakefield's Investment Sales brokerage services specializing in multifamily investments. The primary role of the CMFA will be to perform financial analysis activities of pricing, Excel valuation model creation and auditing, due diligence collection and review, market data collection, and translating analysis findings into high-level summaries with oversight from senior members of the Multifamily Advisory Group ("MAG"). The ideal candidate will be based in the Tysons, VA area and available to work on-site in a local Cushman & Wakefield office. Team members may be expected to work outside normal operating hours to meet project deadlines.

Job Description

Essential Duties

• Support the execution of Multifamily Broker team financial analysis and valuation modeling requests, including scenario analyses
• Prepare pro forma statements, discounted cash flow analyses, and Excel-based financial models with consideration of market conditions (both current historical)
• Conduct audits of existing financial models for accuracy of model inputs and validity of assumptions
• Perform extensive research, including but not limited to, reviewing and analyzing financial reports, studying comparable properties, collect information on the immediate area (demographics) and overall market; synthesize findings in a clear, concise manner
• Develop high-level analysis summaries by identifying transaction considerations (strengths/weaknesses), trends, outliers, and logical inconsistencies
• Assist with the drafting and preparing of Offering Memorandums, Broker Opinion of Value, and/or Request for Proposals
• Communicate professionally to clients in the execution phase of the sales process (including assisting with Marketing Timelines, Scheduling Tours, Weekly Activity Reports, etc.)
• Demonstrates continual development of cash flow and Excel-modeling skills and competencies. Deliverables will increase in complexity and scope over time in the role.
• Prepares clear concise summary documentation and spreadsheets that support and explain the basis of the analyses for use in client presentations, proposals and/or reports
• Review tenant leases to abstract key data points and identify areas of issue/concern that will have an impact on the real estate financial analysis, as applicable for mixed use opportunities
• Maintain owner database and track loan maturities for Business Development.
• Maintain rent and sales comp database
• Review analyses with deal team, answer clarifying questions and make accurate revisions
• Participation in internal and external stakeholder meetings to present and discuss their analyses
• May assist with market research of prospective transactions
• Participates in broker team calls and meetings, as needed
• Performs other related duties as required or as requested
• Leverage AI tools to accelerate data collection, research, valuation modeling, document abstraction, analysis, etc.

Other Requirements & Administrative Duties

• Bachelor's Degree (Business, Finance, Accounting, Real Estate, etc.) preferred
• Combination of education without a degree and corporate work experience may be considered
• 0-2 years of financial analysis and Excel modeling experience, Capital Markets and/or multifamily underwriting experience a plus
• Experience with creating or constructing discounted cash flow models in Excel
• Client-service oriented mindset with a passion for producing a high-quality work product, meeting deadlines and client expectations
• Highly proficient in Microsoft Office Suite. Advanced knowledge in Microsoft Excel a plus.
• Experience with Salesforce, and CoStar and Axiometrics market research data a plus
• Strong analytical skills with high attention to detail and accuracy
• Ability to write effectively and succinctly for use in marketing deliverables, or other internal stakeholders
• 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

Cushman & Wakefield also provides eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health, vision, and dental insurance, flexible spending accounts, health savings accounts, retirement savings plans, life, and disability insurance programs, and paid and unpaid time away from work. In addition to a comprehensive benefits package, Cushman and Wakefield provide eligible employees with competitive pay, which may vary depending on eligibility factors such as geographic location, date of hire, total hours worked, job type, business line, and applicability of collective bargaining agreements.

The compensation that will be offered to the successful candidate will de