Studio67

Start your own business plan »

Organic 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
Meals 0% 779 1,053 1,505 1,553 1,652 1,633 1,173 1,520 2,066 2,602 3,451 3,835
Drinks 50% 390 527 753 777 826 817 587 760 1,033 1,301 1,726 1,918
Other 0% 20 20 20 20 20 20 20 20 20 20 20 20
Total Unit Sales 1,189 1,600 2,278 2,350 2,498 2,470 1,780 2,300 3,119 3,923 5,197 5,773
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
Meals $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00
Drinks $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00
Other $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00
Sales
Meals $11,685 $15,795 $22,575 $23,295 $24,780 $24,495 $17,595 $22,800 $30,990 $39,030 $51,765 $57,525
Drinks $780 $1,054 $1,506 $1,554 $1,652 $1,634 $1,174 $1,520 $2,066 $2,602 $3,452 $3,836
Other $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Total Sales $12,665 $17,049 $24,281 $25,049 $26,632 $26,329 $18,969 $24,520 $33,256 $41,832 $55,417 $61,561
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
Meals 0.00% $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00
Drinks 0.00% $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50 $0.50
Other 0.00% $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00
Direct Cost of Sales
Meals $1,558 $2,106 $3,010 $3,106 $3,304 $3,266 $2,346 $3,040 $4,132 $5,204 $6,902 $7,670
Drinks $195 $264 $377 $389 $413 $409 $294 $380 $517 $651 $863 $959
Other $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $20
Subtotal Direct Cost of Sales $1,773 $2,390 $3,407 $3,515 $3,737 $3,695 $2,660 $3,440 $4,669 $5,875 $7,785 $8,649
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% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Hostess 0% $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Chef 0% $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Cleaning 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Waiters 0% $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Other 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
Total People 8 8 8 8 8 8 8 8 8 8 8 8
Total Payroll $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500
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 $12,665 $17,049 $24,281 $25,049 $26,632 $26,329 $18,969 $24,520 $33,256 $41,832 $55,417 $61,561
Direct Cost of Sales $1,773 $2,390 $3,407 $3,515 $3,737 $3,695 $2,660 $3,440 $4,669 $5,875 $7,785 $8,649
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,773 $2,390 $3,407 $3,515 $3,737 $3,695 $2,660 $3,440 $4,669 $5,875 $7,785 $8,649
Gross Margin $10,892 $14,660 $20,875 $21,535 $22,895 $22,635 $16,310 $21,080 $28,588 $35,958 $47,632 $52,912
Gross Margin % 86.00% 85.98% 85.97% 85.97% 85.97% 85.97% 85.98% 85.97% 85.96% 85.96% 85.95% 85.95%
Expenses
Payroll $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500
Sales and Marketing and Other Expenses $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250
Depreciation 5% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities 5% $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Payroll Taxes 15% $3,525 $3,525 $3,525 $3,525 $3,525 $3,525 $3,525 $3,525 $3,525 $3,525 $3,525 $3,525
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $29,375 $29,375 $29,375 $29,375 $29,375 $29,375 $29,375 $29,375 $29,375 $29,375 $29,375 $29,375
Profit Before Interest and Taxes ($18,483) ($14,716) ($8,501) ($7,841) ($6,480) ($6,741) ($13,066) ($8,295) ($788) $6,583 $18,257 $23,537
EBITDA ($18,483) ($14,716) ($8,501) ($7,841) ($6,480) ($6,741) ($13,066) ($8,295) ($788) $6,583 $18,257 $23,537
Interest Expense $829 $825 $821 $817 $813 $808 $804 $800 $795 $791 $787 $782
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($19,312) ($15,541) ($9,322) ($8,657) ($7,293) ($7,549) ($13,870) ($9,095) ($1,583) $5,791 $17,470 $22,755
Net Profit/Sales -152.49% -91.15% -38.39% -34.56% -27.38% -28.67% -73.12% -37.09% -4.76% 13.84% 31.53% 36.96%
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 $12,665 $17,049 $24,281 $25,049 $26,632 $26,329 $18,969 $24,520 $33,256 $41,832 $55,417 $61,561
Subtotal Cash from Operations $12,665 $17,049 $24,281 $25,049 $26,632 $26,329 $18,969 $24,520 $33,256 $41,832 $55,417 $61,561
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 $12,665 $17,049 $24,281 $25,049 $26,632 $26,329 $18,969 $24,520 $33,256 $41,832 $55,417 $61,561
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 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500 $23,500
Bill Payments $1,283 $8,498 $9,123 $10,106 $10,214 $10,423 $10,343 $9,365 $10,156 $11,379 $12,604 $14,475
Subtotal Spent on Operations $24,783 $31,998 $32,623 $33,606 $33,714 $33,923 $33,843 $32,865 $33,656 $34,879 $36,104 $37,975
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 $488 $492 $496 $500 $505 $509 $513 $517 $522 $526 $530 $535
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 $25,271 $32,490 $33,119 $34,106 $34,219 $34,432 $34,356 $33,382 $34,178 $35,405 $36,634 $38,510
Net Cash Flow ($12,606) ($15,441) ($8,838) ($9,057) ($7,587) ($8,103) ($15,387) ($8,862) ($922) $6,427 $18,783 $23,051
Cash Balance $75,394 $59,954 $51,115 $42,058 $34,472 $26,369 $10,981 $2,120 $1,198 $7,625 $26,408 $49,459
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 $88,000 $75,394 $59,954 $51,115 $42,058 $34,472 $26,369 $10,981 $2,120 $1,198 $7,625 $26,408 $49,459
Other Current Assets $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Total Current Assets $138,000 $125,394 $109,954 $101,115 $92,058 $84,472 $76,369 $60,981 $52,120 $51,198 $57,625 $76,408 $99,459
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $138,000 $125,394 $109,954 $101,115 $92,058 $84,472 $76,369 $60,981 $52,120 $51,198 $57,625 $76,408 $99,459
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 $1,000 $8,195 $8,787 $9,766 $9,866 $10,077 $10,032 $9,027 $9,778 $10,961 $12,123 $13,965 $14,796
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 $1,000 $8,195 $8,787 $9,766 $9,866 $10,077 $10,032 $9,027 $9,778 $10,961 $12,123 $13,965 $14,796
Long-term Liabilities $100,000 $99,512 $99,020 $98,524 $98,024 $97,519 $97,010 $96,497 $95,980 $95,458 $94,932 $94,402 $93,867
Total Liabilities $101,000 $107,707 $107,807 $108,290 $107,890 $107,596 $107,042 $105,524 $105,758 $106,419 $107,055 $108,367 $108,663
Paid-in Capital $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Retained Earnings ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000)
Earnings $0 ($19,312) ($34,853) ($44,174) ($52,832) ($60,124) ($67,673) ($81,543) ($90,638) ($92,221) ($86,429) ($68,959) ($46,204)
Total Capital $37,000 $17,688 $2,147 ($7,174) ($15,832) ($23,124) ($30,673) ($44,543) ($53,638) ($55,221) ($49,429) ($31,959) ($9,204)
Total Liabilities and Capital $138,000 $125,394 $109,954 $101,115 $92,058 $84,472 $76,369 $60,981 $52,120 $51,198 $57,625 $76,408 $99,459
Net Worth $37,000 $17,688 $2,147 ($7,174) ($15,832) ($23,124) ($30,673) ($44,543) ($53,638) ($55,221) ($49,429) ($31,959) ($9,204)