Plain Simple Template - Excel by zkw72695

VIEWS: 71 PAGES: 5

More Info
									The template is meant to be used as a guideline. The finance
plan can naturally be simplified and adjusted freely to meet
the different requirements that apply for the different kind
of productions.



The example illustrates a co-production between a
Norwegian, Icelandic and a French production company
– where the Norwegian production company acts as the 
delegate producer. There are pro rata calculations
between the production companies when it comes
to Eurimages and Nordisk Film & TV Fond.



There are four(4) other worksheets in this document:


          Finance Plan

          Nordisk Film & TV Fond Pro Rata

          Eurimages Pro Rata

          Finance Plan Simple
          The worksheet “Finance Plan Simple” is a simple 
          version that does NOT incl. co-producers and Pro
          Rata calculations.
FINANCE PLAN - EXAMPLE, PLEASE NOTE: behind BLUE cells are plain numbers, behind YELLOW cells are pre-made formulas
                                                                                        Rates       date of rates
                                                                                        NOK/ISK            18.86    0.0530459
                                                                                        NOK/EUR        0.123562       8.09241
Title: name of project                                                                                  EUR                               NOK
Date: date of completing the finance plan                                               EURIMAGES       350,000                 NFTF     800,000

                                                             Eurimage
                                                              s/NFTF        Origin of
                                         Type of finance        %           currency       NOK          ISK           EUR       Budget % Sub. %         Status
NORWAY
Producer: //name of production company
Norwegian Film Institute                 Public Fund                  NOK 4,000,000       4,000,000 75,440,000 494,290            26.45%  35.95%   Contract/Confirmed
Eurimages                                Public Fund           73.58% EUR   257,522       2,083,970 39,303,677 257,522            13.78%  18.73%   TBC, 12.05.11
Nordisk Film & TV Fond                   Public Fund           83.16% NOK   665,273         665,273 12,547,046  82,209             4.40%   5.98%   TBC, 02.06.11
Local Regional Fund                      Public Fund                  NOK   750,000         750,000 14,145,000  92,679             4.96%   6.74%   Contract/Confirmed
NRK license                              TV presale                   NOK   500,000         500,000  9,430,000  61,786             3.31%   4.49%   Contract/Confirmed
NRK equity                               TV investment                NOK   250,000         250,000  4,715,000  30,893             1.65%   2.25%   Contract/Confirmed
Film Distributor Norway MG               Minimum Guarantee            NOK   750,000         750,000 14,145,000  92,679             4.96%   6.74%   LOC
Private investor                         Equity                       NOK 1,000,000       1,000,000 18,860,000 123,573             6.61%   8.99%   Contract/Confirmed
Own Investment/Deferment                 Own investment               NOK 1,128,242       1,128,242 21,278,644 139,420             7.46%  10.14%   Contract/Confirmed
                                                                                        11,127,485 ####### 1,375,052             73.58% 100.00%
ICELAND
Producer: //name of production company
Icelandic Film Centre                    Public Fund                  ISK   ######          795,334 15,000,000         98,281      5.26%  35.29%   Contract/Confirmed
Eurimages                                Public Fund           14.90% EUR      52,152       422,033  7,959,551         52,152      2.79%  18.73%   TBC, 12.05.11
Nordisk Film & TV Fond                   Public Fund           16.84% NOK     134,727       134,727  2,540,954         16,649      0.89%   5.98%   TBC, 05.05.11
20% TAX Reimburcement                    TAX Reimburcement            ISK   6,000,000       318,134  6,000,000         39,313      2.10%  14.12%   LOC
RUV license                              TV presale                   ISK   3,000,000       159,067  3,000,000         19,656      1.05%   7.06%   LOC
Film Distributor Iceland MG              Minimum Guarantee            ISK   3,000,000       159,067  3,000,000         19,656      1.05%   7.06%   LOI
Own Investment/Deferment                 Own investment               ISK   5,000,000       265,111  5,000,000         32,760      1.75%  11.76%   Contract/Confirmed
                                                                                         2,253,473 42,500,505        278,468     14.90% 100.00%
FRANCE
Producer: //name of production company
CNC                                      Public Fund                  EUR      50,000       404,621  7,631,143         50,000      2.68%  23.22%   LOC
Eurimages                                Public Fund           11.52% EUR      40,327       326,340  6,154,770         40,327      2.16%  18.73%   TBC, 12.05.11
ARTE license                             TV presale                   EUR      50,000       404,621  7,631,143         50,000      2.68%  23.22%   LOI
ARTE equity                              TV investment                EUR      50,000       404,621  7,631,143         50,000      2.68%  23.22%   LOI
Own Investment/Deferment                 Own investment               EUR      25,000       202,310  3,815,571         25,000      1.34%  11.61%   Contract/Confirmed
                                                                                         1,742,512 32,863,770        215,327     11.52% 100.00%

TOTAL                                                                                   15,123,470 #######          1,868,846 100.00%
PRO RATA - Nordisk Film og TV Fond


NORWAY                                  NOK
Producer: //name of production company
Norwegian Film Institute               4,000,000
Local Regional Fund                      750,000
NRK license                              500,000
NRK equity                               250,000
Film Distributor Norway MG               750,000
Private investor                       1,000,000
Own Investment/Deferment               1,128,242
                                                    8,378,242   83.16%
ICELAND
Producer: //name of production company
Icelandic Film Centre                    795,334
20% TAX Reimburcement                    318,134
RUV license                              159,067
Film Distributor Iceland MG              159,067
Own Investment/Deferment                 265,111
                                                    1,696,713   16.84%

                                                   10,074,955
PRO RATA - EURIMAGES


NORWAY                                  NOK
Producer: //name of production company
Norwegian Film Institute               4,000,000
Nordisk Film & TV Fond                   665,273
Local Regional Fund                      750,000
NRK license                              500,000
NRK equity                               250,000
Film Distributor Norway MG               750,000
Private investor                       1,000,000
Own Investment/Deferment               1,128,242
                                                   9,043,515 73.58%
ICELAND
Producer: //name of production company
Icelandic Film Centre                    795,334
Nordisk Film & TV Fond                   134,727
20% TAX Reimburcement                    318,134
RUV license                              159,067
Film Distributor Iceland MG              159,067
Own Investment/Deferment                 265,111
                                                   1,831,440 14.90%
FRANCE
Producer: //name of production company
CNC                                      404,621
ARTE license                             404,621
ARTE equity                              404,621
Own Investment/Deferment                 202,310
                                                   1,416,172 11.52%


                                                   ###### 100.00%
FINANCE PLAN - EXAMPLE, PLEASE NOTE: behind BLUE cells are plain numbers, behind YELLOW cells are pre-made formulas

Title: name of project

Date: date of completing the finance plan




                                                                    Origin of
                                            Type of finance         currency      NOK         SEK        EUR       Budget %       Status
Producer: //name of production company
Norwegian Film Institute                 Public Fund          NOK #######        5,000,000   4,347,826   650,000     47.34% Contract/Confirmed
Nordisk Film & TV Fond                   Public Fund          NOK    600,000      600,000     521,739     78,000      5.68% TBC, ca. 02.06.11
NRK license                              TV presale           NOK    250,000      250,000     217,391     32,500      2.37% Contract/Confirmed
NRK equity                               TV investment        NOK    750,000      750,000     652,174     97,500      7.10% Contract/Confirmed
Film Distributor Norway MG               Minimum GuaranteeNOK        750,000      750,000     652,174     97,500      7.10% LOC
Private investor                         Equity               NOK #######        1,500,000   1,304,348   195,000     14.20% Contract/Confirmed
Own Investment/Deferment                 Own investment       NOK #######        1,128,242    981,080    146,671     10.68% Contract/Confirmed
SVT                                      TV presale           SEK    450,000      391,304     450,000     50,687      3.70% LOC
YLE                                      TV presale           EUR     25,000      193,000     167,910     25,000      1.83% LOI


TOTAL                                                                           10,562,546   9,294,642 1,372,859    100.00%

								
To top