Botanical Bounty

Start your own business plan »

Agriculture Farm Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Supplement Companies 0% $300 $432 $565 $2,002 $3,222 $4,323 $4,655 $5,232 $5,989 $6,000 $5,232 $3,433
Processors 0% $258 $372 $486 $1,722 $2,771 $3,718 $4,003 $4,500 $5,151 $5,160 $4,500 $2,952
Nurseries 0% $57 $82 $107 $380 $612 $821 $884 $994 $1,138 $1,140 $994 $652
Total Sales $615 $886 $1,158 $4,104 $6,605 $8,862 $9,543 $10,726 $12,277 $12,300 $10,726 $7,038
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Supplement companies $23 $32 $42 $150 $242 $324 $349 $392 $449 $450 $392 $257
Processors $19 $28 $36 $129 $208 $279 $300 $337 $386 $387 $337 $221
Nurseries $4 $6 $8 $29 $46 $62 $66 $75 $85 $86 $75 $49
Subtotal Direct Cost of Sales $46 $66 $87 $308 $495 $665 $716 $804 $921 $923 $804 $528
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
David 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Sue 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Grower 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Laborers 0% $1,000 $1,000 $2,000 $2,000 $3,000 $4,000 $4,000 $4,000 $2,000 $2,000 $1,000 $1,000
Total People 4 4 5 5 6 7 7 7 5 5 4 4
Total Payroll $6,000 $6,000 $7,000 $7,000 $8,000 $9,000 $9,000 $9,000 $7,000 $7,000 $6,000 $6,000
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $615 $886 $1,158 $4,104 $6,605 $8,862 $9,543 $10,726 $12,277 $12,300 $10,726 $7,038
Direct Cost of Sales $46 $66 $87 $308 $495 $665 $716 $804 $921 $923 $804 $528
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $46 $66 $87 $308 $495 $665 $716 $804 $921 $923 $804 $528
Gross Margin $569 $819 $1,071 $3,796 $6,110 $8,197 $8,827 $9,921 $11,357 $11,378 $9,921 $6,510
Gross Margin % 92.50% 92.50% 92.50% 92.50% 92.50% 92.50% 92.50% 92.50% 92.50% 92.50% 92.50% 92.50%
Expenses
Payroll $6,000 $6,000 $7,000 $7,000 $8,000 $9,000 $9,000 $9,000 $7,000 $7,000 $6,000 $6,000
Sales and Marketing and Other Expenses $400 $3,000 $400 $400 $400 $400 $400 $3,000 $400 $400 $400 $400
Depreciation $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $583 $583
Mortgage $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Utilities $500 $500 $500 $600 $700 $700 $700 $700 $600 $500 $500 $500
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 15% $900 $900 $1,050 $1,050 $1,200 $1,350 $1,350 $1,350 $1,050 $1,050 $900 $900
Other $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Total Operating Expenses $10,783 $13,383 $11,933 $12,033 $13,283 $14,433 $14,433 $17,033 $12,033 $11,933 $10,783 $10,783
Profit Before Interest and Taxes ($10,214) ($12,564) ($10,862) ($8,237) ($7,173) ($6,236) ($5,606) ($7,112) ($676) ($556) ($862) ($4,273)
EBITDA ($9,631) ($11,981) ($10,279) ($7,654) ($6,590) ($5,653) ($5,023) ($6,529) ($93) $28 ($279) ($3,690)
Interest Expense $333 $333 $332 $330 $328 $327 $325 $323 $322 $320 $318 $317
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($10,547) ($12,897) ($11,193) ($8,567) ($7,502) ($6,562) ($5,931) ($7,435) ($998) ($876) ($1,180) ($4,590)
Net Profit/Sales -1715.03% -1456.32% -966.40% -208.74% -113.57% -74.05% -62.15% -69.32% -8.13% -7.12% -11.00% -65.22%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $154 $221 $290 $1,026 $1,651 $2,216 $2,386 $2,681 $3,069 $3,075 $2,681 $1,759
Cash from Receivables $4,000 $4,015 $468 $671 $942 $3,141 $5,010 $6,664 $7,187 $8,083 $9,209 $9,186
Subtotal Cash from Operations $4,154 $4,237 $758 $1,697 $2,594 $5,356 $7,396 $9,345 $10,256 $11,158 $11,890 $10,945
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $100,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $104,154 $4,237 $758 $1,697 $2,594 $5,356 $7,396 $9,345 $10,256 $11,158 $11,890 $10,945
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $6,000 $6,000 $7,000 $7,000 $8,000 $9,000 $9,000 $9,000 $7,000 $7,000 $6,000 $6,000
Bill Payments $13,243 $4,667 $7,119 $4,779 $5,102 $5,534 $5,843 $5,980 $8,482 $5,689 $5,584 $5,313
Subtotal Spent on Operations $19,243 $10,667 $14,119 $11,779 $13,102 $14,534 $14,843 $14,980 $15,482 $12,689 $11,584 $11,313
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $35,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $54,243 $10,667 $14,619 $12,279 $13,602 $15,034 $15,343 $15,480 $15,982 $13,189 $12,084 $11,813
Net Cash Flow $49,911 ($6,430) ($13,861) ($10,582) ($11,009) ($9,678) ($7,947) ($6,135) ($5,726) ($2,031) ($193) ($868)
Cash Balance $84,911 $78,481 $64,620 $54,038 $43,029 $33,351 $25,404 $19,269 $13,543 $11,512 $11,318 $10,450
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $35,000 $84,911 $78,481 $64,620 $54,038 $43,029 $33,351 $25,404 $19,269 $13,543 $11,512 $11,318 $10,450
Accounts Receivable $8,000 $4,461 $1,110 $1,511 $3,918 $7,929 $11,435 $13,582 $14,963 $16,984 $18,126 $16,962 $13,054
Other Current Assets $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Total Current Assets $47,000 $93,372 $83,591 $70,131 $61,956 $54,958 $48,786 $42,986 $38,231 $34,527 $33,638 $32,280 $27,504
Long-term Assets
Long-term Assets $35,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000
Accumulated Depreciation $7,000 $7,583 $8,166 $8,749 $9,332 $9,915 $10,498 $11,081 $11,664 $12,247 $12,830 $13,413 $13,996
Total Long-term Assets $28,000 $62,417 $61,834 $61,251 $60,668 $60,085 $59,502 $58,919 $58,336 $57,753 $57,170 $56,587 $56,004
Total Assets $75,000 $155,789 $145,425 $131,382 $122,624 $115,043 $108,288 $101,905 $96,567 $92,280 $90,808 $88,867 $83,508
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $13,090 $4,427 $6,960 $4,610 $4,918 $5,340 $5,647 $5,694 $8,292 $5,503 $5,406 $5,145 $4,876
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $13,090 $4,427 $6,960 $4,610 $4,918 $5,340 $5,647 $5,694 $8,292 $5,503 $5,406 $5,145 $4,876
Long-term Liabilities $0 $100,000 $100,000 $99,500 $99,000 $98,500 $98,000 $97,500 $97,000 $96,500 $96,000 $95,500 $95,000
Total Liabilities $13,090 $104,427 $106,960 $104,110 $103,918 $103,840 $103,647 $103,194 $105,292 $102,003 $101,406 $100,645 $99,876
Paid-in Capital $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retained Earnings $61,910 $61,910 $61,910 $61,910 $61,910 $61,910 $61,910 $61,910 $61,910 $61,910 $61,910 $61,910 $61,910
Earnings $0 ($10,547) ($23,445) ($34,638) ($43,205) ($50,706) ($57,268) ($63,199) ($70,635) ($71,633) ($72,508) ($73,688) ($78,278)
Total Capital $61,910 $51,363 $38,465 $27,272 $18,705 $11,204 $4,642 ($1,289) ($8,725) ($9,723) ($10,598) ($11,778) ($16,368)
Total Liabilities and Capital $75,000 $155,789 $145,425 $131,382 $122,624 $115,043 $108,288 $101,905 $96,567 $92,280 $90,808 $88,867 $83,508
Net Worth $61,910 $51,363 $38,465 $27,272 $18,705 $11,204 $4,642 ($1,289) ($8,725) ($9,723) ($10,598) ($11,778) ($16,368)