Free Excel templates

A free AUM and net flow forecast model in Excel

A fund raised through wealth platforms, forecast month by month: advisors converted on each platform, tickets, gross flows, redemptions, net flows, assets and the organic growth rate, with the signature of each kind of miss.

Four platforms put 4,000 advisors in reach of a new fund. Gross flows never fall in 84 months, yet net flows peak in month 44 and the organic growth rate peaks in month 29, at 48.1%. Assets reach 755 million by month 84.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

AUM_Net_Flow_Forecast_Model.xlsx (142 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Private Wealth Fundraiser, which explains the method behind it, chapter by chapter.

Get the book on Amazon → Or the DRM-free PDF edition, $19.99

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada.

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

7 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Inputs
Platforms, conversion curve, ticket economics, redemption rate.
Conversion
The curve, month by month, per platform.
The forecast
84 months of gross flow, redemptions, net flow, assets and organic growth rate.
Peaks and drag
Where each of the three measures turns, and the U-shape of redemption drag.
Diagnosing a miss
What conversion, ticket and timing each look like when they go wrong.
Checks
Every figure in Appendix F, tested, and the model's own arithmetic. The last row says ALL PASS.
Scenario engine
The whole model re-run four times (base, conversion, ticket, timing), so that sheet 5 is live.

What the worked case returns

MeasureValue
Advisors in scope4,000
Seed and anchor capital150.0 million
Gross flow, month 183.7 million
Gross flow, month 3611.8 million
Assets, month 36288.3 million
Assets, month 84754.5 million
Peak net flow10.5 million
Net flow peaks in month44
Organic growth rate peaks in month29
Peak organic growth rate48.1%
Redemption drag, month 1838.7%
Redemption drag, month 3614.2%
Redemption drag, month 8441.5%

Redemption drag is U-shaped: 38.7% of gross flows at month 18, 14.2% at month 36, 41.5% at month 84. Three years in, when a team first has enough history to extrapolate, is exactly the bottom.

How to use it on your own case

  1. Enter the seed capital, each platform's advisors and launch month on Inputs.
  2. Set the conversion curve, the ticket economics and the redemption rate.
  3. Read 84 months of gross flow, redemptions, net flow and assets on The forecast.
  4. Use Diagnosing a miss to see how a conversion, ticket or timing shortfall shows up.

Questions people ask about it

What is the difference between gross and net flows?

Gross flows are new subscriptions. Net flows deduct redemptions. A fund can keep growing gross flows while net flows have already peaked.

What is the organic growth rate?

Net flows over the last twelve months as a share of assets at the start of the period: growth from selling, not from performance.

Can I use my own distribution platforms?

Yes. Each platform's advisor count and launch month are inputs, and the conversion and ticket assumptions are open.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Private Wealth Fundraiser go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Private Wealth Fundraiser. The book is on Amazon.

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.