Book · Julian R. Sterling
A Practitioner's Guide for Producers, Lenders and Investors: Budgets, Pre-Sales, Gap Loans, Tax Credit Financing, Completion Bonds, Collection Accounts and the Recoupment Waterfall
An independent film is not paid for by one investor. It is financed in layers, each secured on a different future receipt: distributors' pre-sale contracts, a production tax credit, the estimated value of territories not yet sold, fees the talent agrees to defer and, last of all, equity. Every layer has its own lender, its own price and its own place in the order in which money comes back.
The Film Finance Handbook builds that structure end to end on one fictional feature, The Lantern Keeper, a thriller shot in Georgia with an all-in budget of $12,765,473. Six pre-sales of $3,600,000 support a senior loan of $2,880,000, a 30 percent state credit supports a tax credit loan of $1,948,320, a gap loan of $1,800,000 is sized against unsold territories, and equity of $5,117,153 fills the rest. The book then follows the cash quarter by quarter through the collection account in three scenarios: equity gets back 0.00x in the downside, 0.98x in the base case and 1.40x in the upside, with an IRR of 25.1 percent. It closes on the decisions that matter: whether the gap loan passes its tests, what a completion bond costs equity in an overrun, and when a streamer's cost-plus offer beats the independent route. Production incentives are described as read in November 2026.
Every figure below is computed by the book's model and reproduced in the companion workbook. The film, its companies, distributors, lenders and every figure are fictional teaching assumptions, not market data.
| Item | Value |
|---|---|
| All-in budget | $12,765,473 |
| Production cost before financing, sales and bond costs | $10,980,000 |
| Financing costs (fees, interest, financiers' legal costs) | $1,205,873 (9.4 percent of the budget) |
| Pre-sales (six territories) / senior pre-sale loan | $3,600,000 / $2,880,000 |
| State credit / tax credit loan | $2,460,000 / $1,948,320 |
| Gap loan: share of budget, cover by low estimates | $1,800,000: 14.1 percent, 2.26x |
| Equity invested at financing close | $5,117,153 (40.1 percent of the budget) |
| Equity multiple: downside / base / upside | 0.00x / 0.98x / 1.40x |
| Equity IRR: base / upside | -1.6 percent / 25.1 percent |
| Domestic sale at which equity recovers 100 percent | $4,641,839 |
| Overrun of $1,100,000: guarantor advance, base equity multiple | $320,000, 0.91x |
| Streamer cost-plus price and producer's take | $12,510,000 and $1,368,000 |
The live Excel workbooks behind every table in the book. Blue inputs, black formulas, no macros, no circular references, and a Checks tab that must read zero. No sign-up required for book readers.
Appendix A, chapters 2 to 14
Eleven tabs: README, Inputs, Budget, Plan, WF_Downside, WF_Base, WF_Upside, Returns, Sensitivity, Overrun_CostPlus and Checks. The three WF tabs run the quarterly collection account waterfall of each scenario.
Download Film_Finance_Workbook.xlsx45 KBStandalone practitioner tool
One film, quarterly collections from financing close: pre-sale balances, credit transfer, new foreign sales, the domestic sale and overages, run through the full payment order. Prefilled with the base case: the gap loan is repaid in full and equity receives $4,990,915, a 0.98x multiple.
Download Film_Recoupment_Waterfall_Model.xlsx13 KBWant the model first? Open the free Film Recoupment Waterfall Model page for the worked example and the Excel download.
Related titles. Full list on the author page.