Here's html version of updated (2012) 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 |
$220 |
12 000 |
Oil |
$600 |
|
$600 |
|
$600 |
|
$600 |
|
$600 |
|
Total, raw materials,
ton |
|
|
|
12 000 |
|
|
|
12 000 |
|
12 000 |
Personnel Plan |
Daily wage |
2007 |
2008 |
2009 |
2010 |
2011 |
$100 |
$24 000 |
$24 000 |
$24 000 |
$24 000 |
$24 000 |
|
Production and procurement
director |
|
|
$24 000 |
$24 000 |
$24 000 |
|
Farm supervisor |
|
|
$24 000 |
$24 000 |
$24 000 |
|
Sales manager |
|
|
|
|
|
|
Controller |
|
|
|
|
|
|
Chief Technologist |
$80 |
|
$19 200 |
$19 200 |
|
|
Secretary |
$56 |
|
$13 440 |
$13 440 |
|
|
Operators, production, 5 employees |
$56 |
$67 200 |
$67 200 |
$67 200 |
$67 200 |
|
Laboratory technician, 1 employee |
|
$13 440 |
$13 440 |
$13 440 |
$13 440 |
$13 440 |
Farming, 5 employee |
|
$67 200 |
|
$67 200 |
$67 200 |
$67 200 |
Drivers, 2 employee |
$56 |
$26 880 |
|
$26 880 |
$26 880 |
$26 880 |
Electrical fitter |
$56 |
$13 440 |
|
$13 440 |
$13 440 |
$13 440 |
Storeman, 2 employee |
$56 |
$26 880 |
$26 880 |
$26 880 |
$26 880 |
$26 880 |
Total Payroll |
|
$353 000 |
$353 000 |
$353 000 |
$353 000 |
$353 000 |
Production headcount |
|
5 |
5 |
5 |
5 |
5 |
You can purchase Excel file (Product 3) with formulas for comprehensive financial planning only for 50$. Spivak.pl.ua
2007 |
2008 |
2009 |
2010 |
2011 |
|
Sales |
$4 520 000 |
$4 520 000 |
$4 520 000 |
$4 520 000 |
$4 520 000 |
Cost of Sales |
|
|
$3 326 000 |
$3 326 000 |
$3 326 000 |
Gross Margin |
$1 186 000 |
$1 194 000 |
$1 194 000 |
$1 194 000 |
$1 194 000 |
Gross Margin % |
26.24% |
26.42% |
26.42% |
26.42% |
26.42% |
Operating Expenses |
$434 667 |
$101 667 |
$101 667 |
$101 667 |
$121 667 |
Operating Income |
$751 333 |
|
|
$1 092 333 |
$1 072 333 |
Net Income |
$470 283 |
|
|
$708 983 |
$750 633 |
Net Income to investor |
$244 639 |
$368 809 |
$368 809 |
|
|
Current Assets |
$3 029 283 |
$3 804 933 |
$4 339 917 |
$5 115 567 |
$5 137 867 |
Long-term Assets |
$843 333 |
$776 667 |
$710 000 |
$643 333 |
$576 667 |
Long-term Liabilities |
$795 000 |
$795 000 |
$795 000 |
$795 000 |
$0 |
Equity |
$3 077 617 |
$3 786 600 |
$4 254 917 |
$4 963 900 |
$5 714 533 |
ROE |
0.15 |
0.19 |
0.17 |
0.14 |
0.13 |
ROI |
0.11 |
0.16 |
0.16 |
0.16 |
0.17 |
Shares offered to investor |
52.02% |
|
|
|
|
74.31% |
|
|
|
|
|
Loan financing |
25.69% |
|
|
|
|
|
2007 |
2008 |
2009 |
2010 |
2011 |
Sales |
$4 520 000 |
$4 520 000 |
$4 520 000 |
$4 520 000 |
|
Cost of raw
materials |
|
|
$2 640 000 |
$2 640 000 |
|
Farm maintenance (fuel, fertilizer, etc) |
$5 000 |
$5 000 |
$5 000 |
$5 000 |
$5 000 |
Production Payroll |
$353 000 |
$353 000 |
$353 000 |
$353 000 |
$353 000 |
Methanol |
|
|
|
|
|
Potassium hydroxide |
$8 000 |
$8 000 |
$8 000 |
|
$8 000 |
Utilities |
$80 000 |
$80 000 |
$80 000 |
|
$80 000 |
$8 000 |
$0 |
$0 |
|
$0 |
|
Cost of Goods
Sold |
$3 334 000 |
$3 326 000 |
$3 326 000 |
$3 326 000 |
$3 326 000 |
Gross Margin |
$1 186 000 |
$1 194 000 |
$1 194 000 |
$1 194 000 |
$1 194 000 |
Gross Margin % |
26.24% |
26.42% |
26.42% |
26.42% |
26.42% |
Other Expenses: |
|
|
|
|
|
$10 000 |
$0 |
|
$0 |
$0 |
|
Renovation expenses |
$100 000 |
|
|
|
$20 000 |
Assembly operations |
|
|
$10 000 |
$10 000 |
$10 000 |
Placing into operation |
$53 000 |
$5 000 |
$5 000 |
$5 000 |
$5 000 |
Advertising/Promotion |
$5 000 |
$20 000 |
$20 000 |
$20 000 |
$20 000 |
$66 667 |
$66 667 |
$66 667 |
$66 667 |
$66 667 |
|
Land leasing |
$0 |
$0 |
$0 |
$0 |
$0 |
Rent |
$0 |
$0 |
$0 |
$0 |
$0 |
Total Other expenses |
$434 667 |
$101 667 |
$101 667 |
$101 667 |
$121 667 |
Profit Before Interest and Taxes |
$751 333 |
$1 092 333 |
$1 092 333 |
$1 092 333 |
$1 072 333 |
Interest Expense |
$79 500 |
$79 500 |
$79 500 |
$79 500 |
$0 |
Taxes Incurred |
$201 550 |
$303 850 |
$303 850 |
$303 850 |
$321 700 |
Other Expense |
|
|
|
|
|
Net Profit |
|
|
$708 983 |
$708 983 |
$750 633 |
Net Profit/Sales |
15.69% |
15.69% |
15.69% |
16.61% |
2007 |
2008 |
2009 |
2010 |
2011 |
|
Cash from Operations:
|
|
|
|
|
|
Cash Sales |
$3 164 000 |
$3 164 000 |
|
|
|
Cash from Receivables |
$1 356 000 |
$1 356 000 |
$1 356 000 |
$1 356 000 |
$1 356 000 |
Subtotal Cash from Operations |
|
|
|
|
$4 520 000 |
Additional Cash Received |
|
|
|
|
|
$0 |
$0 |
$0 |
$0 |
$0 |
|
Loan |
$795 000 |
$0 |
$0 |
$0 |
$0 |
New Investment Received |
$2 300 000 |
$0 |
$0 |
$0 |
$0 |
Subtotal Cash Received |
$7 615 000 |
$4 520 000 |
$4 520 000 |
$4 520 000 |
$4 520 000 |
|
|
|
|
|
|
Expenditures |
2007 |
2008 |
2009 |
2010 |
2010 |
Expenditures from Operations: |
|
|
|
|
|
|
|
|
|
$353 000 |
|
Payment
of Accounts Payable |
|
|
|
|
$2 973 000 |
Subtotal Spent on Operations |
$3 334 000 |
$3 326 000 |
$3 326 000 |
$3 326 000 |
$3 326 000 |
|
|
|
|
|
|
Additional Cash Spent |
|
|
|
|
|
|
|
|
|
$321 700 |
|
Principal
Repayment (loan) |
|
|
|
|
$795 000 |
Design works |
$10 000 |
$0 |
$0 |
$0 |
|
Renovation expenses |
|
|
$0 |
$0 |
|
Assembly
operations |
|
|
$10 000 |
$10 000 |
|
Placing
into operation |
$53 000 |
$5 000 |
$5 000 |
|
|
Advertising/Promotion |
$5 000 |
$20 000 |
$20 000 |
$20 000 |
$20 000 |
Land leasing |
$0 |
$0 |
$0 |
$0 |
$0 |
Rent |
$0 |
$0 |
$0 |
$0 |
$0 |
Interest
Expense |
$79 500 |
$79 500 |
$79 500 |
$79 500 |
$0 |
Purchase
Long-term Assets |
|
|
|
$0 |
$0 |
Subtotal Cash Spent |
|
|
|
$3 744 350 |
$4 497 700 |
|
|
|
|
|
|
Net Cash Flow |
$2 788 617 |
$842 317 |
$842 317 |
317 |
$88 967 |
Cash Balance |
$2 788 617 |
$3 564 267 |
$4 339 917 |
$5 115 567 |
$5 137 867 |
Annual Break-even, Tons |
961.34 |
961.34 |
961.34 |
961.34 |
Assumptions: |
|
|
|
|
Average Per Tone
Revenue |
|
|
$1 130.00 |
$1 130.00 |
Average Per Tone Variable Cost |
$742.00 |
$742.00 |
$742.00 |
$742.00 |
Estimated Annual Fixed Cost |
|
|
$373 000 |
$373 000 |