top of page

Entertainment Venue Excel Financial Projection Model

Highly versatile and User-friendly 3 statement 5 year rolling financial projection Excel model for a startup or existing entertainment business

DOWNLOAD DETAILS:

Excel Models 

Populated & Unpopulated

€‎49.00

Highly versatile and user-friendly Excel model for the preparation a of 5-year rolling 3 statement (Income Statement, Balance Sheet and Cash flow Statement) financial projection with a monthly timeline for a startup or existing entertainment business generating revenue through the sale of tickets, gift shop products and other income such as special events.

​

The model allows the user to model the sale of up to 5 different ticket types as well as revenue and cost of sales for gift shop sales, other income, direct and non-direct expenses, inventories, fixed assets, tax, dividends, borrowings and capital changes.

 

The model follows good practice financial modelling principles and includes instructions, line-item explanations, checks and input validations and incorporates a discounted cash flow valuation calculation using the projected cash flows.

KEY OUTPUTS

  • Projected full financial statements (Income Statement, Balance Sheet and Cash flow Statement) presented on a monthly basis across up to 5 years and summarised on an annual basis.

  • Dashboard with:

    • Summarised projected Income Statement and Balance Sheet

    • Compounded Annual Growth rate (CAGR) for each summarised income statement and Balance Sheet line item

    • List of key ratios including average revenue growth, average profit margins, average return on assets and equity and Average Debt to Equity ratio.

    • Bar charts summarising income statement and Balance Sheet projections

    • Revenue and Volume by ticket and revenue type in table and bar-chart format

  • Discounted cash flow valuation using the projected cash flow output.

KEY INPUTS

Setup Inputs:

  • Name of business;

  • Currency;

  • First projection year and month;

  • Naming for ticket categories, other income, staff costs, direct expenses, marketing costs, other expenses, fixed assets and borrowings;

  • Sales tax applicability for revenue, expense and fixed asset items.

 

Actuals Inputs:

  • Opening balance sheet (for existing businesses);

  • Income Statement actuals (for trend analysis);

 

Projection Inputs:

  • Ticket revenue including averages visitors per weekday per month, visitor mix and ticket prices;

  • Gift shop revenue including percentages of visitors making a purchase, average spend, average cost of good sold;

  • Other income including volume and income per unit;

  • Direct expense inputs including expense per operating day and per other income unit;

  • Other costs inputs including staff costs, marketing costs and other expenses;

  • Sales and corporate tax inputs including rate and payment periods;

  • Dividend inputs including amount  or percentage of retained earnings and frequency;

  • Fixed Assets including addition amounts and useful life;

  • Borrowings including addition amounts and interest rate;

  • Share Capital additions;

  • Discount rate inputs (for valuation calculation).

MODEL STRUCTURE

The model comprises of 9 tabs split into input ('i_'), calculation ('c_'), output ('o_’) and system tabs. The tabs to be populated by the user are the input tabs ('i_Setup', ‘i_Actuals’ and 'i_Assumptions'). The calculation tab uses the user-defined inputs to calculate and produce the projection outputs which are presented in 'o_Fin Stats', ‘o_Dashboard’ and ‘o_DCF’.

​

System tabs include:

  • A 'Front Sheet' containing a disclaimer, instructions and contents;

  • A checks dashboard containing a summary of checks by tab.

KEY FEATURES

  • The model follows good practice financial modelling guidelines and includes instructions, line item explanations, checks and input validations;

  • The model contains a flexible timeline that allows for a mix of Actual and Forecast period across a 5-year period. This allows projections to be easily rolled forward;

  • Timeline is split on a monthly basis and summarised on an annual basis;

  • The model allows the user to model 3 revenue sources (ticket sales, gift shop and other income) each with their own unique combinations of direct expenses;

  • The model is not password protected;

  • The model is reviewed using specialised model audit software to help ensure formula consistency and reduce risk of errors;

  • The model allows for the following number of underlying categories for each line item (these can be easily expanded if required):

    • Ticket categories – 5 categories;

    • Other income –5 categories;

    • Direct expenses – 10 categories (5 ticket revenue, 5 other income);

    • Staff costs – 10 categories;

    • Marketing costs – 5 categories;

    • Other expenses – 15 categories;

    • Fixed assets – 5 categories;

    • Borrowings – 3 facilities

  • Apart from projecting revenue and costs the tool includes the possibility to model gift shop inventories, payables, fixed assets, borrowings, dividends and corporate tax;

  • Business Name, currency, starting projection period and volume units are fully customisable;

  • Revenue, cost and fixed asset descriptions are fully customisable;

  • The model included an integrated discounted cash flow valuation using the projected cash flow outputs;

  • The model includes instructions, line item explanations, checks and input validations to help ensure input fields are populated accurately;

  • The model includes a checks dashboard which summarises all the checks included in the various tabs making it easier to identify any errors.

bottom of page