Weekly Cash Flow Projection by shuifanglj

VIEWS: 33 PAGES: 1

									Weekly Cash Flow Projection
Your Company Name

Month: July, 2010

Use this calculator to project your weekly cash flow for a month.
Enter the date of the first Monday of the month into the first date heading
The other date headings automatically display the successive weeks (or blank if the month ends in a previous week)
Replace the figures in this illustration with your own. You can only enter figures in the unshaded boxes.
You can change the names of the rows to suit your business.



                  CASH RECEIVED                   26-Jun          3-Jul           10-Jul           17-Jul            24-Jul       31-Jul
Beginning Cash Balance                               £50,000        £48,500          £21,500          £33,000          £39,000      £55,500
Cash Sales                                           £25,000        £20,000          £32,000          £28,000          £36,000      £40,000
Receivables Collected                                £20,000        £30,000          £45,000          £30,000          £35,000      £40,000
Other Cash Received                                                                                                    £10,000      £18,908
                         Total Cash Available       £95,000        £98,500         £98,500           £91,000         £120,000     £154,408


                    OUTGOINGS
Salaries and Wages                                   £15,000        £15,000          £15,000          £15,000          £15,000      £15,000
Rent/Mortgage                                                       £12,000
Insurance                                                           £10,000
Office Supplies                                       £5,000         £3,000           £3,500           £3,000           £3,000       £4,000
Utilities                                                            £3,000                                             £2,500
Repairs and Maintenance                               £4,000         £4,000           £4,000           £5,000           £5,000       £4,000
Operating Supplies                                    £3,000         £4,000           £4,000           £3,000           £4,000       £3,000
Professional Fees                                                                                                       £2,000
Commissions
Travel and Entertainment                              £1,500         £1,500           £2,000           £3,000           £2,500       £1,500
Purchases                                             £4,000         £4,000           £4,000           £4,000           £4,000       £4,000
Advertising                                           £2,500         £2,500           £2,500           £2,500           £2,500       £2,500
Delivery Costs                                        £1,500         £1,500           £1,500           £1,500           £1,500       £1,500
Purchase of Capital Assets                            £6,000                                           £5,000
Loan Payments with Interest                                         £10,000                                             £1,500
Dividends Paid                                                                                                                       £7,500
Other Cash Disbursed                                 £12,000         £8,000           £9,000          £10,000           £1,000       £7,000
                                Total Outgoings     £54,500        £78,500         £45,500           £52,000          £44,500      £50,000


                  CASH POSITION
                                                                                                                                                Outgoings are entered as
Balance Before Financing                             £40,500        £20,000          £53,000          £39,000          £75,500     £104,408
                                                                                                                                                negative amounts and will
Loan Received / (Repayment)                          (£2,000)                                                                       (£50,000)
Securities Sold / (Purchased)                        £10,000                        (£20,000)                         (£20,000)
Shares Issued / (Repurchased)
Other Funds Received / (Disbursed)                                   £1,500
                        End Of Month Balance        £48,500        £21,500         £33,000           £39,000          £55,500      £54,408

								
To top