Sumptuous Cuisine Catering

Start your own business plan »

Catering and Ballroom Rental Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Off-Site Food & Beverage $50,000 $52,500 $55,125 $57,881 $60,775 $63,814 $67,005 $69,685 $72,472 $75,371 $78,386 $81,522
Sumptuous Ballroom Food & Beverage $0 $0 $5,000 $5,500 $6,050 $6,655 $7,321 $8,053 $8,858 $9,744 $10,718 $11,790
Subcontracted Services $25,000 $25,750 $26,523 $27,318 $28,138 $28,982 $29,851 $30,747 $31,669 $32,619 $33,598 $34,606
Ballroom Rentals $0 $0 $5,000 $7,500 $11,250 $13,750 $16,250 $18,750 $21,250 $23,750 $25,000 $26,250
Staffing $37,500 $39,375 $45,094 $47,536 $50,119 $52,852 $55,744 $58,303 $60,998 $63,836 $66,828 $69,983
Referral Fees/Commissions $6,250 $6,563 $7,516 $7,923 $8,353 $8,809 $9,291 $9,717 $10,166 $10,639 $11,138 $11,664
Event Planning $6,250 $6,563 $7,516 $7,923 $8,353 $8,809 $9,291 $9,717 $10,166 $10,639 $11,138 $11,664
Total Sales $125,000 $130,750 $151,773 $161,581 $173,038 $183,670 $194,752 $204,972 $215,580 $226,599 $236,806 $247,478
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Food and Beverage Cost 25% $12,500 $13,125 $15,031 $15,845 $16,706 $17,617 $18,581 $19,434 $20,333 $21,279 $22,276 $23,328
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $12,500 $13,125 $15,031 $15,845 $16,706 $17,617 $18,581 $19,434 $20,333 $21,279 $22,276 $23,328
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
CEO $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
COO $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Marketing Director $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Salespeople $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Administrative Assistant $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Head Cook $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Assistant Cooks $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Facility Manager $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Total People 8 8 8 8 8 8 8 8 8 8 8 8
Total Payroll $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $125,000 $130,750 $151,773 $161,581 $173,038 $183,670 $194,752 $204,972 $215,580 $226,599 $236,806 $247,478
Direct Cost of Sales $12,500 $13,125 $15,031 $15,845 $16,706 $17,617 $18,581 $19,434 $20,333 $21,279 $22,276 $23,328
Event Staff 17% $21,250 $22,228 $25,801 $27,469 $29,417 $31,224 $33,108 $34,845 $36,649 $38,522 $40,257 $42,071
Subcontracted Services $20,000 $20,600 $21,218 $21,855 $22,510 $23,185 $23,881 $24,597 $25,335 $26,095 $26,878 $27,685
Total Cost of Sales $53,750 $55,953 $62,051 $65,169 $68,633 $72,027 $75,570 $78,877 $82,316 $85,896 $89,411 $93,084
Gross Margin $71,250 $74,798 $89,722 $96,412 $104,405 $111,643 $119,182 $126,095 $133,263 $140,703 $147,395 $154,395
Gross Margin % 57.00% 57.21% 59.12% 59.67% 60.34% 60.78% 61.20% 61.52% 61.82% 62.09% 62.24% 62.39%
Expenses
Payroll $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500
Marketing/Promotion $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $8,000 $8,000 $8,000 $6,000 $6,000
Depreciation 50000 $2,333 $2,333 $2,333 $2,333 $2,333 $2,333 $2,333 $2,333 $2,333 $2,333 $2,333 $2,333
Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Utilities $500 $525 $551 $579 $608 $638 $670 $704 $739 $776 $814 $855
Insurance $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% $9,113 $9,259 $9,795 $10,045 $10,337 $10,609 $10,891 $11,152 $11,422 $11,703 $11,964 $12,236
Employee Benefits 10% $6,075 $6,173 $6,530 $6,697 $6,892 $7,072 $7,261 $7,435 $7,615 $7,802 $7,976 $8,157
Office Expenses 15% $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Facility Cleaning & Maintenance $6,450 $6,738 $7,789 $8,279 $8,852 $9,384 $9,938 $10,449 $10,979 $11,530 $12,040 $12,574
Total Operating Expenses $79,471 $80,028 $81,999 $82,933 $84,022 $85,036 $86,093 $85,072 $86,088 $87,144 $86,127 $87,155
Profit Before Interest and Taxes ($8,221) ($5,230) $7,723 $13,479 $20,383 $26,607 $33,089 $41,023 $47,175 $53,559 $61,267 $67,239
EBITDA ($5,888) ($2,897) $10,057 $15,812 $22,717 $28,941 $35,422 $43,356 $49,508 $55,892 $63,601 $69,573
Interest Expense $15,509 $15,435 $15,361 $15,287 $15,213 $15,139 $15,065 $14,991 $14,917 $14,843 $14,769 $14,694
Taxes Incurred ($7,119) ($6,200) ($2,291) ($542) $1,551 $3,441 $5,407 $7,810 $9,677 $11,615 $13,950 $15,763
Net Profit ($16,611) ($14,466) ($5,346) ($1,266) $3,619 $8,028 $12,617 $18,223 $22,581 $27,101 $32,549 $36,781
Net Profit/Sales -13.29% -11.06% -3.52% -0.78% 2.09% 4.37% 6.48% 8.89% 10.47% 11.96% 13.75% 14.86%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $62,500 $65,375 $75,886 $80,790 $86,519 $91,835 $97,376 $102,486 $107,790 $113,300 $118,403 $123,739
Cash from Receivables $72,222 $69,444 $64,033 $70,981 $78,502 $83,846 $89,354 $94,790 $100,101 $105,315 $110,728 $116,021
Subtotal Cash from Operations $134,722 $134,819 $139,920 $151,771 $165,021 $175,681 $186,730 $197,276 $207,891 $218,614 $229,131 $239,761
Additional Cash Received
Sales Tax, VAT, HST/GST Received 8.00% $10,000 $10,460 $12,142 $12,926 $13,843 $14,694 $15,580 $16,398 $17,246 $18,128 $18,944 $19,798
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 $1,870,000 $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 $2,014,722 $145,279 $152,061 $164,698 $178,864 $190,374 $202,310 $213,674 $225,137 $236,742 $248,076 $259,559
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500
Bill Payments $53,001 $90,483 $104,113 $116,411 $121,640 $128,225 $134,482 $140,936 $145,552 $151,832 $158,297 $163,138
Subtotal Spent on Operations $92,501 $129,983 $143,613 $155,911 $161,140 $167,725 $173,982 $180,436 $185,052 $191,332 $197,797 $202,638
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $10,000 $10,460 $12,142 $12,926 $13,843 $14,694 $15,580 $16,398 $17,246 $18,128 $18,944 $19,798
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 $8,889 $8,889 $8,889 $8,889 $8,889 $8,889 $8,889 $8,889 $8,889 $8,889 $8,889 $8,889
Purchase Other Current Assets $100,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $2,050,000 $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 $2,261,390 $149,332 $164,644 $177,727 $183,872 $191,307 $198,451 $205,723 $211,187 $218,349 $225,631 $231,325
Net Cash Flow ($246,668) ($4,053) ($12,582) ($13,029) ($5,008) ($933) $3,860 $7,951 $13,951 $18,393 $22,445 $28,234
Cash Balance $53,332 $49,279 $36,697 $23,668 $18,660 $17,727 $21,587 $29,538 $43,488 $61,882 $84,327 $112,561
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $300,000 $53,332 $49,279 $36,697 $23,668 $18,660 $17,727 $21,587 $29,538 $43,488 $61,882 $84,327 $112,561
Accounts Receivable $108,333 $98,611 $94,542 $106,395 $116,204 $124,221 $132,211 $140,232 $147,928 $155,617 $163,601 $171,276 $178,994
Inventory $16,000 $6,250 $6,563 $7,516 $7,923 $8,353 $8,809 $9,291 $9,717 $10,166 $10,639 $11,138 $11,664
Other Current Assets $2,500 $102,500 $102,500 $102,500 $102,500 $102,500 $102,500 $102,500 $102,500 $102,500 $102,500 $102,500 $102,500
Total Current Assets $426,833 $260,693 $252,884 $253,107 $250,294 $253,734 $261,246 $273,610 $289,683 $311,771 $338,622 $369,241 $405,719
Long-term Assets
Long-term Assets $90,000 $2,140,000 $2,140,000 $2,140,000 $2,140,000 $2,140,000 $2,140,000 $2,140,000 $2,140,000 $2,140,000 $2,140,000 $2,140,000 $2,140,000
Accumulated Depreciation $40,000 $42,333 $44,667 $47,000 $49,333 $51,667 $54,000 $56,333 $58,667 $61,000 $63,333 $65,667 $68,000
Total Long-term Assets $50,000 $2,097,667 $2,095,333 $2,093,000 $2,090,667 $2,088,333 $2,086,000 $2,083,667 $2,081,333 $2,079,000 $2,076,667 $2,074,333 $2,072,000
Total Assets $476,833 $2,358,360 $2,348,217 $2,346,107 $2,340,961 $2,342,068 $2,347,246 $2,357,276 $2,371,017 $2,390,771 $2,415,289 $2,443,574 $2,477,719
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $50,000 $87,027 $100,238 $112,364 $117,373 $123,749 $129,789 $136,091 $140,498 $146,561 $152,866 $157,491 $163,743
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 $50,000 $87,027 $100,238 $112,364 $117,373 $123,749 $129,789 $136,091 $140,498 $146,561 $152,866 $157,491 $163,743
Long-term Liabilities $0 $1,861,111 $1,852,222 $1,843,333 $1,834,444 $1,825,555 $1,816,666 $1,807,777 $1,798,888 $1,789,999 $1,781,110 $1,772,221 $1,763,332
Total Liabilities $50,000 $1,948,138 $1,952,460 $1,955,697 $1,951,817 $1,949,304 $1,946,455 $1,943,868 $1,939,386 $1,936,560 $1,933,976 $1,929,712 $1,927,075
Paid-in Capital $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000
Retained Earnings $151,833 $226,833 $226,833 $226,833 $226,833 $226,833 $226,833 $226,833 $226,833 $226,833 $226,833 $226,833 $226,833
Earnings $75,000 ($16,611) ($31,077) ($36,423) ($37,689) ($34,070) ($26,042) ($13,425) $4,797 $27,378 $54,479 $87,029 $123,810
Total Capital $426,833 $410,222 $395,756 $390,410 $389,144 $392,763 $400,791 $413,408 $431,631 $454,212 $481,313 $513,862 $550,643
Total Liabilities and Capital $476,833 $2,358,360 $2,348,217 $2,346,107 $2,340,961 $2,342,068 $2,347,246 $2,357,276 $2,371,017 $2,390,771 $2,415,289 $2,443,574 $2,477,719
Net Worth $426,833 $410,222 $395,756 $390,410 $389,144 $392,763 $400,791 $413,408 $431,631 $454,212 $481,313 $513,862 $550,643