|
|
YEAR 1 - P&L
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Year-end |
Percent |
|
Month - |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
Totals |
of Sales |
|
Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Food* |
19,898 |
29,846 |
39,795 |
49,744 |
49,744 |
49,744 |
49,744 |
49,744 |
49,744 |
49,744 |
49,744 |
49,744 |
537,235 |
63% |
|
Beverage* |
6,842 |
10,262 |
13,683 |
17,104 |
17,104 |
17,104 |
17,104 |
17,104 |
17,104 |
17,104 |
17,104 |
17,104 |
184,723 |
22% |
|
Bar/Entertainment |
- |
- |
- |
14,576 |
14,576 |
14,576 |
14,576 |
14,576 |
14,576 |
14,576 |
14,576 |
14,576 |
131,184 |
|
|
|
26,739 |
40,109 |
53,478 |
81,424 |
81,424 |
81,424 |
81,424 |
81,424 |
81,424 |
81,424 |
81,424 |
81,424 |
853,142 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
COGS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Food (30%) |
5,969 |
8,954 |
11,939 |
14,923 |
14,923 |
14,923 |
14,923 |
14,923 |
14,923 |
14,923 |
14,923 |
14,923 |
161,171 |
19% |
|
Beverage (20%) |
1,368 |
2,052 |
2,737 |
3,421 |
3,421 |
3,421 |
3,421 |
3,421 |
3,421 |
3,421 |
3,421 |
3,421 |
36,945 |
4% |
|
Bar Labor |
- |
- |
- |
1,240 |
1,240 |
1,240 |
1,240 |
1,240 |
1,240 |
1,240 |
1,240 |
1,240 |
11,160 |
1% |
|
Entertainment |
- |
- |
- |
3,200 |
3,200 |
3,200 |
3,200 |
3,200 |
3,200 |
3,200 |
3,200 |
3,200 |
28,800 |
3% |
|
Credit Card Fee on 70% of rev. |
374 |
562 |
749 |
1,140 |
1,140 |
1,140 |
1,140 |
1,140 |
1,140 |
1,140 |
1,140 |
1,140 |
11,944 |
1% |
|
Hourly Labor (30% food sales) |
5,969 |
8,954 |
11,939 |
14,923 |
14,923 |
14,923 |
14,923 |
14,923 |
14,923 |
14,923 |
14,923 |
14,923 |
161,171 |
19% |
|
Payroll Taxes on Hourly Labor |
716 |
1,074 |
1,433 |
1,940 |
1,940 |
1,940 |
1,940 |
1,940 |
1,940 |
1,940 |
1,940 |
1,940 |
20,680 |
2% |
|
|
14,398 |
21,596 |
28,795 |
40,787 |
40,787 |
40,787 |
40,787 |
40,787 |
40,787 |
40,787 |
40,787 |
40,787 |
431,869 |
51% |
|
Gross Revenue |
$ 12,342 |
$ 18,512 |
$ 24,683 |
$ 40,637 |
$ 40,637 |
$ 40,637 |
$ 40,637 |
$ 40,637 |
$ 40,637 |
$ 40,637 |
$ 40,637 |
$ 40,637 |
421,273 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Utilities |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
24,000 |
3% |
|
Rent |
6,000 |
6,000 |
6,000 |
6,000 |
6,000 |
6,000 |
6,000 |
6,000 |
6,000 |
6,000 |
6,000 |
6,000 |
72,000 |
8% |
|
Management Payroll |
13,750 |
13,750 |
13,750 |
13,750 |
13,750 |
13,750 |
13,750 |
13,750 |
13,750 |
13,750 |
13,750 |
13,750 |
165,000 |
19% |
|
Payroll Taxes |
1,650 |
1,650 |
1,650 |
1,650 |
1,650 |
1,650 |
1,650 |
1,650 |
1,650 |
1,650 |
1,650 |
1,650 |
19,800 |
2% |
|
Professional Fees & Insurance |
600 |
600 |
600 |
600 |
600 |
600 |
600 |
600 |
600 |
600 |
600 |
600 |
7,200 |
1% |
|
Printing, office, misc., etc. |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
6,000 |
1% |
|
Advertising |
3,000 |
3,000 |
3,000 |
3,000 |
3,000 |
3,000 |
3,000 |
3,000 |
3,000 |
3,000 |
3,000 |
3,000 |
36,000 |
4% |
|
Equipment & Maintenance |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
3,600 |
0% |
|
Total Expenses |
$ 27,800 |
$ 27,800 |
$ 27,800 |
$ 27,800 |
$ 27,800 |
$ 27,800 |
$ 27,800 |
$ 27,800 |
$ 27,800 |
$ 27,800 |
$ 27,800 |
$ 27,800 |
333,600 |
39% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EBITDA |
$ (15,458) |
$ (9,288) |
$ (3,117) |
$ 12,837 |
$ 12,837 |
$ 12,837 |
$ 12,837 |
$ 12,837 |
$ 12,837 |
$ 12,837 |
$ 12,837 |
$ 12,837 |
$ 87,673 |
10% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
* Month #1 represents 40% of estimated monthly sales for
first year. Month #2 represents 60% and Month #3
represents 80%. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|