Kona-Q

Start your own business plan »

Healthy Restaurant Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Families 0% $0 $3,445 $3,665 $3,701 $3,898 $3,998 $4,141 $4,202 $4,336 $4,454 $4,545 $4,641
Individuals 0% $0 $2,722 $2,895 $2,924 $3,079 $3,158 $3,271 $3,320 $3,425 $3,519 $3,591 $3,666
Total Sales $0 $6,167 $6,560 $6,625 $6,977 $7,156 $7,412 $7,522 $7,761 $7,973 $8,136 $8,307
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Families $0 $1,034 $1,100 $1,110 $1,169 $1,199 $1,242 $1,261 $1,301 $1,336 $1,364 $1,392
Individuals $0 $816 $869 $877 $924 $948 $981 $996 $1,028 $1,056 $1,077 $1,100
Subtotal Direct Cost of Sales $0 $1,850 $1,968 $1,987 $2,093 $2,147 $2,224 $2,256 $2,328 $2,392 $2,441 $2,492
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Kevin 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
Cook 0% $0 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150
Manager 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Misc. 0% $0 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Total People 1 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $2,000 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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% 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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $0 $6,167 $6,560 $6,625 $6,977 $7,156 $7,412 $7,522 $7,761 $7,973 $8,136 $8,307
Direct Cost of Sales $0 $1,850 $1,968 $1,987 $2,093 $2,147 $2,224 $2,256 $2,328 $2,392 $2,441 $2,492
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $1,850 $1,968 $1,987 $2,093 $2,147 $2,224 $2,256 $2,328 $2,392 $2,441 $2,492
Gross Margin $0 $4,317 $4,592 $4,637 $4,884 $5,009 $5,189 $5,265 $5,433 $5,581 $5,695 $5,815
Gross Margin % 0.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00%
Expenses
Payroll $2,000 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050
Sales and Marketing and Other Expenses $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Depreciation $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083
Rent $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 15% $300 $608 $608 $608 $608 $608 $608 $608 $608 $608 $608 $608
Other $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75
Total Operating Expenses $4,908 $7,266 $7,266 $7,266 $7,266 $7,266 $7,266 $7,266 $7,266 $7,266 $7,266 $7,266
Profit Before Interest and Taxes ($4,908) ($2,949) ($2,673) ($2,628) ($2,381) ($2,256) ($2,077) ($2,000) ($1,832) ($1,685) ($1,571) ($1,450)
EBITDA ($3,825) ($1,866) ($1,590) ($1,545) ($1,298) ($1,173) ($994) ($917) ($749) ($602) ($488) ($367)
Interest Expense $24 $190 $186 $181 $177 $172 $168 $163 $158 $154 $149 $145
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($4,932) ($3,139) ($2,859) ($2,809) ($2,558) ($2,428) ($2,244) ($2,163) ($1,991) ($1,838) ($1,720) ($1,595)
Net Profit/Sales 0.00% -50.91% -43.58% -42.41% -36.66% -33.93% -30.28% -28.76% -25.65% -23.06% -21.14% -19.20%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $0 $6,167 $6,560 $6,625 $6,977 $7,156 $7,412 $7,522 $7,761 $7,973 $8,136 $8,307
Subtotal Cash from Operations $0 $6,167 $6,560 $6,625 $6,977 $7,156 $7,412 $7,522 $7,761 $7,973 $8,136 $8,307
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 $20,000 $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 $10,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $10,000 $26,167 $6,560 $6,625 $6,977 $7,156 $7,412 $7,522 $7,761 $7,973 $8,136 $8,307
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $2,000 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050 $4,050
Bill Payments $4,304 $1,926 $4,177 $4,287 $4,305 $4,404 $4,454 $4,525 $4,554 $4,621 $4,680 $4,724
Subtotal Spent on Operations $6,304 $5,976 $8,227 $8,337 $8,355 $8,454 $8,504 $8,575 $8,604 $8,671 $8,730 $8,774
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 $550 $550 $550 $550 $550 $550 $550 $550 $550 $550
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 $6,304 $5,976 $8,777 $8,887 $8,905 $9,004 $9,054 $9,125 $9,154 $9,221 $9,280 $9,324
Net Cash Flow $3,696 $20,190 ($2,216) ($2,262) ($1,927) ($1,848) ($1,642) ($1,603) ($1,393) ($1,249) ($1,144) ($1,017)
Cash Balance $8,685 $28,876 $26,659 $24,397 $22,470 $20,622 $18,981 $17,377 $15,985 $14,736 $13,592 $12,575
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $4,989 $8,685 $28,876 $26,659 $24,397 $22,470 $20,622 $18,981 $17,377 $15,985 $14,736 $13,592 $12,575
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $4,989 $8,685 $28,876 $26,659 $24,397 $22,470 $20,622 $18,981 $17,377 $15,985 $14,736 $13,592 $12,575
Long-term Assets
Long-term Assets $22,141 $22,141 $22,141 $22,141 $22,141 $22,141 $22,141 $22,141 $22,141 $22,141 $22,141 $22,141 $22,141
Accumulated Depreciation $8,989 $10,072 $11,155 $12,238 $13,321 $14,404 $15,487 $16,570 $17,653 $18,736 $19,819 $20,902 $21,985
Total Long-term Assets $13,152 $12,069 $10,986 $9,903 $8,820 $7,737 $6,654 $5,571 $4,488 $3,405 $2,322 $1,239 $156
Total Assets $18,141 $20,754 $39,862 $36,562 $33,217 $30,207 $27,276 $24,552 $21,865 $19,390 $17,058 $14,831 $12,731
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $4,242 $1,787 $4,034 $4,144 $4,158 $4,256 $4,303 $4,373 $4,400 $4,465 $4,522 $4,565 $4,610
Current Borrowing $0 $0 $20,000 $19,450 $18,900 $18,350 $17,800 $17,250 $16,700 $16,150 $15,600 $15,050 $14,500
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $4,242 $1,787 $24,034 $23,594 $23,058 $22,606 $22,103 $21,623 $21,100 $20,615 $20,122 $19,615 $19,110
Long-term Liabilities $2,858 $2,858 $2,858 $2,858 $2,858 $2,858 $2,858 $2,858 $2,858 $2,858 $2,858 $2,858 $2,858
Total Liabilities $7,100 $4,645 $26,892 $26,452 $25,916 $25,464 $24,961 $24,481 $23,958 $23,473 $22,980 $22,473 $21,968
Paid-in Capital $0 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Retained Earnings $11,041 $11,041 $11,041 $11,041 $11,041 $11,041 $11,041 $11,041 $11,041 $11,041 $11,041 $11,041 $11,041
Earnings $0 ($4,932) ($8,071) ($10,930) ($13,740) ($16,298) ($18,726) ($20,970) ($23,134) ($25,125) ($26,963) ($28,683) ($30,278)
Total Capital $11,041 $16,109 $12,970 $10,111 $7,301 $4,743 $2,315 $71 ($2,093) ($4,084) ($5,922) ($7,642) ($9,237)
Total Liabilities and Capital $18,141 $20,754 $39,862 $36,562 $33,217 $30,207 $27,276 $24,552 $21,865 $19,390 $17,058 $14,831 $12,731
Net Worth $11,041 $16,109 $12,970 $10,111 $7,301 $4,743 $2,315 $71 ($2,093) ($4,084) ($5,922) ($7,642) ($9,237)