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.
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.
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).
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).
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
Measure
Value
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 call
89.4%
Gross cash received
$40.0m
Distributable cash
$32.0m
Carry payable at this distribution
nil (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
Enter your investors once on 1. Register: commitments, fee rates, classes and whether each is excluded from calls.
Build the call on 2. Capital Call from the economic requirement, not from a round number.
Run the distribution on 3. Distribution from gross proceeds, and clear the bank-detail flags before any notice goes out.
Enter the fund NAV on 4. Capital Accounts and resolve any difference before the quarter closes.
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.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
Value creation bridgeEntry equity to exit equity in six buckets with a zero residual, the cross-term and add-ons net of cash.
Aircraft lease modelA sale-leaseback priced from the lease rate factor to levered IRR, the residual risk, and the lessor's P&L.
Ship finance modelA ship loan with LTV covenants and release prices, a bareboat lease with options, a default, and the fund's waterfall.
Cell tower valuation modelOne tower with one, two and three tenants, a 1,200-tower portfolio, DCF, debt and returns.
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.