Fund Analyst
Position Summary & Requirements
- Prescott Advisors, LLC – Investment advisor to the Fund
- Prescott Realty Group – A full-service real estate operating company
- Dyck O’Neal, Inc. – A nationwide purchaser and servicer of real estate loans
Requirements / Qualifications
Prescott Group seeking a highly analytical and intellectually curious Fund Finance & Accounting Analyst to support the financial management and reporting of its real estate investment funds.
This role is responsible for fund-level financial analysis, modeling, portfolio analytics, investor reporting, valuation support, and performance reporting. The ideal candidate is detail-oriented, enjoys working with complex financial data, proactively identifies opportunities to improve processes through technology, and can manage multiple priorities while maintaining a high level of accuracy.
The Fund Finance & Accounting Analyst will partner closely with executive leadership and collaborate across acquisitions, asset management, accounting, investor relations, and legal to support fund operations and strategic decision-making.
Key Responsibilities
- Maintain and enhance fund-level financial models across multiple investment funds, ensuring the accuracy of:
- Historical and projected cash flows
- Contributions
- Distributions
- Fund expenses
- Lines of credit
- Returns and performance metrics
- Analyze portfolio performance and prepare investment analytics for executive leadership.
- Build hold/sell analyses, scenario modeling, and sensitivity analyses for existing investments and acquisition opportunities.
- Support quarterly and annual fund reporting, working closely with the CFO and Controller.
- Assist with investor reporting requests and portfolio performance analysis at both the fund and investment levels.
- Assist with investment valuation updates for quarterly financial statements.
- Assist with annual property budget process.
- Research market trends, economic conditions, and real estate fundamentals to support investment decisions.
- Partner with Investor Relations on investor presentation materials.
- Maintain investment debt tracking worksheet.
- Coordinate year-end appraisals for annual audits as needed.
- Collaborate across Asset Management, Acquisitions, Accounting, Legal, Investor Relations, and Executive leadership on portfolio analytics and reporting.
- Continuously identify opportunities to automate reporting, improve workflows, and increase analytical efficiency using AI and technology tools.
Qualifications
- Bachelor’s degree in Finance, Accounting, Real Estate, Economics, Business, or a related field.
2–5 years of experience in commercial real estate, private equity, investment management, fund accounting, investment banking, or a related field.
Strong understanding of commercial real estate investments and fund structures.
Experience with financial modeling, discounted cash flow analysis, underwriting, and valuation.
Advanced Microsoft Excel skills with the ability to build and maintain complex financial models.
Demonstrated interest in leveraging technology to improve productivity, reporting, financial analysis, and decision-making, including experience with AI tools such as ChatGPT, Microsoft Copilot, Claude, or similar platforms.
Experience with Power BI or other data visualization tools is preferred.
Experience with real estate software such as Argus, Yardi, DealCloud, or similar platforms is preferred.
Excellent analytical, problem-solving, and critical thinking skills.
High attention to detail and commitment to accuracy.
Strong organizational skills with the ability to manage multiple projects, investment funds, and competing priorities in a fast-paced environment.
Excellent written and verbal communication skills.
Comfortable working cross-functionally and interacting with professionals at all levels of the organization.
Demonstrates sound judgment, professionalism, discretion, and intellectual curiosity.