| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||
2 | ||||||||||||||||||||||
3 | Financial model | |||||||||||||||||||||
4 | Russian Hookah Lounge in Dubai | |||||||||||||||||||||
5 | ||||||||||||||||||||||
6 | v | 2.0 | ||||||||||||||||||||
7 | ||||||||||||||||||||||
8 | ||||||||||||||||||||||
9 | ||||||||||||||||||||||
10 | Model input parameters | |||||||||||||||||||||
11 | ||||||||||||||||||||||
12 | I | Main parameters | ||||||||||||||||||||
13 | ||||||||||||||||||||||
14 | 1. | General description | ||||||||||||||||||||
15 | ||||||||||||||||||||||
16 | Changeable cells | 1 | Картинку поменять, тк 150м2 | Draw a different plan, as the area will be larger | ||||||||||||||||||
17 | Unchangeable cells (formulas) | 1 | ||||||||||||||||||||
18 | ||||||||||||||||||||||
19 | ||||||||||||||||||||||
20 | 2. | Temporal parameters | ||||||||||||||||||||
21 | ||||||||||||||||||||||
22 | Model start date | 24/01/25 | ||||||||||||||||||||
23 | Overhaul start date | 01/08/25 | ||||||||||||||||||||
24 | Operating costs start date | 01/12/25 | ||||||||||||||||||||
25 | Start of sales date | 01/12/25 | ||||||||||||||||||||
26 | AED 1 = | 24.14 | rubles | |||||||||||||||||||
27 | ||||||||||||||||||||||
28 | II | Project feasibility indacators and CapEx | ||||||||||||||||||||
29 | ||||||||||||||||||||||
30 | 1. | Project feasibility indacators | ||||||||||||||||||||
31 | ||||||||||||||||||||||
32 | 1.1. | Total floor area (m2), including | 150 | |||||||||||||||||||
33 | Coal burning room, m2 | 4 | ||||||||||||||||||||
34 | Bar counter, m2 | 20 | ||||||||||||||||||||
35 | Storage space, m2 | 10 | ||||||||||||||||||||
36 | Bathroom, m2 | 10 | ||||||||||||||||||||
37 | Hall (seats), m2 | 106 | ||||||||||||||||||||
38 | ||||||||||||||||||||||
39 | 1.2. | Number of seats | 48 | Here it will be recalculated for more, so you don't need not 100 m2, but 150 m2. | ||||||||||||||||||
40 | ||||||||||||||||||||||
41 | ||||||||||||||||||||||
42 | 2. | CapEx | ||||||||||||||||||||
43 | ||||||||||||||||||||||
44 | № | Name | Amount | Price AED apiece | Total, AED | Comment 1 | Comment 2 | |||||||||||||||
45 | 1. | Repair (clean work + design + materials) | 1 | 218,620 | 258,745 | - Finishing m2 = 750 AED - Design, m2 = 150 AED - Materials, 150 m2 = 80 621 AED +20% - risk Or full project for 150 m2 = 500k AED | - https://haifarenov8.ae/understanding-apartment-renovation-costs-in-dubai-a-comprehensive-guide/# (Major renovations may range from AED 1,500 to AED 2,500 per square meter) - https://www.propertyfinder.ae/blog/renovation-companies-in-dubai/ (Home renovations in Dubai from 100 to 1000 dirhams per square foot) | Link to the cost of materials | ||||||||||||||
46 | 2. | Furniture (6 large tables + 6 big sofas + 28 chairs + 5 small tables + 1 small sofa) | 1 | 40,120 | 48,144 | - Large table = 1 000 AED - Big sofa = 1 000 AED - Chair = 300 AED - Small table = 800 AED - Small sofa = 800 AED +20% - risk | Recalculate if the room is larger | |||||||||||||||
47 | 3. | Equipment | 100,252 | |||||||||||||||||||
48 | 3.1. | Hookah making | ||||||||||||||||||||
49 | Hookahs (Hoob) | 25 | 575 | 14,385 | https://севас.рф/kalyany/hoob/hoob-classic/hoob-apex-mini-a-bazovyy-komplekt.html | |||||||||||||||||
50 | Water jar | 25 | 35 | 879 | https://севас.рф/aksessuary-dlya-kalyana/kolby/kolba-craft-prozrachnaya.html | |||||||||||||||||
51 | Bowl (turkish clay) | 20 | 12 | 248 | https://севас.рф/aksessuary-dlya-kalyana/chashi/cosmo-bowl/cosmo-turkish.html | |||||||||||||||||
52 | Bowl (phunnel 1) | 5 | 23 | 114 | https://севас.рф/aksessuary-dlya-kalyana/chashi/art-bar/chasha-art-bar-glaze-phunel-king.html | |||||||||||||||||
53 | Bowl (phunnel 2) | 5 | 27 | 134 | https://севас.рф/aksessuary-dlya-kalyana/chashi/oblako/oblako-basic-s.html | |||||||||||||||||
54 | Bowl (upgrade) | 5 | 13 | 66 | https://севас.рф/aksessuary-dlya-kalyana/chashi/don-bowl/don-bowl-clasic.html | |||||||||||||||||
55 | Bowl (rubber) | 15 | 8 | 124 | https://севас.рф/aksessuary-dlya-kalyana/silikonovaya-chasha-pod-kalaud-chernaya-2.html | |||||||||||||||||
56 | Kaloud lotus | 30 | 12 | 372 | https://севас.рф/aksessuary-dlya-kalyana/kalaud-lotus-2.html | |||||||||||||||||
57 | Winguard | 5 | 46 | 228 | https://севас.рф/aksessuary-dlya-kalyana/kolpaki/vetrovik-alpha-hookah-roll-nardo-grey.html | |||||||||||||||||
58 | WInguard (mesh) | 10 | 8 | 82 | https://севас.рф/aksessuary-dlya-kalyana/setki/zashitnaya-setka-ekran.html | |||||||||||||||||
59 | Electric burner | 5 | 28 | 140 | https://www.amazon.ae/Olsenmark-OMHP2278-Single-Burner-Electric/dp/B07Z6Q3YXJ/ref=sr_1_13?crid=32G3ZD5EIJZKP&dib=eyJ2IjoiMSJ9.k406prSIJJ9L6IH_h4s6ibLjelh9SxXJCc58o9Olylty4AuxOk1rteXxwhbqr6nCIgE3yK-N3sRsVhE_aBnsZcqlNMIYJHMUlnv3WyNl0Cr0L2yaI53JhxvNoCyBRBL6EVsStxU-GWzurptDLV30WeOjd43SwCDxgOTu7tF1snBkLw0cnBiTlz1g4h1s79Y1XKiVDHmoD3JA8l2whn3vzAtZDtiTJnPNgxWPnSmQotmeq_AT21OOv5Eb5k5gB50ogyBISUm8yJrpnE6vXHA-vOgGJ-ogAa9XMZZ1QX_VZTw.wVKj8bf2ZMb1msCem1RmrR4SV0YHSxpWMwEramvVMVM&dib_tag=se&keywords=electric+stove&qid=1732546177&sprefix=electric+stove%2Caps%2C108&sr=8-13 | |||||||||||||||||
60 | Coconut coal | 144 | 1 | 15 | ||||||||||||||||||
61 | Consumables (rubber, jar) | 30 | 2 | 61 | https://севас.рф/aksessuary-dlya-kalyana/black-base-rubber.html | |||||||||||||||||
62 | Consumables (rubber, bowl) | 30 | 1 | 36 | https://севас.рф/aksessuary-dlya-kalyana/uplotnitel-dlya-vneshnej-chashi-1.html | |||||||||||||||||
63 | Tongs | 3 | 6 | 19 | https://севас.рф/aksessuary-dlya-kalyana/shipcy-srednie-20sm-1.html | |||||||||||||||||
64 | Cleaning wipes | 1 | 33 | 33 | https://севас.рф/aksessuary-dlya-kalyana/ershiki/nabor-ershikov-lite.html | |||||||||||||||||
65 | Consumables tube caps | 2,000 | 0 | 500 | ||||||||||||||||||
66 | Consumables foil | 20 | 4 | 80 | ||||||||||||||||||
67 | Disposable tube consumables | 200 | 6 | 1,104 | https://aliexpress.ru/item/1005006741942047.html?sku_id=12000038518416110&spm=a2g2w.productlist.search_results.2.e8186925rYFiJV | |||||||||||||||||
68 | Coal basket | 3 | 25 | 74 | https://севас.рф/aksessuary-dlya-kalyana/srednyaya-korzina-dlya-uglej-1.html | |||||||||||||||||
69 | 3.2. | Other staff | ||||||||||||||||||||
70 | Flow-through system | 1 | 40,000 | 40,000 | ||||||||||||||||||
71 | Table scale | 1 | 40 | 40 | ||||||||||||||||||
72 | Tableware (mugs) | 50 | 10 | 500 | ||||||||||||||||||
73 | Tableware (plates) | 50 | 10 | 500 | ||||||||||||||||||
74 | Tableware (spoon and fork) | 100 | 6 | 600 | ||||||||||||||||||
75 | Fridge | 1 | 359 | 359 | ||||||||||||||||||
76 | Ice machine | 1 | 399 | 399 | ||||||||||||||||||
77 | 3.2. | Coffee production | ||||||||||||||||||||
78 | Coffee machine | 1 | 12,900 | 12,900 | https://alpha-kitchen.com/product/la-cimbali-m23-up-coffee-machine/ | https://lmi.ae/shop/product/la-cimbali-m23up/ | ||||||||||||||||
79 | Direct Grinding Coffee Grinder | 1 | 3,850 | 3,850 | https://alpha-kitchen.com/product/nuova-simonelli-mdx-on-demand-grinder/?removed_item=1# | |||||||||||||||||
80 | Noise-canceling Smoothie Blender | 1 | 2,528 | 2,528 | https://alahliakitchen.ae/product/smoothie-blender-with-sound-proofing-cover/ | |||||||||||||||||
81 | Fridge | 1 | 1,899 | 1,899 | https://alahliakitchen.ae/product/bar-cooler-2-door/ | |||||||||||||||||
82 | Ice machine | 1 | 4,480 | 4,480 | https://alahliakitchen.ae/product/ice-cube-maker/ | |||||||||||||||||
83 | Juicer | 1 | 1,205 | 1,205 | https://alahliakitchen.ae/product/juicer-machine-ytz-001/ | |||||||||||||||||
84 | Kitchen scale | 1 | 257 | 257 | https://www.almenhaz.com/products/timemore-coffee-scale-with-timer-basic-mini-black-new?_pos=3&_sid=dc42d9638&_ss=r | |||||||||||||||||
85 | Dishwasher | 1 | 4,256 | 4,256 | https://alahliakitchen.ae/product/mec-professional-glass-and-dishwashers-with-peristaltic-dosing-pump-t400/ | |||||||||||||||||
86 | Water heater | 1 | 290 | 290 | https://amzn.eu/d/ahzLJ7t | или https://amzn.eu/d/esPR7gH | ||||||||||||||||
87 | Barista's inventory | |||||||||||||||||||||
88 | Coffee temperature in the set | 1 | 55 | 55 | https://www.amazon.ae/Laelr-Organizer-Distributor-Portafilter-Accessories/dp/B0BX2Q5PB6/260-9682429-1562614?pd_rd_w=Fa7ya&content-id=amzn1.sym.be5f36af-1ec3-4ac3-b973-2f55269305bc&pf_rd_p=be5f36af-1ec3-4ac3-b973-2f55269305bc&pf_rd_r=EVVQPDGE3YXHKDEK4HH8&pd_rd_wg=1Epsz&pd_rd_r=3e3957f6-9a94-4420-8924-808160884629&pd_rd_i=B0BX2Q5PB6&th=1 | |||||||||||||||||
89 | The tempering mat | 1 | 15 | 15 | https://www.amazon.ae/SKY-TOUCH-Espresso-Silicone-Non-Slip-Accessories/dp/B097BX2LX5/260-9682429-1562614?pd_rd_w=ixg6J&content-id=amzn1.sym.74bdf13e-4ba8-4754-ba20-3d9e2dd59b71&pf_rd_p=74bdf13e-4ba8-4754-ba20-3d9e2dd59b71&pf_rd_r=EVVQPDGE3YXHKDEK4HH8&pd_rd_wg=1Epsz&pd_rd_r=3e3957f6-9a94-4420-8924-808160884629&pd_rd_i=B097BX2LX5&psc=1 | |||||||||||||||||
90 | Rubber mat for glasses 60cm | 1 | 38 | 38 | https://amzn.eu/d/inm3JKX | |||||||||||||||||
91 | Container for cocktail preparations (fruit slices) | 1 | 68 | 68 | https://amzn.eu/d/1bdOQ72 | |||||||||||||||||
92 | Pitchers, 350 ml | 2 | 22 | 44 | https://amzn.eu/d/8SsXajs | |||||||||||||||||
93 | Pitchers, 600 ml | 2 | 40 | 80 | https://amzn.eu/d/dimEzRZ | |||||||||||||||||
94 | Milk carafe | 2 | 45 | 90 | https://amzn.eu/d/1uwhyJm | |||||||||||||||||
95 | Cocktail set (shaker, jig, bar spoon) | 1 | 56 | 56 | https://amzn.eu/d/hbF4dMZ | |||||||||||||||||
96 | Coffee Grinder Brush | 1 | 38 | 38 | https://amzn.eu/d/5ixEvqh | |||||||||||||||||
97 | Espresso Jiggers | 2 | 36 | 72 | https://amzn.eu/d/4NU9gq2 | |||||||||||||||||
98 | Bar tweezers (3 pcs set) | 1 | 30 | 30 | https://amzn.eu/d/dA3A3fd | |||||||||||||||||
99 | Ice scoop (3 pcs set) | 1 | 31 | 31 | https://amzn.eu/d/84tB421 | |||||||||||||||||
100 | Non-box for the disposal of processed coffee | 1 | 147 | 147 | https://amzn.eu/d/3xThDlw | |||||||||||||||||