Project Finance Financial Models

The financial model presents the business case of Movie Production. The model accommodates all the detailed information of the Movie Production. This model describes the overall process of the movie production

The model describes the business case of the Movie Production. This model goes for 10 years and it includes the financial projections.
The model is prepared for the production of the three movies – Low Medium and High Budget. The model works through the inputs which are blue in color. This changes all the calculations as needed and are adjusted in the template as per the business case.
The executive summary contains all the important assumptions.
The box office collection contains the domestic as well as overseas collection of the movies.
The Revenue/Operating model uses the assumptions to calculate revenue.
The Revenue build up shows the overall revenue by selecting the method of the film distribution.
The Costing Assumption model includes different costing figures which are based on the assumptions.
The Debt Schedule is a complete table of the periodic loan payments, shows the amount of the principle
and the amount of interest that comprise each payment until the loan is paid off at the end of its term.
The Income and Expenditure Statement specifies the profit and loss incurred by business.
The Break Even Analysis calculates the period when the EBITDA becomes positive first time (Time to Break-Even).
The Return on Investment calculates the return on the amount invested.