What's For Dinner?

Start your own business plan »

Food Preparation 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
Party Fees 0% $10,500 $17,500 $26,250 $35,000 $44,297 $66,445 $66,445 $66,445 $99,667 $112,125 $149,500 $163,500
Other Fees 0% $300 $500 $750 $1,000 $1,266 $1,898 $1,898 $1,898 $2,848 $3,204 $4,271 $4,671
Total Sales $10,800 $18,000 $27,000 $36,000 $45,563 $68,343 $68,343 $68,343 $102,515 $115,329 $153,771 $168,171
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
Ingredients $7,500 $12,500 $18,750 $25,000 $31,641 $47,461 $47,461 $47,461 $71,191 $80,089 $106,786 $116,786
Other Supplies $540 $900 $1,350 $1,800 $2,278 $3,417 $3,417 $3,417 $5,126 $5,766 $7,689 $8,409
Subtotal Direct Cost of Sales $8,040 $13,400 $20,100 $26,800 $33,919 $50,878 $50,878 $50,878 $76,316 $85,856 $114,474 $125,194
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
Alan Kirby 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
Kim Kirby 0% $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417
Part-time cleaner 0% $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833
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 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.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 24.00% 24.00% 24.00% 24.00% 24.00% 24.00% 24.00% 24.00% 24.00% 24.00% 24.00% 24.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 $10,800 $18,000 $27,000 $36,000 $45,563 $68,343 $68,343 $68,343 $102,515 $115,329 $153,771 $168,171
Direct Cost of Sales $8,040 $13,400 $20,100 $26,800 $33,919 $50,878 $50,878 $50,878 $76,316 $85,856 $114,474 $125,194
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $8,040 $13,400 $20,100 $26,800 $33,919 $50,878 $50,878 $50,878 $76,316 $85,856 $114,474 $125,194
Gross Margin $2,760 $4,600 $6,900 $9,200 $11,644 $17,466 $17,466 $17,466 $26,198 $29,473 $39,297 $42,977
Gross Margin % 25.56% 25.56% 25.56% 25.56% 25.56% 25.56% 25.56% 25.56% 25.56% 25.56% 25.56% 25.56%
Expenses
Payroll $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833
Sales and Marketing and Other Expenses $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Depreciation $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
Rent $4,442 $4,442 $4,442 $4,442 $4,442 $4,442 $4,442 $4,442 $4,442 $4,442 $4,442 $4,442
Utilities $980 $1,030 $1,030 $1,030 $1,030 $980 $980 $980 $1,280 $1,280 $1,280 $1,280
Office Supplies $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Insurance $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accountant $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Lawyer $500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $500
Bank Charges $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $15
Website Payment Fees $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Website Hosting & Support 0% $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Repairs and Maintenance 15% $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $10,395 $9,945 $9,945 $9,945 $9,945 $9,895 $9,895 $9,895 $10,195 $10,195 $10,195 $10,695
Profit Before Interest and Taxes ($7,635) ($5,345) ($3,045) ($745) $1,698 $7,570 $7,570 $7,570 $16,003 $19,278 $29,102 $32,282
EBITDA ($7,285) ($4,995) ($2,695) ($395) $2,048 $7,920 $7,920 $7,920 $16,353 $19,628 $29,452 $32,632
Interest Expense $1,504 $1,493 $1,483 $1,472 $1,461 $1,451 $1,440 $1,429 $1,418 $1,408 $1,397 $1,386
Taxes Incurred ($2,193) ($1,641) ($1,087) ($532) $57 $1,469 $1,471 $1,474 $3,500 $4,289 $6,649 $7,415
Net Profit ($6,946) ($5,198) ($3,441) ($1,685) $180 $4,651 $4,659 $4,667 $11,084 $13,581 $21,056 $23,481
Net Profit/Sales -64.32% -28.88% -12.75% -4.68% 0.40% 6.81% 6.82% 6.83% 10.81% 11.78% 13.69% 13.96%
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 $10,800 $18,000 $27,000 $36,000 $45,563 $68,343 $68,343 $68,343 $102,515 $115,329 $153,771 $168,171
Subtotal Cash from Operations $10,800 $18,000 $27,000 $36,000 $45,563 $68,343 $68,343 $68,343 $102,515 $115,329 $153,771 $168,171
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 $10,800 $18,000 $27,000 $36,000 $45,563 $68,343 $68,343 $68,343 $102,515 $115,329 $153,771 $168,171
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 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833 $2,833
Bill Payments $480 $14,790 $26,201 $34,869 $42,144 $51,001 $78,542 $60,501 $62,351 $115,990 $110,789 $160,756
Subtotal Spent on Operations $3,314 $17,624 $29,034 $37,703 $44,977 $53,834 $81,375 $63,334 $65,184 $118,824 $113,622 $163,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,840 $1,840 $1,840 $1,840 $1,840 $1,840 $1,840 $1,840 $1,840 $1,840 $1,840 $1,840
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 $5,154 $19,464 $30,874 $39,543 $46,817 $55,674 $83,215 $65,174 $67,024 $120,664 $115,462 $165,429
Net Cash Flow $5,646 ($1,464) ($3,874) ($3,543) ($1,254) $12,669 ($14,872) $3,169 $35,491 ($5,335) $38,309 $2,742
Cash Balance $39,646 $38,183 $34,309 $30,766 $29,512 $42,181 $27,309 $30,478 $65,969 $60,633 $98,942 $101,685
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 $34,000 $39,646 $38,183 $34,309 $30,766 $29,512 $42,181 $27,309 $30,478 $65,969 $60,633 $98,942 $101,685
Inventory $9,000 $8,844 $14,740 $22,110 $29,480 $37,311 $55,966 $55,966 $55,966 $83,948 $94,441 $125,922 $137,714
Other Current Assets $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Total Current Assets $51,000 $56,490 $60,923 $64,419 $68,246 $74,822 $106,146 $91,274 $94,444 $157,917 $163,075 $232,864 $247,399
Long-term Assets
Long-term Assets $42,000 $42,000 $42,000 $42,000 $42,000 $42,000 $42,000 $42,000 $42,000 $42,000 $42,000 $42,000 $42,000
Accumulated Depreciation $0 $350 $700 $1,050 $1,400 $1,750 $2,100 $2,450 $2,800 $3,150 $3,500 $3,850 $4,200
Total Long-term Assets $42,000 $41,650 $41,300 $40,950 $40,600 $40,250 $39,900 $39,550 $39,200 $38,850 $38,500 $38,150 $37,800
Total Assets $93,000 $98,140 $102,223 $105,369 $108,846 $115,072 $146,046 $130,824 $133,644 $196,767 $201,575 $271,014 $285,199
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 $13,927 $25,047 $33,474 $40,476 $48,362 $76,525 $58,484 $58,476 $112,355 $105,422 $155,646 $148,189
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 $13,927 $25,047 $33,474 $40,476 $48,362 $76,525 $58,484 $58,476 $112,355 $105,422 $155,646 $148,189
Long-term Liabilities $259,708 $257,868 $256,028 $254,188 $252,348 $250,508 $248,668 $246,828 $244,988 $243,148 $241,308 $239,468 $237,628
Total Liabilities $259,708 $271,795 $281,075 $287,662 $292,824 $298,870 $325,193 $305,312 $303,464 $355,503 $346,730 $395,114 $385,817
Paid-in Capital $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
Retained Earnings ($196,708) ($196,708) ($196,708) ($196,708) ($196,708) ($196,708) ($196,708) ($196,708) ($196,708) ($196,708) ($196,708) ($196,708) ($196,708)
Earnings $0 ($6,946) ($12,144) ($15,585) ($17,270) ($17,090) ($12,439) ($7,780) ($3,113) $7,972 $21,553 $42,608 $66,089
Total Capital ($166,708) ($173,654) ($178,852) ($182,293) ($183,978) ($183,798) ($179,147) ($174,488) ($169,821) ($158,736) ($145,155) ($124,100) ($100,619)
Total Liabilities and Capital $93,000 $98,140 $102,223 $105,369 $108,846 $115,072 $146,046 $130,824 $133,644 $196,767 $201,575 $271,014 $285,199
Net Worth ($166,708) ($173,654) ($178,852) ($182,293) ($183,978) ($183,798) ($179,147) ($174,488) ($169,821) ($158,736) ($145,155) ($124,100) ($100,619)