ࡱ>  L\pJill Caulfield Ba==x[;!8X@"1UArial1UArial1UArial1UArial1UVerdana1UArial1UArial1UArial1UArial1UArial1UVerdana1h8UCambria1,8UCalibri18UCalibri18UCalibri1UCalibri1UCalibri1<UCalibri1>UCalibri1?UCalibri14UCalibri14UCalibri1 UCalibri1 UCalibri1UArial1UCalibri1UCalibri1 UCalibri1UCalibri+" "#,##0;\-" "#,##05" "#,##0;[Red]\-" "#,##07" "#,##0.00;\-" "#,##0.00A" "#,##0.00;[Red]\-" "#,##0.00e*0_-" "* #,##0_-;\-" "* #,##0_-;_-" "* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-u,8_-" "* #,##0.00_-;\-" "* #,##0.00_-;_-" "* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                                                                      ff + )       P  P        `            a>   8    "   #  x  H  @  8  x  a@  h  #   8 #P  H  @   H  h #P # (x "P   x     H   H    8  20% - Accent1 20% - Accent2 20% - Accent3 20% - Accent4 20% - Accent5 20% - Accent6 40% - Accent1 40% - Accent2 40% - Accent3 40% - Accent4 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 60% - Accent3 60% - Accent4 60% - Accent5! 60% - Accent6 "Accent1 #Accent2 $Accent3 %Accent4 &Accent5 'Accent6(Bad) Calculation* Check Cell+,-./Explanatory Text 0Good1 Heading 12 Heading 23 Heading 34 Heading 4 5Input6 Linked Cell 7Neutral 8Note 9Output: ;Title <Total= Warning Text` ?P&LuqCashflow Balance sheet Market dataRP&L-SensitivityCashflow-Sensitivity!87Balance sheet-SensitivityagxRetail activities$Subscription income (Basic packages)&Subscription income (Premium packages)/Other delivery-based income (e.g. pay-per-view)Other income (please specify)Wholesale activitiesSubscriber management & billingMarketing and sales1Support for acquisition of DTT receiver equipment"Other subscriber acquisition costsProgramme contentOwn-production costs7Costs associated directly with provision of NI materialMultiplex operationCoding & multiplexingDistribution (to tx sites)Monitoring/Compliance feesTransmission servicesPower.Contribution to capital recovery (if relevant)Technical servicesCentralised Service InformationConditional access facilitiesLCN administrationReceiver upgrade arrangements EPG provisionAdministration)Licence fees and other regulatory chargesManagement and legal feesOther staff costsAccommodation costsOtherOther (please specify)Network infrastructure(Year ending 31 December) '000 (Constant 2008 prices)Profit & Loss ProjectionsCash-flow ProjectionsBalance Sheet ProjectionsCapital expenditureRevenue)Advertising (e.g. EPG banner advertising))Technical support services fees (e.g. CA)Platform carriage fees Sub-total1Other revenue not included above (please specify) Total revenueOperating Expenditure Depreciation)Content acquisition fees - basic channels+Content acquisition fees - premium channels*Contribution to DTT promotion/ASO activity1Total Operating Expenditure (before depreciation)D&A Amortisation'Total Operating Expenditure (after D&A)Operating Profit (EBIT)Net interest payableTaxProfit After TaxOperating profit (EBIT)Movement in debtorsMovement in creditorsShare capital issuedLoan draw-downsDividends paidLoan repayments Interest paid Customer BaseRetail customers&Number of basic subscription customers(Number of premium subscription customers Other customers (please specify)Wholesale customers(Mid-year figures))Please specify types and numbers for each Fixed assetsCurrent assetsLong-term liabilitiesTrade receivablesCash and equivalentsAccounts payableCurrent liabilitiesCapitalRetained profit (loss) Share capital BorrowingsPlant & equipment Net AssetsMarket Projections('000)Market size in Ireland PopulationPay TV households SatelliteFree-to-air only householdsAnalogue (inc. UK channels)Analogue (Irish channels only)DTTSatellite (freesat)IPTVDigital cable/MMDSAnalogue cable/MMDSProjected demandDTT receiver sales Set-top boxesIntegrated digital televisions('000) at mid-year$(* based on platform for primary TV)DTT-enabled TVs Primary TVsFree-to-air only Secondary TVsDTT Pay servicesBasic subscription package onlyPremium subscription packagePayNet cash-flow from tradingNet cash-flow before taxNet cash-flow after financeNet cash-flow after taxAnnual cash flowCapital expenditure breakdownCustomer contact centrePlay-out centre(please detail)Multiplexing centreTotalNotesSee below for breakdown7Breakdown of households with DTT-enabled secondary TVs*(* by platform for primary TV)ditto+Transmitter network operation & maintenance1Other communications costs (e.g. programme feeds)DTT households* DTT householdsPremium subscribersBasic-only subscribersFTA-onlyNumber of TV households+Number of pay-TV households (all platforms)See also section 3.5 of GuideSee also section 3.6 of GuideSee section 3.4.2 of Guide See also section 3.9 of GuideSee also section 3.8 of Guideu z]3XI A x - V! ! " #ccc||\:}-}; 00_)}A}1 00_)[$ -}A}2 00_)?[$ -}A}3 00_)23[$ -}-}4 00_)}A}0 a00_)[$ -}A}( 00_)[$ -}A}7 e00_)[$ -}}5 ??v00_)̙[$ -##0.??_-  }}9 ???00_)[$ -???##0.?????_- ??? ???}}) }00_)[$ -##0.??_-  }A}6 }00_)[$ -}}* 00_)[$ -???##0.?????_- ??? ???}-}= 00_)}x}800_)[$???## ????? ???}-}/ 00_)}U}< 00_)[$## }A}" 00_)[$}A} 00_)ef[$}A} 00_)L[$}A} 00_)23[$}A}# 00_)[$}A} 00_)ef[$}A} 00_)L[$}A} 00_)23[$}A}$ 00_)[$}A} 00_)ef[$}A} 00_)L[$}A} 00_)23[$}A}% 00_)[$}A} 00_)ef[$}A} 00_)L[$}A} 00_)23[$}A}& 00_)[$}A} 00_)ef[$}A} 00_)L[$}A}  00_)23[$}A}' 00_) [$}A} 00_)ef [$}A} 00_)L [$}A}! 00_)23 [$M 20% - Accent1 ef %M" 20% - Accent2 ef %M& 20% - Accent3 ef %M* 20% - Accent4 ef %M. 20% - Accent5 ef %M2 20% - Accent6  ef %M 40% - Accent1 L %M# 40% - Accent2 L湸 %M' 40% - Accent3 L %M+ 40% - Accent4 L %M/ 40% - Accent5 L %M3 40% - Accent6  Lմ %M 60% - Accent1 23 %M$ 60% - Accent2 23ٗ %M( 60% - Accent3 23֚ %M, 60% - Accent4 23 %M0 60% - Accent5 23 %M4 60% - Accent6  23 %AAccent1 O %A!Accent2 PM %A%Accent3 Y %A)Accent4 d %A-Accent5 K %A1Accent6  F %9Bad  % Calculation  }%  Check Cell  %????????? ??? Comma( Comma [0]&Currency. Currency [0]G5Explanatory Text %;Good  a%G Heading 1 I}%OG Heading 2 I}%?G Heading 3 I}%239 Heading 4 I}%uInput ̙ ??v% K Linked Cell }%ANeutral  e%"Normalb Note  wOutput  ???%????????? ???$Percent1Title I}%MTotal %OO? Warning Text %XTableStyleMedium9PivotStyleLight16B L U\cll:p  dMbP?_*+%MNHP CLJ 3800-1pC 4dXXA4DINU"4<I7`A<IUPHdA4 o [none] [none]Arial4Pd?DAVID WHITE<Automatic>dMicrosoft Office Excelype new Quick Set name here.l EXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"dXX??U} } 3} m } $ } m} $ Uh@    @ @@@@@@@@@@@ @@@@ B$ C"Z@`@@d@@h@@l@@p@@t@@x@@|@@@@@@@@@@@@@ @ A ED MJ A > XE XF AY XG AY XH A YX A ZI XK A ZX A A E( M# A > > > ? > > ?> >?> >)?> >?> G,"FFFFFFFFFFFFFF > >+?> >*?> >?? G,"FFFFFFFFFFFFFF ? D-?? G,"FFFFFFFFFFFFFF ?D?? H."IIIIIIIIIIIIII ??? J/ M#? > > >>> >>> > >> > >D^lz 4&""& 4&"""">&"">&>>4&"& @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@ > G," FFFFFFFFFFFFFF >&!>G??????????????!> "> ">1 ">#> #>2 #[$> $> $>%> %> %>&> &G,"&FFFFFFFFFFFFFF&>&'>G??????????????'> (> (> (>)> )> )[*> *>*>+> +>+>,> ,G,",FFFFFFFFFFFFFF&->G?????????????? .> .>.> .>/> />/> /[0> 0>0> 0[1> 1G,"1FFFFFFFFFFFFFF&2>G?????????????? 3> 3>3> 3>4> 4>4> 4[5> 5>5>6> 6>6> 6[7> 7>7>8> 8G,"8FFFFFFFFFFFFFF&9>G?????????????? :> :>:>;> ;>;><> <><>=> =>=>>> >G,">FFFFFFFFFFFFFF&?>G??????????????D<lH4*&"&H4*&"">*400>*40"0">*&""">@@A@BCD EFGHIJ KLMNOPQ RST @> @>3@>A> A> A> BG,"BFFFFFFFFFFFFFF DK4"DIIIIIIIIIIIIII F5 F0 G6 HL,"HFFFFFFFFFFFFFF JK7"JIIIIIIIIIIIIII LE8 LM#"LFFFFFFFFFFFFFF N9 O: QE; QM#"QIIIIIIIIIIIIII.&"4444BB>@A 7b(b(***ggD&J L +  dMbP?_*+%MNHP CLJ 3800-1pC 4dXXA4DINU"4<I7`A<IUPHdLetter o [none] [none]Arial4Pd?DAVID WHITE<Automatic>dMicrosoft Office Excel.l EXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"dXX??U} I!} I} $ } } $ +hO       B% C"Z@`@@d@@h@@l@@p@@t@@x@@|@@@@@@@@@@@@@ @  A# Jy M# A > QR U < 0 = >  Cu" FFFFFFFFFFFFFF ' >  Cv"FFFFFFFFFFFFFF : Cx"FFFFFFFFFFFFFF ? A @ B C Cw"IIIIIIIIIIIIII Jz M# V{ }D.lz44444 !"#$%&'() * W !V| !}"W #W~ #}$W %V! %} ' )C")IIIIIIIIIIIIII   4>@A 7b(b(***ggD&J L *X  dMbP?_*+%MNHP CLJ 3800-1pC 4dXXA4DINU"4<I7`A<IUPHdLetter o [none] [none]Arial4Pd?DAVID WHITE<Automatic>dMicrosoft Office Excel.l EXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"dXX??U} I} $ } I} $ h      B& C"Z@`@@d@@h@@l@@p@@t@@x@@|@@@@@@@@@@@@@ @ A JX M# > QR L W  "FFFFFFFFFFFFFF M O P  " FFFFFFFFFFFFFF R Q  "FFFFFFFFFFFFFF N V  "FFFFFFFFFFFFFF JS M# S U T  "FFFFFFFFFFFFFF>0z *&&&&&>@A 7b(b(***ggD&B L H7u]  dMbP?_*+%MNHP CLJ 3800-1pC 4dXXA4DINU"4<I7`A<IUPHdA4 o [none] [none]Arial4Pd?DAVID WHITE<Automatic>dMicrosoft Office Excel.l EXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"dXX??U} $} $} $ } } $ Hh         BYCZ@`@@d@@h@@l@@p@@t@@x@@|@@@@@@@@@@@@@ @ A J[ Mk QR \   J Mk Sl     C"IIIIIIIIIIIIII Jg MZ h i j C"IIIIIIIIIIIIII q r s  C"IIIIIIIIIIIIII Jm Mk n oDlv 444 !"#$%&' ()*+,-./0123456789: ;<=>? t !C,"!FFFFFFFFFFFFFF #p #o $t %C,"%FFFFFFFFFFFFFF"&?????????????? 'C"'IIIIIIIIIIIIII )T )Mk *S +_ +` ,a -c .b / 0C,"0FFFFFFFFFFFFFF 2] 2^ 3e 4f 5b 6d 7 8C,"8FFFFFFFFFFFFFF :C":IIIIIIIIIIIIIIDl44&4444@ABCDEFG>@A 7ggD&J L Sh0 Z  dMbP?_*+%MNHP CLJ 3800-1pC 4dXXA4DINU"4<I7`A<IUPHdA4 o [none] [none]Arial4Pd?DAVID WHITE<Automatic>dMicrosoft Office Excel.l EXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"dXX??U} } 3} m } $ } m} $ Sh    @ @@@@@@@@@@@ @@@@ B$ C"Z@`@@d@@h@@l@@p@@t@@x@@|@@@@@@@@@@@@@ @ A ED MJ A > PE OF AN OG AN OH A NO A I OK A A A E( M# A > > > ? > > ?> >?> >)?> >?> G,"FFFFFFFFFFFFFF > >+?> >*?> >?? G,"FFFFFFFFFFFFFF ? D-?? G,"FFFFFFFFFFFFFF ?D?? H."IIIIIIIIIIIIII ??? J/ M#? > > >>> >>> > >> > >DPlz 4&""& 4&"""">&"">&>>4&"& @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@ > G," FFFFFFFFFFFFFF >&!>G??????????????!> "> ">1 ">#> #>2 #[$> $> $>%> %> %>&> &G,"&FFFFFFFFFFFFFF&>&'>G??????????????'> (> (> (>)> )> )[*> *>*>+> +>+>,> ,G,",FFFFFFFFFFFFFF&->G?????????????? .> .>.> .>/> />/> /[0> 0>0> 0[1> 1G,"1FFFFFFFFFFFFFF&2>G?????????????? 3> 3>3> 3>4> 4>4> 4[5> 5>5>6> 6>6> 6[7> 7>7>8> 8G,"8FFFFFFFFFFFFFF&9>G?????????????? :> :>:>;> ;>;><> <><>=> =>=>>> >G,">FFFFFFFFFFFFFF&?>G??????????????D<lH4*&"&H4*&"">*400>*40"0">*&""">@@A@BCD EFGHIJ KLMNOPQ R @> @>3@>A> A> A> BG,"BFFFFFFFFFFFFFF DK4"DIIIIIIIIIIIIII F5 F0 G6 HL,"HFFFFFFFFFFFFFF JK7"JIIIIIIIIIIIIII LE8 LM#"LFFFFFFFFFFFFFF N9 O: QE; QM#"QIIIIIIIIIIIIII*^h&"4444BB>@A ---7b(b(,,,ggD&J L +.946  dMbP?_*+%MNHP CLJ 3800-1pC 4dXXA4DINU"4<I7`A<IUPHdLetter o [none] [none]Arial4Pd?DAVID WHITE<Automatic>dMicrosoft Office Excel.l EXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"dXX??U} I!} I} $ } } $ +hO       B% C"Z@`@@d@@h@@l@@p@@t@@x@@|@@@@@@@@@@@@@ @  A# Jy M# A > QR U < 0 = >  Cu" FFFFFFFFFFFFFF ' >  Cv"FFFFFFFFFFFFFF : Cx"FFFFFFFFFFFFFF ? A @ B C Cw"IIIIIIIIIIIIII Jz M# V{ }D.lz44444 !"#$%&'() * W !V| !}"W #W~ #}$W %V! %} ' )C")IIIIIIIIIIIIII   4>@A   7b(b(,,,ggD&J L FStX  dMbP?_*+%MNHP CLJ 3800-1pC 4dXXA4DINU"4<I7`A<IUPHdLetter o [none] [none]Arial4Pd?DAVID WHITE<Automatic>dMicrosoft Office Excel.l EXCEL.EXEC:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE"dXX??U} I} $ } I} $ h      B& C"Z@`@@d@@h@@l@@p@@t@@x@@|@@@@@@@@@@@@@ @ A JX M# > QR L W  "FFFFFFFFFFFFFF M O P  " FFFFFFFFFFFFFF R Q  "FFFFFFFFFFFFFF N V  "FFFFFFFFFFFFFF JS M# S U T  "FFFFFFFFFFFFFF>0z *&&&&&>@A 7b(b(,,,ggD&B Oh+'0HP\h Jill CaulfieldMicrosoft Excel@:li@ ;՜.+,0< PXd lt|  P&L CashflowBalance sheet Market dataP&L-SensitivityCashflow-SensitivityBalance sheet-Sensitivity  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FgŦFWorkbookYSummaryInformation(DocumentSummaryInformation8