Financial Analysis
Dallas Chicken & Ribs / Dallas Chicken & Pizza Detailed Profit and Loss Account – PROJECTIONS DRAFT
Below are estimated projections according to weekly sales. Please note that projection vary for international franchisees. These projections may vary according to footfall, location, rent and other commercial factors.
Weekly Sales in £s:
A) 3,000 – 3,500 B) 3,500 – 4,000 C) 4,000 – 4,500 D) 4,500 – 5,000 E) 5,000 – 5,500 F) 5,500 – 6,000 G) 6,000 +
| All figure in £s | B | D | F |
|---|---|---|---|
| Sales | 195000 | 247000 | 299000 |
|
Cost of Goods
|
78000 | 98800 | 119600 |
|
Gross Profit
|
117000 | 148200 | 179400 |
| Expenses | – | – | – |
|
Rent & Rates
|
15000 | 25000 | 30000 |
|
Service Charge
|
2400 | 3600 | 4800 |
| Saleries | 28500 | 35000 | 42500 |
| Other | 11000 | 13500 | 15500 |
|
Expense Total
|
56900 | 77100 | 92800 |
| Projected Profit | 60100 | 71000 | 86600 |
| Loan Interest | 5000 | 6000 | 7000 |
| Net Profit | 55100 | 65100 | 79600 |
| All figure in £s | Projection A | Projection B | Projection C |
|---|---|---|---|
| Weekly sales | 5,000 | 6,000 | 7,000 |
|
Annual Turnover
|
260,000 | 312,000 | 364,000 |
| Cost of sales (30% of Turnover) | 78,000 | 93,600 | 109,200 |
|
Gross Profit
|
182,000 | 218,400 | 254,800 |
| 70% | 70% | 70% | |
|
Administrative expenses
|
|||
| Employee costs: | |||
| Wages and salaries | 61,516 | 68,140 | 78,840 |
| Employer’s NI | 8,489 | 9,403 | 10,880 |
| Staff training and welfare | 600 | 900 | 1200 |
| Travel and subsistence | 520 | 520 | 520 |
| Motor expenses | 520 | 520 | 520 |
| 71,645 | 79,483 | 91,960 | |
| Premises costs: | |||
| Rent | 25,000 | 25,000 | 25,000 |
| Rates | 7,000 | 7,000 | 7,000 |
| Service charges | 900 | 1,200 | 1,500 |
| Light and heat | 7,800 | 9,600 | 12,000 |
| Cleaning | 1,200 | 1,500 | 1,800 |
| Royalties | 360 | 360 | 360 |
| 42,260 | 44,660 | 47,660 | |
| General administrative expenses: | |||
| Telephone and fax | 240 | 240 | 240 |
| Stationery and printing | 1,200 | 1,200 | 1,200 |
| Licences and permits | 180 | 180 | 180 |
| Refurbishment costs | 1,200 | 1,500 | 1,800 |
| Equipment expensed | 1,200 | 1,500 | 1,800 |
| Repairs and maintenance | 1,200 | 1,200 | 1,500 |
| Sundry expenses | 600 | 900 | 1,200 |
| 6,820 | 7,820 | 9,220 | |
| Legal and professional costs: | |||
| Accountancy fees | 1,200 | 1,500 | 1,800 |
| Advertising and PR | 600 | 900 | 1200 |
| Other legal and professional | 600 | 900 | 1,200 |
| 2,400 | 2,400 | 2,400 | |
| Total Administrative Expenses | 123,125 | 135,263 | 153,040 |
| 47% | 43% | 42% | |
| Operating profit | 58,875 | 83,137 | 101,760 |
| 22.64% | 26.65% | 27.96% | |
| 4,906.23 | 6,928.06 | 8,480.01 | |
| – | – | – | – |
| Hours per annum | 8,543.89 | 9,463.89 | 10,950.00 |
| Hours per week | 164.31 | 182.00 | 210.58 |
| Hours per day | 23.47 | 26.00 | 30.08 |
