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