Catering For Kids

Start your own business plan »

Catering Business Plan

Appendix

Funding 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
Units
Corporate boxed lunches 0% 50 50 50 50 50 50 50 50 50 50 50 50
Corporate buffet lunches 0% 50 50 50 50 50 50 50 50 50 50 50 50
Grant Funding 0% 0 0 0 15,000 0 0 0 0 0 0 0 0
School District Reimbursement Funding 0% 600 600 600 600 600 600 600 600 600 600 600 600
Total Units 700 700 700 15,700 700 700 700 700 700 700 700 700
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Corporate boxed lunches $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75
Corporate buffet lunches $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75 $6.75
Grant Funding $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00
School District Reimbursement Funding $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00 $1.00
Funding
Corporate boxed lunches $338 $338 $338 $338 $338 $338 $338 $338 $338 $338 $338 $338
Corporate buffet lunches $338 $338 $338 $338 $338 $338 $338 $338 $338 $338 $338 $338
Grant Funding $0 $0 $0 $15,000 $0 $0 $0 $0 $0 $0 $0 $0
School District Reimbursement Funding $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Total Funding $1,275 $1,275 $1,275 $16,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Corporate boxed lunches 0.00% $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03
Corporate buffet lunches 0.00% $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03 $2.03
Grant Funding 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
School District Reimbursement Funding 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Funding
Corporate boxed lunches $101 $101 $101 $101 $101 $101 $101 $101 $101 $101 $101 $101
Corporate buffet lunches $101 $101 $101 $101 $101 $101 $101 $101 $101 $101 $101 $101
Grant Funding $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
School District Reimbursement Funding $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Funding $203 $203 $203 $203 $203 $203 $203 $203 $203 $203 $203 $203
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
Manager/Instructor 0% $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Students/Workers 0% $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Name or Title 0% $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 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
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 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Surplus and Deficit
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Funding $1,275 $1,275 $1,275 $16,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275
Direct Cost $203 $203 $203 $203 $203 $203 $203 $203 $203 $203 $203 $203
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Direct Cost $203 $203 $203 $203 $203 $203 $203 $203 $203 $203 $203 $203
Gross Surplus $1,073 $1,073 $1,073 $16,073 $1,073 $1,073 $1,073 $1,073 $1,073 $1,073 $1,073 $1,073
Gross Surplus % 84.12% 84.12% 84.12% 98.76% 84.12% 84.12% 84.12% 84.12% 84.12% 84.12% 84.12% 84.12%
Expenses
Payroll $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Sales and Marketing and Other Operating Expenses $655 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $37 $37 $37 $37 $37 $37 $37 $37 $37 $37 $37 $37
Payroll Taxes 15% $98 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Commercial Kitchen Use Overhead 15% $893 $893 $893 $893 $893 $893 $893 $893 $893 $893 $893 $893
Miscellaneous $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Total Operating Expenses $3,733 $2,980 $2,980 $2,980 $2,980 $2,980 $2,980 $2,980 $2,980 $2,980 $2,980 $2,980
Surplus Before Interest and Taxes ($2,661) ($1,908) ($1,908) $13,093 ($1,908) ($1,908) ($1,908) ($1,908) ($1,908) ($1,908) ($1,908) ($1,908)
EBITDA ($2,661) ($1,908) ($1,908) $13,093 ($1,908) ($1,908) ($1,908) ($1,908) ($1,908) ($1,908) ($1,908) ($1,908)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Surplus ($2,661) ($1,908) ($1,908) $13,093 ($1,908) ($1,908) ($1,908) ($1,908) ($1,908) ($1,908) ($1,908) ($1,908)
Net Surplus/Funding -208.69% -149.61% -149.61% 80.45% -149.61% -149.61% -149.61% -149.61% -149.61% -149.61% -149.61% -149.61%
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 Funding $1,148 $1,148 $1,148 $14,648 $1,148 $1,148 $1,148 $1,148 $1,148 $1,148 $1,148 $1,148
Cash from Receivables $0 $4 $128 $128 $178 $1,578 $128 $128 $128 $128 $128 $128
Subtotal Cash from Operations $1,148 $1,152 $1,275 $14,775 $1,325 $2,725 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275
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 $1,148 $1,152 $1,275 $14,775 $1,325 $2,725 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275
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,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Bill Payments $91 $2,675 $980 $1,013 $1,947 $980 $980 $980 $1,013 $1,947 $980 $980
Subtotal Spent on Operations $2,091 $4,675 $2,980 $3,013 $3,947 $2,980 $2,980 $2,980 $3,013 $3,947 $2,980 $2,980
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 $2,091 $4,675 $2,980 $3,013 $3,947 $2,980 $2,980 $2,980 $3,013 $3,947 $2,980 $2,980
Net Cash Flow ($944) ($3,523) ($1,705) $11,762 ($2,622) ($255) ($1,705) ($1,705) ($1,738) ($2,672) ($1,705) ($1,705)
Cash Balance $14,505 $10,982 $9,277 $21,039 $18,417 $18,162 $16,457 $14,752 $13,014 $10,342 $8,637 $6,932
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 $15,449 $14,505 $10,982 $9,277 $21,039 $18,417 $18,162 $16,457 $14,752 $13,014 $10,342 $8,637 $6,932
Accounts Receivable $0 $128 $251 $251 $1,751 $1,701 $251 $251 $251 $251 $251 $251 $251
Inventory $0 $798 $595 $393 $1,190 $988 $785 $583 $380 $1,178 $975 $773 $570
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $15,449 $15,430 $11,828 $9,921 $23,980 $21,106 $19,198 $17,291 $15,383 $14,442 $11,568 $9,661 $7,753
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $15,449 $15,430 $11,828 $9,921 $23,980 $21,106 $19,198 $17,291 $15,383 $14,442 $11,568 $9,661 $7,753
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 $2,642 $947 $947 $1,914 $947 $947 $947 $947 $1,914 $947 $947 $947
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 $2,642 $947 $947 $1,914 $947 $947 $947 $947 $1,914 $947 $947 $947
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $2,642 $947 $947 $1,914 $947 $947 $947 $947 $1,914 $947 $947 $947
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
Accumulated Surplus/Deficit ($14,551) ($14,551) ($14,551) ($14,551) ($14,551) ($14,551) ($14,551) ($14,551) ($14,551) ($14,551) ($14,551) ($14,551) ($14,551)
Surplus/Deficit $0 ($2,661) ($4,568) ($6,476) $6,617 $4,709 $2,802 $894 ($1,013) ($2,921) ($4,828) ($6,736) ($8,643)
Total Capital $15,449 $12,788 $10,881 $8,973 $22,066 $20,158 $18,251 $16,343 $14,436 $12,528 $10,621 $8,713 $6,806
Total Liabilities and Capital $15,449 $15,430 $11,828 $9,921 $23,980 $21,106 $19,198 $17,291 $15,383 $14,442 $11,568 $9,661 $7,753
Net Worth $15,449 $12,788 $10,881 $8,973 $22,066 $20,158 $18,251 $16,343 $14,436 $12,528 $10,621 $8,713 $6,806