Financial Analyst

• Reports To : Corporate Accounting Supervisor
• FLSA Status : Exempt

Sherman Associates is currently seeking an experienced Real Estate Financial Analyst to join our team! This position supports Sherman Associates’ Asset Management Department by preparing financial reports, analyses, forecasts, and support for real estate value events, including acquisitions, developments, refinancings, and dispositions. The Financial Analyst supports Development and Transaction Teams by coordinating financial information, due diligence materials, reporting requirements, and analytical deliverables.

The Financial Analyst plays a critical role in supporting deal execution with the designated Project or Transaction Lead. This role uses existing company systems, business intelligence reporting, and financial data to coordinate the delivery of information requests and meet internal and external reporting requirements. Through analysis of transaction reporting, the Financial Analyst provides decision-support insights to designated Transaction Leads throughout the evaluation and execution of real estate initiatives.

This position will work on site at our corporate office in Minneapolis, at least 4 days per week.

ESSENTIAL FUNCTIONS

• Support the development of pro forma and cash flow models for acquisitions, developments, refinancings, recapitalizations, dispositions, and other real estate value events.
• Prepare forecasts, scenario analyses, valuation analyses, and return summaries to support the evaluation of transaction opportunities and strategic alternatives.
• Support analysis of debt structures, loan terms, covenant requirements, and financing alternatives, and summarize relevant financial implications for internal review.
• Leverage existing enterprise reporting from the Financial Suite, Lease Management, and other internal data sources to fulfill lender, investor, ownership, and transaction-related reporting requirements.
• Prepare financial and statistical reporting and additional analyses by organizing, validating, and adapting existing company data to meet internal and external reporting requests.
• Provide financial analysis, reporting support, and information management to Developers and designated Transaction Leads throughout the lifecycle of real estate value events.
• Assist in preparing financing request packages, presentations, transaction summaries, sources and uses, and supporting financial schedules under the direction of the appropriate Transaction Lead.
• Assist Transaction Leads by organizing, tracking, and distributing information requested by internal teams, lenders, mortgage bankers, investors, attorneys, title and escrow teams, consultants, and other transaction participants.
• Coordinate the collection, validation, organization, and distribution of information requested by internal and external stakeholders, helping ensure timely and accurate delivery of transaction materials.
• Summarize, organize, and maintain lender term sheets, financing proposals, and loan documents while tracking key financial terms, requirements, risks, reporting obligations, and critical dates for internal communication.
• Support financing and transaction closings through preparation, compilation, tracking, and distribution of existing financial, operational, organizational, and due diligence materials requested by transaction participants.
• Support ongoing lender reporting, covenant compliance, reserve and escrow activity, extension requirements, and other post-closing obligations in collaboration with Accounting and Asset Management.
• Maintain transaction trackers, reporting logs, critical-date schedules, and information management tools used to coordinate requests, responsible parties, milestones, and deliverables across departments and external stakeholders.
• Conduct market research to support pro forma assumptions, financing analysis, valuation analysis, and management decision-making.

Education & Experience

• Bachelor’s degree in finance, Real Estate, Accounting, Economics, Business, or a related field.
• Three to five years of experience in real estate finance, asset management, acquisitions, development, transaction coordination, commercial lending, or a related analytical field preferred.
• Experience supporting real estate transactions, financial analysis, due diligence, information requests, closings, or external reporting is strongly preferred.
• Experience with multifamily, commercial, mixed-use, hospitality, retail, or development transactions is preferred.

Required Skills & Abilities

• Advanced Excel skills with experience building and reviewing pro formas, debt models, cash flow analyses, sources and uses, and sensitivity scenarios.
• Working knowledge of commercial real estate finance concepts, transaction processes, loan structures, due diligence, closing requirements, and post-closing reporting.
• Ability to analyze term sheets and loan documents and clearly summarize financial terms, requirements, risks, and critical dates.
• Strong coordination skills with the…