| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Supermarkets | 0% | $40,000 | $40,000 | $45,000 | $45,000 | $50,000 | $60,000 | $60,000 | $60,000 | $65,000 | $65,000 | $65,000 | $65,000 |
| Large Upscale Natural Food Stores | 0% | $15,000 | $15,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $25,000 | $25,000 | $25,000 | $25,000 |
| Small Natural Food Stores | 0% | $5,000 | $5,000 | $5,000 | $5,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Sales | $60,000 | $60,000 | $70,000 | $70,000 | $80,000 | $90,000 | $90,000 | $90,000 | $100,000 | $100,000 | $100,000 | $100,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Supermarkets | $8,500 | $8,500 | $10,000 | $10,000 | $12,000 | $14,000 | $14,000 | $14,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
| Large Upscale Natural Food Stores | $3,000 | $3,500 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $6,000 | $6,000 | $6,000 | $6,000 | |
| Small Natural Food Stores | $1,000 | $1,000 | $1,000 | $1,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $12,500 | $13,000 | $15,900 | $15,900 | $18,900 | $20,900 | $20,900 | $20,900 | $23,000 | $23,000 | $23,000 | $23,000 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Jean Simmons | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Sales Manager | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Production Staff | 0% | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
| Distribution Staff | 0% | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
| Sales Staff | 0% | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 |
| Total People | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | |
| Total Payroll | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,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 | 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | $60,000 | $60,000 | $70,000 | $70,000 | $80,000 | $90,000 | $90,000 | $90,000 | $100,000 | $100,000 | $100,000 | $100,000 | |
| Direct Cost of Sales | $12,500 | $13,000 | $15,900 | $15,900 | $18,900 | $20,900 | $20,900 | $20,900 | $23,000 | $23,000 | $23,000 | $23,000 | |
| Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $12,500 | $13,000 | $15,900 | $15,900 | $18,900 | $20,900 | $20,900 | $20,900 | $23,000 | $23,000 | $23,000 | $23,000 | |
| Gross Margin | $47,500 | $47,000 | $54,100 | $54,100 | $61,100 | $69,100 | $69,100 | $69,100 | $77,000 | $77,000 | $77,000 | $77,000 | |
| Gross Margin % | 79.17% | 78.33% | 77.29% | 77.29% | 76.38% | 76.78% | 76.78% | 76.78% | 77.00% | 77.00% | 77.00% | 77.00% | |
| Expenses | |||||||||||||
| Payroll | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | |
| Sales and Marketing and Other Expenses | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
| Depreciation | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
| Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Insurance | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
| Rent | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Payroll Taxes | 15% | $5,700 | $5,700 | $5,700 | $5,700 | $5,700 | $5,700 | $5,700 | $5,700 | $5,700 | $5,700 | $5,700 | $5,700 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $55,300 | $55,300 | $55,300 | $55,300 | $55,300 | $55,300 | $55,300 | $55,300 | $55,300 | $55,300 | $55,300 | $55,300 | |
| Profit Before Interest and Taxes | ($7,800) | ($8,300) | ($1,200) | ($1,200) | $5,800 | $13,800 | $13,800 | $13,800 | $21,700 | $21,700 | $21,700 | $21,700 | |
| EBITDA | ($7,000) | ($7,500) | ($400) | ($400) | $6,600 | $14,600 | $14,600 | $14,600 | $22,500 | $22,500 | $22,500 | $22,500 | |
| Interest Expense | $401 | $469 | $538 | $606 | $674 | $742 | $810 | $878 | $946 | $1,014 | $1,082 | $1,151 | |
| Taxes Incurred | ($2,460) | ($2,631) | ($521) | ($542) | $1,538 | $3,917 | $3,897 | $3,877 | $6,226 | $6,206 | $6,185 | $6,165 | |
| Net Profit | ($5,741) | ($6,139) | ($1,216) | ($1,264) | $3,588 | $9,141 | $9,093 | $9,046 | $14,528 | $14,480 | $14,433 | $14,384 | |
| Net Profit/Sales | -9.57% | -10.23% | -1.74% | -1.81% | 4.49% | 10.16% | 10.10% | 10.05% | 14.53% | 14.48% | 14.43% | 14.38% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | $15,000 | $15,000 | $17,500 | $17,500 | $20,000 | $22,500 | $22,500 | $22,500 | $25,000 | $25,000 | $25,000 | $25,000 | |
| Cash from Receivables | $40,000 | $41,500 | $45,000 | $45,250 | $52,500 | $52,750 | $60,250 | $67,500 | $67,500 | $67,750 | $75,000 | $75,000 | |
| Subtotal Cash from Operations | $55,000 | $56,500 | $62,500 | $62,750 | $72,500 | $75,250 | $82,750 | $90,000 | $92,500 | $92,750 | $100,000 | $100,000 | |
| 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 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,500 | |
| New Other Liabilities (interest-free) | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| New Long-term Liabilities | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| 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 | $69,333 | $70,833 | $76,833 | $77,083 | $86,833 | $89,583 | $97,083 | $104,333 | $106,833 | $107,083 | $114,333 | $114,500 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | $38,000 | |
| Bill Payments | $21,023 | $30,598 | $28,146 | $35,502 | $32,745 | $41,023 | $44,187 | $42,108 | $42,382 | $48,907 | $46,721 | $46,769 | |
| Subtotal Spent on Operations | $59,023 | $68,598 | $66,146 | $73,502 | $70,745 | $79,023 | $82,187 | $80,108 | $80,382 | $86,907 | $84,721 | $84,769 | |
| 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 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | |
| Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Long-term Liabilities Principal Repayment | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Purchase Other Current Assets | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Purchase Long-term Assets | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Spent | $66,189 | $75,764 | $73,312 | $80,668 | $77,911 | $86,189 | $89,353 | $87,274 | $87,548 | $94,073 | $91,887 | $91,935 | |
| Net Cash Flow | $3,144 | ($4,931) | $3,521 | ($3,585) | $8,922 | $3,394 | $7,730 | $17,059 | $19,285 | $13,010 | $22,446 | $22,565 | |
| Cash Balance | $43,144 | $38,213 | $41,735 | $38,150 | $47,072 | $50,465 | $58,195 | $75,254 | $94,539 | $107,549 | $129,995 | $152,560 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $40,000 | $43,144 | $38,213 | $41,735 | $38,150 | $47,072 | $50,465 | $58,195 | $75,254 | $94,539 | $107,549 | $129,995 | $152,560 |
| Accounts Receivable | $80,000 | $85,000 | $88,500 | $96,000 | $103,250 | $110,750 | $125,500 | $132,750 | $132,750 | $140,250 | $147,500 | $147,500 | $147,500 |
| Inventory | $10,000 | $13,750 | $14,300 | $17,490 | $17,490 | $20,790 | $22,990 | $22,990 | $22,990 | $25,300 | $25,300 | $25,300 | $25,300 |
| Other Current Assets | $5,000 | $7,000 | $9,000 | $11,000 | $13,000 | $15,000 | $17,000 | $19,000 | $21,000 | $23,000 | $25,000 | $27,000 | $29,000 |
| Total Current Assets | $135,000 | $148,894 | $150,013 | $166,225 | $171,890 | $193,612 | $215,955 | $232,935 | $251,994 | $283,089 | $305,349 | $329,795 | $354,360 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $50,000 | $52,000 | $54,000 | $56,000 | $58,000 | $60,000 | $62,000 | $64,000 | $66,000 | $68,000 | $70,000 | $72,000 | $74,000 |
| Accumulated Depreciation | $12,000 | $12,800 | $13,600 | $14,400 | $15,200 | $16,000 | $16,800 | $17,600 | $18,400 | $19,200 | $20,000 | $20,800 | $21,600 |
| Total Long-term Assets | $38,000 | $39,200 | $40,400 | $41,600 | $42,800 | $44,000 | $45,200 | $46,400 | $47,600 | $48,800 | $50,000 | $51,200 | $52,400 |
| Total Assets | $173,000 | $188,094 | $190,413 | $207,825 | $214,690 | $237,612 | $261,155 | $279,335 | $299,594 | $331,889 | $355,349 | $380,995 | $406,760 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $20,000 | $29,668 | $26,959 | $34,419 | $31,382 | $39,548 | $42,784 | $40,703 | $40,749 | $47,349 | $45,162 | $45,208 | $45,255 |
| Current Borrowing | $0 | $6,667 | $13,334 | $20,001 | $26,668 | $33,335 | $40,002 | $46,669 | $53,336 | $60,003 | $66,670 | $73,337 | $80,171 |
| Other Current Liabilities | $0 | $3,000 | $6,000 | $9,000 | $12,000 | $15,000 | $18,000 | $21,000 | $24,000 | $27,000 | $30,000 | $33,000 | $36,000 |
| Subtotal Current Liabilities | $20,000 | $39,335 | $46,293 | $63,420 | $70,050 | $87,883 | $100,786 | $108,372 | $118,085 | $134,352 | $141,832 | $151,545 | $161,426 |
| Long-term Liabilities | $40,000 | $41,500 | $43,000 | $44,500 | $46,000 | $47,500 | $49,000 | $50,500 | $52,000 | $53,500 | $55,000 | $56,500 | $58,000 |
| Total Liabilities | $60,000 | $80,835 | $89,293 | $107,920 | $116,050 | $135,383 | $149,786 | $158,872 | $170,085 | $187,852 | $196,832 | $208,045 | $219,426 |
| Paid-in Capital | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 |
| Retained Earnings | $9,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 | $33,000 |
| Earnings | $24,000 | ($5,741) | ($11,880) | ($13,096) | ($14,360) | ($10,771) | ($1,630) | $7,463 | $16,508 | $31,036 | $45,516 | $59,949 | $74,333 |
| Total Capital | $113,000 | $107,259 | $101,120 | $99,904 | $98,640 | $102,229 | $111,370 | $120,463 | $129,508 | $144,036 | $158,516 | $172,949 | $187,333 |
| Total Liabilities and Capital | $173,000 | $188,094 | $190,413 | $207,825 | $214,690 | $237,612 | $261,155 | $279,335 | $299,594 | $331,889 | $355,349 | $380,995 | $406,760 |
| Net Worth | $113,000 | $107,259 | $101,120 | $99,904 | $98,640 | $102,229 | $111,370 | $120,463 | $129,508 | $144,036 | $158,516 | $172,949 | $187,333 |