| 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) |