A film budget is a detailed financial plan that outlines all anticipated expenses involved in producing a film. It serves as a roadmap for the financial aspects of the project and helps filmmakers allocate resources efficiently and ensure that the film is completed within budget constraints.
To help you out, we at WordLayouts have designed this detailed budget template in Excel and Google Sheets. The template is organized into sections for Pre-Production, Production, Post-Production, and Marketing/Distribution. You can input costs for each phase, including activities like Script Analysis, Equipment Rental, Editing, and Press Kit Production, to calculate total costs and manage budgets effectively.
This template is a great budgeting tool if you are an independent filmmaker, small- to medium-sized production company, film student, or organization in need of thorough budget submissions for grants and film festivals.
With built-in formulas and automated calculations, this template simplifies your film budgeting and helps you in financial planning and tracking your budget throughout the film project.
Before we go into how to use this budget planner, remember that this is a fully editable template and flexible enough to be adjusted to your needs. If you find a heading or section that needs changing or need to add more rows, you can easily do so.
Here is how to use this template:
Pre-Production
Examples: Script Analysis, Location Scouting, Casting, Rehearsals, Production Design
These are costs associated with activities before filming, such as analyzing the script, scouting locations, casting actors, rehearsing, and designing production elements.
Most of the hires and rentals in this phase will cost you per hour. Given that, you can add the Qty, Duration, and Rate Per Hour in the given columns, and the template will auto-calculate the total cost of each expense.
Production
Examples: Principal Cast, Extras, Production Crew, Equipment Rental, Set Construction
This section refers to costs related to the filming process, including payments for the principal cast, extras, production crew, equipment rentals, set construction, and others. We have added the same Qty, Duration, and Rate per Hour columns to calculate costs.
Post-Production
Examples: Editing, Sound Design, Color Grading, Visual Effects, Master Copies
This section is for planning the post-production costs, such as editing, sound design, color grading, visual effects, and creating master copies.
These usually are charged at a per-day rate. You can enter the estimated days and cost per day to calculate estimates.
Marketing and Distribution
Examples: Press Kit Production, Screening Costs, Festival Submissions, Promotional Materials, Distribution
These are the costs for promoting and distributing the film, which include the production of press kits, screening costs, festival submissions, promotional materials, and distribution expenses.
In this section, you can input the quantity and rate for each marketing and distribution activity. For example, for press kits, you can enter the number of kits and the cost per kit.
Contingency
This refers to the percentage of the total budget allocated for unforeseen expenses or emergencies.
You can enter the percentage of the total budget you wish to allocate as a contingency fund. The sheet calculates the contingency funds based on the estimated budget for total production. For example, as shown in the sample data in the template, if the total of all items in the budget is $125,000 and you allocate 10% as the contingency fund, the sheet will automatically compute $125000*0.10 = $12,500.
Grand Total
This section gives a thorough overview of the entire budget by taking totals from the pre-production, production, post-production, marketing, and contingency sections.
Budget vs. Actual
We have added this section to compare the actual cost with your estimated cost to analyze cost variances.
You can compare the budgeted costs with the actual costs by entering the actual expenses incurred in each category. The template will calculate the difference between budgeted and actual costs and show the totals.
We have added a bar graph at the top of the template that reflects these values so you can see which category is consuming more budget.
Notes
We have added this section for you to add any additional information or comments related to the budget, providing context or explanations for budget decisions.
Change Log
This section can be used to document any budget changes, including who made them and when.
We have designed this film budget template to be a helpful resource that simplifies the budgeting process for filmmakers and facilitates efficient and accurate financial planning and management. It is completely editable and flexible to be adjusted to your needs. It is available to download for Excel and ODS, and also available in Google Sheets.
