Visit our US site at: www.bplans.comhide this bar
 
Edit This Plan

Gourmet Food Store Business Plan

Sarrica's Market

This sample business plan can be edited directly in Business Plan Pro software.

previous
next
Page 1   2   3   4   5   6   7   8   9   10  

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Grocery Items 0% £8,000 £7,800 £18,000 £18,000 £18,000 £18,000 £18,000 £18,000 £18,000 £18,000 £7,800 £8,000
Delicatessen - Cheese, meat, produce 0% £8,000 £7,000 £12,000 £12,000 £12,000 £12,000 £12,000 £12,000 £12,000 £12,000 £7,000 £8,000
Drinks 0% £4,000 £3,500 £9,000 £9,000 £9,000 £9,000 £9,000 £9,000 £9,000 £9,000 £3,500 £4,000
Frozen 0% £2,000 £1,800 £4,000 £3,500 £4,000 £3,500 £4,000 £4,000 £3,500 £4,000 £1,800 £2,000
Gift Merchandise 0% £2,500 £2,000 £3,000 £2,000 £3,000 £2,000 £3,000 £3,000 £2,000 £3,000 £2,000 £2,500
Other 0% £300 £300 £500 £500 £500 £500 £500 £500 £500 £500 £300 £300
Total Sales £24,800 £22,400 £46,500 £45,000 £46,500 £45,000 £46,500 £46,500 £45,000 £46,500 £22,400 £24,800
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Grocery Items £4,800 £4,680 £10,800 £10,800 £10,800 £10,800 £10,800 £10,800 £10,800 £10,800 £4,680 £4,800
Delicatessen - cheese, meat, produce £4,800 £4,200 £7,200 £7,200 £7,200 £7,200 £7,200 £7,200 £7,200 £7,200 £4,200 £4,800
Drinks £2,400 £2,100 £5,400 £5,400 £5,400 £5,400 £5,400 £5,400 £5,400 £5,400 £2,100 £2,400
Frozen £1,200 £1,080 £2,400 £2,100 £2,400 £2,100 £2,400 £2,400 £2,100 £2,400 £1,080 £1,200
Gift Merchandise £1,500 £1,200 £1,800 £1,200 £1,800 £1,200 £1,800 £1,800 £1,200 £1,800 £1,200 £1,500
Other £180 £180 £300 £300 £300 £300 £300 £300 £300 £300 £180 £180
Subtotal Direct Cost of Sales £14,880 £13,440 £27,900 £27,000 £27,900 £27,000 £27,900 £27,900 £27,000 £27,900 £13,440 £14,880
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Owners: Managers (2) 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
Clerks (1-2) 0% £1,280 £1,280 £2,560 £2,560 £2,560 £2,560 £2,560 £2,560 £2,560 £2,560 £1,280 £1,280
Accounting/Books (1) 0% £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Cooks/Kitchen (1) 0% £0 £0 £1,280 £1,280 £1,280 £1,280 £1,280 £1,280 £1,280 £1,280 £0 £0
Other 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 4 4 6 6 6 6 6 6 6 6 4 4
Total Payroll £5,480 £5,480 £8,040 £8,040 £8,040 £8,040 £8,040 £8,040 £8,040 £8,040 £5,480 £5,480
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales £24,800 £22,400 £46,500 £45,000 £46,500 £45,000 £46,500 £46,500 £45,000 £46,500 £22,400 £24,800
Direct Cost of Sales £14,880 £13,440 £27,900 £27,000 £27,900 £27,000 £27,900 £27,900 £27,000 £27,900 £13,440 £14,880
Hidden Row £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £14,880 £13,440 £27,900 £27,000 £27,900 £27,000 £27,900 £27,900 £27,000 £27,900 £13,440 £14,880
Gross Margin £9,920 £8,960 £18,600 £18,000 £18,600 £18,000 £18,600 £18,600 £18,000 £18,600 £8,960 £9,920
Gross Margin % 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00%
Expenses
Payroll £5,480 £5,480 £8,040 £8,040 £8,040 £8,040 £8,040 £8,040 £8,040 £8,040 £5,480 £5,480
Marketing/Postage/Other £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
Depreciation £208 £208 £208 £208 £208 £208 £208 £208 £208 £208 £208 £208
Legal £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Books/Accounting £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Licenses/Permits/Memberships £75 £75 £75 £75 £75 £75 £75 £75 £75 £75 £75 £75
Delivery/Transportation £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400
Insurance £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300
Rent £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500 £2,500
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
Equipment/Supplies £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400
Building/Equipment Maintenence £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Payroll Taxes 15% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Total Operating Expenses £11,263 £11,263 £13,823 £13,823 £13,823 £13,823 £13,823 £13,823 £13,823 £13,823 £11,263 £11,263
Profit Before Interest and Taxes (£1,343) (£2,303) £4,777 £4,177 £4,777 £4,177 £4,777 £4,777 £4,177 £4,777 (£2,303) (£1,343)
EBITDA (£1,135) (£2,095) £4,985 £4,385 £4,985 £4,385 £4,985 £4,985 £4,385 £4,985 (£2,095) (£1,135)
Interest Expense £535 £529 £522 £516 £509 £503 £497 £490 £484 £477 £471 £464
Taxes Incurred (£564) (£850) £1,276 £1,098 £1,280 £1,102 £1,284 £1,286 £1,108 £1,290 (£832) (£542)
Net Profit (£1,315) (£1,982) £2,978 £2,563 £2,987 £2,572 £2,996 £3,001 £2,585 £3,010 (£1,942) (£1,265)
Net Profit/Sales -5.30% -8.85% 6.40% 5.69% 6.42% 5.71% 6.44% 6.45% 5.74% 6.47% -8.67% -5.10%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales £24,800 £22,400 £46,500 £45,000 £46,500 £45,000 £46,500 £46,500 £45,000 £46,500 £22,400 £24,800
Subtotal Cash from Operations £24,800 £22,400 £46,500 £45,000 £46,500 £45,000 £46,500 £46,500 £45,000 £46,500 £22,400 £24,800
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 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Cash Received £24,800 £22,400 £46,500 £45,000 £46,500 £45,000 £46,500 £46,500 £45,000 £46,500 £22,400 £24,800
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending £5,480 £5,480 £8,040 £8,040 £8,040 £8,040 £8,040 £8,040 £8,040 £8,040 £5,480 £5,480
Bill Payments £560 £16,805 £18,246 £50,580 £33,301 £36,152 £33,292 £36,212 £35,182 £33,278 £35,198 £5,690
Subtotal Spent on Operations £6,040 £22,285 £26,286 £58,620 £41,341 £44,192 £41,332 £44,252 £43,222 £41,318 £40,678 £11,170
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 £1,191 £1,191 £1,191 £1,191 £1,191 £1,191 £1,191 £1,191 £1,191 £1,191 £1,191 £1,191
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 £7,230 £23,476 £27,476 £59,811 £42,531 £45,383 £42,522 £45,443 £44,412 £42,509 £41,869 £12,360
Net Cash Flow £17,570 (£1,076) £19,024 (£14,811) £3,969 (£383) £3,978 £1,057 £588 £3,991 (£19,469) £12,440
Cash Balance £33,270 £32,194 £51,218 £36,407 £40,375 £39,993 £43,970 £45,027 £45,615 £49,606 £30,137 £42,577
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash £15,700 £33,270 £32,194 £51,218 £36,407 £40,375 £39,993 £43,970 £45,027 £45,615 £49,606 £30,137 £42,577
Inventory £20,000 £16,368 £14,784 £30,690 £29,700 £30,690 £29,700 £30,690 £30,690 £29,700 £30,690 £17,250 £16,368
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 £40,700 £54,638 £51,978 £86,908 £71,107 £76,065 £74,693 £79,660 £80,717 £80,315 £85,296 £52,387 £63,945
Long-term Assets
Long-term Assets £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000 £20,000
Accumulated Depreciation £0 £208 £417 £625 £833 £1,042 £1,250 £1,458 £1,667 £1,875 £2,083 £2,292 £2,500
Total Long-term Assets £20,000 £19,792 £19,583 £19,375 £19,167 £18,958 £18,750 £18,542 £18,333 £18,125 £17,917 £17,708 £17,500
Total Assets £60,700 £74,429 £71,561 £106,283 £90,274 £95,024 £93,443 £98,202 £99,051 £98,440 £103,213 £70,096 £81,445
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable £0 £16,235 £16,540 £49,474 £32,092 £35,046 £32,084 £35,037 £34,076 £32,071 £35,024 £5,040 £18,845
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 £16,235 £16,540 £49,474 £32,092 £35,046 £32,084 £35,037 £34,076 £32,071 £35,024 £5,040 £18,845
Long-term Liabilities £100,000 £98,810 £97,619 £96,429 £95,238 £94,048 £92,857 £91,667 £90,476 £89,286 £88,095 £86,905 £85,714
Total Liabilities £100,000 £115,044 £114,159 £145,902 £127,330 £129,094 £124,941 £126,704 £124,552 £121,356 £123,119 £91,944 £104,559
Paid-in Capital £24,000 £24,000 £24,000 £24,000 £24,000 £24,000 £24,000 £24,000 £24,000 £24,000 £24,000 £24,000 £24,000
Retained Earnings (£63,300) (£63,300) (£63,300) (£63,300) (£63,300) (£63,300) (£63,300) (£63,300) (£63,300) (£63,300) (£63,300) (£63,300) (£63,300)
Earnings £0 (£1,315) (£3,297) (£319) £2,243 £5,230 £7,802 £10,798 £13,799 £16,384 £19,393 £17,451 £16,186
Total Capital (£39,300) (£40,615) (£42,597) (£39,619) (£37,057) (£34,070) (£31,498) (£28,502) (£25,501) (£22,916) (£19,907) (£21,849) (£23,114)
Total Liabilities and Capital £60,700 £74,429 £71,561 £106,283 £90,274 £95,024 £93,443 £98,202 £99,051 £98,440 £103,213 £70,096 £81,445
Net Worth (£39,300) (£40,615) (£42,597) (£39,619) (£37,057) (£34,070) (£31,498) (£28,502) (£25,501) (£22,916) (£19,907) (£21,849) (£23,114)
previous
next
Edit This Plan