La Salsa Fresh Mexican Grill

Start your own business plan »

Mexican 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
Meal Deals 0% $12,588 $19,188 $24,319 $26,688 $28,044 $28,428 $23,302 $18,116 $15,604 $20,116 $24,240 $25,536
A La Carte 0% $6,582 $9,534 $12,048 $13,560 $14,431 $14,880 $12,910 $10,796 $9,658 $12,796 $11,622 $10,903
Burrito/ Taco 0% $8,844 $14,592 $20,100 $23,244 $25,104 $26,832 $22,792 $19,268 $16,804 $21,268 $24,672 $25,548
Other 0% $1,378 $2,192 $3,015 $3,752 $4,042 $4,352 $3,490 $2,932 $2,072 $2,746 $3,610 $3,570
Total Sales $29,392 $45,506 $59,482 $67,244 $71,621 $74,492 $62,494 $51,112 $44,138 $56,926 $64,144 $65,557
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
Meal Deals 26% $3,273 $4,989 $6,323 $6,939 $7,291 $7,391 $6,059 $4,710 $4,057 $5,230 $6,302 $6,639
A La Carte 21% $1,382 $2,002 $2,530 $2,848 $3,031 $3,125 $2,711 $2,267 $2,028 $2,687 $2,441 $2,290
Burrito/ Taco 31% $2,742 $4,524 $6,231 $7,206 $7,782 $8,318 $7,066 $5,973 $5,209 $6,593 $7,648 $7,920
Other 17% $234 $373 $513 $638 $687 $740 $593 $498 $352 $467 $614 $607
Subtotal Direct Cost of Sales $7,631 $11,887 $15,597 $17,630 $18,791 $19,574 $16,428 $13,449 $11,647 $14,977 $17,005 $17,456
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
Production Personnel
Manager $3,000 $3,000 $3,008 $3,015 $3,023 $3,030 $3,038 $3,045 $3,053 $3,061 $3,068 $3,076
Cooks (3) $4,800 $4,800 $4,812 $4,824 $4,836 $4,848 $4,860 $4,872 $4,885 $4,897 $4,909 $4,921
Other $2,000 $2,000 $3,008 $3,015 $3,023 $3,030 $3,038 $3,045 $3,053 $3,061 $3,068 $3,076
Subtotal $9,800 $9,800 $10,828 $10,854 $10,882 $10,908 $10,936 $10,962 $10,991 $11,019 $11,045 $11,073
Sales and Marketing Personnel
Marketing $1,000 $1,003 $1,005 $1,008 $1,010 $1,013 $1,015 $1,018 $1,020 $1,023 $1,025 $1,028
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $1,000 $1,003 $1,005 $1,008 $1,010 $1,013 $1,015 $1,018 $1,020 $1,023 $1,025 $1,028
General and Administrative Personnel
Benjamin Strock $3,000 $3,008 $3,015 $3,023 $3,030 $3,038 $3,045 $3,053 $3,061 $3,068 $3,076 $3,084
Accountant $1,000 $1,000 $1,003 $1,005 $1,008 $1,010 $1,013 $1,015 $1,018 $1,020 $1,023 $1,025
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $4,000 $4,008 $4,018 $4,028 $4,038 $4,048 $4,058 $4,068 $4,079 $4,088 $4,099 $4,109
Other Personnel
Name or Title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $14,800 $14,811 $15,851 $15,890 $15,930 $15,969 $16,009 $16,048 $16,090 $16,130 $16,169 $16,210
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 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 $29,392 $45,506 $59,482 $67,244 $71,621 $74,492 $62,494 $51,112 $44,138 $56,926 $64,144 $65,557
Direct Cost of Sales $7,631 $11,887 $15,597 $17,630 $18,791 $19,574 $16,428 $13,449 $11,647 $14,977 $17,005 $17,456
Production Payroll $9,800 $9,800 $10,828 $10,854 $10,882 $10,908 $10,936 $10,962 $10,991 $11,019 $11,045 $11,073
SBRG Franchise Fee 6% $1,764 $2,730 $3,569 $4,035 $4,297 $4,470 $3,750 $3,067 $2,648 $3,416 $3,849 $3,933
Other Production Expenses $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Total Cost of Sales $20,195 $25,418 $30,993 $33,519 $34,971 $35,951 $32,114 $28,478 $26,286 $30,412 $32,899 $33,462
Gross Margin $9,197 $20,088 $28,489 $33,725 $36,650 $38,541 $30,380 $22,634 $17,852 $26,514 $31,245 $32,095
Gross Margin % 31.29% 44.14% 47.89% 50.15% 51.17% 51.74% 48.61% 44.28% 40.45% 46.58% 48.71% 48.96%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $1,000 $1,003 $1,005 $1,008 $1,010 $1,013 $1,015 $1,018 $1,020 $1,023 $1,025 $1,028
Advertising/ Promotion $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
SBRG Corporate Marketing Fee 4% $1,176 $1,820 $2,379 $2,690 $2,865 $2,980 $2,500 $2,044 $1,766 $2,277 $2,566 $2,622
Travel $600 $600 $600 $0 $0 $0 $0 $0 $0 $0 $0 $0
Miscellaneous $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Total Sales and Marketing Expenses $3,876 $4,523 $5,084 $4,798 $4,975 $5,093 $4,615 $4,162 $3,886 $4,400 $4,691 $4,750
Sales and Marketing % 13.19% 9.94% 8.55% 7.13% 6.95% 6.84% 7.38% 8.14% 8.80% 7.73% 7.31% 7.25%
General and Administrative Expenses
General and Administrative Payroll $4,000 $4,008 $4,018 $4,028 $4,038 $4,048 $4,058 $4,068 $4,079 $4,088 $4,099 $4,109
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
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
Payroll Taxes 15% $2,220 $2,222 $2,378 $2,384 $2,390 $2,395 $2,401 $2,407 $2,414 $2,420 $2,425 $2,432
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $10,620 $10,630 $10,796 $10,812 $10,828 $10,843 $10,859 $10,875 $10,893 $10,908 $10,924 $10,941
General and Administrative % 36.13% 23.36% 18.15% 16.08% 15.12% 14.56% 17.38% 21.28% 24.68% 19.16% 17.03% 16.69%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contract/Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Total Operating Expenses $14,496 $15,153 $15,880 $15,609 $15,802 $15,936 $15,474 $15,038 $14,778 $15,308 $15,615 $15,691
Profit Before Interest and Taxes ($5,298) $4,936 $12,609 $18,116 $20,848 $22,605 $14,906 $7,597 $3,074 $11,207 $15,630 $16,404
EBITDA ($4,298) $5,936 $13,609 $19,116 $21,848 $23,605 $15,906 $8,597 $4,074 $12,207 $16,630 $17,404
Interest Expense $1,740 $1,730 $1,719 $1,709 $1,699 $1,688 $1,678 $1,667 $1,657 $1,646 $1,635 $1,625
Taxes Incurred ($2,111) $962 $3,267 $4,922 $5,745 $6,275 $3,968 $1,779 $425 $2,868 $4,198 $4,434
Net Profit ($4,927) $2,244 $7,622 $11,485 $13,404 $14,641 $9,259 $4,151 $992 $6,692 $9,796 $10,346
Net Profit/Sales -16.76% 4.93% 12.81% 17.08% 18.72% 19.65% 14.82% 8.12% 2.25% 11.76% 15.27% 15.78%
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 $29,392 $45,506 $59,482 $67,244 $71,621 $74,492 $62,494 $51,112 $44,138 $56,926 $64,144 $65,557
Subtotal Cash from Operations $29,392 $45,506 $59,482 $67,244 $71,621 $74,492 $62,494 $51,112 $44,138 $56,926 $64,144 $65,557
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 $29,392 $45,506 $59,482 $67,244 $71,621 $74,492 $62,494 $51,112 $44,138 $56,926 $64,144 $65,557
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 $14,800 $14,811 $15,851 $15,890 $15,930 $15,969 $16,009 $16,048 $16,090 $16,130 $16,169 $16,210
Bill Payments $363 $11,044 $15,768 $22,330 $41,154 $42,603 $43,377 $32,561 $26,551 $24,497 $36,855 $39,379
Subtotal Spent on Operations $15,163 $25,855 $31,619 $38,220 $57,084 $58,572 $59,386 $48,609 $42,641 $40,627 $53,024 $55,589
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 $1,733 $1,743 $1,754 $1,764 $1,774 $1,784 $1,795 $1,805 $1,816 $1,826 $1,837 $1,848
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 $16,896 $27,598 $33,372 $39,984 $58,859 $60,357 $61,180 $50,415 $44,456 $42,453 $54,861 $57,437
Net Cash Flow $12,496 $17,908 $26,110 $27,260 $12,762 $14,135 $1,314 $697 ($318) $14,473 $9,283 $8,120
Cash Balance $114,496 $132,404 $158,514 $185,773 $198,536 $212,671 $213,985 $214,682 $214,364 $228,837 $238,119 $246,240
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 $102,000 $114,496 $132,404 $158,514 $185,773 $198,536 $212,671 $213,985 $214,682 $214,364 $228,837 $238,119 $246,240
Inventory $50,000 $42,369 $30,482 $17,156 $19,393 $20,670 $21,531 $18,071 $14,794 $12,811 $16,475 $18,706 $19,201
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $152,000 $156,865 $162,886 $175,670 $205,166 $219,206 $234,202 $232,056 $229,476 $227,175 $245,312 $256,825 $265,441
Long-term Assets
Long-term Assets $287,000 $287,000 $287,000 $287,000 $287,000 $287,000 $287,000 $287,000 $287,000 $287,000 $287,000 $287,000 $287,000
Accumulated Depreciation $0 $1,000 $2,000 $3,000 $4,000 $5,000 $6,000 $7,000 $8,000 $9,000 $10,000 $11,000 $12,000
Total Long-term Assets $287,000 $286,000 $285,000 $284,000 $283,000 $282,000 $281,000 $280,000 $279,000 $278,000 $277,000 $276,000 $275,000
Total Assets $439,000 $442,865 $447,886 $459,670 $488,166 $501,206 $515,202 $512,056 $508,476 $505,175 $522,312 $532,825 $540,441
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 $10,525 $15,045 $20,960 $39,736 $41,145 $42,284 $31,673 $25,748 $23,271 $35,542 $38,096 $37,214
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 $10,525 $15,045 $20,960 $39,736 $41,145 $42,284 $31,673 $25,748 $23,271 $35,542 $38,096 $37,214
Long-term Liabilities $300,000 $298,267 $296,523 $294,770 $293,006 $291,232 $289,448 $287,653 $285,848 $284,032 $282,205 $280,368 $278,521
Total Liabilities $300,000 $308,791 $311,568 $315,730 $332,742 $332,377 $331,732 $319,326 $311,596 $307,303 $317,747 $318,464 $315,735
Paid-in Capital $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000
Retained Earnings ($161,000) ($161,000) ($161,000) ($161,000) ($161,000) ($161,000) ($161,000) ($161,000) ($161,000) ($161,000) ($161,000) ($161,000) ($161,000)
Earnings $0 ($4,927) ($2,683) $4,940 $16,425 $29,829 $44,470 $53,730 $57,880 $58,872 $65,565 $75,361 $85,707
Total Capital $139,000 $134,073 $136,317 $143,940 $155,425 $168,829 $183,470 $192,730 $196,880 $197,872 $204,565 $214,361 $224,707
Total Liabilities and Capital $439,000 $442,865 $447,886 $459,670 $488,166 $501,206 $515,202 $512,056 $508,476 $505,175 $522,312 $532,825 $540,441
Net Worth $139,000 $134,073 $136,317 $143,940 $155,425 $168,829 $183,470 $192,730 $196,880 $197,872 $204,565 $214,361 $224,707