Take Five Sports Bar and Grill

Start your own business plan »

Sports Bar Business Plan

Appendix

Sales Forecast
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Sales
Food 0% $32,130 $64,260 $67,473 $77,112 $80,325 $53,633 $80,450 $89,388 $107,266 $116,205 $125,000 $133,000
Drinks 0% $30,870 $61,740 $64,827 $74,088 $77,175 $52,749 $79,124 $87,915 $105,498 $114,290 $120,000 $130,000
Retail 0% $0 $1,000 $1,000 $1,200 $1,500 $720 $1,556 $1,729 $2,074 $2,247 $2,400 $2,500
Franchise Fees 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $63,000 $127,000 $133,300 $152,400 $159,000 $107,102 $161,130 $179,032 $214,838 $232,742 $247,400 $265,500
Direct Cost of Sales Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Food $10,924 $21,848 $23,033 $26,218 $27,310 $18,235 $27,353 $30,392 $36,470 $39,510 $42,500 $45,220
Drinks $6,791 $13,523 $14,262 $16,299 $16,979 $11,605 $17,407 $19,341 $23,210 $25,144 $26,400 $28,600
Retail $0 $500 $600 $600 $750 $360 $778 $865 $1,037 $1,124 $1,200 $1,250
Franchise Fees $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $17,715 $35,871 $37,895 $43,117 $45,039 $30,200 $45,538 $50,598 $60,717 $65,778 $70,100 $75,070
Personnel Plan
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Total Payroll 0% $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400
Name or Title or Group 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 12 12 12 12 12 12 12 12 12 12 12 12
Total Payroll $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400
Pro Forma Profit and Loss
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Sales $63,000 $127,000 $133,300 $152,400 $159,000 $107,102 $161,130 $179,032 $214,838 $232,742 $247,400 $265,500
Direct Cost of Sales $17,715 $35,871 $37,895 $43,117 $45,039 $30,200 $45,538 $50,598 $60,717 $65,778 $70,100 $75,070
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $17,715 $35,871 $37,895 $43,117 $45,039 $30,200 $45,538 $50,598 $60,717 $65,778 $70,100 $75,070
Gross Margin $45,285 $91,129 $95,405 $109,283 $113,961 $76,902 $115,592 $128,434 $154,121 $166,964 $177,300 $190,430
Gross Margin % 71.88% 71.76% 71.57% 71.71% 71.67% 71.80% 71.74% 71.74% 71.74% 71.74% 71.67% 71.73%
Expenses
Payroll $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400
Marketing/Promotion $7,000 $4,500 $5,000 $4,500 $6,000 $5,500 $5,500 $6,000 $6,000 $6,500 $6,500 $6,500
Depreciation $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833 $5,833
Rent $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400
Utilities $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400
Insurance $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 12% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $63,033 $60,533 $61,033 $60,533 $62,033 $61,533 $61,533 $62,033 $62,033 $62,533 $62,533 $62,533
Profit Before Interest and Taxes ($17,748) $30,596 $34,372 $48,750 $51,928 $15,369 $54,059 $66,401 $92,088 $104,431 $114,767 $127,897
EBITDA ($11,915) $36,429 $40,205 $54,583 $57,761 $21,202 $59,892 $72,234 $97,921 $110,264 $120,600 $133,730
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($5,857) $10,097 $11,343 $16,088 $17,136 $5,072 $17,839 $21,912 $30,389 $34,462 $37,873 $42,206
Net Profit ($11,891) $20,499 $23,029 $32,663 $34,792 $10,297 $36,220 $44,489 $61,699 $69,969 $76,894 $85,691
Net Profit/Sales -18.87% 16.14% 17.28% 21.43% 21.88% 9.61% 22.48% 24.85% 28.72% 30.06% 31.08% 32.28%
Pro Forma Cash Flow
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Cash Received
Cash from Operations
Cash Sales $63,000 $127,000 $133,300 $152,400 $159,000 $107,102 $161,130 $179,032 $214,838 $232,742 $247,400 $265,500
Subtotal Cash from Operations $63,000 $127,000 $133,300 $152,400 $159,000 $107,102 $161,130 $179,032 $214,838 $232,742 $247,400 $265,500
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 $625,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $688,000 $127,000 $133,300 $152,400 $159,000 $107,102 $161,130 $179,032 $214,838 $232,742 $247,400 $265,500
Expenditures Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Expenditures from Operations
Cash Spending $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400 $40,400
Bill Payments $21,138 $34,524 $79,773 $66,697 $79,277 $78,561 $36,292 $95,494 $94,682 $118,173 $122,338 $129,361
Subtotal Spent on Operations $61,538 $74,924 $120,173 $107,097 $119,677 $118,961 $76,692 $135,894 $135,082 $158,573 $162,738 $169,761
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 $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 $600,000 $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 $661,538 $74,924 $120,173 $107,097 $119,677 $118,961 $76,692 $135,894 $135,082 $158,573 $162,738 $169,761
Net Cash Flow $26,462 $52,076 $13,127 $45,303 $39,323 ($11,859) $84,438 $43,138 $79,756 $74,169 $84,662 $95,739
Cash Balance $93,598 $145,674 $158,800 $204,103 $243,427 $231,567 $316,005 $359,143 $438,900 $513,069 $597,731 $693,470
Pro Forma Balance Sheet
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Assets Starting Balances
Current Assets
Cash $67,136 $93,598 $145,674 $158,800 $204,103 $243,427 $231,567 $316,005 $359,143 $438,900 $513,069 $597,731 $693,470
Inventory $15,197 $19,487 $39,458 $41,685 $47,429 $49,543 $33,220 $50,092 $55,658 $66,789 $72,356 $77,110 $82,577
Other Current Assets $17,310 $17,310 $17,310 $17,310 $17,310 $17,310 $17,310 $17,310 $17,310 $17,310 $17,310 $17,310 $17,310
Total Current Assets $99,643 $130,394 $202,442 $217,795 $268,842 $310,279 $282,097 $383,407 $432,111 $522,998 $602,735 $692,151 $793,357
Long-term Assets
Long-term Assets $475,495 $1,075,495 $1,075,495 $1,075,495 $1,075,495 $1,075,495 $1,075,495 $1,075,495 $1,075,495 $1,075,495 $1,075,495 $1,075,495 $1,075,495
Accumulated Depreciation $29,713 $35,546 $41,379 $47,212 $53,045 $58,878 $64,711 $70,544 $76,377 $82,210 $88,043 $93,876 $99,709
Total Long-term Assets $445,782 $1,039,949 $1,034,116 $1,028,283 $1,022,450 $1,016,617 $1,010,784 $1,004,951 $999,118 $993,285 $987,452 $981,619 $975,786
Total Assets $545,425 $1,170,343 $1,236,558 $1,246,078 $1,291,292 $1,326,896 $1,292,881 $1,388,358 $1,431,229 $1,516,283 $1,590,187 $1,673,770 $1,769,143
Liabilities and Capital Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Current Liabilities
Accounts Payable $20,040 $31,849 $77,565 $64,055 $76,607 $77,420 $33,107 $92,364 $90,747 $114,102 $118,037 $124,726 $134,408
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $40,826 $40,826 $40,826 $40,826 $40,826 $40,826 $40,826 $40,826 $40,826 $40,826 $40,826 $40,826 $40,826
Subtotal Current Liabilities $60,866 $72,675 $118,391 $104,881 $117,433 $118,246 $73,933 $133,190 $131,573 $154,928 $158,863 $165,552 $175,234
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $60,866 $72,675 $118,391 $104,881 $117,433 $118,246 $73,933 $133,190 $131,573 $154,928 $158,863 $165,552 $175,234
Paid-in Capital $625,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000
Retained Earnings ($218,401) ($140,441) ($140,441) ($140,441) ($140,441) ($140,441) ($140,441) ($140,441) ($140,441) ($140,441) ($140,441) ($140,441) ($140,441)
Earnings $77,960 ($11,891) $8,608 $31,637 $64,300 $99,092 $109,389 $145,608 $190,097 $251,796 $321,765 $398,659 $484,350
Total Capital $484,559 $1,097,668 $1,118,167 $1,141,196 $1,173,859 $1,208,651 $1,218,948 $1,255,167 $1,299,656 $1,361,355 $1,431,324 $1,508,218 $1,593,909
Total Liabilities and Capital $545,425 $1,170,343 $1,236,558 $1,246,078 $1,291,292 $1,326,896 $1,292,881 $1,388,358 $1,431,229 $1,516,283 $1,590,187 $1,673,770 $1,769,143
Net Worth $484,559 $1,097,668 $1,118,167 $1,141,196 $1,173,859 $1,208,651 $1,218,948 $1,255,167 $1,299,656 $1,361,355 $1,431,324 $1,508,218 $1,593,909
General Assumptions
Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50%
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 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0