On The Water

Start your own business plan »

Mediterranean Restaurant 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
Unit Sales
Covercharge 0% 0 0 0 0 0 0 0 0 0 0 0 0
Meals 0% 0 1,822 2,552 2,552 2,552 2,552 2,552 4,739 4,739 4,739 4,739 4,739
Drinks 0% 0 7,006 9,809 9,809 9,809 9,809 9,809 18,217 18,217 18,217 18,217 18,217
Restaurant Merchandise 0% 0 25 100 100 100 100 100 200 200 100 100 100
Total Unit Sales 0 8,853 12,461 12,461 12,461 12,461 12,461 23,156 23,156 23,056 23,056 23,056
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Covercharge $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Meals $0.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00
Drinks $0.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00
Restaurant Merchandise $0.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00 $8.00
Sales
Covercharge $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Meals $0 $27,330 $38,280 $38,280 $38,280 $38,280 $38,280 $71,085 $71,085 $71,085 $71,085 $71,085
Drinks $0 $35,030 $49,045 $49,045 $49,045 $49,045 $49,045 $91,085 $91,085 $91,085 $91,085 $91,085
Restaurant Merchandise $0 $200 $800 $800 $800 $800 $800 $1,600 $1,600 $800 $800 $800
Total Sales $0 $62,560 $88,125 $88,125 $88,125 $88,125 $88,125 $163,770 $163,770 $162,970 $162,970 $162,970
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Covercharge 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Meals 0.00% $0.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00
Drinks 0.00% $0.00 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50
Restaurant Merchandise 0.00% $0.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00
Direct Cost of Sales
Covercharge $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Meals $0 $5,466 $7,656 $7,656 $7,656 $7,656 $7,656 $14,217 $14,217 $14,217 $14,217 $14,217
Drinks $0 $3,503 $4,905 $4,905 $4,905 $4,905 $4,905 $9,109 $9,109 $9,109 $9,109 $9,109
Restaurant Merchandise $0 $75 $300 $300 $300 $300 $300 $600 $600 $300 $300 $300
Subtotal Direct Cost of Sales $0 $9,044 $12,861 $12,861 $12,861 $12,861 $12,861 $23,926 $23,926 $23,626 $23,626 $23,626
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
Management 0% $0 $3,780 $3,780 $3,780 $3,780 $3,780 $3,780 $3,780 $3,780 $3,780 $3,780 $3,780
Hostess 0% $0 $1,470 $1,470 $1,470 $1,470 $1,470 $1,470 $1,470 $1,470 $1,470 $1,470 $1,470
Waiters/Waitresses 0% $0 $4,410 $4,410 $4,410 $4,410 $4,410 $4,410 $5,880 $5,880 $5,880 $5,880 $5,880
Bartenders 0% $0 $0 $2,430 $2,430 $2,430 $2,430 $2,430 $3,078 $3,078 $3,078 $3,078 $3,078
Bus Boys 0% $0 $720 $720 $720 $720 $720 $720 $720 $720 $720 $720 $720
Cocktail Waitresses 0% $0 $0 $0 $0 $0 $0 $0 $672 $672 $672 $672 $672
Chefs 0% $0 $4,620 $4,620 $4,620 $4,620 $4,620 $4,620 $9,240 $9,240 $9,240 $9,240 $9,240
Total People 0 8 8 8 8 8 8 12 12 12 12 12
Total Payroll $0 $15,000 $17,430 $17,430 $17,430 $17,430 $17,430 $24,840 $24,840 $24,840 $24,840 $24,840
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 $0 $62,560 $88,125 $88,125 $88,125 $88,125 $88,125 $163,770 $163,770 $162,970 $162,970 $162,970
Direct Cost of Sales $0 $9,044 $12,861 $12,861 $12,861 $12,861 $12,861 $23,926 $23,926 $23,626 $23,626 $23,626
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $9,044 $12,861 $12,861 $12,861 $12,861 $12,861 $23,926 $23,926 $23,626 $23,626 $23,626
Gross Margin $0 $53,516 $75,265 $75,265 $75,265 $75,265 $75,265 $139,845 $139,845 $139,345 $139,345 $139,345
Gross Margin % 0.00% 85.54% 85.41% 85.41% 85.41% 85.41% 85.41% 85.39% 85.39% 85.50% 85.50% 85.50%
Expenses
Payroll $0 $15,000 $17,430 $17,430 $17,430 $17,430 $17,430 $24,840 $24,840 $24,840 $24,840 $24,840
Sales and Marketing and Other Expenses $0 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $0 $2,250 $2,615 $2,615 $2,615 $2,615 $2,615 $3,726 $3,726 $3,726 $3,726 $3,726
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $3,000 $20,450 $23,245 $23,245 $23,245 $23,245 $23,245 $31,766 $31,766 $31,766 $31,766 $31,766
Profit Before Interest and Taxes ($3,000) $33,066 $52,020 $52,020 $52,020 $52,020 $52,020 $108,079 $108,079 $107,579 $107,579 $107,579
EBITDA ($3,000) $33,066 $52,020 $52,020 $52,020 $52,020 $52,020 $108,079 $108,079 $107,579 $107,579 $107,579
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($900) $8,267 $13,005 $13,005 $13,005 $13,005 $13,005 $27,020 $27,020 $26,895 $26,895 $26,895
Net Profit ($2,100) $24,800 $39,015 $39,015 $39,015 $39,015 $39,015 $81,059 $81,059 $80,684 $80,684 $80,684
Net Profit/Sales 0.00% 39.64% 44.27% 44.27% 44.27% 44.27% 44.27% 49.50% 49.50% 49.51% 49.51% 49.51%
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 $0 $62,560 $88,125 $88,125 $88,125 $88,125 $88,125 $163,770 $163,770 $162,970 $162,970 $162,970
Subtotal Cash from Operations $0 $62,560 $88,125 $88,125 $88,125 $88,125 $88,125 $163,770 $163,770 $162,970 $162,970 $162,970
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 $0 $62,560 $88,125 $88,125 $88,125 $88,125 $88,125 $163,770 $163,770 $162,970 $162,970 $162,970
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 $0 $15,000 $17,430 $17,430 $17,430 $17,430 $17,430 $24,840 $24,840 $24,840 $24,840 $24,840
Bill Payments $15,520 $3,054 $30,881 $35,738 $31,680 $31,680 $31,680 $32,959 $69,637 $57,846 $57,127 $57,446
Subtotal Spent on Operations $15,520 $18,054 $48,311 $53,168 $49,110 $49,110 $49,110 $57,799 $94,477 $82,686 $81,967 $82,286
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 $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 $15,520 $18,054 $48,311 $53,168 $49,110 $49,110 $49,110 $57,799 $94,477 $82,686 $81,967 $82,286
Net Cash Flow ($15,520) $44,506 $39,814 $34,957 $39,015 $39,015 $39,015 $105,971 $69,293 $80,284 $81,003 $80,684
Cash Balance $6,480 $50,986 $90,800 $125,757 $164,772 $203,787 $242,802 $348,773 $418,066 $498,350 $579,353 $660,037
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 $22,000 $6,480 $50,986 $90,800 $125,757 $164,772 $203,787 $242,802 $348,773 $418,066 $498,350 $579,353 $660,037
Inventory $2,000 $2,000 $9,948 $14,147 $14,147 $14,147 $14,147 $14,147 $26,318 $26,318 $25,988 $25,988 $25,988
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $24,000 $8,480 $60,935 $104,947 $139,904 $178,919 $217,934 $256,949 $375,091 $444,384 $524,338 $605,341 $686,025
Long-term Assets
Long-term Assets $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000
Total Assets $69,000 $53,480 $105,935 $149,947 $184,904 $223,919 $262,934 $301,949 $420,091 $489,384 $569,338 $650,341 $731,025
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 $15,450 $2,030 $29,685 $34,682 $30,624 $30,624 $30,624 $30,624 $67,708 $55,942 $55,212 $55,531 $55,531
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 $15,450 $2,030 $29,685 $34,682 $30,624 $30,624 $30,624 $30,624 $67,708 $55,942 $55,212 $55,531 $55,531
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $15,450 $2,030 $29,685 $34,682 $30,624 $30,624 $30,624 $30,624 $67,708 $55,942 $55,212 $55,531 $55,531
Paid-in Capital $115,000 $115,000 $115,000 $115,000 $115,000 $115,000 $115,000 $115,000 $115,000 $115,000 $115,000 $115,000 $115,000
Retained Earnings ($61,450) ($61,450) ($61,450) ($61,450) ($61,450) ($61,450) ($61,450) ($61,450) ($61,450) ($61,450) ($61,450) ($61,450) ($61,450)
Earnings $0 ($2,100) $22,700 $61,715 $100,730 $139,745 $178,760 $217,775 $298,833 $379,892 $460,576 $541,260 $621,944
Total Capital $53,550 $51,450 $76,250 $115,265 $154,280 $193,295 $232,310 $271,325 $352,383 $433,442 $514,126 $594,810 $675,494
Total Liabilities and Capital $69,000 $53,480 $105,935 $149,947 $184,904 $223,919 $262,934 $301,949 $420,091 $489,384 $569,338 $650,341 $731,025
Net Worth $53,550 $51,450 $76,249 $115,265 $154,280 $193,295 $232,310 $271,325 $352,383 $433,442 $514,126 $594,810 $675,494