The Bronx Deli and Bakery
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 | |||||||||||||
Bakery | 0% | $8,000 | $9,000 | $9,000 | $11,000 | $11,000 | $11,000 | $10,000 | $9,000 | $10,000 | $12,000 | $13,000 | $14,000 |
Sandwiches | 0% | $15,000 | $16,000 | $17,000 | $19,000 | $20,000 | $22,000 | $20,000 | $19,000 | $22,000 | $24,000 | $26,000 | $27,000 |
Drinks | 0% | $3,000 | $3,500 | $4,000 | $4,000 | $5,000 | $5,000 | $4,000 | $3,000 | $3,000 | $4,000 | $5,000 | $5,000 |
Total Sales | $26,000 | $28,500 | $30,000 | $34,000 | $36,000 | $38,000 | $34,000 | $31,000 | $35,000 | $40,000 | $44,000 | $46,000 | |
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 | |
Bakery | $2,000 | $2,200 | $2,200 | $2,800 | $2,800 | $2,800 | $2,500 | $2,400 | $2,500 | $3,000 | $3,500 | $3,700 | |
Sandwiches | $5,000 | $5,400 | $5,600 | $6,500 | $6,800 | $7,400 | $6,800 | $6,500 | $7,400 | $8,000 | $8,500 | $9,000 | |
Drinks | $400 | $460 | $500 | $500 | $600 | $600 | $500 | $400 | $400 | $500 | $600 | $600 | |
Subtotal Direct Cost of Sales | $7,400 | $8,060 | $8,300 | $9,800 | $10,200 | $10,800 | $9,800 | $9,300 | $10,300 | $11,500 | $12,600 | $13,300 |
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 | ||
Barry Cohn | 0% | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 |
Kitchen Staff | 0% | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 |
Waiters/Waitresses | 0% | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 |
Baking Staff | 0% | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Total People | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
Total Payroll | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 |
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% | 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 | $26,000 | $28,500 | $30,000 | $34,000 | $36,000 | $38,000 | $34,000 | $31,000 | $35,000 | $40,000 | $44,000 | $46,000 | |
Direct Cost of Sales | $7,400 | $8,060 | $8,300 | $9,800 | $10,200 | $10,800 | $9,800 | $9,300 | $10,300 | $11,500 | $12,600 | $13,300 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $7,400 | $8,060 | $8,300 | $9,800 | $10,200 | $10,800 | $9,800 | $9,300 | $10,300 | $11,500 | $12,600 | $13,300 | |
Gross Margin | $18,600 | $20,440 | $21,700 | $24,200 | $25,800 | $27,200 | $24,200 | $21,700 | $24,700 | $28,500 | $31,400 | $32,700 | |
Gross Margin % | 71.54% | 71.72% | 72.33% | 71.18% | 71.67% | 71.58% | 71.18% | 70.00% | 70.57% | 71.25% | 71.36% | 71.09% | |
Expenses | |||||||||||||
Payroll | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | |
Sales and Marketing and Other Expenses | $1,000 | $1,000 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Depreciation | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Rent | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | |
Payroll Taxes | 15% | $2,565 | $2,565 | $2,565 | $2,565 | $2,565 | $2,565 | $2,565 | $2,565 | $2,565 | $2,565 | $2,565 | $2,565 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $23,485 | $23,485 | $22,985 | $22,985 | $22,985 | $22,985 | $22,985 | $22,985 | $22,985 | $22,985 | $22,985 | $22,985 | |
Profit Before Interest and Taxes | ($4,885) | ($3,045) | ($1,285) | $1,215 | $2,815 | $4,215 | $1,215 | ($1,285) | $1,715 | $5,515 | $8,415 | $9,715 | |
EBITDA | ($4,765) | ($2,925) | ($1,165) | $1,335 | $2,935 | $4,335 | $1,335 | ($1,165) | $1,835 | $5,635 | $8,535 | $9,835 | |
Interest Expense | $410 | $403 | $396 | $389 | $382 | $375 | $368 | $361 | $354 | $347 | $340 | $333 | |
Taxes Incurred | ($1,588) | ($1,034) | ($504) | $248 | $730 | $1,152 | $254 | ($494) | $408 | $1,550 | $2,422 | $2,814 | |
Net Profit | ($3,706) | ($2,413) | ($1,177) | $578 | $1,703 | $2,688 | $593 | ($1,152) | $953 | $3,617 | $5,652 | $6,567 | |
Net Profit/Sales | -14.26% | -8.47% | -3.92% | 1.70% | 4.73% | 7.07% | 1.74% | -3.72% | 2.72% | 9.04% | 12.85% | 14.28% |
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 | $26,000 | $28,500 | $30,000 | $34,000 | $36,000 | $38,000 | $34,000 | $31,000 | $35,000 | $40,000 | $44,000 | $46,000 | |
Subtotal Cash from Operations | $26,000 | $28,500 | $30,000 | $34,000 | $36,000 | $38,000 | $34,000 | $31,000 | $35,000 | $40,000 | $44,000 | $46,000 | |
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 | $26,000 | $28,500 | $30,000 | $34,000 | $36,000 | $38,000 | $34,000 | $31,000 | $35,000 | $40,000 | $44,000 | $46,000 | |
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 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | $17,100 | |
Bill Payments | $521 | $15,586 | $14,413 | $14,342 | $17,841 | $17,558 | $18,630 | $15,064 | $14,500 | $18,013 | $20,544 | $22,359 | |
Subtotal Spent on Operations | $17,621 | $32,686 | $31,513 | $31,442 | $34,941 | $34,658 | $35,730 | $32,164 | $31,600 | $35,113 | $37,644 | $39,459 | |
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 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | |
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 | $18,454 | $33,519 | $32,346 | $32,275 | $35,774 | $35,491 | $36,563 | $32,997 | $32,433 | $35,946 | $38,477 | $40,292 | |
Net Cash Flow | $7,546 | ($5,019) | ($2,346) | $1,725 | $226 | $2,509 | ($2,563) | ($1,997) | $2,567 | $4,054 | $5,523 | $5,708 | |
Cash Balance | $70,746 | $65,727 | $63,381 | $65,107 | $65,333 | $67,842 | $65,279 | $63,282 | $65,849 | $69,903 | $75,426 | $81,134 |
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 | $63,200 | $70,746 | $65,727 | $63,381 | $65,107 | $65,333 | $67,842 | $65,279 | $63,282 | $65,849 | $69,903 | $75,426 | $81,134 |
Inventory | $5,000 | $8,140 | $8,866 | $9,130 | $10,780 | $11,220 | $11,880 | $10,780 | $10,230 | $11,330 | $12,650 | $13,860 | $14,630 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $68,200 | $78,886 | $74,593 | $72,511 | $75,887 | $76,553 | $79,722 | $76,059 | $73,512 | $77,179 | $82,553 | $89,286 | $95,764 |
Long-term Assets | |||||||||||||
Long-term 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 |
Accumulated Depreciation | $0 | $120 | $240 | $360 | $480 | $600 | $720 | $840 | $960 | $1,080 | $1,200 | $1,320 | $1,440 |
Total Long-term Assets | $50,000 | $49,880 | $49,760 | $49,640 | $49,520 | $49,400 | $49,280 | $49,160 | $49,040 | $48,920 | $48,800 | $48,680 | $48,560 |
Total Assets | $118,200 | $128,766 | $124,353 | $122,151 | $125,407 | $125,953 | $129,002 | $125,219 | $122,552 | $126,099 | $131,353 | $137,966 | $144,324 |
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 | $15,105 | $13,939 | $13,747 | $17,257 | $16,933 | $18,127 | $14,584 | $13,903 | $17,330 | $19,800 | $21,593 | $22,217 |
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 | $15,105 | $13,939 | $13,747 | $17,257 | $16,933 | $18,127 | $14,584 | $13,903 | $17,330 | $19,800 | $21,593 | $22,217 |
Long-term Liabilities | $50,000 | $49,167 | $48,334 | $47,501 | $46,668 | $45,835 | $45,002 | $44,169 | $43,336 | $42,503 | $41,670 | $40,837 | $40,004 |
Total Liabilities | $50,000 | $64,272 | $62,273 | $61,248 | $63,925 | $62,768 | $63,129 | $58,753 | $57,239 | $59,833 | $61,470 | $62,430 | $62,221 |
Paid-in Capital | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 |
Retained Earnings | ($11,800) | ($11,800) | ($11,800) | ($11,800) | ($11,800) | ($11,800) | ($11,800) | ($11,800) | ($11,800) | ($11,800) | ($11,800) | ($11,800) | ($11,800) |
Earnings | $0 | ($3,706) | ($6,120) | ($7,296) | ($6,718) | ($5,015) | ($2,327) | ($1,734) | ($2,886) | ($1,934) | $1,684 | $7,336 | $13,903 |
Total Capital | $68,200 | $64,494 | $62,080 | $60,904 | $61,482 | $63,185 | $65,873 | $66,466 | $65,314 | $66,266 | $69,884 | $75,536 | $82,103 |
Total Liabilities and Capital | $118,200 | $128,766 | $124,353 | $122,151 | $125,407 | $125,953 | $129,002 | $125,219 | $122,552 | $126,099 | $131,353 | $137,966 | $144,324 |
Net Worth | $68,200 | $64,494 | $62,080 | $60,904 | $61,482 | $63,185 | $65,873 | $66,466 | $65,314 | $66,266 | $69,884 | $75,536 | $82,103 |