Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
  • Media Slate Financing Model (BASIC)
Originally published: 16/04/2020 15:22
Publication number: ELQ-75205-1
View all versions & Certificate
certified

Media Slate Financing Model (BASIC)

This is an Excel financial model for media financiers - to develop, appraise equity/debt capacity & report to investors.

Description
TESTIMONIAL:
“This is very clear. We can do our financing structure with a tried-and-tested media financing methodology.”

A leading UK and international media finance developer and investor.

Benefits:

- Appraise the co-financing media project for debt capacity and equity requirement

- Appraise the co-financing media project for equity/investment payback, cash-on-cash multiple and investor and management returns

- Report to investors and managers up to, and including, transaction

- Flexible construction to be able to try different financing solutions

- Fast simulation functionality

- Random portfolio functionality

Features:

- Three-region analysis

- 1st, 2nd and 3rd cycle revenue

- Library value

- Distribution and sales fees, calculated pre and post threshold, and fully dynamic

- Participations and residuals functionality, including recoupment

- Costs include advisory fees, fund operating costs, transaction costs and other fund costs

- Detailed financing includes equity and debt

- Debt capacity is measured using borrowing base methodology

- Capped equity mathematics

- Fund waterfall is on a co-financing arrangement

- Gross corridor functionality

- Revenues and costs phasing

- Up to five years production and twelve years release

- Up to 20 media on slate

- Up to 30 media in historic database

- Up to 1,000 simulations

- Individual media sheets

- Random portfolio generator with input degrees of uniqueness

- Full simulation VBA

- Quarterly timeline

- Full quarterly financial statements

- Full annual financial statements

Reporting:

- Media TCCR for each media in each portfolio and fund

- Gross receipts for each media in each portfolio and across fund

- Individual cash flow waterfall for each media

- Cash flow waterfall for co-financing fund

- Equity cash flows for co-financing fund

- Debt cash flows for co-financing fund

- Breakage alarm for each portfolio

- Shareholder return for each portfolio

- Management fees and returns

- Median, average, maximum and minimum of all fund key performance indicators calculated across all portfolios

- Very simple to use

- Excel and VBA written to best practice and FAST standard

Includes all standard FAST functionality including:

- Sensitivity analysis reporting

- Ref & Diff sheets

- Track sheet

- Check sheet

- Control Panel

Included in the price

- The downloaded Excel MediaModel_Basic (XLSM)

- The MediaModel User Manual (PDF)

- The Lazuli Solutions Excel Add-In with useful functionality (*)

- The “See-Through Modelling” book for detailed description of the model language and logic (*)

Contact & more information

To claim the software and book (*), or for more information, contact Dominic Robertson here: https://www.eloquens.com/channel/dominic-robertson

Please note:
The VBA modules included in this Excel solution are not accessible to the buyer and as such are password protected.

This Best Practice includes
1 The downloaded Excel MediaModel_Basic.xlsm, 1 MediaModel User Manual 01a.pdf

Acquire business license for $985.00

Add to cart

Add to bookmarks

Discuss

Further information

To develop, appraise, report and transact a co-financing of a slate of media - feature films, TV series and games.

This tool is best for media financiers.
This tool is best for those that require transparent, simple and clear Excel coding.
This tool is best for those that want a tried-and-tested solution that reads from front to back like a book.
This tool is best for those that require logic to be as separated as possible, allowing for a clear understanding of each step - in this way the model is truly editable.
This tool is best for those that want a 'bankable' solution - i.e. an Excel solution that is bank friendly.

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Media Slate Financing Model (BASIC)?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...