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 2011 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 2011 Docstoc Inc.
© Copyright 2011 Docstoc Inc.