InstitutionsMaria Skotheim

How Many Analysts Does a $1 Billion Portfolio Need?

Quick answer

When its data is handled manually, a $1 billion institutional portfolio can tie up the aggregation and reporting work of roughly 3 to 4 analysts. That is MYFO's estimate per $1 billion under management, worth up to about $500K a year in labor at a fully loaded cost of about $125K per analyst. Much of that capacity goes to collecting statements, keying private fund data and reconciling positions rather than analyzing the portfolio. Automating collection and reconciliation frees the same team to spend more of its time on manager evaluation, risk and the questions an investment committee actually asks.

Key takeaways

  • MYFO estimates that the aggregation and reporting work behind each $1 billion under management amounts to roughly 3 to 4 analysts, or up to about $500K a year at a fully loaded cost of about $125K per analyst.
  • That figure describes data preparation, not the number of people a portfolio needs for analysis and judgment.
  • Private markets drive much of the burden because every fund reports on its own schedule and in its own format.
  • The cost of a data-heavy team also shows up as slower committee reporting, key-person risk and less time for portfolio work.
  • Endowments, foundations and pensions can redeploy analyst capacity by automating collection and reconciliation before adding headcount.

What the 3 to 4 analysts are actually doing

The figure refers to aggregation and reporting work: the effort it takes to keep the numbers current when every manager, custodian and administrator reports in a different format on a different schedule. It says little about how many people it takes to think about a $1 billion portfolio and a great deal about how many it takes to prepare the data first.

On teams that still assemble portfolio data by hand, the analyst week tends to divide into two kinds of work. The first is data handling: downloading custodian files, pulling quarterly statements from fund portals, reading capital call and distribution notices, keying valuations into a master spreadsheet and reconciling cash and positions against source documents. The second is analysis: evaluating managers, monitoring exposures and liquidity, running scenarios and preparing material for the investment committee.

ActivityData handling or analysisChanges with automation?
Collecting custodian and manager filesData handlingLargely automated
Keying private fund valuations and cash flowsData handlingReplaced by data extraction with review
Reconciling positions and cash across sourcesData handlingShifts to reviewing exceptions
Monitoring exposure, liquidity and pacingAnalysisMore time available, on more current data
Manager due diligence and evaluationAnalysisMore time available
Preparing investment committee materialsMixedFaster once the underlying data is consolidated

When the first category takes up most of the week, adding assets means adding analysts. That is how a team ends up with several people per billion without any of them feeling underworked.

Why private markets push the number up

Public market data is comparatively easy to handle. Custodians deliver positions and transactions in structured files, and prices are available daily. Private funds are different. Valuations typically arrive quarterly and often well after quarter end, capital account statements vary by manager and every call or distribution needs to be recorded against the right commitment.

Endowments, foundations and pensions with meaningful private equity, real estate or infrastructure programs feel this most. A portfolio's size matters less than how many reporting sources sit behind it. Two portfolios of the same size can need very different teams if one holds a few index funds and the other holds a long list of private fund commitments.

Operations leaders know the problem well. In an industry survey of 200 buy-side operations leaders, one of the main challenges was visibility: 60% said they can't manage multi-asset portfolios in one view, and 64% said they plan to consolidate systems for a real-time total portfolio view. Another 67% said they are prioritizing more standardized data models, which is the groundwork that makes consolidation possible.

What a data-heavy team costs

Salary is the visible part. MYFO puts the labor value of the aggregation and reporting work behind each $1 billion at up to about $500K a year, assuming a fully loaded cost of about $125K per analyst. That is an assumption-based estimate rather than a measured result, and the real figure depends on portfolio size and complexity, but it gives a CIO a reasonable starting point for the conversation.

The operational costs can matter more. When valuations live in a spreadsheet maintained by one or two people, those people become a single point of failure, and a resignation in the middle of a reporting cycle can delay committee materials. Manual reconciliation also leaves room for errors that only surface when someone asks a pointed question, such as total exposure to a sector across direct holdings and fund look-throughs.

Then there is the opportunity cost. Investment committees want answers about liquidity under stress, unfunded commitments against expected distributions and how pacing plans hold up if markets fall. An analyst who spends most of the quarter keying data can produce those answers, but only late and only occasionally.

How institutions shift capacity from data handling to analysis

Few teams set out to cut staff. Most want to change what the existing staff spend their time on, so the team can absorb growth in assets and complexity without hiring at the same rate.

The usual sequence starts with collection, so analysts review extracted values instead of typing them. Reconciliation comes next: when data from every source lands in one place, discrepancies can be surfaced for review rather than found by hand. Only then does the analysis layer improve, because exposure reports, liquidity forecasts and risk analysis are only as reliable as the data feeding them. For a detailed look at that foundation, see investment data management for pensions, endowments and foundations.

Institutions by MYFO is built for this shift. It automates the data-intensive work behind complex portfolios, from collection and reconciliation to reporting, analysis and liquidity oversight, and consolidates reporting, reconciliation and data prep across custodians, entities and asset classes. On top of that consolidated data, it brings live portfolio aggregation, cash flow forecasting and risk analysis to institutional investment teams, from larger institutions to smaller endowments and pension funds. Depending on portfolio size and complexity, that can free the capacity of one or more analysts. Learn more about Institutions by MYFO.

How to measure your own team's split

Before deciding whether a portfolio needs more analysts, it is worth finding out how the current team spends its time. A simple exercise over one quarter tends to be revealing:

  • Count the reporting sources behind the portfolio, including each fund, custodian and administrator.
  • Have analysts log time by activity for a full quarterly cycle, separating data handling from analysis.
  • Track how many days after quarter end committee materials are ready and how current the private valuations in them are.
  • List the questions the committee asked that the team couldn't answer quickly.

If data handling takes most of the quarter, the headcount question is really a data question. Hiring another analyst will add capacity, but much of it will go to the same manual work.

The bottom line

MYFO's estimate of 3 to 4 analysts' worth of aggregation and reporting work per $1 billion is less a staffing rule than a measure of how much institutional talent goes to work that doesn't require it. As private allocations grow, that burden tends to grow with them unless the data work changes. Institutions that automate collection and reconciliation first are in a better position to hold headcount steady as assets grow and give their analysts the time to do what they were hired for.

Frequently asked questions

How many analysts does a $1 billion institutional portfolio need?

MYFO estimates that the aggregation and reporting work behind each $1 billion under management amounts to roughly 3 to 4 analysts when it is done manually, or up to about $500K a year assuming a fully loaded cost of about $125K per analyst. The number of people needed for analysis itself depends on the portfolio, particularly how many private fund relationships sit behind it.

Why do endowments and pensions need so many investment analysts?

Allocations to private equity, venture capital, real assets and other private strategies mean many separate managers, each sending statements and notices in different formats on different schedules. Collecting, keying and reconciling that data takes a large share of analyst time before any analysis can start.

How can an institutional investment team spend less time on manual data entry?

Most teams start by automating data collection and extraction from fund documents, then use reconciliation so analysts review exceptions instead of checking every line. Platforms such as Institutions by MYFO consolidate reporting, reconciliation and data preparation across custodians, entities and asset classes and support cash flow forecasting and risk analysis on top of it.

Does automating investment data mean an institution can cut analyst headcount?

Some can, but many use the freed capacity differently, shifting analysts toward manager evaluation, liquidity planning and committee questions. That lets the team absorb growth in assets and private commitments without hiring at the same pace.