Docstoc

Cash Flow Projection worksheet

Document Sample
Cash Flow Projection worksheet Powered By Docstoc
					                                      Business Name
                          List for Growth or Start-up Expenses
  A.                                     Cash Available Now
       Purchased fixed assets
  1.
       (land, equipment, building, vehicles)
       Remodeling costs
  2.
       (building, fixtures, signs, paint, cleaning)
       Installation fees
  3.
       (equipment, phones, hookup charges)
       Deposits
  4.
       (utilities, lease, phone, leased equipment)
       Fees, licenses, certifications
  5.
       Special one-time legal fees
  6.
       (specifically for growth/start-up)
       Special accounting / other professional fees
  7.
       Pre-opening labor costs
  8.
       Pre-opening training costs
  9.
       Beginning inventory of merchandise or materials
 10.
       Supplies
 11.
       (letterhead, forms, price tags)
       Promotion
 12.
       (grand opening, prizes, give-aways)
       Advertising
 13.
       (initial media, direct mail, coupons)
 14.
       Working Capital
 15.
       Other Expenses:
 16.

                         Total Growth /or Start-up Expenses
  B.                                          (sum lines 1-16)   $0
                                 (Additional Cash Required)
  C.                                       or Cash Available
                                        (Line A minus Line B)    $0




                                                                 8/20/2012
51fb200a-3f44-4906-90a9-da3952304ce8.xls              1
                                                              Business Name
                                                Monthly Cash Flow Projection Worksheet
For year(s)__________
                                Jan       Feb       Mar       Apr       May       Jun       Jul       Aug       Sep       Oct       Nov       Dec       Total
Beginning Cash Balance                0         0         0         0         0         0         0         0         0         0         0         0           0
Cash Receipts
Cash Sales                                                                                                                                                      0
Collect Accounts Receivable                                                                                                                                     0
Loans or Other                                                                                                                                                  0
Total Cash Receipts                   0         0         0         0         0         0         0         0         0         0         0         0           0

Cash Disbursements
Cost of Goods                                                                                                                                                   0
Gross Wages                                                                                                                                                     0
Payroll Expenses                                                                                                                                                0
Outside Services                                                                                                                                                0
Supplies (Office & Operating)                                                                                                                                   0
Repairs and Maintenance                                                                                                                                         0
Advertising                                                                                                                                                     0
Car, Delivery and Travel                                                                                                                                        0
Accounting and Legal                                                                                                                                            0
Rent                                                                                                                                                            0
Telephone                                                                                                                                                       0
Utilites                                                                                                                                                        0
Insurance                                                                                                                                                       0
Taxes (Real estate, ect.)                                                                                                                                       0
Total Cash Disbursements              0         0         0         0         0         0         0         0         0         0         0         0           0

Net Cash Flow                         0         0         0         0         0         0         0         0         0         0         0         0           0

Adjustments to Net Cash Flow
(+) New Owner Investment                                                                                                                                        0
(-) Old Debt Payment                                                                                                                                            0
(-) New Debt-Loan Paymts                                                                                                                                        0
(-) New Owner Withdrawals                                                                                                                                       0
Adjusted Net Cash Flow                0         0         0         0         0         0         0         0         0         0         0         0           0

Ending Cash Balance                   0         0         0         0         0         0         0         0         0         0         0         0           0



   51fb200a-3f44-4906-90a9-da3952304ce8.xls                                   2                                                                     8/20/2012
                                      Business Name
                          List for Growth or Start-up Expenses
  A.                                     Cash Available Now       $25,000
       Purchased fixed assets
  1.
       (land, equipment, building, vehicles)                      $18,000
       Remodeling costs
  2.
       (building, fixtures, signs, paint, cleaning)                $2,000
       Installation fees
  3.
       (equipment, phones, hookup charges)                           $750
       Deposits
  4.
       (utilities, lease, phone, leased equipment)                   $200
       Fees, licenses, certifications
  5.
                                                                     $300
       Special one-time legal fees
  6.
       (specifically for growth/start-up)                            $500
       Special accounting / other professional fees
  7.
                                                                     $300
       Pre-opening labor costs
  8.
                                                                       $0
       Pre-opening training costs
  9.
                                                                       $0
       Beginning inventory of merchandise or materials
 10.
                                                                   $2,000
       Supplies
 11.
       (letterhead, forms, price tags)                             $1,000
       Promotion
 12.
       (grand opening, prizes, give-aways)                           $500
       Advertising
 13.
       (initial media, direct mail, coupons)                       $2,500
 14.
       Working Capital                                            $50,000
 15.
       Other Expenses:
 16.

                         Total Growth /or Start-up Expenses
  B.                                          (sum lines 1-16)   $78,050
                                 (Additional Cash Required)
  C.                                       or Cash Available
                                        (Line A minus Line B)    ($53,050)




51fb200a-3f44-4906-90a9-da3952304ce8.xls              3                8/20/2012
51fb200a-3f44-4906-90a9-da3952304ce8.xls   4   8/20/2012
                                                                             Business Name
                                                           Monthly Cash Flow Projection Worksheet Sample
For year: 200x
                                     Jan         Feb         Mar         Apr        May         Jun             Jul       Aug        Sep          Oct       Nov       Dec      Total
Beginning Cash Balance (Note 1)     $50,000     $42,854     $44,577     $45,136    $44,592     $42,726        $35,491    $29,278    $28,029      $27,913   $30,326   $33,060    $50,000
Cash Receipts
Cash Sales                             9,730      9,500       9,500       9,000       8,400         8,750      10,300     11,540     12,165       12,165    12,475    12,475   $126,000
Collect Accounts Receivable                0      8,333       8,333       7,733       6,867         7,000       2,333      8,333     10,800       13,533    13,767    13,767   $100,799
Loans or Other
Total Cash Receipts                    9,730     17,833      17,833      16,733      15,267     15,750         12,633     19,873     22,965       25,698    26,242    26,242   $226,799

Cash Disbursements
Cost of Goods                          9,886      9,720      10,584      10,512      10,368     11,340         12,456     14,357     16,391       16,895    17,118    15,894   $155,521
Gross Wages                            1,850      1,850       1,850       1,850       1,850      1,850          1,850      1,850      1,850        1,850     1,850     1,850    $22,200
Payroll Expenses                         185        185         185         185         185        185            185        185        185          185       185       185     $2,220
Outside Services                         100        100         100         100         100        100            100        100        100          100       100       100     $1,200
Supplies (Office & Operating)            300        300         300         300         300        300            300        300        300          300       300       300     $3,600
Repairs and Maintenance                  300        300         300         300         300        300            300        300        300          300       300       300     $3,600
Advertising                            1,000        400         400         400         400      4,555            400        400        400          400       400       400     $9,555
Car, Delivery and Travel                 150        150         150         150         150        150            150        150        150          150       150       150     $1,800
Accounting and Legal                                                        375         375                                  375                                         375     $1,500
Rent                                    750         750         750         750         750        750           750         750         750        750       750        750     $9,000
Telephone                               125         125         125         125         125        125           125         125         125        125       125        125     $1,500
Utilites                                216         216         216         216         216        216           216         216         216        216       216        216     $2,592
Insurance                                                       300                                300                                   300                             300     $1,200
Taxes (Real estate, ect.)                                                                          800                                                                   800     $1,600
Total Cash Disbursements             14,862      14,096      15,260      15,263      15,119     20,971         16,832     19,108     21,067       21,271    21,494    21,745    217,088

Net Cash Flow                        ($5,132)    $3,737      $2,573      $1,470       $148      ($5,221)      ($4,199)     $765      $1,898       $4,427    $4,748    $4,497     $9,711

Adjustments to Net Cash Flow
(+) New Owner Investment                                                                                                                                                             $0
(-) Old Debt Payment                                                                                                                                                                 $0
(-) New Debt-Loan Paymts (Note 2)      1,014      1,014       1,014       1,014       1,014          1,014      1,014      1,014        1,014      1,014     1,014     1,014    $12,168
(-) New Owner Withdrawals              1,000      1,000       1,000       1,000       1,000          1,000      1,000      1,000        1,000      1,000     1,000     1,000    $12,000
Adjusted Net Cash Flow                (7,146)     1,723         559        (544)     (1,866)        (7,235)    (6,213)    (1,249)        (116)     2,413     2,734     2,483   ($14,457)

Ending Cash Balance                 $42,854     $44,577     $45,136     $44,592    $42,726     $35,491        $29,278    $28,029    $27,913      $30,326   $33,060   $35,543    $35,543


Note 1: Beginning Cash Balance is obtained from the Working Capital amount from the "Sample S-Up Exp" worksheet.
Note 2: New Debt-Loan Payments is the monthly principle and interest and is based on amortization of amount borrowed @8% for 5 years.
          The amount borrowed is the Additional Cash Required from the "Sample S-U Exp worksheet.




51fb200a-3f44-4906-90a9-da3952304ce8.xls                                                        5                                                                                8/20/2012

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:66
posted:8/19/2012
language:English
pages:5