Film Finance / Strategy
Overview
The model supported clearer analysis of how revenue scenarios flow through fees, recoupment, and participation structures.
The challenge
Financial waterfall structures can be hard to test quickly when assumptions, fees, and stakeholder terms change across scenarios.
My role
I structured the waterfall logic, separated assumptions from outputs, and designed views for comparing revenue and participation scenarios.
What I built
A recoupment and revenue waterfall model with scenario inputs, fee logic, stakeholder participation, and summary outputs.
Process
I mapped the financial sequence, defined the assumption controls, validated calculations, and created readable summary views for review.
Key features
Revenue scenarios • Recoupment logic • Fee structures • Participation outputs • Sensitivity views
Outcomes
Stakeholders could test financial outcomes more quickly and understand how changes affected recoupment and participation.
Tools and methods
Revenue modeling, film finance, scenario planning, spreadsheet systems, financial analysis