Free Excel templates

A free capital call and distribution template in Excel, with the capital account roll

One investor register feeding the call, the distribution and the capital accounts, with the reconciliations a fund controller runs before anything goes out: five sheets, no macros.

The file runs the investor-level arithmetic of a fictional $250 million fund with five limited partners and a $15 million GP commitment that sits outside calls. A $25 million call (investment funding, management fee and expenses, less cash on hand) is allocated by participation percentage: $8.51 million to the largest investor, leaving 89.4% of every commitment unfunded. A $40 million realisation becomes $32 million distributable after the facility, costs and a reserve, held at the notice stage until bank details are verified. The capital accounts roll from $94 million to $87 million and wait for the NAV to reconcile against.

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.

Capital_Call_and_Distribution_Template.xlsx (20 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 file is one worked case from The Private Equity Fund Controller Playbook. The book explains every assumption, every sheet and the decision the numbers support, 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.

Go further: the fund controller's job, end to end

Private Fund Finance & Controllership: capital calls and equalization, fees and offsets, both waterfalls, NAV and capital accounts, IRR and PME, fund financing and ILPA reporting, on one fictional fund. Course Book, Excel exercises that check your answers, a 160-question quiz and the Private Equity Fund Model, Pro Edition included ($199).

Read module 4 and try ten quiz questions, free →

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: 11 paperbacks by Julian R. Sterling on banking, credit and payments, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

Five sheets. Enter the register once; every other sheet references it.

0. Read Me
The three reconciliations that matter and how the sheets connect.
1. Register
Investors, commitments, participation percentages, fee rates, classes, exclusions from calls and closings, with the check that percentages total 100%.
2. Capital Call
The economic requirement first (investment, fee, expenses, facility repayment, reserve, less cash and receipts), the purpose test, then the allocation with cumulative called and unfunded remaining.
3. Distribution
Gross proceeds to distributable cash, recallable amounts, the preferred return test and carry, then the allocation with a hold flag on unverified bank details.
4. Capital Accounts
Opening capital, contributions, distributions, income, expenses, gains and carry by investor, and the tie to the fund's net asset value.

What the worked case returns

MeasureValue
Total commitments$250m
Commitments participating in calls$235m
Amount to call$25.0m
Largest investor's share of the call$8.51m
Unfunded remaining after the call89.4%
Gross cash received$40.0m
Distributable cash$32.0m
Carry payable at this distributionnil (pref not reached)
Capital accounts, opening to closing$94.0m to $87.0m

Three reconciliations do the work: commitments to the register, allocated amounts to the notice total, and the sum of capital accounts to the fund's NAV. The last one is left open in the file on purpose: until you type the NAV, it says so, because a capital account roll that has not been tied to NAV is a draft.

How to use it on your own fund

  1. Enter your investors once on 1. Register: commitments, fee rates, classes and whether each is excluded from calls.
  2. Build the call on 2. Capital Call from the economic requirement, not from a round number.
  3. Run the distribution on 3. Distribution from gross proceeds, and clear the bank-detail flags before any notice goes out.
  4. Enter the fund NAV on 4. Capital Accounts and resolve any difference before the quarter closes.
  5. Save a copy per notice: the register stays, the activity changes.

Questions people ask about it

Is this capital call template really free?

Yes. It is a companion file to a book. The file costs nothing. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Does it use macros or circular references?

No macros and no circular reference: allocations are commitment shares of the call and of the distribution, and the roll is a sum.

Does it compute the full carried interest waterfall?

It applies carry at the distribution once the preferred return is reached, as a share of distributable cash. A full European or American waterfall with catch-up is in the distribution waterfall model on this site.

Can I use it for a real fund?

You can reuse the structure. The fund, the investors and every figure are fictional, and nothing here replaces your limited partnership agreement or your administrator.

The rest of the files

This template is one of the five companion workbooks for The Private Equity Fund Controller Playbook: the others cover the quarter-end close, the fund waterfall, the performance the book defines and the operational checklists. Free, like this one.

Open the companion files →

Other free templates

This template comes from The Private Equity Fund Controller Playbook. 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.