20% Discount on Business Plan Pro Premier Edition
Click here to buy now or call 0845 351 9924
 

Ethnic Food Restaurant Business Plan

Zara Restaurant and Lounge

This sample business plan can be edited directly in Business Plan Pro software.

previous
next

Appendix

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
Total Sales Food 0% £44,579 £50,948 £57,975 £65,441 £79,057 £81,253 £83,449 £74,665 £83,449 £74,665 £79,057 £79,057
Total Sales Bar/Beverages 0% £11,499 £13,141 £14,954 £16,880 £20,392 £20,958 £21,524 £19,259 £21,524 £19,259 £20,392 £20,392
Other 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Sales £56,078 £64,089 £72,929 £82,321 £99,449 £102,211 £104,973 £93,924 £104,973 £93,924 £99,449 £99,449
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
Total Cost of Sales: Food £15,603 £17,832 £20,291 £22,904 £27,670 £28,439 £29,207 £26,133 £29,207 £26,133 £27,670 £27,670
Total Cost of Sales: Bar/Beverages £3,795 £4,337 £4,935 £5,570 £6,729 £6,916 £7,103 £6,355 £7,103 £6,355 £6,729 £6,729
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £19,397 £22,168 £25,226 £28,475 £34,399 £35,355 £36,310 £32,488 £36,310 £32,488 £34,399 £34,399
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 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.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% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 £56,078 £64,089 £72,929 £82,321 £99,449 £102,211 £104,973 £93,924 £104,973 £93,924 £99,449 £99,449
Direct Cost of Sales £19,397 £22,168 £25,226 £28,475 £34,399 £35,355 £36,310 £32,488 £36,310 £32,488 £34,399 £34,399
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £19,397 £22,168 £25,226 £28,475 £34,399 £35,355 £36,310 £32,488 £36,310 £32,488 £34,399 £34,399
Gross Margin £36,681 £41,921 £47,703 £53,846 £65,050 £66,856 £68,663 £61,436 £68,663 £61,436 £65,050 £65,050
Gross Margin % 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41%
Expenses
Payroll £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299
Marketing/Promotion £1,457 £1,457 £1,457 £6,457 £0 £1,457 £2,457 £1,457 £0 £0 £0 £2,457
Depreciation £542 £542 £542 £542 £542 £542 £542 £542 £542 £542 £542 £542
Leased Equipment £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Accounting/Payroll Processing £550 £550 £550 £550 £550 £550 £550 £550 £550 £550 £550 £550
Legal Retainer Fees £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Business Licenses & Permits £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
Credit Card Expense £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548
Bank Fees £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Music & Entertainment £312 £312 £312 £312 £312 £312 £312 £312 £312 £312 £312 £312
Training / Employee Retention Programs £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Repairs & Maintenance £750 £750 £750 £750 £750 £750 £750 £750 £750 £750 £750 £750
Utility Services (Gas/Electric/Water/Sewer) £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083
Telephone/Communication Expense £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150
Insurance: Fire/Theft/Liability/Liquor/Product £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700
Restaurant Occupancy Cost (Lease) £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250
Payroll Taxes (FICA/FUTA/SUTA) & Employee Benefits 17% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Exterminator/Trash Removal £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400
Dishware/Uniforms/Cleaning Supplies/Decor £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980
Printing/Paper/Postage/Subscriptions £763 £763 £763 £763 £763 £763 £763 £763 £763 £763 £763 £763
Facility (Exterior Cleaning/Grease Trap/Hood/Windows,etc.) £0 £303 £303 £303 £303 £303 £303 £303 £303 £303 £303 £303
R&D Meals £0 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
General Business Comps £0 £0 £1,240 £1,240 £1,240 £1,240 £1,240 £1,240 £1,240 £1,240 £1,240 £1,240
Owner Comps 15% £177 £177 £177 £177 £177 £177 £177 £177 £177 £177 £177 £177
Other Expenses (ComAreaMaint, etc.) £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350
Total Operating Expenses £53,111 £53,614 £54,854 £59,854 £53,397 £54,854 £55,854 £54,854 £53,397 £53,397 £53,397 £55,854
Profit Before Interest and Taxes (£16,430) (£11,693) (£7,151) (£6,007) £11,653 £12,003 £12,809 £6,582 £15,266 £8,039 £11,653 £9,196
EBITDA (£15,888) (£11,151) (£6,609) (£5,466) £12,195 £12,544 £13,351 £7,124 £15,808 £8,581 £12,195 £9,738
Interest Expense £1,727 £1,704 £1,680 £1,657 £1,634 £1,611 £1,587 £1,564 £1,541 £1,518 £1,495 £1,471
Taxes Incurred (£5,447) (£4,019) (£2,649) (£2,299) £3,006 £3,118 £3,367 £1,505 £4,118 £1,956 £3,048 £2,317
Net Profit (£12,710) (£9,378) (£6,182) (£5,365) £7,013 £7,274 £7,855 £3,513 £9,608 £4,565 £7,111 £5,407
Net Profit/Sales -22.66% -14.63% -8.48% -6.52% 7.05% 7.12% 7.48% 3.74% 9.15% 4.86% 7.15% 5.44%
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 £56,078 £64,089 £72,929 £82,321 £99,449 £102,211 £104,973 £93,924 £104,973 £93,924 £99,449 £99,449
Subtotal Cash from Operations £56,078 £64,089 £72,929 £82,321 £99,449 £102,211 £104,973 £93,924 £104,973 £93,924 £99,449 £99,449
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 £56,078 £64,089 £72,929 £82,321 £99,449 £102,211 £104,973 £93,924 £104,973 £93,924 £99,449 £99,449
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 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299
Bill Payments £959 £29,247 £42,873 £48,926 £57,675 £65,013 £62,220 £63,929 £52,812 £65,248 £51,624 £60,586
Subtotal Spent on Operations £34,258 £62,546 £76,172 £82,225 £90,974 £98,312 £95,519 £97,228 £86,111 £98,547 £84,923 £93,885
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 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981
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 £38,239 £66,527 £80,153 £86,206 £94,955 £102,293 £99,500 £101,209 £90,092 £102,528 £88,904 £97,866
Net Cash Flow £17,839 (£2,438) (£7,224) (£3,885) £4,494 (£82) £5,473 (£7,285) £14,881 (£8,604) £10,545 £1,583
Cash Balance £164,819 £162,381 £155,157 £151,272 £155,765 £155,683 £161,157 £153,871 £168,752 £160,148 £170,693 £172,276
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 £146,980 £164,819 £162,381 £155,157 £151,272 £155,765 £155,683 £161,157 £153,871 £168,752 £160,148 £170,693 £172,276
Inventory £27,500 £21,337 £24,385 £27,749 £31,322 £37,839 £38,890 £39,941 £35,737 £39,941 £35,737 £37,839 £37,839
Other Current Assets £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311
Total Current Assets £247,791 £259,467 £260,077 £256,217 £255,905 £266,915 £267,884 £274,409 £262,919 £282,004 £269,196 £281,843 £283,426
Long-term Assets
Long-term Assets £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000
Accumulated Depreciation £0 £542 £1,083 £1,625 £2,167 £2,708 £3,250 £3,792 £4,333 £4,875 £5,417 £5,958 £6,500
Total Long-term Assets £65,000 £64,458 £63,917 £63,375 £62,833 £62,292 £61,750 £61,208 £60,667 £60,125 £59,583 £59,042 £58,500
Total Assets £312,791 £323,925 £323,994 £319,592 £318,738 £329,207 £329,634 £335,617 £323,586 £342,129 £328,779 £340,885 £341,926
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 £27,825 £41,252 £47,012 £55,505 £62,942 £60,075 £62,184 £50,621 £63,538 £49,604 £58,580 £58,194
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 £27,825 £41,252 £47,012 £55,505 £62,942 £60,075 £62,184 £50,621 £63,538 £49,604 £58,580 £58,194
Long-term Liabilities £300,000 £296,019 £292,038 £288,057 £284,076 £280,095 £276,114 £272,133 £268,152 £264,171 £260,190 £256,209 £252,228
Total Liabilities £300,000 £323,844 £333,290 £335,069 £339,581 £343,037 £336,189 £334,317 £318,773 £327,709 £309,794 £314,789 £310,422
Paid-in Capital £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000
Retained Earnings (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209)
Earnings £0 (£12,710) (£22,087) (£28,269) (£33,634) (£26,621) (£19,346) (£11,491) (£7,979) £1,629 £6,194 £13,305 £18,712
Total Capital £12,791 £82 (£9,296) (£15,478) (£20,843) (£13,829) (£6,555) £1,300 £4,813 £14,420 £18,985 £26,096 £31,504
Total Liabilities and Capital £312,791 £323,925 £323,994 £319,592 £318,738 £329,207 £329,634 £335,617 £323,586 £342,129 £328,779 £340,885 £341,926
Net Worth £12,791 £82 (£9,296) (£15,478) (£20,843) (£13,829) (£6,555) £1,300 £4,813 £14,420 £18,985 £26,096 £31,504
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 (Year 2+) 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Partner/Manager 0% £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Partner/Asst. Manager/Exec. Chef 0% £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680
Hostess (Full Time) 0% £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
Hostess (Part Time) 0% £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100
Waitperson 1 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 2 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 3 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 4 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 5 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 6 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 7 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 8 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 9 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Wait/Barperson 0% £870 £870 £870 £870 £870 £870 £870 £870 £870 £870 £870 £870
Bartender 1 0% £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200
Bartender 2 0% £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Busboy 1 0% £760 £760 £760 £760 £760 £760 £760 £760 £760 £760 £760 £760
Busboy 2 0% £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980
Busboy 3 0% £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Assistant Chef 0% £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,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% £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020
Cook 2 0% £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580
Prep Cook/Dishwasher 0% £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024
Prep Cook/Dishwasher/Cleaning 0% £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080
Dishwasher 1 0% £720 £720 £720 £720 £720 £720 £720 £720 £720 £720 £720 £720
Dishwasher 2 0% £475 £475 £475 £475 £475 £475 £475 £475 £475 £475 £475 £475
Cleaning/Dishwasher 0% £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980
Open 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 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299
previous
next
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
Total Sales Food 0% £44,579 £50,948 £57,975 £65,441 £79,057 £81,253 £83,449 £74,665 £83,449 £74,665 £79,057 £79,057
Total Sales Bar/Beverages 0% £11,499 £13,141 £14,954 £16,880 £20,392 £20,958 £21,524 £19,259 £21,524 £19,259 £20,392 £20,392
Other 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Sales £56,078 £64,089 £72,929 £82,321 £99,449 £102,211 £104,973 £93,924 £104,973 £93,924 £99,449 £99,449
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
Total Cost of Sales: Food £15,603 £17,832 £20,291 £22,904 £27,670 £28,439 £29,207 £26,133 £29,207 £26,133 £27,670 £27,670
Total Cost of Sales: Bar/Beverages £3,795 £4,337 £4,935 £5,570 £6,729 £6,916 £7,103 £6,355 £7,103 £6,355 £6,729 £6,729
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £19,397 £22,168 £25,226 £28,475 £34,399 £35,355 £36,310 £32,488 £36,310 £32,488 £34,399 £34,399
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 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.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% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 £56,078 £64,089 £72,929 £82,321 £99,449 £102,211 £104,973 £93,924 £104,973 £93,924 £99,449 £99,449
Direct Cost of Sales £19,397 £22,168 £25,226 £28,475 £34,399 £35,355 £36,310 £32,488 £36,310 £32,488 £34,399 £34,399
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £19,397 £22,168 £25,226 £28,475 £34,399 £35,355 £36,310 £32,488 £36,310 £32,488 £34,399 £34,399
Gross Margin £36,681 £41,921 £47,703 £53,846 £65,050 £66,856 £68,663 £61,436 £68,663 £61,436 £65,050 £65,050
Gross Margin % 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41% 65.41%
Expenses
Payroll £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299
Marketing/Promotion £1,457 £1,457 £1,457 £6,457 £0 £1,457 £2,457 £1,457 £0 £0 £0 £2,457
Depreciation £542 £542 £542 £542 £542 £542 £542 £542 £542 £542 £542 £542
Leased Equipment £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000 £1,000
Accounting/Payroll Processing £550 £550 £550 £550 £550 £550 £550 £550 £550 £550 £550 £550
Legal Retainer Fees £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Business Licenses & Permits £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
Credit Card Expense £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548 £1,548
Bank Fees £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Music & Entertainment £312 £312 £312 £312 £312 £312 £312 £312 £312 £312 £312 £312
Training / Employee Retention Programs £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Repairs & Maintenance £750 £750 £750 £750 £750 £750 £750 £750 £750 £750 £750 £750
Utility Services (Gas/Electric/Water/Sewer) £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083 £2,083
Telephone/Communication Expense £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150 £150
Insurance: Fire/Theft/Liability/Liquor/Product £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700 £1,700
Restaurant Occupancy Cost (Lease) £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250 £6,250
Payroll Taxes (FICA/FUTA/SUTA) & Employee Benefits 17% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Exterminator/Trash Removal £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400
Dishware/Uniforms/Cleaning Supplies/Decor £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980
Printing/Paper/Postage/Subscriptions £763 £763 £763 £763 £763 £763 £763 £763 £763 £763 £763 £763
Facility (Exterior Cleaning/Grease Trap/Hood/Windows,etc.) £0 £303 £303 £303 £303 £303 £303 £303 £303 £303 £303 £303
R&D Meals £0 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
General Business Comps £0 £0 £1,240 £1,240 £1,240 £1,240 £1,240 £1,240 £1,240 £1,240 £1,240 £1,240
Owner Comps 15% £177 £177 £177 £177 £177 £177 £177 £177 £177 £177 £177 £177
Other Expenses (ComAreaMaint, etc.) £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350 £350
Total Operating Expenses £53,111 £53,614 £54,854 £59,854 £53,397 £54,854 £55,854 £54,854 £53,397 £53,397 £53,397 £55,854
Profit Before Interest and Taxes (£16,430) (£11,693) (£7,151) (£6,007) £11,653 £12,003 £12,809 £6,582 £15,266 £8,039 £11,653 £9,196
EBITDA (£15,888) (£11,151) (£6,609) (£5,466) £12,195 £12,544 £13,351 £7,124 £15,808 £8,581 £12,195 £9,738
Interest Expense £1,727 £1,704 £1,680 £1,657 £1,634 £1,611 £1,587 £1,564 £1,541 £1,518 £1,495 £1,471
Taxes Incurred (£5,447) (£4,019) (£2,649) (£2,299) £3,006 £3,118 £3,367 £1,505 £4,118 £1,956 £3,048 £2,317
Net Profit (£12,710) (£9,378) (£6,182) (£5,365) £7,013 £7,274 £7,855 £3,513 £9,608 £4,565 £7,111 £5,407
Net Profit/Sales -22.66% -14.63% -8.48% -6.52% 7.05% 7.12% 7.48% 3.74% 9.15% 4.86% 7.15% 5.44%
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 £56,078 £64,089 £72,929 £82,321 £99,449 £102,211 £104,973 £93,924 £104,973 £93,924 £99,449 £99,449
Subtotal Cash from Operations £56,078 £64,089 £72,929 £82,321 £99,449 £102,211 £104,973 £93,924 £104,973 £93,924 £99,449 £99,449
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 £56,078 £64,089 £72,929 £82,321 £99,449 £102,211 £104,973 £93,924 £104,973 £93,924 £99,449 £99,449
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 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299
Bill Payments £959 £29,247 £42,873 £48,926 £57,675 £65,013 £62,220 £63,929 £52,812 £65,248 £51,624 £60,586
Subtotal Spent on Operations £34,258 £62,546 £76,172 £82,225 £90,974 £98,312 £95,519 £97,228 £86,111 £98,547 £84,923 £93,885
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 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981 £3,981
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 £38,239 £66,527 £80,153 £86,206 £94,955 £102,293 £99,500 £101,209 £90,092 £102,528 £88,904 £97,866
Net Cash Flow £17,839 (£2,438) (£7,224) (£3,885) £4,494 (£82) £5,473 (£7,285) £14,881 (£8,604) £10,545 £1,583
Cash Balance £164,819 £162,381 £155,157 £151,272 £155,765 £155,683 £161,157 £153,871 £168,752 £160,148 £170,693 £172,276
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 £146,980 £164,819 £162,381 £155,157 £151,272 £155,765 £155,683 £161,157 £153,871 £168,752 £160,148 £170,693 £172,276
Inventory £27,500 £21,337 £24,385 £27,749 £31,322 £37,839 £38,890 £39,941 £35,737 £39,941 £35,737 £37,839 £37,839
Other Current Assets £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311 £73,311
Total Current Assets £247,791 £259,467 £260,077 £256,217 £255,905 £266,915 £267,884 £274,409 £262,919 £282,004 £269,196 £281,843 £283,426
Long-term Assets
Long-term Assets £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000 £65,000
Accumulated Depreciation £0 £542 £1,083 £1,625 £2,167 £2,708 £3,250 £3,792 £4,333 £4,875 £5,417 £5,958 £6,500
Total Long-term Assets £65,000 £64,458 £63,917 £63,375 £62,833 £62,292 £61,750 £61,208 £60,667 £60,125 £59,583 £59,042 £58,500
Total Assets £312,791 £323,925 £323,994 £319,592 £318,738 £329,207 £329,634 £335,617 £323,586 £342,129 £328,779 £340,885 £341,926
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 £27,825 £41,252 £47,012 £55,505 £62,942 £60,075 £62,184 £50,621 £63,538 £49,604 £58,580 £58,194
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 £27,825 £41,252 £47,012 £55,505 £62,942 £60,075 £62,184 £50,621 £63,538 £49,604 £58,580 £58,194
Long-term Liabilities £300,000 £296,019 £292,038 £288,057 £284,076 £280,095 £276,114 £272,133 £268,152 £264,171 £260,190 £256,209 £252,228
Total Liabilities £300,000 £323,844 £333,290 £335,069 £339,581 £343,037 £336,189 £334,317 £318,773 £327,709 £309,794 £314,789 £310,422
Paid-in Capital £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000 £440,000
Retained Earnings (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209) (£427,209)
Earnings £0 (£12,710) (£22,087) (£28,269) (£33,634) (£26,621) (£19,346) (£11,491) (£7,979) £1,629 £6,194 £13,305 £18,712
Total Capital £12,791 £82 (£9,296) (£15,478) (£20,843) (£13,829) (£6,555) £1,300 £4,813 £14,420 £18,985 £26,096 £31,504
Total Liabilities and Capital £312,791 £323,925 £323,994 £319,592 £318,738 £329,207 £329,634 £335,617 £323,586 £342,129 £328,779 £340,885 £341,926
Net Worth £12,791 £82 (£9,296) (£15,478) (£20,843) (£13,829) (£6,555) £1,300 £4,813 £14,420 £18,985 £26,096 £31,504
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 (Year 2+) 0% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Partner/Manager 0% £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Partner/Asst. Manager/Exec. Chef 0% £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680 £2,680
Hostess (Full Time) 0% £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
Hostess (Part Time) 0% £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100 £1,100
Waitperson 1 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 2 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 3 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 4 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 5 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 6 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 7 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 8 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Waitperson 9 0% £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Wait/Barperson 0% £870 £870 £870 £870 £870 £870 £870 £870 £870 £870 £870 £870
Bartender 1 0% £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200 £1,200
Bartender 2 0% £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Busboy 1 0% £760 £760 £760 £760 £760 £760 £760 £760 £760 £760 £760 £760
Busboy 2 0% £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980
Busboy 3 0% £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600 £600
Assistant Chef 0% £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,700 £3,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% £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020 £2,020
Cook 2 0% £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580 £1,580
Prep Cook/Dishwasher 0% £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024 £1,024
Prep Cook/Dishwasher/Cleaning 0% £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080 £1,080
Dishwasher 1 0% £720 £720 £720 £720 £720 £720 £720 £720 £720 £720 £720 £720
Dishwasher 2 0% £475 £475 £475 £475 £475 £475 £475 £475 £475 £475 £475 £475
Cleaning/Dishwasher 0% £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980 £980
Open 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 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299 £33,299