Family office - analyst role test

Hello everyone,

Have an upcoming test to take for a senior analyst role at a family office and from what I understand, the role is research-heavy. I received these email instructions: " As a potential next step in the process, we would like to share a short take-home exercise designed to assess research capabilities, analytical thinking, data organisation, and the effective use of AI tools in an investment context."

This is a 4-5 hours test and as someone with an M&A background, do not know exactly what to expect.

Anyone have any similar experience? Am I supposed to create an excel file with research and proposals about investment opportunities and a word memo?

3 Comments
 

Based on the most helpful WSO content, here's what you need to know about preparing for a family office analyst role test:

  1. Understand the Role's Focus: Family offices often require analysts to wear multiple hats, with a strong emphasis on research, due diligence, and investment analysis. Since the role is research-heavy, expect tasks that test your ability to gather, analyze, and present data effectively.

  2. Test Components: Given the instructions you received, the test will likely assess:

    • Research Capabilities: You may need to identify investment opportunities, analyze industries, or evaluate specific companies. Be prepared to use credible sources and organize your findings clearly.
    • Analytical Thinking: This could involve interpreting financial data, assessing risks, or comparing investment options. Your M&A background should help here, especially if you’ve worked on valuations or due diligence.
    • Data Organization: Expect to create structured outputs, such as Excel models or summaries, to present your findings. Ensure your work is clean, logical, and easy to follow.
    • Effective Use of AI Tools: This is a newer trend. You might be asked to leverage AI tools (e.g., ChatGPT, Bloomberg GPT, or other financial AI platforms) to enhance your research or analysis. Practice using these tools to summarize data, generate insights, or even draft memos.
  3. Deliverables: While the exact format isn’t specified, it’s reasonable to assume you’ll need to:

    • Create an Excel file with organized data, financial models, or investment comparisons.
    • Draft a Word memo summarizing your findings, providing recommendations, and justifying your conclusions.
  4. Preparation Tips:

    • Brush Up on Financial Modeling: Family offices value strong modeling skills. If you’re rusty, consider reviewing templates or guides on DCF, LBO, or comparable company analysis.
    • Practice Research: Familiarize yourself with tools like Capital IQ, Bloomberg, or even public filings to gather investment data efficiently.
    • AI Familiarity: Experiment with AI tools to understand how they can assist in summarizing data, generating insights, or drafting professional documents.
    • Time Management: Since the test is 4-5 hours, practice working under time constraints to ensure you can deliver quality outputs within the allotted time.
  5. Leverage Your M&A Background: Highlight your experience in deal analysis, financial modeling, and presenting to stakeholders. These skills are transferable and will set you apart.

Good luck with the test! If you need additional resources, WSO offers financial modeling templates and guides that could be helpful.

Sources: Help! MD is asking me to come with him, Finishing 1st Year as HF Analyst - Ask Anything, Family Office Private Equity, Family office Private Equity - help

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

Soluta quaerat est ipsum itaque. Unde harum tempora quod asperiores in vitae et. Laboriosam voluptatem odit veritatis qui expedita voluptates. Est sequi voluptatum rerum omnis. Eius maiores voluptates eos expedita minima.

Harum ex recusandae rerum est. Itaque necessitatibus corporis ipsam quo sapiente exercitationem est. Et itaque autem facere placeat. Mollitia et dolorem rerum quibusdam quia. Tenetur sint et accusamus.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Morgan Stanley 08 97.8%
  • Goldman Sachs 02 97.2%

Overall Employee Satisfaction

August 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (47) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (25) $178
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (83) $151
  • Intern/Summer Analyst (74) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
GameTheory's picture
GameTheory
98.9
8
DrApeman's picture
DrApeman
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”