craft3-childcare-cashflow

Document Sample
craft3-childcare-cashflow Powered By Docstoc
					                                                                                                                            Craft3
                                                                                                                Childcare Cashflow Worksheet

     Business Name:_________________________                                                      Monthly Cash Flow Projection Worksheet                                                                      Prepared By:_____________________Date:_____________
                                                                                                  Cells in blue will be automatically calculated

                                                                 Start-up       Month 1           Month 2           Month 3           Month 4           Month 5           Month 6           Month 7           Month 8           Month 9           Month 10       Month 11       Month 12
 2   Number of infants - private pay
 3   Number of infants - with subsidy
 4   Number of toddlers - private pay
 5   Number of toddlers - with subsidy
 6   Number of pre-schoolers - private pay
 7   Number of pre-schoolers - with subsidy
 8   Number of school-age children - private pay
 9   Number of school-age children - with subsidy
10   Total number of children (add lines 2 - 9)                                               0                 0                 0                 0                 0                 0                 0                 0                 0              0              0              0
11   Beginning Cash Balance                                                     $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
12   Revenues                                     Monthly Rate
13   Tuition rate - infants - private pay         $        -                    $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
14   Tuition rate - infants - with subsidy        $        -                    $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
15   Tuition rate - toddlers - private pay        $        -                    $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
16   Tuition rate - toddlers - with subsidy       $        -                    $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
17   Tuition rate - preschoolers - private pay    $        -                    $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
18   Tuition rate - preschoolers - with subsidy   $        -                    $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
19   Tuition rate - school age - private pay      $        -                    $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
20   Tuition rate - school age - with subsidy     $        -                    $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
21   Food program revenues
22   Registration and other fees
23   Total Revenues (add lines 13 - 22)                                         $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
24
25 Expenses
26 Directors Salary
27 Teachers and staff salaries
28 Non-teaching salaries/wages
29 Owner's draw or salary
30 Payroll taxes and benefits (employees)
31 Payroll taxes and benefits (owner)
32 Telephone and Utilities
33 Mortgage/Rent
34 Property Insurance/Taxes
35 Repairs & Maintenance
36 Food costs
37 Educational supplies/equipment
38 Insurance
39 Advertising
40 License Fees and Dues
41 Transportation
42 Training
43 Office Supplies/Equipment
44 Accounting and Legal
45 Non-Craft3 loan payments
46 Other Expenses (please list separately)
47 Total Expenses (add lines 26-46)                                             $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
48 Net Profit (loss) subtract line 47 from line 23                              $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -
   Craft3 Loan Amount                                            $          -
49 Craft3 Loan Payment
50 Ending Cash Balance (line 11+48-49)                           $          -   $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $         -       $      -       $      -       $      -




           b1b9ac33-6557-416b-8979-849a1b3f9577.xls
           Last updated December 2011

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:5/16/2012
language:
pages:1
fanzhongqing fanzhongqing http://
About