Monthly Expence Business Work Sheet by tkp18188

VIEWS: 23 PAGES: 19

More Info
									                                                     Copyright Statement
                                                 Last Updated January 2010
This Excel workbook (Cash Flow Forecasting 2010) is owned and maintained by Brant Community Futures Development
Corporation o/a Enterprise Brant. The information in the Cash Flow Forecasting 2010 workbook is provided as a service to our
clients.
However, the entire content (text, graphics, and/or images) of this workbook is protected by copyright and may not be
modified, reused, reposted, distributed, downloaded, or otherwise used, in whole or in part, except as provided herein,
without the express written permission of Enterprise Brant.
You may download content, or print copies of the information, only for your own personal, noncommercial use. All other
rights are reserved.



The first step is Save this Excel Workbook with a name that is unique to you. Such as “ABC Machine Cash Flow Forecast”.
Make it descriptive and something you will immediately remember. You could also save three copies once you have input all
the data required.
         > Optimistic Forecast for ABC Machine
         > Expected Forecast for ABC Machine
         > Pessimistic Forecast for ABC Machine
In doing this you will have three views that can direct your actions should circumstances change.

Next is to print out the Word document "Cash Flow Forecasting Guide" and read through it to get a feel for the process. We
recommend that as you read through you open the various Steps in the workbook.

Now you are ready to start forecasting - wrong! First thing to do is collect all your data. As you went through the Guide you
should have realized that you may have to do a little more digging to get all the information your require.
When you are ready have the guide open beside you as you work through each step.

Once you start you may encounter problems; don't hesitate you contact your consultant or email info@enterprisebrant.com
for help. The most challenging step is Step 6 Data Input - don't get discouraged we can help you.

                                      Make sure you save your work regularly
                                                                            BEFORE YOU BEGIN COMPLETE THE INFORMATION BELOW

Please input the following data as it will be used to complete your Cash Flow Forecast

                               Your Name: (First, Last)
                            Date Prepared: (dd/mmm/yy)
                           Business Name:

                Year 1 of your cash flow:         Format is: 2010                                   Remember this is a forecast so the starting
     Month you are starting your forecast:        Format is: SEP                                    month will be for a date in future. Do not
                                                                                                    include past months in your forecast.
         How Much Equipment do you have in place now? $                 -   This represents the intial investment in the
                   How much Inventory do you have now? $                -   buisness and can include vehicles any
           Total Inventory and Equipment:              $                -   assest.
       How much cash Equity are you investing?

                   LOAN INFORMATION                             Stat-up         0                                                                     TOTAL
Loan 1 - Enterprise Brant                                                                                                                         $       -
Loan 2 -                                                                                                                                          $       -
Loan 3 -                                                                                                                                          $       -

                                                     0              1
       What is your goal for sales?




                                                                                                       219
C:\Docstoc\Working\pdf\5308d0c4-4ff5-4579-9b5e-8c49373c374c.xls5308d0c4-4ff5-4579-9b5e-8c49373c374c.xlsSTEP 2 - USER DATA                              4/13/2011
                                         PERSONAL EXPENSE LIST
                                             Prepared by: 0
                                                     For: 0

            Use the following form to determine your personal/household expenses on a monthly
            and annual basis Out of your total obligations, how much is being met from other
            sources? (e.g.. Spouse, Government benefits, Investment income, rental income, part-
            time work).

                        MONTHLY EXPENSE ITEMS                       MONTHLY             ANNUAL
            Rent or Mortgage Payment                                                $              -
            Property Taxes                                                          $              -
            Home Insurance & Maintenance                                            $              -
            Utilities - Hydro                                                       $              -
            Utilities - Heat                                                        $              -
            Utilities - Cable TV                                                    $              -
            Telephone & Internet                                                    $              -
            Groceries                                                               $              -
            Clothing                                                                $              -
            Daycare                                                                 $              -
            Recreation/Sports                                                       $              -
            Travel & Entertainment                                                  $              -
            Retirement Savings                                                      $              -
            Recreation / memberships                                                $              -
            Vehicle Operation                                                       $              -
            Vehicle Payments                                                        $              -
            Vehicle Insurance                                                       $              -
            Loan Payments                                                           $              -
            Credit Card Payments                                                    $              -
            Health Care/Prescriptions                                               $              -
            Alimony and Child Support                                               $              -
            Other                                                                   $              -
            Other                                                                   $              -
            Total Expenses                                      $             -     $              -

                                             Deduct other Income sources:
                Spouse's net earnings (after tax)                                   $              -
                Government benefits                                                 $              -
                Child support benefits                                              $              -
                All other net income -                                              $              -
            Total Other Income Sources                           $            -     $              -

            Difference = Drawings Required (Year 1)             $            -     $                -
                                                                   Monthly             Annually
            Based on your anticipated business income, can you afford to be this business at this time?
                   Percent increase in Draw (set your rate here)            1.05
            Drawings (Year 2)                                    $           -     $                -




C:\Docstoc\Working\pdf\5308d0c4-4ff5-4579-9b5e-8c49373c374c.xls5308d0c4-4ff5-4579-9b5e-
8c49373c374c.xlsSTEP 3 - Personal Expenses       Page 3                                                   4/13/2011
                                           If at anytime you need assistance in completing this section please email
                                           info@enterprisebrant.com and one of our business consultants will contact you
                                           to provide free assistance.

      YEAR         0
    MONTHS         0           0           0           0           0           0           0           0           0           0           0           0           Total

Owners' Salary $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $      -
     Bonuses                                                                                                                                                   $      -
    Dividends                                                                                                                                                  $      -

   Totals      $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $      -



        YEAR       1
                   0           0           0           0           0           0           0           0           0           0           0           0           Total

Owners' Salary $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $      -
     Bonuses                                                                                                                                                   $      -
    Dividends                                                                                                                                                  $      -

   Totals      $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $      -


               This sheet reflects all the money's the owners/principals intent to take from the company. Draws can be salary or any other form of
               regular withdrawl of funds for personal use.
                 Business Start Up / Funds from Loans Capital Plan
                            Prepared by:    0
                                    For:    0

      Start up or Use of Funds from Loans (Record Equipment and Supplies required for start-up)
                    Description                 Price    Qty   Installation       $ Cost

          Website Development                             1                   $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                                                              $            -
                                  Total                                       $            -




C:\Docstoc\Working\pdf\5308d0c4-4ff5-4579-9b5e-8c49373c374c.xls5308d0c4-4ff5-4579-9b5e-
8c49373c374c.xlsSTEP 4 - Startup Costs             519                                         4/13/2011
                                                                                             Marketing Plan
             Prepared by:          0
                     For:          0

         Activity                      0                 0           0           0            0           0           0           0           0           0           0           0           Total

                                                                                                      Year 1
Website Hosting                $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
  Web Maint & Optimization     $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Business Cards                 $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Flyers                         $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
              Canada Post      $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Diabetes Fund Raiser           $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Fescui Golf Course Fund        $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Yellow Pages                   $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Newspaper Advertising          $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
               Publications    $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Gift Cards                     $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Signage                        $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Vehicle Signage                $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Gift Bags                      $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
Memberships
     Chamber of Commerce       $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
                               $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
                               $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
                               $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
                               $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
                               $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
                               $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
                               $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
                               $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
                               $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -
                               $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -

       Grand Totals            $           -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -

                                                                                                      Year 2
                      Factor                   1.2

          Year 2 Forecast $                -         $       -   $       -   $       -   $        -   $       -   $       -   $       -   $       -   $       -   $       -   $       -   $       -




                                                                                619
C:\Docstoc\Working\pdf\5308d0c4-4ff5-4579-9b5e-8c49373c374c.xls5308d0c4-4ff5-4579-9b5e-8c49373c374c.xlsSTEP 5 Marketing Plan                                                                  4/13/2011
                                                                   DATA INPUT SHEET
                            Prepared by:        0
                                    For:        0

                                                Estimated (Orders or Clients or Product or Service) - (insert name)     Year 1            Year 2              Year 1          Year 2
           Revenue Sources                      Your Descriptor (information is for sample only input your data
                                                                                                                       % of Sales        % of Sales       Sales Goal $ Sales Goal $
                                                in the yellow boxes)
Estimated Clients/Orders Source # 1         =   Revenue Source #1                                                                                            #DIV/0!          #DIV/0!
Estimated Clients/Orders Source # 2         =   Revenue Source #2                                                                                            #DIV/0!          #DIV/0!
Estimated Clients/Orders Source # 3         =   Revenue Source #3                                                                                            #DIV/0!          #DIV/0!
Estimated Clients/Orders Source # 4         =   Revenue Source #4                                                                                            #DIV/0!          #DIV/0!
                                                                       Total Unit Sales %%% ( must equal 100%)                     0%               0%       #DIV/0!          #DIV/0!

                                                                                                                       Year1 $$       Year 2 $$              Year 1           Year 2
         Selling Price Per Unit                                Enter your selling price per unit item
                                                                                                                        Selling Price per unit              Unit Sales       Unit Sales
Estimated Selling Price Source #1           =   Revenue Source #1
Estimated Selling Price Source #2           =   Revenue Source #2
Estimated Selling Price Source #3           =   Revenue Source #3
Estimated Selling Price Source #4           =   Revenue Source #4
                                                                                               Average Selling Price    #DIV/0!           #DIV/0!                        0                0

                                         Building Your Sales Forecast                                                    Year 1            Year 2         Each Month You must Avg
Number of business days per week          = How many days a week are you going to do business                                                                this many unit sales
Number of business weeks per year         = How many weeks a year will you work (allow for holidays)                                                           0.0           0.0
Deduct Statutory Holidays                 = Deduct Stat holidays (Normally 10 in Ontario)
Number of days worked per year            = Number of days worked per year                                                          0                 0
Average Price for all Revenue Sources     = You must first input in Revenue Sources and Estimated Revenue               #DIV/0!           #DIV/0!         This is a good place to play
Average Number of sales per day           = How many clients/Services or products will you bill daily                                                     "what if" scenarios. What if I
                                                                                Your Estimated Sales Forecast           #DIV/0!           #DIV/0!         increase my price on #1?
                                                                                                                                                          What if we had 20% more
                                                 Aged Receivables                                                      Year 1 %          Year 2 %         sales.
What percent of your clients pay at time of purchase? (Paid from 0 - 30 days)
                                                                                                                                                          This worksheet is perhaps
What percent of your clients pay in 31 to 60 days? Will this change in year 2?
                                                                                                                                                          the most confusing but it is
What percent of your clients pay in 61 to 90 days? Do you have any plans to change this in Year 2?
What percent of your clients pay in 91 to 120 days - How will this change in year two?
                                                                                                                                                          the most helpful in getting
What percent of your clients pay in over 120 days? - These are doubtful get on them!                                                                      control of your plan and your
                                                       Total                                                                  0.0%             0.0%       business.

          Direct Material Cost                      What is the Percent of Sales your material represents?             % of Sales        % of Sales
     Direct Material Expense - Source # 1   =   Revenue Source #1
     Direct Material Expense - Source # 2   =   Revenue Source #2
     Direct Material Expense - Source # 3   =   Revenue Source #3
     Direct Material Expense - Source # 4   =   Revenue Source #4


          Direct Labour Expence                         Average Direct Exp - Direct Labour costs % of Sales             #DIV/0!           #DIV/0!
          Direct expense - Wages labour         Set your direct labour rate as a % of sales.
      Employer remittances labour & staff       This is the normal factor for this and should remain unchanged                    0.15          0.15
     If at anytime you need assistance in completing this section please email info@enterprisebrant.com and one of our business consultants will contact you to provide
     free assistance.


                                                                            Seasonal Index Year 1

                                                         Input the "Percent of Sales" per product line per month
                                          0          0          0           0          0          0          0          0           0          0          0          0        Total
Revenue Source #1                                                                                                                                                                  0.0%
Revenue Source #2                                                                                                                                                                  0.0%
Revenue Source #3                                                                                                                                                                  0.0%
Revenue Source #4                                                                                                                                                                  0.0%



                                                                            Seasonal Index Year 2

                                                         Input the "Percent of Sales" per product line per month
                                          0          0          0           0          0          0          0          0           0          0          0          0        Total
Revenue Source #1                                                                                                                                                                  0.0%
Revenue Source #2                                                                                                                                                                  0.0%
Revenue Source #3                                                                                                                                                                  0.0%
Revenue Source #4                                                                                                                                                                  0.0%




   In this sheet you can input the percent of business you expect to have in each month by each revenue source. For instance if you had a landscaping business and in the winter
   did snow removal then you would have sales for landscaping in the summer months and snow removal in the winter. Forecasting this way will greatly improve the accuracy of
   your cash flow forecast. NOTE: Your total percentages must total to 100%.
                                                                                                 CASH FLOW FORECAST
                                              Client Name:        0                                                         Business Name :       0
                                           Date prepared:         0-Jan-00                                                                                                          Target Unit Sales / Month               0
                              Year for Start of Cash Flow:           0           Month:       0-Jan                                                                           Forecast Average Sales / month            -
            Clients/Orders/Units                 Start up            J           J              J         J             J            J                J           J           J           J             J           J           Total
    Total Estimated Unit Sales / month              0%                 -           -              -           -              -           -                -           -         -           -             -             -           -
 Revenue Source #1                                       0%   0              0            0           0           0              0            0               0           0          0            0             0                   -
 Revenue Source #2                                       0%   0              0            0           0           0              0            0               0           0          0            0             0                   -
 Revenue Source #3                                       0%   0              0            0           0           0              0            0               0           0          0            0             0                   -
 Revenue Source #4                                       0%   0              0            0           0           0              0            0               0           0          0            0             0                   -
            Estimated Revenue:
 Revenue Source #1                             $        -              -           -              -           -              -           -                -           -         -            -           -              -           -
 Revenue Source #2                             $        -              -           -              -           -              -           -                -           -         -            -           -              -           -
 Revenue Source #3                             $        -              -           -              -           -              -           -                -           -         -            -           -              -           -
 Revenue Source #4                             $        -              -           -              -           -              -           -                -           -         -            -           -              -           -
         Total Estimated Revenue                                       -           -              -           -              -           -                -           -         -            -           -              -           -
             Revenue Receipts:
 Cash from sales (within 30 days)                        0%            -           -              -           -              -           -                -           -         -            -           -              -           -
 Cash from A/R (Paid in 31 - 60 days)                    0%            -           -              -           -              -           -                -           -         -            -           -              -           -
 Cash from A/R (Paid 61 - 90 days)                       0%            -           -              -           -              -           -                -           -         -            -           -              -           -
 Cash from A/R (Paid 91 - 120 days)                      0%            -           -              -           -              -           -                -           -         -            -           -              -           -
 Over 120 Days                                           0%                                                                  -           -                -           -         -            -           -              -           -
                 Financing:
   Cash Equity                                 $        -                                                                                                                                                                           -
   Loan 1 - Enterprise Brant                   $        -              -           -              -           -              -           -                -           -         -            -           -              -           -
   Loan 2 -                                                            -           -              -           -              -           -                -           -         -            -           -              -           -
   Loan 3 -                                    $        -              -           -              -           -              -           -                -           -         -            -           -              -           -

            Total Cash Received            $           -             -            -           -            -            -             -           -           -                 -            -           -              -           -
            Equipment & Inventory in place $           -      This amount is not added to the cash but is an indication of additional investment in the business.

                Direct Costs
                        Revenue Source #1             0.00             -           -              -           -              -           -                -           -         -            -           -              -           -
                        Revenue Source #2             0.00             -           -              -           -              -           -                -           -         -            -           -              -           -
                        Revenue Source #3             0.00             -           -              -           -              -           -                -           -         -            -           -              -           -
                        Revenue Source #4             0.00             -           -              -           -              -           -                -           -         -            -           -              -           -
       Total Direct Exp - Materials & Supplies                         -           -              -           -              -           -                -           -         -            -           -              -           -
             Direct expense - Wages labour            0.00             -           -              -           -              -           -                -           -         -            -           -              -           -
         Employer remittances labour & staff          0.15             -           -              -           -              -           -                -           -         -            -           -              -           -
            Total Labour and Remittances                               -           -              -           -              -           -                -           -         -            -           -              -           -
             Total Direct Cost                                         -           -              -           -              -           -                -           -         -            -           -              -           -




                                                                                                                  919

C:\Docstoc\Working\pdf\5308d0c4-4ff5-4579-9b5e-8c49373c374c.xls5308d0c4-4ff5-4579-9b5e-8c49373c374c.xlsSTEP 7 - Cashflow Year 1                                                                                                 4/13/2011
                                                                                              Operating Expenses
                                                             J           J           J             J              J        J        J       J       J       J       J       J       Total
 Marketing Plan                                                  -           -           -             -              -         -       -       -       -       -       -       -       -
 Bank Charges                                                                                                                                                                           -
  Business Liability Insurance                                                                                                                                                          -
  Delivery                                                                                                                                                                              -
  Legal & Accounting                                                                                                                                                                    -
 Loan 1 - Enterprise Brant                                                                                                                                                              -
 Loan 2 -                                                                                                                                                                               -
 Loan 3 -                                                                                                                                                                               -
 Security System                                                                                                                                                                        -
 Buying Trips                                                                                                                                                                           -
  Office expenses                                                                                                                                                                       -
  Professional Fees                                                                                                                                                                     -
  Rent/Mortgage Payments                                                                                                                                                                -
  Telephone/Internet/Cell                                                                                                                                                               -
  Utilities                                                                                                                                                                             -
 Vehicle Allowance                                                                                                                                                                      -
  Vehicle/travel expenses                                                                                                                                                               -
  Wages staff                                                                                                                                                                           -
                                                                                             Start up from Start-up Costs Tab
 Brought forward From Start-up Costs w/s                 0                                                                                                                              -
 Total Cash Out                                      -           -           -           -             -              -         -       -       -       -       -       -       -       -

 Net Cash - Month                                    -           -           -           -             -              -         -       -       -       -       -       -       -       -
 Cumulative Net Cash                                 -           -           -           -             -              -         -       -       -       -       -       -       -

        Owners' Salary, Drawings/Bonuses/Dividends               -           -           -             -              -         -       -       -       -       -       -       -       -

       Net Monthly Cash After Personal Drawings                  -           -           -             -              -         -       -       -       -       -       -       -
      Net Cumulative Cash After Personal Drawings                -           -           -             -              -         -       -       -       -       -       -       -




                                                                                                           1019

C:\Docstoc\Working\pdf\5308d0c4-4ff5-4579-9b5e-8c49373c374c.xls5308d0c4-4ff5-4579-9b5e-8c49373c374c.xlsSTEP 7 - Cashflow Year 1                                                     4/13/2011
                     Statement of Projected Income From Cash Sources
0
0
                                           Year 1


                           Income                                -     #DIV/0!

                                      Cost of Goods Sold
     Opening inventory purchase                         -
    Total Direct Exp - Materials & Supplies             -
     * Wages and Benefits                               -
     - Closing inventory                                -


              Cost of Goods Sold                                 -     #DIV/0!




                 Gross Profit                                    -     #DIV/0!


                                    Operating Expenses

Marketing Plan                                                   -     #DIV/0!
Bank Charges                                                     -     #DIV/0!
 Business Liability Insurance                                    -     #DIV/0!
 Delivery                                                        -     #DIV/0!
 Legal & Accounting                                              -     #DIV/0!
Loan 1 - Enterprise Brant                                        -     #DIV/0!
Loan 2 -                                                               #DIV/0!
Loan 3 -                                                               #DIV/0!
Security System                                                  -     #DIV/0!
Buying Trips                                                     -     #DIV/0!
 Office expenses                                                 -     #DIV/0!
 Professional Fees                                               -     #DIV/0!
 Rent/Mortgage Payments                                          -     #DIV/0!
 Telephone/Internet/Cell                                         -     #DIV/0!
 Utilities                                                       -     #DIV/0!
Vehicle Allowance                                                -     #DIV/0!
 Vehicle/travel expenses                                         -     #DIV/0!
 Wages staff                                                     -     #DIV/0!
Brought forward From Start-up Costs w/s                          -     #DIV/0!
Depreciation
 Total Expenses                                                  -     #DIV/0!

                 Operating Income (profit)                       -     #DIV/0!
                  Less Personal Drawings                         -     #DIV/0!
          Operating Income After Drawings(profit)                -     #DIV/0!
                                                                                                CASH FLOW FORECAST
                                             Client Name:        0                                                          Business Name :                 0
                                          Date prepared:         0-Jan-00                                                                                                           Target Unit Sales / Month                     0
                             Year for Start of Cash Flow:           1             Month:       0-Jan                                                                                        Average Sales / month             -
           Clients/Orders/Units                 Start up         Jan-00         Jan-00         Jan-00       Jan-00       Jan-00       Jan-00       Jan-00           Jan-00       Jan-00      Jan-00        Jan-00       Jan-00         Total
   Total Estimated Unit Sales / month              0%              0.0            0.0            0.0          0.0          0.0          0.0          0.0              0.0          0.0         0.0           0.0          0.0              -
Revenue Source #1                                  0%        0              0              0            0            0            0            0                0            0             0             0          0                      -
Revenue Source #2                                  0%        0              0              0            0            0            0            0                0            0             0             0          0                      -
Revenue Source #3                                  0%        0              0              0            0            0            0            0                0            0             0             0          0                      -
Revenue Source #4                                  0%        0              0              0            0            0            0            0                0            0             0             0          0                      -
           Estimated Revenue:
Revenue Source #1                             $        -              -             -              -            -            -            -            -                -            -           -           -               -               -
Revenue Source #2                             $        -              -             -              -            -            -            -            -                -            -           -           -               -               -
Revenue Source #3                             $        -              -             -              -            -            -            -            -                -            -           -           -               -               -
Revenue Source #4                             $        -              -             -              -            -            -            -            -                -            -           -           -               -               -
         Total Estimated Revenue                                      -             -              -            -            -            -            -                -            -           -           -               -               -
            Revenue Receipts:
Cash from sales (within 30 days)                        0%            -             -              -            -            -            -            -                -            -           -           -               -               -
Cash from A/R (Paid in 31 - 60 days)                    0%            -             -              -            -            -            -            -                -            -           -           -               -               -
Cash from A/R (Paid 61 - 90 days)                       0%            -             -              -            -            -            -            -                -            -           -           -               -               -
Cash from A/R (Paid 91 - 120 days)                      0%            -             -              -            -            -            -            -                -            -           -           -               -               -
Over 120 Days                                           0%            -             -              -            -            -            -            -                -            -           -           -               -               -
                 Financing:
 Cash Equity                                  $        -                                                                                                                                                                                     -
Loan 1 - Enterprise Brant                                                                                                                                                                                                                    -
Loan 2 -                                                                                                                                                                                                                                     -
Loan 3 -                                                                                                                                                                                                                                     -
           Total Cash Received                $        -              -             -              -            -            -            -            -                -            -           -           -               -               -


               Direct Costs
                       Revenue Source #1         0%                   -             -              -            -            -            -            -                -            -           -           -               -               -
                       Revenue Source #2         0%                   -             -              -            -            -            -            -                -            -           -           -               -               -
                       Revenue Source #3         0%                   -             -              -            -            -            -            -                -            -           -           -               -               -
                       Revenue Source #4         0%                   -             -              -            -            -            -            -                -            -           -           -               -               -
      Total Direct Exp - Materials & Supplies                         -             -              -            -            -            -            -                -            -           -           -               -               -
             Direct expense - Wages labour        0%                  -             -              -            -            -            -            -                -            -           -           -               -               -
        Employer remittances labour & staff      15%                  -             -              -            -            -            -            -                -            -           -           -               -               -
      Total Labour and Remittances                                    -             -              -            -            -            -            -                -            -           -           -               -               -
            Total Direct Costs                                        -             -              -            -            -            -            -                -            -           -           -               -               -




                                                                                                                     1219

     C:\Docstoc\Working\pdf\5308d0c4-4ff5-4579-9b5e-8c49373c374c.xls5308d0c4-4ff5-4579-9b5e-8c49373c374c.xlsSTEP 8 - Cashflow Year 2                                                                                             4/13/2011
                                                                                            Operating Expenses
                                                         Jan-00      Jan-00      Jan-00      Jan-00       Jan-00      Jan-00      Jan-00   Jan-00   Jan-00   Jan-00   Jan-00   Jan-00        Total
Marketing Plan                                                -           -           -           -            -           -           -        -        -        -        -        -            -
Bank Charges                                                                                                                                                                                     -
 Business Liability Insurance                                                                                                                                                                    -
 Delivery                                                                                                                                                                                        -
 Legal & Accounting                                                                                                                                                                              -
Loan 1 - Enterprise Brant                                                                                                                                                                        -
Loan 2 -                                                                                                                                                                                         -
Loan 3 -                                                                                                                                                                                         -
Security System                                                                                                                                                                                  -
Buying Trips                                                                                                                                                                                     -
 Office expenses                                                                                                                                                                                 -
 Professional Fees                                                                                                                                                                               -
 Rent/Mortgage Payments                                                                                                                                                                          -
 Telephone/Internet/Cell                                                                                                                                                                         -
 Utilities                                                                                                                                                                                       -
Vehicle Allowance                                                                                                                                                                                -
 Vehicle/travel expenses                                                                                                                                                                         -
 Wages staff                                                                                                                                                                                     -
            Capital purchases:
 Other: Computer/Office equip                                                                                                                                                                      -
 Other: Equipment                                                                                                                                                                                  -
Other: Describe                                                                                                                                                                                    -
Total Cash Out                                    -           -           -           -           -            -           -           -       -        -        -        -        -               -

Net Cash - Month                                  -           -           -           -           -            -           -           -       -        -        -        -        -               -
Cumulative Net Cash                               -           -           -           -           -            -           -           -       -        -        -        -        -

 Owners' Salary, Drawings/Bonuses/Dividends                   -           -           -           -            -           -           -       -        -        -        -        -               -

     Net Monthly Cash After Personal Drawings                 -           -           -           -            -           -           -       -        -        -        -        -
    Net Cumulative Cash After Personal Drawings               -           -           -           -            -           -           -       -        -        -        -        -




                                                                                                       1319

     C:\Docstoc\Working\pdf\5308d0c4-4ff5-4579-9b5e-8c49373c374c.xls5308d0c4-4ff5-4579-9b5e-8c49373c374c.xlsSTEP 8 - Cashflow Year 2                                                   4/13/2011
                     Statement of Projected Income From Cash Sources
0
0
                                           Year 2


                           Income                           $    -     #DIV/0!

                                      Cost of Goods Sold
     Opening inventory purchase                $        -
    Total Direct Exp - Materials & Supplies    $        -
     * Wages and Benefits                      $        -
     - Closing inventory                       $        -


              Cost of Goods Sold                            $    -     #DIV/0!




                 Gross Profit                               $    -     #DIV/0!


                                    Operating Expenses

Marketing Plan                                              $    -     #DIV/0!
Bank Charges                                                $    -     #DIV/0!
 Business Liability Insurance                               $    -     #DIV/0!
 Delivery                                                   $    -     #DIV/0!
 Legal & Accounting                                         $    -     #DIV/0!
Loan 1 - Enterprise Brant                                   $    -     #DIV/0!
Security System                                             $    -     #DIV/0!
Buying Trips                                                $    -     #DIV/0!
 Office expenses                                            $    -     #DIV/0!
 Professional Fees                                          $    -     #DIV/0!
 Rent/Mortgage Payments                                     $    -     #DIV/0!
 Telephone/Internet/Cell                                    $    -     #DIV/0!
 Utilities                                                  $    -     #DIV/0!
Vehicle Allowance                                           $    -     #DIV/0!
 Vehicle/travel expenses                                    $    -     #DIV/0!
 Wages staff                                                $    -     #DIV/0!
Capital purchases:                                          $    -     #DIV/0!
 Depreciation                                               $    -     #DIV/0!
 Total Expenses                                             $    -     #DIV/0!

                 Operating Income (profit)                  $    -     #DIV/0!
                  Less Personal Drawings                         -     #DIV/0!
          Operating Income After Drawings(profit)           $    -     #DIV/0!
                                                              Marketing Matrix
                                                                       No of Clients     Sales Dollars       Avg trans Value    Ad cost ratio   Repeat
Product/service Supplier   Vehicle   Size   Price $   Cost   Timing
                                                                      Est #     Act #   Est $      Act $    Est $     Act $    Est%      Act%   Yes/no
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
                                                                                                           #DIV/0!   #DIV/0!   0.0%     0.0%
              Your Business Implementation Chart
Quarters        Quarter One         Quarter Two          Quarter Three
Months     Jan-00 Jan-00 Jan-00 Jan-00 Jan-00 Jan-00 Jan-00 Jan-00
Quarter Three         Quarter Four
           Jan-00 Jan-00 Jan-00 Jan-00
$ 194,390.00
               $ 11,690.00 $ 16,700.00 $ 30,450.00 $ 5,010.00 $ 15,030.00 $ 6,680.00
                      7.0%        9.9%       18.1%       3.0%        8.9%       4.0%

               $ 1,750.00 $ 2,500.00 $ 5,000.00 $ 1,500.00 $ 2,250.00 $ 1,500.00
                     6.7%       9.5%      19.0%       5.7%       8.6%       5.7%

               $ 13,440.00 $ 19,200.00 $ 35,450.00 $ 6,510.00 $ 17,280.00 $ 8,180.00
                      6.9%        9.9%       18.2%       3.3%        8.9%       4.2%
$ 17,400.00 $ 10,020.00 $ 16,700.00 $ 16,700.00 $ 11,690.00 $ 10,020.00 $ 168,090.00
      10.4%        6.0%        9.9%        9.9%        7.0%        6.0%       100.0%

$ 1,800.00 $ 2,500.00 $ 2,500.00 $ 1,750.00 $ 1,750.00 $ 1,500.00 $ 26,300.00
      6.8%       9.5%       9.5%       6.7%       6.7%       5.7%      100.0%

$ 19,200.00 $ 12,520.00 $ 19,200.00 $ 18,450.00 $ 13,440.00 $ 11,520.00 $ 194,390.00
       9.9%        6.4%        9.9%        9.5%        6.9%        5.9%       100.0%

								
To top