Last Frontier Market

Start your own business plan »

Organic Food Store Business Plan

Appendix

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
Sales 0% $26,000 $29,000 $30,000 $34,000 $36,000 $38,000 $34,000 $33,000 $35,000 $39,000 $43,000 $46,000
Others 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $26,000 $29,000 $30,000 $34,000 $36,000 $38,000 $34,000 $33,000 $35,000 $39,000 $43,000 $46,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
Sales $9,000 $9,500 $9,600 $10,200 $10,500 $11,300 $10,000 $10,000 $11,000 $12,000 $12,120 $13,000
Others $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $9,000 $9,500 $9,600 $10,200 $10,500 $11,300 $10,000 $10,000 $11,000 $12,000 $12,120 $13,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
Mary Stevens 0% $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800
Josh Wingard 0% $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800
Cashiers 0% $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
Produce Staff 0% $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 People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600
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 $26,000 $29,000 $30,000 $34,000 $36,000 $38,000 $34,000 $33,000 $35,000 $39,000 $43,000 $46,000
Direct Cost of Sales $9,000 $9,500 $9,600 $10,200 $10,500 $11,300 $10,000 $10,000 $11,000 $12,000 $12,120 $13,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $9,000 $9,500 $9,600 $10,200 $10,500 $11,300 $10,000 $10,000 $11,000 $12,000 $12,120 $13,000
Gross Margin $17,000 $19,500 $20,400 $23,800 $25,500 $26,700 $24,000 $23,000 $24,000 $27,000 $30,880 $33,000
Gross Margin % 65.38% 67.24% 68.00% 70.00% 70.83% 70.26% 70.59% 69.70% 68.57% 69.23% 71.81% 71.74%
Expenses
Payroll $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600
Sales and Marketing and Other Expenses $1,000 $1,000 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Depreciation $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120
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 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Rent $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Payroll Taxes 15% $2,490 $2,490 $2,490 $2,490 $2,490 $2,490 $2,490 $2,490 $2,490 $2,490 $2,490 $2,490
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $22,910 $22,910 $22,410 $22,410 $22,410 $22,410 $22,410 $22,410 $22,410 $22,410 $22,410 $22,410
Profit Before Interest and Taxes ($5,910) ($3,410) ($2,010) $1,390 $3,090 $4,290 $1,590 $590 $1,590 $4,590 $8,470 $10,590
EBITDA ($5,790) ($3,290) ($1,890) $1,510 $3,210 $4,410 $1,710 $710 $1,710 $4,710 $8,590 $10,710
Interest Expense $410 $403 $396 $389 $382 $375 $368 $361 $354 $347 $340 $333
Taxes Incurred ($1,896) ($1,144) ($722) $300 $812 $1,174 $367 $69 $371 $1,273 $2,439 $3,077
Net Profit ($4,424) ($2,669) ($1,684) $701 $1,896 $2,740 $855 $160 $865 $2,970 $5,691 $7,180
Net Profit/Sales -17.01% -9.20% -5.61% 2.06% 5.27% 7.21% 2.52% 0.49% 2.47% 7.62% 13.23% 15.61%
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 $6,500 $7,250 $7,500 $8,500 $9,000 $9,500 $8,500 $8,250 $8,750 $9,750 $10,750 $11,500
Cash from Receivables $0 $650 $19,575 $21,775 $22,600 $25,550 $27,050 $28,400 $25,475 $24,800 $26,350 $29,350
Subtotal Cash from Operations $6,500 $7,900 $27,075 $30,275 $31,600 $35,050 $35,550 $36,650 $34,225 $34,550 $37,100 $40,850
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 $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 $4,000 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $6,500 $7,900 $27,075 $30,275 $35,600 $35,050 $35,550 $36,650 $34,225 $34,550 $37,100 $40,850
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 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600 $16,600
Bill Payments $457 $13,745 $14,949 $15,018 $16,606 $17,423 $18,469 $16,414 $16,163 $17,478 $19,353 $20,640
Subtotal Spent on Operations $17,057 $30,345 $31,549 $31,618 $33,206 $34,023 $35,069 $33,014 $32,763 $34,078 $35,953 $37,240
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 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
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 $17,890 $31,178 $32,382 $32,451 $34,039 $34,856 $35,902 $33,847 $33,596 $34,911 $36,786 $38,073
Net Cash Flow ($11,390) ($23,278) ($5,307) ($2,176) $1,561 $194 ($352) $2,803 $629 ($361) $314 $2,777
Cash Balance $30,810 $7,532 $2,224 $49 $1,609 $1,804 $1,452 $4,254 $4,883 $4,522 $4,836 $7,614
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 $42,200 $30,810 $7,532 $2,224 $49 $1,609 $1,804 $1,452 $4,254 $4,883 $4,522 $4,836 $7,614
Accounts Receivable $0 $19,500 $40,600 $43,525 $47,250 $51,650 $54,600 $53,050 $49,400 $50,175 $54,625 $60,525 $65,675
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $42,200 $50,310 $48,132 $45,749 $47,299 $53,259 $56,404 $54,502 $53,654 $55,058 $59,147 $65,361 $73,289
Long-term Assets
Long-term Assets $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Accumulated Depreciation $0 $120 $240 $360 $480 $600 $720 $840 $960 $1,080 $1,200 $1,320 $1,440
Total Long-term Assets $10,000 $9,880 $9,760 $9,640 $9,520 $9,400 $9,280 $9,160 $9,040 $8,920 $8,800 $8,680 $8,560
Total Assets $52,200 $60,190 $57,892 $55,389 $56,819 $62,659 $65,684 $63,662 $62,694 $63,978 $67,947 $74,041 $81,849
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 $13,247 $14,451 $14,465 $16,027 $16,805 $17,922 $15,877 $15,582 $16,834 $18,666 $19,903 $21,364
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 $0 $13,247 $14,451 $14,465 $16,027 $16,805 $17,922 $15,877 $15,582 $16,834 $18,666 $19,903 $21,364
Long-term Liabilities $50,000 $49,167 $48,334 $47,501 $46,668 $45,835 $45,002 $44,169 $43,336 $42,503 $41,670 $40,837 $40,004
Total Liabilities $50,000 $62,414 $62,785 $61,966 $62,695 $62,640 $62,924 $60,046 $58,918 $59,337 $60,336 $60,740 $61,368
Paid-in Capital $80,000 $80,000 $80,000 $80,000 $80,000 $84,000 $84,000 $84,000 $84,000 $84,000 $84,000 $84,000 $84,000
Retained Earnings ($77,800) ($77,800) ($77,800) ($77,800) ($77,800) ($77,800) ($77,800) ($77,800) ($77,800) ($77,800) ($77,800) ($77,800) ($77,800)
Earnings $0 ($4,424) ($7,093) ($8,777) ($8,076) ($6,180) ($3,440) ($2,585) ($2,424) ($1,559) $1,411 $7,101 $14,281
Total Capital $2,200 ($2,224) ($4,893) ($6,577) ($5,876) $20 $2,760 $3,615 $3,776 $4,641 $7,611 $13,301 $20,481
Total Liabilities and Capital $52,200 $60,190 $57,892 $55,389 $56,819 $62,659 $65,684 $63,662 $62,694 $63,978 $67,947 $74,041 $81,849
Net Worth $2,200 ($2,224) ($4,893) ($6,577) ($5,876) $20 $2,760 $3,615 $3,776 $4,641 $7,611 $13,301 $20,481