Film Finance Modeling

Single Film Financial Model & Recoupment Waterfall

Quantitative, fully structured for transparent review Excel projections modeling complex revenue cascades, distributor fees, sales agency margins, and co-production recoupment waterfalls.

Request Model Scope Detailed Specifications

Who This Is For & Problem Solved

This modeling service is designed for independent film producers, private equity investors, family offices, and distribution consultants seeking a sophisticated, mathematical representation of a film's financial lifespan.

Most independent film models are "flat sheets" with hardcoded numbers guessing return on investment. If a private equity analyst receives a financial model that lacks dynamic formulas or doesn't separate gross receipts from net producer proceeds, the package will be immediately discarded. We build dynamic, structured for transparent review models in Microsoft Excel. Every variable—from theatrical ticket sales and SVOD licenses to domestic versus foreign splits—is fully adjustable, flowing seamlessly down into standard recoupment waterfalls.

What We Deliver

  • ✓ Recoupment Waterfall Layers: Complete cash cascade modeling including senior debt fees, sales agent commissions, preferred returns, and equity corridor splits.
  • ✓ Multi-Scenario Analysis: Low, Mid, and High-case revenue projections modeled across modern distribution channels (Theatrical, PVOD, SVOD, AVOD).
  • ✓ Tax Incentive Integration: Direct modeling of transferable tax credits (like Georgia 30% or UK 40%) as early debt paydowns or production funding sources.
  • ✓ Audit-Ready Formulas: Entirely open Excel models with clear formula trails, no hidden cells, and professional formatting ready for due diligence reviews.

The Modeling Protocol

01
Revenue Assumption Analysis
We collaborate with you to define foreign pre-sales targets, domestic licensing options, and regional comparables to anchor the high/low ranges.
02
Waterfall Structure Setup
We build the recoupment columns cell-by-cell inside Excel, matching the specific legal terms of your capital partners.
03
Due Diligence Audit
We run circular dependency audits and test the model under severe conditions (e.g., 50% revenue haircuts) to ensure mathematical durability.
Advanced film financial model with recoupment waterfall simulation graph and investor return schedules
Specifications
$695 starting rate
Scope
Single Feature Film (Completed breakdown, schedule & budget required)
Turnaround Time
7 to 14 Business Days
Delivery Format
Microsoft Excel (.xlsx), Word (.docx) Investor Package, PDF
Formulas Status
100% Open, No Hidden Sheets/Macros
Request Modeling Quote
FAQ

Common Modeling Inquiries

What is a film financial model?

A film financial model is a dynamic, formula-driven projection of a film's potential revenue, expenses, and investor returns. It models theatrical, streaming, SVOD, and international sales scenarios to evaluate financial viability.

What is a recoupment waterfall?

A recoupment waterfall defines the exact sequence in which distribution receipts flow back to every party with a financial claim on the film. It models distributor fees, sales agent commissions, debt repayment, tax credits, preferred returns, and net profit splits.

What is the difference between a film budget and a film financial model?

A film budget dictates how much it costs to make the film. A film financial model projects how much the film might earn and exactly how those earnings are distributed back to investors.

How do film investors evaluate return scenarios?

Investors look at low, mid, and high revenue scenarios based on comparable films. They analyze metrics like Return on Investment (ROI), Internal Rate of Return (IRR), and the breakeven point to assess risk.

Why does a film financial model matter for investor review?

Sophisticated equity financiers and debt lenders require a detailed financial model to understand how their capital is protected, how the recoupment waterfall is structured, and what their realistic upside potential is.

What is included in this financial model package?

This package delivers a professional, single-film financial model and recoupment waterfall built in MS Excel, alongside a supporting investor package in Microsoft Word. It is best for projects that already have a completed script breakdown, production schedule, and budget.

Is this service for a single feature film or a slate?

Yes, this starting rate of $695 is designed specifically for a single feature film project. For multi-film slates or television series, please see our corporate business plan service.

Do I need to have a completed budget before using this service?

Yes. An accurate film financial model must be built on top of a realistic, professional production budget. We require your completed budget top sheet (or native Movie Magic Budgeting file) to accurately link the capital requirement and structure the model.

What specific sheets are included in the Excel model?

The Excel model includes a 3-scenario revenue forecast (low, mid, high), a detailed recoupment waterfall schedule, and an investor return summary (ROI, IRR, and payback analysis).

Are the formulas in the Excel sheet locked or hidden?

No. All of our Excel financial models are delivered 100% open with no hidden sheets, locked cells, or proprietary macros. You and your investors can audit, stress-test, and update every formula and variable as your deal terms evolve.

Related Services
Film Budget Service → Film Business Plan / Investor Package → Corporate Business Plan & Slate Budgeting →