Zara Restaurant and Lounge

Start your own business plan »

Ethnic Food 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
Sales
Total Sales Food 0% $44,579 $50,948 $57,975 $65,441 $79,057 $81,253 $83,449 $74,665 $83,449 $74,665 $79,057 $79,057
Total Sales Bar/Beverages 0% $11,499 $13,141 $14,954 $16,880 $20,392 $20,958 $21,524 $19,259 $21,524 $19,259 $20,392 $20,392
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $56,078 $64,089 $72,929 $82,321 $99,449 $102,211 $104,973 $93,924 $104,973 $93,924 $99,449 $99,449
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
Total Cost of Sales: Food $15,603 $17,832 $20,291 $22,904 $27,670 $28,439 $29,207 $26,133 $29,207 $26,133 $27,670 $27,670
Total Cost of Sales: Bar/Beverages $3,795 $4,337 $4,935 $5,570 $6,729 $6,916 $7,103 $6,355 $7,103 $6,355 $6,729 $6,729
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $19,397 $22,168 $25,226 $28,475 $34,399 $35,355 $36,310 $32,488 $36,310 $32,488 $34,399 $34,399
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 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Long-term Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 $56,078 $64,089 $72,929 $82,321 $99,449 $102,211 $104,973 $93,924 $104,973 $93,924 $99,449 $99,449
Direct Cost of Sales $19,397 $22,168 $25,226 $28,475 $34,399 $35,355 $36,310 $32,488 $36,310 $32,488 $34,399 $34,399
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $19,397 $22,168 $25,226 $28,475 $34,399 $35,355 $36,310 $32,488 $36,310 $32,488 $34,399 $34,399
Gross Margin $36,681 $41,921 $47,703 $53,846 $65,050 $66,856 $68,663 $61,436 $68,663 $61,436 $65,050 $65,050
Gross Margin % 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41%
Expenses
Payroll $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299
Marketing/Promotion $1,457 $1,457 $1,457 $6,457 $0 $1,457 $2,457 $1,457 $0 $0 $0 $2,457
Depreciation $542 $542 $542 $542 $542 $542 $542 $542 $542 $542 $542 $542
Leased Equipment $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Accounting/Payroll Processing $550 $550 $550 $550 $550 $550 $550 $550 $550 $550 $550 $550
Legal Retainer Fees $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Business Licenses & Permits $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Credit Card Expense $1,548 $1,548 $1,548 $1,548 $1,548 $1,548 $1,548 $1,548 $1,548 $1,548 $1,548 $1,548
Bank Fees $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Music & Entertainment $312 $312 $312 $312 $312 $312 $312 $312 $312 $312 $312 $312
Training / Employee Retention Programs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Repairs & Maintenance $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Utility Services (Gas/Electric/Water/Sewer) $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083 $2,083
Telephone/Communication Expense $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance: Fire/Theft/Liability/Liquor/Product $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
Restaurant Occupancy Cost (Lease) $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250
Payroll Taxes (FICA/FUTA/SUTA) & Employee Benefits 17% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Exterminator/Trash Removal $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Dishware/Uniforms/Cleaning Supplies/Decor $980 $980 $980 $980 $980 $980 $980 $980 $980 $980 $980 $980
Printing/Paper/Postage/Subscriptions $763 $763 $763 $763 $763 $763 $763 $763 $763 $763 $763 $763
Facility (Exterior Cleaning/Grease Trap/Hood/Windows,etc.) $0 $303 $303 $303 $303 $303 $303 $303 $303 $303 $303 $303
R&D Meals $0 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
General Business Comps $0 $0 $1,240 $1,240 $1,240 $1,240 $1,240 $1,240 $1,240 $1,240 $1,240 $1,240
Owner Comps 15% $177 $177 $177 $177 $177 $177 $177 $177 $177 $177 $177 $177
Other Expenses (ComAreaMaint, etc.) $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
Total Operating Expenses $53,111 $53,614 $54,854 $59,854 $53,397 $54,854 $55,854 $54,854 $53,397 $53,397 $53,397 $55,854
Profit Before Interest and Taxes ($16,430) ($11,693) ($7,151) ($6,007) $11,653 $12,003 $12,809 $6,582 $15,266 $8,039 $11,653 $9,196
EBITDA ($15,888) ($11,151) ($6,609) ($5,466) $12,195 $12,544 $13,351 $7,124 $15,808 $8,581 $12,195 $9,738
Interest Expense $1,727 $1,704 $1,680 $1,657 $1,634 $1,611 $1,587 $1,564 $1,541 $1,518 $1,495 $1,471
Taxes Incurred ($5,447) ($4,019) ($2,649) ($2,299) $3,006 $3,118 $3,367 $1,505 $4,118 $1,956 $3,048 $2,317
Net Profit ($12,710) ($9,378) ($6,182) ($5,365) $7,013 $7,274 $7,855 $3,513 $9,608 $4,565 $7,111 $5,407
Net Profit/Sales -22.66% -14.63% -8.48% -6.52% 7.05% 7.12% 7.48% 3.74% 9.15% 4.86% 7.15% 5.44%
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 $56,078 $64,089 $72,929 $82,321 $99,449 $102,211 $104,973 $93,924 $104,973 $93,924 $99,449 $99,449
Subtotal Cash from Operations $56,078 $64,089 $72,929 $82,321 $99,449 $102,211 $104,973 $93,924 $104,973 $93,924 $99,449 $99,449
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 $56,078 $64,089 $72,929 $82,321 $99,449 $102,211 $104,973 $93,924 $104,973 $93,924 $99,449 $99,449
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 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299
Bill Payments $959 $29,247 $42,873 $48,926 $57,675 $65,013 $62,220 $63,929 $52,812 $65,248 $51,624 $60,586
Subtotal Spent on Operations $34,258 $62,546 $76,172 $82,225 $90,974 $98,312 $95,519 $97,228 $86,111 $98,547 $84,923 $93,885
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 $3,981 $3,981 $3,981 $3,981 $3,981 $3,981 $3,981 $3,981 $3,981 $3,981 $3,981 $3,981
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 $38,239 $66,527 $80,153 $86,206 $94,955 $102,293 $99,500 $101,209 $90,092 $102,528 $88,904 $97,866
Net Cash Flow $17,839 ($2,438) ($7,224) ($3,885) $4,494 ($82) $5,473 ($7,285) $14,881 ($8,604) $10,545 $1,583
Cash Balance $164,819 $162,381 $155,157 $151,272 $155,765 $155,683 $161,157 $153,871 $168,752 $160,148 $170,693 $172,276
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 $146,980 $164,819 $162,381 $155,157 $151,272 $155,765 $155,683 $161,157 $153,871 $168,752 $160,148 $170,693 $172,276
Inventory $27,500 $21,337 $24,385 $27,749 $31,322 $37,839 $38,890 $39,941 $35,737 $39,941 $35,737 $37,839 $37,839
Other Current Assets $73,311 $73,311 $73,311 $73,311 $73,311 $73,311 $73,311 $73,311 $73,311 $73,311 $73,311 $73,311 $73,311
Total Current Assets $247,791 $259,467 $260,077 $256,217 $255,905 $266,915 $267,884 $274,409 $262,919 $282,004 $269,196 $281,843 $283,426
Long-term Assets
Long-term Assets $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000
Accumulated Depreciation $0 $542 $1,083 $1,625 $2,167 $2,708 $3,250 $3,792 $4,333 $4,875 $5,417 $5,958 $6,500
Total Long-term Assets $65,000 $64,458 $63,917 $63,375 $62,833 $62,292 $61,750 $61,208 $60,667 $60,125 $59,583 $59,042 $58,500
Total Assets $312,791 $323,925 $323,994 $319,592 $318,738 $329,207 $329,634 $335,617 $323,586 $342,129 $328,779 $340,885 $341,926
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 $27,825 $41,252 $47,012 $55,505 $62,942 $60,075 $62,184 $50,621 $63,538 $49,604 $58,580 $58,194
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 $27,825 $41,252 $47,012 $55,505 $62,942 $60,075 $62,184 $50,621 $63,538 $49,604 $58,580 $58,194
Long-term Liabilities $300,000 $296,019 $292,038 $288,057 $284,076 $280,095 $276,114 $272,133 $268,152 $264,171 $260,190 $256,209 $252,228
Total Liabilities $300,000 $323,844 $333,290 $335,069 $339,581 $343,037 $336,189 $334,317 $318,773 $327,709 $309,794 $314,789 $310,422
Paid-in Capital $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000 $440,000
Retained Earnings ($427,209) ($427,209) ($427,209) ($427,209) ($427,209) ($427,209) ($427,209) ($427,209) ($427,209) ($427,209) ($427,209) ($427,209) ($427,209)
Earnings $0 ($12,710) ($22,087) ($28,269) ($33,634) ($26,621) ($19,346) ($11,491) ($7,979) $1,629 $6,194 $13,305 $18,712
Total Capital $12,791 $82 ($9,296) ($15,478) ($20,843) ($13,829) ($6,555) $1,300 $4,813 $14,420 $18,985 $26,096 $31,504
Total Liabilities and Capital $312,791 $323,925 $323,994 $319,592 $318,738 $329,207 $329,634 $335,617 $323,586 $342,129 $328,779 $340,885 $341,926
Net Worth $12,791 $82 ($9,296) ($15,478) ($20,843) ($13,829) ($6,555) $1,300 $4,813 $14,420 $18,985 $26,096 $31,504
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
General Manager (Year 2+) 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Partner/Manager 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
Partner/Asst. Manager/Exec. Chef 0% $2,680 $2,680 $2,680 $2,680 $2,680 $2,680 $2,680 $2,680 $2,680 $2,680 $2,680 $2,680
Hostess (Full Time) 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Hostess (Part Time) 0% $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100
Waitperson 1 0% $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470
Waitperson 2 0% $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470
Waitperson 3 0% $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470
Waitperson 4 0% $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470
Waitperson 5 0% $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470
Waitperson 6 0% $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470
Waitperson 7 0% $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470
Waitperson 8 0% $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470
Waitperson 9 0% $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470 $470
Wait/Barperson 0% $870 $870 $870 $870 $870 $870 $870 $870 $870 $870 $870 $870
Bartender 1 0% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Bartender 2 0% $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Busboy 1 0% $760 $760 $760 $760 $760 $760 $760 $760 $760 $760 $760 $760
Busboy 2 0% $980 $980 $980 $980 $980 $980 $980 $980 $980 $980 $980 $980
Busboy 3 0% $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Assistant Chef 0% $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700
Sous Chef 0% $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700
Cook 1 0% $2,020 $2,020 $2,020 $2,020 $2,020 $2,020 $2,020 $2,020 $2,020 $2,020 $2,020 $2,020
Cook 2 0% $1,580 $1,580 $1,580 $1,580 $1,580 $1,580 $1,580 $1,580 $1,580 $1,580 $1,580 $1,580
Prep Cook/Dishwasher 0% $1,024 $1,024 $1,024 $1,024 $1,024 $1,024 $1,024 $1,024 $1,024 $1,024 $1,024 $1,024
Prep Cook/Dishwasher/Cleaning 0% $1,080 $1,080 $1,080 $1,080 $1,080 $1,080 $1,080 $1,080 $1,080 $1,080 $1,080 $1,080
Dishwasher 1 0% $720 $720 $720 $720 $720 $720 $720 $720 $720 $720 $720 $720
Dishwasher 2 0% $475 $475 $475 $475 $475 $475 $475 $475 $475 $475 $475 $475
Cleaning/Dishwasher 0% $980 $980 $980 $980 $980 $980 $980 $980 $980 $980 $980 $980
Open 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 20 20 20 20 20 20 20 20 20 20 20 20
Total Payroll $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299 $33,299