Pension Fund Asset Allocation ModelFree Financial Model Download

Project pension fund or endowment financial health with a liability-driven investment framework that links asset allocation to funding ratios and spending rules. This template models six asset classes (public equities, fixed income, private equity, real assets, hedge funds, cash) with scenario-dependent returns under Base, Bull, and Bear cases, calculates fees by asset class including performance fees, and computes funded ratio and liquidity coverage each year. It addresses the core liability side: benefit obligations that grow via service cost and interest cost, with actuarial gains and losses adjusting the PBO in stress scenarios.

The workbook contains assumption controls for scenario toggle (Base/Bull/Bear), asset allocation with rebalancing, base and performance fee schedules, and member demographics (active and retired headcounts, salary escalation, benefit accrual). The AUM roll-forward captures asset returns net of fees and internal opex; the Liability_Rollforward models PBO dynamics separately. A funded status sheet monitors the gap between assets and liabilities, while a liquidity check ensures liquid assets exceed annual cash outflows (benefits, fees, opex). For endowments, a spending rule based on a trailing three-year average AUM provides a sustainable drawdown mechanism.

Target users are pension fund trustees, investment committees, endowment boards, and institutional investors managing £1B to £100B+ portfolios requiring liability-asset matching analysis.