Cash Flow Diagram Fuel Tax - Excel

Document Sample
Cash Flow Diagram Fuel Tax - Excel Powered By Docstoc
					            Total Cost of Capital (Bare Module), Labour and Utilities for the Plant
                      Capital (K$) Labour Units                          Utilities (K$/yr)
                                    0             0                                        0

Equipment                                                            Utilities
Name                  Module Cost Labour                   Utility Type     Annual Cost
Raw Material Costs, Product Revenue, Additional Operating Costs and Revenue


Raw Materials
         Material             Rate - kg/hr   Price - $/kg   Cost - $K/yr
       1                                                                   0
       2                                                                   0
       3                                                                   0
       4                                                                   0
       5                                                                   0
       6                                                                   0
       7                                                                   0
       8                                                                   0
       9                                                                   0
      10                                                                   0
Total                                                                      0

Products
            Product           Rate - kg/hr   Price - $/kg   Revenue - $K/yr
        1                                                                  0
        2                                                                  0
        3                                                                  0
        4                                                                  0
        5                                                                  0
Total                                                                      0

Waste Disposal and Other Operating Costs
          Cost                                              Cost - $K/yr
        1
        2
        3
        4
        5
Total                                                                      0

Additional Revenue
           Revenue                                          Revenue - $K/yr
        1
        2
        3
        4
        5
Total                                                                      0
Parameters that can be changed at any time                                 Variabilily Factors

CEPCI                                          397
Hours/year                                   8000    Hours
Labour rate                                     80   K$/man-year
Taxation Rate                                   30   %
Discount Rate                                   15   %
Working Capital / Fixed Capital               17.5   %
Capital Cost/Bare Module Cost                  118   %
Startup Year Costs                              25   %
Startup Year Revenue                          12.5   %
Capital in Year 1                               10   %
Capital in Year 2                               60   %
Capital in Year 3                               30   %


Utility Costs

Steam: Low Pressure (5 barg, 160C)            6.08   $/GJ     SteamLow
Steam: Medium Pressure (10 barg, 184C)        6.87   $/GJ     SteamMed
Steam: High Pressure (41 barg, 254C)          9.83   $/GJ     SteamHigh
Dowtherm (300C)                               8.85   $/GJ     Dowtherm
Fuel Oil                                         6   $/GJ     FuelOil
Natural Gas                                      6   $/GJ     Gas
Custom Heating                                   6   $/GJ     CustomHeat
Electricity (GJ)                              16.8   $/GJ     ElectGJ
Electricity (KW)                              0.06   $/KWH    ElectKWH
Cooling Water                                0.354   $/GJ     CoolWater
Refrigeration: Water (5=>15C)                 4.43   $/GJ     RefWater
Refrigeration: Low T (-20C)                   7.89   $/GJ     RefLow
Refrigeration: Very Low (-50C)               13.11   $/GJ     RefVeryLow
Refrigeration: Custom                            6   $/GJ     RefCustom
riabilily Factors

             %+     %-
                                                 2469

                                                         Net Present Value           -6885 K$
                                                         Payback Period              12.00 Years

                                Year       1        2            3            4             5       6
Revenue
Sales                                                            0            0             0       0
Additional Revenue                                               0            0             0       0
Total Revenue                                                    0            0             0       0

Direct Manufacturing Costs
Raw Materials                                                                0          0           0
Utilities                                                                    0          0           0
Additional Costs                                                             0          0           0
Operating Labour                                                           903        903         903
Other labour                                                               163        163         163
Maintenance and Repairs                                                      0          0           0
Operating Supplies                                                           0          0           0
Laboratory Charges                                                         135        135         135
Patents and Royalties                                                       74         74          74
Total Direct Manufacturing Costs                               319        1275       1275        1275

Fixed Manufacturing Costs
Local Taxes and Insurance                                                    0           0           0
Plant Overhead Costs                                                       639         639         639
Total Fixed Manufacturing Costs                                160         639         639         639

General Mfg. Expenses
Administration                                                             160         160         160
Distribution and Selling                                                   272         272         272
Research and Development                                                   123         123         123
Total General Mfg. Expenses                                    139         555         555         555

Total Manufacturing Costs                                      617        2469       2469        2469

Operating Income Before Tax                0        0         -617       -2469       -2469      -2469

Capital                                                              Total Capital Cost =           0
Fixed Capital Investment - K$              0        0            0
Working Capital                                                  0
Unused CCA                                                       0            0             0       0
Capital Cost Allowance                                           0            0             0       0

Taxes                                      0        0         -185        -741        -741       -741
Operating Income After Tax                 0        0         -432       -1728       -1728      -1728

Cash Flow                                   0        0        -432       -1728       -1728       -1728
Discount Factor                        1.0000   0.8696      0.7561      0.6575      0.5718      0.4972
Discounted Cash Flow                        0        0        -327       -1136        -988        -859
Accumulated Disc. Cash Flow                 0        0        -327       -1463       -2451       -3310
                Cumulative Discounted Cash Flow

    0
-1000   1   2   3    4   5    6    7   8    9     10   11   12   13
-2000
-3000
-4000
-5000
-6000
-7000
-8000
                                                   Sensitivity Analysis
Uncertainties                                      -%        +%           Min NPV     33032.97 Max NPV

Sales Revenue                                           10           15      19964      33033       52636

Additional Revenue                                      10           10      30310      33033       35756

Raw Materials                                           20           20      31137      33033       34929

Utilities                                               20           20      32658      33033       46027

Additional Costs                                        10           10      32737      33033       33329

Operating Labour                                        15           15      32820      33033       33246

Working Capital                                         10           10      32774      33033       45996

Capital Cost of Plant                                    5           40      20694      33033       34575




                                   Cumulative Probability Distribution

                         100
                          90
                          80
   Percent Probability




                          70
                          60
                          50
                          40
                          30
                          20
                          10                                                                                       0
                           0                                                                                7362.095
                                                                                                            7913.752
                               0   10000   20000     30000   40000        50000     60000   70000
                                                                                                            8465.409
                                                         NPV                                                9017.066
                                                                                                            9568.723
                                                                                                            10120.38
                                                                                                            10672.04
    7        8        9       10       11       12       13

    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        0        0        0
    0        0        0        0        0        0        0
    0        0        0        0        0        0        0
  903      903      903      903      903      903      903
  163      163      163      163      163      163      163
    0        0        0        0        0        0        0
    0        0        0        0        0        0        0
  135      135      135      135      135      135      135
   74       74       74       74       74       74       74
 1275     1275     1275     1275     1275     1275     1275


    0        0        0        0        0        0        0
  639      639      639      639      639      639      639
  639      639      639      639      639      639      639


  160      160      160      160      160      160      160
  272      272      272      272      272      272      272
  123      123      123      123      123      123      123
  555      555      555      555      555      555      555

 2469     2469     2469     2469     2469     2469     2469

-2469    -2469    -2469    -2469    -2469    -2469    -2469



                                                          0
    0        0        0        0        0        0        0
    0        0        0        0        0        0        0

 -741     -741     -741     -741     -741     -741     -741
-1728    -1728    -1728    -1728    -1728    -1728    -1728

 -1728    -1728    -1728    -1728    -1728    -1728    -1728
0.4323   0.3759   0.3269   0.2843   0.2472   0.2149   0.1869
  -747     -650     -565     -491     -427     -371     -323
 -4058    -4707    -5272    -5764    -6191    -6562    -6885
                  Tornado Diagram


      20694    13881

      32774    13222

      32820     426

      32737     593

      32658    13369

      31137    3793

      30310    5445

      19964    32671

0     10000    20000   30000    40000   50000   60000




           0       0      0
    7362.095     0.3      3
    7913.752     0.4      1
    8465.409     0.4      0
    9017.066     0.5      1
    9568.723     0.6      1
    10120.38     0.7      1
    10672.04     0.8      1

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:60
posted:12/10/2010
language:English
pages:10
Description: Cash Flow Diagram Fuel Tax document sample