Film Finance & Entertainment Distribution
Theatrical Box-Office 90/10 Split & P&A Formula
Calculate Distributor Theatrical Film Rentals MAX(Floor_Pct * GBO, 0.90 * MAX(0, GBO - House_Nut)), Effective Cinema Exhibitor Retention, Post-Fee Studio Receipts, and Net Producer P&A Recoupment.
Model the Hollywood 90/10 over House Nut vs Percentage Floor clause accurately!
Cinema ticket Gross Box Office (GBO) NEVER flows 100% to a film’s producer! Standard theatrical exhibition contracts pay the distributor the GREATER of a negotiated Gross Floor Percentage Floor_Pct * GBO (typically 50%–60% on opening frames) OR 90% of box office above the theatre circuit’s negotiated overhead House Nut: Film_Rentals = MAX(Floor_Pct * GBO, 0.90 * MAX(0, GBO - House_Nut))! From Film_Rentals—NOT from GBO—the studio deducts its Distribution Fee Fee_Pct * Film_Rentals first, and then recoups upfront Print & Advertising (P&A) marketing spend before any Net Producer Corridor emerges!
Verify on Gross_Box_Office GBO = $10,000,000 (B2), Circuit_House_Nut = $3,000,000 (B3 -> 90% over nut = 0.90 * $7,000,000 = $6,300,000), Distributor_Floor_Pct = 0.55 (55.0% -> $5,500,000 floor, B4), Studio_Dist_Fee_Pct = 0.25 (25.0%, B5), and Print_And_Ad_PA = $4,000,000 (B6): Distributor Film Rentals hit MAX(5,500,000, 6,300,000) = $6,300,000.00 (E2); Effective Exhibitor Keep Share is (10M - 6.3M) / 10M = 0.3700 (37.00% in E3); Post-Fee Distributor Net is 6,300,000 * (1 - 0.25) = $4,725,000.00 (E4); and Net Producer Surplus after $4.0M P&A is +$725,000.00 (E5)! Cut GBO in half to $5,000,000 (B2 = 5,000,000): 90/10 drops to $1,800,000, so the 55% Floor ($2,750,000) takes over, leaving -$1,937,500.00 in unrecouped P&A!
| Theatrical Waterfall Metric ($10M GBO, $3M Nut, 55% Floor, 25% Dist Fee, $4M P&A) | Formula | Verified Output |
|---|---|---|
| Distributor Film Rentals ($) | MAX(Floor*GBO, 0.90*MAX(0, GBO - Nut)) | $6,300,000.00 ($2.75M @ $5M GBO) |
| Effective Exhibitor Keep Share | (GBO - Film_Rentals) / GBO | 0.3700 (37.00% Theatre Share) |
| Post-Fee Distributor Net ($) | Film_Rentals * (1 - Studio_Fee_Pct) | $4,725,000.00 |
| Net Producer P&A Corridor ($) | Post_Fee_Net - PA_Marketing_Spend | +$725,000.00 (-$1,937,500 @ $5M GBO) |
90/10 Over House Nut & P&A Recoupment Waterfall Formula
Validate GBO > 0, House_Nut >= 0, 0 < Floor_Pct <= 0.90, and 0 <= Studio_Fee_Pct < 1!
=LET(gb_o, B2, hs_n, B3, fl_p, B4, st_f, B5, pa_s, B6, IF(OR(gb_o <= 0, hs_n < 0, fl_p <= 0, fl_p > 0.9, st_f < 0, st_f >= 1, pa_s < 0), "Invalid Theatrical Deal", LET(rn_t, MAX(fl_p * gb_o, 0.9 * MAX(0, gb_o - hs_n)), nt_d, rn_t * (1 - st_f), ROUND(nt_d - pa_s, 2))))Effective Exhibitor Retention Share Formula
Audit exhibitor retention across blockbuster ($10M GBO -> 37% exhibitor share) vs soft release ($5M GBO -> 45% exhibitor share capped by 55% distributor floor)!
=IF(ISTEXT(E2), E2, ROUND((B2 - E2) / B2, 4))Try the example
Use the original values or change them to test your understanding.