Cashflow Forecast Template - Excel by demandmetric

VIEWS: 4,372 PAGES: 3

More Info
									                                                                                                                                        Cash Flow - Projection



                                               Q1 2008               Q2 2008               Q3 2008                Q4 2008

                                         Jan    Feb      Mar   Apr    May      Jun   Jul    Aug      Sept   Oct    Nov      Dec   2008          Comments
Cash on Hand                             $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0

CASH RECEIPTS
Cash Sales                               $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Collections from CR Firms                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Load/Other Cash Injection                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Total Cash Receipts                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Total Cash Available (before cash out)   $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0

CASH PAID OUT
Purchases (merchandise)                  $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Purchases (specify)                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Purchases (specify)                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Gross wages (exact withdrawal)           $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Payroll expenses (taxes, etc.)           $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Outside services                         $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Supplies (office & oper.)                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Repairs & maintenance                    $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Advertising                              $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Car, delivery & travel                   $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Accounting & legal                       $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Rent                                     $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Telephone                                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Utilities                                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Insurance                                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Taxes (real estate, etc.)                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Interest                                 $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Other expenses (specify)                 $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Other (specify)                          $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Other (specify)                          $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Miscellaneous                            $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Subtotal                                 $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Loan principal payment                   $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Capital purchase (specify)               $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Other startup costs                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Reserve and/or Escrow                    $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Owners' Withdrawal                       $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
TOTAL CASH PAID OUT                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
CASH POSITION (END OF MONTH)             $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0

ESSENTIAL OPERATING DATA
Sales Volume (dollars)                   $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Accounts Receivable                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Bad Debt (end of month)                  $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Inventory on hand (eom)                  $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Accounts Payable (eom)                   $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Depreciation                             $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
                                                                                                                                         Cash Flow - Actual



                                               Q1 2008               Q2 2008               Q3 2008                Q4 2008

                                         Jan    Feb      Mar   Apr    May      Jun   Jul    Aug      Sept   Oct    Nov      Dec   2008       Comments
Cash on Hand                             $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0

CASH RECEIPTS
Cash Sales                               $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Collections from CR Firms                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Load/Other Cash Injection                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Total Cash Receipts                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Total Cash Available (before cash out)   $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0

CASH PAID OUT
Purchases (merchandise)                  $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Purchases (specify)                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Purchases (specify)                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Gross wages (exact withdrawal)           $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Payroll expenses (taxes, etc.)           $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Outside services                         $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Supplies (office & oper.)                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Repairs & maintenance                    $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Advertising                              $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Car, delivery & travel                   $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Accounting & legal                       $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Rent                                     $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Telephone                                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Utilities                                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Insurance                                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Taxes (real estate, etc.)                $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Interest                                 $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Other expenses (specify)                 $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Other (specify)                          $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Other (specify)                          $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Miscellaneous                            $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Subtotal                                 $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Loan principal payment                   $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Capital purchase (specify)               $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Other startup costs                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Reserve and/or Escrow                    $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Owners' Withdrawal                       $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
TOTAL CASH PAID OUT                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
CASH POSITION (END OF MONTH)             $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0

ESSENTIAL OPERATING DATA
Sales Volume (dollars)                   $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Accounts Receivable                      $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Bad Debt (end of month)                  $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Inventory on hand (eom)                  $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Accounts Payable (eom)                   $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
Depreciation                             $0      $0      $0    $0      $0      $0    $0      $0       $0    $0      $0      $0     $0
                                                                                                                                                                                      Cash Flow - Analysis

Note: This page will automatically calculate the difference between Actual Cash Flow and Cash Flow Projections.

                                                                    Q1 2008                                       Q2 2008               Q3 2008                Q4 2008

                                                         Jan           Feb            Mar            Apr           May      Jun   Jul    Aug      Sept   Oct    Nov      Dec   2008         Comments
   Cash on Hand                                           $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0

   CASH RECEIPTS
   Cash Sales                                             $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Collections from CR Firms                              $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Load/Other Cash Injection                              $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Cash Receipts (Difference)                             $0             $0            $0             $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Total Cash Available (before cash out)                 $0             $0            $0             $0            $0      $0    $0      $0       $0    $0      $0      $0

   CASH PAID OUT
   Purchases (merchandise)                                $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Purchases (specify)                                    $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Purchases (specify)                                    $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Gross wages (exact withdrawal)                         $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Payroll expenses (taxes, etc.)                         $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Outside services                                       $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Supplies (office & oper.)                              $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Repairs & maintenance                                  $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Advertising                                            $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Car, delivery & travel                                 $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Accounting & legal                                     $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Rent                                                   $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Telephone                                              $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Utilities                                              $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Insurance                                              $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Taxes (real estate, etc.)                              $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Interest                                               $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Other expenses (specify)                               $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Other (specify)                                        $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Other (specify)                                        $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Miscellaneous                                          $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Difference                                             $0             $0            $0             $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Loan principal payment                                 $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Capital purchase (specify)                             $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Other startup costs                                    $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Reserve and/or Escrow                                  $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Owners' Withdrawal                                     $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   TOTAL CASH PAID OUT                                    $0             $0            $0             $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   CASH POSITION (END OF MONTH)                           $0             $0            $0             $0            $0      $0    $0      $0       $0    $0      $0      $0

   ESSENTIAL OPERATING DATA
   Sales Volume (dollars)                                 $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Accounts Receivable                                    $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Bad Debt (end of month)                                $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Inventory on hand (eom)                                $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Accounts Payable (eom)                                 $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0
   Depreciation                                           $0             $0             $0            $0            $0      $0    $0      $0       $0    $0      $0      $0     $0

								
To top