Financial Guide

Film P&L Projection: How to Model Revenue, Costs, and Break-Even

Nick HartyBy Nick HartyUpdated September 14, 20266 min read

Quick answer

A film P&L projection is a spreadsheet model that estimates what a film will earn, by territory and release window, and subtracts everything taken before money reaches the producer: distribution fees and expenses, sales agent commission, collection account fees, residuals, and financing costs. It compares what's left with the budget net of incentives to show profit or loss and the break-even point, usually under low, base, and high scenarios.

On this page
  1. The shape of the model
  2. Revenue: building it from deals, not box office
  3. Deductions: following the money
  4. Production cost: use the net number
  5. The result under three cases
  6. Finding break-even
  7. Sensitivities worth running
  8. Mistakes that make projections useless
  9. Where this connects

The budget tells you what a film costs. A P&L projection tells you whether anyone gets their money back, and at what level of sales. Producers build one to decide whether a project is worth packaging, financiers use one to size equity and loans, and sales agents build their own version to decide whether to take a film on. This post covers the mechanics of building the numbers. For how to present them to investors, see film P&L for investors.

Every revenue figure and percentage in the examples below is an assumption chosen for illustration. Real fees come from signed agreements, and real revenue comes from actual deals, so replace them as soon as you have them.

The shape of the model

A film P&L has four blocks, top to bottom:

  1. Revenue by source. Domestic and international, broken into the deals or windows that will actually exist for this film.
  2. Deductions before the money reaches the producer. Distribution fees, distribution expenses including P&A, sales agent commission and expenses, collection account fees, and residuals.
  3. Production cost. The budget net of incentives, plus financing costs such as loan interest and fees.
  4. Result. Net profit or loss, the break-even point, and how the profit would be split under the waterfall.

Most models run each block under three scenarios: low, base, and high. Some add a "no domestic sale" case, because that's a real outcome for many independent films.

Revenue: building it from deals, not box office

The old way to project revenue was to take a comparable film's box office and work down. That still happens on studio films. For an independent feature, the more reliable input is the sales agent's estimates, territory by territory.

A typical estimate sheet gives two numbers per territory: the ask (what the agent will open with) and the take (what they'd accept). Use the take for the base case and something below it for the low case. Use the ask only for the high case, and only if the agent thinks it's realistic.

Domestic (the US and Canada) usually gets its own line or lines. It might be an all-rights deal with an independent distributor, a streaming license, a theatrical release with a distributor who pays nothing up front but takes fees and expenses, or a combination. Each has a different path to the producer, so model them separately.

For example, an illustrative thriller with two recognizable leads:

SourceLowBaseHigh
International sales (sum of territories)$1,400,000$2,100,000$2,900,000
Domestic streaming license$0$1,200,000$1,800,000
Domestic theatrical and later windows, net to producer$0$150,000$600,000
Gross receipts to the collection account$1,400,000$3,450,000$5,300,000

Note the third line is already net. When a domestic distributor releases a film theatrically, it collects box office rentals, deducts its distribution fee and recoups its P&A spend, and remits what's left. That remittance, not the box office, is what reaches the producer's side of the model. Plenty of theatrical releases send nothing back once P&A is recouped, which is why the low case shows zero.

Deductions: following the money

The next block takes deductions from gross receipts in the order they actually happen. In this example the percentages are assumptions; the waterfall entry works through a similar tier order.

DeductionAssumptionBase case
Collection account management fee1% of gross$34,500
Sales agent commission15% of international gross$315,000
Sales agent expenses (markets, deliverables, marketing)capped$90,000
Domestic producer's rep or agency fee10% of domestic license$120,000
Residuals reserveset with guild counsel$110,000
Total deductions$669,500
Net receipts to the production$3,450,000 minus $669,500$2,780,500

Residuals get forgotten more than any other line. SAG-AFTRA, WGA, and DGA agreements require residual payments when a film is exploited in later markets such as streaming, pay TV, and home video, calculated from the distributor's gross receipts in those markets. Who pays them depends on the distribution agreements (many buyers assume them, some don't), so budget a reserve until the deal paperwork says otherwise.

Production cost: use the net number

The cost block starts with the locked budget and subtracts incentives at the amount you'll actually receive.

Say the film budgets $4,000,000 and shoots in Louisiana, earning a 25% base credit on $3,200,000 of qualified spend, or $800,000 face value. Louisiana lets producers transfer credits back to the state at 90% of face value with a 2% transfer fee, which nets 88%: $800,000 x 0.88 = $704,000. If a lender advanced money against the credit, add its interest and fees; here, $45,000.

LineAmount
Budget$4,000,000
Less incentive, net of transfer($704,000)
Plus incentive loan interest and fees$45,000
Plus gap loan interest and fees$60,000
Net production cost$3,401,000

Show the incentive only here. If it also appears as revenue in the top block, the P&L counts it twice, and a careful financier will catch it.

The result under three cases

Running the whole model:

LowBaseHigh
Gross receipts$1,400,000$3,450,000$5,300,000
Deductions($370,000)($669,500)($975,000)
Net receipts$1,030,000$2,780,500$4,325,000
Net production cost($3,401,000)($3,401,000)($3,401,000)
Profit or (loss)($2,371,000)($620,500)$924,000

(The low and high deduction totals use the same percentages applied to their own gross figures, with the expense cap and residual reserve adjusted.)

The base case loses money. That's a common and useful result. It tells the producer the film needs a better domestic deal, a lower budget, a bigger incentive, or more pre-sold territories before it makes sense for equity.

Finding break-even

Break-even is the gross at which net receipts equal net production cost. Roughly, if deductions average about 19% of gross in the base case ($669,500 / $3,450,000 = 19.4%), then:

  • Required net receipts: $3,401,000
  • Required gross: $3,401,000 / (1 minus 0.194) = $3,401,000 / 0.806 = about $4,219,600

So the film needs roughly $4.2 million of gross receipts to the collection account just to return its cost, before any equity premium. That's about $770,000 above the base case. The model now points to specific questions: can one more major territory close at the take figure, or can the budget come down by $600,000 without losing the cast that drives the estimates?

If equity is promised a premium (for example 120% recoupment), add that premium to the required net receipts. On $1,500,000 of equity, a 20% premium adds $300,000, and break-even gross rises to ($3,401,000 + $300,000) / 0.806 = about $4,591,800.

Sensitivities worth running

A P&L gets more useful when you vary one input at a time and watch the result:

  • Domestic license from $1,200,000 to $800,000.
  • Sales agent expense cap from $90,000 to $150,000.
  • Incentive received three months later, with the loan interest that adds.
  • The largest single territory falling through.
  • The budget coming in 5% over, eaten out of contingency or not.

The inputs that swing the result most are the ones to lock in the deal documents first.

Mistakes that make projections useless

Using ask prices in the base case makes every film look profitable. Treating the minimum guarantee and a projected overage as separate revenue double counts, because overages only arrive once the distributor has recouped the MG, its fees, and its expenses. Ignoring timing is another: international sales can take years to collect, and a dollar in year three is worth less than one at delivery, especially when a loan is accruing interest. And forgetting that the budget itself is a projection. If the P&L is built on the breakdown budget rather than the locked one, update it at greenlight.

Where this connects

The P&L sits alongside the finance plan. How to finance an indie film covers the sources of money, pre-sales and minimum guarantees explains how territory deals are paid, and the recoupment and prints and advertising entries define the terms used above. The cost block comes from your budget; Storiara's Budget module shows a net total after applying estimated incentives from its Funding module, which is a starting point you'd replace with the net figures from your incentive counsel and lender.

Frequently asked questions

Where do revenue numbers in a film P&L come from?

For independent films, from a sales agent's estimates by territory, usually given as a high figure (the ask) and a low figure (the take). Domestic numbers come from comparable films and conversations with distributors and streamers. Box office from other films is a weak guide unless the comparable is close in genre, cast, and release plan.

What is the difference between gross and net in a film P&L?

Gross is what a buyer pays or a distributor collects. Net is what's left after fees, expenses, and other deductions at each step. A P&L has to follow the money through each step, because the same film can gross $5 million and send far less to its investors.

How do tax incentives appear in a P&L projection?

Usually as a reduction of the production cost or as a source of financing, at the net amount actually received after any sale discount, transfer fee, audit cost, and loan interest. Treat them consistently; showing them both as revenue and as a budget reduction double counts them.

What is break-even for a film?

The level of gross revenue at which the money flowing back to the production covers the net production cost plus financing costs. Every dollar of fees, expenses, and deductions above the production pushes the break-even higher than the budget.

Sources

Plan your production in Storiara

Upload a PDF, Word, or Final Draft script. Storiara breaks it down into scenes, cast, locations, props, and wardrobe, and keeps the stripboard, budget, and call sheets tied to that breakdown.

Start Planning for Free
Nick Harty

Nick Harty

Technical Lead, Storiara

Technical architect and full-stack engineer building the core systems that power Storiara. Creates technology that enhances creative workflows.