| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Herbal Products | 0% | $0 | $10,000 | $12,000 | $14,000 | $18,000 | $22,000 | $26,000 | $36,000 | $40,000 | $36,000 | $32,000 | $36,000 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Sales | $0 | $10,000 | $12,000 | $14,000 | $18,000 | $22,000 | $26,000 | $36,000 | $40,000 | $36,000 | $32,000 | $36,000 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Herbal Products | $0 | $5,000 | $6,000 | $7,000 | $9,000 | $11,000 | $13,000 | $18,000 | $20,000 | $18,000 | $16,000 | $18,000 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $0 | $5,000 | $6,000 | $7,000 | $9,000 | $11,000 | $13,000 | $18,000 | $20,000 | $18,000 | $16,000 | $18,000 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Joanne Lovejoy | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| 2 Production Staff | 0% | $3,400 | $3,400 | $3,400 | $3,400 | $3,400 | $3,400 | $3,400 | $3,400 | $3,400 | $3,400 | $3,400 | $3,400 |
| P/T Production Staff | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | $0 | $10,000 | $12,000 | $14,000 | $18,000 | $22,000 | $26,000 | $36,000 | $40,000 | $36,000 | $32,000 | $36,000 | |
| Direct Cost of Sales | $0 | $5,000 | $6,000 | $7,000 | $9,000 | $11,000 | $13,000 | $18,000 | $20,000 | $18,000 | $16,000 | $18,000 | |
| Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $5,000 | $6,000 | $7,000 | $9,000 | $11,000 | $13,000 | $18,000 | $20,000 | $18,000 | $16,000 | $18,000 | |
| Gross Margin | $0 | $5,000 | $6,000 | $7,000 | $9,000 | $11,000 | $13,000 | $18,000 | $20,000 | $18,000 | $16,000 | $18,000 | |
| Gross Margin % | 0.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | |
| Expenses | |||||||||||||
| Payroll | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | |
| Sales and Marketing and Other Expenses | $380 | $380 | $380 | $380 | $380 | $380 | $380 | $230 | $230 | $380 | $380 | $380 | |
| Depreciation | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
| Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
| Insurance | $650 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | |
| Payroll Taxes | 15% | $885 | $885 | $885 | $885 | $885 | $885 | $885 | $885 | $885 | $885 | $885 | $885 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $9,215 | $8,565 | $8,565 | $8,565 | $8,565 | $8,565 | $8,565 | $8,415 | $8,415 | $8,565 | $8,565 | $8,565 | |
| Profit Before Interest and Taxes | ($9,215) | ($3,565) | ($2,565) | ($1,565) | $435 | $2,435 | $4,435 | $9,585 | $11,585 | $9,435 | $7,435 | $9,435 | |
| EBITDA | ($8,815) | ($3,165) | ($2,165) | ($1,165) | $835 | $2,835 | $4,835 | $9,985 | $11,985 | $9,835 | $7,835 | $9,835 | |
| Interest Expense | $411 | $405 | $399 | $393 | $388 | $482 | $472 | $462 | $452 | $442 | $432 | $422 | |
| Taxes Incurred | ($2,888) | ($1,191) | ($889) | ($588) | $14 | $586 | $1,189 | $2,737 | $3,340 | $2,698 | $2,101 | $2,704 | |
| Net Profit | ($6,738) | ($2,779) | ($2,075) | ($1,371) | $33 | $1,367 | $2,774 | $6,386 | $7,793 | $6,295 | $4,902 | $6,309 | |
| Net Profit/Sales | 0.00% | -27.79% | -17.29% | -9.79% | 0.18% | 6.22% | 10.67% | 17.74% | 19.48% | 17.49% | 15.32% | 17.53% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | $0 | $2,500 | $3,000 | $3,500 | $4,500 | $5,500 | $6,500 | $9,000 | $10,000 | $9,000 | $8,000 | $9,000 | |
| Cash from Receivables | $0 | $0 | $250 | $7,550 | $9,050 | $10,600 | $13,600 | $16,600 | $19,750 | $27,100 | $29,900 | $26,900 | |
| Subtotal Cash from Operations | $0 | $2,500 | $3,250 | $11,050 | $13,550 | $16,100 | $20,100 | $25,600 | $29,750 | $36,100 | $37,900 | $35,900 | |
| 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 | $12,000 | $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 | $0 | $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 | $0 | $2,500 | $3,250 | $11,050 | $13,550 | $28,100 | $20,100 | $25,600 | $29,750 | $36,100 | $37,900 | $35,900 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | $5,900 | |
| Bill Payments | $15 | $656 | $7,042 | $8,918 | $10,294 | $13,956 | $16,619 | $19,449 | $28,790 | $27,877 | $21,118 | $18,831 | |
| Subtotal Spent on Operations | $5,915 | $6,556 | $12,942 | $14,818 | $16,194 | $19,856 | $22,519 | $25,349 | $34,690 | $33,777 | $27,018 | $24,731 | |
| 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 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Long-term Liabilities Principal Repayment | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | |
| Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Purchase Long-term Assets | $0 | $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 | $6,615 | $7,256 | $13,642 | $15,518 | $16,894 | $20,556 | $23,719 | $26,549 | $35,890 | $34,977 | $28,218 | $25,931 | |
| Net Cash Flow | ($6,615) | ($4,756) | ($10,392) | ($4,468) | ($3,344) | $7,544 | ($3,619) | ($949) | ($6,140) | $1,123 | $9,682 | $9,969 | |
| Cash Balance | $26,785 | $22,029 | $11,637 | $7,169 | $3,825 | $11,369 | $7,750 | $6,802 | $662 | $1,785 | $11,467 | $21,436 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $33,400 | $26,785 | $22,029 | $11,637 | $7,169 | $3,825 | $11,369 | $7,750 | $6,802 | $662 | $1,785 | $11,467 | $21,436 |
| Accounts Receivable | $0 | $0 | $7,500 | $16,250 | $19,200 | $23,650 | $29,550 | $35,450 | $45,850 | $56,100 | $56,000 | $50,100 | $50,200 |
| Inventory | $5,000 | $5,000 | $5,500 | $6,600 | $7,700 | $9,900 | $12,100 | $14,300 | $19,800 | $22,000 | $19,800 | $17,600 | $19,800 |
| Other Current Assets | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
| Total Current Assets | $43,400 | $36,785 | $40,029 | $39,487 | $39,069 | $42,375 | $58,019 | $62,500 | $77,452 | $83,762 | $82,585 | $84,167 | $96,436 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
| Accumulated Depreciation | $0 | $400 | $800 | $1,200 | $1,600 | $2,000 | $2,400 | $2,800 | $3,200 | $3,600 | $4,000 | $4,400 | $4,800 |
| Total Long-term Assets | $15,000 | $14,600 | $14,200 | $13,800 | $13,400 | $13,000 | $12,600 | $12,200 | $11,800 | $11,400 | $11,000 | $10,600 | $10,200 |
| Total Assets | $58,400 | $51,385 | $54,229 | $53,287 | $52,469 | $55,375 | $70,619 | $74,700 | $89,252 | $95,162 | $93,585 | $94,767 | $106,636 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $0 | $423 | $6,746 | $8,579 | $9,832 | $13,405 | $15,982 | $18,488 | $27,853 | $27,170 | $20,498 | $17,978 | $24,738 |
| Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $12,000 | $11,500 | $11,000 | $10,500 | $10,000 | $9,500 | $9,000 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $0 | $423 | $6,746 | $8,579 | $9,832 | $13,405 | $27,982 | $29,988 | $38,853 | $37,670 | $30,498 | $27,478 | $33,738 |
| Long-term Liabilities | $50,000 | $49,300 | $48,600 | $47,900 | $47,200 | $46,500 | $45,800 | $45,100 | $44,400 | $43,700 | $43,000 | $42,300 | $41,600 |
| Total Liabilities | $50,000 | $49,723 | $55,346 | $56,479 | $57,032 | $59,905 | $73,782 | $75,088 | $83,253 | $81,370 | $73,498 | $69,778 | $75,338 |
| Paid-in Capital | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
| Retained Earnings | ($41,600) | ($41,600) | ($41,600) | ($41,600) | ($41,600) | ($41,600) | ($41,600) | ($41,600) | ($41,600) | ($41,600) | ($41,600) | ($41,600) | ($41,600) |
| Earnings | $0 | ($6,738) | ($9,517) | ($11,592) | ($12,963) | ($12,930) | ($11,562) | ($8,788) | ($2,402) | $5,392 | $11,687 | $16,589 | $22,899 |
| Total Capital | $8,400 | $1,662 | ($1,117) | ($3,192) | ($4,563) | ($4,530) | ($3,162) | ($388) | $5,998 | $13,792 | $20,087 | $24,989 | $31,299 |
| Total Liabilities and Capital | $58,400 | $51,385 | $54,229 | $53,287 | $52,469 | $55,375 | $70,619 | $74,700 | $89,252 | $95,162 | $93,585 | $94,767 | $106,636 |
| Net Worth | $8,400 | $1,662 | ($1,117) | ($3,192) | ($4,563) | ($4,530) | ($3,162) | ($388) | $5,998 | $13,792 | $20,087 | $24,989 | $31,299 |