On The Water mediterranean restaurant business plan appendix. On The Water is a start-up restaurant specializing in Mediterranean cuisine.

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

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
On The Water mediterranean restaurant business plan appendix. On The Water is a start-up restaurant specializing in Mediterranean cuisine.
\n