ࡱ> Root EntryRoot Entry F`YFk@CompObjfWorkbookG:MSDigSig(Author)$<@e  !"#$%&'()*+,-./0123456789:;=>?@ABCDEFHIJKLMNOPQRSTUVWXYZ[\]^_`abcdSummaryInformation(@iDocumentSummaryInformation8՜.+,D՜.+, PXd lt| / Cash Flow Forecast  Worksheets 8@ _PID_HLINKSA`?;msbp://-r:276DB11B/ FMicrosoft Excel WorksheetBiOh+'0i X` *Cash Flow Forecast, Two Years (Quarterly)ofMicrosoft Corporationo Microsoft Corporationo Microsoft Excel@jw@7)+@f[Gg& 3&" WMFCE 'Gd>& EMFG @    !" !" !  " !  ?'%    &% 6% Ld!??% 6% Ld!??% 969% Ld999!??% J6J% LdJJJ!??% [6[% Ld[[[!??% l6l% Ldlll!??% }6}% Ld}}}!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 6?% Ld>>!??% #6#% Ld###!??% 6% Ld!??% >6>% Ld>>>!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# WXw \lP@$0P \l|pd+%w0%    TT AA LP14   ( &% 6% Ld!??   TT (7AA (LP2s   %  6 % Ld   !??   TT :IAA :LP3j   % :6:% Ld:::!??   TT KZAA KLP4    % K6K% LdKKK!??   TT \kAA \LP5   % \6\% Ld\\\!??   TT m|AA mLP6   % m6m% Ldmmm!??   TT ~AA ~LP7   % ~6~% Ld~~~!??   TT AA LP8   % 6% Ld!??   TT AA LP9   % 6% Ld!??   TT"AAL#PA    % 6% Ld!??   TTAALPB    % $6$% Ld$$$!??   TT AALPC    % 6% Ld!??% % " !% %   ?'%    Ld#9 )!??'% (  Ld#>9#`)!??'% (  Ld9#&" WMFC G9 !??'% (  Ld#9>#9`!??RL Tahoma TahomaDhۍ0WXw \@$0M \ $ 0%    T4 >8AA4 LMicrosoft Business Planner      RL Verdana Verdana`hۍ0WXw \@$0M \0%  T2MYAA2MLhGo to Article:   RL  Verdana VerdanaDhۍ0WXw \@$0M \ D0% T2^jAA2^LxCash Flow Projections RL  Verdana Verdana`hۍ0WXw \@$0M \ 0%   RL  Verdana VerdanaDhۍ0WXw \@$0M \ D0% %  % % % % % % " !% %   $?%   TD3>AA3)LCash Flow Forecast -Two Years (Quarterly)             % %  % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % " !% %   $?% % % % % % % % % % % % %   T2>AA2kL$This template provides a pro forma cash flow forecast. Enter your figures in the quarter you realistically    T2>AA2gLexpect them to take place. Start by entering the definite amounts first. You can customize the form by     T82AA2'Lchanging the row labels or adding rows.  T2>AA2iL To add a row, select one of the rows labeled "Other," click Insert on the Excel menu bar, and then click     T2>AA2hLRows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the "Totals"    T2>AA2gLcolumn. The cells displaying zeros contain formulas to perform automatic calculations on your data. Do      T42>AA2QLnot enter data into these cells because doing so will erase the formulas in them.&WMFCG   % % % " !% %   ?% % " !% %   ?' % (     ( &% % Ld!??% % Ld#!??% % Ld!??% % Ld>!??'%   ( &% #}6@}% Ld#}>}#}!??% ( % " !%   ?% " !%   ?'%    ( &% 6?% Ld>?!??% 6% Ld!??% "   ?  '' ' ,?-  -- @ !-- @ !-99- @ !9-JJ- @ !J-[[- @ ![-ll- @ !l-}}- @ !}-- @ !-- @ !-- @ !-?- @ !>-##- @ !#-- @ !->>- @ !>-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1T -- @ !  2 ( 2 -  - @ !   2 : 3 -::- @ !:  2 K 4o -KK- @ !K  2 \ 5o -\\- @ !\  2 m 6d -mm- @ !m  2 ~ 7T -~~- @ !~  2 8 -- @ !  2 9 -- @ !  2 #Ao  -- @ !  2 Bo  -$$- @ !$  2 Cd  -- @ !-"System-'-- ,?-   @ !) -    @ !)`#-    @ ! 9-    @ !`9# Tahoma-  .2 4Microsoft Business Planner       Verdana-  2 M2Go to Article:    Verdana- '2 ^2Cash Flow Projections  Verdana-    Verdana--  - - - - --'- -  ,?$-  E2 3)Cash Flow Forecast -Two Years (Quarterly)             - - ---------------------------------------'--  ,?$------------- 2 2kThis template provides a pro forma cash flow forecast. Enter your figures in the quarter you realistically    2 2gexpect them to take place. Start by entering the definite amounts first. You can customize the form by l    B2 2'changing the row labels or adding rows.e  2 2iTo add a row, select one of the rows labeled "Other," click Insert on the Excel menu bar, and then click     2 2hRows. You will then need to use the fill handle (see Excel Help) to fill in the formula in the "Totals"    2 2gcolumn. The cells displaying zeros contain formulas to perform automatic calculations on your data. Do      2 2Qnot enter data into these cells because doing so will erase the formulas in them.i   ---'--  ,?--'--  ,?-   -- @ !-- @ !#-- @ !-- @ !>-  -}#}@- @ !}#- -'- ,?-'- ,?-   -?- @ !?-- @ !-'05 *H &0"10 *H 0g +7Y0W03 +70%7)O•0 0 *H $ C#0㒵ߠ?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 #1_0[0u0a10UInternet10U VeriSign, Inc.1301U *VeriSign Commercial Software Publishers CAyfnжneq0 *H 0 *H  1  +70 +7 10  +70 *H  1rTYˮ!9 0 +7 1~0|:8Cash Flow Forecast-Two Years>޶8E* Bn 1ocރ_T !a0 *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 981125024055Z0 *H  18 >E^nVa0  *H r"ϰl7O+E.| 1DZ@-Ko~>ml5D 4HϢ#%{ǏkŲU4ՠcB|6W KLEs 0 'H @`\pMicrosoft Corporation Ba==8X@"1Arial1Arial1Arial1Arial1 Verdana1Verdana1Verdana1 Tahoma1Tahoma1Tahoma1 Arial1@ Tahoma1?Verdana1Tahoma1@ Tahoma1Verdana1Verdana1 Tahoma1 Tahoma1Arial1Arial1Tahoma1Tahoma"$"#,##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\);_(* "-"??_);_(@_)""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- "$"#,##0.00 "$"#,##0#,##0;\ \(#,##0\)#,##0_);\ \(#,##0\)                 %@@   7 % @  %"@       D $ 7 ! ! ) )   @  !7   7     @  @  `  %   % 7  %   h@  A @ `   % 7   % 7   a`  a`7   Q(   7  A "@  %1 "@ %1H"@  %1h"@@  %1h"@  %1h" @  Ah"@ @  (  7  %1  7  %1 7  %1 !77  @  % @  % 7 @  Q   p7  %!(@  %!`  %!`   ah 7  !7   H7 !  @ !  `  `7 H @ ) ) X P  (7 Ah"@@ ! %( %( !p@  `7  `  `  a`7  ah  a`  A(   ah  a(   a8 7  a( 7   (  ( %( %(7  !7 ) ) ) )  ax  ap  X   amount Body text header Header Total Header1 Header2 Header3 Header4NonPrint_HeadingNonPrint_HyperlinkNonPrint_TemTitle NonPrint_Text Normal 2 Product Title Text Title`Cash Flow Forecast  ; :  gX4Receipts Payments Telephone InsuranceTotal ReceiptsTotal PaymentsCashflow Surplus/Deficit (-)TotalsGo to Article:Cash Flow ProjectionsOtherRentTravelPostage Advertising Miscellaneous UtiltitiesOpening Cash BalanceClosing Cash BalanceMicrosoft Business PlannerYear 1Year 2 Qtr 1Qtr 2Qtr 3Qtr 4Qtr 1)Cash Flow Forecast -Two Years (Quarterly)*Cash Flow Forecast - Two Years (Quarterly) Microsoft, 1998.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 labeled "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 zeros contain formulas to perform automatic calculations on your data. Do not enter data into these cells because doing so will erase the formulas in them. Cash salesCollections from credit salesNew equity inflowLoans receivedCapital purchases Tax paymentsLoan repaymentsOwner's drawings Bank chargesTraining and developmentProfessional feesMarketing/promotionOffice suppliesRepairs and maintenance Payroll taxesEmployee benefitsSalaries and wagesPayments to creditorsCash purchasesNote: 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 Microsoft Business Planner, a new workbook is created.:{ Pdx% @ =)9  dMbP?_*+% &LDate: &D&?'?(?)?MHP LaserJet 4Si (Copy 2)@w XX@MSUDOHP LaserJet 4Si<d "RXX??U} I} }  } I=  @ @       @  X@         /               !FGGGGGGGGG# ! hGGGGGGGGG# !HIIIIIIIII# ! J IIIIIIIII# ! U IIIIIIIII# !KKKKKKKKKK# !LLLLLLLLLL# ! ijjjjjjOOO# ! kjjjjjjPPP#  !QRRRRRRRRR#  ! l3 jjjjjjPPP#  !MNNNNNNNNN#  !MNN o pppppp#  !'"""""""")# # BCCCCCCCCD# #XY##ZY##[A# #X\ m m]\ mn^A# #_ ` a a b a a a  c  E ##(,,,,,,,,-# # .deeddddd  9 ## 8 f f f f f f f  f ;dd   - ## 8!ffffffff  ;   ## 8"ffffffff  ;   ## 8#f f f f f f ff  ;   ## S gg g gg g gg  <   ## 124  -/242424242424 24  :   ##=>>>>>>>>?# # @&&&&&&&&+# # 82 $W$$$$$  ;  4  - ## 81$W$$$$$$  ;   ## 80 V$ $ $ $ $ $  $ ;   ## 8/V$$$$$$$  ;.   #D l"6"66""66"6"8"6"N"J[[T"6~[ ! " # $ % & ' ( ) * + , - . / 0 1 2 3  4  5  6  7  8  9  :  ; <  # 8. V$$$$$$$  ;   #!# !8 !V$$$$$$$ ! ;2  ! #"# "8"V$$$$$$$ " ;!  " ### #8-#V$$$$$$$ # ;"  # #$# $8$V$$$$$$$ $ ;#  $ #%# %8 %V$$$$$$$ % ;$  % #&# &8&V$$$$$$$ & ;%  & #'# '8'V$$$$$$$ ' ;&  ' #(# (8,(V$$$$$$$ ( ;'  ( #)# )8)V$$$$$$$ ) ;(  ) #*# *8+*V$$$$$$$ * ;)  * #+# +8*+V$$$$$$$ + ;*  + #,# ,8),V$$$$$$$ , ;+  , #-# -8(-V$$$$$$$ - ;,  - #.# .8.V$$$$$$$ . ;-  . #/# /8'/V$$$$$$$ / ;  / #0# 08& 0V$ 0$ 0$ 0$ 0$ 0$ 0 $0 ;/  0 #1# 18% 1V$ 1$ 1$$ 1$ 1$$ 1 ;0  1 #2# 2S$2%%%%%%%% 2 ; 2 #3# 3S 3% 3% 3% 3%%% 3%3 %3 <1  3 #4# 41426444  -f4264426442644264426442644 26 44 :3  4 #5#0&&&&&&&&+# 6# 6T65:666  LL63:663:663:663:663:663:66 3: 6#6 64 %66 6 #7#0$$$$$$$$*# 8# 87~ 8485888 L8588588588588588 5 8 8 6# 9!0$$$$$$$$*# :! :7!:48 D8D6!:58 D8D6:58:::  LL:58::58::58::58 :: 56 : : 6# ;############ <############ >0[[[[[[[[[[[[[[[[[T"Z" "C">@<d2   7\yK yK (msbp://-r:276DB11B/ ff8Excel.Sheet.89q