Docstoc

xls

Document Sample
xls Powered By Docstoc
					Here’s a form you can use to work out your cash flow forecast. It uses the Excel program to do the calculations for you.
1. In the lines under the heading “Cash in-flow items”, type in the types of income you will receive.
2. Then for each type of payment you get, enter in the amount you expect to get each month.
3. Do the same for “Cash out-flow items”. Under the heading, type in the names of the types of payments you’ll have to make.
4. Then for each type of payment, enter in the amount you expect to pay out each month.
5. If you have any capital expenditure items, enter those under the heading “Capital expenditure” and enter the amounts you expect to pay out each month.
6. Enter how much you have in the bank in the first space to the right of the heading “Bank balance at the beginning of the month”.
7. The program will do all the calculations for you.
If you need to add more lines under any of the headings, click on any of the lines or rows underneath the heading then click on the “Insert” button at the top of your screen. Then click on “Rows” and the
program will put in another line for you and adjust all the calculations.

If you change your mind, you can click on the button with the undo arrow (it points to the left) as long as you do it straight away. If you want to take out any lines later, click anywhere on the line or row you
want to take out, then click on the “Edit” button at the top of the screen. Next click on “Delete” and then on “Entire Row”. The program will take out the whole line and adjust the calculations for you.
For the document to print on one page Go to Page Setup and click on "Landscape" and "Fit to page".

                                                                                                  Cash flow forecast




                                                                                                                                                                Month 10




                                                                                                                                                                             Month 11




                                                                                                                                                                                          Month 12
                                        Month 1




                                                     Month 2




                                                                  Month 3




                                                                                Month 4




                                                                                             Month 5




                                                                                                           Month 6




                                                                                                                        Month 7




                                                                                                                                     Month 8




                                                                                                                                                  Month 9




                                                                                                                                                                                                            total
                                                                                                                                                                                                       Category
                         Month name

Item
Cash in-flow items
   …                                                                                                                                                                                                   $0
   …                                                                                                                                                                                                   $0
Total cash in-flow                     $0            $0           $0           $0            $0            $0          $0            $0           $0           $0           $0            $0           $0

Cash out-flow items
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
  …                                                                                                                                                                                                    $0
Sub-total cash out-flow                $0            $0           $0           $0            $0            $0          $0            $0           $0           $0           $0            $0           $0


Capital expenditure
   …                                                                                                                                                                                                   $0
   …                                                                                                                                                                                                   $0
Total cash out-flow                    $0            $0           $0           $0            $0            $0          $0            $0           $0           $0           $0            $0           $0

Net cash flow (= total cash in-  $0                  $0           $0           $0            $0            $0          $0            $0           $0           $0           $0            $0           $0
flow minus total cash out-flow)
Bank balance at beginning of the                     $0           $0           $0            $0            $0          $0            $0           $0           $0           $0            $0
month
Bank balance at the end of the   $0                  $0           $0           $0            $0            $0          $0            $0           $0           $0           $0            $0
month (= beginning bank balance
plus or minus the net cash flow)

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:315
posted:7/17/2011
language:English
pages:1