Waterloo Region Assets Program

Instruction on completing the Cashflow Statement step by step

Step 1 (PURPLE AREA) In cell A1, replace XXXXX with your name or your business name

Step 2 Change any descriptions in column A to suit your business

Step 3 (GREEN AREA) Start-up – enter owner’s investment & amount of loans, shown in your business plan, in cells C9 & C10

Step 4 (GREEN AREA) Start-up costs – enter start-up costs identified in your business plan in cell C37

Step 5 (ORANGE AREA) Change Mth 1 , Mth 2 etc to actual months, starting with, when you plan to start your business - Ie Mth1 to May, Mth 2 to June etc or Mth 1 to Jan, Mth 2 to Feb etc

Step 6 (GREY AREA) Change cell A3 to match your business cycle - ie May 1/07 to April 30/08 or January 1/07 to December 31/07 etc.

Step 7 (RED AREA) Enter units sold per month, estimated in your business plan, in cells D6 to O6

Step 8 (YELLOW AREA) Enter sales unit price, calculated in your business plan, in cell B11 – numbers will automatically multiply across using the information entered in cells D6 to O6

Step 9 (YELLOW AREA) Enter variable costs, calculated in your business plan, in cells B18 to B24 – numbers will automatically multiply across using the information entered in cells D6 to O6

Step 10 (LIGHT BLUE AREA) Enter monthly overhead costs, identified in your business plan, in cells B28 to B36 – these numbers will automatically be filled in for each month. If you want to adjust your overhead costs to account for seasonal trends, you can put a different amount for any particular month but it will replace the formula and will not automatically copy the amount from column B. The total column will still automatically add the numbers for you provided you don’t manually enter a number in the last column.