Feature Film Title Planning

AnaplanAppHub
Not applicable
Deloitte’s Feature Film Title Planning Model is a financial model used for forecasting potential future revenue and expense streams (also known as Ultimates) that represent the worldwide distribution of a film. Projecting financials for film distribution is a complex process involving multiple revenue streams such as domestic and international box office, DVD sales, internet rentals, pay TV revenues, and free TV revenues.

Information

App Last Updated
October 28th, 2016
Size
25 MB
Language
English
Terms & Conditions

App stats

Modules
26
Roles
1
Formulas
205
Reports
7
Complexity
Intermediate

 

 

Features

Estimation of Box Office by Genre
  • The film genre, such as Action or Drama, is a major input for estimating the box office for a planned title. The model allows the user to select a genre for each title and one or several historical box office comparables for each title. The model then automatically calculates a US and International box office estimate, which can be adjusted by the user.
Revenue Curve Fitting by Day
  • An important requirement of film title planning is the ability to forecast box office by day for the first 180 days after a film is released. Since the bulk of box office usually occurs in the first three weeks, the model has a revenue curve that is automatically applied to the estimated box office to forecast the timing of box office revenues. The model has similar curves for home entertainment, internet, and television revenues.
Film Release Planning by Country
  • A requirement of film title planning is the ability to forecast revenue for multiple release dates in different countries, and in local currency. The model automatically calculates regional shares of the total international box office based on historical percentages by genre, and also calculates different box office revenue curves based on each release date.
Forecasting of Multiple Revenue Streams
  • In order to calculate a revenue Ultimate (a ten-year total of all revenues related to a film), the film title planning model must have the capacity to generate forecasts for multiple revenue streams. The model currently forecasts revenues for DVD, Blu-Ray, internet, pay TV, and free TV revenue streams based on the box office estimate.
Forecasting of Distribution Costs
  • In addition to revenue streams, there are two major costs usually related to a film release - Print Costs (either 35mm or digital) and Advertising. The title planning model generates forecasts for both of these costs based on the size of the film release, and also calculates a distribution expense curve with timing prior to the planned release date.

Deloitte

Deloitte provides industry-leading audit, consulting, tax, and advisory services to many of the world’s most admired brands, including 70% of the Fortune 500. Our people work across more than 20 industry sectors with one purpose: to deliver measurable, lasting results. We help reinforce public trust in our capital markets, inspire clients to make their most challenging business decisions with confidence, and help lead the way toward a stronger economy and a healthy society. As a member firm of Deloitte Touche Tohmatsu Limited, a network of member firms, we are proud to be part of the largest global professional services network, serving our clients in the markets that are most important to them.

Website
http://www2.deloitte.com/us/en.html
Address

Deloitte United States

30 Rockefeller Plaza

New York, NY 10112-0015

United States

Website: https://www2.deloitte.com/us/en.html

-------------

 

Deloitte Japan

Marunouchi Building, 2-4-1 Marunouchi

Chiyoda-ku, Tokyo 100-6390

Japan

Website: https://www2.deloitte.com/jp/ja/pages/about-deloitte/articles/dtc/dtc.html

 

-------------

 

Deloitte Brussels

Gateway, Luchthaven Nationaal 1 J, 1930

Zaventem, Belgium

Website: http://www.deloitte.com

-------------

 

Deloitte Australia

225 George St

Sydney, New South Wales 2000

Australia

Website: http://www.deloitte.com.au

 

Email