# Fund of Funds Portfolio Model Track portfolio allocation, capital calls, distributions, and net returns across your manager lineup to optimize fund-of-funds composition and fee structures. Built for allocators who need to consolidate across PE, VC, HF, and real assets. - Canonical: https://finamodel.com/templates/fund-of-funds-model - Excel download: https://finamodel.com/templates/fund-of-funds.xlsx - Category: Capital Markets - Model type: Portfolio - Difficulty: Advanced - Audiences: Fund managers, Investors & analysts, Fund-of-funds managers, Institutional investors, Allocators, Portfolio analysts - Tags: fund-allocation, fee-waterfall, multi-manager, portfolio-construction ## Overview This portfolio model tracks capital calls, distributions, and net returns across a fund-of-funds vehicle investing in PE, VC, hedge funds, and real estate manager-run funds. Model allocation by strategy, manage the fee waterfall (management fees on commitments, performance fees above HWM, GP clawback mechanics), and consolidate cash flows and leverage across the underlying fund lineup to optimise composition and fee structure. The workbook tracks each underlying fund's capital call schedule, distribution timing, performance fees, and leverage separately, then consolidates into a roll-forward of total portfolio NAV, cumulative distributions, and net IRR. Fee waterfall: typically 1.0–1.5% management fee on fund AUM, 15–20% performance fee above hurdle. Key outputs: net IRR (fund-of-funds level), DPI/MOIC by vintage manager, and exposure concentration analysis. Used by institutional investors (pension funds, endowments, sovereign wealth), family offices sizing multi-strategy allocations, and funds-of-funds managers structuring new vehicles. The model reveals fee drag from layered performance fees (manager fee + FOFOF fee + GP carry) and helps identify over-allocated geographies or strategies. Benchmarks: industry net IRR target 8–12%, net MOIC 1.8–2.5x after all fees. ## What's included - Portfolio allocation by manager and strategy: PE, VC, hedge funds, and real assets - Fund-level capital calls and distribution scheduling - Fee waterfall including management fees, performance fees, and GP clawback - Performance attribution and peer comparison by manager - Cash flow forecasting and liquidity management - Portfolio allocation by manager and strategy (PE, VC, HF, RE) - Leverage and credit facility modeling - Performance attribution and peer comparison ## Inside the Fund of Funds Model: How Commitments, Fees and Waterfalls Drive LP Outcomes This fund of funds model is a 15-year planning template for eight PE/VC funds across five vintages plus a secondaries sleeve. It links commitments, calls, distributions, fees and a waterfall to show LP net returns, multiples and vintage comparisons, with all figures as illustrative assumptions for evaluation. ### Key assumptions that drive fund-level schedules The model builds each underlying fund from three core inputs: vintage deployment share, within-vintage allocation and fund-specific strategy (PE or VC). These determine primary commitment. - Calls follow five annual percentages relative to each vintage, while gross distributions use a triangular start/peak/end profile and an assumed MOIC. Net asset value is a closed-form curve based on called capital, a trough factor, target multiple and cumulative distributions. - A secondaries sleeve adds a separate purchase call, buys NAV at a discount and distributes a modelled return over four years. Case settings scale gross MOIC and shift distributions, and per-fund overrides are available. ### How cash flows and fees flow through the structure Underlying fund schedules generate gross calls and distributions, which then meet two layers of fees. Underlying management fees are charged on commitments during the investment period and on NAV during harvest, with a simplified carry calculation. - At the fund-of-funds level, management and setup fees add to the cash need. Eligible distributions may recycle into funding need during a defined window; remaining calls are split between the LP and GP. - A capacity test warns on overcommitment but does not stop calls, and net distributions are floored at zero after fees. The waterfall then applies return of capital, preferred return, catch-up and residual split to determine LP and GP distributions. ### Outputs for evaluating LP net performance The model reports periodic IRR, DPI, RVPI, TVPI and fee-drag measures across the portfolio and by vintage. LP net cash flow equals LP distributions less LP calls. - Total TVPI combines DPI with remaining NAV divided by called capital. Dashboard views include LP net returns, multiples, J-curve-style cash-flow trends and fund/vintage charts. - Vintage-level IRRs are also provided, though some helpers reference gross underlying flows and commitment charts may differ from actual commitments. Terminal liquidation reflects primary-fund NAV only, and headline net multiple equals LP DPI. These outputs support comparison of vintages and fee impact. Calculation summary: ```text LP net cash flow = LP distributions − LP calls ``` ### Practical use and documented boundaries The template is intended for allocators planning a fund-of-funds portfolio, testing commitment pacing, fee structures and waterfall terms under a base case and two scenarios. Users can adjust vintage deployment, call timing, MOIC, distribution profiles, fee rates and waterfall parameters to see how LP outcomes respond. - Documented limitations should be respected: overcommit is a warning rather than a cap, secondary allocation is added to primary commitments, unpaid underlying fees are not tracked separately, and the preferred return does not compound unpaid amounts. No leverage, stochastic simulation or automated fund-statement import is implemented. - The public download is a values-only preview. ## Multi-manager portfolio consolidation Combine cash flows, valuations, and performance metrics from each underlying fund into a single portfolio view for LP reporting. ## Fee structure analysis across managers Model 2/20 and 1/30 fee structures across managers with GP-level expenses, allocation, and net-of-fees return impact on the fund. ## Leverage and financing scenarios Incorporate credit facilities and subscription lines to model cash flow timing, cost of capital, and the IRR impact of leverage on LP returns. ## Multi-manager portfolio consolidation Combine cash flows, valuations, and performance metrics from each underlying fund into a single portfolio view for LP reporting. ## Fee structure analysis across managers Model 2/20 and 1/30 fee structures across managers with GP-level expenses, allocation, and net-of-fees return impact on the fund. ## Leverage and financing scenarios Incorporate credit facilities and subscription lines to model cash flow timing, cost of capital, and the IRR impact of leverage on LP returns. ## Features - **Multi-manager portfolio tracking:** Consolidate cash flows, valuations, and performance metrics from each underlying fund into a single view. - **Fee structure analysis:** Model 2/20 and 1/30 fee structures across managers with GP-level fees, expense allocation, and net-of-fees returns. - **Leverage and financing scenarios:** Incorporate credit facilities, subscription credit lines, and leverage strategies to model cash flow timing and cost of capital. ## Use cases - **Fund launch and capital raise:** Forecast LP returns, fee drag, and cash management to support fundraising decks and investor commitments. - **Manager selection and rebalancing:** Compare fund-level returns, fee impact, and risk-adjusted performance to decide allocation to new or existing managers. - **NAV and quarterly reporting:** Consolidate capital calls, distributions, valuations, and IRR/MoIC calculations for LP reporting and compliance. ## Frequently asked questions ### What is a fund of funds model? A portfolio model that consolidates capital calls, distributions, valuations, and performance across multiple underlying fund managers into a single vehicle. ### How do I handle subscription credit lines? Model as borrowed proceeds at the capital call date, repaid from distributions. Borrow amounts are typically 30-50% of subscription commitments at SOFR plus a spread. ### What is the typical fund-of-funds fee structure? FoF management fees are typically 0.75-1.5% of committed capital or AUM, sometimes with a 50-75% pass-through of underlying manager fees to investors. ### How do I allocate diversification across strategies? A common starting point is 30-40% PE, 20-30% VC, 20-25% real assets, and 10-20% hedge funds. Adjust based on fund thesis and LP risk appetite. ### Who uses fund of funds models? FoF managers, institutional allocators, endowments, pension funds, and portfolio analysts use them for fundraising, reporting, and manager selection decisions. ## Related templates - [Private Equity Fund Model](https://finamodel.com/templates/pe-fund-model) - [Venture Capital Fund Model](https://finamodel.com/templates/venture-capital-model) - [Hedge Fund Operating Model](https://finamodel.com/templates/hedge-fund-model)