Film and media financial models and waterfalls

A production spends its entire budget before a single revenue window opens. Between those two points sit tax credits received months after wrap, minimum guarantees paid on delivery, and distribution revenue that arrives net of fees on a reporting cycle measured in quarters. Modelling any of that on accrual rather than on receipt produces a financing plan that does not work in practice.

Sources of finance, modelled on receipt

Equity, pre-sales, minimum guarantees, soft money and tax credits, gap and bridge facilities each have their own timing and their own conditions precedent. The model tracks them individually: when the cash lands, what triggers it, and what the financing costs while the production waits.

Tax credits and rebates are modelled at the receipt date, with the discount and fees a lender charges to monetise them early shown explicitly. The difference between modelling a credit as an offset to budget and modelling it as cash arriving nine months after wrap is frequently the difference between a financed picture and a stalled one.

Revenue by window and territory

Theatrical, PVOD, subscription licensing, AVOD, free television and the library tail each have distinct timing, distinct splits and distinct decay. Territory is modelled separately where pre-sales carve it up. Distributor fees and recoupable expenses are deducted in the right order and at the right level, because a fee applied to the wrong base is the most common error in producer models.

The recoupment waterfall

Order of recoupment is the substance of the deal. Distribution fees, recoupable distribution expenses, senior debt, gap facilities, deferrals, equity recoupment with its premium, then net profit participation split between financiers and profit participants. Each tier is modelled as a tested tier rather than a fixed percentage of the whole, and the output shows what each participant actually receives across scenarios.

Producers routinely discover at this point that the corridor they negotiated only pays in a performance band the film is unlikely to reach. Better to discover it in the model than in a distribution statement three years later.

Scenarios and coverage

Budget coverage before principal photography — the percentage of spend already secured by pre-sales, MGs and soft money — is the number financiers open with. Around it the model runs a downside where a territory does not sell, a base where the picture performs to comparable titles, and an upside where a streamer acquires outright.

Where a waterfall already exists in a spreadsheet, a model audit tests it tier by tier. Where a production or slate needs building from scratch, the model build covers financing plan, revenue windows and waterfall in one workbook.