Family Office Financial PlanFree Financial Model Download

A family office financial model projects the management of $500 million in ultra-high-net-worth family assets across five asset classes: public equities (40%, 7.5% return), fixed income (20%, 4.5% return), private equity (25% committed, 12% return with J-curve), real estate (10%, 7% return), and cash (5%, 3.5% return). The office funds annual family distributions ($7.5 million, or 1.5% of AUM) plus operating expenses ($2.8 million, or 56 basis points of AUM), and is responsible for tax optimization, compliance, and asset allocation oversight.

The core tension is liquidity: private equity is deliberately illiquid and generates zero distributions for Years 1–3 (J-curve), while family distributions must be funded from yield (dividends, interest, rental income) and PE distributions after the curve turns positive. The model ensures that cash reserves never fall below a minimum buffer despite capital calls to PE funds totaling $6 million annually. Tax treatment separates ordinary income (37% rate on yield) from capital gains (20% rate on realized gains and the gain portion of PE distributions, with return-of-capital treated as non-taxable).

The model answers: can the family sustain $7.5 million in annual lifestyle distributions while funding a 25% PE allocation? What happens if PE returns decline or capital calls spike? This template is calibrated for institutionalized single-family offices with $300 million–$1 billion AUM.