Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Get this document free

Cash Flow Forecast

VIEWS: 707 PAGES: 3

This document provides collective data regarding all of the cash inflows a company receives from both its ongoing operations and external investment sources, as well as all cash outflows that pay for business activities and investments. The cash flow statement is critical to any business, as even profitable companies can suffer cash flow problems. This template worksheet allows the user to enter a starting cash balance, cash sales from the company's income statement, and cash receivables and expenditure from the company's balance sheet. A sales tax rate can also be included. Companies should use this form to calculate their available cash balance.

More Info
									Guidelines
This document provides collective data regarding all of the cash inflows a company receives from
both its ongoing operations and external investment sources, as well as all cash outflows that pay
for business activities and investments. Even profitable companies can fail to adequately manage
their cash flow, which is why the cash flow statement is important: it helps investors see if a
company is having trouble with cash.


1.   Enter starting cash balance in cell B3.
2.   Cash Sales can be sourced from your income statement.
3.   Cash receivables and Expenditures can be sourced from your balance sheet.
4.   Insert sales tax rate, if applicable, based on your state tax rate into cell B12.




© Copyright 2013 Docstoc Inc.
Cash Flow Forecast
                                               Starting Cash   Month 1    Month 2    Month 3    Month 4    Month 5    Month 6    Month 7    Month 8    Month 9    Month 10    Month 11    Month 12        Year 1
Cash Received                                        50,000

Cash from Operations
Cash Sales                                                       $200       $200       $200       $200       $200       $200       $200       $200       $200        $200        $200         $200        $2,400
Cash from Receivables                                            $200       $200       $200       $200       $200       $200       $200       $200       $200        $200        $200         $200        $2,400
Subtotal Cash from Operations                                    $400       $400       $400       $400       $400       $400       $400       $400       $400        $400        $400         $400        $4,800

Additional Cash Received
Non Operating (Other) Income                                       $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0            $0
Sales Tax, VAT, HST/GST Received                     8.10%        $32        $32        $32        $32        $32        $32        $32        $32        $32         $32         $32          $32          $389
New Current Borrowing                                              $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0            $0
New Other Liabilities (interest-free)                              $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0            $0
New Long-term Liabilities                                          $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0            $0
Sales of Other Current Assets                                      $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0            $0
Sales of Long-term Assets                                          $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0            $0
New Investment Received                                            $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0            $0
Subtotal Cash Received                                           $432       $432       $432       $432       $432       $432       $432       $432       $432        $432        $432         $432        $5,189

Expenditures                                                   Month 1    Month 2    Month 3    Month 4    Month 5    Month 6    Month 7    Month 8    Month 9    Month 10    Month 11     Month 12       Year 1

Expenditures from Operations
Payroll                                                          $500       $500       $500       $500       $500       $500       $500       $500       $500        $500        $500         $500        $6,000
Bill Payments                                                      $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0            $0
Subtotal Spent on Operations                                     $500       $500       $500       $500       $500       $500       $500       $500       $500        $500        $500         $500        $6,000

Additional Cash Spent
Non Operating (Other) Expense                                    $250       $250       $250       $250       $250       $250       $250       $250       $250        $250        $250         $250       $3,000
Sales Tax, VAT, HST/GST Paid Out                                  $32        $32        $32        $32        $32        $32        $32        $32        $32         $32         $32          $32         $389
Principal Repayment of Current Borrowing                           $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0           $0
Other Liabilities Principal Repayment                              $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0           $0
Long-term Liabilities Principal Repayment                          $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0           $0
Purchase Other Current Assets                                      $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0           $0
Purchase Long-term Assets                                          $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0           $0
Loans                                                              $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0     $250,000     $250,000
Dividends                                                          $0         $0         $0         $0         $0         $0         $0         $0         $0          $0          $0           $0           $0
Subtotal Cash Spent                                              $782       $782       $782       $782       $782       $782       $782       $782       $782        $782        $782     $250,782     $259,389

Net Cash Flow                                                    ($350)     ($350)     ($350)     ($350)     ($350)     ($350)     ($350)     ($350)     ($350)      ($350)      ($350)   ($250,350)   ($254,200)
Cash Balance                                                   $49,650    $49,300    $48,950    $48,600    $48,250    $47,900    $47,550    $47,200    $46,850     $46,500     $46,150    ($204,200)   ($204,200)

Additional Notes:




               © Copyright 2013 Docstoc Inc.
© Copyright 2013 Docstoc Inc.
								
To top