Free Excel templates

A free fundraising funnel and timeline model for a first fund

A first real estate fund raise as a queue: names screened to commitments, the meetings the founder has to hold, investor committee dates and dead weeks, the week the first close is reached, and the management company's cash while it waits.

The book's funnel, 180 names to 8 commitments, implies about 22.5 conversations per commitment and 202.5 meeting sessions, 0.75 years of a founder's diary. The management fee only covers the burn once 160 million is closed.

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.

Fundraising_Funnel_and_Timeline_Model.xlsx (137 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 Raising a Real Estate Fund, 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

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

2 The funnel
3 The diary
4 The queue
5 The cash
6 The slip
7 The two rules
8 The cliff
9 Two constraints
10 Checks

What the worked case returns

MeasureValue
Names screened180
Commitments8
Conversations per commitment22.5
Screened names the stated rules require192
Meeting sessions in total202.5
Years of the founder's capacity0.75
Capital needed for the fee to cover the burn160,000,000
Partner funding needed by month 122,095,312
Partner funding needed by month 243,089,062
Cost of a six-month slip (extra burn)1,200,000
Cost of a six-month slip, with fee foregone1,950,000

The start week matters more than it should: investor committees sit quarterly and August and December are dead, so starting six weeks late closes 20% less by month twelve.

How to use it on your own case

  1. Enter the funnel conversions, average commitment and first close target on Inputs.
  2. Set the meetings the founder can hold per week and the weeks each stage takes.
  3. Enter the committee weeks and dead weeks, then read the week the target is reached on The queue.
  4. Enter the management company's costs and fee rate and read the partner funding needed on The cash.

Questions people ask about it

How long does it take to raise a first fund?

It depends on the funnel and on investor committee calendars. The model turns both into the week each commitment closes, so the answer moves with your inputs.

How many LP meetings does a first close need?

The funnel gives the number of conversations per commitment; the diary sheet turns them into sessions and weeks of a founder's time.

Why model the management company's cash?

Because the fee starts at first close while costs start on day one. The gap is funded by the partners, and every month of slip adds to it.

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 Raising a Real Estate Fund 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 Raising a Real Estate Fund. 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.