| 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 | |||||||||||||
| Covercharge | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Meals | 0% | 0 | 1,822 | 2,552 | 2,552 | 2,552 | 2,552 | 2,552 | 4,739 | 4,739 | 4,739 | 4,739 | 4,739 |
| Drinks | 0% | 0 | 7,006 | 9,809 | 9,809 | 9,809 | 9,809 | 9,809 | 18,217 | 18,217 | 18,217 | 18,217 | 18,217 |
| Restaurant Merchandise | 0% | 0 | 25 | 100 | 100 | 100 | 100 | 100 | 200 | 200 | 100 | 100 | 100 |
| Total Unit Sales | 0 | 8,853 | 12,461 | 12,461 | 12,461 | 12,461 | 12,461 | 23,156 | 23,156 | 23,056 | 23,056 | 23,056 | |
| 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 | |
| Covercharge | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Meals | £0.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | |
| Drinks | £0.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | |
| Restaurant Merchandise | £0.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | |
| Sales | |||||||||||||
| Covercharge | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Meals | £0 | £27,330 | £38,280 | £38,280 | £38,280 | £38,280 | £38,280 | £71,085 | £71,085 | £71,085 | £71,085 | £71,085 | |
| Drinks | £0 | £35,030 | £49,045 | £49,045 | £49,045 | £49,045 | £49,045 | £91,085 | £91,085 | £91,085 | £91,085 | £91,085 | |
| Restaurant Merchandise | £0 | £200 | £800 | £800 | £800 | £800 | £800 | £1,600 | £1,600 | £800 | £800 | £800 | |
| Total Sales | £0 | £62,560 | £88,125 | £88,125 | £88,125 | £88,125 | £88,125 | £163,770 | £163,770 | £162,970 | £162,970 | £162,970 | |
| 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 | |
| Covercharge | 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 |
| Meals | 0.00% | £0.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| Drinks | 0.00% | £0.00 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 |
| Restaurant Merchandise | 0.00% | £0.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| Direct Cost of Sales | |||||||||||||
| Covercharge | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Meals | £0 | £5,466 | £7,656 | £7,656 | £7,656 | £7,656 | £7,656 | £14,217 | £14,217 | £14,217 | £14,217 | £14,217 | |
| Drinks | £0 | £3,503 | £4,905 | £4,905 | £4,905 | £4,905 | £4,905 | £9,109 | £9,109 | £9,109 | £9,109 | £9,109 | |
| Restaurant Merchandise | £0 | £75 | £300 | £300 | £300 | £300 | £300 | £600 | £600 | £300 | £300 | £300 | |
| Subtotal Direct Cost of Sales | £0 | £9,044 | £12,861 | £12,861 | £12,861 | £12,861 | £12,861 | £23,926 | £23,926 | £23,626 | £23,626 | £23,626 | |
| 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 | ||
| Management | 0% | £0 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 |
| Hostess | 0% | £0 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 |
| Waiters/Waitresses | 0% | £0 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £5,880 | £5,880 | £5,880 | £5,880 | £5,880 |
| Bartenders | 0% | £0 | £0 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £3,078 | £3,078 | £3,078 | £3,078 | £3,078 |
| Bus Boys | 0% | £0 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 |
| Cocktail Waitresses | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £672 | £672 | £672 | £672 | £672 |
| Chefs | 0% | £0 | £4,620 | £4,620 | £4,620 | £4,620 | £4,620 | £4,620 | £9,240 | £9,240 | £9,240 | £9,240 | £9,240 |
| Total People | 0 | 8 | 8 | 8 | 8 | 8 | 8 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | £0 | £15,000 | £17,430 | £17,430 | £17,430 | £17,430 | £17,430 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | |
| 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 | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 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 | £62,560 | £88,125 | £88,125 | £88,125 | £88,125 | £88,125 | £163,770 | £163,770 | £162,970 | £162,970 | £162,970 | |
| Direct Cost of Sales | £0 | £9,044 | £12,861 | £12,861 | £12,861 | £12,861 | £12,861 | £23,926 | £23,926 | £23,626 | £23,626 | £23,626 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £9,044 | £12,861 | £12,861 | £12,861 | £12,861 | £12,861 | £23,926 | £23,926 | £23,626 | £23,626 | £23,626 | |
| Gross Margin | £0 | £53,516 | £75,265 | £75,265 | £75,265 | £75,265 | £75,265 | £139,845 | £139,845 | £139,345 | £139,345 | £139,345 | |
| Gross Margin % | 0.00% | 85.54% | 85.41% | 85.41% | 85.41% | 85.41% | 85.41% | 85.39% | 85.39% | 85.50% | 85.50% | 85.50% | |
| Expenses | |||||||||||||
| Payroll | £0 | £15,000 | £17,430 | £17,430 | £17,430 | £17,430 | £17,430 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | |
| Sales and Marketing and Other Expenses | £0 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £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 | |
| Payroll Taxes | 15% | £0 | £2,250 | £2,615 | £2,615 | £2,615 | £2,615 | £2,615 | £3,726 | £3,726 | £3,726 | £3,726 | £3,726 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,000 | £20,450 | £23,245 | £23,245 | £23,245 | £23,245 | £23,245 | £31,766 | £31,766 | £31,766 | £31,766 | £31,766 | |
| Profit Before Interest and Taxes | (£3,000) | £33,066 | £52,020 | £52,020 | £52,020 | £52,020 | £52,020 | £108,079 | £108,079 | £107,579 | £107,579 | £107,579 | |
| EBITDA | (£3,000) | £33,066 | £52,020 | £52,020 | £52,020 | £52,020 | £52,020 | £108,079 | £108,079 | £107,579 | £107,579 | £107,579 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£900) | £8,267 | £13,005 | £13,005 | £13,005 | £13,005 | £13,005 | £27,020 | £27,020 | £26,895 | £26,895 | £26,895 | |
| Net Profit | (£2,100) | £24,800 | £39,015 | £39,015 | £39,015 | £39,015 | £39,015 | £81,059 | £81,059 | £80,684 | £80,684 | £80,684 | |
| Net Profit/Sales | 0.00% | 39.64% | 44.27% | 44.27% | 44.27% | 44.27% | 44.27% | 49.50% | 49.50% | 49.51% | 49.51% | 49.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 | £0 | £62,560 | £88,125 | £88,125 | £88,125 | £88,125 | £88,125 | £163,770 | £163,770 | £162,970 | £162,970 | £162,970 | |
| Subtotal Cash from Operations | £0 | £62,560 | £88,125 | £88,125 | £88,125 | £88,125 | £88,125 | £163,770 | £163,770 | £162,970 | £162,970 | £162,970 | |
| 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 | £0 | £62,560 | £88,125 | £88,125 | £88,125 | £88,125 | £88,125 | £163,770 | £163,770 | £162,970 | £162,970 | £162,970 | |
| 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 | £15,000 | £17,430 | £17,430 | £17,430 | £17,430 | £17,430 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | |
| Bill Payments | £15,520 | £3,054 | £30,881 | £35,738 | £31,680 | £31,680 | £31,680 | £32,959 | £69,637 | £57,846 | £57,127 | £57,446 | |
| Subtotal Spent on Operations | £15,520 | £18,054 | £48,311 | £53,168 | £49,110 | £49,110 | £49,110 | £57,799 | £94,477 | £82,686 | £81,967 | £82,286 | |
| 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 | £15,520 | £18,054 | £48,311 | £53,168 | £49,110 | £49,110 | £49,110 | £57,799 | £94,477 | £82,686 | £81,967 | £82,286 | |
| Net Cash Flow | (£15,520) | £44,506 | £39,814 | £34,957 | £39,015 | £39,015 | £39,015 | £105,971 | £69,293 | £80,284 | £81,003 | £80,684 | |
| Cash Balance | £6,480 | £50,986 | £90,800 | £125,757 | £164,772 | £203,787 | £242,802 | £348,773 | £418,066 | £498,350 | £579,353 | £660,037 | |
| 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 | £22,000 | £6,480 | £50,986 | £90,800 | £125,757 | £164,772 | £203,787 | £242,802 | £348,773 | £418,066 | £498,350 | £579,353 | £660,037 |
| Inventory | £2,000 | £2,000 | £9,948 | £14,147 | £14,147 | £14,147 | £14,147 | £14,147 | £26,318 | £26,318 | £25,988 | £25,988 | £25,988 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £24,000 | £8,480 | £60,935 | £104,947 | £139,904 | £178,919 | £217,934 | £256,949 | £375,091 | £444,384 | £524,338 | £605,341 | £686,025 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| Total Assets | £69,000 | £53,480 | £105,935 | £149,947 | £184,904 | £223,919 | £262,934 | £301,949 | £420,091 | £489,384 | £569,338 | £650,341 | £731,025 |
| 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 | £15,450 | £2,030 | £29,685 | £34,682 | £30,624 | £30,624 | £30,624 | £30,624 | £67,708 | £55,942 | £55,212 | £55,531 | £55,531 |
| 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 | £15,450 | £2,030 | £29,685 | £34,682 | £30,624 | £30,624 | £30,624 | £30,624 | £67,708 | £55,942 | £55,212 | £55,531 | £55,531 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £15,450 | £2,030 | £29,685 | £34,682 | £30,624 | £30,624 | £30,624 | £30,624 | £67,708 | £55,942 | £55,212 | £55,531 | £55,531 |
| Paid-in Capital | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 |
| Retained Earnings | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) |
| Earnings | £0 | (£2,100) | £22,700 | £61,715 | £100,730 | £139,745 | £178,760 | £217,775 | £298,833 | £379,892 | £460,576 | £541,260 | £621,944 |
| Total Capital | £53,550 | £51,450 | £76,250 | £115,265 | £154,280 | £193,295 | £232,310 | £271,325 | £352,383 | £433,442 | £514,126 | £594,810 | £675,494 |
| Total Liabilities and Capital | £69,000 | £53,480 | £105,935 | £149,947 | £184,904 | £223,919 | £262,934 | £301,949 | £420,091 | £489,384 | £569,338 | £650,341 | £731,025 |
| Net Worth | £53,550 | £51,450 | £76,249 | £115,265 | £154,280 | £193,295 | £232,310 | £271,325 | £352,383 | £433,442 | £514,126 | £594,810 | £675,494 |
| 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 | |||||||||||||
| Covercharge | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Meals | 0% | 0 | 1,822 | 2,552 | 2,552 | 2,552 | 2,552 | 2,552 | 4,739 | 4,739 | 4,739 | 4,739 | 4,739 |
| Drinks | 0% | 0 | 7,006 | 9,809 | 9,809 | 9,809 | 9,809 | 9,809 | 18,217 | 18,217 | 18,217 | 18,217 | 18,217 |
| Restaurant Merchandise | 0% | 0 | 25 | 100 | 100 | 100 | 100 | 100 | 200 | 200 | 100 | 100 | 100 |
| Total Unit Sales | 0 | 8,853 | 12,461 | 12,461 | 12,461 | 12,461 | 12,461 | 23,156 | 23,156 | 23,056 | 23,056 | 23,056 | |
| 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 | |
| Covercharge | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Meals | £0.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | |
| Drinks | £0.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | |
| Restaurant Merchandise | £0.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | £8.00 | |
| Sales | |||||||||||||
| Covercharge | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Meals | £0 | £27,330 | £38,280 | £38,280 | £38,280 | £38,280 | £38,280 | £71,085 | £71,085 | £71,085 | £71,085 | £71,085 | |
| Drinks | £0 | £35,030 | £49,045 | £49,045 | £49,045 | £49,045 | £49,045 | £91,085 | £91,085 | £91,085 | £91,085 | £91,085 | |
| Restaurant Merchandise | £0 | £200 | £800 | £800 | £800 | £800 | £800 | £1,600 | £1,600 | £800 | £800 | £800 | |
| Total Sales | £0 | £62,560 | £88,125 | £88,125 | £88,125 | £88,125 | £88,125 | £163,770 | £163,770 | £162,970 | £162,970 | £162,970 | |
| 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 | |
| Covercharge | 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 |
| Meals | 0.00% | £0.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| Drinks | 0.00% | £0.00 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 |
| Restaurant Merchandise | 0.00% | £0.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| Direct Cost of Sales | |||||||||||||
| Covercharge | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Meals | £0 | £5,466 | £7,656 | £7,656 | £7,656 | £7,656 | £7,656 | £14,217 | £14,217 | £14,217 | £14,217 | £14,217 | |
| Drinks | £0 | £3,503 | £4,905 | £4,905 | £4,905 | £4,905 | £4,905 | £9,109 | £9,109 | £9,109 | £9,109 | £9,109 | |
| Restaurant Merchandise | £0 | £75 | £300 | £300 | £300 | £300 | £300 | £600 | £600 | £300 | £300 | £300 | |
| Subtotal Direct Cost of Sales | £0 | £9,044 | £12,861 | £12,861 | £12,861 | £12,861 | £12,861 | £23,926 | £23,926 | £23,626 | £23,626 | £23,626 | |
| 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 | ||
| Management | 0% | £0 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 | £3,780 |
| Hostess | 0% | £0 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 | £1,470 |
| Waiters/Waitresses | 0% | £0 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £4,410 | £5,880 | £5,880 | £5,880 | £5,880 | £5,880 |
| Bartenders | 0% | £0 | £0 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £3,078 | £3,078 | £3,078 | £3,078 | £3,078 |
| Bus Boys | 0% | £0 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 | £720 |
| Cocktail Waitresses | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £672 | £672 | £672 | £672 | £672 |
| Chefs | 0% | £0 | £4,620 | £4,620 | £4,620 | £4,620 | £4,620 | £4,620 | £9,240 | £9,240 | £9,240 | £9,240 | £9,240 |
| Total People | 0 | 8 | 8 | 8 | 8 | 8 | 8 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | £0 | £15,000 | £17,430 | £17,430 | £17,430 | £17,430 | £17,430 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | |
| 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 | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 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 | £62,560 | £88,125 | £88,125 | £88,125 | £88,125 | £88,125 | £163,770 | £163,770 | £162,970 | £162,970 | £162,970 | |
| Direct Cost of Sales | £0 | £9,044 | £12,861 | £12,861 | £12,861 | £12,861 | £12,861 | £23,926 | £23,926 | £23,626 | £23,626 | £23,626 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £9,044 | £12,861 | £12,861 | £12,861 | £12,861 | £12,861 | £23,926 | £23,926 | £23,626 | £23,626 | £23,626 | |
| Gross Margin | £0 | £53,516 | £75,265 | £75,265 | £75,265 | £75,265 | £75,265 | £139,845 | £139,845 | £139,345 | £139,345 | £139,345 | |
| Gross Margin % | 0.00% | 85.54% | 85.41% | 85.41% | 85.41% | 85.41% | 85.41% | 85.39% | 85.39% | 85.50% | 85.50% | 85.50% | |
| Expenses | |||||||||||||
| Payroll | £0 | £15,000 | £17,430 | £17,430 | £17,430 | £17,430 | £17,430 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | |
| Sales and Marketing and Other Expenses | £0 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Utilities | £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 | |
| Payroll Taxes | 15% | £0 | £2,250 | £2,615 | £2,615 | £2,615 | £2,615 | £2,615 | £3,726 | £3,726 | £3,726 | £3,726 | £3,726 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,000 | £20,450 | £23,245 | £23,245 | £23,245 | £23,245 | £23,245 | £31,766 | £31,766 | £31,766 | £31,766 | £31,766 | |
| Profit Before Interest and Taxes | (£3,000) | £33,066 | £52,020 | £52,020 | £52,020 | £52,020 | £52,020 | £108,079 | £108,079 | £107,579 | £107,579 | £107,579 | |
| EBITDA | (£3,000) | £33,066 | £52,020 | £52,020 | £52,020 | £52,020 | £52,020 | £108,079 | £108,079 | £107,579 | £107,579 | £107,579 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£900) | £8,267 | £13,005 | £13,005 | £13,005 | £13,005 | £13,005 | £27,020 | £27,020 | £26,895 | £26,895 | £26,895 | |
| Net Profit | (£2,100) | £24,800 | £39,015 | £39,015 | £39,015 | £39,015 | £39,015 | £81,059 | £81,059 | £80,684 | £80,684 | £80,684 | |
| Net Profit/Sales | 0.00% | 39.64% | 44.27% | 44.27% | 44.27% | 44.27% | 44.27% | 49.50% | 49.50% | 49.51% | 49.51% | 49.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 | £0 | £62,560 | £88,125 | £88,125 | £88,125 | £88,125 | £88,125 | £163,770 | £163,770 | £162,970 | £162,970 | £162,970 | |
| Subtotal Cash from Operations | £0 | £62,560 | £88,125 | £88,125 | £88,125 | £88,125 | £88,125 | £163,770 | £163,770 | £162,970 | £162,970 | £162,970 | |
| 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 | £0 | £62,560 | £88,125 | £88,125 | £88,125 | £88,125 | £88,125 | £163,770 | £163,770 | £162,970 | £162,970 | £162,970 | |
| 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 | £15,000 | £17,430 | £17,430 | £17,430 | £17,430 | £17,430 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | |
| Bill Payments | £15,520 | £3,054 | £30,881 | £35,738 | £31,680 | £31,680 | £31,680 | £32,959 | £69,637 | £57,846 | £57,127 | £57,446 | |
| Subtotal Spent on Operations | £15,520 | £18,054 | £48,311 | £53,168 | £49,110 | £49,110 | £49,110 | £57,799 | £94,477 | £82,686 | £81,967 | £82,286 | |
| 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 | £15,520 | £18,054 | £48,311 | £53,168 | £49,110 | £49,110 | £49,110 | £57,799 | £94,477 | £82,686 | £81,967 | £82,286 | |
| Net Cash Flow | (£15,520) | £44,506 | £39,814 | £34,957 | £39,015 | £39,015 | £39,015 | £105,971 | £69,293 | £80,284 | £81,003 | £80,684 | |
| Cash Balance | £6,480 | £50,986 | £90,800 | £125,757 | £164,772 | £203,787 | £242,802 | £348,773 | £418,066 | £498,350 | £579,353 | £660,037 | |
| 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 | £22,000 | £6,480 | £50,986 | £90,800 | £125,757 | £164,772 | £203,787 | £242,802 | £348,773 | £418,066 | £498,350 | £579,353 | £660,037 |
| Inventory | £2,000 | £2,000 | £9,948 | £14,147 | £14,147 | £14,147 | £14,147 | £14,147 | £26,318 | £26,318 | £25,988 | £25,988 | £25,988 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £24,000 | £8,480 | £60,935 | £104,947 | £139,904 | £178,919 | £217,934 | £256,949 | £375,091 | £444,384 | £524,338 | £605,341 | £686,025 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 | £45,000 |
| Total Assets | £69,000 | £53,480 | £105,935 | £149,947 | £184,904 | £223,919 | £262,934 | £301,949 | £420,091 | £489,384 | £569,338 | £650,341 | £731,025 |
| 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 | £15,450 | £2,030 | £29,685 | £34,682 | £30,624 | £30,624 | £30,624 | £30,624 | £67,708 | £55,942 | £55,212 | £55,531 | £55,531 |
| 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 | £15,450 | £2,030 | £29,685 | £34,682 | £30,624 | £30,624 | £30,624 | £30,624 | £67,708 | £55,942 | £55,212 | £55,531 | £55,531 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £15,450 | £2,030 | £29,685 | £34,682 | £30,624 | £30,624 | £30,624 | £30,624 | £67,708 | £55,942 | £55,212 | £55,531 | £55,531 |
| Paid-in Capital | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 | £115,000 |
| Retained Earnings | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) | (£61,450) |
| Earnings | £0 | (£2,100) | £22,700 | £61,715 | £100,730 | £139,745 | £178,760 | £217,775 | £298,833 | £379,892 | £460,576 | £541,260 | £621,944 |
| Total Capital | £53,550 | £51,450 | £76,250 | £115,265 | £154,280 | £193,295 | £232,310 | £271,325 | £352,383 | £433,442 | £514,126 | £594,810 | £675,494 |
| Total Liabilities and Capital | £69,000 | £53,480 | £105,935 | £149,947 | £184,904 | £223,919 | £262,934 | £301,949 | £420,091 | £489,384 | £569,338 | £650,341 | £731,025 |
| Net Worth | £53,550 | £51,450 | £76,249 | £115,265 | £154,280 | £193,295 | £232,310 | £271,325 | £352,383 | £433,442 | £514,126 | £594,810 | £675,494 |