ࡱ> @? (.@\pMaggie Bond-Brickey Ba==Z*v 8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1'Arial1'Arial"$"#,##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.000 "$"#,##0.0 "$"#,##0.00                + ) , *       H2     $""@ @  $""@ @    H  H  L  L  H "  (@@  ,@  ,@  (@  , @ "8@ "< "< "8 "<  h@(  l,  l,  h,  l ,  (@  ,  ,  ,  (  ,  h@ -  l -  l -  l -  h@  l  h@  l  l"@ @   l  (@@  ,@  ,@  , @  l"@ @   (  (@  ,  ,  l ` Instructions Projections`ibZ  3  @@  ZSJanFebMarchAprilMayJuneJulyAugSeptOctNovDecTotal Total Sales Cost of Sales Gross ProfitGen Oper Expenses DepreciationTotal Operating ExpensesOperating ProfitOther Income(Expense)Net Profit Before TaxBeginning Cash Cash Inflows:Collections (A/R)Other Income (Expense) Cash Sales Cash OutflowsAccounts Payable Past Due: A/PGeneral ExpensesCapital PurchasesTotal Cash OutflowLoans:Line of Credit Credit CardInterest ExpensePrincipal: Debt&InterestTotal Cash Available Total Debt Profit Plan Cash BudgetOther/payback on LOC Debt #1Debt #2Debt #3Draw/Payback on LOCDec Prev Year Purchases Monthly %August SeptemberOctoberNovemberDecemberStep 1Step 2Project months by %Total Sales - must equal 100%Step 3Step 4Step 5Step 6Step 7Step 8!Project General Operating Cost %*Step 9 OReview ending cash and put in draw down or pay off on Line of Credit (Line 32).Ending Cash (after LOC)Step 10Review Graph on Worksheet 3:Put in projected principal and interest payment in Line 28.Put in projected capital purchases in Line 27.B*Include all payroll, benefits, selling, occupency, and G&A costs.Enter Your Assumptions HereCash Position (before LOC)Project Total Sales for YearProject Cost of Goods Sold by %%Project Total Depreciation for year $!Project Total Interest for year $Project Beginning Cash $ Project Purchase from Dec Prev $RGo to projection page and put in your own assumptions for A/R Collection (Line 20); and Accounts Payable (Line 24 & 25) in cash budget area.Z D B 4 2 WU,* (.@ ((  dMbP?_*+%*'&C&"Arial,Bold"&12Assumptions WorksheetM2Canon PIXMA iP4000 T߁ od LetterTBJDM ,VT$m,`Oj,`OjVT$m,v`Oj,v,v`OjXXDRAFTSample 1' dVT$mVT$m@  VT$m  Canon PIXMA iP4000 T߁ od Letter4k"d??U} $ } #} I (                                 I 6 K 7 8 0            1  2 3 4 5 9# % : L ; @ H < M = N > O ? PBX&5&&&&&!"#$%' !A !Q "R #G $F %B 'D 'Ed> @7 (.@ )K$K6S  dMbP?_*+%!&CCash Flow Projection as of&D&Q?'?MTEPSON Stylus C80 Seriespv odhhRL*** xhhDLLName32=E_DU14GE.DLL d 2EPSON Stylus C80 Series  ***"d??U} m} m}  m} m} m} m)"      #( $%%%%%%%%%%&' ( ) * * * * * * *  *  *  *  +  , - %.ZZ%.ZZ%/ZZ%/Z Z%/Z Z%/Z Z%/Z Z%/Z Z% / ZZ% / ZZ% / ZZ% 0 ZZ 1 Z 2%3ZZ%3ZZ%3ZZ%3ZZ%3ZZ%3ZZ%3ZZ%3ZZ% 3ZZ % 3 ZZ % 3 ZZ % 3 ZZ # 4 %  2!3 DD5 LL555555 5  5  5  6  4  2%3ZZ%3ZZ%3ZZ%3ZZ%3ZZ%3ZZ%3ZZ%3ZZ% 3 ZZ % 3 ZZ % 3 ZZ % 3 ZZ % 4 ZZ  25 D  5D5 L55555  5  5  5  5  7Z 2!3 DD3 LL333333 3 3  3  3  4  2!3  DD5  LL5 5 5 5 5 5  5  5  5  3  4  2 3555555555564 2$ 3  D   3 D  3    L 3   3   3   3   3   3   3   3   3   4 Z 8' 9 DD D  :   LLL :  :  :  :  :  :  :  :   :   9   ;  $ @   #)> $%%%%%%%%%%&'!!!!!!!!!!!!!!! 2/3Z<555555555564@23555555555564 23 Z!5 DD5 LL55555 5  5  5  5 & 4 2>3555555555564 23D3 L333333 3  3  3  3 # 4( % $ 2>3555555555554 2>3555555555564 2&#3 %5 -555555 5  5  5  3 & 4 2>3555555555564 2%5333333?D%5333333?D5 333333?L55555 5  5  5  5 & 4 2%3ffffff?D53ffffff?D333333?D3 ffffff?L33333 3  3  3  3 & 4 23D3D3 L33333 3  3  3  3 # 4 % $ 2>3555555555564 2%>3555555555534 2*>3555555555564 2 #3 %3 -333333 3  3  3  3 & 4 <J!= DD!= DD= LL=====  =  =  =  =   K 2.>3555555555564D&'l2!#2DPoDPPPPPPP !" # $%&'( >C! ? DD ?    LL ?   ?   ?   ?   ?   ?   ?   ?   ?   @   A! $! "B!"CDDDDDDDDDDE $" #2"#3#D!#3# D#D#3#### LL#3###3###3###3###3# ## 3# ## 3# ## 3# ## F# $2#$35555555555G %2+%35555555555G &2,&35555555555G '2-'35555555555G (H'#(I %#'(I(((( -(I(((I(((I(((I(((I(((I((( I((( I( (( I( (( J( (HX0000(  v  <NMM?* Lw]`,  (.@",??3` /` / 3d23 M NM4  3Q SalesQ ; QQ3_ ( NM  MM<4E4  3Q ProfitsQ ;  QQ3_ ! NM  MM<4E4  3Q 4Ending Cash (before LOC)Q ; QQ3_ " NM  MM<4E4D $% M/3O&Q4$% M/3O& Q4FA=& " 3O9O+ 3 b#M43*#M! M4523  O43"  3O % M;3OQ443_ M NM  MM<4444 ee         e >@  7 Oh+'0HP\x LAOMaggie Bond-BrickeyMicrosoft Excel@@@b„@`՜.+,0 PXd lt| BRS  Instructions Projections  Worksheets  !"#$%&'()*+,-.012345689:;<=>Root Entry FtWorkbook]SummaryInformation(/DocumentSummaryInformation87