# Biodiesel_Cost_Income_Calculator_May22

Document Sample

```					                 Feasibility of Biodiesel in the Treasure Valley
Feedstock Evaulation Sheet

Instructions: In column I enter your data for your plant in the grey cells. The white cells
are locked and contain formula's. Yellow cells are to contain the total of the cells
immediately above , either use a Sum function or enter the sum directly.

Desired Annual Capacity                                       Model               Estimate A
a. Used Oil, gallons                                           500,000                         0
b. Tallow, gallons                                           3,500,000                         0
c. Virgin Oils, gallons                                               0            17,529,600
d. Total Annual Capacity, gallons                            4,000,000             17,529,600
Selected Feedstocks
a. Used Oil
I.   Pounds available                                  3,750,000                         0
ii. Cost (\$/lb)                                            \$0.100                 \$0.100
iii. Total Cost                                          \$375,000                         \$0
1/
iv. Weight per gallon                                          7.50                   7.50
v. Gallons available                                       500,000                         0
b. Tallow
i. Pounds available                                     26,250,000                         0
ii. Cost (\$/lb)                                            \$0.112                 \$0.112
iii. Total Cost                                        \$2,940,000                         \$0
1/
iv. Weight per gallon                                          7.50                   7.50
v. Gallons available                                     3,500,000                         0
c. Virgin Oils
i. Acres                                                          0               166,000
ii. Estimated average Yield. Lbs/acre                         2,200                 2,200
iii. Total Pounds of seed                                         0          365,200,000
iv. Cost per pound of seed (\$/lb)                          \$0.111                 \$0.111
v. Cleaning and handling cost (\$/lb)                       \$0.040                 \$0.040
vi. Total Seed Cost                                             \$0          \$55,145,200
vii. Percentage oil in seed                                    40%                   40%
vii. Estimated crushing recovery of oil (%)                    90%                   90%
1/
viii. Oil weight per gallon, lb                                 7.5                       7.5
ix. Gallons of oil available for Biodiesel                       0            17,529,600
d. Total Annual Production, gallons                          4,000,000            17,529,600
e. Total Annual Cost of Feedstocks                         \$3,315,000           \$55,145,200
1/
7.5 lb/gal is a nominal weight for raw oil
Notes:

(7.5 lb/gal is a nominal weight for raw oil)

(7.5 lb/gal is a nominal weight for raw oil)

Enter the seed price on the Calculations page, cell K25

(7.5 lb/gal is a nominal weight for raw oil)
Feasibility of Biodiesel in the Treasure Valley
Chemical Feedstock Evaulation Sheet

Instructions: In column J enter your data for your plant in the grey cells. The white cells are
locked and contain formula's.

Model              Estimate A
Methanol
a. Cost per gallon for methanol                                    \$0.80                        0.8
1/
b. Gallons required per gallon of biodiesel                         0.175                     0.175
c. Total gallons of methanol required                            700,000              3,067,680
Total Cost                                                     \$560,000             \$2,454,144
Catalyst
2/
a. Cost of catalyst per gallon of biodiesel                       \$0.073                 \$0.073
b. Total Cost                                                  \$292,000             \$1,279,661
FFA Treatment (If Used)
a. Cost of ffa treatment per gallon of biodiesel                  \$0.060                 \$0.060
b. Gallons of oil treated                                      4,000,000                         0
c. Total Cost of FFA treatment                                 \$240,000                         \$0

Total Chemical Cost                                              \$1,092,000             \$3,733,805

1/
0.125 assumes 0.25 gallon required per gallon of production with a 50% recovery rate.
2/
(\$0.073/gallon of biodiesel production)
Notes:

0.125 assumes 0.25 gallon required per gallon of production with a 50% recovery rate.

(\$0.073/gallon of biodiesel production)
12/10/2011
PROJECT COST ESTIMATE
Treasure Valley Biodiesel Plant
Capacity -------------- 4,000,000 Gallons per Year

PRE-DESIGN DEVELOPMENT
Business Plan        \$25,000          +         \$10    /1000 Gal.                                \$65,000
Licensing Permiting \$35,000           +         \$10    /1000 Gal.                                \$75,000
Agreements           \$25,000          +         \$10    /1000 Gal.                                \$65,000
Site Acquistion     \$165,000          +          0.5   Acre/5 MGal./Yr                          \$165,000
1.0 Acre                    Pre-Design Development Total             \$370,000
SITE WORK, FOUNDATION, STRUCTURE & BUILDING EXTERIOR
5,000 /sqFt +          3,000 sqFt/5 MGal./Yr @ \$50.00 /sqFt                           250,000
5,000 sqFt                         Building Total                        \$250,000
EQUIPMENT
Tankage                     14   Day Capacity
Feedstock          153,425   Gallon @    \$0.55 /Gal.                                          \$84,384
Methanol           117,664   Gallon @    \$1.10 /Gal. +               \$16,000         6       \$145,431
Biodiesel          153,425   Gallon @    \$0.55 /Gal.                                          \$84,384
Glycerol            15,342   Gallon @    \$0.55 /Gal.                                           \$8,438
Reactors             5,479   Gallon @    \$1.00 /Gal.                                           \$5,479
Seperators                        \$20,000      +         \$10             /1000 Gal.               \$60,000
Heaters, Dryers & Other           \$10,000      +          \$5             /1000 Gal.               \$30,000
Piping                            \$20,000      +          \$5             /1000 Gal.               \$40,000
Pumps                             \$20,000      +         \$15             /1000 Gal.      18       \$60,000
Laboratory                        \$50,000      +          \$5             /1000 Gal.               \$70,000
Controls                          \$20,000      +         \$30             /1000 Gal.              \$140,000
Fire Supression                   \$20,000      +          \$5             /1000 Gal.               \$40,000
Misc.                               5.0%    of Equipment Cost                                     \$38,406
Miscellaneous                                                                                    \$500,000
Installation                        15.0% of Equipment Cost                                      \$120,978
Equipment Total      \$1,427,500

TOTAL DIRECT COST                                   2,047,500
CONTINGENCY                           10 %            204,750
TOTAL                              2,252,250

CONSTRUCTION MANAGEMENT                              3 % Project Cost                                67,567
ENGINEERING & DESIGN                                10 % Project Cost                               225,225
OPERATION & PLANT START-UP                           5 % Project Cost                               112,612
TOTAL CONSTRUCTION COST                      \$2,657,655
Plant Cost Per Gallon of Annual Production                     \$0.664
Size Factor

-1        Set for Column B only

Assumes starting a batch every other day.
Feasibility of Biodiesel in the Treasure Valley
Other Expenses
Instructions: In column J enter your data for your plant in the grey cells. The white cells are locked and contain
formula's. Yellow cells are to contain the total of the cells immediately above , either use a Sum function or enter
the sum directly.

Model             Estimate A

Miscellaneous Freight Charges Not included Elsewhere                    \$0.050           \$200,000             \$876,480
Enter estimate per gallon in F13

In-plant Meal handling
a. Cost/ ton                                                                            \$0.000               \$0.010
b. Tons handled                                                                                0
c. Total Meal Handling charge                                                                \$0                   \$0

In-plant Glycerol handling and purification
a. Cost/gallon                                                                          \$0.000               \$0.000
b. Gallons handled                                                                     100,000              100,000
c. Total Glycerol handling                                                                   \$0                   \$0

Crushing Charge
a. Tons crushed                                                                                 0            182,600
b. Estimated cost per ton                                                                \$50.00               \$50.00
c. Total Crushing charge                                                                      \$0         \$9,130,000

Cost of Plant Operation
a. Energy                                                                                                     \$0.030
b. Labor                                                                                                      \$0.034
Plant Cost \$/gal of annual production                          \$0.664
c. Capital Recovery                                                                                           \$0.090
d. Maintenance
f. Analytical Services                                                                                        \$0.001
g. Miscellaneous Costs
h. Total Plant Operation Cost/gallon                                                     \$0.217               \$0.219
i. Total Plant Operation Cost                                                         \$866,103           \$3,837,346

Total Cost
a. Total Cost                                                                      \$5,473,103         \$72,722,831
b. Cost/gallon of biodiesel                                                              \$1.37                \$4.15
c. Ratio of Feedstock cost to total cost                                                    61%                 76%
Notes:

Estimate of Plant Operation Cost:
Cost/gal gallons per year
0.3    500000
0.219 17,529,600
0.2 21,500,000 21,000,000
0.1                  3970400

(\$50.00/ton)

See computation on Calculation sheet
CR is computed based on 7% interest, 10% salvage, and 10 year life

For Estimate A only
Enter 1 in cell J35 if COST Page is used
0 Enter 0 in J35 and your estimate of
\$0.219 Plant Operation Cost Per "Gallon in J36
0.2 if the Cost Page is not used

Use this in lieu of estimating a-h or estimate a-h and sum them to obtain I or j
depending on whether they are input as total plant costs or costs/gallon..
Feasibility of Biodiesel in the Treasure Valley
Income

Biodiesel Production Plant Income              Model          Estimate A
1. Biodiesel Sales
a. Selling Price per gallon                   \$2.20            \$2.20
(FOB Plant Gate)
b. Gallons Sold                           4,000,000       17,529,600
c. Total Biodiesel Income                \$8,800,000      \$38,565,120
2. Meal Sales
a. Price per ton                                 125             125
(FOB Plant Gate)
b. Tons sold                                       0         116,864
c. Total Meal Income                              \$0     \$14,608,000
3. Glycerol Sales
a. Price per pound                               0.05           0.05
(FOB Plant Gate)
b. Pounds sold                              400,000        1,752,960
c. Total Glycerol Income                   \$20,000          \$87,648
4. Local State and Federal Incentives
a. Local Incentives (\$/gal)                   \$0.00                  0
b. State Incentives (\$/gal)                   \$0.00                  0
c. Federal Incentives (\$/gal)                 \$0.00                  0
Total Incentive Income                            \$0             \$0
5. Other Income
6. Total Income
a. Total Income                          \$8,820,000      \$53,260,768
b. Income per gallon of plant capacity        \$2.21            \$3.04

Plant Profit or Loss                                \$0.84           (\$1.11)
Computation of Capital Recovery, CRF

Principal amount               P                0.6644137                    I/q                  0.07
Payment                        R                                             (1+I/q)              1.07
Salvage as a percent of P                              0.1                   n*q                    10
Salvage Value                  S                0.0664414                    p-s             0.597972
q
Number of compounding periods per year                   1                   si/q            0.004651
Interest Rate/period           I                      0.07
Life of investment, years      n                        10                   num             0.137701
den             0.967151

CRF                 0.090 This value is currently refe

Enter Seed Price in K25                              0.111                   To use the sensitivity analysis cells H31 and I31 on the feedsto
11 Million     21 Million      (=Calculations!E17)
Highlight the table (A30:F38E32) and use Data | Ta
Cost Per Gallon                                     \$1.37           \$4.15
Gross Profit or Loss                                \$0.84          (\$1.11)
% Feedstock Cost                                      61%             76%

Sensitivity Analysis
Cost Per Gallon and Profit or Loss Versus Seed Price

11 Million Gallon Plant 2.5 Million Gallon Plant
Seed Price, cents/lb      Cost         Profit      Cost          Profit
1.37      0.84          4.15         (1.11)
\$0.06            1.37      0.84          3.09         (0.05)
\$0.08            1.37      0.84          3.50         (0.46)
\$0.10            1.37      0.84          3.92         (0.88)
\$0.12            1.37      0.84          4.34         (1.30)
\$0.14            1.37      0.84          4.75         (1.71)
\$0.16            1.37      0.84          5.17         (2.13)
\$0.18            1.37      0.84          5.59         (2.55)
\$0.20            1.37      0.84          6.00         (2.96)

This table will automatically update, if the only changes to the spreadsheet are inputs
in the grey areas (on any page), and if cells H31 and I30 on the feedstock page remain
referenced to E17.
This value is currently referenced by cells by cells I31 on the Expense Page

ysis cells H31 and I31 on the feedstock