ࡱ> N tM  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLVkPQRSTUW_XYZ[\]^jqabcdefghilmnopsvwxyz{|}~Root Entry FmJ0!zO@Workbookh_VBA_PROJECT_CUR"f<Po'0Z*VBAe`'p :* F\pBLUEtaker Ba=H ThisWorkbook,=;<@"1Arial1Arial1Arial1Arial1Arial1$ Stone Sans1Arial1 Arial1 Arial1 Arial1$Arial1 Arial1 Arial1Arial1 Times1 Arial""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- d\ mmm\ yy #,##0.000000083_-""#,##0_-;[Red]_-""\(#,##0\)_-;_-"""0"_-;_-@_-.)""#,##0.000,," m";\(""#,##0.000,," m"\)72_-""#,##0,"m";\-""#,##0,"m";_-""* "-"??_-;_-@_- ""#,##0(##,##0.0,_);[Red]\(#,##0.0,\);\-_0_) 0.0% 0.00" MW" 0.00" p/kWh"$""#,##0," k";\(""#,##0," k"\).)_-* #,##0_-;\-* #,##0_-;_-* "-"??_-;_-@_- 0.000[$-809]dd\ mmmm\ yyyy[$-809]d\ mmmm\ yyyy;@ dd/mm/yy;@[$-809]dd\ mmmm\ yyyy;@[$-409]mmmm\ d\,\ yyyy;@ #,##0.0 0.0000""#,##0;[Red]""#,##0#,##0_ ;[Red]\-#,##0\  0.0000% ""#,##0.000.0 0.0,_);[Red]\(0.0,\);\-_0_) ""#,##0.0000 0.000% #,##0.0000 ""#,##0.0"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\) yyyy""#,##0.0;[Red]""#,##0.0 #,##0_ ;[Red]\(#,##0\);\-\ .)* _(#,##0_);* \(#,##0\);* _("-"_);* _(@_)#,##0;\(#,##0\) #,##0.000 ""#,##0.000                + ) , *       #   "X  @ "P !P  H  `  D  H  a H   H  H  H   H  Currency m  Operis date Operis moneyOperis percent Operis pounds Title 3` qCOVER,V-AccountingTreatmentFees: +ADSCRTargetForwardMin< ,ADSCRTargetHistoricMin<!/BankDebtfundingPercentage: * BankfeesCashflow;e+ Bankfeesfinancing;e+BaseDateForIndexation:* BidCostsCashflow; e+ BidCostsFinancing; e' Capexcashflow; e( CapexFinancing;e& Cash_at_bank; d1 CashflowBeforeFinancing;e# CashGenerated:5 CashGeneratedBeforeInterest;e'ConcessionEndDate:%ConcessionYears:)ConstructionEndDate: +ConstructionStartDate: (CorporationTaxRate:! CURRENTDATE:  DSRA=""e# DSRAActivated<&DSRATargetMonths< -EquityFundingPercentage:  EXPIRYDATE: -FinanceDebtorAccounting</FinanceDebtorInterestRate<1FinanceDebtorQualifyingIBAs<2FinanceDebtorQualifyingPandM<6 FinanceDebtorQualifyingPandMLong<1GeneralInflationPerAnnumRPI:2IBACapitalAllowancesPhaseOut: % IDCCashflow;e& IDCFinancing;e+IndustrialBuildingsCA: * InterestCashflow;e+ InterestFinancing;e'InterestOverdraft:2InterestOverdraftSensitivity: (InterestReceivable:3InterestReceivableSensitivity: % IRRSandNPVS; "' LendersRatios;W0 LifecycleCostsCashflow= e1 LifecycleCostsFinancing;e# LLCRTargetMin<")MinimumForwardADSCR:**MinimumHistoricADSCR:/MinimumLoanLifeCoverRatio:?2MinimumProjectLifeCoverRatio:T$ModelStartDate: MRA=##e" MRAActivated< %MRATargetMonths<(OpeningBalanceCash:1 OpeningBalanceCashRange;e0 OperatingCostsCashflow; e1 OperatingCostsFinancing; e)OperationsStartDate: " PayablesDays:"7!PlantandMachineryCapitalAllowance:# PLCRTargetMin<#) ProjectCashFlow;66e)ProjectDiscountRate:! PROJECTNAME:%ReceivablesDays: # ResidualValue<$ RPIIndices; $%e$RPISensitivity: , SeniorDebtInterest;3SeniorDebtInterestSensitivity: 0SeniorDebtRepaymentProfile:2SeniorDebtRepaymentTermYears:$SeniorDebtSize<!(SENSITIVITY_NUMBER: :$SubbordinatedDebtRepaymentTermsYears<(.SubDebtFundingPercentage< %SubDebtInterest<+0SubDebtInterestSensitivity: 6 SubordinatedDebtRepaymentProfile<'(TargetEquityReturn< #,TargetIRRUnitaryCharge< % TaxCashflow;e& TaxFinancing;e/ UnitaryChargeCashflow; e0 UnitaryChargeFinancing; e-UnitaryChargeIndexation<*UnitaryChargeIndexed< . UnitaryChargeProfile= 79I,UnitaryChargeRealTerms< VAT:% VATcashflow;e& VATFinancing;e0 WorkingCapitalCashflow; e1 WorkingCapitalFinancing; eT O(E yS0rV5bv.cT$ 4 Q&@uIRmICu^hmIIFAICu^hmJFIFddPhotoshop 3.08BIMCaption x8BIM Print InfoxHH +7G{HH(d'`8BIM Resolutiondd8BIM FX Global Lighting Angle8BIMFX Global Altitude8BIM Print Flags 8BIM Copyright Flag8BIM'Japanese Print Flags 8BIMColor Halftone SettingsH/fflff/ff2Z5-8BIMColor Transfer Settingsp8BIMGuides@@8BIM URL overrides8BIMSlicesqooption 3o8BIMLayer ID Generator Base8BIM New Windows Thumbnail ypUPo ]JFIFHHAdobed            Up"?   3!1AQa"q2B#$Rb34rC%Scs5&DTdE£t6UeuF'Vfv7GWgw5!1AQaq"2B#R3$brCScs4%&5DTdEU6teuFVfv'7GWgw ?TI%)$IJI%+\29thʾmB Vέ=Cq}^c"̌]N6Ms'].ݧs]]ڽ540NP3VK,c*}SNEdRncl^I$I$TI%)2t)b츯/翧tq2)lUOCeξG>?BRDχeT}C zwPt's^UnwW _J)|qNǖf"wޟ:IU0ftXlM99juߤ_UV7I3,JOLnˬӶ]3ӫo]~UQӺK-vnU o7?׳W_gVfΘ>a#E1w챖 I?.Y=@ |__3d."t?beQ[zf=MUV3+{].\N^fts>WV}}*׈4"C$})}?פu _ZMXYXK7K^Ör[y_cj;{:dÌI%?TI%)$$oX=#ں%yMMEۻӱ-f6?޴R%>I3,y_Wf/K5cT65ju5^wK\6fV õ͔^Ȗ6[_jEg׷gcdUL_Sv쯝5]W0uv⊽:}.^=GSj,# h߉xg`}O}VnjȮ0Kqs^g}'6F$S2"%#.Lt'IOTI%,tݔG,^-"x}&{+f]u r=Nz&8s7gџzE;e33)h/L~tË`~r+x<}/}1UK/1Kۭ52>]GY~則ҳŭ10zXǐ ~ůQW%BZjXjZVwRdQz$[:puy4? 0ߋm6ҽb}lenjV̌l7ݒJ[IfOaӦ.[륕]CScUh-p˳kk+̟J~թիɧ'/=)vm{gMGi7wjb=*]GڶvKy}X\'}ֺWޝc57{N˿B}{=V6?veՍS'U72HZ\_bmOȻ&Imk@s/ۿ}o=6^Z**)6Vu[k_m{_W_K zY9=.{nc37_'O]-'/"WYOW]e=?RċwL.TI%0/>x\?^˿?>ב+?|o+ۭD:Fs}kV[-uvlo`˻mmTicY_:oK3##"sEՐO߳ Q}57쮝N?eF$4R}sw>z,}4zQvQ̥E]&}v#)n7Mޣu? M:ܝ1ʣ?*!f;ʯ^%bё麇K!rd#8d66yTݏEuGf5o쾿Gg‹.uZq]qk陖lc+>"rp_l]d5OJ띒X7C`cCu`sW?W2[ϲ.:QfiWCrQ}~?D_uÇV9oE?W58 5躻YVV%U;}/Z[M벿}5Elαv"&[KeWzgz5938o9N皭UczOH27=ţ#T"?H>eEz!㹕/쿪Rr=ܫI7Qk|Ɩq{0̇SfٕcWUWzz+qf}\}34z#]Vś8o{,-c[]Uz5Cv@5Occ߃{_}MC?}T+ Mo/s̋]kz5u,J?=00NTʩ$;(va$Uzq~'/A_zsO';#X t*?S6cN8Oӏ//E/$/AI/RIO8BIM!Version compatibility infoUAdobe PhotoshopAdobe Photoshop 6.08BIM JPEG Quality8ICC_PROFILE(ADBEmntrRGB XYZ acspAPPLnone-ADBE cprt2desc0dwtptbkptrTRCgTRCbTRCrXYZgXYZbXYZtextCopyright 1999 Adobe Systems Incorporateddesc Apple RGBXYZ QXYZ curvcurvcurvXYZ yARXYZ V/XYZ &"pAdobed@o     u!"1A2# QBa$3Rqb%C&4r 5'S6DTsEF7Gc(UVWdte)8fu*9:HIJXYZghijvwxyzm!1"AQ2aqB#Rb3 $Cr4%ScD&5T6Ed' sFtUeuV7)(GWf8vgwHXhx9IYiy*:JZjz ?ߺ^׽u~{ߺ^׽^׺?^q׺?O~z￯~w{{^׺u{{^׺ߺ^׽u~{ߺ^ /{b_4]Yx稵MSY@LyyTkjuiQWʾ}V6~ ^ߥ=ߛ⦒6>ĭ߰uL6,/WI"<]sW-㚷H6IP,HT׀m݂ut?HR*c@X-bo+:ȁw/OU Ev\b7mM%~lZ0h!P 3MDZm0stBi4$q8zuPKx, ;>F W̎_=Usgxtoα߸ۛ'f4U lTL6e)Ⴓ] ԕqGQ_p&צq*A5O,ܭkG< 2GCDNZ_7@>&IWJ)#4JZk}>ޟ>Kiz_{^׺u{{^ߺ^׽u~{މ׽uaxm`O'ǽ`OWC=AiBV%$y! PJȪ[y>BjN9F<.^Foۓd^ힺO֔CbC6Ato̅ ]t` B>(9y.c_r[*|IQ+z{q$&pÇlgԝ@BZiZґ6ti%Dxuy Q$T"QЫT/gK[[ϕI jPۭi5TF ֠GF`o.VT<`n&{fQE S݉kJ?I÷$)3[1Ō81<{MD 6sBGi#Oש# J "MddRas'9-n.:-78d5L5|>};u( {{PB#>]9(~.{V׺u{{^׺ߺ^׽u~qoNn]~xf^F6Qk V$j+pqkov$%uӀ(PD_.vJڹq[Klb6;}f>vbe!Z3Uj*Zܯ6HibHݿ46[+jObkvk}~A p4DžXK^N6HB !TRz:$Ut:w%ufD֊_*z}ػ ܘͱ_Fˁ4 c}:)1GSGF&Zϯy=m IJ;t,LjK5?r!/𴊯HGya'2tiT_\_3 v<|ޘܦiR2UL x]p`+$k uuww[kKpJ&dS"ǟYoy`ǗߦNj;c,%4:ihjFt?wuȮԛzxbNOMy*7VST45Pe"ȫ Vn& )O":0G1r&5Z2@skQRT!*WK.KFRA=S׽u~{ߺ^ߺ^׽u~qo}NqYnPŀX= yQY<՘N-bd?Gkd2{i*#%.*q;{~L*HTY EV*: Ys>"kgyfDŽi=i@|@=E|L-B4D,;AˤSD NXI [NjXCYP,^?{,~,_JjgP2gI>!ˍ 14Z_OTve4οdNUNٓ}ӆS,JcRc"U=-Dܿ"Ɖdi$%I҄t8䍵lR'Ou}>Jqt~_Uv6z0ܔٽ*^+-=^{ AvEc5!2DJ w[-Ԉmj&<qC+@ro>i۷; OE(JАU/H]r+|ܼͫeFW 'diU z:tNH>"n{VWe ;O 铑}>ljT[Evؙi&\8^/'MLl,ءjrTQUATŔ|^[w3&:4(sP=) ~r>{cdm"–&O 7xuYK0 ߅(ؼ:=w{{^׺u{ߺ^׽u~t@"K u4Js#{$..[d v~mǷsV3xjzvN2s1o|3q|*#IY@*4=jC#(MuPzTj7ٻ f{O|a29ݛ[q͚W)kh,5 Mybhm$j  à ݍųc ['84`@ դT :܋F P;Wlo'䢧\Y2Sjw;I %ED9bs,<}2d'Hw9SoSjbN49$S}~hcßvpK{l6EMNZ|+jbЎ mDW xOLJg"bAȥ[]x#SC NT< \OdM~_ϩ KwA}khD1 GG.:r㷋QO^{~{ߺ^׽u~ߺ^׽NӞX>{ҳ(OϪqnj=ʔ>W[oǺ9d1?o:p 5<2*eu7 ᔋ>:,~ }kNFd 5>w.ڻ۷oFt3?sXc)z*yEVYQ*nW3mr$l {YI9?0H#u#K{ R_*yqol׬7u%g 66q#ʫźI])*kt97mH95e05 0A#nV]Epk_R8S2H՞OA4(,[?S{ɢI~f<BѣA EOYƭpcG$A>_Iol]V޽au6^l[O\c犕t>G??k߄ ׀NG].o׀=Xuݺ]^׺ߺ^׉'ߺX'V6!spIῆiDJs|\r+z3o_2|޽y?m\⨫` Wp`%ژ*k&42Wc*-6 j?Op doW97>ܽ[[#sSڹ[A}]w~ '#TW楫Q }R"ExW8k询xZ?$zҿS|]_ѽ[/6\{˳x|N]Ij2*.{UڂDj8~<}|xh?;1.N#lx˸3;#nu{r}z{swqFZ\uFJ 4_TʑZRP$tܛi9lzuϧ~nw~ؘߐ!Uf1=Sښ,}=|So轝ҿy];ȱmS@<2uq8SǦ4?o؝:1.}7 bXm8d?Y|]^j$Y nu >2qkOTgG2>nؽ z3&7 8m4dchs0%e YaR X+R[&].(~}<+t^'fڟ7o(G.woߑSv_tSVmYvKAW84f.قt"-:Bˣ ;clջ ufnոe2m׀؛Ǵ3XMYKl&Y:j+(xaJaJֺuߺ^Loߺ45=%Bj`zN0 ؿgRo7/ܙKqUO'eb3tqN=2FIKtkH; Bkr7ǁzݥwQl7b|TꭥGM{FЦ"mD@sT3r-yr8q\1+@-RPzdtˤ3A}6 _^,ߡT!Gx{Q"'hA0_ZWץr mɸ5<ϧX?XR0k-*fbD'9U FX} yv~,,FJqsKdN3=qfy?ǿ#qP{+wυۡ7ԕ4k>6vڪЮrT瀄l&AcO_G -b&>o1b_ _Zd:\ۓ{lEln]sLdUVi+3~$h]OtLZNv.Z :W:-屺cYh2Q#j dSM,09 MUxfeNӧ"o4@!MA+4@J//:w?ޚѻ{.wOOn]ߝU/6Ghaf|VmLE. pi%j 3ŭܛdE*T@$T 9>Xh֔O[/N]A 6Gi5'ǜ~ԭ]oCVee6>݃xaVgƒKIu+\ 6&438)C:N>vgun#W5Sil,^p.lͷ9=ӿ7~v =y|k+_ie jJX!F-_Y!E,\ʸ&QPLrL$A}s>^'m-9Ncg<nRڪvT;)J%CK"YHfKKIAcQZPjA*NkLd.öjy@^~?|xZs;;nd(٭a*af6%m]U>>j#(jLF\m% PqB)ջ[m.Pߟ^?5~0G@?L\`:|v?eh6|>9rY)TgjYt2ֻn7BJ(mM)oԿNxjqgX7ꝯvv۹]Ǵ3|n> &G%x*(ڏ)?ݼs[@S]ϙ#fߧHByPqMvfSX|~u4垚7e?/DĠ;KlǸ2=5꛰;k~mdd趟rcsQ)A١FT6۽NU&'ƕǠ" tVr nOQ8`|ted%;3OeNī=Q~mf؝-_0VE_%#M<0c{v)V=5)A@On3Ǥaٶth~t _ߍC9 > uCdrDIi5}T# w7*VYhBf4%_O #/yp?(@k_.۽k{^ߺ^)k?ޡވ(EGWJkZ~U7NBH2/$ [ߟo]OՎ.nSm%d#TCr(G `5~"Mꍱ= bJ^ة~Tdnv:Jf{=rMFkzv9&duc PҠҿ>GnZir#qk++owfrUY+avL윕+gK_xZySHK[o9JGe`j& okv{fx-]KU<3El2#3J JML (T_lv_ɫ;.R|\oco*{ lTSn^$mH)Ϋq4{T?Qֲ<_V3 `AnIn8R(s RWJNL`}{9=8? {337ĉF'>(|tlO[_1~L|`=vٳKJrT3S%5ULR{w :yPkcZUR/r"w{qt~$2,tU' -jQu}'GJN-Q6kt3`vF; ;!{7_۽wvI)w=.b|Ab{Guyq%2,LMà]@3piJW6%}ۯWk][ i-_|v'oTv_~h:büGhda8+5?޸^l\OUS+X"qaImg&!:UT#+\{{ܸ[&x]IlҬ~[|LȾGvUɁ[{Ad*SKͫr7^N&U MtMM' ۻI+54UsOVn?OV.܊S=s׽uߺ^ZK?97dҿ]iWa}28O=Y(N#3ꪆ/MTSBy\y~,\Yg|Mμ=1׶+lٵ}^ `@kGsn?=ܘo]Ɉݩ{#ڏpmzLcls7:= VJ=kPBlSh8Z*T`P|ΪR׻_:lqB۹k'4eRь甃etU!Eed+}DxMQ 5S#T@5|OώM|o\҇o6[aN%<4Q@Q` Sr'n;pRvɈ~K 5!6QB|,v vk5WɁi maI#) CnsᰦK|- ܟmn;~1p[cv6<`6&ȎLvܛk)Y ̤8ǥx2YO3K4ƒ0yE|Ѽ*yϗ}e_ov ׭ju7k\d&OӣS@p WK]wr&'4lߌlz)v~6Lv[l1Gi57 j[i4 xQL v姎z%=6F[닢u]C+`Aa>Wu 7U|콕G`n>u~lY8؜Ԥܣ%G e) 'jY%L|%5 իJj>}n>Zo^_l:B6B$[qA*Ot|j{ẏpnȤl% J,uT#/tsMYu$1'q2i?ns0זfpPbe\G bT {E# v/a|WOrN^&]q}TPTi`ۑӍ͘c+FU>/ $ Pwl!4=?g>Ε{g OFo.߸}U.z~ ݕw p{E7դJiU5JD$_E~j֏׫~q?gId?k]vIuno!=jn:<;rgN;Snc$lj#ʹ"(U'm펝xߺ^ߺ^ 2!n/sa{sqPqǦX6YH\S?oX!xAzlA%Ӭj_A0F2j-82!YQZQJ_^}vDITe|z__^}Bnxgt?Z-|Ѫ{xuZcYEaku~3 A@@  ? DisclaimerXmade in relation to it. No responsibility is taken or accepted by MS for the accuracy of excluded.www.modellingsolutions.co.uk+Copyright Modelling Solutions Limited 2008FINANCIAL MODELLING BEST PRACTICE EXCEL ADD INKIt has not been audited and recipients should use their own due dilligence.FNo representation , warranty or undertaking (expressed or implied) is ]the softwareor the assumptions on which it is based and all liability therefore is expressly EThis Add In has been prepared by Modelling Solutions Limited ("MS") .o pRcc@ F (Gy}~AɇQِ  dMbP?_*+%MzCanon iP90 ߁ 4dA4BJDM 0Rt,T`Op,T`OpRt,TT`Op,TT,TT`OpXX' d Rt Rt@, Rt Canon iP90 ߁ 4dA4+." UXX??U}  } $                                  (   !!  " ! !  !   !! # # # #! #!  ' #  &  $$ # # # # ) # #    #  #  #  #  # #Dl   ( &* ! " # $ % & ' ( ) * + , - . / 0123456789:;<=>? # $ $$$ !# !% !$$$ "# ## $# %# &## '## (## )## *## +## ,## -## .## /## 0## 1## 2## 3## 4## 5## 6## 7## 8## 9## :## ;## <## =## >## ?##D|l,,@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @## A## B## C## D## E## F## G## H## I## J## K## L## M## N## O## P## Q## R## S## T## U## V## W## X## Y## Z## [## \## ]## ^## _##D@l`abcdefghijklmnopqrstuvwxyz{|}~ `## a## b## c## d## e## f## g## h## i## j## k## l## m## n## o## p## q## r## s## t## u## v## w## x## y## z## {## |## }## ~## ##D@l ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## ##D@l ## ## ## ## ## ## ## ## ## ## ## ##(  ^  C $A mime P  p]&`)>@7!!yK www.modellingsolutions.co.ukyK bhttp://www.modellingsolutions.co.uk/yX;H,]ą'c Sheet1ggD ThisWorkbook,2Module18 Module5Module16&  !"#$%'()*+,-./023456789:;=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghiklmnopqrstvwxyz{|}~?#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}X(%8HSndIxAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2$+xMESndIx$Attribute VB_Name = "Module18" $+GnxMESndIx"Attribute VB_Name = "Module5" $+a xMESndIx$Attribute VB_Name = "Module16" $+ xMEModule6 1Module8<s Module17`mModule7jSndIx"Attribute VB_Name = "Module6"  ( G |xME<<(<,<< <<<<< <$<0<4<8<<< hD) tX:D 8`8D9 t-Ap (%hPth8` , x @d h` @P @@ (X0  @  @@ (O @ @  H0(x @d @T @D @ @< 8O de X@P@x @d @T X8`D)) `@D @ @< `H8O $0( @ @ @ %@ @ @ @ @ @ @ @x @h  @SndI  `"Attribute VB_Name = "Module8" $+xMESndIx"Attribute VB_Name = "Module7" D$+:xModule9uModule11Module10Module19(?IxME< <$<<< <<<<<(<,<0<4<8<<<(0p(D&&@(h >8`D$$'@@h ȁ B8`D%%K@Dh J8`D$$p@Lh ! R8`D$$@Th 0' X8`DBB@(h Gep `X h% @``.ppp@PpHx `@X T @@D p`@4 PHX$  ``@ ` ``@ @ @ (  .A Ph . x @X ͂T @D @4 $  @  @F @N @2 I@ @H @P H( @Zt @d @T @D  4 h@$ P@ @ @ @ @ X@ @ 0 H x x. `x @X 0 T @D @4 ` X$ Hx  @   @ @ X@ @ ( @ @ @ (    0 `.Hx @X T @D @4 h X$   @  @ @ @ (   (@p8 .x @X T @D @4 0$  @  @F @N @2 @ @H @P ( @Zt @d @T @D 4 @$ @ @ @ @ @ @ @  @SndI0$Attribute VB_Name = "Module17" MESndIx"Attribute VB_Name = "Module9" $+xMESndIx$Attribute VB_Name = "Module11" $+7xMESndIx$Attribute VB_Name = "Module10" $+~xMESndIx$Attribute VB_Name = "Module19" rU~|  -Y q !Iq Y9IUU q9y1i)Y> # # $ X$ DK Module1uG__SRP_2:6 __SRP_3Sheet19~63c7ff$*\Rffff*764963c7dc*\R3*#30*\R3*#4f*\R3*#4d*\R3*#8c*\R1*#5a*\R1*#ce*\R1*#df*\R1*#285" "( Z0 , Z  "  %0@HPp"*x77 $= Zx  Z X@  X   `8  . ` @  X .HX  .  .@  .0 ( .0`r B[ << <<<<< <$<(<,<0<4<8""""LLLLH+% hH`@|o j`,oYY pt px%`xn zp% ` |kp`l@HXj0  X` |kx ` |kt$n 8% `|J|@x @\ @`|J@X @T H `|J  `|J @D @4   `X |k 8 `x0@$ @ ` 6`^P`@0 @H @ @ @` x@( #@P`@# 8 f %@x h((@`8P(@ x-@`-@ 2 @@|`02@@hl X7 @h`@7@X h<@T`8<@ D A@0 @` A@0 H  F@,`0 F @t  @h  @ @  h} t @d H(` pP @@ @0 8H  `p  H`DE8 !0 4` $ 02@ `Xsh  `t IR ADS `  0`HX p`x p !4 !x @h (. !pd @T @D @4 !$ `H !., !x @h @X @H @8 `4 @ !$ X,.@x @h @d (" T @D @4   !$ @ @ @ !( @  !H,. !0x @h 0d @T X@D @4 @ !$ @ @ @  !( @  !H,. !0x @h  d @T @D @4 ` !$ @ @ @ 0 !( @  !H,. !0x @h d @T @D @4 b !$ @ @ @  !( @  !H,. !0x @h d @T @D @4  !$ @ @ H@  !( @ x ("H,.("0x @h  d @T @D @4 ("$ @ @ @ ("( @ ("!("X !("@x @h ("d 0*"('X('@x @h ('d #0*X0*@x @h 0*d 0*$('X('@x @h ('d ('%('X'('@x @h ('d &0*X0*@x @h 0*d 0*'+X0*P+@x te@h d+d (+Xvision+@x @h +d )+X+@x @h +d *+Xn (n(+@x (@h (+d (++(+ PSndI$*\Rffff*0K49646eca*\R3*#4e*\R3*#50$*\Rffff*794963c82e$*\Rffff*784963c823$*\Rffff*7749 H .`  .x   . @ (  6P @ 6 ^ ( ^0  " 6  " F F( Fp  "*    1   "h 0 X "H  P ` "p   x "    "    "    "    "0   8 h A@joHS=================================================================================== PROCE%THIS PROCEDURE LOADS UP THE MENU BARS====S=================================================================================== $(&l n $(l]]]&1 Scope9]8Worksheet Menu Bar$.pp%Help p%!'x p%Window p%!'x &2 Specify9p!ShowTest9 l x p!%.zx&4 Build9 &3 Design9(o &5 Document9S===================================================================================XS=========================================================================================R================================================================================== MODEL INPUTS======R================================================================================== z/A Best Practice Approach To Financial Modelling9 l5%np l5%s l5%YIqqX  l5% I&6 Test9qq  l5% &7 Implement9s9q  l5%q`  l5%==q /=================================================/===============================================%qX========================================================================================X======================================================================================== $(&======0Application.Calculation = xlCalculationAutomaticteo?===============================================================?THIS ROUTINE REMOVES THE MENUS BARS WHEN THE WORKBOOK IS CLOSED?================================================================= V 'VFMBP p%B@ VI + 1o8p5(JJ K0KPK6 HEND OF MENU BARS_&FMBP9B@P  ShowScope9odu ShowSpecify9? ShowDesign90x4 ShowBuild9 Sh ShowDocument9 ShowImplement92 B@  B@o o B@ SXo B@o B@@oh B@le2oH B@dul0  l5%o ShowAbout9q@ &About this add in9Module B@dul ]0Worksheet Menu Bar$.pommand'V V V ume Neh   l5%q RemoveAddIn9&Remove this add in9 [Attribute VB_Name = "Module1" Sub Auto_Open() On Error ResuNext LoadMenus End j x2 x'=O 'THIS PROCEDURE LOADS UP THE MENU 0BARS'R} Application.Scre enUpdngAFalseC`alculxlManual Dim cbWSbar As CommandBarmuC@ustom1 C ontro!iHelpIndexIntegeiWindowQxSet $=#s("Workshe A, )":=I.)(").! % . C .Add(Type:=mso Popup, Befor+/'N%A0 MODEL INPUTh}With f8 .Capjd"&FMBP`.TooltipT@A7st Practice proach To Finan cial `elling  OBButton @jAbout this add inOnA@onShow?a! &?/1 Scope  ]32 Specxify2 F  &3 Desig'&? ? &4 Buxildq & 5 DocntQ h &6 Tb_ I STru'9QmcqHa?O BROUTINE REMOVESS" WHEN2WORKBOOK CLOSED?_\ If0 FkpI!n1+ 1Af("s).Delet  I=ϒe1m.a aq ^RZ$XRqN??9r $ |" x$ x x% x$ x $xK*X:\%x$ dx HQXtx7TX:\%xt x , X lTpn)xX7TX:\ %xt x , X lTpl)xX=X'%knDD%'$%'4%\ %xt x $ QXpx lp      .\%Wq5:\%lC:\%lC q.\%Wq5:\%lC:\%lC q.\%Wq5:\%lC:\%lC q.\%Wq5:\%lC:\%lC q.\%Wq|5:\%l|C:\%l|C q|.\%Wllqh5:\%lhC:\%lhC qh.\%WXXqT5:\%lTC:\ %lTC qT.\%WDDq@5:\!%l@C:\"%l@C q@.\%W00q,5:\#%l,C:\$%l,C q,c" x$ x xP|T< lXD0tp xX0   H'$(X$ H)$*$ H+$,$ 0 X  0   0 @  0   H%$&[$   9rU $`$`$`$`$!`$I`$q`$`$`$ `$ `n<jxL#<uBcIPa3g] Fx@NC>8;xx@NC>8;uBcIPa3g]ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%` %V %`h8@<<0SndI$*\Rffff*2849639eff4xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU yQ4`rU @n__SRP_6 $__SRP_7BModule22 mModule3 ?4xMEP<<<<< <<<8`0%`x@ggo recorded 24/12/2007 by WhittakerP$M x @h mpfid @T @D iV@4 ls@$ S@ S@ S@ SSndI(P``x $Attribute VB_Name = "Module22"  (  $      !"#$%&'(*+,-./012356789:;<=>@ABCDEFGHIKLMNOPQRSTVWXYZ[\]^_`abcdefhijklmnopqrstuvwxyz{|~xME<0<4<<< <<<<< <$<(<,<8<<<``X@h@P(o recorded 22/08/2007 by WHITT1D 68`@P(o recorded 22/08/2007 by WHITT1D 88` H@2@o recorded 22/08/2007 by WHITT1DpCapi:%H,.Ix yj@h P1d %(@T m$@D N]@4 @$ 1@ @ @ @x,.Bx @h xd @T (D @4 @0  ,_ `  @ @ @ @ @ P,.x @h d @T @D i@4 @$ @ @ @ pSndIP"Attribute VB_Name = "Module3" $+nxMEModule12 )Module134Module14?Module15JSndIx$Attribute VB_Name = "Module12" $+xMESndIx$Attribute VB_Name = "Module13" $+jxMESndIx$Attribute VB_Name = "Module14" $+xMESndIx$Attribute VB_Name = "Module15" OxModule2U{Module4gSModule21}UModule20}MEP<<<<< <<<ph@hx@ 0o recorded 22/08/2007 by WHITT1D2%H(468x ENxSndI8"Attribute VB_Name = "Module2" '*xMEP<<<<< <<<`hD  xX BA N8`  `(D%@@L @t @p @l 8hO H l~SndI"Attribute VB_Name = "Module4" 'v xMEP<<<<< <<<8`0%`x@o recorded 22/12/2007 by WhittakerPPB$Hx >@h d f@T @D @4 6@$ ``@ @ @ p@SndIh$Attribute VB_Name = "Module21" |(ORxME<0<4<<< <<<<< <$<(<,<8<<<80%p,. x (x&(o recorded 16/12/2007 by Whittakerčpxh h(d P@T @D @4  8`x@{{p8p@$ @ @ `X` HP pSndI(x0P0Xx ;U(\ @ $Attribute VB_Name = "Module20" -lwF2E`Ot\>hnmfeoIgD[jh9(وCqxhScopeForm1#__SRP_8"__SRP_9BSpecifyForm&9(وCqwF2EMEPSPSSS6"<<<0{867EBBF0-3DB7-484F-94D8-33C8C13B7F4E}{C5E60891-D578-4E7E-A38A-48B2E9FF4836}h0(%X0 %80ei f% %i i i MHi p0p`SndI$*\Rffff*774963c7ff 48<@DHLPTX\`dxAttribute VB_Name = "ScopeForm" " Bas0{867EBBF0-3DB7-484F-94D8-33C8C13B7F4E}{C5E60891-D578-4E7E -A38A^B2E9FF4836} dGlobal!SpacoFalse CreatablPre declaIdTru BExpose0TemplateDerivCustomizDrU # iA4)8<@YDYZHY`LgPgTgXg\g`cd  i`rU pndTϖm@n-H ]roE@pnTyGESM8;Mjex8;Mjeϖm@n-MEPSPSSS6"<<<0{523BC8B8-17C6-444F-8746-1A6FB397D763}{38AC78BC-1098-43BD-B092-03CD64B05015}0(%X0 %%%00hX`SndI$*\Rffff*784963c82348<@DHLxAttribute VB_Name = "SpecifyForm" Bas0{523BC8B8-17C6-444F-8746-1A6FB397D763}{38AC78BC-1098-43BD-B092-03CD64B0 5015} dGlobalSpacoFalse CreatablPredeclaIdTru BExpose0Templat@eDerivCustomizDrU $٠)4__SRP_a!'__SRP_bBDesignForm__SRP_c%*      !"#$%&')+,-./0123456789:;<=>?@ABCDEGHIJKLMNOPQRSTUVXZ[\]^_`abcdefghijklmnopqrtuvwxyz{|}~8Y<YZ@Y`D  H)Lc`rU XnHv(T/?ȭF.co-$+LH :o4٦]K+7ZNyI[*xyI[*/?ȭF.coMEPSPSSS6"<<<0{7741A8F5-96EA-4397-97D5-8A10E60D030F}{A0D344D2-4F38-423A-9311-2C56D8B8119A}80(%X0 %%%8ei Zh0pXhSndI$*\Rffff*794963c82e48<@DHLxAttribute VB_Name = "DesignForm"D Bas0{7741A8F5-96EA-4397-97D5-8A10E60D030F}{A0D344D2-4F38-423A-9311-2C56D8B8119A} dGlobalSpacAoFalse CreatablPredeclaIdTru BExpose0Template DerivCu@stomizDrU H$!Iqѡ48Y<YZ@Y`D ) H)Lc`__SRP_d(BBuildForm5*__SRP_e(+F__SRP_fWBrU XnlKTd>w ؑncHHe$,` hDN5LAJoj(FUԥiuBLnxuBLn>w ؑncHHe$,`MEPSPSSS6"<<<0{8697E581-DBC9-4925-8C7D-69660FAA073B}{28D4729A-CE2F-4839-A9DA-94FAF6F24B20}0(%X0 %%%8ei ehi i -i X0phhSndI$*\Rffff*7:4963c860 48<@DHLPTX\ xAttribute VB_Name = "BuildForm" " Bas0{8697E581-DBC9-4925-8C7D-69660FAA073B}{28D4729A-CE2F-4839-A9DA-94FAF6F24B20} dGlobalSpaco False Cr@eatablPredeclaDIdTru BE`xpose0TemplateDerivCus tomizDrU $ Ai4Y8YZ<Y`@gDgHgLgP)TX I \g`rU hnHvX dD礰$$K'ٴu4A# FK7""bXb@K2Sax""bXb@K2SaD礰$$K'MEPSPSSS6"DocumentFormYG__SRP_10/s__SRP_11-0BTestForm8<<<0{CF6F4F74-8C24-42D8-A8E8-4D1D78FC301E}{88911934-AFE1-49A3-B754-821048EFAEA3}80(%X0 %%%8ei eh0phhSndI$*\Rffff*7;4963c88e 48<@DHLPTX\xAttribute VB_Name = "DocumentForm" Bas0{CF6F4F74-8C24-42D8-A8E8-4D1D78FC301E}{88911934-AFE1-49A3-B75h21048EFAEA3} dGlobalSpacAoFalse CreatablPredeclaIdTru BExpose0Template DerivCu@stomizDrU $ ٤a4Y8YZ<Y`@gDgHgLgP)TX i \g`rU hnHvL8M`83IU13k7 I6Ri[=W@N<`EHALxEHAL83IU13MEPSPSSS6"<<<0{3CBF45C4-77FB-4009-A3E8-94C5122E95E2}{7DBEABF9-CE53-4C94-95D8-075D634BC361}80(%X0 %%%8ei Kh0pdhSndI$*\Rffff*7<4963c8b7 48<@DHLPTXxAttribute VB_Name = "TestForm"  Bas|0{3CBF45C4-77FB-4009-A3E8-94C5122E95E2}{7DBEABF9-CE53-4C94-95D8-075D634BC361} dGlobaBlSpacoFalse Cre atablPr@edeclaI"dTru BEx0pose0TemplateDerivCustomizDrU %__SRP_12__SRP_13.4BImplementForm8__SRP_14 ѥ!I4Y8YZ<Y`@  DgHgL)PTgXf`rU dnXPBHDn{OgSp MIJ( U?< 진Aߴy>H'2wxy>H'2wBHDn{OMEPSPSSS6"<<<0{F4687926-8F54-4E15-AC2F-F84BBE51B7BE}{A0CEAEBB-8E63-453D-8651-BBA890999EFF}0(%X0 %% %0pThSndI$*\Rffff*7=4963c90cH8<@D4xAttribute VB_Name = "ImplementFo rm" Bas0{F4687926-8F54-4E15-AC2F-F84BBE51B7BE}{A0CEAEBB-8E63-453D-8651-BBA890999EFF} d@GlobalSpacoFalse CreatablPredeHclaIdTru BExpos&e0Teat@eDerivCustomizDrU H%Ai4YZ8)<@DYH  b`rU Tnx[sT@lJT=+- HN̒rP9xzK}kk4|ј#C6x4__SRP_153)BAboutFormd__SRP_47__SRP_5B|ј#C6@lJT=+-MEPSPSSS6"<<<0{57D0389A-E115-4227-8ECF-BC22AB868377}{C7B49103-3A29-42EA-9CC1-012E89FC5CFE}0(%X0 %%%08ei rohi ri ce0hX`SndI$*\Rffff*764963c7dc48<@DHLxAttribute VB_Name = "AboutForm" " Bas0{57D0389A-E115-4227-8ECF-BC22AB868377}{C7B49103-3A29JEA-9CC1-012E89FC5CFE} dGlobal!SpacoFalse CreatablPre declaIdTru BExpose0TemplateDerivCustomizDrU p#!Iq48Y<YZ@Y`D  H)Lc`rU Xnĵ0* pHd VBAProject4@j = r SndI J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\syst em32\e2._VBA_PROJECT0dir__SRP_0 ;b__SRP_1GF     . !"#$%&'()*+,-/01234568:;<=?@ABCEFGHIJKLNPQRSUbWXYZ[\]^_`acdegijklnpqrstuvwxyz{|}~signFormx.BuildForm7:4963c860BuildFormKTDocumentForm7;4963c88eDocumentForm ^TestForm7<4963c8b7 TestForm8MRImplementForm7=4963c90c ImplementFormAboutForm764963c7dcAboutForm[s~80Px0`H80H hϔ&Eҙ|NbbqD q`G:awڧ`Oҍ v2k Fț*ZH9j)EԣdEMES%TskL#})Py8EqyAzPkܨQ? D)xRٿ`7 cA:'Mf@|<`vmKwX^Z#ȍwpOO{ccOd$hRPWlKi|2Ś@N&cslw7GIu:3F6v PoM׌`(|m`LW E:C*yޯdN`AB #XMJpTV#X/>@@uO,é(QTY"/wjwSVEO ?]*NAcN0!^L5X$M]z>6({B}˜E6PG%@$1lL n`VIvjzI C'He8{Lٽ9k JIU] x>\Iφ@(F='pߢxrp(rJ Qz%4z9H[7?2""+}6 Gfdp&F13%pw,J*"p )eIEdMH-BI#O AsCEachRFalse^GotobInResumeTrue Excel+ VBAWin16~Win32MacVBA6# VBAProjectstdole`Officeu ThisWorkbook| _Evaluate Module18]Sheet2 Module16[Sheet4Sheet5 Module17\UnitaryChargeOptimisationT Application*ScreenUpdating! CounterAXSheets Range as  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.4#0#C:\Program Files\Microsoft Office\Office10\EXCEL.EXE#Microsoft Excel 10.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.2#0#C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL#Microsoft Office 11.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{F4265428-BD3E-4124-9EF0-6373105FD0BD}#2.0#0#C:\Users\CHELSE~1\AppData\Local\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M   SndI   ThisWorkbook1W49639daaThisWorkbookEModule181X49639daaModule18Module51Y49639daaRModule5GnModule161Z49639daaModule16a HModule61[49639daaTModule6 Module81]49639daaModule8|M Module171^49639daa Module17IEModule71_49639daaZModule7Module91`49639daaModule9:Module111a49639daaModule11Module101b49639daaModule107Module191c49639daa*Module19~Module10K49646ecafModule1C80`x @C Sheet12849639effW Sheet1LModule221f49639daaModule224EModule31g49639daa:Module3$h Module121h49639daaModule12n0Module131i49639daaModule13HModule141j49639daa,Module14jModule151k49639daa0Module158Module21l49639daa2Module2PUModule41m49639daaDModule4*-Module211n49639daaModule21v -Module201o49639daaModule20RUScopeForm774963c7ffScopeForm-0 SpecifyForm784963c823SpecifyForm` DesignForm794963c82eDe    C !"#$%&'()*+,-./0123456789:;<=>?@ODEFPHIJKLMNARQSTUXVWY_Z\q]^`cabdiefghjklomnpurstv}wxyz{|ValueKE\ StatusBarʜGoalSeekY'GoalI ChangingCell?ReadyOptimisationLLCRCounter2OptimisationADSCRforwardACounter3CZG^OptimisationADSCRhistoricCounter4D[H_OptimisationPLCRɘCounter5I`OptimisationALLJaSheet7Sheet8Sheet9Sheet10 PSheet11!P Module1b ( Auto_OpenV  ( LoadMenus  CalculationhxlCalculationManual cbWSMenubarB CommandBarmuCustom~:CommandBarControlP iHelpIndexE muCustom1 muCustom2 muCustom3 iWindowIndexJ CommandBars ControlsKIndexAddrmsoControlPopupl)BeforeCaptionx TooltipTextb?msoControlButtonnOnAction Auto_ClosewDeletexSENSITIVITYINPUTS# GENERALINPUTSM2FINANCINGINPUTS$TAXATIONINPUTSACCOUNTINGINPUTSPANDLSEMIANNUALSUMMARY]ACASHFLOWSEMIANNUALBALANCESHEETSEMIANNUALrASUMMARYH SENSITIVITIES CHECKS)RUNSENSITIVITIES+RUN_SENSITIVITYCALC1SENSITIVITYCALC2SENSITIVITYCALC3SENSITIVITYCALC4SENSITIVITYCALC5SENSITIVITYCALC6 CalculateUnProtectEachSheetInterestReceivableCircularityProtectEachSheetPxlCalculationAutomaticCells SelectionZClear ReferenceeCopyƿ PasteSpecialKPaste xlPasteValues" OperationyxlNone SkipBlanksұ TransposeColumnsp9AutoFit& Sheet45PSheet43PSheet44PSheet16&PSheet17'PSheet18(PSheet19)PSheet20EPSheet21FPSheet22GPSheet23HPSheet24IPSheet25JPSheet26KPSheet27LP Module8iSheet[ WorksheetActiveWorkbookProtectf Unprotect? Module9j Module10U Module11VSheet32lPChart5 Module12W Module13XSheet46PSheet37qPSheet38rPSheet39sPSheet40PSheet41P Module19^ Module14YSheet52P Module15Z Module2cLogicOpeningBalanceDLogicCashGeneratedRPasteToInterestReceivableo Module3d ClearContents{Cell FormulaR1C1S ActiveCell Module4e UnhideSheetsP ActiveSheet%NVisiblexlSheetVisible HideSheets^ xlSheetHidden4 Module5f Module6g Sheet1Sheet28MP Module7hChart1Chart2Chart3Sheet3Chart4Workbookk_DefaultjItemzChart? _B_var_Ready١ _B_var_Cell_B_var_A_B_var_E_B_var_C_B_var_G_B_var_D_B_var_H_B_var_B_B_var_F_B_var_I _B_var_J  Module20zMacro1NMacro2N ActiveWindow+ LargeScroll~Down; CutCopyModeMacro3NHorizontalAlignmentS@xlCenterVerticalAlignmentʡxlBottom?WrapText} Orientationw AddIndent2W IndentLevel ShrinkToFitA ReadingOrder xlContextP MergeCellsکFundingRequirementCashflowbeforefinancingMacro4NDSRA _B_var_ForjL Module21{Secondssemiannual3ange-ectFct\ PasteRange PasteRange DisplayAlertsTest4 Module22|Activate|Previous:bSheet6Sheet29NPXANADOOMsgBoxRSheet12"P ( ShowScopek UserForm1)MSFormsCUserFormNUserForm_Click ScopeForm ShowLabel1,Label2, Label2_ClickLabel3, Label3_Click< SpecifyForm\ ( ShowSpecify UserForm2* UserForm3+ UserForm4, DesignForm BuildForm DocumentForm TestFormL ImplementForm ( ShowDesign( ( ShowBuild2  ( ShowDocument( ShowTest! ( ShowImplement[ _B_var_On6 Label1_Click ( ShowAbout! AboutFormwH_B_var_AboutForm;BLabel4,Label5, Label5_Click=Label6, Label6_ClickLabel7,Label8,Label9,Label10@Label11ALabel12B ( RemoveAddIn9*g G  + -13!;  E)%'!&S,U-W ./[0149: ; <=GFL@!@@tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\@10\MSO.DLL# 11.0 Ob LibraryKMSForms>SFrms3D452EE1-E08F`A-8-02608C4D0BB4SFM20L'BF _&/;"1?jIqAHq00h}#0Bq# 04@F4@265428\3E-4124-9EF0-6373P105F.DH.User\HELSE~1\AppData\Local\Temp\V BEZB/.exd[U4@".E .`PM  D´ThisWorkb@ookGT@idWfkbAok 2E HB1EB,!"B+BModule18GAdun18i2romȪ! e"Tib5G$To~C5;2Gn616+616aa 5@cr''| @< <8%,8pM /K|,7,7,7,7pEoI5@-',,9Y99,9ph:U,1,1,1,1CC010017?K??~ #@2C_-C8[ShXeet@Scet!2cҿaLaD22222n21Eࢽa4։34333, ]|$["P12?%i1 *A P?,K"414141j`? x5815<G$}<_&2_U]&_]Wb-5*[72C}2+ؠ2b>Kvv 2bp{b27b2U@OR pScope1!G`opSj2oa-sT(׮ SpecifyQQciyr2 ? Q?(? RD esign# /DesignForm esignForm2$Acs_н4C:\Users\CHELSE~1\AppData\Local\Temp\VBE\MSForms.exd   y v@H2B_w[vx'AVdJMF rlZXV1^APGqȏ[qJ eUserForm]rNQpb F3Dynamic   @ Auto_Open LoadMenus Auto_Close ShowScope  COVERFF F Select F $Worksheet Menu Bar F Help F F F Window &FMBP ^A Best Practice Approach To Financial Modelling LControlsTypeAdd &1 ScopeCaption ShowScopeOnAction &2 Specify ShowSpecify &3 Design ShowDesign &4 Build ShowBuild &5 Document ShowDocument &6 Test ShowTest &6 ImplementLabel2Label3 ShowImplementFuBcIPa3g] Fx@NC>8;DF Worksheet/ex?CYb$8ZuSB$J tN)=6JR|MEFp~FK6_k"-?@Label1!-6S` AyXbrU݄M{   h D(AJ .d\`m>QMwI}QjG9gm i.B-E/QP&@H    H`*6H2ʕr\NL-'MJ"Ah ޖEl@2ЃHH I  ^~(Lچ_=gKľ-[ބZM.H{p Kߠ_Y7KuXA4 i  X-%XKcWКDz7t# @ܫ1tMKDW桼h७V&D{ ʉ 1  Xd{jDr{)kCLT|2K*s     rU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~F ֑OFuVU    9Qia I % a) !.A.a...)Ua  1Ii1Qa ha `)a `'a }!'a }A'a ai'a Z'a `S ThisWorkbookModule18Module5Module16Module6Module8Module17Module7Module9Module11Module10Module19Module1Sheet1Module22Module3Module12Module13Module14Module15Module2Module4Module21Module20 UserForm1 VBAProject ScopeFormFVBA@C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL  `F4C:\Program Files\Microsoft Office\Office10\EXCEL.EXEExcel p0FC:\Windows\system32\stdole2.tlbstdole )qL-[DR?C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLLOffice  .E .`M C:\Windows\system32\FM20.DLL) 0 @Iz8ݵU.fOWOnNJRZ Y   ShowSpecifyF#M2|^b_H̳_'VBcC@%k8 -y*Bλ?y.B[QqgG/ q2  X=O6+Ob clT20nE5Mi~;z@{q/:G ALK{7Eeϒ>FNSܛc:<͹K$F͸#pfIL`H 3  05fTiIׇɹQ{!@c PPY RA!ӈr]n@,5`k.OfO4k_HAn@2KClM )5  DvuKz^0iAMr0x.ŬqI})la@JR(dCo'*hJOq1 XsJ8H q6  8PM*-N5qIήܯ5O3o/"4*6I; 7  xɬ^DbґZi'V| J mBP2t$fNgST@n A0 Hf\:EK1wP& 9  ;tAŦxMe|7Oa:&ME yS`a}H%44%c}^A`& !:   @GKw>Q(Eo7T^7(ZGcI&{OԀG C`e^ʁ2FǑJ,y) A;  h bNNH)*&OcNct <  YK{`I#EL1ᨐMR/)nF|D`8Y) ~NdfTͻ FOI< )=   b4IM|sYX>mPOD(ԫ DnAr0J~?Mb\loHqIԂ$;- I>  p  FMBP &7 Implementw<%wF4 v6Ӻ@>wNˊ5|fv)F `>,MP%~NMIDաCh ?  nSyLQ fP7 n{_*N'Jըa#λ_KPoB_J9RMѾͳWăE#%o8 A   -B!J S#mҭD'Z 6Y}AH(FLaL0Re@sRHC[H !B  H c11AΩF,5Dk2}R6I+Pv:a+IC, ~DY AC  faC0m3@kIyG;?\ GbZL`ƠEn# (M$;bpN D  t& G|FM8 kDr F9gQұF[A4GZKY_U%MS= E  8 &OD-a6K^Ht#iMGKo潺\L@/CO-y1 F  wS EF͂J[HSe ճ4oi$GS KC6V5ernGJw>(J_Ea ~K Ӊ G  :WwIξѹߪ?@djg-FSI؋R.TKFLO*_J6 I  @ B\:V*AcI 9L:K^x0ELH h'U_)F=g AK  蟙Y7ICǤU|,)F:Q׃E eA >xӌquL5ksѫ_ncLsY L  rG zhMz6yN0JB$݃.Hp;DƄL~:n=y$_'H@ ],D M  @L4Kz|%BU4ĂtF4hq f:tJ_֟D27l}K}qÍc>4J@0щ N  suy#J.z}*n1Tq0@ yK%B'~%pZ3EҒRR*- HԂ ׇa O  v]LNK)vSLl>LdE;jX6(aN{O%0 BHY~43m8C6  Q  H *L7fi^Y<N?~U^7GGC+0ȟCB ڐY~(CT[Xt !R  7mzH+A9)_S[OYgeѠ@TpxߦLDh@F[JJH6} AS   AboutFormܥH GQizY9ٍsIzQNB??$J*NV2wI^ $@IcSYH*1F9Y G%& T  8 ShowAbout $&About this add in ShowAboutV8 uUHLOՙrEhCѥJȪmk%HS᲋7S @F`RRH-ÓO R5@jL6n 4^"C)ډ V  " M O Q$ڬEBH\X|=F}</QN'jl~*"M]q} W  ۨ1~xMN9"Nz|9@9Iw^;{THbQkILabel4bA KǶ Y   P`8B<¯1ٯM@ tb^G..^(A6? Label5? DtBN8 qZ  P T˲hNe f0E%*߽8pHBh}raퟑE1f}OyzCcr3 i>:O Nq [  Vgg6YLH}#ߺWj=sM@ X | Mh7v;L2fTCxuE Bi9;BA|!n ]  ->GWl[Ěr=bM L*eh̤uI ͳiOpGN.$^WFKpj !^  2 voAHԩRnG@8V; @zQOt bI`keQ0B^al9T A_  P<#LZc E$2N r#: YEܩ -Label6(RدG q`   Xx=X~5^MS|%I \ܑc+vD>_P34wCzLbF`C" a   rNA3^LB0hzƨ1huEPJ rkgU%F;lG-JVe&h׹Lu.T b  (ж%\HwG2HVeLX|pqB;UZn4; dFYn Label12vl Iomቻc d  } DwD@[*Q+ڇX?DZUen1L5B&,1-бeezɽ@Se@1(d.LCUq )e  9t˲LN]_}?L7ʼ -o;0C6l8 Yw%@)XJ;pD{#[ If  8Al 2DIZ?u^KLIN-XK'`$}BSK%?aP\lE w0BLabel7Label8Label9Label10Label11Q ` ƕ@9AD1 h  x pakK S.BQKѨr6iG+C('tIAsviݮ'޽#E4o\ Ii  $E>350qŝGy @a*S KWUF;wS0C>H~uR!Op; ij  (m4hsJL3T"E ,6B(V-M%nMfPO7k k  1'DLD7rbuuGH!i"k⌎J` HKl@Vq(iIH *.JB}mx l  R=D#9 }>p@#&^ bnM>tJ GJd5AQIlsv'N3BSro0, n  auH$PC"ұKnw #i.qHX1/[WzcDT؎\DX*ImJS 9o  XZ+KV kGj@KN IPŁ6N@<.G?Dz^p Yp  ÑoAd4EBjY\L˕(uRZB?xK? 2DO O93A?^o h yq  nqY}M{aigk?;:O._(֛1/OOz549EaI 6<&JbNb)y%; r  H@AN76 'aoGt5ʟ9k1 έX N9䯿_u?f{dOK[ Un$v@*#@q20uMORĈ8Ʒ s  4t@]QG#TL^&_%IEV[f7ۏI9 F{/h.CQw?)AC#9^rL"''?y\M=.ھC?F!4 iv  8&[HH yCX fC/H&i%|E/*pJHD!>E2 |  |H :TE2Q^–CXAry*vGWi!z羅J@+{U̞# L.i ?Q )}  0 h3@bYߛx!V/;B[z_|ϜAPx^M;8N@Mw"K"l i~  V9H>#^ۼTO5v"Ճ{ N !ܝG\t@,ǩ_AG!I   taf" !@ ZREAXFgL  E LwKnBZ}Q @Kn' 8GF9MX^IwHk1  K Ai~}-OD=,JJ@N"OE=5lkbJP3 t$=ūBOJ]5 )   GH?\c ZoSD {x*[fIKlNBQ/NB≳]@FU]b];\ q  j *iO_uaˆD?PٔNYZB(Zu@NBx),vӞ^C g%Pտ,CVpϴuc;#[ZEH`$   dzހQVJvUn3Eα' HNBj[CMyhKB( !  pS>5L"/ƢL m?F**rUL&{@8t=88[fmF<3h9 A  |OHWTeop1H_Hc  @vs5E%+BCVuV:J*7ȯJd^ a   y'CMyd)V+:3@;E7(jX.AG& 1  xzhE] :_qGH}J& f?AnɁ}H)%^E28{\Z5L+I Q  /+>AOH>*G D{MDxMΞki#Hb`J%MuۘChQ q  (ox?3Fpg'LJ!fMtф澆I ӴxkƒOZ" /J+QA(U`s1LK]a{^txjb6ET5 ְ`ՏD1L{XHzk I  8 1. @72CE8mN_I(\h!Ao8!aqNHv}CX)BD+9 i  x Jl_ҸAra@y`"-FW?WԜBrEB Y  QV@VOڙ7=wFJAP7xT EzHD@(P2H/tG-tJ"4>2 y  $JIN&n@J R.3SLaK6cwG5L~tARxI]  P!m]GKp +7K&\}C}.BmDjDFf{K. k鼖iG[f۩ ~As  !br]H#p+b4ACxL w"D4Hs'HhM)Ea8bg7Bi5j   "AVܱō:d{MZZBxRjDNM J|E~M,ylKx_R}{Ah8'n[;Kӵ:^jrDGgN.n A  "JUhH(d; wBD]fHyS2I8T44qFܥ- Y  #&fL)|YG~OEM[njGo>*ҾOLHh^LP#A y  H#ɳ Op,~@lJT=+- HN̒rP9xzK}kk4|ј#C6IspLAG  #J!։I3K61wF2E`Ot\>hnmfeoIgD[jh9(وCq4&8F Sp=  #I, Q  8$;xNHd]/?ȭF.co-$+LH :o4٦]K+7ZNyI[*%[^AM8I  x$fBR]>w ؑncHHe$,` hDN5LAJoj(FUԥiuBLn=7ݍF^%  $D$sL,yrD礰$$K'ٴu4A# FK7""bXb@K2SadL aP )  $͏@*LF683IU13k7 I6Ri[=W@N<`EHAL#4FE_qu q  8%+yPDL}!G2ABHDn{OgSp MIJ( U?< 진Aߴy>H'2w0 :H8"  x% RemoveAddIn &&Remove this add in RemoveAddIn\          9   i(  8 1 H q X  h  x  ScopeFormUA>p :*M*fo=?CompObj@7a5TahomaL+22 What are the key output schedules and measures ?{5Tahoma@+'3 What key sensitivities are required? {5TahomaD+,4 Is there certain Functionality required ? {5TahomaP+65 Consider the needs of the sponsors or stakeholders. e.{5TahomaH+-6 What timescales and resources do you have ?ng{5TahomaD+)7 What level of complexity is required ?ve {5TahomaD+,8 Consider the ease of the data collection.{5Tahoma<+!9 Prepare a timeline and budget.ire{5Tahoma Z  \ abel1{(2TLabel2; I(2hLabel3 (2\Label4(2lLabel5q(2`Label6 (2dLabel7g (2pLabel8( 2hLabel9]( 2d Label10( 2d Label11S( 2\ Label12   t  Qu  Microsoft Forms 2.0 FormEmbedded Object9q y 8 zVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} ScopeForm Caption = "Financial Modelling Best Practice" ClientHeight = 4575 ClientLeft = 45 ClientTop = 345 ClientWidth = 4710 StartUpPosition = 1 'CenterOwner TypeInfoVer = 12 End 4N  @}t R KQDBTahoma (2@rU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~         9   i(  8 1 H q X  h  x   9  Y   !  "  $  )%  I&  (  ) ( 9+ 8 , H - X 0 h Q1 x 2  4  Q5  6  8  )9  I:  i;  1<  Q=  q> ( @ 8 )A H IB X iC h D x E  F  H  )I  IJ  iK  L  M  N  P  )Q ( IR 8 iS H T X V h X x AY  Z  \  )]  I^  i_  `  a  b  1d  Qe ( qf 8 1h H qi X j h k x l  An  ao  p  q  r  t  Qu  v  w  x ( y 8 z H 1| X Q} h ~ x   р     1  Q    I  i  ( Y 8 y H X h ) x q       )  I  i   ( 8 1 H y X h x Q VBFrame9<SpecifyFormFPCM* ]*f>oBDD Label1Y(2TLabel2Y1(2dLabel3Y (2\Label4Y"(2\Label5Yq(2\Label6Y   +SPECIFY{5TahomaY4+www.modellingsolutions.co.uk5TahomaYD+*Copyright Modelling Solutions Limited 2008n.'5TahomaY<+#1 Prepare a specification document.e5TahomaY<+#2 Document all areas of the scope.e5TahomaY<+#3 Get the project sponsors buy in.e5TahomaY Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} SpeciCompObjEMaVBFrameO=DesignFormH ]*f*fTwfyForm Caption = "Financial Modelling Best Practice" ClientHeight = 3210 ClientLeft = 45 ClientTop = 345 ClientWidth = 4710 StartUpPosition = 1 'CenterOwner TypeInfoVer = 6 End ,J  @}t R KQDBTahoma (2TLabel4+www.modellingsolutions.co.uk5Tahoma2H*Copyright Modelling oGIVCompObjJfaVBFrameh<BuildForm_dMf*pw*Solutions Limited 2008n.S5Tahoma2 +DESIGN2{5Tahoma2+1 Consider whether excel is the best platform ? eg if there long lists of data involved you may be better using an access database.u5Tahoma2x+^2 Is it best to use two or more excel workbooks ? eg are there two discrete models required? uO5Tahoma2+m3 Use a modularised layout eg one sheet for financing calculations, one sheet for taxation calculations etc. u5Tahoma222g (2hLabel32 S(2@Label12(2Label42"(2Label52 (2Label62;   Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} DesignForm Caption = "Financial Modelling Best Practice" ClientHeight = 3555 ClientLeft = 45 ClientTop = 345 ClientWidth = 4710 StartUpPosition = 1 'CenterOwner TypeInfoVer = 6 End ,J  @ }t %R KQDBTahoma (2TLabel4+www.modellingsolutions.co.uk5fm'oLNoCompObjOaVBFrame<Tahoma2H*Copyright Modelling Solutions Limited 2008n.S5Tahoma2 +BUILDa2{5Tahoma2\+D1 Keep a clear separation of "inputs","calculations" and "outputs". O5Tahoma2P+82 Keep formulae simple ie no longer than say two lines. O5Tahoma2@+%3 Keep labels clear and descriptive. ? {5Tahoma2+o4 Build 1 unique formula per row. ie where logic holds ensure that a single formula is copied down and accross.v"5Tahoma2P+85 Use as many checksums and reconciliations as possible.vN5Tahoma2+6 Keep "Version Controls" ie ensure that you keep sequentially numbered versions of the models with descriptions as to the difference between each version.vq5Tahoma2+7 Keep "Change Controls" ie ensure that you keep a sequentially numbered log of any logic or input change requests.The log should reflect the status of such requests.v5Tahoma222g !(2hLabel32q#(2@Label12(2|Label42"(2pLabel52q(2`Label62 (2Label72; (2pLabel821( 2Label92( 2 Label10I  Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} BuildForm Caption = "Financial Modelling Best Practice" ClientHeight = 5445 ClientLeft = 45 ClientTop = 345 ClientWidth = 4710 StartUpPosition = 1 'CenterOwner TypeInfoVer = 10 End ,J  @ }t R KQDBTahoma (2TLabel4+www.modellingsolutions.co.uk5Tahoma0H*Copyright Modelling Solutions Limited 2008n.S5Tahoma0 +DOCUMENT{5TahomaNT<DocumentFormZRpw*?*f'oQSXCompObjTa+"1 State the purpose of the model. e.{5TahomaNTH+02 Include instructions for operating the model. {5TahomaNTx+`3 Outline the model layout ie the purpose of each worksheet or indeed the purpose of each macro.O5TahomaNTL+24 Describe the basis of any material calculations.siO5TahomaNTP+65 Describe and attach the models key output schedules.e.5TahomaNTL+36 Describe and attach the models input assumptions.e{5TahomaNT+~7 Where a databook is required before a financial close, document the base case assumptions and the defined sensitivity cases.5TahomaNT2NTg (2hLabel3NT u(2@Label1NT(2\Label4NT"(2hLabel5NT(2Label6NT (2lLabel7NTg (2pLabel8NT( 2lLabel9NT]( 2 Label10T  Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} DocumVBFrame?TestFormKW?*й*foVXXentForm Caption = "Financial Modelling Best Practice" ClientHeight = 4155 ClientLeft = 45 ClientTop = 345 ClientWidth = 4710 StartUpPosition = 1 'CenterOwner TypeInfoVer = 10 End 0J  @ }t h+R KQDBTahoma (2TL4+www.modellingsolutions.co.uk5Tahoma0TD+*Copyright Modelling Solutions Limited 2008od'5Tahoma0T+TEST{5Tahoma0TX+@1 A minimal amount of self testing is recommended as follows :- {5Tahoma0T+(a) "Analytical Review" - a high level review of the financial statement forecasts. Look at the reasonableness of the trends. Try to correlate the outputs with the inputs. Look for obvious irregularities such as balance sheet imbalances, negative debt etc.. q5Tahoma0T+(b) "Key Outputs Review" - A detailed review of the key output measures is recommended as a logic error at this level is likely to be magnified. Eg double check npvs, irrs and lenders covenant results etc.. 5Tahoma0T+(c) "Sensitivity Review" - Undertake an Analytical Review of each sensitivity case and compare the results of each case to the base case. 5Tahoma0T+2 For a more detailed approach to limited scope testing please download the article included on our website entitled "Spreadsheet Errors And Techniques For Finding Them". 5Tahoma0T+3 Please note that 1 and 2 described above are not to be treated as an alternative to a financial model audit or opinion typically provided by a professional firm prior to financial close. 5Tahoma0Tabel20T; '(2dLabel30T W)(2<Label10T(2xLabel40T"(2<Label50Tq(2 Label60T(2Label70T(2Label80Tu( 2Label90T!  Microsoft Forms 2.0 FormEmbedded Object9qCompObjYaVBFrame:ImplementForm\й**f7VERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} TestForm Caption = "Financial Modelling Best Practice" ClientHeight = 6300 ClientLeft = 45 ClientTop = 345 ClientWidth = 4710 StartUpPosition = 1 'CenterOwner TypeInfoVer = 9 End (  }t R KQDBTahomaL(2hLabel30TH*Copyright Modelling Solutions Limited 20o[]`CompObj^aVBFrame?AboutForma**08odS5Tahoma0T4+www.modellingsolutions.co.uk5Tahoma0T$+ IMPLEMENTT{5Tahoma0T+w1 Where the model is to be used by someone other than the developer ensure to undertake a training or handover session.#5Tahoma0T+u2 The training session should include a demonstration of the areas typically outlined in the documentation section. n.#5Tahoma0T (2TLabel20T; 1(2DLabel10T(2Label40T"(2Label50T  Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} ImplementForm Caption = "Financial Modelling Best Practice" ClientHeight = 3210 ClientLeft = 45 ClientTop = 345 ClientWidth = 4710 StartUpPosition = 1 'CenterOwner TypeInfoVer = 5 End ,J  @}t R KQDBTahoma L(2LLabel10T(2TLabel20Tg '(2hLabel30T (2Label40T"(2xLabel50T (fwo`bCompObjc aVBFrame ;2Label60T1 ,+ABOUT THIS ADD IN {5Tahoma0T4+www.modellingsolutions.co.uk5Tahoma0TH*Copyright Modelling Solutions Limited 2008odS5Tahoma0T+1 This Excel Add In software has been developed as freeware by Modelling Solutions Limited.It is distributed free without the need to purchase licenses.     !"#$%&'()*+,-./0123456789:;<=>@ABDEFGHIJL 5Tahoma0TX+>2 It has been developed in order to promote low risk spreadsheet and financial modelling practices."Financial Modelling Best Practice" outlines a structured approach which helps to reduce the chance of material errors and poorly designed models leading to incorrect financial decisions.  5Tahoma0Tt+\3 Please feel free to refer to the seven principles of "Financial Modelling Best Practice". "5Tahoma0T Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} AboutForm Caption = "Financial Modelling Best Practice" ClientHeight = 3930 ClientLeft = 45 ClientTop = 345 ClientWidth = 4710 StartUpPosition = 1 'CenterOwner TypeInfoVer = 8 End ThisWorkbookThisWorkbookModule1Module1Module2Module2Module3Module3Module4Module4Module5Module5Module6Module6Module7Module7Module8Module8Module9Module9Module10Module10Module11Module11Module12Module12Module13Module13Module14Module14Module15Module15Module16Module16ModuPROJECTwmPROJECTSummaryInformation(g?DocumentSummaryInformation8Cle17Module17Module18Module18Sheet1Sheet1Module19Module19Module20Module20Module21Module21Module22Module22ScopeFormScopeFormSpecifyFormSpecifyFormDesignFormDesignFormBuildFormBuildFormDocumentFormDocumentFormTestFormTestFormImplementFormImplementFormAboutFormAboutFormID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000 Module=Module1 Module=Module2 Module=Module3 Module=Module4 Module=Module5 Module=Module6 Module=Module7 Module=Module8 Module=Module9 Module=Module10 Module=Module11 Module=Module12 Module=Module13 Module=Module14 Module=Module15 Module=Module16 Module=Module17 Module=Module18 Document=Sheet1/&H00000000 Module=Module19 Module=Module20 Module=Module21 Module=Module22 Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} BaseClass=ScopeForm BaseClass=SpecifyForm BaseClass=DesignForm BaseClass=BuildForm BaseClass=DocumentForm BaseClass=TestForm BaseClass=ImplementForm BaseClass=AboutForm HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="EEEC42BB46FD6D016D0169056905" DPB="1113BDA2DAA2DA5D26A3DBE4EC25B95469175CADC1C2D114970AE36DAF8C6751986EA56F" GC="343698C198E599E599E5" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Module1=207, 207, 880, 674, Module2=0, 0, 0, 0, C Module3=0, 0, 0, 0, C Module4=0, 0, 0, 0, C Module5=0, 0, 0, 0, C Module6=0, 0, 0, 0, C Module7=0, 0, 0, 0, C Module8=0, 0, 0, 0, C Module9=0, 0, 0, 0, C Module10=207, 207, 880, 674, Module11=0, 0, 0, 0, C Module12=0, 0, 0, 0, C Module13=0, 0, 0, 0, C Module14=0, 0, 0, 0, C Module15=0, 0, 0, 0, C Module16=0, 0, 0, 0, C Module17=0, 0, 0, 0, C Module18=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Module19=0, 0, 0, 0, C Module20=0, 0, 0, 0, C Module21=0, 0, 0, 0, C Module22=0, 0, 0, 0, C ScopeForm=0, 0, 0, 0, C, 23, 23, 1041, 519, SpecifyForm=0, 0, 0, 0, C, 46, 46, 1064, 542, C DesignForm=0, 0, 0, 0, C, 69, 69, 1087, 565, Z BuildForm=0, 0, 0, 0, C, 92, 92, 1110, 588, DocumentForm=0, 0, 0, 0, C, 115, 115, 1133, 611, TestForm=0, 0, 0, 0, C, 138, 138, 1156, 634, ImplementForm=0, 0, 0, 0, C, 161, 161, 1179, 657, C AboutForm=0, 0, 0, 0, C, 184, 184, 1202, 680, C Oh+'0 PXdt sWHITT1D Whittaker Microsoft Excel@\6BF@i@w*՜.+,D՜.+, PXl t|  EDF ENERGYA COVER  Worksheets 8@ _PID_HLINKSA F%http://www.modellingsolutions.co.uk/ FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qCompObjKf