|
Sales
Forecast |
FIRST
OPERATIONAL YEAR FULL TABLES
BUSINESS
PLAN
TEXT
|
Unit Sales |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
|
|
|
Shea butter |
500 |
600 |
800 |
952 |
952 |
952 |
952 |
952 |
952 |
952 |
952 |
952 |
10.468 |
11.419 |
11.990 |
|
|
|
Cooking oil |
500 |
800 |
1.000 |
1.136 |
1.136 |
1.136 |
1.136 |
1.136 |
1.136 |
1.136 |
1.136 |
1.136 |
12.524 |
13.634 |
14.316 |
|
|
|
Other |
1.264 |
1.732 |
2.238 |
3.632 |
3.632 |
3.632 |
3.632 |
3.632 |
3.632 |
3.632 |
3.632 |
3.632 |
37.922 |
43.591 |
45.770 |
|
|
|
Total Unit Sales |
2.264 |
3.132 |
4.038 |
5.720 |
5.720 |
5.720 |
5.720 |
5.720 |
5.720 |
5.720 |
5.720 |
5.720 |
60.914 |
68.644 |
72.076 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Unit Prices |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
|
|
|
Shea butter |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.550,00 |
$1.628,00 |
$1.709,00 |
|
|
|
Cooking oil |
$740,00 |
$740,00 |
$740,00 |
$740,00 |
$740,00 |
$740,00 |
$740,00 |
$740,00 |
$740,00 |
$740,00 |
$740,00 |
$740,00 |
$740,00 |
$777,00 |
$815,00 |
|
|
|
Other |
$100,00 |
$100,00 |
$100,00 |
$100,00 |
$100,00 |
$100,00 |
$100,00 |
$100,00 |
$100,00 |
$100,00 |
$100,00 |
$100,00 |
$100,00 |
$105,00 |
$110,00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Shea butter |
$775.000 |
$930.000 |
$1.240.000 |
$1.475.600 |
$1.475.600 |
$1.475.600 |
$1.475.600 |
$1.475.600 |
$1.475.600 |
$1.475.600 |
$1.475.600 |
$1.475.600 |
$16.225.400 |
$18.590.132 |
$20.490.910 |
|
|
|
Cooking oil |
$370.000 |
$592.000 |
$740.000 |
$840.640 |
$840.640 |
$840.640 |
$840.640 |
$840.640 |
$840.640 |
$840.640 |
$840.640 |
$840.640 |
$9.267.760 |
$10.593.618 |
$11.667.540 |
|
|
|
Other |
$126.400 |
$173.200 |
$223.800 |
$363.200 |
$363.200 |
$363.200 |
$363.200 |
$363.200 |
$363.200 |
$363.200 |
$363.200 |
$363.200 |
$3.792.200 |
$4.577.055 |
$5.034.700 |
|
|
|
Total Sales |
$1.271.400 |
$1.695.200 |
$2.203.800 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$29.285.360 |
$33.760.805 |
$37.193.150 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Direct Unit Costs |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
|
|
|
Shea butter |
$232,00 |
$232,00 |
$232,00 |
$232,00 |
$232,00 |
$232,00 |
$232,00 |
$232,00 |
$232,00 |
$232,00 |
$232,00 |
$232,00 |
$232,00 |
$255,00 |
$280,00 |
|
|
|
Cooking oil |
$161,00 |
$161,00 |
$161,00 |
$161,00 |
$161,00 |
$161,00 |
$161,00 |
$161,00 |
$161,00 |
$161,00 |
$161,00 |
$161,00 |
$161,00 |
$177,00 |
$194,00 |
|
|
|
Other |
$19,00 |
$13,00 |
$10,00 |
$9,00 |
$9,00 |
$9,00 |
$9,00 |
$9,00 |
$9,00 |
$9,00 |
$9,00 |
$9,00 |
$9,58 |
$11,00 |
$12,00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Direct Cost of Sales |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
|
|
|
Shea butter |
$116.000 |
$139.200 |
$185.600 |
$220.864 |
$220.864 |
$220.864 |
$220.864 |
$220.864 |
$220.864 |
$220.864 |
$220.864 |
$220.864 |
$2.428.576 |
$2.911.845 |
$3.357.200 |
|
|
|
Cooking oil |
$80.500 |
$128.800 |
$161.000 |
$182.896 |
$182.896 |
$182.896 |
$182.896 |
$182.896 |
$182.896 |
$182.896 |
$182.896 |
$182.896 |
$2.016.364 |
$2.413.218 |
$2.777.304 |
|
|
|
Other |
$24.016 |
$22.516 |
$22.380 |
$32.688 |
$32.688 |
$32.688 |
$32.688 |
$32.688 |
$32.688 |
$32.688 |
$32.688 |
$32.688 |
$363.104 |
$479.501 |
$549.240 |
|
|
|
Subtotal Direct Cost of Sales |
$220.516 |
$290.516 |
$368.980 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$4.808.044 |
$5.804.564 |
$6.683.744 |
|
|
|
Production Personnel |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
2005 |
2006 |
|
Manager |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$15.120 |
$15.876 |
$16.670 |
$0 |
$0 |
|
Deputy manager |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$12.516 |
$13.142 |
$13.799 |
$0 |
$0 |
|
Foremen |
$2.522 |
$2.522 |
$2.522 |
$2.522 |
$2.522 |
$2.522 |
$2.522 |
$2.522 |
$2.522 |
$2.522 |
$2.522 |
$2.522 |
$30.264 |
$31.772 |
$33.366 |
$0 |
$0 |
|
Mecs/Elec/Plumbers |
$1.471 |
$1.471 |
$1.471 |
$1.471 |
$1.471 |
$1.471 |
$1.471 |
$1.471 |
$1.471 |
$1.471 |
$1.471 |
$1.471 |
$17.652 |
$18.545 |
$19.472 |
$0 |
$0 |
|
Presses workers |
$5.675 |
$5.675 |
$5.675 |
$5.675 |
$5.675 |
$5.675 |
$5.675 |
$5.675 |
$5.675 |
$5.675 |
$5.675 |
$5.675 |
$68.100 |
$71.505 |
$75.080 |
$0 |
$0 |
|
Other |
$3.368 |
$3.368 |
$3.368 |
$3.368 |
$3.368 |
$3.368 |
$3.368 |
$3.368 |
$3.368 |
$3.368 |
$3.368 |
$3.368 |
$40.416 |
$42.437 |
$44.559 |
$0 |
$0 |
|
Other |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
Subtotal |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$184.068 |
$193.277 |
$202.946 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales and Marketing Personnel |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Manager |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$1.260 |
$15.120 |
$15.876 |
$16.670 |
$0 |
$0 |
|
Accountant |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$1.043 |
$12.516 |
$13.142 |
$13.799 |
$0 |
$0 |
|
Deputy accountant |
$837 |
$837 |
$837 |
$837 |
$837 |
$837 |
$837 |
$837 |
$837 |
$837 |
$837 |
$837 |
$10.044 |
$10.546 |
$11.073 |
$0 |
$0 |
|
Sales/Purchases officer |
$820 |
$820 |
$820 |
$820 |
$820 |
$820 |
$820 |
$820 |
$820 |
$820 |
$820 |
$820 |
$9.840 |
$10.332 |
$10.849 |
$0 |
$0 |
|
Warehouse officer |
$633 |
$633 |
$633 |
$633 |
$633 |
$633 |
$633 |
$633 |
$633 |
$633 |
$633 |
$633 |
$7.596 |
$7.976 |
$8.375 |
$0 |
$0 |
|
Other |
$2.105 |
$2.105 |
$2.105 |
$2.105 |
$2.105 |
$2.105 |
$2.105 |
$2.105 |
$2.105 |
$2.105 |
$2.105 |
$2.105 |
$25.260 |
$26.523 |
$27.849 |
$0 |
$0 |
|
Subtotal |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$80.376 |
$84.395 |
$88.615 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
General and Administrative Personnel |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
General manager |
$1.679 |
$1.679 |
$1.679 |
$1.679 |
$1.679 |
$1.679 |
$1.679 |
$1.679 |
$1.679 |
$1.679 |
$1.679 |
$1.679 |
$20.148 |
$21.155 |
$22.213 |
$0 |
$0 |
|
Personnel manager |
$1.417 |
$1.417 |
$1.417 |
$1.417 |
$1.417 |
$1.417 |
$1.417 |
$1.417 |
$1.417 |
$1.417 |
$1.417 |
$1.417 |
$17.004 |
$18.854 |
$18.747 |
$0 |
$0 |
|
Assistant/Executive secretary |
$379 |
$379 |
$379 |
$379 |
$379 |
$379 |
$379 |
$379 |
$379 |
$379 |
$379 |
$379 |
$4.548 |
$4.776 |
$5.015 |
$0 |
$0 |
|
Other |
$1.052 |
$1.052 |
$1.052 |
$1.052 |
$1.052 |
$1.052 |
$1.052 |
$1.052 |
$1.052 |
$1.052 |
$1.052 |
$1.052 |
$12.624 |
$13.255 |
$13.918 |
$0 |
$0 |
|
Subtotal |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$54.324 |
$58.040 |
$59.893 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other Personnel |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
President |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$24.000 |
$25.200 |
$26.460 |
$0 |
$0 |
|
Other |
$1.500 |
$1.500 |
$1.500 |
$1.500 |
$1.500 |
$1.500 |
$1.500 |
$1.500 |
$1.500 |
$1.500 |
$1.500 |
$1.500 |
$18.000 |
$18.900 |
$19.845 |
$0 |
$0 |
|
Subtotal |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$42.000 |
$44.100 |
$46.305 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Headcount |
75 |
75 |
75 |
75 |
75 |
75 |
75 |
75 |
75 |
75 |
75 |
75 |
75 |
75 |
75 |
0 |
0 |
|
Total Payroll |
$30.064 |
$30.064 |
$30.064 |
$30.064 |
$30.064 |
$30.064 |
$30.064 |
$30.064 |
$30.064 |
$30.064 |
$30.064 |
$30.064 |
$360.768 |
$379.812 |
$397.759 |
$0 |
$0 |
|
Payroll Burden |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$129.876 |
$136.732 |
$143.193 |
$0 |
$0 |
|
Total Payroll Expenditures |
$40.887 |
$40.887 |
$40.887 |
$40.887 |
$40.887 |
$40.887 |
$40.887 |
$40.887 |
$40.887 |
$40.887 |
$40.887 |
$40.887 |
$490.644 |
$516.544 |
$540.952 |
$0 |
$0 |
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
2005 |
2006 |
|
Short-term Interest Rate % |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
13,00% |
|
Long-term Interest Rate % |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
9,00% |
|
Payment Days Estimator |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
30 |
|
Collection Days Estimator |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
45 |
|
Inventory Turnover Estimator |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
8,00 |
|
Tax Rate % |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
35,00% |
|
Expenses in Cash % |
90,00% |
90,00% |
90,00% |
100,00% |
100,00% |
100,00% |
100,00% |
90,00% |
100,00% |
100,00% |
100,00% |
100,00% |
96,67% |
100,00% |
100,00% |
100,00% |
100,00% |
|
Sales on Credit % |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
80,00% |
|
Personnel Burden % |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
36,00% |
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
|
|
|
Sales |
$1.271.400 |
$1.695.200 |
$2.203.800 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$2.679.440 |
$29.285.360 |
$33.760.805 |
$37.193.150 |
|
|
|
Direct Cost of Sales |
$220.516 |
$290.516 |
$368.980 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$436.448 |
$4.808.044 |
$5.804.564 |
$6.683.744 |
|
|
|
Production Payroll |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$15.339 |
$184.068 |
$193.277 |
$202.946 |
|
|
|
FOB/Transport/Miscellaneous |
$6.722 |
$8.914 |
$11.603 |
$14.092 |
$14.092 |
$14.092 |
$14.092 |
$14.092 |
$14.092 |
$14.092 |
$14.092 |
$14.092 |
$154.067 |
$169.474 |
$186.421 |
|
|
|
|
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
|
|
|
Total Cost of Sales |
$242.577 |
$314.769 |
$395.922 |
$465.879 |
$465.879 |
$465.879 |
$465.879 |
$465.879 |
$465.879 |
$465.879 |
$465.879 |
$465.879 |
$5.146.179 |
$6.167.315 |
$7.073.111 |
|
|
|
Gross Margin |
$1.028.823 |
$1.380.431 |
$1.807.878 |
$2.213.561 |
$2.213.561 |
$2.213.561 |
$2.213.561 |
$2.213.561 |
$2.213.561 |
$2.213.561 |
$2.213.561 |
$2.213.561 |
$24.139.181 |
$27.593.490 |
$30.120.039 |
|
|
|
Gross Margin % |
80,92% |
81,43% |
82,03% |
82,61% |
82,61% |
82,61% |
82,61% |
82,61% |
82,61% |
82,61% |
82,61% |
82,61% |
82,43% |
81,73% |
80,98% |
|
|
|
Operating expenses: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales and Marketing Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales and Marketing Payroll |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$6.698 |
$80.376 |
$84.395 |
$88.615 |
|
|
|
Advertising/Promotion |
$3.000 |
$3.000 |
$3.000 |
$3.000 |
$3.000 |
$3.000 |
$3.000 |
$3.000 |
$3.000 |
$3.000 |
$3.000 |
$3.000 |
$36.000 |
$39.600 |
$44.560 |
|
|
|
Travel |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$60.000 |
$66.600 |
$73.260 |
|
|
|
Miscellaneous |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$2.000 |
$24.000 |
$26.400 |
$29.040 |
|
|
|
Other |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$12.000 |
$13.200 |
$14.520 |
|
|
|
|
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
|
|
|
Total Sales and Marketing Expenses |
$17.698 |
$17.698 |
$17.698 |
$17.698 |
$17.698 |
$17.698 |
$17.698 |
$17.698 |
$17.698 |
$17.698 |
$17.698 |
$17.698 |
$212.376 |
$230.195 |
$249.995 |
|
|
|
Sales and Marketing % |
1,39% |
1,04% |
0,80% |
0,66% |
0,66% |
0,66% |
0,66% |
0,66% |
0,66% |
0,66% |
0,66% |
0,66% |
0,73% |
0,68% |
0,67% |
|
|
|
General and Administrative Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
General and Administrative Payroll |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$4.527 |
$54.324 |
$58.040 |
$59.893 |
|
|
|
Payroll Burden |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$10.823 |
$129.876 |
$136.732 |
$143.193 |
|
|
|
Depreciation |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$489.996 |
$490.000 |
$490.000 |
|
|
|
Leased Equipment |
$7.000 |
$7.000 |
$7.000 |
$7.000 |
$7.000 |
$7.000 |
$7.000 |
$7.000 |
$7.000 |
$7.000 |
$7.000 |
$7.000 |
$84.000 |
$84.000 |
$84.000 |
|
|
|
Utilities |
$87.089 |
$87.089 |
$87.089 |
$87.089 |
$87.089 |
$87.089 |
$87.089 |
$87.089 |
$87.089 |
$87.089 |
$87.089 |
$87.089 |
$1.045.068 |
$1.201.828 |
$1.382.102 |
|
|
|
Insurance |
$4.600 |
$4.600 |
$4.600 |
$4.600 |
$4.600 |
$4.600 |
$4.600 |
$4.600 |
$4.600 |
$4.600 |
$4.600 |
$4.600 |
$55.200 |
$57.960 |
$60.858 |
|
|
|
Rent |
$1.667 |
$1.667 |
$1.667 |
$1.667 |
$1.667 |
$1.667 |
$1.667 |
$1.667 |
$1.667 |
$1.667 |
$1.667 |
$1.667 |
$20.004 |
$22.004 |
$22.205 |
|
|
|
Other |
$3.558 |
$3.558 |
$3.558 |
$3.558 |
$3.558 |
$3.558 |
$3.558 |
$3.558 |
$3.558 |
$3.558 |
$3.558 |
$3.558 |
$42.696 |
$46.966 |
$51.662 |
|
|
|
|
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
|
|
|
Total General and Administrative Expenses |
$160.097 |
$160.097 |
$160.097 |
$160.097 |
$160.097 |
$160.097 |
$160.097 |
$160.097 |
$160.097 |
$160.097 |
$160.097 |
$160.097 |
$1.921.164 |
$2.097.530 |
$2.293.913 |
|
|
|
General and Administrative % |
12,59% |
9,44% |
7,26% |
5,98% |
5,98% |
5,98% |
5,98% |
5,98% |
5,98% |
5,98% |
5,98% |
5,98% |
6,56% |
6,21% |
6,17% |
|
|
|
Other Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other Payroll |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$3.500 |
$42.000 |
$44.100 |
$46.305 |
|
|
|
Contract/Consultants |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$60.000 |
$66.600 |
$73.260 |
|
|
|
Other |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$1.000 |
$12.000 |
$13.200 |
$14.520 |
|
|
|
|
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
|
|
|
Total Other Expenses |
$9.500 |
$9.500 |
$9.500 |
$9.500 |
$9.500 |
$9.500 |
$9.500 |
$9.500 |
$9.500 |
$9.500 |
$9.500 |
$9.500 |
$114.000 |
$123.900 |
$134.085 |
|
|
|
Other % |
0,75% |
0,56% |
0,43% |
0,35% |
0,35% |
0,35% |
0,35% |
0,35% |
0,35% |
0,35% |
0,35% |
0,35% |
0,39% |
0,37% |
0,36% |
|
|
|
|
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
------------ |
|
|
|
Total Operating Expenses |
$187.295 |
$187.295 |
$187.295 |
$187.295 |
$187.295 |
$187.295 |
$187.295 |
$187.295 |
$187.295 |
$187.295 |
$187.295 |
$187.295 |
$2.247.540 |
$2.451.625 |
$2.677.993 |
|
|
|
Profit Before Interest and Taxes |
$841.528 |
$1.193.136 |
$1.620.583 |
$2.026.266 |
$2.026.266 |
$2.026.266 |
$2.026.266 |
$2.026.266 |
$2.026.266 |
$2.026.266 |
$2.026.266 |
$2.026.266 |
$21.891.641 |
$25.141.865 |
$27.442.046 |
|
|
|
Interest Expense Short-term |
$4.333 |
$8.125 |
$8.179 |
$8.233 |
$8.288 |
$8.342 |
$8.396 |
$8.450 |
$8.504 |
$8.558 |
$8.613 |
$8.667 |
$96.688 |
$107.900 |
$115.700 |
|
|
|
Interest Expense Long-term |
$66.696 |
$65.893 |
$65.089 |
$64.286 |
$63.482 |
$62.679 |
$61.875 |
$61.071 |
$60.268 |
$59.464 |
$58.661 |
$57.857 |
$747.321 |
$636.428 |
$520.714 |
|
|
|
Taxes Incurred |
$269.674 |
$391.691 |
$541.560 |
$683.811 |
$684.074 |
$684.336 |
$684.598 |
$684.861 |
$685.123 |
$685.385 |
$685.647 |
$685.910 |
$7.366.671 |
$8.539.138 |
$9.381.971 |
|
|
|
Net Profit |
$500.824 |
$727.427 |
$1.005.754 |
$1.269.935 |
$1.270.423 |
$1.270.910 |
$1.271.397 |
$1.271.884 |
$1.272.371 |
$1.272.858 |
$1.273.345 |
$1.273.832 |
$13.680.961 |
$15.858.399 |
$17.423.661 |
|
|
|
Net Profit/Sales |
39,39% |
42,91% |
45,64% |
47,40% |
47,41% |
47,43% |
47,45% |
47,47% |
47,49% |
47,50% |
47,52% |
47,54% |
46,72% |
46,97% |
46,85% |
|
|
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
|
|
|
Net Profit |
$500.824 |
$727.427 |
$1.005.754 |
$1.269.935 |
$1.270.423 |
$1.270.910 |
$1.271.397 |
$1.271.884 |
$1.272.371 |
$1.272.858 |
$1.273.345 |
$1.273.832 |
$13.680.961 |
$15.858.399 |
$17.423.661 |
|
|
|
Plus: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Depreciation |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$40.833 |
$489.996 |
$490.000 |
$490.000 |
|
|
|
Change in Accounts Payable |
($135.908) |
$12.380 |
$26.989 |
($83.461) |
$0 |
$0 |
$0 |
$127.554 |
($127.554) |
$0 |
$0 |
$0 |
($180.000) |
$0 |
$0 |
|
|
|
Current Borrowing (repayment) |
$350.000 |
$350.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$5.000 |
$750.000 |
$60.000 |
$60.000 |
|
|
|
Increase (decrease) Other Liabilities |
($17.500) |
($4.000) |
($1.000) |
($4.000) |
($1.000) |
($4.000) |
($14.000) |
($4.000) |
($1.000) |
($4.000) |
($1.000) |
($4.000) |
($59.500) |
($59.500) |
($59.500) |
|
|
|
Long-term Borrowing (repayment) |
($107.143) |
($107.143) |
($107.143) |
($107.143) |
($107.143) |
($107.143) |
($107.143) |
($107.143) |
($107.143) |
($107.143) |
($107.143) |
($107.143) |
($1.285.716) |
($1.285.716) |
($1.285.716) |
|
|
|
Capital Input |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
|
Subtotal |
$631.106 |
$1.019.497 |
$970.434 |
$1.121.164 |
$1.208.113 |
$1.205.600 |
$1.196.087 |
$1.334.128 |
$1.082.507 |
$1.207.548 |
$1.211.035 |
$1.208.522 |
$13.395.741 |
$15.063.183 |
$16.628.445 |
|
|
|
Less: |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
|
|
|
Change in Accounts Receivable |
$1.017.120 |
$989.254 |
$601.959 |
$416.739 |
$190.256 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$3.215.328 |
$491.373 |
$376.848 |
|
|
|
Change in Inventory |
($220.516) |
($290.516) |
($243.498) |
$101.202 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
($653.328) |
$83.757 |
$61.833 |
|
|
|
Change in Other ST Assets |
($1.000) |
($1.000) |
($1.000) |
($1.000) |
($1.000) |
($1.000) |
($1.000) |
($1.000) |
($1.000) |
($1.000) |
($1.000) |
($1.000) |
($12.000) |
($13.200) |
($14.520) |
|
|
|
Capital Expenditure |
($20.000) |
($20.000) |
($20.000) |
($20.000) |
($20.000) |
($20.000) |
($20.000) |
($20.000) |
($20.000) |
($20.000) |
($20.000) |
($20.000) |
($240.000) |
($264.000) |
($290.000) |
|
|
|
Dividends |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$7.500.000 |
$15.000.000 |
|
|
|
Subtotal |
$775.604 |
$677.738 |
$337.461 |
$496.941 |
$169.256 |
($21.000) |
($21.000) |
($21.000) |
($21.000) |
($21.000) |
($21.000) |
($21.000) |
$2.310.000 |
$7.797.929 |
$15.134.161 |
|
|
|
Net Cash Flow |
($144.498) |
$341.759 |
$632.972 |
$624.223 |
$1.038.857 |
$1.226.600 |
$1.217.087 |
$1.355.128 |
$1.103.507 |
$1.228.548 |
$1.232.035 |
$1.229.522 |
$11.085.741 |
$7.265.253 |
$1.494.284 |
|
|
|
Cash Balance |
$5.502 |
$347.261 |
$980.233 |
$1.604.457 |
$2.643.313 |
$3.869.913 |
$5.087.000 |
$6.442.127 |
$7.545.635 |
$8.774.183 |
$10.006.218 |
$11.235.741 |
$11.235.741 |
$18.500.994 |
$19.995.278 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Short-term Assets |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
|
|
|
Cash |
$5.502 |
$347.261 |
$980.233 |
$1.604.457 |
$2.643.313 |
$3.869.913 |
$5.087.000 |
$6.442.127 |
$7.545.635 |
$8.774.183 |
$10.006.218 |
$11.235.741 |
$11.235.741 |
$18.500.994 |
$19.995.278 |
|
|
|
Accounts Receivable |
$1.017.120 |
$2.006.374 |
$2.608.333 |
$3.025.072 |
$3.215.328 |
$3.215.328 |
$3.215.328 |
$3.215.328 |
$3.215.328 |
$3.215.328 |
$3.215.328 |
$3.215.328 |
$3.215.328 |
$3.706.701 |
$4.083.548 |
|
|
|
Inventory |
$1.087.484 |
$796.968 |
$553.470 |
$654.672 |
$654.672 |
$654.672 |
$654.672 |
$654.672 |
$654.672 |
$654.672 |
$654.672 |
$654.672 |
$654.672 |
$738.429 |
$800.262 |
|
|
|
Other Short-term Assets |
$109.000 |
$108.000 |
$107.000 |
$106.000 |
$105.000 |
$104.000 |
$103.000 |
$102.000 |
$101.000 |
$100.000 |
$99.000 |
$98.000 |
$98.000 |
$84.800 |
$70.280 |
|
|
|
Total Short-term Assets |
$2.219.106 |
$3.258.603 |
$4.249.036 |
$5.390.201 |
$6.618.313 |
$7.843.913 |
$9.060.000 |
$10.414.127 |
$11.516.635 |
$12.744.183 |
$13.975.218 |
$15.203.741 |
$15.203.741 |
$23.030.923 |
$24.949.368 |
|
|
|
Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Capital Assets |
$4.880.000 |
$4.860.000 |
$4.840.000 |
$4.820.000 |
$4.800.000 |
$4.780.000 |
$4.760.000 |
$4.740.000 |
$4.720.000 |
$4.700.000 |
$4.680.000 |
$4.660.000 |
$4.660.000 |
$4.396.000 |
$4.106.000 |
|
|
|
Accumulated Depreciation |
$40.833 |
$81.666 |
$122.499 |
$163.332 |
$204.165 |
$244.998 |
$285.831 |
$326.664 |
$367.497 |
$408.330 |
$449.163 |
$489.996 |
$489.996 |
$979.996 |
$1.469.996 |
|
|
|
Total Long-term Assets |
$4.839.167 |
$4.778.334 |
$4.717.501 |
$4.656.668 |
$4.595.835 |
$4.535.002 |
$4.474.169 |
$4.413.336 |
$4.352.503 |
$4.291.670 |
$4.230.837 |
$4.170.004 |
$4.170.004 |
$3.416.004 |
$2.636.004 |
|
|
|
Total Assets |
$7.058.273 |
$8.036.937 |
$8.966.537 |
$10.046.869 |
$11.214.148 |
$12.378.915 |
$13.534.169 |
$14.827.463 |
$15.869.138 |
$17.035.853 |
$18.206.055 |
$19.373.745 |
$19.373.745 |
$26.446.927 |
$27.585.372 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Liabilities and Capital |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
2002 |
2003 |
2004 |
|
|
|
Accounts Payable |
$44.092 |
$56.472 |
$83.461 |
$0 |
$0 |
$0 |
$0 |
$127.554 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
|
Short-term Notes |
$400.000 |
$750.000 |
$755.000 |
$760.000 |
$765.000 |
$770.000 |
$775.000 |
$780.000 |
$785.000 |
$790.000 |
$795.000 |
$800.000 |
$800.000 |
$860.000 |
$920.000 |
|
|
|
Other Short-term Liabilities |
($7.500) |
($11.500) |
($12.500) |
($16.500) |
($17.500) |
($21.500) |
($35.500) |
($39.500) |
($40.500) |
($44.500) |
($45.500) |
($49.500) |
($49.500) |
($109.000) |
($168.500) |
|
|
|
Subtotal Short-term Liabilities |
$436.592 |
$794.972 |
$825.961 |
$743.500 |
$747.500 |
$748.500 |
$739.500 |
$868.054 |
$744.500 |
$745.500 |
$749.500 |
$750.500 |
$750.500 |
$751.000 |
$751.500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long-term Liabilities |
$8.892.857 |
$8.785.714 |
$8.678.571 |
$8.571.428 |
$8.464.285 |
$8.357.142 |
$8.249.999 |
$8.142.856 |
$8.035.713 |
$7.928.570 |
$7.821.427 |
$7.714.284 |
$7.714.284 |
$6.428.568 |
$5.142.852 |
|
|
|
Total Liabilities |
$9.329.449 |
$9.580.686 |
$9.504.532 |
$9.314.928 |
$9.211.785 |
$9.105.642 |
$8.989.499 |
$9.010.910 |
$8.780.213 |
$8.674.070 |
$8.570.927 |
$8.464.784 |
$8.464.784 |
$7.179.568 |
$5.894.352 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Paid in Capital |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
$2.000.000 |
|
|
|
Retained Earnings |
($4.772.000) |
($4.772.000) |
($4.772.000) |
($4.772.000) |
($4.772.000) |
($4.772.000) |
($4.772.000) |
($4.772.000) |
($4.772.000) |
($4.772.000) |
($4.772.000) |
($4.772.000) |
($4.772.000) |
$1.408.961 |
$2.267.359 |
|
|
|
Earnings |
$500.824 |
$1.228.251 |
$2.234.005 |
$3.503.941 |
$4.774.363 |
$6.045.273 |
$7.316.670 |
$8.588.554 |
$9.860.925 |
$11.133.783 |
$12.407.128 |
$13.680.961 |
$13.680.961 |
$15.858.399 |
$17.423.661 |
|
|
|
Total Capital |
($2.271.176) |
($1.543.749) |
($537.995) |
$731.941 |
$2.002.363 |
$3.273.273 |
$4.544.670 |
$5.816.554 |
$7.088.925 |
$8.361.783 |
$9.635.128 |
$10.908.961 |
$10.908.961 |
$19.267.359 |
$21.691.020 |
|
|
|
Total Liabilities and Capital |
$7.058.273 |
$8.036.937 |
$8.966.537 |
$10.046.869 |
$11.214.148 |
$12.378.915 |
$13.534.169 |
$14.827.463 |
$15.869.138 |
$17.035.853 |
$18.206.055 |
$19.373.745 |
$19.373.745 |
$26.446.927 |
$27.585.372 |
|
|
|
Net Worth |
($2.271.176) |
($1.543.749) |
($537.995) |
$731.941 |
$2.002.363 |
$3.273.273 |
$4.544.670 |
$5.816.554 |
$7.088.925 |
$8.361.783 |
$9.635.128 |
$10.908.961 |
$10.908.961 |
$19.267.359 |
$21.691.020 |
|
|