ࡱ> pRoot EntryRoot Entry F%oFkq*CompObjfWorkbookXd._VBA_PROJECT_CUR"R!oFkP_$oFkW  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKMNOPQRSTUVsYZ[\]^_`abcdefghijklmnortuwxyz{|}~MSDigSig(Author)$L0SummaryInformation(XhDocumentSummaryInformation8"VBA R!oFk"oFk՜.+,D՜.+,D"" X`l t| : Financial Resource Audit  WorksheetsA!!, !!0 *H 010 *H 0R +7D0B0 +7{>q]:{X0 0 *H <<`: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  1yETkDqy0  *H ws% 5l6viU=菵UNr|$eN<+J U`G\%!giy,V Ak-yQR2_4Ai_!A ͫΐ?}L@l(^*b \4K dZ[*"\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_HLINKSAdmsbpz://-r:276DB167/Oh+'0(h X` Financial Resource AuditicrMicrosoft CorporationitMicrosoft CorporationitMicrosoft Excel@y@7)+@Gg/'! 3&" WMFC13 'Gd@/'! EMFG @    !" !" !  " !  A'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 6A% Ld@@!??% #6#% Ld###!??% @6@% Ld@@@!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw \lP@$0 \l|pd+%w0%    TT AA LP1   ( &% 6% Ld!??   TT (7AA (LP2   %  6 % Ld   !??   TT :IAA :LP3li   % :6:% Ld:::!??   TT KZAA KLP4    % K6K% LdKKK!??   TT \kAA \LP5Y    % \6\% Ld\\\!??   TT m|AA mLP6sj   % m6m% Ldmmm!??   TT ~AA ~LP7    % ~6~% Ld~~~!??   TT AA LP8 9   % 6% Ld!??   TT AA LP9o   % 6% Ld!??   TT"AAL#PAc)    % 6% Ld!??   TTAALPB^    % $6$% Ld$$$!??% % " !% %   A'%    Ld#9 )!??'% (  Ld#@9#b)!??'% (  Ld9#9 !??'% (  Ld#9@#9b!??RL Tahoma TahomaDhۍ0&" WMFC GWXw \@$0 \ 0%    T3 +8AA3 LMicrosoft Business Planner       RL Verdana VerdanaDhۍ0WXw \@$0 \0%  T2MYAA2MLhGo to Article:   RL  Verdana Ref Verdana RefDhۍ0WXw \@$0 \3 0% T2^kAA2^LxResources AppreciationRL  Verdana VerdanaDhۍ0WXw \@$0 \ 0%  % % " !% %   A%   T3AA3L|Financial Resource Audit      %  % % " !% %   ARL  Verdana VerdanaDhۍ0WXw \@$0 \ D0% % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $A% % % % % % % % % % % % % % %   T2@AA2dLUse this form to help you calculate how much money you have to invest in your business and how much       T2AA2Lcapital you need to raise.T2@AA2dLThe figure for your net worth is the maximum security that you can offer for any money borrowed. To       T2@AA2jL work out the amount of capital you are likely to need to finance growth, look at your business objectives   T2@AA2_L over the planning period. You can customize the form by changing the row labels or adding rows.    T2@AA2jL To add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then click     T2@AA2eLRows. The cells displaying zeroes contain formulae to perform automatic calculations on the data you     T42@AA2QLenter. Do not enter data into these cells as you will erase the formulae in them. &6WMFCG   % % % " !% %   A% % " !% %   A' % (     ( &% % Ld!??% % Ld#!??% % Ld@!??'%   ( &% #}6B}% Ld#}@}#}!??% ( % " !%   A% " !%   A'%    ( &% 6A% Ld@A!??% 6% Ld!??% "   A  '' ' ,A-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-A- @ !@-##- @ !#-@@- @ !@-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1 -- @ !  2 ( 2 -  - @ !   2 : 3 -::- @ !:  2 K 4& -KK- @ !K  2 \ 5 -\\- @ !\  2 m 6 -mm- @ !m  2 ~ 7 -~~- @ !~  2 8& -- @ !  2  9 -- @ !  2 #A  -- @ !  2 B  -$$- @ !$-"System-'-- ,A-   @ !) -    @ !)b#-    @ ! 9-    @ !b9# Tahoma-  .2 3Microsoft Business Planner        Verdana-  2 M2Go to Article:    Verdana Ref- (2 ^2Resources Appreciation Verdana-  --'- -  ,A-  +2 3Financial Resource Audit      -  --'- -  ,A Verdana-------------------------------------'--  ,A$--------------- 2 2dUse this form to help you calculate how much money you have to invest in your business and how much       .2 2capital you need to raise.2 2dThe figure for your net worth is the maximum security that you can offer for any money borrowed. To       2 2jwork out the amount of capital you are likely to need to finance growth, look at your business objectives   2 2_over the planning period. You can customize the form by changing the row labels or adding rows.    2 2jTo add a row, select one of the rows labelled "Other", click Insert on the Excel menu bar, and then click     2 2eRows. The cells displaying zeroes contain formulae to perform automatic calculations on the data you l    2 2Qenter. Do not enter data into these cells as you will erase the formulae in them.    ---'--  ,A--'--  ,A-   -- @ !-- @ !#-- @ !@-  -}#}B- @ !}#- -'- ,A-'- ,A-   -A- @ !A-- @ !-'0+ *H 010 *H 0g +7Y0W03 +70%7)O•0 0 *H mH< tk۠?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 #1U0Q0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1 Js@L,F0 +7 1t0r20Financial Resource Audit<:http://bookshelf.msn.com/z/msbp/teleport/fromCD/office.asp0  *H N߹gqЄ誻̹@ԪVQ#>DJ ؛yR^h!\#;;m9Z51٤BA:-BՒ܌,yr[}DJR;mԶܜS9"5 3F e'wEB9PxS$-hnjxEc.k(ү= $q $)yx׳sa14ՠZhņ `?$$$$$""ZY$$$$$"# @A$$$$$"#&'$$$$$" #G H$$$$$"#(F$$$$$"# (F$$$$$"#&'$$$$$"# )*$$$$$"# +,$$$$$"# +,$$$$$#% # +,""""""% # +,""""""% # -,""""""% # + ,""""""% # + ,""""""% # -!,""""""% # /#0. %""""""% #1'""""""% Dl0000000020002222222W ! " # $ % & ' ( ) * +  ,  - . / 0 1 2 3  4  5  6  7 8 9 : ; <  # 2 *""""""% !" !+!,"""""""" "-",""""""#" #+#,""""""$" $+ $,""""""%" %+ %.""""""&" &+ &,""""""'" '+'3""""""(" (-(,"""""")" )-),""""""*" *+*,""""""+" +-!+,""""""," ,4#,5 %!+(,""""""-"67""""""." .@!.B: D,D.""""""/"63""""""0" 0(0'""""""1"89""""""2" 2-2,""""""3" 3:3.""""""4" 4/#408 %234""""""5"6;""""""6" 6/60""""""7"63""""""8" 8C!8B, D4D68""""""9"<="""""":" :D"!:E"" D8D.:"""""";"""""""""<""""""""">0200000000000US000U0SS>@<d 7^yK yK *msbpz://-r:276DB167/ Sheet1   "#$&'()*+,./0123456789:;<=>?@ABCDEFGHIJKMOPQRTUVWYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qThisWorkbookThisWorkbookSheet1Sheet1MainMainID="{7BFDC779-6759-11D2-B09D-080009FBA239}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Main Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="7E7CAD3155D1D7D5D7D5D5D7D5D7" DPB="FCFE2FAFD32CD42CD42C" GC="7A78A93526362636D9" [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=44, 44, 632, 442, Z <jx#< oLDO`F oLDO`x oLDO` oLDO`MESheet1~__SRP_0 X __SRP_1S4__SRP_2N__SRP_3LB__SRP_4-__SRP_5%__SRP_6!__SRP_7BThisWorkbook _VBA_PROJECTv3ak  *\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  o}c7ThisWorkbook04378e0d15ThisWorkbook Sheet105378e0d15 Sheet1Main06378e0d15Main0P0oLDO`oLDO`oLDO`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@0o}c7$*\Rffff*04378e0d154xAttribute 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 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 xo}c7$*\Rffff*06378e0d15(*\Rffff*06378e0d15\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:B15$<(8Profiler_MEGATASK600111_A7$<(:> 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 ,)!Querbueactuworkb>@,t; getbinfo outA3m ,'o rwisŀ5e"it %bAOrror `NexaDim dbsu,Path]aSb/!r"Recordse a `[WsheetT.Rang$e(H). <> ""&NE\^ ,a iIntegeri =*=ACdbA= Get5DBcE;!aICCHIfL& S:*= DB(Eng~."papces(iAs%.( H` F5i0 To UBoundB() - 1C'Err.CPD$a5=y hen0 (rs.EOF A%@BOF)1B CaC= C O(@,& r& s%3be 0< i1pg ?>F#(!(0 ingsP~("WFDB" !yX*yQ0WDiSuirP47Right$(C, e\9 = & "\]1"msbp_plz.mdbp` `{Cpu, təQPwAB0w9pSizepL#`Con~HKEY_CURRENT_USER@ p&H80:SREG_SZ ` "Soft6e\Miys Zfznce\SBB\9.0Z>\d%da templP moniker F:i,eAorooZ I( ) H?U= (1024, 32P.WRFq2Ex(!, 0, eP!?`(a5In2+p, Chr$U) > DZ 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`&",T""+)S@heet1G SŠe@t1 ݣ2  `MainG Ma`n 2o mX!cb