Java Culture

Start your own business plan »

Coffee Shop 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
Coffee beverages 0% $24,000 $27,000 $28,800 $28,800 $28,800 $28,800 $28,800 $28,800 $29,400 $31,200 $33,000 $33,000
Coffee beans 0% $6,000 $6,750 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,350 $7,800 $8,250 $8,250
Pastries, etc. 0% $10,000 $11,250 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,250 $13,000 $13,750 $13,750
Total Sales $40,000 $45,000 $48,000 $48,000 $48,000 $48,000 $48,000 $48,000 $49,000 $52,000 $55,000 $55,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
Coffee beverages $6,000 $6,750 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,350 $7,800 $8,250 $8,250
Coffee beans $3,000 $3,375 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,675 $3,900 $4,125 $4,125
Pastries, etc. $5,000 $5,625 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,125 $6,500 $6,875 $6,875
Subtotal Direct Cost of Sales $14,000 $15,750 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $17,150 $18,200 $19,250 $19,250
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
Manager 0% $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917 $2,917
Baristas 0% $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167
Employees 0% $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300
Total People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.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 $40,000 $45,000 $48,000 $48,000 $48,000 $48,000 $48,000 $48,000 $49,000 $52,000 $55,000 $55,000
Direct Cost of Sales $14,000 $15,750 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $17,150 $18,200 $19,250 $19,250
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $14,000 $15,750 $16,800 $16,800 $16,800 $16,800 $16,800 $16,800 $17,150 $18,200 $19,250 $19,250
Gross Margin $26,000 $29,250 $31,200 $31,200 $31,200 $31,200 $31,200 $31,200 $31,850 $33,800 $35,750 $35,750
Gross Margin % 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00%
Expenses
Payroll $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383
Sales and Marketing and Other Expenses $2,150 $2,150 $2,150 $2,150 $2,150 $2,150 $2,150 $2,150 $2,150 $2,150 $2,150 $2,150
Depreciation $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Rent $0 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400
Rent $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Maintenance $400 $450 $480 $480 $480 $480 $480 $480 $490 $520 $550 $550
Utilities/Phone $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Payroll Taxes 15% $1,558 $1,558 $1,558 $1,558 $1,558 $1,558 $1,558 $1,558 $1,558 $1,558 $1,558 $1,558
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $16,191 $20,641 $20,671 $20,671 $20,671 $20,671 $20,671 $20,671 $20,681 $20,711 $20,741 $20,741
Profit Before Interest and Taxes $9,809 $8,609 $10,529 $10,529 $10,529 $10,529 $10,529 $10,529 $11,169 $13,089 $15,009 $15,009
EBITDA $10,259 $9,059 $10,979 $10,979 $10,979 $10,979 $10,979 $10,979 $11,619 $13,539 $15,459 $15,459
Interest Expense $248 $245 $243 $241 $239 $236 $234 $232 $229 $227 $225 $223
Taxes Incurred $2,868 $2,091 $2,572 $2,572 $2,573 $2,573 $2,574 $2,574 $2,735 $3,216 $3,696 $3,697
Net Profit $6,693 $6,273 $7,715 $7,716 $7,718 $7,720 $7,721 $7,723 $8,205 $9,647 $11,088 $11,090
Net Profit/Sales 16.73% 13.94% 16.07% 16.08% 16.08% 16.08% 16.09% 16.09% 16.74% 18.55% 20.16% 20.16%
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 $40,000 $45,000 $48,000 $48,000 $48,000 $48,000 $48,000 $48,000 $49,000 $52,000 $55,000 $55,000
Subtotal Cash from Operations $40,000 $45,000 $48,000 $48,000 $48,000 $48,000 $48,000 $48,000 $49,000 $52,000 $55,000 $55,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 $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 $40,000 $45,000 $48,000 $48,000 $48,000 $48,000 $48,000 $48,000 $49,000 $52,000 $55,000 $55,000
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 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383 $10,383
Bill Payments $728 $22,112 $29,845 $30,569 $29,450 $29,449 $29,447 $29,445 $29,474 $30,424 $32,727 $34,195
Subtotal Spent on Operations $11,112 $32,496 $40,228 $40,952 $39,834 $39,832 $39,830 $39,829 $39,857 $40,808 $43,110 $44,578
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 $275 $275 $275 $275 $275 $275 $275 $275 $275 $275 $275 $275
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $11,387 $32,771 $40,503 $41,227 $40,109 $40,107 $40,105 $40,104 $40,132 $41,083 $43,385 $44,853
Net Cash Flow $28,613 $12,229 $7,497 $6,773 $7,891 $7,893 $7,895 $7,896 $8,868 $10,917 $11,615 $10,147
Cash Balance $95,736 $107,966 $115,462 $122,235 $130,127 $138,020 $145,914 $153,811 $162,679 $173,596 $185,211 $195,358
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 $67,123 $95,736 $107,966 $115,462 $122,235 $130,127 $138,020 $145,914 $153,811 $162,679 $173,596 $185,211 $195,358
Inventory $16,027 $15,400 $17,325 $18,480 $18,480 $18,480 $18,480 $18,480 $18,480 $18,865 $20,020 $21,175 $21,175
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $83,150 $111,136 $125,291 $133,942 $140,715 $148,607 $156,500 $164,394 $172,291 $181,544 $193,616 $206,386 $216,533
Long-term Assets
Long-term Assets $59,170 $59,170 $59,170 $59,170 $59,170 $59,170 $59,170 $59,170 $59,170 $59,170 $59,170 $59,170 $59,170
Accumulated Depreciation $0 $450 $900 $1,350 $1,800 $2,250 $2,700 $3,150 $3,600 $4,050 $4,500 $4,950 $5,400
Total Long-term Assets $59,170 $58,720 $58,270 $57,820 $57,370 $56,920 $56,470 $56,020 $55,570 $55,120 $54,670 $54,220 $53,770
Total Assets $142,320 $169,856 $183,561 $191,762 $198,085 $205,527 $212,970 $220,414 $227,861 $236,664 $248,286 $260,606 $270,303
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 $21,118 $28,825 $29,587 $28,469 $28,467 $28,465 $28,464 $28,462 $29,335 $31,586 $33,092 $31,974
Current Borrowing $10,000 $9,725 $9,450 $9,175 $8,900 $8,625 $8,350 $8,075 $7,800 $7,525 $7,250 $6,975 $6,700
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $10,000 $30,843 $38,275 $38,762 $37,369 $37,092 $36,815 $36,539 $36,262 $36,860 $38,836 $40,067 $38,674
Long-term Liabilities $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
Total Liabilities $30,000 $50,843 $58,275 $58,762 $57,369 $57,092 $56,815 $56,539 $56,262 $56,860 $58,836 $60,067 $58,674
Paid-in Capital $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000 $140,000
Retained Earnings ($27,680) ($27,680) ($27,680) ($27,680) ($27,680) ($27,680) ($27,680) ($27,680) ($27,680) ($27,680) ($27,680) ($27,680) ($27,680)
Earnings $0 $6,693 $12,966 $20,680 $28,397 $36,115 $43,834 $51,556 $59,279 $67,484 $77,130 $88,218 $99,308
Total Capital $112,320 $119,013 $125,286 $133,000 $140,717 $148,435 $156,154 $163,876 $171,599 $179,804 $189,450 $200,538 $211,628
Total Liabilities and Capital $142,320 $169,856 $183,561 $191,762 $198,085 $205,527 $212,970 $220,414 $227,861 $236,664 $248,286 $260,606 $270,303
Net Worth $112,320 $119,013 $125,286 $133,000 $140,717 $148,435 $156,154 $163,876 $171,599 $179,804 $189,450 $200,538 $211,628