ࡱ> 87 =`\6CCH Incorporated B=  Cash Flow Budget1Month1_Ending_Bal: -1Month2_Ending_Bal: -1Month3_Ending_Bal:' -1Month4_Ending_Bal: -1Month5_Ending_Bal: - 1Month6_Ending_Bal:_ - $ ; -$ ;=xi$e8X@"1Arial1Arial1Arial1Arial1Arial1 Arial1 Arial1Arial1Arial1Arial1 Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0;0;#,##0_);[Red]\(##,#0\)0;0;                + ) , *  & " "  "  "      & C     &  %    C    C   &   H   &   A  A  = Cash Flow Budget (Sheet2 )Sheet3 *Sheet4 +Sheet5 ,Sheet6 -Sheet7 .Sheet8 /Sheet90Sheet101Sheet112Sheet123Sheet13w4Sheet14o5Sheet15g6Sheet16 = / bf(  dMbP?_*+%%Page &P&?'?)?MHP LaserJet IIIPICE  DLgW,,?;5N}w;5}dg2"d,,??U} !} !}  } }  } }  } }  } } } } } }  } $ Column B /wbwT bTԁ  ԁ b  b  bGeD@@PPbq,bbb"Cash Flow Budget Worksheet"$ [Month][Month][Month][Month]  [Month]  [Month]  TotalBeginning Cash Balance %" C<#%" C<#%" C< #% " C< #% "C<  'Cash Inflows (Income):"############(Accts. Rec. Collections ) -y Loan Proceeds ) Sales & Receipts ) Other: ############("   )"   )    Total Cash Inflows! $  % y # $     -y # $   # $   # $   # $   ! * % y Available Cash Balance  "$ D D # "$    LL # "$  # "$  # "$   # "$   '! Cash Outflows (Expenses):" ############( Advertising )Bank Service Charges )Credit Card Fees )Delivery )Health Insurance ) Insurance )Interest )! -yInventory Purchases ) Miscellaneous )Office )Payroll ) Payroll Taxes )Professional Fees ) Rent or Lease !)  % Subscriptions & Dues )Supplies )Taxes & Licenses )$Utilities & Telephone )!DylL(5Hdg@EEeAKbkg_g`xjd]^dhjk_g b!"T#b$%T&'ԁ( )ԁ*b +b,-b.G  Other: ############("! !)""" ")#""# -y"# #)"$$ Subtotal!$$+ %#$#$$+$$$  -$#$$+$$#$$+$$ #$ $+ $$ #$ $+ $$ !$*& %#%Other Cash Out Flows:"%############(&&Capital Purchases&  &)'&&* -y''Loan Principal'  ')(&(( Owner's Draw(  ()*&))Other: )############("* *)+&++ Subtotal!+$, %&*y+#!+$, %&*y+#!+$, %&*y+#!+$, %&*y+ #!+ $, %&* y+ #!+ $, %&* y+ !+*, %&*y,, Total Cash Outflows,"- D$D+,#,"- D$D+,#,"- D$D+,#,"- D$D+, #, "- D$ D+ , #, "- D$ D+ , ,+ D$D+-Ending Cash Balance--% D D,-&-% D D,-#-% D D,-#-% D D,- #- % D D, - #- % D D,  - ," @E^E[Gec@E`];> &&&" =  )  dMbP?_*+%&APage &P"?? U >  =  *  dMbP?_*+%&APage &P"?? U >  =  +  dMbP?_*+%&APage &P"?? U >  =  ~,  dMbP?_*+%&APage &P"?? U >  =  v-  dMbP?_*+%&APage &P"?? U >  =  n.  dMbP?_*+%&APage &P"?? U >  =  f/  dMbP?_*+%&APage &P"?? U >  =  ^0  dMbP?_*+%&APage &P"?? U >  =  V1  dMbP?_*+%&APage &P"?? U >  =  N2  dMbP?_*+%&APage &P"?? U >  =  F3  dMbP?_*+%&APage &P"?? U >  =  >4  dMbP?_*+%&APage &P"?? U >  =  65  dMbP?_*+%&APage &P"?? U >  =  .6  dMbP?_*+%&APage &P"?? U >  =  &7  dMbP?_*+%&APage &P"?? U >  Oh+'0$ `hpx  John K. RothCCH Incorporatedc@Microsoft Excel@-޺G#'0    ZN """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www45'  ' -  "- "- !-**- !*-CC- !C-UU- !U-ff- !f-ww- !w-- !-- !-- !-- !-- !-- !-..- !.-- !-- !-%%- !%-~~- !~-'- -   "-**- !d*-CC- !dC-UU- !dU-ff- !df-ww- !dw-- !d-- !d-- !d-- !d-- !d-..- !.-- !-- !-%%- !%-~~- !~-  !Dp5B(D@DDAD-  !pU-  "-ff- !Zf !qT-f%f- !Zf%-'- Arial-  2  -  "-- !-- !-- !-- !ZN-  ZN ZN"-- !-- !-- !-- !---  2  *1  "-*- !-- !  2 1 ,C2 -,C- !,-++- !+  2 D EU3 -EU- !E-DD- !D  2 V Wf4 -Wf- !W-VV- !V  2 g hw5 -hw- !h-gg- !g  2 x y6 -y- !y-xx- !x  2 7 -- !-- !  2 8 -- !-- !  2 9 -- !-- ! 2 10 -- !-- !  2  .A  -- !-.- !  2 s0B  -//- !/-/- !/  2 C  -- !-- !X  2 %D  -- !-%- !   2 N'~E -&&- !&-&~- !X&- -"Systemn- '--  Arial-  ArialT-  -   !. !. ! ! ! ! !% !% .2 ?Cash Flow Budget Worksheet        Arial- 2 D[Month] 2 D9[Month]   Arial-5B(D@DDAD-  !V. !V. (2 WBeginning Cash Balance Arial-cx 2 Vj$0-  !g. !g. (2 hCash Inflows (Income):   Arial-*2 y1Accts. Rec. Collections  2 1 Loan Proceeds2 1Sales & Receipts 2 1Other: -- '- -  "-- !-- !--ZN4'=A՜.+,040 8@ H  Cash Flow BudgetSheet2Sheet3Sheet4Sheet5Sheet6Sheet7Sheet8Sheet9Sheet10Sheet11Sheet12Sheet13Sheet14Sheet15Sheet16  Worksheets  !"#$%&'()*+,-.0123456Root EntryF޺ 2﯐BookBBBPmPB _7SummaryInformation($DocumentSummaryInformation8/