Budgetting for a Non Profit Organization by ftv14677

VIEWS: 15 PAGES: 7

More Info
									                                          BiD Challenge 2006 - Financial Plan
                                                     Confidential


General information:
                          My plan name:                     Extracting Gold from Grass                            Use the yellow fields to fill things in
                               My name:                         Moises P. Talladen                                Use the yellow fields to fill things in
                       My email address:                       naciphil@yahoo.com                                 Use the yellow fields to fill things in
                               Currency:                               EU$                                        *Choose either USD or EUR (US Dollars or Euros) for your financial plan, the currency will be displayed on every following sheet



                                                    Fill sheets in follwing order:
                                                                     Budgetting**                                 **Start with the budgetting sheet and subsequently work your way through the following sheets
                                                                      Investments                                 Fill Sheets in in this order
                                                               Profit & Loss Statement                            Fill Sheets in in this order
                                                                       Cash Flow                                  Fill Sheets in in this order
                                                                    Balance Sheet                                 Fill Sheets in in this order
                                                                        Planning                                  Fill Sheets in in this order

Assume the the following:                     No inflation
                                              No price increases
                                              No interest rates
                                              No timelag in payment of bills (accounts payable & receivable)
                                              No paid out dividends or profits


However indicate***:
  Your local currency & EUR/USD rate:                                        61
         Interest rate (savings account):                                    6%
                Interest rate (borrowing):                                   8%
                      Inflation (per year):                                  5%
          Normal payment days for bills:                                     30

*** This information will not be directly used in subsequent calculations in this file, however please provide it so it can be taken into account by those who assess it.


HELP
               Spreadsheet protection: You can remove cell protection via option PROTECTION in EXTRA
        See an example financial model:         www.bidnetwork.org/attachment-XXXXXXX.html
Extracting Gold from Grass
                                        USE THE YELLOW AREAS TO FILL IN YOUR FINANCIAL PLAN
EU$                                     Only add items which are hardware and last longer than one year


INVESTMENTS                             ESTIMATE                                                      REAL
                                                                               Total
                                                      No. of                   Investment
                                        Price per     Units (1st Estimated     in first 3                                                                              Depreciation     Depreciation     Depreciation
                                        unit          3 years) life (in years) years                  start up       1st Year     2nd Year     3rd Year                   year 1           year 2           year 3
                       Summary -->                                                  274,721                              57,918       23,770       98,361

Project related assets you own before start -->                                                           94,672

                    Office Hardware                                                                                  Fill investment amount in the correct year (e.g.Total investment is 300; in year one you plan to invest 100, as well as
                            furniture          1000           1             5           1000                     0        1,000          -            -                           200              200              200
                computers & printers           1500           1             5           1500                     0        1,500          -            -                           300              300              300
                   Phones & internet            500           1             5             500                    0          500          -            -                           100              100              100
          < add an investment item >              0           0             2               0                               -            -            -                           -                -                -
          < add an investment item >              0           0             2               0                               -            -            -                           -                -                -
          < add an investment item >              0           0             2               0                               -            -            -                           -                -                -
                           sub-total                                                   3,000                 -            3,000          -            -



              Production Hardware                                                                                    Fill investment amount in the correct year
                           Machinery              0           0             2              0                                -            -            -                           -                -                -
           Instruments & Shop Tools            8197           1             5          8197                 8197            -            -            -                           -                -                -
         Plant Building & Warehouse           11475           1             5         11475                11475            -            -            -                           -                -                -
               Production Equipment          196721           1            10        196721                59016          39344          -         98,361                       3,934            3,934           13,770
           Transportation Equipment           18033           1             5         18033                    0           6557       11,475          -                         1,311            3,607            3,607
          < add an investment item >              0           0             2              0                                -            -            -                           -                -                -
          < add an investment item >              0           0             2              0                                -            -            -                           -                -                -
                           sub-total                                                234,426               78,688         45,902       11,475       98,361



                    Other hardware                                                                                   Fill investment amount in the correct year
                               Land           11066           1            50          11066               11066            -            -            -                           -                -                -
                  Land Development            24590           1             5          24590                4918          7,377       12,295          -                         1,475            3,934            3,934
   Farmers Training on Cooperatives            1639           1             5           1639                   0          1,639          -            -                           328              328              328
         < add an investment item >               0           0             2               0                               -            -            -                           -                -                -
                          sub-total                                                   37,295              15,984          9,016       12,295          -



                  Total investments                                                 274,721                  -           57,918       23,770       98,361                       7,649           12,403           22,239
Extracting Gold from Grass
                                             USE THE YELLOW AREAS TO FILL IN YOUR FINANCIAL PLAN                                                           USE THE YELLOW AREAS TO FILL IN YOUR FINANCIAL PLAN
                                                                                                                           USE THE YELLOW AREAS TO FILL IN YOUR FINANCIAL PLAN
EU$                                                                                                              Use this Budgetting sheet to estimate your 1st to 3rd year's INCOME and COSTS. 1st to 3rd year's INCOME and COSTS.
                                             Use this Budgetting sheet to estimate your 1st to 3rd year's INCOME and COSTS.                              Use this Budgetting sheet to estimate your
                                                                                                                  Only investments (add operational costsOnly in "investments" sheet)
                                                                                                                                                          or revenues - that are operational costs or revenues - do not investments investments (add hardware investments in "inv
                                             Only add items that are operational costs or revenues - do not add harwareadd items that are hardware investments add itemsdo not add harware investments (add hardware add harware in "investments" sheet)

BUDGET - YEAR 1

                                             Price per No. of units          Total per    Total (no. of                    Price per                                    Price per
                                             unit year per month             month in     units) in year Total             unit in   No. of units        Total          unit in   No. of units         Total
                                             1         in year 1             year 1       1              1st year          year 2    in year 2           2nd year       year 3    in year 3            3rd year
                            Summary >>                                                                            78,543                                      183,882                                       539,580
INCOME
                     Revenues / Sales
           Lemongrass Oil - Local Sales           32.79             420          13,770           5,040         165,246         32.79           9,072         297,443         32.79          21,072         690,885
         Lemongrass Water- Local Sales             0.25          12,600           3,098         151,200          37,180          0.25         272,160          66,925          0.25         632,160         155,449
             <add a product or service >            -               -               -               -               -             -                               -             -                               -
             <add a product or service >            -               -               -               -               -             -                               -             -                               -
             <add a product or service >            -               -               -               -               -             -                               -             -                               -
                              sub-total                          13,020          16,869                         202,426                                       364,367                                       846,334

COSTS
                           Cost of sales
 Direct Materials (Lemongrass P1.00/Kg.         0.01639         140,000           2,295        1,680,000          27,541     0.01639        3,024,000          49,574      0.01639        7,024,000         115,148
Harvesting, Handling & Transport to Plant       0.00820         140,000           1,148        1,680,000          13,770     0.00820        3,024,000          24,787       0.0082        7,024,000          57,574
        Fuel (Firewood @ P0.25 per Kg.)         0.00410         140,000             574        1,680,000           6,885     0.00410        3,024,000          12,393      0.00574        7,024,000          40,302
               Direct Labor - Processing           2,305              1           2,305               12          27,656        2,305              12          27,656         2,305              12          27,656
                 Manufacturing Overhead              -              -               -                -               -            -               -               -             -               -               -
                      < add a cost item >            -              -               -                -               -            -               -               -             -               -               -
                      < add a cost item >            -              -               -                -               -            -               -               -             -               -               -
                                sub-total                       420,001                                           75,853                                      114,410                                       240,679



                 Materials & Operations
                               Materials             -               -              -                -               -            -                -                -           -                -                -
                          Transportation             -               -              -                -               -            -                -                -           -                -                -
                                Storage              -               -              -                -               -            -                -                -           -                -                -
                     < add a cost item >             -               -              -                -               -            -                -                -           -                -                -
                     < add a cost item >             -               -              -                -               -            -                -                -           -                -                -
                     < add a cost item >             -               -              -                -               -            -                -                -           -                -                -
                     < add a cost item >             -               -              -                -               -            -                -                -           -                -                -
                              sub-total                              -                                               -                                              -                                             -



                              Staff costs You can use the "Planning" sheet to get a better idea on the total number of man-hours you may need                            You can the total number of man-hours a better need
                                                                                                                          You can use the "Planning" sheet to get a better idea onuse the "Planning" sheet to get you mayidea on the total number of man-hours you may need
                              manager(s)         328                2            656                  18           5,902         328               24           7,869            328               24            7,869
                         middle personnel        246                3            738                  27           6,639         246               36           8,852            246               36            8,852
                                   labour        150                7          1,049                  63           9,443         150               84          12,590            150               84          12,590
                              consultants        164                1            164                   9           1,475         164               12           1,967            164               12            1,967
                                    health       328                1            328                   9           2,951         328               12           3,934            328               12            3,934
                      insurance / pension         51                1              51                  9             458           51              12              611             51              12              611
                                 Training        164                1            164                   9           1,475         164               12           1,967            164               12            1,967
                      < add a cost item >        -                -               -                  -               -            -               -                -              -               -                -
                      < add a cost item >        -                -               -                  -               -            -               -                -              -               -                -
                      < add a cost item >        -                -               -                  -               -            -               -                -              -               -                -
                                sub-total                          16                                            28,343                                        37,791                                          37,791



                            Travel costs
          Local Travel & Accommodation           163.93                  1          164               12           1,967       163.93               12          1,967       163.93                12          1,967
                    visa's & vaccination            -                -              -                -               -            -                -              -            -                 -              -
                      < add a cost item >           -                -              -                -               -            -                -              -            -                 -              -
                      < add a cost item >           -                -              -                -               -            -                -              -            -                 -              -
                      < add a cost item >           -                -              -                -               -            -                -              -            -                 -              -
                               sub-total                                 1                                         1,967                                        1,967                                         1,967



                           Office costs
                                    Rent             98                  1           98               12           1,180           98               12          1,180           98                12          1,180
                              Telephone              98                  1           98               12           1,180           98               12          1,180           98                12          1,180
                              Stationary            131                  1          131               12           1,574          131               12          1,574          131                12          1,574
                               Electricity           66                  1           66               12             787           66               12            787           66                12            787
                        IT maintenance               82                  1           82               12             984           82               12            984           82                12            984
              Rates (5% of Gross Sales)             -                -              -                -            10,121          -                -           18,218          -                 -           18,218
                              Insurance              33                  1           33               12             393           33               12            393           33                12            393
                     < add a cost item >            -                -              -                -               -            -                -              -            -                 -              -
                     < add a cost item >            -                -              -                -               -            -                -              -            -                 -              -
                               sub-total                                 6                                        16,220                                       24,317                                        24,317



       Equipment & maintenance costs Only add running costs here or things with a life of less than one year. Add hardware investmentshere or things with Only add running one year. Addthings withinvestments in Investments sheet.
                                                                                                                                                          a life
                                                                                                                Only add running costs in Investments sheet. of less than costs here or hardware a life of less than one year. Add hardware investments in Investments sheet.
                  Machinery maintenance     -              -             -                  -              -           -              -             -            -              -              -
      Instruments (small or maintenance)    -              -             -                  -              -           -              -             -            -              -              -
                Building(s) (maintenance)     4              1             4                  9             32           4             12            43            4             12             43
                Equipment (maintenance)      64              1            64                  9           575           64             12           766           64             12           766
       Furniture & Fixtures (maintenance)  0.92              1             1                  9              8           1             12            11            1             12             11
                       < add a cost item >  -              -             -                  -              -           -              -             -            -              -              -
                       < add a cost item >  -              -             -                  -              -           -              -             -            -              -              -
                                sub-total                    3                                            615                                       820                                       820

                        Third Party cost
                     Bank charges & fees              16                 1           16                  9           148           16               12            197            16               12            197
                              Legal costs             82                 1           82                  9           738           82               12            984            82               12            984
                            advisory fees            -               -              -                -               -            -                -              -             -                -              -
                              Equipment              -               -              -                -               -            -                -              -             -                -              -
                      < add a cost item >            -               -              -                -               -            -                -              -             -                -              -
                      < add a cost item >            -               -              -                -               -            -                -              -             -                -              -
                      < add a cost item >            -               -              -                -               -            -                -              -             -                -              -
                               sub-total                                 2                                           885                                        1,180                                         1,180



                            Other costs
                      < add a cost item >            -               -              -                -               -            -                -                -           -                -                -
                      < add a cost item >            -               -              -                -               -            -                -                -           -                -                -
                      < add a cost item >            -               -              -                -               -            -                -                -           -                -                -
                               sub-total                             -                                               -                                              -                                             -

                         Total Revenues                                                                         202,426                                       364,367                                       846,334
                             Total Costs                                                                        123,883                                       180,485                                       306,754

         Total (revenues MINUS costs)                                                                             78,543                                      183,882                                       539,580
Extracting Gold from Grass
                                             USE THE YELLOW AREAS TO FILL IN YOUR FINANCIAL PLAN
EU$

PROFIT & LOSS STATEMENT

                                               1st Year     2nd Year     3rd Year     4th Year     5th Year

          Revenues (see budgetting sheet)         202,426      364,367      846,334      846,334      846,334
                        Total Revenues            202,426      364,367      846,334      846,334      846,334

      Cost of Sales (see budgetting sheet)         75,853      114,410      240,679      240,679      240,679
                            Cost of Sales          75,853      114,410      240,679      240,679      240,679

            Gross margin (Net revenues)           126,573      249,957      605,655      605,655      605,655

                 Materials & Operations               -            -            -
                             Staff costs           28,343       37,791       37,791       37,791       37,791
                            Travel costs            1,967        1,967        1,967        1,967        1,967
                            Office costs           16,220       24,317       24,317       24,317       24,317
          Equipment & maintenance costs               615          820          820          820          820
                        Third Party cost              885        1,180        1,180        1,180        1,180
                            Other costs               -            -            -
                       Operating Costs             48,030       66,075       66,075       66,075       66,075

                Income from Operations             78,543      183,882      539,580      539,580      539,580

         Franchise Fee (10% of Revenues)           20,243       36,437       84,633       84,633       84,633
            Taxes (VAT 12% of Revenues)            24,291       43,724      101,560      101,560      101,560
  Local Taxes & Licences (5% of Revenues           10,121       18,218       42,317       42,317       42,317
                             Depreciation           7,649       12,403       22,239       22,239       22,239
              non-tax (deductable) costs           62,304      110,782      250,750      250,750      250,750



                              Net Income           16,239       73,099      288,831      288,831      288,831
Extracting Gold from Grass
                                                USE THE YELLOW AREAS TO FILL IN YOUR FINANCIAL PLAN
EU$

REAL CASH FLOW's

                                                start-up      1st Year      2nd Year     3rd Year     4th Year      5th Year

                   Beginning Cash Position                         36,476      157,096      387,600      799,914      1,304,441

                                   Revenues                       202,426      364,367      846,334      846,334        846,334

               Investors funds (add manually)        32,787
                 Loans paid in (add manually)        98,361



                                    Cash IN         131,148       202,426      364,367      846,334      846,334        846,334


                                       Costs                       23,888       85,503      311,070      311,070        311,070
                                 Investments         94,672        57,918       23,770       98,361        6,148          6,148
      Loan Repayment (not interest payments)                          -         24,590       24,590       24,590         24,590

                                 Cash OUT            94,672        81,806      133,863      434,021      341,808        341,808
                             Net Cash Flow           36,476       120,620      230,504      412,314      504,527        504,527

                      Ending Cash Position           36,476       157,096      387,600      799,914     1,304,441     1,808,967
Extracting Gold from Grass
                                              USE THE YELLOW AREAS TO FILL IN YOUR FINANCIAL PLAN
EU$

BALANCE SHEET

                                              start-up      1st Year    2nd Year    3rd Year     4th Year     5th Year

ASSETS / INVESTMENTS
                                 Assets            94,672
                Investments (Cumulative)                      152,590     176,360     274,721      274,721      274,721
                           Fixed Assets         94,672        152,590     176,360     274,721      274,721      274,721

                                   Cash         36,476        157,096     387,600     799,914     1,304,441    1,808,967
                          Current Assets        36,476        157,096     387,600     799,914     1,304,441    1,808,967

                            Total Assets        131,148       309,686     563,960    1,074,635    1,579,161    2,083,688

LIABILITIES
          Current liabilities (leave blank)        0             0          0           0             0            0
                     Current Liabilities           0             0          0           0             0            0

                                    Loans       98,361        98,361      73,770      49,180       24,590          0


         Retained Earnings (Net income)                       16,239      73,099      288,831      288,831      288,831
                  Shareholders Equity                         16,239      73,099      288,831      288,831      288,831

                                Net Worth       32,787        195,086     417,090     736,624     1,265,741    1,794,858

                         Total Liabilities      131,148       309,686     563,960    1,074,635    1,579,161    2,083,688
Extracting Gold from Grass
                                                            USE THE YELLOW AREAS TO FILL IN YOUR PLAN
                                                            Fill in the number of man-days per activity

PLANNING
Number of man-days per activity
                                                                              1st Year


                                                                                                                  4th
                                                            Pre-start         1st Quarter 2nd Quarter 3rd Quarter Quarter    Year 2     Year 3
                                         Summary -->               3,436           3,390       3,245       6,080     6,080     37,820     33,320

                                  Pre-start-up activities
    Business Planning with Gold In Grass Corp. (GIGC)                   20           -           -           -         -          -          -
                  Feasibility studies - Provided by GIGC                10           -           -           -         -          -          -
   Visit to GIGC Farm to Witness Processing Operation                   20           -           -           -         -          -          -
    Procure Lemongrass Seedlings for a 1 ha. Seedbed                     6           -           -           -         -          -          -
                                   sub-total (man-days)                 56           -           -           -         -          -          -


                                Financing & Marketing
   Meet GFI's: Land Bank, Quedancor, Dev't.Bank, etc.                    30              10       10          10       10         40         40
   Meet Interested Parties & Investors, the Curious, etc.                10              10       10          10       10         40         40
                            BioSearch & Other Exhibits                  100              30       30          30       30        120        120
                                  sub-total (man-days)                  140              50       50          50       50        200        200


                 Recruitment & Buying & Investing
          20 Farmers Training - Seed Bed Preparation                     60          -           -           -         -          -          -
      25 Farmers Training - Transplanting of Seedlings                  100          -           -           -         -          -          -
                            Audit of Farmers' Farmlots                   10
                                Farmers Organization                    -            -           -           -         -          -          -
                                sub-total (man-days)                    170          -           -           -         -          -          -


                                              Building
                 Plant Building & Plant Water System                    300          -           -           -         -          -          -
       Redesign & Fabrication of Prototype GIGC Plant                   200          -           -           -         -          -          -
          GIGC Plant Installation and Commissioning                     100
                 Product Storage & Delivery Facilities                  200
                       GIGC Plant Manpower Training                      70
                       Test Operations prior to Launch                   30          -           -           -         -          -          -
                                 sub-total (man-days)                   900          -           -           -         -          -          -


                                                Launch
                     Blessing of Plant Site & Facilities                -             50         -           -         -          -          -
             Demonstrate Distillation Process to Guests                 -             20         -           -         -          -          -
                                      < add an activity >               -            -           -           -         -          -          -
                                  sub-total (man-days)                  -             70         -           -         -          -          -

                                          Operations
     Harvesting Lemongrass & Delivery to GIGC Plant                     150          990         990       1,980     1,980     15,840     15,840
      Distillation (Lemongrass Processing) Operations                   120          675         675       1,620     1,620     12,960     12,960
     Supervision, Product Storage & Delivery to Manila                  100          630         630         630       630      2,520      2,520
                                sub-total (man-days)                    370        2,295       2,295       4,230     4,230     31,320     31,320


                                       Other activities
                   Plant 100 Hectars with Lemongrass               1,800             450         450         900       900      4,500        -
         Train Farmert in Organic Fertilizer Production              -               150         -           -         -          -          -
      Convert Spent Lemongrass into Organic Fertilizer               -               375         450         900       900      1,800      1,800
                                sub-total (man-days)               1,800             975         900       1,800     1,800      6,300      1,800


                                        Total man-days             3,436           3,390       3,245       6,080     6,080     37,820     33,320

								
To top