Media, Entertainment Finance & Film-Slate Recoupment Waterfalls
Film-Slate Recoupment Waterfall & Backend Profit Formula
Calculate Independent Film & Content-Slate Off-the-Top Distribution Fee, Post-P&A Recoupment Cash Available for Production Financing, Net Backend Profit Pool, and Equity Financier Total Cash Multiple.
Respect strict priority tiers in film-slate CAMA recoupment waterfalls!
In independent film and streaming-slate Collection Account Management Agreements (CAMAs), investor equity NEVER touches a dollar until senior distribution fees and Prints & Advertising (P&A) marketing outlays recoup off the top! Worldwide Distributor Gross Receipts first pay an Off-the-Top Distribution Fee = Gross_Receipts * Dist_Fee_Pct, then reimburse P&A Marketing Spend, leaving Post-P&A Net Cash = MAX(0, Gross_Receipts * (1 - Dist_Fee_Pct) - PA_Spend) to recoup the Negative Production Cost Basis! Only positive surplus above full production recoupment enters the Net Backend Profit Pool = MAX(0, Post_PA_Cash - Production_Budget), split between the Financier Backend Corridor and Creative/Producer Backend Points!
Verify on a $20.00M Independent Feature—Worldwide_Distributor_Receipts = $50.00M (B2), OffTheTop_Distribution_Fee = 0.20 (20.0%, B3 -> $10.00M fee in E2), Prints_&_Advertising_Spend = $12.00M (B4 -> Post-P&A Recoupment Cash = 50 - 10 - 12 = $28.00M in E3), Production_Equity_Basis = $20.00M (B5 -> Net Backend Profit Pool = 28 - 20 = $8.00M in E4), and Equity_Financier_Backend_Share = 0.50 (50%, B6): Equity Financier collects $20.00M principal recoupment + $4.00M backend share = $24.00M, achieving a 24 / 20 = 1.2000x Cash Multiple (E5)!
| CAMA Film Waterfall ($50M Receipts, 20% Dist Fee, $12M P&A, $20M Budget, 50% Backend) | Formula | Verified Output |
|---|---|---|
| Off-the-Top Distribution Fee ($M) | Gross_Receipts * Dist_Fee_Rate | $10.00M |
| Post-P&A Cash Available ($M) | MAX(0, Receipts*(1 - Fee) - PA_Spend) | $28.00M ($12.00M @ $30M Gross) |
| Net Backend Profit Pool ($M) | MAX(0, Post_PA_Cash - Prod_Budget) | $8.00M ($0.00M @ $30M Gross) |
| Financier Cash Multiple (x) | (MIN(Post_PA, Budget) + Backend*Share)/Budget | 1.2000x (0.6000x @ $30M Gross) |
CAMA Waterfall Equity Financier Total Cash Multiple Formula
Validate non-negative Gross_Receipts and PA_Spend, 0 <= Dist_Fee < 0.60, Production_Budget > 0, and 0 <= Backend_Share <= 1!
=LET(rc_g, B2, df_r, B3, pa_s, B4, bg_p, B5, bk_s, B6, IF(OR(rc_g < 0, df_r < 0, df_r >= 0.6, pa_s < 0, bg_p <= 0, bk_s < 0, bk_s > 1), "Invalid CAMA Waterfall Input", LET(av_c, MAX(0, rc_g * (1 - df_r) - pa_s), bk_p, MAX(0, av_c - bg_p), eq_r, MIN(av_c, bg_p) + bk_p * bk_s, ROUND(eq_r / bg_p, 4))))Modest Box-Office Partial-Recoupment Check (Set Gross Receipts = $30.00M)
Drop Worldwide_Receipts B2 to $30.00M: after $6.00M distribution fee and $12.00M P&A, Post-P&A Cash E3 falls to $12.00M (< $20.00M budget), Backend Profit Pool E4 is $0.00M, and Equity Multiple E5 compresses to 12 / 20 = 0.6000x!
=IF(ISTEXT(E5), E5, ROUND(MAX(0, B2 * (1 - B3) - B4), 2))Try the example
Use the original values or change them to test your understanding.