ࡱ> ZRoot EntryRoot Entry F`7YFk*CompObjfWorkbook[_VBA_PROJECT_CUR".YFk1YFkY  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMOPQRSTUVWX\]^_`abcdefghijklmnopqrstuvwxyz{|}~MSDigSig(Author)$NPSummaryInformation(mDocumentSummaryInformation8#VBA .YFk@0YFk՜.+,D՜.+,@"! X`l t| : Cash Flow Forecast  WorksheetsA!!, !!0 *H 010 *H 0R +7D0B0 +7QϽ>Ɩ 0 0 *H k?64`똠x0500  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 960409093559Z 991231093558Z0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA00  *H 0ieRT(bTUDEJ;~Ȁ k)vsb<ulMԘisbN1 }GQod5}gwQ>wCʣA="HH0  *H 10o#&mvh*(K󉰙2[{ls$ D}xKO200$_)ȡXu9`EލW Ɲ6tk|ҥ*j~۩+"00)ъĽ5ǛSV0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.00  *H 0. h|,-.  WSu3* [4 Z%}XsjxqX)X^-bXq"X/6MJ;"V~!lJGj6 -Ӵ90  *H :>{թy=q#+(ߌe,ZbVkbEƢ5"r-| CMlX 5ʉp*}a qfbB="2"d$006C!FXF%`0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z01'0%U VeriSign Time Stamping Service10U VeriSign Trust Network1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.10U VeriSign, Inc.10UInternet00  *H 0aGܴ^i b1FI:?xZcEO n06- o' Q`5OTOз,B Ѝ^㖴"IBlӘV.:X"e匫xGBh[-}0  *H m`_i{p+b#D Q#tI'\q5+ൖ苧KsH ڋ %VNGWF8V!&;-%2Λ@GmGv0;~*1+ݰUApF-,~0 0 yfnжneq0  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 980416000000Z 990416235959Z0]10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA1F0DU =www.verisign.com/repository/CPS Incorp. by Ref.,LIAB.LTD(c)961>0<U 5Digital ID Class 3 - Microsoft Software Validation v21 0 UUS10U Washington10URedmond10UMicrosoft Corporation10U Microsoft Corporation0 0  *H  0&dm{AO o*q.S26h5IؖeS zpm̳*02X|k%gw #100u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H p0 +7 100 *H  1  +70 +7 10  +70 *H  1l#uL1"^j(0  *H $="?|ɑ1/h@*lK\ǔ+_JfV%=5s߯<  g%9nύ!yaң%r35PĖ:8ߝMޛ AM3l}׽cͨ0mu(R_AǗjNN0$i$bO%41 %fz6ЗvDegl CWF>ivro%w{h 9}CERT ,Microsoft Corporation1#{l2e55d8fc-d4a1-11d1-b3af-00c04fa3493dAtalla Base Cryptographic Provider v1.0}~}+  0 0 yfnжneq0  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 980416000000Z 990416235959Z0]10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA1F0DU =www.verisign.com/repository/CPS Incorp. by Ref.,LIAB.LTD(c)961>0<U 5Digital ID Class 3 - Microsoft Software Validation v21 0 UUS10U Washington10URedmond10UMicrosoft Corporation10U Microsoft Corporation0 0  *H  0&dm{AO o*q.S26h5IؖeS zpm̳*02X|k%gw # 8@ _PID_HLINKSA< M-msbptz://Cash Flow Forecast - 12 Months.xlt/  http:///Mmsbpz://-r:276DB11B/Oh+'0l X` +Cash Flow Forecast - Two Years (Quarterly)fMicrosoft CorporationwoMicrosoft CorporationwoMicrosoft Excel@w=t@7)+@Gk, 5&" WMFC_ l*lJdm, EMFlJ @    !" !" !  " !  n'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 6n% Ldmm!??% #6#% Ld###!??% 6% Ld!??% )6)% Ld)))!??% m6m% Ldmmm!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw \lP@$0  \l|pd+%w0%    TT AA LP1ri   ( &% 6% Ld!??   TT (7AA (LP2D   %  6 % Ld   !??   TT :IAA :LP3et   % :6:% Ld:::!??   TT KZAA KLP4ic   % K6K% LdKKK!??   TT \kAA \LP5   % \6\% Ld\\\!??   TT m|AA mLP6at   % m6m% Ldmmm!??   TT ~AA ~LP7A    % ~6~% Ld~~~!??   TT AA LP8OF   % 6% Ld!??   TT AA LP96   % 6% Ld!??   TT"AAL#PAq    % 6% Ld!??   TTAALPB7    % $6$% Ld$$$!??   TT AALPC    % 6% Ld!??   TTGOAAGLPD&    % *6*% Ld***!??% % " !% %&" WMFC l lJ   n'%    Ld#9 )!??'% (  Ld#m9#)!??'% (  Ld9#9 !??'% (  Ld#9m#9!??RL Tahoma TahomaHhۍ0WXw -\@$0 -\ 0%    T3 +8AA3 LMicrosoft Business Planner       RL Verdana VerdanaHhۍ0WXw .\@$0 .\0%  T2MYAA2MLhGo to Article:   RL  Verdana VerdanaDhۍ0WXw $\@$0 $\ D0% T2^jAA2^LxCash Flow Projections RL  Verdana VerdanaHhۍ0WXw /\@$0 /\ 0%   RL  Verdana VerdanaDhۍ0WXw %\@$0 %\ D0% %  % % % % % % % % " !% %   $n%   TH3mAA3*LCash Flow Forecast - Two Years (Quarterly)             % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $n% % % % % % % % % % % %   T|2mAA2]LThis template provides a pro forma cash flow forecast. Enter your figures in the quarter you HE   T2mAA2iL realistically expect them to take place. Start by entering the definite amounts first. You can customize 0   T2\AA23Lthe form by changing the row labels or adding rows.   T2mAA2dLTo add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then     T2mAA2eLclick Rows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the    T2mAA2cL"Totals" column. The cells displaying zeroes contain formulae to perform automatic calculations on   L& WMFCl lJ  TL2mAA2ULyour data. Do not enter data into these cells as you will erase the formulae in them.    % % % " !% %   n% % " !% %   n' % (     ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld)!??% % Ldm!??'%   ( &% #}6o}% Ld#}m}#}L!??% ( % " !%   n% " !%   n'%    ( &% 6n% Ldmn!??% 6% Ld!??% "   n  '' ' ,n-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-n- @ !m-##- @ !#-- @ !-))- @ !)-mm- @ !m-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1 -- @ !  2 ( 2G -  - @ !   2 : 3 -::- @ !:  2 K 4 -KK- @ !K  2 \ 5 -\\- @ !\  2 m 6G -mm- @ !m  2 ~ 7 -~~- @ !~  2 8 -- @ !  2 9 -- @ !  2 #AG  -- @ !  2 B  -$$- @ !$  2 C  -- @ !  2 GD  -**- @ !*-"System-'-- ,n-   @ !) -    @ !)#-    @ ! 9-    @ !9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana- '2 ^2Cash Flow Projections  Verdana-    Verdana--  - - - - - - --'- -  ,n$-  F2 3*Cash Flow Forecast - Two Years (Quarterly)             - - -------------------------------------------------'--  ,n$------------ 2 2]This template provides a pro forma cash flow forecast. Enter your figures in the quarter you    2 2irealistically expect them to take place. Start by entering the definite amounts first. You can customize @   T2 23the form by changing the row labels or adding rows.   2 2dTo add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then     2 2eclick Rows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the    2 2c"Totals" column. The cells displaying zeroes contain formulae to perform automatic calculations on     2 2Uyour data. Do not enter data into these cells as you will erase the formulae in them.t    ---'--  ,n--'--  ,n-   -- @ !-- @ !#-- @ !-- @ !)-- @ !m-  -}#}o- @ !L}#- -'- ,n-'- ,n-   -n- @ !n-- @ !-'0I *H :0610 *H 0g +7Y0W03 +70%7)O•0 0 *H n객ɚ KL?00)ъĽ5ǛSV0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.00  *H 0. h|,-.  WSu3* [4 Z%}XsjxqX)X^-bXq"X/6MJ;"V~!lJGj6 -Ӵ90  *H :>{թy=q#+(ߌe,ZbVkbEƢ5"r-| CMlX 5ʉp*}a qfbB="2"d$006C!FXF%`0  *H 010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.0 970512070000Z 991231070000Z01'0%U VeriSign Time Stamping Service10U VeriSign Trust Network1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.10U VeriSign, Inc.10UInternet00  *H 0aGܴ^i b1FI:?xZcEO n06- o' Q`5OTOз,B Ѝ^㖴"IBlӘV.:X"e匫xGBh[-}0  *H m`_i{p+b#D Q#tI'\q5+ൖ苧KsH ڋ %VNGWF8V!&;-%2Λ@GmGv0;~*1+ݰUApF-,~0 0 yfnжneq0  *H 0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA0 980416000000Z 990416235959Z0]10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CA1F0DU =www.verisign.com/repository/CPS Incorp. by Ref.,LIAB.LTD(c)961>0<U 5Digital ID Class 3 - Microsoft Software Validation v21 0 UUS10U Washington10URedmond10UMicrosoft Corporation10U Microsoft Corporation0 0  *H  0&dm{AO o*q.S26h5IؖeS zpm̳*02X|k%gw #1s0o0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1  W5Y60 +7 10NLCash Flow Forecast Two Years Quarterly<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H sA iFB5j!N wŸuq"7|>bZT!F3x=ty$Q&e*dNa p>8Q8őo׾z_i!4҆[Τ7˭wo8Fyp6:%HĔ[. :\AYJO =1 u7Ǜ,0FB?)(A{ɡ0 *H  100010U VeriSign Trust Network10U VeriSign, Inc.1,0*U #VeriSign Time Stamping Service Root1402U +NO LIABILITY ACCEPTED, (c)97 VeriSign, Inc.C!FXF%`0 *H Y0 *H  1  *H 0 *H  1 981201010539Z0 *H  1u k)QV0  *H ~<&˗lj:^ݕQz~}ڕB!U y47mRBlήSPTc 6`8vݬ'\@R0[ݸd>?3Z//FhPROJECT PROJECTwmMdirnMain  & @`\pMicrosoft Corporation Ba= ThisWorkbook=-j,8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1Verdana1 Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1?Verdana1Tahoma1@ Tahoma1Verdana1Verdana1Verdana"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"IR"#,##0;\-"IR"#,##0!"IR"#,##0;[Red]\-"IR"#,##0""IR"#,##0.00;\-"IR"#,##0.00'""IR"#,##0.00;[Red]\-"IR"#,##0.00;6_-"IR"* #,##0_-;\-"IR"* #,##0_-;_-"IR"* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-C>_-"IR"* #,##0.00_-;\-"IR"* #,##0.00_-;_-"IR"* "-"??_-;_-@_-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_-;_-""* "-"??_-;_-@_- "$"#,##0.00 "$"#,##0#,##0;\ \(#,##0\)#,##0_);\ \(#,##0\)                 %@@   7 % @  %@"@        D $ 7 # ! ! ) )  % @  !7   7     @  `  ` p  A  %   % 7  A0!p@  A @ `7   %   a`   a    a8    %!`  `  A  %1  %1   A`    %   % 7  `7 @  A 7  %1 7   %1   %1`  %1p p  `  %1p7 @  `@   a  7  ax  Q(  A("@  %1 "@  h@@  `@  ` @  ax7   a8 7  %1 "7 @   Ah@   %1 @  %1  @  `  %1  %1    %1h %1h  Ah@ %1h  %1h  %!` %!` %!`7  %!(@  %!   %!`  %!`  !7   H7 !  @ !  `  `7 H @ h7 `7  H ) ) X P  %(7 ! !7  %( #  `  `  %! @  ax7  ax  ax ) ) ) ) !  amount Body text header Header Total Header1 Header2 Header3 Header4NonPrint_copyrightNonPrint_HeadingNonPrint_HyperlinkNonPrint_TemTitle NonPrint_Text Normal 2 Product Title Text !Title`Cash Flow Forecast  ;>  gs:2Qtr 1Qtr 2Qtr 3Qtr 4Receipts Cash Sales Credit SalesCapital IntroducedLoans Received VAT ReclaimedPaymentsPayments to CreditorsEmployee Wages & NIOwn Drawings/NIMotoring Costs Rent & RatesPostage & PackingAdvertising & PrintingHeat, Light & Power TelephoneProfessional Fees InsuranceRepairs & RenewalsBank Charges & InterestSundry ExpensesLoan Repayments (Bank)Loan Repayment (Other) VAT PaymentsCapital PurchasesOpening Bank BalanceClosing Bank BalanceTotalsfor YearTotal ReceiptsTotal PaymentsCashflow Surplus/Deficit (-)Year 1Year 2Go to Article: See Also:Cash Flow Projections{This template provides a pro forma cash flow forecast. Enter your figures in the quarter you realistically expect them to take place. Start by entering the definite amounts first. You can customize the form by changing the row labels or adding rows. To add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then click Rows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the "Totals" column. The cells displaying zeroes contain formulae to perform automatic calculations on your data. Do not enter data into these cells as you will erase the formulae in them.Other*Cash Flow Forecast - Two Years (Quarterly)Cash Flow Forecast - 12 MonthsMicrosoft Business PlannerNote: When you save this template as a workbook, note the workbook's file name and location. To edit the workbook next time, you must open it using Excel. Every time you open this template from Business Planner, a new workbook is created.Cash PurchasesR Colin and Paul Barrow 1998, The Business Plan Workbook, published by Kogan Page.9O Mike Shaw 1997, Your Business: Make it Work for You, published by Kogan Page.6: kh30 @ l'!,BfGKvPTY^bgk.pt>y}Nֆ^n~¡  dMbP?_*+% &LDate: &D&x? # u* (((( 5$ ((((  =:  C3 !# !H!!I!!!!  -/!I!!!I!!!I!!#!I: %!!?!I!!!I! !! I! !! I! !#! O! %!! ? ! C3 ""#>?????????BC3 ## #+ #@AAAAAAAA,C3 $# $x/$''''$6%$$7 -$'''' $ <% $ $7  - $ C3 %# %8 %''''%6&$%'''' % <& $ % C3 &# &8 &''''&6'$&'''' & <' $ & C3 '# '8 ''''''6($''''' ' <( $ ' C3 (# (8(''''(6)$('''' ( <) $ ( C3 )# )8)'''')6*$)'''' ) <* $ ) C3 *# *8*''''*6+$*'''' * <+ $ * C3 +# +8+''''+6,$+'''' + <, $ + C3 ,# ,8,'''',6-$,'''' , <- $ , C3 -# -8-''''-6.$-'''' - <. $ - C3 .# .8.''''.6/$.'''' . </ $ . C3 /# /8/''''/60$/'''' / <0 $ / C3 0# 080''''061$0'''' 0 <1 $ 0 C3 1# 181''''162$1'''' 1 <2 $ 1 C3 2# 282''''263$2'''' 2 <3 $ 2 C3 3# 383''''364$3'''' 3 <4 $ 3 C3 4# 484''''465$4'''' 4 <5 $ 4 C3 5# 585''''567$5'''' 5 <7 $ 5 C3 6# 696((((668$6(((( 6 <6$ 6 C3 7# 7u*7((((75:$7(((( 7 = $ 7 C3 8# 8H"8I8888  -f8I888I888I88#8I! %88?8I888I8 88 I8 88 I8 8#8 O8 %88 ? 8 C3 "9#PRRRRSRRRRTC3 :" :Q#:Y>::: LL:Y>::Y>::Y>::Y>::Y>::Y>:: Y> :: Y> :: Z> : : C3 ";"U$$$$V$$$$WC3 <" <Q~ <Y<Y:D><Y:D><Y:D><YD<<Y<D><Y:D>< Y: D>< Y: D> < ZC3 "="X1111V1111WC3 >" >[>\<>>> LL>\<>>\<>>\<>>\:>>\<>>\< >> \< >> \$ > > ]C3 "?#############D Dl&:&u&.&X@ABCDEFGHIJKLMNOP Q R S T U V W X Y Z [ \ ] ^ _ "@#############D ADDDDDDDDDDDDD B DD C DD D DD E DD F DD G DD H DD I DD J DD K DD L DD M DD N DD O DD P DD Q DD R DD S DD T DD U DD V DD W DD X DD Y DD Z DD [ DD \ DD ] DD ^ DD _ DD Dnl&$` 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 { | } ~   ` DD a DD b DD c DD d DD e DD f DD g DD h DD i DD j DD k DD l DD m DD n DD o DD p DD q DD r DD s DD t DD u DD v DD w DD x DD y DD z DD { DD | DD } DD ~ DD  DD D@l                                 DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD D@l                                 DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD D@l                                 DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD D@l                                 DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD DD D@l                                       DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD D@l  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?   DD ! DD " DD # DD $ DD % DD & DD ' DD ( DD ) DD * DD + DD , DD - DD . DD / DD 0 DD 1 DD 2 DD 3 DD 4 DD 5 DD 6 DD 7 DD 8 DD 9 DD : DD ; DD < DD = DD > DD ? DD D@l@ 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 [ \ ] ^ _  @ DD A DD B DD C DD D DD E DD F DD G DD H DD I DD J DD K DD L DD M DD N DD O DD P DD Q DD R DD S DD T DD U DD V DD W DD X DD Y DD Z DD [ DD \ DD ] DD ^ DD _ DD D@l` 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 { | } ~   ` DD a DD b DD c DD d DD e DD f DD g DD h DD i DD j DD k DD l DD m DD n DD o DD p DD q DD r DD s DD t DD u DD v DD w DD x DD y DD z DD { DD | DD } DD ~ DD  DD D@l                                  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD D@l                                  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD D@l                                  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD D@l                                  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD D@l                                       DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD D@l  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?   DD ! DD " DD # DD $ DD % DD & DD ' DD ( DD ) DD * DD + DD , DD - DD . DD / DD 0 DD 1 DD 2 DD 3 DD 4 DD 5 DD 6 DD 7 DD 8 DD 9 DD : DD ; DD < DD = DD > DD ? DD D@l@ 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 [ \ ] ^ _  @ DD A DD B DD C DD D DD E DD F DD G DD H DD I DD J DD K DD L DD M DD N DD O DD P DD Q DD R DD S DD T DD U DD V DD W DD X DD Y DD Z DD [ DD \ DD ] DD ^ DD _ DD D@l` 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 { | } ~   ` DD a DD b DD c DD d DD e DD f DD g DD h DD i DD j DD k DD l DD m DD n DD o DD p DD q DD r DD s DD t DD u DD v DD w DD x DD y DD z DD { DD | DD } DD ~ DD  DD D@l                                  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD D@l                                  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD D@l                                DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD  DD @D>@<d  2  7^yK yK *msbpz://-r:276DB11B/FyK yK http:///yK yK Zmsbptz://Cash Flow Forecast - 12 Months.xlt/ Sheet1   "#$&'()*+,./0123456789:;<=>?@ABCDEFGHIJKMOPQRTUVWYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qThisWorkbookThisWorkbookSheet1Sheet1MainMainID="{7BFDC763-6759-11D2-B09D-080009FBA239}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Main Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="F4F63836D82EDC2EDC2CDE2CDE" DPB="E8EA24B725B725B7" GC="DCDE105EF053F153F1AC" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Main=-36, 106, 552, 504, Z <jx>8#<.-DO`F--DO`x--DO`.-DO`MESheet1~__SRP_0 X __SRP_1S4__SRP_2N__SRP_3LB__SRP_4-__SRP_5%__SRP_6!__SRP_7BThisWorkbook _VBA_PROJECT3ak  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\vbe6.dll#Visual Basic For Applications *\G{00020813-0000-0000-C000-000000000046}#1.3#0#C:\Program Files\Microsoft Office\Office\excel9.olb#Microsoft Excel 9.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#D:\WINNT\System32\StdOle2.tlb#OLE Automation*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINNT\System32\fm20.dll#Microsoft Forms 2.0 Object Library*\G{5DBCDB52-F197-11D1-9DC7-00C04FB160FE}#2.0#0#C:\TEMP\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.1#0#D:\Program Files\Microsoft Office\Office\MSO97.DLL#Microsoft Office 8.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO360.DLL#Microsoft DAO 3.6 Object Library  !}c7>ThisWorkbook04378e0ce1ThisWorkbook8 Sheet105378e0ce2 Sheet1:Main06378e0ce2Main0P0(-DO`*-DO`,-DO`0LM@/ Excel+ VBAWin16~Win32MacVBA6# VBAProjectstdole`MSFormsCOfficeuDAO ThisWorkbook| _Evaluate Sheet1 Main, (RegCreateKeyhKey lpSubKey phkResult4 advapi32.dll}0(RegQueryValueExT lpValueName) lpReservedPlpTypelpDatah0lpcbData4 (RegCloseKeyl(!LU&^strCellstrQueryM?(aLUs$ (Auto_OpenV (FillDocFUbProfiledbsǂdbPathers_ Recordset WorksheetsRange ValueKi` (GetProfileDBf (GetCurrentDB DBEngineQ WorkspacesUd OpenDatabase`ErroClear OpenRecordset|dbOpenForwardOnly;EOFBOFy (GetOptionsKeyostrDirRight strValueKstrKeystrData@dwActionR dwDataSize)dwTypeHKEY_CURRENT_USERʝREG_SZdChrK~Trim@Workbookk Worksheet_DefaultjItemzNumber-Fields7 _B_str_Right#( _B_var_Stringӊ _B_str_Chrm# _B_str_LeftV _B_var_TrimmTx   6@@Q(SLSS6"N0{00020819-0000-0000-C000-000000000046}(%H` % %`h8@0!}c7$*\Rffff*04378e0ce14xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2rU @nrU  i 4 1 `rU  0 p (@ $p9Qi("(( Lp$`(`#$`$`(!`0Q nrU~| %qa9 I1Y! ay   iI l<AA +z <$ DK]A@X(\%l$ l dX8A:( ]@)lX68g   1t 1t lt 0H'%'(%'H%ltX(\%l $ <l 0X XQx)lXc7 llHl1l'(%'H%\%kAx Qlp$ ll ll!#p 4kp k:H 8X(\%lp l 0X D8KF%kA@((%$  dC)lX6 8 p  d x XD0ptx,lX8TCtt 1x/t(xtCdd FTh/dh:D ]@u%hd #@=2d@ch:DThh:DTh h1x<,xhd@TT :,h4`h($4l$^ q :#<0-DO` F/-DO`x/-DO`0-DO`ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@0!}c7$*\Rffff*05378e0ce24xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2j0* pHd VBAProject4@j = r !}c7 J< rstdole>stdole f%\*\G{00020430-C 0046}#2.0#0#D:\WINNT\System32\StdOle2j^>l&RegCreateKeyA&8RegQueryValueExA&`$RegCloseKeyxRRMELL@H6(LX(LJ> LLLLLLLL`zk @`o'' iB  Dx@%`Ft Hpx%`R+V`8 tkG+T0`@ @k K@lh +j` kpVip0 @rh `td` `@vP @x@ `z<@|C@~B<x@P0H<@@z `H(hXPP<LTVX^d@l @\ @@X @H @8 @(( @ @  @ @ @p @ ( p@ @ @ @ @ @ p" (  `Vx j@t 0 H `  `Tx jn@x d @T @D @@ 8 p h 0 H `jxX 0 @, \(4@ ( @$ @  @  @ @(  @ P0P x!}c7$*\Rffff*06378e0ce2(*\Rffff*06378e0ce2\0*\R5*#24*\R5*#2e*\R1*#229*\R1*#c4*\R1*#b8*\R5*#46*\R5*#1b*\R5*#21*\R5*#22*\R0*#13*\R0*#19*\R5*#0*\R0*#1a*\R5*#28*\R5*#29*\R5*#2a*\R0*#fq H  H  H   (08 8@ Tx  "   :(h, D  N Ph " p bx 6   (0 0`8 h  p   H   "1 $@ #P4h       B B   ( H,7X  B    @  <X4 " (Z *$2 8 @ PX  `px x^^0p@1This array holds cell/query combinations to fill.NNote: The first element in this array is the sentinel. If the cell of its namecontains data, we'll exit.] P AutoOpen Macro3 This is where the data to be written is specified:B21$<(8Profiler_MEGATASK600111_A1$<(:> Uncomment this to fill the document from the profile databaseA@@H Or uncomment this to fill the document from the current wizard database FillDoc Falseo\ This does the actual work. If bProfile is true we get the info out of the profile database,/ otherwise we get it from the current wizard db](]H]`$<!8$L%N!PG|j] B$T'Fdh$V'FkP FG|j F X%Z%\.D R <  ^B@` R$<!: d D%b.H ^ H!f H!h$HX R$<!8$L%N(PkXkP HB@B R DB@BoCurrentWizardDB$j'Vi]CurrentProfileDir$j'l l l$ n\G l\'lj l msbp_plz.mdb'lkP l'Ti@0]]]] ]87Software\Microsoft\Microsoft Reference\SBB\9.0Z\Options'r6This is a template moniker First, get the content root | r $ $\'t  p ~ t$( t$  t t$  $ 'tk t$'t t'jk A@4kixAttribute VB_Name = "Main" Option Explicit Declare FuncpRegCreateKey Lib "advapi32.dll" Alias " LA" (ByVal hhAs Long, lpSubSphkResult ,)!Querbueactuwornkb>@,t; getbinfop outA3m,'o rwis5be"it %b AOrror `NexaDim dbsu,Patha.Sb/!r"Recordse a `[WsheetT.Range(H). <>X ""&NE\ /,a iIntegeri *=ACdb = Get5DB{cE;!aICCHIfL&S:*= DBEng~."paces(iAs%.( W H` F5i0 To UBoundB() - 1C'Err.C_PD$a5=<. 51izbw,` !wbOnly hen0 (rs.EOF A%@BOF)1B CGaC= C O(@,& r& s%3be 0 i1pg >F#(!(0 ing_sP~("WFDB" !yX*yQ0WDiSuirP47Right$(C, e\9= & "\ `1"msbp_plz.mdbp` `{Cpu, təYQPwAB0w9SizepL`Con~HKEY_CURREN@T_USER@ &8H80:SREG_SZ ` "Soft6e\MiysZfznce\SBB\9.0Z\d%da templP moniker Fi,eAorooZ I( ~) H?U= (1024, 32P.WRF28Ex(!, 0, eP!`(a5In2+p, Chr$U) >  Lef.V ii,ugTrim :,DAub$q22.tlb#OLE Autom`ation^MSFor ms>SFErms$3DD452EE1-E08F-101A-8-02608C4D0BB4DCDfm20.dll#Microsoft 9 \ Ob Library/;C~1s00}#0#j0jA5DBCDB52-F197-11D1-9DC7@C04FB160FE6TEMP\VBE\DM.exd`5.E .`0M ACOf(ficDO@ficB *2DF8D04@C-5BFAaB -BDE5*AAu@42*@gram File,s\^\MSO97.DLL1 8.0Lg"@DAO>ADAO*@i25E01&05nPROGRAM FILES\COMMONMICROSOFT SHARED\360L- 3.6,>ThisWorkbookG`Th@/sWb`kbok2` H1Z`&",8T""+)S@heet1G SŠe@t1 ݣ2 : `MainG Ma`n 2o mX!cb