| 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 | |||||||||||||
| Lunch Sales | 0% | 0 | 0 | 0 | 0 | 0 | 600 | 5,850 | 5,850 | 5,850 | 5,850 | 5,850 | 5,850 |
| Dinner Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 5,850 | 5,850 | 3,900 | 3,900 | 3,900 | 3,900 |
| Gift Shop Item Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 180 | 180 | 180 | 180 | 180 | 180 |
| Web Shop Sales | 0% | 0 | 0 | 0 | 0 | 0 | 6 | 20 | 25 | 25 | 25 | 25 | 25 |
| Catering Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |
| Liquor Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 2,330 | 2,330 | 1,940 | 1,940 | 1,940 | 1,940 |
| Wine Bottle Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 240 | 240 | 240 | 240 | 240 | 240 |
| Wine by the Glass Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 2,050 | 2,050 | 1,450 | 1,450 | 1,450 | 1,450 |
| Beer Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 2,770 | 2,770 | 2,380 | 2,380 | 2,380 | 2,380 |
| Chef's Table in the Vault Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 15 | 15 | 15 | 15 | 15 |
| Total Unit Sales | 0 | 0 | 0 | 0 | 0 | 606 | 19,306 | 19,311 | 15,981 | 15,981 | 15,981 | 15,981 | |
| 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 | |
| Lunch Sales | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | |
| Dinner Sales | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | |
| Gift Shop Item Sales | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | |
| Web Shop Sales | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | |
| Catering Sales | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | |
| Liquor Sales | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | |
| Wine Bottle Sales | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | |
| Wine by the Glass Sales | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | |
| Beer Sales | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | |
| Chef's Table in the Vault Sales | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | |
| Sales | |||||||||||||
| Lunch Sales | £0 | £0 | £0 | £0 | £0 | £6,300 | £61,425 | £61,425 | £61,425 | £61,425 | £61,425 | £61,425 | |
| Dinner Sales | £0 | £0 | £0 | £0 | £0 | £0 | £117,000 | £117,000 | £78,000 | £78,000 | £78,000 | £78,000 | |
| Gift Shop Item Sales | £0 | £0 | £0 | £0 | £0 | £0 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | |
| Web Shop Sales | £0 | £0 | £0 | £0 | £0 | £36 | £120 | £150 | £150 | £150 | £150 | £150 | |
| Catering Sales | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Liquor Sales | £0 | £0 | £0 | £0 | £0 | £0 | £10,485 | £10,485 | £8,730 | £8,730 | £8,730 | £8,730 | |
| Wine Bottle Sales | £0 | £0 | £0 | £0 | £0 | £0 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | |
| Wine by the Glass Sales | £0 | £0 | £0 | £0 | £0 | £0 | £8,200 | £8,200 | £5,800 | £5,800 | £5,800 | £5,800 | |
| Beer Sales | £0 | £0 | £0 | £0 | £0 | £0 | £8,310 | £8,310 | £7,140 | £7,140 | £7,140 | £7,140 | |
| Chef's Table in the Vault Sales | £0 | £0 | £0 | £0 | £0 | £0 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | |
| Total Sales | £0 | £0 | £0 | £0 | £0 | £6,336 | £220,260 | £220,290 | £175,965 | £175,965 | £175,965 | £175,965 | |
| 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 | |
| Lunch Sales | 32.00% | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 |
| Dinner Sales | 33.00% | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 |
| Gift Shop Item Sales | 48.00% | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 |
| Web Shop Sales | 45.00% | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 |
| Catering Sales | 34.00% | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 |
| Liquor Sales | 20.00% | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 |
| Wine Bottle Sales | 30.00% | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 |
| Wine by the Glass Sales | 20.00% | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 |
| Beer Sales | 20.00% | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 |
| Chef's Table in the Vault Sales | 35.00% | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 |
| Direct Cost of Sales | |||||||||||||
| Lunch Sales | £0 | £0 | £0 | £0 | £0 | £2,016 | £19,656 | £19,656 | £19,656 | £19,656 | £19,656 | £19,656 | |
| Dinner Sales | £0 | £0 | £0 | £0 | £0 | £0 | £38,610 | £38,610 | £25,740 | £25,740 | £25,740 | £25,740 | |
| Gift Shop Item Sales | £0 | £0 | £0 | £0 | £0 | £0 | £346 | £346 | £346 | £346 | £346 | £346 | |
| Web Shop Sales | £0 | £0 | £0 | £0 | £0 | £12 | £38 | £48 | £48 | £48 | £48 | £48 | |
| Catering Sales | £0 | £0 | £0 | £0 | £0 | £0 | £640 | £640 | £640 | £640 | £640 | £640 | |
| Liquor Sales | £0 | £0 | £0 | £0 | £0 | £0 | £3,355 | £3,355 | £2,794 | £2,794 | £2,794 | £2,794 | |
| Wine Bottle Sales | £0 | £0 | £0 | £0 | £0 | £0 | £1,229 | £1,229 | £1,229 | £1,229 | £1,229 | £1,229 | |
| Wine by the Glass Sales | £0 | £0 | £0 | £0 | £0 | £0 | £2,624 | £2,624 | £1,856 | £1,856 | £1,856 | £1,856 | |
| Beer Sales | £0 | £0 | £0 | £0 | £0 | £0 | £2,659 | £2,659 | £2,285 | £2,285 | £2,285 | £2,285 | |
| Chef's Table in the Vault Sales | £0 | £0 | £0 | £0 | £0 | £0 | £2,730 | £2,730 | £2,730 | £2,730 | £2,730 | £2,730 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £2,028 | £71,887 | £71,897 | £57,323 | £57,323 | £57,323 | £57,323 | |
| 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 Day | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Manager Night | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Manager Lounge/Bar | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Wait Staff day & night - 16 x 40 hrs x 4.00 p/hr | 0% | £0 | £0 | £0 | £0 | £0 | £1,280 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 |
| Dishwasher - 2 x 40 hrs x 7.00 p/hr | 0% | £0 | £0 | £0 | £0 | £0 | £280 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Cooks - 2 day & 3 night = 7 x 40 hrs x 10.00 p/hr | 0% | £0 | £0 | £0 | £0 | £0 | £2,800 | £11,200 | £11,200 | £11,200 | £11,200 | £11,200 | £11,200 |
| Bartenders - 4 flex x 40 hrs x 2.50 p/hr | 0% | £0 | £0 | £0 | £0 | £0 | £400 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Executive Chef | 0% | £0 | £0 | £0 | £0 | £0 | £4,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £8,760 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £6,336 | £220,260 | £220,290 | £175,965 | £175,965 | £175,965 | £175,965 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £2,028 | £71,887 | £71,897 | £57,323 | £57,323 | £57,323 | £57,323 | |
| Staff Meals | £0 | £0 | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Other Costs of Goods/DESCOMM/Bank | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £5,000 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £2,428 | £77,287 | £77,297 | £61,223 | £61,223 | £61,223 | £61,223 | |
| Gross Margin | £0 | £0 | £0 | £0 | £0 | £3,908 | £142,973 | £142,993 | £114,742 | £114,742 | £114,742 | £114,742 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 61.69% | 64.91% | 64.91% | 65.21% | 65.21% | 65.21% | 65.21% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £8,760 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | |
| Marketing/Promotion | £0 | £0 | £0 | £0 | £0 | £10,000 | £10,000 | £10,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Employee Healthcare | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £2,000 | £2,500 | £3,000 | £3,500 | £4,000 | |
| Utilities and Security Services | £0 | £0 | £0 | £500 | £1,000 | £3,600 | £3,600 | £3,600 | £2,600 | £2,600 | £2,600 | £2,600 | |
| Ceramic, Glass and Silver Upkeep | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £200 | £200 | £200 | £200 | £200 | |
| Accounting Fees | £0 | £0 | £0 | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £500 | |
| Manager Comps & Grease Handouts | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Dues and Subscriptions | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £600 | £0 | |
| Legal Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Flowers | £0 | £0 | £0 | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Travel Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Exterminating | £0 | £0 | £0 | £0 | £0 | £0 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Fines and Penalties | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £100 | |
| Payroll Processing | £0 | £0 | £0 | £0 | £190 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | |
| Insurance, Licensure & RE Taxes | £0 | £0 | £0 | £0 | £0 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Maintenance Costs/Repairs | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Linen and Dry Cleaning | £0 | £0 | £0 | £0 | £0 | £175 | £175 | £175 | £150 | £150 | £150 | £150 | |
| Computer Upkeep/Upgrade | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dish and Cleaning Supplies | £0 | £0 | £0 | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Office Products Upkeep | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £200 | £200 | £200 | £200 | £200 | £200 |
| Paper Product Deliveries | £0 | £0 | £0 | £0 | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Total Operating Expenses | £0 | £0 | £0 | £500 | £1,190 | £26,295 | £60,860 | £59,060 | £53,535 | £54,035 | £55,135 | £55,235 | |
| Profit Before Interest and Taxes | £0 | £0 | £0 | (£500) | (£1,190) | (£22,387) | £82,113 | £83,933 | £61,207 | £60,707 | £59,607 | £59,507 | |
| EBITDA | £0 | £0 | £0 | (£500) | (£1,190) | (£22,387) | £82,113 | £83,933 | £61,207 | £60,707 | £59,607 | £59,507 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | (£150) | (£357) | (£6,716) | £24,634 | £25,180 | £18,362 | £18,212 | £17,882 | £17,852 | |
| Net Profit | £0 | £0 | £0 | (£350) | (£833) | (£15,671) | £57,479 | £58,753 | £42,845 | £42,495 | £41,725 | £41,655 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | -247.33% | 26.10% | 26.67% | 24.35% | 24.15% | 23.71% | 23.67% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £6,336 | £220,260 | £220,290 | £175,965 | £175,965 | £175,965 | £175,965 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £0 | £6,336 | £220,260 | £220,290 | £175,965 | £175,965 | £175,965 | £175,965 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 6.00% | £0 | £0 | £0 | £0 | £0 | £380 | £13,216 | £13,217 | £10,558 | £10,558 | £10,558 | £10,558 |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,100 | £1,200 | £1,400 | £1,300 | £1,300 | |
| 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 | £0 | £0 | £0 | £1,000 | £1,000 | £7,716 | £234,476 | £234,607 | £187,723 | £187,923 | £187,823 | £187,823 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £8,760 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | |
| Bill Payments | £0 | £0 | £0 | £12 | £366 | £1,179 | £15,055 | £126,390 | £127,870 | £97,010 | £100,896 | £101,642 | |
| Subtotal Spent on Operations | £0 | £0 | £0 | £12 | £366 | £9,939 | £47,655 | £158,990 | £160,470 | £129,610 | £133,496 | £134,242 | |
| 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 | £0 | £0 | £0 | £12 | £366 | £9,939 | £47,655 | £158,990 | £160,470 | £129,610 | £133,496 | £134,242 | |
| Net Cash Flow | £0 | £0 | £0 | £988 | £634 | (£2,223) | £186,820 | £75,618 | £27,252 | £58,313 | £54,327 | £53,581 | |
| Cash Balance | £40,000 | £40,000 | £40,000 | £40,988 | £41,622 | £39,399 | £226,220 | £301,837 | £329,090 | £387,403 | £441,730 | £495,311 | |
| 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 | £40,000 | £40,000 | £40,000 | £40,000 | £40,988 | £41,622 | £39,399 | £226,220 | £301,837 | £329,090 | £387,403 | £441,730 | £495,311 |
| Inventory | £23,878 | £23,878 | £23,878 | £23,878 | £23,878 | £23,878 | £21,851 | £17,972 | £17,974 | £14,331 | £14,331 | £14,331 | £14,331 |
| Other Current Assets | £0 | £0 | £0 | £0 | (£1,000) | (£2,000) | (£3,000) | (£4,000) | (£5,100) | (£6,300) | (£7,700) | (£9,000) | (£10,300) |
| Total Current Assets | £63,878 | £63,878 | £63,878 | £63,878 | £63,867 | £63,501 | £58,250 | £240,191 | £314,711 | £337,120 | £394,034 | £447,061 | £499,342 |
| 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 | £63,878 | £63,878 | £63,878 | £63,878 | £63,867 | £63,501 | £58,250 | £240,191 | £314,711 | £337,120 | £394,034 | £447,061 | £499,342 |
| 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 | £0 | £0 | £0 | £338 | £805 | £10,845 | £122,092 | £124,641 | £93,647 | £97,508 | £98,252 | £98,320 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £380 | £13,596 | £26,813 | £37,371 | £47,929 | £58,487 | £69,045 |
| Subtotal Current Liabilities | £0 | £0 | £0 | £0 | £338 | £805 | £11,225 | £135,688 | £151,454 | £131,018 | £145,437 | £156,739 | £167,364 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £0 | £0 | £0 | £338 | £805 | £11,225 | £135,688 | £151,454 | £131,018 | £145,437 | £156,739 | £167,364 |
| Paid-in Capital | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 |
| Retained Earnings | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) |
| Earnings | £0 | £0 | £0 | £0 | (£350) | (£1,183) | (£16,854) | £40,625 | £99,379 | £142,224 | £184,719 | £226,444 | £268,099 |
| Total Capital | £63,878 | £63,878 | £63,878 | £63,878 | £63,528 | £62,695 | £47,025 | £104,504 | £163,257 | £206,102 | £248,597 | £290,322 | £331,977 |
| Total Liabilities and Capital | £63,878 | £63,878 | £63,878 | £63,878 | £63,867 | £63,501 | £58,250 | £240,191 | £314,711 | £337,120 | £394,034 | £447,061 | £499,342 |
| Net Worth | £63,878 | £63,878 | £63,878 | £63,878 | £63,528 | £62,695 | £47,025 | £104,504 | £163,257 | £206,102 | £248,597 | £290,322 | £331,977 |
| 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 | |||||||||||||
| Lunch Sales | 0% | 0 | 0 | 0 | 0 | 0 | 600 | 5,850 | 5,850 | 5,850 | 5,850 | 5,850 | 5,850 |
| Dinner Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 5,850 | 5,850 | 3,900 | 3,900 | 3,900 | 3,900 |
| Gift Shop Item Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 180 | 180 | 180 | 180 | 180 | 180 |
| Web Shop Sales | 0% | 0 | 0 | 0 | 0 | 0 | 6 | 20 | 25 | 25 | 25 | 25 | 25 |
| Catering Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |
| Liquor Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 2,330 | 2,330 | 1,940 | 1,940 | 1,940 | 1,940 |
| Wine Bottle Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 240 | 240 | 240 | 240 | 240 | 240 |
| Wine by the Glass Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 2,050 | 2,050 | 1,450 | 1,450 | 1,450 | 1,450 |
| Beer Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 2,770 | 2,770 | 2,380 | 2,380 | 2,380 | 2,380 |
| Chef's Table in the Vault Sales | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 15 | 15 | 15 | 15 | 15 |
| Total Unit Sales | 0 | 0 | 0 | 0 | 0 | 606 | 19,306 | 19,311 | 15,981 | 15,981 | 15,981 | 15,981 | |
| 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 | |
| Lunch Sales | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | £10.50 | |
| Dinner Sales | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | £20.00 | |
| Gift Shop Item Sales | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | |
| Web Shop Sales | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | £6.00 | |
| Catering Sales | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | £2,000.00 | |
| Liquor Sales | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | £4.50 | |
| Wine Bottle Sales | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | |
| Wine by the Glass Sales | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | £4.00 | |
| Beer Sales | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | |
| Chef's Table in the Vault Sales | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | £520.00 | |
| Sales | |||||||||||||
| Lunch Sales | £0 | £0 | £0 | £0 | £0 | £6,300 | £61,425 | £61,425 | £61,425 | £61,425 | £61,425 | £61,425 | |
| Dinner Sales | £0 | £0 | £0 | £0 | £0 | £0 | £117,000 | £117,000 | £78,000 | £78,000 | £78,000 | £78,000 | |
| Gift Shop Item Sales | £0 | £0 | £0 | £0 | £0 | £0 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | £1,080 | |
| Web Shop Sales | £0 | £0 | £0 | £0 | £0 | £36 | £120 | £150 | £150 | £150 | £150 | £150 | |
| Catering Sales | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Liquor Sales | £0 | £0 | £0 | £0 | £0 | £0 | £10,485 | £10,485 | £8,730 | £8,730 | £8,730 | £8,730 | |
| Wine Bottle Sales | £0 | £0 | £0 | £0 | £0 | £0 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | £3,840 | |
| Wine by the Glass Sales | £0 | £0 | £0 | £0 | £0 | £0 | £8,200 | £8,200 | £5,800 | £5,800 | £5,800 | £5,800 | |
| Beer Sales | £0 | £0 | £0 | £0 | £0 | £0 | £8,310 | £8,310 | £7,140 | £7,140 | £7,140 | £7,140 | |
| Chef's Table in the Vault Sales | £0 | £0 | £0 | £0 | £0 | £0 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | £7,800 | |
| Total Sales | £0 | £0 | £0 | £0 | £0 | £6,336 | £220,260 | £220,290 | £175,965 | £175,965 | £175,965 | £175,965 | |
| 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 | |
| Lunch Sales | 32.00% | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 | £3.36 |
| Dinner Sales | 33.00% | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 | £6.60 |
| Gift Shop Item Sales | 48.00% | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 |
| Web Shop Sales | 45.00% | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 | £1.92 |
| Catering Sales | 34.00% | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 | £640.00 |
| Liquor Sales | 20.00% | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 | £1.44 |
| Wine Bottle Sales | 30.00% | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 | £5.12 |
| Wine by the Glass Sales | 20.00% | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 | £1.28 |
| Beer Sales | 20.00% | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 | £0.96 |
| Chef's Table in the Vault Sales | 35.00% | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 | £182.00 |
| Direct Cost of Sales | |||||||||||||
| Lunch Sales | £0 | £0 | £0 | £0 | £0 | £2,016 | £19,656 | £19,656 | £19,656 | £19,656 | £19,656 | £19,656 | |
| Dinner Sales | £0 | £0 | £0 | £0 | £0 | £0 | £38,610 | £38,610 | £25,740 | £25,740 | £25,740 | £25,740 | |
| Gift Shop Item Sales | £0 | £0 | £0 | £0 | £0 | £0 | £346 | £346 | £346 | £346 | £346 | £346 | |
| Web Shop Sales | £0 | £0 | £0 | £0 | £0 | £12 | £38 | £48 | £48 | £48 | £48 | £48 | |
| Catering Sales | £0 | £0 | £0 | £0 | £0 | £0 | £640 | £640 | £640 | £640 | £640 | £640 | |
| Liquor Sales | £0 | £0 | £0 | £0 | £0 | £0 | £3,355 | £3,355 | £2,794 | £2,794 | £2,794 | £2,794 | |
| Wine Bottle Sales | £0 | £0 | £0 | £0 | £0 | £0 | £1,229 | £1,229 | £1,229 | £1,229 | £1,229 | £1,229 | |
| Wine by the Glass Sales | £0 | £0 | £0 | £0 | £0 | £0 | £2,624 | £2,624 | £1,856 | £1,856 | £1,856 | £1,856 | |
| Beer Sales | £0 | £0 | £0 | £0 | £0 | £0 | £2,659 | £2,659 | £2,285 | £2,285 | £2,285 | £2,285 | |
| Chef's Table in the Vault Sales | £0 | £0 | £0 | £0 | £0 | £0 | £2,730 | £2,730 | £2,730 | £2,730 | £2,730 | £2,730 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £2,028 | £71,887 | £71,897 | £57,323 | £57,323 | £57,323 | £57,323 | |
| 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 Day | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Manager Night | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Manager Lounge/Bar | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Wait Staff day & night - 16 x 40 hrs x 4.00 p/hr | 0% | £0 | £0 | £0 | £0 | £0 | £1,280 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 |
| Dishwasher - 2 x 40 hrs x 7.00 p/hr | 0% | £0 | £0 | £0 | £0 | £0 | £280 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 | £2,240 |
| Cooks - 2 day & 3 night = 7 x 40 hrs x 10.00 p/hr | 0% | £0 | £0 | £0 | £0 | £0 | £2,800 | £11,200 | £11,200 | £11,200 | £11,200 | £11,200 | £11,200 |
| Bartenders - 4 flex x 40 hrs x 2.50 p/hr | 0% | £0 | £0 | £0 | £0 | £0 | £400 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Executive Chef | 0% | £0 | £0 | £0 | £0 | £0 | £4,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £8,760 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £6,336 | £220,260 | £220,290 | £175,965 | £175,965 | £175,965 | £175,965 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £2,028 | £71,887 | £71,897 | £57,323 | £57,323 | £57,323 | £57,323 | |
| Staff Meals | £0 | £0 | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Other Costs of Goods/DESCOMM/Bank | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £5,000 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £2,428 | £77,287 | £77,297 | £61,223 | £61,223 | £61,223 | £61,223 | |
| Gross Margin | £0 | £0 | £0 | £0 | £0 | £3,908 | £142,973 | £142,993 | £114,742 | £114,742 | £114,742 | £114,742 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 61.69% | 64.91% | 64.91% | 65.21% | 65.21% | 65.21% | 65.21% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £8,760 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | |
| Marketing/Promotion | £0 | £0 | £0 | £0 | £0 | £10,000 | £10,000 | £10,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Employee Healthcare | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £2,000 | £2,500 | £3,000 | £3,500 | £4,000 | |
| Utilities and Security Services | £0 | £0 | £0 | £500 | £1,000 | £3,600 | £3,600 | £3,600 | £2,600 | £2,600 | £2,600 | £2,600 | |
| Ceramic, Glass and Silver Upkeep | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £200 | £200 | £200 | £200 | £200 | |
| Accounting Fees | £0 | £0 | £0 | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £500 | |
| Manager Comps & Grease Handouts | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Dues and Subscriptions | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £600 | £0 | |
| Legal Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Flowers | £0 | £0 | £0 | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Travel Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Exterminating | £0 | £0 | £0 | £0 | £0 | £0 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Fines and Penalties | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £100 | |
| Payroll Processing | £0 | £0 | £0 | £0 | £190 | £60 | £60 | £60 | £60 | £60 | £60 | £60 | |
| Insurance, Licensure & RE Taxes | £0 | £0 | £0 | £0 | £0 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Maintenance Costs/Repairs | £0 | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Linen and Dry Cleaning | £0 | £0 | £0 | £0 | £0 | £175 | £175 | £175 | £150 | £150 | £150 | £150 | |
| Computer Upkeep/Upgrade | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dish and Cleaning Supplies | £0 | £0 | £0 | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Office Products Upkeep | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £200 | £200 | £200 | £200 | £200 | £200 |
| Paper Product Deliveries | £0 | £0 | £0 | £0 | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Total Operating Expenses | £0 | £0 | £0 | £500 | £1,190 | £26,295 | £60,860 | £59,060 | £53,535 | £54,035 | £55,135 | £55,235 | |
| Profit Before Interest and Taxes | £0 | £0 | £0 | (£500) | (£1,190) | (£22,387) | £82,113 | £83,933 | £61,207 | £60,707 | £59,607 | £59,507 | |
| EBITDA | £0 | £0 | £0 | (£500) | (£1,190) | (£22,387) | £82,113 | £83,933 | £61,207 | £60,707 | £59,607 | £59,507 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | (£150) | (£357) | (£6,716) | £24,634 | £25,180 | £18,362 | £18,212 | £17,882 | £17,852 | |
| Net Profit | £0 | £0 | £0 | (£350) | (£833) | (£15,671) | £57,479 | £58,753 | £42,845 | £42,495 | £41,725 | £41,655 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | -247.33% | 26.10% | 26.67% | 24.35% | 24.15% | 23.71% | 23.67% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £6,336 | £220,260 | £220,290 | £175,965 | £175,965 | £175,965 | £175,965 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £0 | £6,336 | £220,260 | £220,290 | £175,965 | £175,965 | £175,965 | £175,965 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 6.00% | £0 | £0 | £0 | £0 | £0 | £380 | £13,216 | £13,217 | £10,558 | £10,558 | £10,558 | £10,558 |
| 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 | £1,000 | £1,000 | £1,000 | £1,000 | £1,100 | £1,200 | £1,400 | £1,300 | £1,300 | |
| 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 | £0 | £0 | £0 | £1,000 | £1,000 | £7,716 | £234,476 | £234,607 | £187,723 | £187,923 | £187,823 | £187,823 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £8,760 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | £32,600 | |
| Bill Payments | £0 | £0 | £0 | £12 | £366 | £1,179 | £15,055 | £126,390 | £127,870 | £97,010 | £100,896 | £101,642 | |
| Subtotal Spent on Operations | £0 | £0 | £0 | £12 | £366 | £9,939 | £47,655 | £158,990 | £160,470 | £129,610 | £133,496 | £134,242 | |
| 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 | £0 | £0 | £0 | £12 | £366 | £9,939 | £47,655 | £158,990 | £160,470 | £129,610 | £133,496 | £134,242 | |
| Net Cash Flow | £0 | £0 | £0 | £988 | £634 | (£2,223) | £186,820 | £75,618 | £27,252 | £58,313 | £54,327 | £53,581 | |
| Cash Balance | £40,000 | £40,000 | £40,000 | £40,988 | £41,622 | £39,399 | £226,220 | £301,837 | £329,090 | £387,403 | £441,730 | £495,311 | |
| 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 | £40,000 | £40,000 | £40,000 | £40,000 | £40,988 | £41,622 | £39,399 | £226,220 | £301,837 | £329,090 | £387,403 | £441,730 | £495,311 |
| Inventory | £23,878 | £23,878 | £23,878 | £23,878 | £23,878 | £23,878 | £21,851 | £17,972 | £17,974 | £14,331 | £14,331 | £14,331 | £14,331 |
| Other Current Assets | £0 | £0 | £0 | £0 | (£1,000) | (£2,000) | (£3,000) | (£4,000) | (£5,100) | (£6,300) | (£7,700) | (£9,000) | (£10,300) |
| Total Current Assets | £63,878 | £63,878 | £63,878 | £63,878 | £63,867 | £63,501 | £58,250 | £240,191 | £314,711 | £337,120 | £394,034 | £447,061 | £499,342 |
| 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 | £63,878 | £63,878 | £63,878 | £63,878 | £63,867 | £63,501 | £58,250 | £240,191 | £314,711 | £337,120 | £394,034 | £447,061 | £499,342 |
| 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 | £0 | £0 | £0 | £338 | £805 | £10,845 | £122,092 | £124,641 | £93,647 | £97,508 | £98,252 | £98,320 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £380 | £13,596 | £26,813 | £37,371 | £47,929 | £58,487 | £69,045 |
| Subtotal Current Liabilities | £0 | £0 | £0 | £0 | £338 | £805 | £11,225 | £135,688 | £151,454 | £131,018 | £145,437 | £156,739 | £167,364 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £0 | £0 | £0 | £338 | £805 | £11,225 | £135,688 | £151,454 | £131,018 | £145,437 | £156,739 | £167,364 |
| Paid-in Capital | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 | £379,309 |
| Retained Earnings | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) | (£315,431) |
| Earnings | £0 | £0 | £0 | £0 | (£350) | (£1,183) | (£16,854) | £40,625 | £99,379 | £142,224 | £184,719 | £226,444 | £268,099 |
| Total Capital | £63,878 | £63,878 | £63,878 | £63,878 | £63,528 | £62,695 | £47,025 | £104,504 | £163,257 | £206,102 | £248,597 | £290,322 | £331,977 |
| Total Liabilities and Capital | £63,878 | £63,878 | £63,878 | £63,878 | £63,867 | £63,501 | £58,250 | £240,191 | £314,711 | £337,120 | £394,034 | £447,061 | £499,342 |
| Net Worth | £63,878 | £63,878 | £63,878 | £63,878 | £63,528 | £62,695 | £47,025 | £104,504 | £163,257 | £206,102 | £248,597 | £290,322 | £331,977 |