Sagebrush Sam's
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 | |||||||||||||
Lunch | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $82,947 | $84,956 | $79,682 | $69,304 | $68,718 | $73,238 |
Senior Dinners | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $27,054 | $27,710 | $25,990 | $22,604 | $22,413 | $23,888 |
Child (3-10) | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $40,136 | $41,108 | $38,556 | $33,534 | $33,251 | $35,438 |
Weekday Dinner | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $56,487 | $57,855 | $54,264 | $47,196 | $46,797 | $49,875 |
Weekend Dinner | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $90,677 | $92,873 | $87,108 | $75,762 | $75,122 | $80,063 |
Total Sales | $0 | $0 | $0 | $0 | $0 | $0 | $297,301 | $304,502 | $285,600 | $248,400 | $246,301 | $262,502 | |
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 | |
Lunch | $0 | $0 | $0 | $0 | $0 | $0 | $29,031 | $29,735 | $27,889 | $24,256 | $24,051 | $25,633 | |
Senior Dinners | $0 | $0 | $0 | $0 | $0 | $0 | $9,469 | $9,698 | $9,096 | $7,911 | $7,845 | $8,361 | |
Child (3-10) | $0 | $0 | $0 | $0 | $0 | $0 | $14,047 | $14,388 | $13,495 | $11,737 | $11,638 | $12,403 | |
Weekday Dinner | $0 | $0 | $0 | $0 | $0 | $0 | $19,771 | $20,249 | $18,992 | $16,519 | $16,379 | $17,456 | |
Weekend Dinner | $0 | $0 | $0 | $0 | $0 | $0 | $31,737 | $32,505 | $30,488 | $26,517 | $26,293 | $28,022 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $104,055 | $106,575 | $99,960 | $86,940 | $86,206 | $91,875 |
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 | |||||||||||||
Proprietor/Managing Partner | $0 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | |
General Manager | $0 | $0 | $4,166 | $4,166 | $4,166 | $4,166 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | |
Back of House Manager | $0 | $0 | $0 | $3,333 | $3,333 | $3,333 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Front of House Manager | $0 | $0 | $0 | $0 | $2,916 | $2,916 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | |
Assistant Manager | $0 | $0 | $0 | $0 | $0 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | $2,083 | |
Employees | $0 | $0 | $0 | $0 | $5,000 | $33,000 | $50,541 | $51,765 | $48,552 | $42,228 | $41,871 | $44,625 | |
Subtotal | $0 | $6,250 | $10,416 | $13,749 | $21,665 | $51,748 | $64,707 | $65,931 | $62,718 | $56,394 | $56,037 | $58,791 | |
Sales and Marketing 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 | |
General and Administrative Personnel | |||||||||||||
President & C.E.O. | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | |
Administrative Assistant | $375 | $165 | $335 | $175 | $50 | $75 | $250 | $250 | $250 | $250 | $250 | $250 | |
Director of Training | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Controller | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $12,875 | $12,665 | $12,835 | $12,675 | $12,550 | $12,575 | $12,750 | $12,750 | $12,750 | $12,750 | $12,750 | $12,750 | |
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 | 1 | 3 | 4 | 5 | 6 | 28 | 40 | 41 | 38 | 34 | 34 | 36 | |
Total Payroll | $12,875 | $18,915 | $23,251 | $26,424 | $34,215 | $64,323 | $77,457 | $78,681 | $75,468 | $69,144 | $68,787 | $71,541 |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $297,301 | $304,502 | $285,600 | $248,400 | $246,301 | $262,502 | |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $104,055 | $106,575 | $99,960 | $86,940 | $86,206 | $91,875 | |
Production Payroll | $0 | $6,250 | $10,416 | $13,749 | $21,665 | $51,748 | $64,707 | $65,931 | $62,718 | $56,394 | $56,037 | $58,791 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $6,250 | $10,416 | $13,749 | $21,665 | $51,748 | $168,762 | $172,506 | $162,678 | $143,334 | $142,243 | $150,666 | |
Gross Margin | $0 | ($6,250) | ($10,416) | ($13,749) | ($21,665) | ($51,748) | $128,539 | $131,996 | $122,922 | $105,066 | $104,058 | $111,836 | |
Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 43.24% | 43.35% | 43.04% | 42.30% | 42.25% | 42.60% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Advertising/Promotion | 2% | $0 | $0 | $0 | $0 | $0 | $0 | $5,946 | $6,090 | $5,712 | $4,968 | $4,926 | $5,250 |
Production Expense | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $981 | $1,005 | $942 | $820 | $813 | $866 |
Miscellaneous | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales and Marketing Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $6,927 | $7,095 | $6,654 | $5,788 | $5,739 | $6,116 | |
Sales and Marketing % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2.33% | 2.33% | 2.33% | 2.33% | 2.33% | 2.33% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $12,875 | $12,665 | $12,835 | $12,675 | $12,550 | $12,575 | $12,750 | $12,750 | $12,750 | $12,750 | $12,750 | $12,750 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $7,084 | $7,084 | $7,084 | $7,084 | $7,084 | $7,084 | |
Fixed Costs | $0 | $0 | $0 | $0 | $0 | $0 | $7,442 | $7,442 | $7,442 | $7,442 | $7,442 | $7,442 | |
Variable Costs | $0 | $0 | $0 | $0 | $0 | $0 | $17,095 | $17,509 | $16,422 | $14,283 | $14,162 | $15,094 | |
Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $6,667 | $6,667 | $6,667 | $6,667 | $6,667 | $6,667 | |
Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $667 | $667 | $667 | $667 | $667 | $667 | |
Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Payroll Taxes | 18% | $2,279 | $3,348 | $4,115 | $4,677 | $6,056 | $11,385 | $13,710 | $13,927 | $13,358 | $12,238 | $12,175 | $12,663 |
Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total General and Administrative Expenses | $15,154 | $16,013 | $16,950 | $17,352 | $18,606 | $23,960 | $65,415 | $66,045 | $64,390 | $61,131 | $60,948 | $62,367 | |
General and Administrative % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 22.00% | 21.69% | 22.55% | 24.61% | 24.75% | 23.76% | |
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 | $15,154 | $16,013 | $16,950 | $17,352 | $18,606 | $23,960 | $72,342 | $73,140 | $71,044 | $66,919 | $66,686 | $68,483 | |
Profit Before Interest and Taxes | ($15,154) | ($22,263) | ($27,366) | ($31,101) | ($40,271) | ($75,708) | $56,197 | $58,856 | $51,878 | $38,147 | $37,372 | $43,353 | |
EBITDA | ($15,154) | ($22,263) | ($27,366) | ($31,101) | ($40,271) | ($75,708) | $63,281 | $65,940 | $58,962 | $45,231 | $44,456 | $50,437 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | ($4,546) | ($5,566) | ($6,842) | ($7,775) | ($10,068) | ($18,927) | $14,049 | $14,714 | $12,969 | $9,537 | $9,343 | $10,838 | |
Net Profit | ($10,608) | ($16,697) | ($20,525) | ($23,326) | ($30,203) | ($56,781) | $42,148 | $44,142 | $38,908 | $28,610 | $28,029 | $32,515 | |
Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 14.18% | 14.50% | 13.62% | 11.52% | 11.38% | 12.39% |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $297,301 | $304,502 | $285,600 | $248,400 | $246,301 | $262,502 | |
Subtotal Cash from Operations | $0 | $0 | $0 | $0 | $0 | $0 | $297,301 | $304,502 | $285,600 | $248,400 | $246,301 | $262,502 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $297,301 | $304,502 | $285,600 | $248,400 | $246,301 | $262,502 | |
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 | $12,875 | $18,915 | $23,251 | $26,424 | $34,215 | $64,323 | $77,457 | $78,681 | $75,468 | $69,144 | $68,787 | $71,541 | |
Bill Payments | ($2,267) | ($4,409) | ($4,870) | ($5,734) | ($7,007) | ($11,420) | $1,045 | $247,649 | $176,684 | $155,942 | $129,652 | $142,127 | |
Subtotal Spent on Operations | $10,608 | $14,506 | $18,381 | $20,690 | $27,208 | $52,903 | $78,502 | $326,330 | $252,152 | $225,086 | $198,439 | $213,668 | |
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 | $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 | $10,608 | $14,506 | $18,381 | $20,690 | $27,208 | $52,903 | $78,502 | $326,330 | $252,152 | $225,086 | $198,439 | $213,668 | |
Net Cash Flow | ($10,608) | ($14,506) | ($18,381) | ($20,690) | ($27,208) | ($52,903) | $218,799 | ($21,828) | $33,448 | $23,314 | $47,862 | $48,834 | |
Cash Balance | $149,392 | $134,887 | $116,506 | $95,815 | $68,607 | $15,704 | $234,503 | $212,674 | $246,123 | $269,436 | $317,299 | $366,132 |
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 | $160,000 | $149,392 | $134,887 | $116,506 | $95,815 | $68,607 | $15,704 | $234,503 | $212,674 | $246,123 | $269,436 | $317,299 | $366,132 |
Inventory | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $114,461 | $117,233 | $109,956 | $95,634 | $94,827 | $101,063 |
Other Current Assets | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 |
Total Current Assets | $295,000 | $284,392 | $269,887 | $251,506 | $230,815 | $203,607 | $150,704 | $448,963 | $429,907 | $456,079 | $465,070 | $512,125 | $567,195 |
Long-term Assets | |||||||||||||
Long-term Assets | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $7,084 | $14,168 | $21,252 | $28,336 | $35,420 | $42,504 |
Total Long-term Assets | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,500,000 | $1,492,916 | $1,485,832 | $1,478,748 | $1,471,664 | $1,464,580 | $1,457,496 |
Total Assets | $1,795,000 | $1,784,392 | $1,769,887 | $1,751,506 | $1,730,815 | $1,703,607 | $1,650,704 | $1,941,879 | $1,915,739 | $1,934,827 | $1,936,734 | $1,976,705 | $2,024,691 |
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 | $0 | $2,192 | $4,336 | $6,971 | $9,966 | $13,844 | $262,871 | $192,589 | $172,769 | $146,066 | $158,008 | $173,479 |
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 | $0 | $2,192 | $4,336 | $6,971 | $9,966 | $13,844 | $262,871 | $192,589 | $172,769 | $146,066 | $158,008 | $173,479 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $0 | $2,192 | $4,336 | $6,971 | $9,966 | $13,844 | $262,871 | $192,589 | $172,769 | $146,066 | $158,008 | $173,479 |
Paid-in Capital | $2,003,945 | $2,003,945 | $2,003,945 | $2,003,945 | $2,003,945 | $2,003,945 | $2,003,945 | $2,003,945 | $2,003,945 | $2,003,945 | $2,003,945 | $2,003,945 | $2,003,945 |
Retained Earnings | ($208,945) | ($208,945) | ($208,945) | ($208,945) | ($208,945) | ($208,945) | ($208,945) | ($208,945) | ($208,945) | ($208,945) | ($208,945) | ($208,945) | ($208,945) |
Earnings | $0 | ($10,608) | ($27,305) | ($47,830) | ($71,156) | ($101,359) | ($158,140) | ($115,992) | ($71,850) | ($32,942) | ($4,332) | $23,697 | $56,212 |
Total Capital | $1,795,000 | $1,784,392 | $1,767,695 | $1,747,170 | $1,723,844 | $1,693,641 | $1,636,860 | $1,679,008 | $1,723,150 | $1,762,058 | $1,790,668 | $1,818,697 | $1,851,212 |
Total Liabilities and Capital | $1,795,000 | $1,784,392 | $1,769,887 | $1,751,506 | $1,730,815 | $1,703,607 | $1,650,704 | $1,941,879 | $1,915,739 | $1,934,827 | $1,936,734 | $1,976,705 | $2,024,691 |
Net Worth | $1,795,000 | $1,784,392 | $1,767,695 | $1,747,170 | $1,723,844 | $1,693,641 | $1,636,860 | $1,679,008 | $1,723,150 | $1,762,058 | $1,790,668 | $1,818,697 | $1,851,212 |