аЯрЁБс>ўџ 01ўџџџ/џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ ьЭЩР`сАСт\pZachhos BАaР=œЏМ=[џ: "8X@"Зк1 џArial1ШџArial1ШџArial1ШџArial1 џМArial1 џArial1 QМTahoma1ШџМArial1ДџArial1мџМArial1|џArial1№џ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.00$Ѕ[$-409]dddd\,\ mmmm\ dd\,\ yyyyІ[$-409]mmmm\-yy;@ Їmmmm Јmmmm\-yyрѕџ Р рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР рѕџ єР р Р р+ѕџ јР р)ѕџ јР р,ѕџ јР р*ѕџ јР р ѕџ јР рР рР р  Р р Р р Р р8Р р8Р р8Р рx  ) р|  ) р8 Р р< Р р| , р|  , рx  ) р8  Р р8  Р р|  . р8 Р р< Р р|, рx , рx  , р x , р x , р  Р р  Р р #Р р #Р р8  Р р<  Р рЇ<  Р рx   р|   “€џ“€џ“€џ“€џ“€џ“€џ’т8џџџџџџџџџџџџ€€€€€€€€€РРР€€€™™џ™3fџџЬЬџџffџ€€fЬЬЬџ€џџџџџџ€€€€€џЬџћњѕіѓтџџ™МЬфџ™ЬъъъџЬ™3fџ3ЬЬ™ЬџЬџ™џfff™–––3f3™f333™3™3f33™333\џџџ`…ZTwelve-month cash flowŒЎ  ;џСС"Оыj№b№(3 №ПAР@@ё* їќJ1/Total Item ESTEnter Company Name Here CASH RECEIPTS Cash SalesCollections fm CR accountsLoan/ other cash inj.TOTAL CASH RECEIPTS CASH PAID OUTPurchases (merchandise)Purchases (specify)Outside servicesSupplies (office & oper.)Repairs & maintenance AdvertisingCar, delivery & travelAccounting & legalRent Telephone Utilities InsuranceTaxes (real estate, etc.)InterestOther expenses (specify)Other (specify) MiscellaneousSUBTOTALLoan principal paymentCapital purchase (specify)Other startup costsReserve and/or EscrowTOTAL CASH PAID OUTSales Volume (dollars)Accounts ReceivableBad Debt (end of month)Inventory on hand (eom)Accounts Payable (eom)Pre-Startup ESTFiscal Year Begins:4ESSENTIAL OPERATING DATA (non cash flow information) DepreciationGross wages (exact withdrawal)Payroll expenses (taxes, etc.)Owners' Withdrawal!Cash on Hand (beginning of month) &Total Cash Available (before cash out)Cash Position (end of month)Twelve-month cash flowџ2Х h Џ bš сH`ccт ьЭЩР 3P‡$&/  dќЉёвMbP?_*+‚€%сСƒ„&'(р?)а?M\\prn-corp1\b16-1273-bм$Sџъ oPXXLetterPRIVт0''''Ф`\KhCяЄFS џ `5XRX>@цццDraft00Ё"PXXU} е} *} Њ } * }  } U 3с@+РK@яРр@Ђ@h@h@h@ h@ h@ р@ ЂР h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@h@§ .§ .О..///. § 0%~ 1`Ÿт@О   § 2$3`Ÿт@џDР03 Ѓт@џDРAEDРADAA3Їт@џМ$ LџРAELџРADAA3рЊт@џ3 Ўт@џ3€Вт@ џ 3@Жт@ џ 3 Кт@ џ 3От@ џ 3€Ст@ џ 3`Хт@џ3 Щт@ џ§ 4§ +О"О& § ,О"!!!!!!!!!!!!!"§ #О"§ 5О"66666666666666§ #О" § %# & џ % РР$k & џ М  -§џџџРР$k & џ  & џ  & џ  & џ  & џ  & џ  & џ  & џ  & џ  & ў  & џ  & џ § ," &#џ DРD Р & џ М  LљџРLџџР & џ  & џ  & џ  & џ  & џ  & џ  & џ  & џ  & џ  &џ  & џ  & џ О$ '((((((((((((((§ ,О" )))))))))))))"§ #О"§ $ О"66666666666666§ # О"§ $(О"66666666666666§ #)О"§ $ О"66666666666666§ # О"§ $ О"66666666666666§ # О"§ $О"66666666666666§ #О"§ $О"66666666666666§ #О"§ $О"66666666666666§ #О"§ $О"66666666666666§ #О"§ $О"66666666666666зDП lN$з4*4444ус(444444444444444444 h@!h@"h@#h@$h@%h@&h@'h@(h@)h@*h@+Ђ@,h@-h@.h@/h@0h@1h@2h@§ #О" § !$О"!66666666666666§ "#О""§ #%##&)џ %"РР(ю#&)џ#М## -ыџџџРР(ю#&)џ##&)џ##&)џ##&)џ##&)џ## &) џ## &) џ## &) џ## &) џ## &) џ##&)џ##&)џ#§ $#О"$§ %$О"%66666666666666§ &#О"&§ '$О"'66666666666666§ (#*О"(§ )%#)&*џ %#(РР$k)&*џ)М)) -њџџџРР$k)&*џ))&*џ))&*џ))&*џ))&*џ)) &* џ)) &* џ)) &* џ)) &* џ)) &* џ))&*џ))&*џ)§ *-"*&є%т§ D РD)Р*&#џ*М** LсџРLџџР*&#џ**&#џ**&#џ**&#џ**&#џ** &#џ** &# џ** &# џ** &# џ** &# џ**&# џ**&#џ*О$+§ ,-&О",*************+§ -#О"-§ .$ О".66666666666666§ /#!О"/§ 05"О"066666666666666§ 1##О"1§ 2$'О"266666666666666з*W h444у44444ус(444444ьд№z№№b№( № №№„Ђ № Г №B€Їя…‹П XPƒPП?П№еbе№]4@Їя Uo/џ@†Stf]XЖ‚ь №Ж$<%Totals are calculated automatically.<Ъ$ ьž№žЂ № г №N€рЇя…П €)ƒ№q‹Іџœ @ПРџП"ёП `№Œ`Œ$5№]`рЇя`ь №Ж‹ <Œ Notes on Preparation Note: You may want to print this information to use as reference later. To delete these instructions, click the border of this text box and then press the DELETE key. Refer back to your Profit & Loss Projection. Line-by-line ask yourself when you should expect cash to come and go. You have already done a sales projection, now you must predict when you will actually collect from customers. On the expense side, you have previously projected expenses; now predict when you will actually have to write the check to pay those bills. Most items will be the same as on the Profit & Loss Projection. Rent and utility bills, for instance, are usually paid in the month they are incurred. Other items will differ from the Profit & Loss view. Insurance and some types of taxes, for example, may actually be payable quarterly or semiannually, even though you recognize them as monthly expenses. Just try to make the Cash Flow as realistic as you can line by line. The payoff for you will be an ability to manage and forecast working capital needs. Change the category labels in the left column as needed to fit your accounting system. Note that lines for 'Loan principal payment' through 'Owners' Withdrawal' are for items that always are different on the Cash Flow than on the Profit & Loss. Loan Principal Payment, Capital Purchases, and Owner's Draw simply do not, by the rules of accounting, show up on the Profit & Loss Projection. They do, however, definitely take cash out of the business, and so need to be included in your Cash plan. On the other hand, you will not find Depreciation on the Cash Flow because you never write a check for Depreciation. Cash from Loans Received and Owners' Injections go in the "Loan/ other cash inj." row. The "Pre-Startup" column is for cash outlays prior to the time covered by the Cash Flow. It is intended primarily for new business startups or major expansion projects where a great deal of cash must go out before operations commence. The bottom section, "ESSENTIAL OPERATING DATA", is not actually part of the Cash model, but it allows you to track items which have a heavy impact on cash. The Cash Flow Projection is the best way to forecast working capital needs. Begin with the amount of Cash on Hand you expect to have. Project all the Receipts and Paid Outs for the year. If CASH POSITION gets dangerously low or negative, you will need to pump in more cash to keep the operation afloat. Many profitable businesses have gone under because they could not pay the bills while waiting for money to flow in. Your creditors do not care about profit; they want to be paid with cash. Cash is the financial lifeblood of your business. < —, s8‹   Microsofts>М@<dA @я7bb, ўџр…ŸђљOhЋ‘+'Гй0Ш PXdt„ œ Ј ДРфSCOREMatthosMicrosoft Excel@€Cі]хУ@€;ЙЂ–Р@УAЛхУ€аŒ Є А МШ ,фMicrosoft Excel@€Cі]хУ@€;ЙЂ–Р@УAЛхУ-Service Corps of Retired Executives (SCOREЎ) Named Ranges ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџўџџџўџџџ'џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot Entryџџџџџџџџ РF$•’ЦћУ2@Workbookџџџџџџџџџџџџт<SummaryInformation(џџџџhDocumentSummaryInformation8џџџџџџџџџџџџЄўџџџ ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџўџеЭеœ.“—+,љЎ0t `$h px€ˆ  р\hфG Twelve-month cash flow('Twelve-month cash flow'!Print_Titles  WorksheetsNamed Ranges-Service Corps of Retired Executives (SCOREЎ)ўџр…ŸђљOhЋ‘+'Гй08 x