| Sales 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 | ||
| Unit Sales | |||||||||||||
| Belgian Fries | 2% | 1,000 | 1,200 | 1,440 | 1,728 | 2,074 | 2,488 | 3,981 | 4,778 | 5,733 | 6,880 | 8,256 | 9,907 |
| Italian Soda | 2% | 650 | 780 | 936 | 1,123 | 1,348 | 1,617 | 2,426 | 2,790 | 3,209 | 3,690 | 4,243 | 4,880 |
| Merchandising | 2% | 100 | 120 | 144 | 160 | 180 | 220 | 299 | 358 | 430 | 516 | 619 | 743 |
| Signature Packaged Sauces | 1% | 100 | 118 | 139 | 150 | 150 | 150 | 270 | 319 | 376 | 444 | 523 | 618 |
| Total Unit Sales | 1,850 | 2,218 | 2,659 | 3,161 | 3,751 | 4,476 | 6,976 | 8,244 | 9,747 | 11,529 | 13,641 | 16,147 | |
| 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 | |
| Belgian Fries | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | |
| Italian Soda | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | |
| Merchandising | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | |
| Signature Packaged Sauces | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | |
| Sales | |||||||||||||
| Belgian Fries | £4,000 | £4,800 | £5,760 | £6,912 | £8,294 | £9,953 | £15,925 | £19,110 | £22,932 | £27,519 | £33,023 | £39,627 | |
| Italian Soda | £975 | £1,170 | £1,404 | £1,685 | £2,022 | £2,426 | £3,639 | £4,185 | £4,813 | £5,535 | £6,365 | £7,320 | |
| Merchandising | £850 | £1,020 | £1,224 | £1,360 | £1,530 | £1,870 | £2,538 | £3,046 | £3,655 | £4,386 | £5,263 | £6,316 | |
| Signature Packaged Sauces | £200 | £236 | £278 | £300 | £300 | £300 | £540 | £637 | £752 | £887 | £1,047 | £1,235 | |
| Total Sales | £6,025 | £7,226 | £8,666 | £10,257 | £12,146 | £14,549 | £22,642 | £26,978 | £32,152 | £38,326 | £45,697 | £54,498 | |
| 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 | |
| Belgian Fries | 20.00% | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 |
| Italian Soda | 10.00% | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 |
| Merchandising | 45.00% | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 |
| Signature Packaged Sauces | 50.00% | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 |
| Direct Cost of Sales | |||||||||||||
| Belgian Fries | £800 | £960 | £1,152 | £1,382 | £1,659 | £1,991 | £3,185 | £3,822 | £4,586 | £5,504 | £6,605 | £7,925 | |
| Italian Soda | £98 | £117 | £140 | £168 | £202 | £243 | £364 | £419 | £481 | £553 | £636 | £732 | |
| Merchandising | £383 | £459 | £551 | £612 | £689 | £842 | £1,142 | £1,371 | £1,645 | £1,974 | £2,368 | £2,842 | |
| Signature Packaged Sauces | £100 | £118 | £139 | £150 | £150 | £150 | £270 | £319 | £376 | £444 | £523 | £618 | |
| Subtotal Direct Cost of Sales | £1,380 | £1,654 | £1,982 | £2,313 | £2,700 | £3,225 | £4,961 | £5,930 | £7,088 | £8,474 | £10,133 | £12,117 | |
| 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 | ||
| Site Managers | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Cashiers | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Cook | 0% | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 |
| Busboy | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £6,025 | £7,226 | £8,666 | £10,257 | £12,146 | £14,549 | £22,642 | £26,978 | £32,152 | £38,326 | £45,697 | £54,498 | |
| Direct Cost of Sales | £1,380 | £1,654 | £1,982 | £2,313 | £2,700 | £3,225 | £4,961 | £5,930 | £7,088 | £8,474 | £10,133 | £12,117 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,380 | £1,654 | £1,982 | £2,313 | £2,700 | £3,225 | £4,961 | £5,930 | £7,088 | £8,474 | £10,133 | £12,117 | |
| Gross Margin | £4,645 | £5,572 | £6,684 | £7,944 | £9,447 | £11,325 | £17,681 | £21,048 | £25,063 | £29,852 | £35,565 | £42,381 | |
| Gross Margin % | 77.10% | 77.11% | 77.13% | 77.45% | 77.77% | 77.84% | 78.09% | 78.02% | 77.95% | 77.89% | 77.83% | 77.77% | |
| Expenses | |||||||||||||
| Payroll | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Marketing/Promotion | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | |
| Utilities | 15% | £125 | £125 | £125 | £125 | £125 | £125 | £300 | £300 | £300 | £300 | £300 | £300 |
| New location setup | £0 | £0 | £0 | £0 | £0 | £25,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £17,858 | £17,858 | £17,858 | £17,858 | £17,858 | £42,858 | £27,933 | £27,933 | £27,933 | £27,933 | £27,933 | £27,933 | |
| Profit Before Interest and Taxes | (£13,213) | (£12,286) | (£11,174) | (£9,914) | (£8,412) | (£31,534) | (£10,252) | (£6,885) | (£2,870) | £1,919 | £7,631 | £14,447 | |
| EBITDA | (£13,213) | (£12,286) | (£11,174) | (£9,914) | (£8,412) | (£31,534) | (£10,252) | (£6,885) | (£2,870) | £1,919 | £7,631 | £14,447 | |
| 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 Profit | (£13,213) | (£12,286) | (£11,174) | (£9,914) | (£8,412) | (£31,534) | (£10,252) | (£6,885) | (£2,870) | £1,919 | £7,631 | £14,447 | |
| Net Profit/Sales | -219.30% | -170.03% | -128.94% | -96.66% | -69.25% | -216.74% | -45.28% | -25.52% | -8.93% | 5.01% | 16.70% | 26.51% | |
| 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 Sales | £6,025 | £7,226 | £8,666 | £10,257 | £12,146 | £14,549 | £22,642 | £26,978 | £32,152 | £38,326 | £45,697 | £54,498 | |
| Subtotal Cash from Operations | £6,025 | £7,226 | £8,666 | £10,257 | £12,146 | £14,549 | £22,642 | £26,978 | £32,152 | £38,326 | £45,697 | £54,498 | |
| 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 | £6,025 | £7,226 | £8,666 | £10,257 | £12,146 | £14,549 | £22,642 | £26,978 | £32,152 | £38,326 | £45,697 | £54,498 | |
| 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 | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Bill Payments | £478 | £14,347 | £14,623 | £14,952 | £15,284 | £16,509 | £40,580 | £23,127 | £24,102 | £25,268 | £26,663 | £28,332 | |
| Subtotal Spent on Operations | £5,378 | £19,247 | £19,523 | £19,852 | £20,184 | £21,409 | £50,380 | £32,927 | £33,902 | £35,068 | £36,463 | £38,132 | |
| 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 | £5,378 | £19,247 | £19,523 | £19,852 | £20,184 | £21,409 | £50,380 | £32,927 | £33,902 | £35,068 | £36,463 | £38,132 | |
| Net Cash Flow | £647 | (£12,021) | (£10,857) | (£9,595) | (£8,038) | (£6,859) | (£27,738) | (£5,949) | (£1,750) | £3,259 | £9,234 | £16,365 | |
| Cash Balance | £731,847 | £719,826 | £708,969 | £699,374 | £691,336 | £684,477 | £656,739 | £650,791 | £649,041 | £652,299 | £661,534 | £677,899 | |
| 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 | £731,200 | £731,847 | £719,826 | £708,969 | £699,374 | £691,336 | £684,477 | £656,739 | £650,791 | £649,041 | £652,299 | £661,534 | £677,899 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £731,200 | £731,847 | £719,826 | £708,969 | £699,374 | £691,336 | £684,477 | £656,739 | £650,791 | £649,041 | £652,299 | £661,534 | £677,899 |
| 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 | £731,200 | £731,847 | £719,826 | £708,969 | £699,374 | £691,336 | £684,477 | £656,739 | £650,791 | £649,041 | £652,299 | £661,534 | £677,899 |
| 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 | £13,860 | £14,125 | £14,443 | £14,762 | £15,136 | £39,810 | £22,325 | £23,261 | £24,381 | £25,721 | £27,324 | £29,242 |
| 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 | £13,860 | £14,125 | £14,443 | £14,762 | £15,136 | £39,810 | £22,325 | £23,261 | £24,381 | £25,721 | £27,324 | £29,242 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £13,860 | £14,125 | £14,443 | £14,762 | £15,136 | £39,810 | £22,325 | £23,261 | £24,381 | £25,721 | £27,324 | £29,242 |
| Paid-in Capital | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 |
| Retained Earnings | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) |
| Earnings | £0 | (£13,213) | (£25,499) | (£36,674) | (£46,588) | (£55,000) | (£86,533) | (£96,785) | (£103,670) | (£106,540) | (£104,621) | (£96,990) | (£82,543) |
| Total Capital | £731,200 | £717,987 | £705,701 | £694,526 | £684,612 | £676,200 | £644,667 | £634,415 | £627,530 | £624,660 | £626,579 | £634,210 | £648,657 |
| Total Liabilities and Capital | £731,200 | £731,847 | £719,826 | £708,969 | £699,374 | £691,336 | £684,477 | £656,739 | £650,791 | £649,041 | £652,299 | £661,534 | £677,899 |
| Net Worth | £731,200 | £717,987 | £705,701 | £694,526 | £684,612 | £676,200 | £644,667 | £634,415 | £627,530 | £624,660 | £626,579 | £634,210 | £648,657 |
| Sales 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 | ||
| Unit Sales | |||||||||||||
| Belgian Fries | 2% | 1,000 | 1,200 | 1,440 | 1,728 | 2,074 | 2,488 | 3,981 | 4,778 | 5,733 | 6,880 | 8,256 | 9,907 |
| Italian Soda | 2% | 650 | 780 | 936 | 1,123 | 1,348 | 1,617 | 2,426 | 2,790 | 3,209 | 3,690 | 4,243 | 4,880 |
| Merchandising | 2% | 100 | 120 | 144 | 160 | 180 | 220 | 299 | 358 | 430 | 516 | 619 | 743 |
| Signature Packaged Sauces | 1% | 100 | 118 | 139 | 150 | 150 | 150 | 270 | 319 | 376 | 444 | 523 | 618 |
| Total Unit Sales | 1,850 | 2,218 | 2,659 | 3,161 | 3,751 | 4,476 | 6,976 | 8,244 | 9,747 | 11,529 | 13,641 | 16,147 | |
| 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 | |
| Belgian Fries | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | |
| Italian Soda | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | £1.50 | |
| Merchandising | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | £8.50 | |
| Signature Packaged Sauces | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | £2.00 | |
| Sales | |||||||||||||
| Belgian Fries | £4,000 | £4,800 | £5,760 | £6,912 | £8,294 | £9,953 | £15,925 | £19,110 | £22,932 | £27,519 | £33,023 | £39,627 | |
| Italian Soda | £975 | £1,170 | £1,404 | £1,685 | £2,022 | £2,426 | £3,639 | £4,185 | £4,813 | £5,535 | £6,365 | £7,320 | |
| Merchandising | £850 | £1,020 | £1,224 | £1,360 | £1,530 | £1,870 | £2,538 | £3,046 | £3,655 | £4,386 | £5,263 | £6,316 | |
| Signature Packaged Sauces | £200 | £236 | £278 | £300 | £300 | £300 | £540 | £637 | £752 | £887 | £1,047 | £1,235 | |
| Total Sales | £6,025 | £7,226 | £8,666 | £10,257 | £12,146 | £14,549 | £22,642 | £26,978 | £32,152 | £38,326 | £45,697 | £54,498 | |
| 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 | |
| Belgian Fries | 20.00% | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 | £0.80 |
| Italian Soda | 10.00% | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 | £0.15 |
| Merchandising | 45.00% | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 | £3.83 |
| Signature Packaged Sauces | 50.00% | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 |
| Direct Cost of Sales | |||||||||||||
| Belgian Fries | £800 | £960 | £1,152 | £1,382 | £1,659 | £1,991 | £3,185 | £3,822 | £4,586 | £5,504 | £6,605 | £7,925 | |
| Italian Soda | £98 | £117 | £140 | £168 | £202 | £243 | £364 | £419 | £481 | £553 | £636 | £732 | |
| Merchandising | £383 | £459 | £551 | £612 | £689 | £842 | £1,142 | £1,371 | £1,645 | £1,974 | £2,368 | £2,842 | |
| Signature Packaged Sauces | £100 | £118 | £139 | £150 | £150 | £150 | £270 | £319 | £376 | £444 | £523 | £618 | |
| Subtotal Direct Cost of Sales | £1,380 | £1,654 | £1,982 | £2,313 | £2,700 | £3,225 | £4,961 | £5,930 | £7,088 | £8,474 | £10,133 | £12,117 | |
| 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 | ||
| Site Managers | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Cashiers | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Cook | 0% | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 |
| Busboy | 0% | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £1,300 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £6,025 | £7,226 | £8,666 | £10,257 | £12,146 | £14,549 | £22,642 | £26,978 | £32,152 | £38,326 | £45,697 | £54,498 | |
| Direct Cost of Sales | £1,380 | £1,654 | £1,982 | £2,313 | £2,700 | £3,225 | £4,961 | £5,930 | £7,088 | £8,474 | £10,133 | £12,117 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,380 | £1,654 | £1,982 | £2,313 | £2,700 | £3,225 | £4,961 | £5,930 | £7,088 | £8,474 | £10,133 | £12,117 | |
| Gross Margin | £4,645 | £5,572 | £6,684 | £7,944 | £9,447 | £11,325 | £17,681 | £21,048 | £25,063 | £29,852 | £35,565 | £42,381 | |
| Gross Margin % | 77.10% | 77.11% | 77.13% | 77.45% | 77.77% | 77.84% | 78.09% | 78.02% | 77.95% | 77.89% | 77.83% | 77.77% | |
| Expenses | |||||||||||||
| Payroll | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Marketing/Promotion | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | £17,000 | |
| Utilities | 15% | £125 | £125 | £125 | £125 | £125 | £125 | £300 | £300 | £300 | £300 | £300 | £300 |
| New location setup | £0 | £0 | £0 | £0 | £0 | £25,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £17,858 | £17,858 | £17,858 | £17,858 | £17,858 | £42,858 | £27,933 | £27,933 | £27,933 | £27,933 | £27,933 | £27,933 | |
| Profit Before Interest and Taxes | (£13,213) | (£12,286) | (£11,174) | (£9,914) | (£8,412) | (£31,534) | (£10,252) | (£6,885) | (£2,870) | £1,919 | £7,631 | £14,447 | |
| EBITDA | (£13,213) | (£12,286) | (£11,174) | (£9,914) | (£8,412) | (£31,534) | (£10,252) | (£6,885) | (£2,870) | £1,919 | £7,631 | £14,447 | |
| 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 Profit | (£13,213) | (£12,286) | (£11,174) | (£9,914) | (£8,412) | (£31,534) | (£10,252) | (£6,885) | (£2,870) | £1,919 | £7,631 | £14,447 | |
| Net Profit/Sales | -219.30% | -170.03% | -128.94% | -96.66% | -69.25% | -216.74% | -45.28% | -25.52% | -8.93% | 5.01% | 16.70% | 26.51% | |
| 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 Sales | £6,025 | £7,226 | £8,666 | £10,257 | £12,146 | £14,549 | £22,642 | £26,978 | £32,152 | £38,326 | £45,697 | £54,498 | |
| Subtotal Cash from Operations | £6,025 | £7,226 | £8,666 | £10,257 | £12,146 | £14,549 | £22,642 | £26,978 | £32,152 | £38,326 | £45,697 | £54,498 | |
| 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 | £6,025 | £7,226 | £8,666 | £10,257 | £12,146 | £14,549 | £22,642 | £26,978 | £32,152 | £38,326 | £45,697 | £54,498 | |
| 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 | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £4,900 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | £9,800 | |
| Bill Payments | £478 | £14,347 | £14,623 | £14,952 | £15,284 | £16,509 | £40,580 | £23,127 | £24,102 | £25,268 | £26,663 | £28,332 | |
| Subtotal Spent on Operations | £5,378 | £19,247 | £19,523 | £19,852 | £20,184 | £21,409 | £50,380 | £32,927 | £33,902 | £35,068 | £36,463 | £38,132 | |
| 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 | £5,378 | £19,247 | £19,523 | £19,852 | £20,184 | £21,409 | £50,380 | £32,927 | £33,902 | £35,068 | £36,463 | £38,132 | |
| Net Cash Flow | £647 | (£12,021) | (£10,857) | (£9,595) | (£8,038) | (£6,859) | (£27,738) | (£5,949) | (£1,750) | £3,259 | £9,234 | £16,365 | |
| Cash Balance | £731,847 | £719,826 | £708,969 | £699,374 | £691,336 | £684,477 | £656,739 | £650,791 | £649,041 | £652,299 | £661,534 | £677,899 | |
| 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 | £731,200 | £731,847 | £719,826 | £708,969 | £699,374 | £691,336 | £684,477 | £656,739 | £650,791 | £649,041 | £652,299 | £661,534 | £677,899 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £731,200 | £731,847 | £719,826 | £708,969 | £699,374 | £691,336 | £684,477 | £656,739 | £650,791 | £649,041 | £652,299 | £661,534 | £677,899 |
| 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 | £731,200 | £731,847 | £719,826 | £708,969 | £699,374 | £691,336 | £684,477 | £656,739 | £650,791 | £649,041 | £652,299 | £661,534 | £677,899 |
| 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 | £13,860 | £14,125 | £14,443 | £14,762 | £15,136 | £39,810 | £22,325 | £23,261 | £24,381 | £25,721 | £27,324 | £29,242 |
| 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 | £13,860 | £14,125 | £14,443 | £14,762 | £15,136 | £39,810 | £22,325 | £23,261 | £24,381 | £25,721 | £27,324 | £29,242 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £13,860 | £14,125 | £14,443 | £14,762 | £15,136 | £39,810 | £22,325 | £23,261 | £24,381 | £25,721 | £27,324 | £29,242 |
| Paid-in Capital | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 | £800,000 |
| Retained Earnings | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) | (£68,800) |
| Earnings | £0 | (£13,213) | (£25,499) | (£36,674) | (£46,588) | (£55,000) | (£86,533) | (£96,785) | (£103,670) | (£106,540) | (£104,621) | (£96,990) | (£82,543) |
| Total Capital | £731,200 | £717,987 | £705,701 | £694,526 | £684,612 | £676,200 | £644,667 | £634,415 | £627,530 | £624,660 | £626,579 | £634,210 | £648,657 |
| Total Liabilities and Capital | £731,200 | £731,847 | £719,826 | £708,969 | £699,374 | £691,336 | £684,477 | £656,739 | £650,791 | £649,041 | £652,299 | £661,534 | £677,899 |
| Net Worth | £731,200 | £717,987 | £705,701 | £694,526 | £684,612 | £676,200 | £644,667 | £634,415 | £627,530 | £624,660 | £626,579 | £634,210 | £648,657 |