ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
INPUTS
2
3
4
AssetsQuantityN/unit costN/Total
5
AIR CONDITIONERS 10 85,000.00 850,000.00
6
SMART TVS 5 150,000.00 750,000.00
7
SNOOKER TABLE 10.00 4,000,000.00 40,000,000.00
8
GENERATOR/UPS/INVERTER PS 7,000,000.00 7,000,000.00
9
DJ BOOT 1 100,000.00 100,000.00
10
LOUNGE CHAIRS 24 20,000.00 480,000.00
11
LOUNGE TABLES/CHAIRS 6 35,000.00 210,000.00
12
COCKTAIL TABLES 12 20,000.00 240,000.00
13
BAR STOOLS 10 10,000.00 100,000.00
14
Total: 49,730,000.00
15
Preliminary Expemses
16
DOORS AND ITS ACCESSORIES PS 400,000.00 400,000.00
17
RENT 370 35,000.00 12,950,000.00
18
TILING247.9 4,500.00 1,115,550.00
19
KITCHENPS 1,000,000.00 1,000,000.00
20
POP CEILING 247.90 5,000.00 1,239,500.00
21
WALL SCREEDING PS 350,000.00 350,000.00
22
PAINTING PS 350,000.00 350,000.00
23
WALL PAPERS PS 100,000.00 100,000.00
24
SANITORY MATERIALS 4.00 100,000.00 400,000.00
25
MOOD WALL/BRANDING WORKS PS 300,000.00 300,000.00
26
Total: 18,205,050.00
27
28
Estimated working capital for first 3 months:
Food & Drinks (Inventories)
7,145,714.29 21,437,142.86
29
 Staff salary 700,000.00 2,100,000.00
30
 Diesel & Lighting, water 600,000.00 1,800,000.00
31
 Other Opex 150,000.00 450,000.00
32
Working Capital (3-month Opex)
Total: 25,787,142.86
33
34
Total Budget: 93,722,192.86
35
Contigencies (4% of Total budget)
 3,748,887.71
36
Grand Total Budget : 97,471,080.57
37
38
OPEX:
39
Salaries/ Month N N
40
MANAGER1 120,000.00 120,000.00
41
OPERATIONAL STAFF2 50,000.00 100,000.00
42
SECURITY GUARDS & BOUNCERS2 50,000.00 100,000.00
43
BAR TENDER1 50,000.00 50,000.00
44
WAITRESS4 40,000.00 160,000.00
45
CHEFS2 60,000.00 120,000.00
46
CLEANERS2 25,000.00 50,000.00
47
Total: 395,000.00 700,000.00
48
49
Source of Fund100% Equity 97,471,080.57
50
shares @ =N=1 each
51
52
Revenue Model:
53
54
Sales of Drinks:NoBasis of PatronsNo of Patrons
55
Drink Categories:10Bar stools10
56
1Soft Drinks-
Average Selling Price (N)
Average Cost Price (N)
24Lounge chairs24
57
Fanta, Coke, 7UP, Maltina, Sprite, Pepsi…e.tc.
300 Per bottle 12512Cocktail tables24
58
Water200 Per bottle 756Lounge tables/chairs24
59
Total:82
60
2Juice-
61
Cranberry, Pineapple, Apple, Orange…e.tc.
1500 Per pack 500REVENUE MODEL:Periods:
62
Days of the week: or Weekly salesLunchAv. Number of Patrons/CoversDinner/NightAv. Number of Patrons/Covers
63
3Power Drinks-Mondays - Thursdays (Patronage)10%3340%131
64
Power horse, Redbull, Last shot…..e.tc.
1000 Per can 300Fridays & Saturdays (Patronage)15%2590%148
65
Sundays (Patronage)10%840%33
66
4Whiskey-Total:66312
67
Jameson, Jameson (small), Red Label, Back Label, Gold Label, Chives Regal, Chives Extra, Wild Turkey, Jack Daniels….e.tc.20000 Per bottle 15000
68
Days of the week: or Weekly salesLunchCheck Av/Per person averageDinner/NightCheck Av/Per person average
69
5Gin-Mondays - Thursdays (Patronage) 3,500.00 4,000.00
70
Gordons, Bombay Sapphire12500 Per bottle 6500Fridays (Patronage) 3,500.00 20,000.00
71
Saturdays & Sundays (Patronage) 3,500.00 10,000.00
72
6Liquour & Bitters-
73
Baileys, Malibu, Campari, Amaretto, Martin Rose…e.tc.18000 Per bottle 8000
74
Days of the week: or Weekly salesTotal Lunch SalesTotal Dinner Sales
Total Weekly sales
75
7Beer- Mondays - Thursdays (Patronage) 114,800.00 524,800.00 639,600.00
76
Star, Stout, Heineken, Gulder, Origin, Legend, Satzenbrau….et.c.1000 Per bottle 400Fridays (Patronage) 86,100.00 2,952,000.00 3,038,100.00
77
Saturdays & Sundays (Patronage) 28,700.00 328,000.00 356,700.00
78
8Wines- 229,600.00 3,804,800.00 4,034,400.00
79
Carlo rossi (White, Red, Rose), Ara (Rose, White, Rose)….e.tc.4000 Per bottle 1500
80
Other Wines150008000 Years Sales Probabilities
81
 1 80%
82
9Champagne- 2 90%
83
Moet & Candon, Martini Rose, Verve, Elicquot….e.tc.30000 Per bottle 20000 3 100%
84
 4 100%
85
10Cognac- 5 100%
86
Hennessy (VS, VSOP, Black), Remy Martin, Dusse, Martel…e.tc.35000 Per bottle 20000
87
88
11Vodka-
89
Smirnoff Ice, Skyy, Absolut,Citreon….e.tc.18000 Per bottle 10000
90
Other Vodkas2500012000COST MODEL:Periods:
91
Days of the week: or Weekly salesLunchAv. Number of Patrons/CoversDinner/NightAv. Number of Patrons/Covers
92
12Rum & Tequila-20000 Per bottle 10000Mondays - Thursdays (Patronage)10%3340%131
93
Fridays & Saturdays (Patronage)15%2590%148
94
Sundays (Patronage)10%840%33
95
Sale of Foods:Total:66312
96
Food & Other platters ….e.tc1500 Per person 750
97
Days of the week: or Weekly salesLunch Av COS person averageDinner/NightAv COS person average
98
 Av. Selling Price Co-efficient 10.0%Mondays - Thursdays (Patronage) 1,500.00 2,000.00
99
Fridays (Patronage) 1,500.00 10,000.00
100
Number of Opening weeks in a year
43Saturdays & Sundays (Patronage) 1,500.00 5,000.00