La Salsa Fresh Mexican Grill
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 |