Sample Cash Flow Spreadsheet

Document Sample
Sample Cash Flow Spreadsheet Powered By Docstoc
					MONTHLY CASH FLOW FORECAST FOR FIRST YEAR
NAME:
Cash In                        Start Up                                                   Total
Cash from sales                                                                             -
Accounts Receivable                                                                         -
Personal Investment                                                                         -
Loan                                                                                        -
SEB Benefits (if applicable)                                                                -
Total Cash In                      -      -   -   -   -   -   -   -   -   -   -   -   -     -
Cash Out
Cost of Goods Sold                                                                          -
Purchase of Assets                                                                          -
Freight                                                                                     -
Rent                                                                                        -
Utilities/Hydro/heat                                                                        -
Telephone/Internet                                                                          -
Insurance                                                                                   -
Licences & Permits                                                                          -
Loan Payments                                                                               -
Maintenance & Repairs                                                                       -
Vehicle Expenses                                                                            -
Office Supplies                                                                             -
Promotion/Marketing                                                                         -
Banking Expenses                                                                            -
Wages & Deductions                                                                          -
Professional Services                                                                       -
Training/travel                                                                             -
                                                                                            -
                                                                                            -
                                                                                            -
TOTAL EXPENSES                     -      -   -   -   -   -   -   -   -   -   -   -   -     -
Taxes/savings                                                                               -
Owner's Drawings                                                                            -
Total Cash Out                     -      -   -   -   -   -   -   -   -   -   -   -   -     -
Net Cash
Starting Cash Balance                     -   -   -   -   -   -   -   -   -   -   -   -     -
Cash in less Cash Out              -      -   -   -   -   -   -   -   -   -   -   -   -
Ending Cash Balance                -      -   -   -   -   -   -   -   -   -   -   -   -
MONTHLY CASH FLOW FORECAST FOR SECOND YEAR

NAME:
Cash In                                                                 Total
Cash from sales                                                            -
Accounts Receivable                                                        -
Personal Investment                                                        -
Loan                                                                       -
                                                                           -
Total Cash In           -   -   -   -   -   -   -   -   -   -   -   -      -

Cash Out
Cost of Goods Sold                                                         -
Purchase of Assets                                                         -
Freight                                                                    -
Rent                                                                       -
Utilities -hydro/heat                                                      -
Telephone/Internet                                                         -
Insurance                                                                  -
Licences & Permits                                                         -
Loan Payments                                                              -
Maintenance & Repairs                                                      -
Vehicle Expenses                                                           -
Office Supplies                                                            -
Promotion/Marketing                                                        -
Banking Expenses                                                           -
Wages & Deductions                                                         -
Professional Services                                                      -
Training                                                                   -
                                                                           -
                                                                           -
                                                                           -
TOTAL EXPENSES          -   -   -   -   -   -   -   -   -   -   -   -      -
Taxes/savings                                                              -
Owner's Drawings                                                           -
Total Cash Out          -   -   -   -   -   -   -   -   -   -   -   -      -

Net Cash
Starting Cash Balance       -   -   -   -   -   -   -   -   -   -   -      -
Cash in less Cash Out   -   -   -   -   -   -   -   -   -   -   -   -
Ending Cash Balance     -   -   -   -   -   -   -   -   -   -   -   -
MONTHLY CASH FLOW FORECAST FOR THIRD YEAR

NAME:
Cash In                                                                 Total
Cash from sales                                                            -
Accounts Receivable                                                        -
Personal Investment                                                        -
Loan                                                                       -
                                                                           -
Total Cash In           -   -   -   -   -   -   -   -   -   -   -   -      -

Cash Out
Cost of Goods Sold                                                         -
Purchase of Assets                                                         -
Freight                                                                    -
Rent                                                                       -
Utilities -hydro/heat                                                      -
Telephone/Internet                                                         -
Insurance                                                                  -
Licences & Permits                                                         -
Loan Payments                                                              -
Maintenance & Repairs                                                      -
Vehicle Expenses                                                           -
Office Supplies                                                            -
Promotion/Marketing                                                        -
Banking Expenses                                                           -
Wages & Deductions                                                         -
Professional Services                                                      -
Training                                                                   -
                                                                           -
                                                                           -
                                                                           -
TOTAL EXPENSES          -   -   -   -   -   -   -   -   -   -   -   -      -
Taxes/savings                                                              -
Owner's Drawings                                                           -
Total Cash Out          -   -   -   -   -   -   -   -   -   -   -   -      -

Net Cash
Starting Cash Balance       -   -   -   -   -   -   -   -   -   -   -      -
Cash in less Cash Out   -   -   -   -   -   -   -   -   -   -   -   -
Ending Cash Balance     -   -   -   -   -   -   -   -   -   -   -   -
             PROFORMA INCOME AND EXPENSE STATEMENT

                         FOR                                      -


                                   YEAR 1       YEAR 2       YEAR 3
INCOME
 Sales
 Cost of Sales                                                        [enter as a negative]
 Gross Profit                  $        -   $        -   $        -


EXPENSES
 Freight
 Rent
 Utilities -hydro/heat
 Telephone/Internet
 Insurance
 Licences & Permits
 Loan Interest
 Maintenance & Repairs
 Vehicle Expenses
 Office Supplies
 Promotion/Marketing
 Banking Expenses
 Wages & Deductions
 Professional Services
 Training




 Total Expenses                $        -   $        -   $        -


NET PROFIT                     $        -   $        -   $        -


 Income Tax & CPP                                                     [enter as a negative]


 SEB Benefits
 Owners Drawings                                                      [enter as a negative]


BALANCE                        $        -   $        -   $        -

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:114
posted:8/7/2012
language:Unknown
pages:4