Sumptuous Cuisine Catering
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 |