| 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 |