Here's html version of updated (2008) biodiesel financial plan with randomly removed text. You can purchase Excel file with formulas (Product 3) for comprehensive financial planning only for 50$. Spivak.pl.ua
|
Start-up Expenses |
|
|
Land to buy |
|
|
Office to buy |
|
|
Renovation expenses |
|
|
$10 000 |
|
|
Assembly operations |
$200 000 |
|
Placing into operation |
$53 000 |
|
Oil processing equipment (incl. storage and loading) |
$100 000 |
|
Seed storage equipment (incl. installation) |
$350 000 |
|
Glycerol purification equipment (including installation) |
$0 000 |
|
Tanks |
$100 000 |
|
Biodiesel production equipment (incl. delivery and installation ) |
$250 000 |
|
Utility network |
$000 |
|
Advertising/Promotion |
$5 000 |
|
Land leasing |
$0 |
|
Raw materials (1 quarter of operations) |
$660 000 |
|
Salaries |
$353 000 |
|
Biodiesel production costs (chemicals, utilities, maintenance for 1
quarter) |
$84 000 |
|
Rent |
$0 |
|
Total Start-up Expenses |
|
|
|
|
|
Start-up Assets Needed |
|
|
Start-up Inventory |
|
|
Other Current Assets |
|
|
Total Current Assets |
|
|
Long-term Assets |
|
|
Total Assets |
|
|
Total Requirements |
$3 095 000 |
|
Sales |
2007 |
|
2008 |
|
2009 |
|
2010 |
|
2011 |
|
|
|
Price per ton |
Sum |
Price per ton |
Sum |
Price per ton |
Sum |
Price per ton |
Sum |
Price per ton |
Sum |
|
|
$2 800 000 |
$700 |
|
|
$2 800 000 |
|
$2 800 000 |
$700 |
$ |
|
|
Glycerol |
|
$280 000 |
$700 |
$280 000 |
$700 |
$280 000 |
|
$280 000 |
$0 |
$280 000 |
|
Seeds |
|
$0 |
$220 |
|
$220 |
$0 |
|
$0 |
$220 |
$0 |
|
Press cake |
$180 |
$1 440 000 |
$180 |
$1 440 000 |
$180 |
$1 440 000 |
$180 |
$1 440 000 |
$180 |
$1 440 000 |
|
Total Sales |
|
$4 520 000 |
|
$4 520 000 |
|
$4 520 000 |
|
$4 520 000 |
|
$4 520 000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Direct Cost of
Sales |
|
2006 |
|
2007 |
|
2008 |
|
2009 |
|
2010 |
|
$220 |
$2 640 000 |
$220 |
|
$220 |
$2 640 000 |
$220 |
|
|
|
|
|
Oil |
$600 |
$0 |
$600 |
$0 |
$600 |
$0 |
$600 |
$0 |
600 |
$0 |
|
Subtotal Direct Cost of Sales |
|
$2 640 000 |
|
$2 640 000 |
|
$2 640 000 |
|
$2 640 000 |
|
$2 640 000 |
|
Sales and costs
in tons |
|
|
|
|
|
|
|
|
|
|
|
Biodiesel |
|
|
|
|
|
|
|
|
|
|
|
Glycerol |
$700 |
400 |
$700 |
400 |
$700 |
400 |
$700 |
400 |
$700 |
400 |
|
Seeds from own
farm |
$220 |
|
$220 |
|
$220 |
|
$220 |
|
$220 |
|
|
Press cake |
$180 |
|
$180 |
8 000 |
$180 |
8 000 |
$180 |
8 000 |
$180 |
8 000 |
|
Total sales, ton |
|
|
|
12 400 |
|
12 400 |
|
12 400 |
|
12 400 |
|
Procurement of raw
materials |
|
|
|
|
|
|
0 |
|
0 |
|
|
Seeds |
$220 |
12 000 |
$220 |
12 000 |
$220 |
|
$220 |
12 000 |
||