Sovereign Wealth Fund Portfolio ModelFree Financial Model Download
Model sovereign wealth fund allocation and performance to track whether the fund is hitting return targets and maintaining strategic positioning. Covers multi-decade time horizons, real asset illiquidity, currency exposure, and rebalancing discipline in one framework.
Free download. No sign-up required.
About this model
Model sovereign wealth fund allocation and performance to track whether the fund is hitting return targets and maintaining strategic positioning across 10+ year horizons. The model projects government contributions (commodity revenue, fiscal transfers), applies expected returns per asset class (equities, bonds, PE, infrastructure, real assets), calculates total fees and performance fees, and rolls forward NAV by year. It outputs net returns, real returns (inflation-adjusted), and rebalancing trades to restore target weights.
Key features: contributions are scenario-linked (e.g., oil revenue above $50/bbl transfers to the fund); fees separate base management (0.05-0.5% depending on asset class) from performance fees (20% carry above hurdle); fiscal transfers use a trailing 3-year average spend rule (e.g., Norway's 3% rule) to avoid pro-cyclical drawdowns. Asset class weights drift after differential returns; the model flags drift and calculates rebalancing trades. Real return preservation—a core SWF mandate—is checked annually (real return > inflation = intergenerational equity maintained). Leverage is optional and tracked against LTV caps.
Essential for sovereign wealth fund managers, central banks, and ministries of finance managing long-term savings. Also used by pension funds with SWF-like governance (multi-decade horizons, diversified mandates, fiscal transfer rules).
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
What's included
- Strategic asset allocation by major class and geography
- Return assumptions and performance tracking vs. benchmarks
- Contribution and withdrawal dynamics
- Rebalancing triggers and frequency modeling
- Currency exposure and hedging strategy
Multi-decade allocation planning
Long-term allocations appropriate for generational wealth are modeled with low time preference and real return targets of 7-10%, appropriate for sovereign mandates.
Rebalancing discipline
Rebalancing bands (e.g., equity target 45% plus or minus 5%) and annual or multi-year rebalancing cycles are modeled explicitly to maintain strategic positioning.
Real assets and illiquidity
Private equity, infrastructure, and real estate allocations are tracked with vintage-year cash flows and extended J-curves reflecting actual illiquidity constraints.
Frequently asked
What is a typical SWF return target?+
Sovereign wealth funds typically target 5-8% real returns after inflation to sustain withdrawal rates of 3-5% per year indefinitely across generations.
How much should a sovereign wealth fund allocate to real assets?+
Real assets including private equity, infrastructure, and real estate are typically 20-40% of SWF portfolios, offering higher returns in exchange for active management and illiquidity tolerance.
Should a sovereign wealth fund hedge currency exposure?+
Most SWFs hedge foreign currency back to home currency to reduce volatility. Some maintain unhedged positions when seeking diversification from home-country inflation.
How often should the fund rebalance?+
Annual rebalancing is most common, triggered when allocation drifts outside policy bands. More frequent rebalancing increases transaction costs without proportional risk reduction.
Who uses this model?+
Institutional investors, government finance teams, pension fund managers, and allocators use it for strategic allocation reviews, performance attribution, and contribution planning.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Pension Fund Asset Allocation Model
Liability-driven investment strategy, asset allocation, and funding ratio analysis for pension plan portfolios.
Endowment Fund Model
Multi-asset portfolio model for endowments with allocation, returns, spending, and perpetual sustainability.
Multi-Asset Portfolio Allocation
Asset allocation model optimizing portfolio construction across equities, bonds, alternatives, and real assets.
DCF Model
Discounted cash flow valuation model with explicit forecast, terminal value, and WACC.