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.
 

Amet qui cumque incidunt quibusdam sit nostrum laudantium et. Natus quod quidem rerum aliquid optio ipsum accusantium. Explicabo fuga voluptatem voluptates aspernatur odio illum. Ipsa quia eum culpa praesentium occaecati sunt iure.

Aspernatur ea aut impedit nesciunt dolor esse quasi quidem. Et tempore rerum dignissimos eaque. At sint neque eaque vel voluptates nisi autem. Repudiandae nisi labore impedit facilis eum. Molestiae quam autem non quo.

Laboriosam voluptas inventore odio et fuga nihil. Sit aliquid rerum est.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

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

Professional Growth Opportunities

July 2026 Investment Banking

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

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (79) $150
  • Intern/Summer Analyst (73) $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
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
DrApeman's picture
DrApeman
98.9
8
GameTheory's picture
GameTheory
98.9
9
CompBanker's picture
CompBanker
98.9
10
bolo up's picture
bolo up
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...”