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 | ||
Sales | |||||||||||||
Food & Liquor | 0% | £79,670 | £79,670 | £79,670 | £101,680 | £101,680 | £101,680 | £48,300 | £31,050 | £31,050 | £101,680 | £31,050 | £31,050 |
Catering | 0% | £10,200 | £10,200 | £12,750 | £16,500 | £12,750 | £12,750 | £5,313 | £5,313 | £12,750 | £16,500 | £5,313 | £5,313 |
Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Total Sales | £89,870 | £89,870 | £92,420 | £118,180 | £114,430 | £114,430 | £53,613 | £36,363 | £43,800 | £118,180 | £36,363 | £36,363 | |
Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Food & Liquor | 33% | £26,291 | £26,291 | £26,291 | £33,554 | £33,554 | £33,554 | £15,939 | £10,247 | £10,247 | £33,554 | £10,247 | £10,247 |
Catering | 33% | £3,366 | £3,366 | £4,208 | £5,445 | £4,208 | £4,208 | £1,753 | £1,753 | £4,208 | £5,445 | £1,753 | £1,753 |
Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
Subtotal Direct Cost of Sales | £29,657 | £29,657 | £30,499 | £38,999 | £37,762 | £37,762 | £17,692 | £12,000 | £14,454 | £38,999 | £12,000 | £12,000 |
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 | ||
General Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Front Manager | 0% | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 |
Captain 1 | 0% | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 |
Captain 2 | 0% | £532 | £532 | £532 | £532 | £532 | £532 | £532 | £532 | £532 | £532 | £532 | £532 |
Waitperson | 0% | £420 | £420 | £420 | £420 | £420 | £420 | £420 | £420 | £420 | £420 | £420 | £420 |
Waitperson | 0% | £322 | £322 | £322 | £322 | £322 | £322 | £322 | £322 | £322 | £322 | £322 | £322 |
Waitperson | 0% | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 |
Wait/Barperson | 0% | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 |
Bartender | 0% | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 |
Busboy 1 | 0% | £660 | £660 | £660 | £660 | £660 | £660 | £660 | £660 | £660 | £660 | £660 | £660 |
Busboy 2 | 0% | £880 | £880 | £880 | £880 | £880 | £880 | £880 | £880 | £880 | £880 | £880 | £880 |
Busboy 3 | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
Head Chef Linda | 0% | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 |
Sous Chef | 0% | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 |
Cook 1 | 0% | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 |
Cook 2 | 0% | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 |
Prep Cook/Dishwasher | 0% | £924 | £924 | £924 | £924 | £924 | £924 | £924 | £924 | £924 | £924 | £924 | £924 |
Prep/Dishwasher/Cleaning | 0% | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 |
Dishwasher | 0% | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 |
Cleaning/Dishwasher | 0% | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 |
Additional Cook | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Additional Dishwasher | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Additional Waitperson | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Additional Busboy | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Total People | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | |
Total Payroll | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 |
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 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Long-term Interest Rate | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
Tax Rate | 30.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.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 | £89,870 | £89,870 | £92,420 | £118,180 | £114,430 | £114,430 | £53,613 | £36,363 | £43,800 | £118,180 | £36,363 | £36,363 | |
Direct Cost of Sales | £29,657 | £29,657 | £30,499 | £38,999 | £37,762 | £37,762 | £17,692 | £12,000 | £14,454 | £38,999 | £12,000 | £12,000 | |
Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
Total Cost of Sales | £29,657 | £29,657 | £30,499 | £38,999 | £37,762 | £37,762 | £17,692 | £12,000 | £14,454 | £38,999 | £12,000 | £12,000 | |
Gross Margin | £60,213 | £60,213 | £61,921 | £79,181 | £76,668 | £76,668 | £35,921 | £24,363 | £29,346 | £79,181 | £24,363 | £24,363 | |
Gross Margin % | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | |
Expenses | |||||||||||||
Payroll | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | |
Sales and Marketing and Other Expenses | £5,013 | £5,540 | £5,540 | £5,540 | £5,013 | £3,845 | £3,845 | £5,013 | £3,845 | £3,845 | £3,845 | £5,013 | |
Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
Leased equipment | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
Proffesional fees accounting | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
Proffesional fees legal | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
Licences and permits | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | |
Office Supplies | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
Postage | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | |
Utilities | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | |
Insurance | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | |
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 | |
Payroll Taxes | 15% | £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 | |
Total Operating Expenses | £31,480 | £32,007 | £32,007 | £32,007 | £31,480 | £30,312 | £30,312 | £31,480 | £30,312 | £30,312 | £30,312 | £31,480 | |
Profit Before Interest and Taxes | £28,733 | £28,206 | £29,914 | £47,174 | £45,188 | £46,356 | £5,609 | (£7,117) | (£966) | £48,869 | (£5,949) | (£7,117) | |
EBITDA | £28,733 | £28,206 | £29,914 | £47,174 | £45,188 | £46,356 | £5,609 | (£7,117) | (£966) | £48,869 | (£5,949) | (£7,117) | |
Interest Expense | £1,156 | £1,145 | £1,134 | £1,123 | £1,112 | £1,101 | £1,090 | £1,078 | £1,067 | £1,056 | £1,044 | £1,033 | |
Taxes Incurred | £8,273 | £9,471 | £10,073 | £16,118 | £15,427 | £15,839 | £1,582 | (£2,868) | (£712) | £16,734 | (£2,448) | (£2,852) | |
Net Profit | £19,304 | £17,590 | £18,707 | £29,933 | £28,649 | £29,416 | £2,937 | (£5,327) | (£1,322) | £31,078 | (£4,546) | (£5,297) | |
Net Profit/Sales | 21.48% | 19.57% | 20.24% | 25.33% | 25.04% | 25.71% | 5.48% | -14.65% | -3.02% | 26.30% | -12.50% | -14.57% |
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 | £89,870 | £89,870 | £92,420 | £118,180 | £114,430 | £114,430 | £53,613 | £36,363 | £43,800 | £118,180 | £36,363 | £36,363 | |
Subtotal Cash from Operations | £89,870 | £89,870 | £92,420 | £118,180 | £114,430 | £114,430 | £53,613 | £36,363 | £43,800 | £118,180 | £36,363 | £36,363 | |
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 | £89,870 | £89,870 | £92,420 | £118,180 | £114,430 | £114,430 | £53,613 | £36,363 | £43,800 | £118,180 | £36,363 | £36,363 | |
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 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | |
Bill Payments | £1,695 | £50,907 | £52,612 | £54,481 | £68,449 | £66,039 | £64,154 | £30,660 | £22,088 | £26,805 | £65,846 | £21,218 | |
Subtotal Spent on Operations | £21,411 | £70,623 | £72,328 | £74,197 | £88,165 | £85,755 | £83,870 | £50,376 | £41,804 | £46,521 | £85,562 | £40,934 | |
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 | £1,852 | £1,863 | £1,874 | £1,884 | £1,895 | £1,907 | £1,918 | £1,929 | £1,940 | £1,951 | £1,963 | £1,974 | |
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 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | |
Subtotal Cash Spent | £25,113 | £74,336 | £76,052 | £77,931 | £91,910 | £89,512 | £87,638 | £54,155 | £45,594 | £50,322 | £89,375 | £44,758 | |
Net Cash Flow | £64,757 | £15,534 | £16,368 | £40,249 | £22,520 | £24,918 | (£34,025) | (£17,792) | (£1,794) | £67,858 | (£53,012) | (£8,395) | |
Cash Balance | £149,757 | £165,291 | £181,659 | £221,907 | £244,427 | £269,345 | £235,321 | £217,529 | £215,734 | £283,593 | £230,581 | £222,186 |
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 | £85,000 | £149,757 | £165,291 | £181,659 | £221,907 | £244,427 | £269,345 | £235,321 | £217,529 | £215,734 | £283,593 | £230,581 | £222,186 |
Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Total Current Assets | £85,000 | £149,757 | £165,291 | £181,659 | £221,907 | £244,427 | £269,345 | £235,321 | £217,529 | £215,734 | £283,593 | £230,581 | £222,186 |
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 | £85,000 | £149,757 | £165,291 | £181,659 | £221,907 | £244,427 | £269,345 | £235,321 | £217,529 | £215,734 | £283,593 | £230,581 | £222,186 |
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 | £49,155 | £50,812 | £52,197 | £66,247 | £63,862 | £63,122 | £29,928 | £21,241 | £24,559 | £65,139 | £20,486 | £21,213 |
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 | £49,155 | £50,812 | £52,197 | £66,247 | £63,862 | £63,122 | £29,928 | £21,241 | £24,559 | £65,139 | £20,486 | £21,213 |
Long-term Liabilities | £200,000 | £198,148 | £196,285 | £194,411 | £192,527 | £190,632 | £188,725 | £186,807 | £184,878 | £182,938 | £180,987 | £179,024 | £177,050 |
Total Liabilities | £200,000 | £247,303 | £247,097 | £246,608 | £258,774 | £254,494 | £251,847 | £216,735 | £206,119 | £207,497 | £246,126 | £199,510 | £198,263 |
Paid-in Capital | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 |
Retained Earnings | (£300,000) | (£301,850) | (£303,700) | (£305,550) | (£307,400) | (£309,250) | (£311,100) | (£312,950) | (£314,800) | (£316,650) | (£318,500) | (£320,350) | (£322,200) |
Earnings | £0 | £19,304 | £36,894 | £55,601 | £85,534 | £114,183 | £143,599 | £146,536 | £141,209 | £139,888 | £170,966 | £166,421 | £161,123 |
Total Capital | (£115,000) | (£97,546) | (£81,806) | (£64,949) | (£36,866) | (£10,067) | £17,499 | £18,586 | £11,409 | £8,238 | £37,466 | £31,071 | £23,923 |
Total Liabilities and Capital | £85,000 | £149,757 | £165,291 | £181,659 | £221,907 | £244,427 | £269,345 | £235,321 | £217,529 | £215,734 | £283,593 | £230,581 | £222,186 |
Net Worth | (£115,000) | (£97,546) | (£81,806) | (£64,949) | (£36,866) | (£10,067) | £17,499 | £18,586 | £11,409 | £8,238 | £37,466 | £31,071 | £23,923 |
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 | ||
Sales | |||||||||||||
Food & Liquor | 0% | £79,670 | £79,670 | £79,670 | £101,680 | £101,680 | £101,680 | £48,300 | £31,050 | £31,050 | £101,680 | £31,050 | £31,050 |
Catering | 0% | £10,200 | £10,200 | £12,750 | £16,500 | £12,750 | £12,750 | £5,313 | £5,313 | £12,750 | £16,500 | £5,313 | £5,313 |
Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Total Sales | £89,870 | £89,870 | £92,420 | £118,180 | £114,430 | £114,430 | £53,613 | £36,363 | £43,800 | £118,180 | £36,363 | £36,363 | |
Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Food & Liquor | 33% | £26,291 | £26,291 | £26,291 | £33,554 | £33,554 | £33,554 | £15,939 | £10,247 | £10,247 | £33,554 | £10,247 | £10,247 |
Catering | 33% | £3,366 | £3,366 | £4,208 | £5,445 | £4,208 | £4,208 | £1,753 | £1,753 | £4,208 | £5,445 | £1,753 | £1,753 |
Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
Subtotal Direct Cost of Sales | £29,657 | £29,657 | £30,499 | £38,999 | £37,762 | £37,762 | £17,692 | £12,000 | £14,454 | £38,999 | £12,000 | £12,000 |
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 | ||
General Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Front Manager | 0% | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 | £1,680 |
Captain 1 | 0% | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 | £518 |
Captain 2 | 0% | £532 | £532 | £532 | £532 | £532 | £532 | £532 | £532 | £532 | £532 | £532 | £532 |
Waitperson | 0% | £420 | £420 | £420 | £420 | £420 | £420 | £420 | £420 | £420 | £420 | £420 | £420 |
Waitperson | 0% | £322 | £322 | £322 | £322 | £322 | £322 | £322 | £322 | £322 | £322 | £322 | £322 |
Waitperson | 0% | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 |
Wait/Barperson | 0% | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 | £570 |
Bartender | 0% | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 | £900 |
Busboy 1 | 0% | £660 | £660 | £660 | £660 | £660 | £660 | £660 | £660 | £660 | £660 | £660 | £660 |
Busboy 2 | 0% | £880 | £880 | £880 | £880 | £880 | £880 | £880 | £880 | £880 | £880 | £880 | £880 |
Busboy 3 | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
Head Chef Linda | 0% | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 |
Sous Chef | 0% | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 |
Cook 1 | 0% | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 | £1,920 |
Cook 2 | 0% | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 | £1,480 |
Prep Cook/Dishwasher | 0% | £924 | £924 | £924 | £924 | £924 | £924 | £924 | £924 | £924 | £924 | £924 | £924 |
Prep/Dishwasher/Cleaning | 0% | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 |
Dishwasher | 0% | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 |
Cleaning/Dishwasher | 0% | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 | £980 |
Additional Cook | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Additional Dishwasher | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Additional Waitperson | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Additional Busboy | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Total People | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | |
Total Payroll | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 |
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 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Long-term Interest Rate | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
Tax Rate | 30.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.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 | £89,870 | £89,870 | £92,420 | £118,180 | £114,430 | £114,430 | £53,613 | £36,363 | £43,800 | £118,180 | £36,363 | £36,363 | |
Direct Cost of Sales | £29,657 | £29,657 | £30,499 | £38,999 | £37,762 | £37,762 | £17,692 | £12,000 | £14,454 | £38,999 | £12,000 | £12,000 | |
Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
Total Cost of Sales | £29,657 | £29,657 | £30,499 | £38,999 | £37,762 | £37,762 | £17,692 | £12,000 | £14,454 | £38,999 | £12,000 | £12,000 | |
Gross Margin | £60,213 | £60,213 | £61,921 | £79,181 | £76,668 | £76,668 | £35,921 | £24,363 | £29,346 | £79,181 | £24,363 | £24,363 | |
Gross Margin % | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | 67.00% | |
Expenses | |||||||||||||
Payroll | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | |
Sales and Marketing and Other Expenses | £5,013 | £5,540 | £5,540 | £5,540 | £5,013 | £3,845 | £3,845 | £5,013 | £3,845 | £3,845 | £3,845 | £5,013 | |
Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
Leased equipment | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
Proffesional fees accounting | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
Proffesional fees legal | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
Licences and permits | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | |
Office Supplies | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | £167 | |
Postage | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | |
Utilities | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | £1,667 | |
Insurance | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | |
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 | |
Payroll Taxes | 15% | £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 | |
Total Operating Expenses | £31,480 | £32,007 | £32,007 | £32,007 | £31,480 | £30,312 | £30,312 | £31,480 | £30,312 | £30,312 | £30,312 | £31,480 | |
Profit Before Interest and Taxes | £28,733 | £28,206 | £29,914 | £47,174 | £45,188 | £46,356 | £5,609 | (£7,117) | (£966) | £48,869 | (£5,949) | (£7,117) | |
EBITDA | £28,733 | £28,206 | £29,914 | £47,174 | £45,188 | £46,356 | £5,609 | (£7,117) | (£966) | £48,869 | (£5,949) | (£7,117) | |
Interest Expense | £1,156 | £1,145 | £1,134 | £1,123 | £1,112 | £1,101 | £1,090 | £1,078 | £1,067 | £1,056 | £1,044 | £1,033 | |
Taxes Incurred | £8,273 | £9,471 | £10,073 | £16,118 | £15,427 | £15,839 | £1,582 | (£2,868) | (£712) | £16,734 | (£2,448) | (£2,852) | |
Net Profit | £19,304 | £17,590 | £18,707 | £29,933 | £28,649 | £29,416 | £2,937 | (£5,327) | (£1,322) | £31,078 | (£4,546) | (£5,297) | |
Net Profit/Sales | 21.48% | 19.57% | 20.24% | 25.33% | 25.04% | 25.71% | 5.48% | -14.65% | -3.02% | 26.30% | -12.50% | -14.57% |
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 | £89,870 | £89,870 | £92,420 | £118,180 | £114,430 | £114,430 | £53,613 | £36,363 | £43,800 | £118,180 | £36,363 | £36,363 | |
Subtotal Cash from Operations | £89,870 | £89,870 | £92,420 | £118,180 | £114,430 | £114,430 | £53,613 | £36,363 | £43,800 | £118,180 | £36,363 | £36,363 | |
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 | £89,870 | £89,870 | £92,420 | £118,180 | £114,430 | £114,430 | £53,613 | £36,363 | £43,800 | £118,180 | £36,363 | £36,363 | |
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 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | £19,716 | |
Bill Payments | £1,695 | £50,907 | £52,612 | £54,481 | £68,449 | £66,039 | £64,154 | £30,660 | £22,088 | £26,805 | £65,846 | £21,218 | |
Subtotal Spent on Operations | £21,411 | £70,623 | £72,328 | £74,197 | £88,165 | £85,755 | £83,870 | £50,376 | £41,804 | £46,521 | £85,562 | £40,934 | |
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 | £1,852 | £1,863 | £1,874 | £1,884 | £1,895 | £1,907 | £1,918 | £1,929 | £1,940 | £1,951 | £1,963 | £1,974 | |
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 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | £1,850 | |
Subtotal Cash Spent | £25,113 | £74,336 | £76,052 | £77,931 | £91,910 | £89,512 | £87,638 | £54,155 | £45,594 | £50,322 | £89,375 | £44,758 | |
Net Cash Flow | £64,757 | £15,534 | £16,368 | £40,249 | £22,520 | £24,918 | (£34,025) | (£17,792) | (£1,794) | £67,858 | (£53,012) | (£8,395) | |
Cash Balance | £149,757 | £165,291 | £181,659 | £221,907 | £244,427 | £269,345 | £235,321 | £217,529 | £215,734 | £283,593 | £230,581 | £222,186 |
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 | £85,000 | £149,757 | £165,291 | £181,659 | £221,907 | £244,427 | £269,345 | £235,321 | £217,529 | £215,734 | £283,593 | £230,581 | £222,186 |
Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
Total Current Assets | £85,000 | £149,757 | £165,291 | £181,659 | £221,907 | £244,427 | £269,345 | £235,321 | £217,529 | £215,734 | £283,593 | £230,581 | £222,186 |
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 | £85,000 | £149,757 | £165,291 | £181,659 | £221,907 | £244,427 | £269,345 | £235,321 | £217,529 | £215,734 | £283,593 | £230,581 | £222,186 |
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 | £49,155 | £50,812 | £52,197 | £66,247 | £63,862 | £63,122 | £29,928 | £21,241 | £24,559 | £65,139 | £20,486 | £21,213 |
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 | £49,155 | £50,812 | £52,197 | £66,247 | £63,862 | £63,122 | £29,928 | £21,241 | £24,559 | £65,139 | £20,486 | £21,213 |
Long-term Liabilities | £200,000 | £198,148 | £196,285 | £194,411 | £192,527 | £190,632 | £188,725 | £186,807 | £184,878 | £182,938 | £180,987 | £179,024 | £177,050 |
Total Liabilities | £200,000 | £247,303 | £247,097 | £246,608 | £258,774 | £254,494 | £251,847 | £216,735 | £206,119 | £207,497 | £246,126 | £199,510 | £198,263 |
Paid-in Capital | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 | £185,000 |
Retained Earnings | (£300,000) | (£301,850) | (£303,700) | (£305,550) | (£307,400) | (£309,250) | (£311,100) | (£312,950) | (£314,800) | (£316,650) | (£318,500) | (£320,350) | (£322,200) |
Earnings | £0 | £19,304 | £36,894 | £55,601 | £85,534 | £114,183 | £143,599 | £146,536 | £141,209 | £139,888 | £170,966 | £166,421 | £161,123 |
Total Capital | (£115,000) | (£97,546) | (£81,806) | (£64,949) | (£36,866) | (£10,067) | £17,499 | £18,586 | £11,409 | £8,238 | £37,466 | £31,071 | £23,923 |
Total Liabilities and Capital | £85,000 | £149,757 | £165,291 | £181,659 | £221,907 | £244,427 | £269,345 | £235,321 | £217,529 | £215,734 | £283,593 | £230,581 | £222,186 |
Net Worth | (£115,000) | (£97,546) | (£81,806) | (£64,949) | (£36,866) | (£10,067) | £17,499 | £18,586 | £11,409 | £8,238 | £37,466 | £31,071 | £23,923 |