Download - Updated Food Court Budget - 20042010
CHANDIGARHOPERATING EXPENSE Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09
H.Keeping - Common Area (Ext.) 1.20 0.96 0.94 0.94 0.94 0.93 Pest Control Services 0.05 0.05 0.05 0.05 0.05 0.05 Personnel Cost- Team Members 0.30 0.29 0.30 0.34 0.36 0.27 Repair & Maint(Buil) - - - - - - Repair & Maint(Mach)- Others 0.02 0.06 0.00 0.01 0.18 0.02 Insurance Expense 0.01 0.01 0.01 0.01 0.01 0.01 Printing and stationery 0.01 0.00 0.01 0.01 0.01 0.02 Communication Exp.Telep 0.02 0.01 0.02 0.02 0.02 0.02 Disposable Glasses 0.10 0.21 0.18 0.16 0.22 0.07 Commission for Tenners 0.02 0.02 0.02 0.04 0.02 0.02 General Charges 0.10 0.10 0.10 0.10 0.10 0.13 TOTAL 1.81 1.71 1.63 1.67 1.90 1.53
SAKETOPERATING EXPENSE Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09
H.Keeping - Common Area (Ext.) 1.20 1.30 1.30 1.30 1.30 1.30 Pest Control Services 0.08 0.08 0.08 0.08 0.08 0.08 Personnel Cost- Team Members 0.63 0.63 0.64 0.64 0.61 0.54 Repair & Maint(Buil) 0.34 0.34 0.34 0.34 0.34 0.34 Repair & Maint(Mach)- Others 0.05 - 0.09 0.10 0.12 0.02 Insurance Expense 0.02 0.02 0.02 0.02 0.02 0.02 Printing and stationery 0.06 0.03 0.04 - - - Communication Exp.Telep 0.05 0.06 0.06 0.02 - 0.06 Disposable Glasses 0.02 0.11 0.44 0.37 0.24 0.28 Commission for Tenners 0.08 0.08 0.10 0.10 0.12 0.10 General Charges 0.07 0.07 0.07 0.07 0.07 0.07 Stamp Duty paid
2.59 2.73 3.18 3.06 2.91 2.82
PROMENADEOPERATING EXPENSE Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09
H.Keeping - Common Area (Ext.) 1.20 1.30 1.27 1.08 1.26 1.30 Pest Control Services 0.07 0.07 0.07 0.07 0.03 0.03 Personnel Cost- Team Members 0.69 0.49 0.49 0.58 0.56 0.45 Repair & Maint(Buil) 0.34 0.34 0.34 0.34 0.34 0.61 Repair & Maint(Mach)- Others - - - - - - Insurance Expense 0.03 0.03 0.03 0.03 0.03 0.03 Printing and stationery - 0.01 0.02 - 0.05 0.11 Communication Exp.Telep 0.04 0.03 0.03 - 0.04 0.03 Disposable Glasses 0.12 0.02 - 0.06 0.11 - Commission for Tenners 0.04 0.03 0.04 0.06 0.05 0.07 General Charges 0.13 0.13 0.13 0.13 0.13 0.13 Stamp Duty paid
2.66 2.46 2.43 2.35 2.60 2.76
SHALIMAR BAGHOPERATING EXPENSE Apr-09 May-09 Jun-09 Jul-09 Aug-09 Sep-09
H.Keeping - Common Area (Ext.) 0.95 0.95 0.92 0.92 0.92 0.92 Pest Control Services 0.05 0.05 0.05 0.05 0.05 0.05 Personnel Cost- Team Members 0.24 0.22 0.24 0.19 0.24 0.24 Repair & Maint(Buil) 0.31 0.30 0.30 0.35 0.41 0.40 Repair & Maint(Mach)- Others - - 0.02 - 0.04 0.07 Insurance Expense - - - - - - Printing and stationery - - - - 0.01 0.00 Communication Exp.Telep 0.02 0.01 0.04 0.01 0.01 0.00 Disposable Glasses 0.04 0.01 0.04 0.04 0.12 0.04 Commission for Tenners - - 0.02 0.03 0.03 0.03 General Charges 0.05 0.05 0.05 0.05 0.05 0.05
1.65 1.59 1.66 1.63 1.87 1.80
Oct-09 Nov-09 Dec-09 Jan-10 Feb-10 Mar-10 TOTAL
0.93 0.92 0.93 0.92 0.93 0.93 11.46 0.05 0.05 0.04 0.04 0.04 0.04 0.54 0.36 0.30 0.29 0.29 0.43 0.40 3.90 - - - - - - - 0.23 0.07 0.03 0.14 0.00 0.25 1.01 0.01 0.01 0.01 0.01 0.01 0.01 0.10 0.01 - 0.02 0.04 0.01 0.01 0.15 0.02 0.01 0.02 0.02 0.02 0.02 0.21 0.09 0.09 0.15 0.08 0.08 0.18 1.61 0.02 0.01 0.02 0.04 0.02 0.02 0.26 0.11 0.10 0.10 0.13 0.10 0.13 1.31 1.82 1.57 1.59 1.71 1.62 1.97 20.54
Oct-09 Nov-09 Dec-09 Jan-10 Feb-10 Mar-10 TOTAL
1.73 1.77 1.77 1.77 1.77 1.77 18.29 0.08 0.08 0.08 0.08 0.08 0.08 1.01 0.58 0.63 0.63 0.60 0.75 0.65 7.54 0.34 0.05 0.34 0.34 0.33 0.34 3.82 0.11 0.38 0.25 0.20 - 0.16 1.47 0.02 0.02 0.02 0.02 0.02 0.02 0.19 0.14 0.03 0.04 0.16 0.13 0.08 0.71 0.02 0.03 0.02 0.01 0.03 0.03 0.39 0.22 0.07 0.29 0.14 0.32 0.09 2.60 0.10 0.10 0.10 0.12 0.10 0.10 1.20 0.07 0.07 0.07 0.07 0.07 0.13 0.91
3.45 3.45 3.41 3.23 3.63 3.52 3.61 6.91 41.59
Oct-09 Nov-09 Dec-09 Jan-10 Feb-10 Mar-10 TOTAL
1.61 1.61 1.61 1.61 1.61 1.61 17.08 0.04 0.04 0.04 0.04 0.04 0.04 0.54 0.49 0.52 0.52 0.59 0.51 0.60 6.49 0.34 0.34 0.34 0.34 0.34 0.34 4.40 - - - - - - - 0.03 0.03 0.03 0.03 0.03 0.03 0.38 - 0.04 0.09 0.03 0.01 0.10 0.47 0.03 0.03 0.03 0.03 0.03 0.03 0.35 0.06 0.15 0.07 0.17 0.13 0.08 0.98 0.07 0.07 0.10 0.13 0.13 0.12 0.92 0.13 0.13 0.13 0.13 0.13 0.13 1.54
3.62 3.62 2.81 2.97 2.97 3.11 2.96 6.71 36.77
Oct-09 Nov-09 Dec-09 Jan-10 Feb-10 Mar-10 TOTAL
0.92 0.92 0.92 0.92 0.92 0.92 11.08 0.05 0.05 0.05 0.05 0.05 0.05 0.54 0.24 0.24 0.24 0.24 0.22 0.25 2.83 0.30 0.30 0.30 0.30 0.33 0.30 3.89 - 0.17 0.08 0.04 0.07 0.17 0.66 - - - - - - - 0.00 0.03 0.00 0.00 - 0.05 0.10 0.02 0.02 0.02 0.01 0.01 0.02 0.21 - 0.04 0.04 0.08 0.08 - 0.51 0.03 0.06 0.05 0.06 0.06 0.06 0.44 0.05 0.05 0.05 0.05 0.05 0.05 0.55
- - 1.61 1.88 1.75 1.74 1.78 1.87 20.81
LOCATION SHOP No. PARTY NAME BRAND Apr-09
128,407
Promenade FC1 Mc Donalds
Promenade FC2 Dominos Pizza India Ltd. Domino's 30,792
Promenade FC3 Old World Hospitality Pvt. Ltd. Tika Town
Promenade FC4 Aarbee International Subway 15,178 Promenade FC5 Arabian Nites Arabian Nites 15,157 Promenade FC6 Haldiram Marketing Pvt. Ltd. Haldiram 59,584 Promenade FC7 Café Brown Sugar Café Brown Sugar
Promenade FC8 Gourmand Hospitality Pvt. Ltd. Soy Expres
FC9.1 Gourmand Hospitality Pvt. Ltd. Soy Expres
Promenade FC9.2 Lite Bite Foods (P) Ltd. PinoosPromenade K1 LNM Enterprises Baskin Robbins 7,696 Promenade K2A Sushiya Sushiya
Promenade K3 Archana Rai Oh La LaPromenade K4 Lite Bite Foods (P) Ltd. Bakers Street
72,123
FC1 Dominos Pizza India Ltd. Domnos 12,151
FC2 Magic Wok 22,084
FC3 Santinos 23,560
FC4 Moti Mahal -
FC5 Bikanerwala Foods Pvt. Ltd. Bikano
FC6 Bikanerwala Foods Pvt. Ltd. Bikano SI
K3 Kamlesh Gupta Kwality Walls 14,329
Cart 1 Vacant -
Cart 2 Vacant -
153,366
Chandigarh FC1 Dominos Pizza India Ltd. Domino 22,919
Chandigarh FC2 Madras Mail 21,542
Chandigarh FC3 Moti Mahal 21,919
Chandigarh FC4 Gurpreet Chatha Resturants Subway. 18,632
PROMENADE
Connaught Plaza Restaurants Pvt Ltd
SHALIMAR BAGHShalimar BaghShalimar Bagh
Consortium Consumcare Pvt. Ltd.
Shalimar Bagh
Consortium Consumcare Pvt. Ltd.
Shalimar Bagh
South Asian Hoapitality Services Pvt. Ltd.
Shalimar BaghShalimar BaghShalimar BaghShalimar BaghShalimar BaghCHANDIGARH
Red Ginger Hospitality (I) Pvt. Ltd.South Asian Hoapitality Services Pvt. Ltd.
Chandigarh FC5 Mad About China 21,110
Chandigarh FC6 Good & Kind Foods (P) Ltd. Ovenfresh 36,736 Chandigarh K1 King Hospitality Pvt. Ltd. Baskin Robins 10,508 Chandigarh Cart1 Gurpreet Chatha Resturants Tamerine LeafChandigarh Cart2
280,688
Courtyard FC1 Mc Donald 23,333
Courtyard FC2 Sanah Creations Pvt. Ltd. Kobe SizzlersCourtyard FC3 Dominos Pizza India Ltd. Dominos 31,289
Courtyard FC4 Old World Hospitality Pvt. Ltd. Tikka Twn 29,514
Courtyard FC5 Old World Hospitality Pvt. Ltd. Orient8 28,984
Courtyard FC6 Vacant - Courtyard FC7 Aarbee International Subwey 19,840 Courtyard FC8 Archana Rai Ooh La La - Courtyard FC9 Café Brown Sugar Brown Sugar - Courtyard FC10 Lite Bite Foods (P) Ltd. Pinos 29,177 Courtyard FC11 LNM Enterprises Baskin Robbin 12,076 Courtyard FC12 Haldiram Marketing Pvt. Ltd. Haldirams 54,534 Courtyard FC13 Lite Bite Foods (P) Ltd. Baker Street 29,350 Courtyard SKF 1 Kool Kidz Products Ltd. Kool Kidz 17,211 Courtyard Cart 1 Susvik Food India Pvt. Ltd. Donut Master 5,378 Courtyard Cart 2 VacantCourtyard Cart 3 VacantCourtyard Cart 4 Vacant
10,054 Courtyard Unit 1 H&B Stores Ltd. Dabur 3,027 Courtyard Unit 2 H&B Stores Ltd. Dabur 2,259 Courtyard Unit 3 H&B Stores Ltd. Dabur 4,768 Courtyard Unit 4 Kimkrafts pvt. Ltd Kim's - Courtyard Unit 5 Vacant - - Courtyard Unit 6 Goldy's Nestt New Goldy's Nest - Courtyard Unit 7 Vacant - - Courtyard Unit 8 Carry-on Fashion Stores Closed on 17.05.09 - Courtyard Unit 9 Afsana - -
Red Ginger Hospitality (I) Pvt. Ltd.
COURTYARD
Connaught Plaza Restaurants Pvt Ltd
TEMP LEASE
May-09 Jun-09 Jul-09 Aug-09 Sep'09 Oct'09 Nov'09
128,407 128,407 201,496 269,713 330,682 332,463 332,462
38,333 50,000 50,000 50,000 50,000
30,792 30,792 30,792 30,792 30,792 30,792 30,792
30,077 31,080 31,080 31,080 31,080
15,178 15,178 15,178 15,178 15,178 15,178 15,178 15,157 15,157 15,157 15,157 15,157 15,157 15,157 59,584 59,584 59,584 59,584 59,584 59,584 59,584
24,293 31,378 31,378 31,378
24,012 24,012 24,012
21,070 21,070 21,070
10,687 19,487 19,487 19,487 7,696 7,696 7,696 7,696 7,696 7,696 7,696
1,781 1,781
3,728 10,505 10,505 10,505 10,505 951 14,742 14,742 14,742 14,742
86,010 86,010 86,010 86,010 89,676 81,681 81,681
26,037 26,037 26,037 26,037 26,037 26,037 26,037
22,084 22,084 22,084 22,084 22,084 22,084 22,084
23,560 23,560 23,560 23,560 23,560 23,560 23,560
3,667 10,000 10,000
14,329 14,329 14,329 14,329 14,329
153,366 153,366 153,366 155,764 157,279 157,279 157,279
22,919 22,919 22,919 22,919 22,919 22,919 22,919
21,542 21,542 21,542 21,542 21,542 21,542 21,542
21,919 21,919 21,919 21,919 21,919 21,919 21,919
18,632 18,632 18,632 18,632 18,632 18,632 18,632
21,110 21,110 21,110 21,110 21,110 21,110 21,110
36,736 36,736 36,736 36,736 36,736 36,736 36,736 10,508 10,508 10,508 10,508 10,508 10,508 10,508
2,398 3,913 3,913 3,913
308,065 318,355 366,109 378,446 378,446 378,446 378,446
50,000 50,000 50,000 50,000 50,000 50,000 50,000
20,166 28,416 28,416 28,416 28,416 31,289 31,289 31,289 31,289 31,289 31,289 31,289
29,514 29,514 29,514 29,514 29,514 29,514 29,514
28,984 28,984 28,984 28,984 28,984 28,984 28,984
- - 19,840 19,840 19,840 19,840 19,840 19,840 19,840 710 11,000 11,000 11,000 11,000 11,000 11,000 - - 27,588 31,675 31,675 31,675 31,675 29,177 29,177 29,177 29,177 29,177 29,177 29,177 12,076 12,076 12,076 12,076 12,076 12,076 12,076 54,534 54,534 54,534 54,534 54,534 54,534 54,534 29,350 29,350 29,350 29,350 29,350 29,350 29,350 17,211 17,211 17,211 17,211 17,211 17,211 17,211 5,378 5,378 5,378 5,378 5,378 5,378 5,378
17,740 16,716 16,716 16,716 16,716 9,187 9,187 2,913 2,913 2,913 2,913 2,913 2,913 2,913 2,016 2,016 2,016 2,016 2,016 2,016 2,016 4,258 4,258 4,258 4,258 4,258 4,258 4,258 - - - - - - - 4,129 7,529 7,529 7,529 7,529 - - - 4,424 - - - - -
TOTAL
AS PER RAMCO
PROVISON 267,279
Temp Lease
Dec'09 Jan'10 Feb-10 Mar-10 TOTAL
332,462 332,462 332,462 332,462 3,181,885 3,181,885.00 (0.01)
50,000 50,000 50,000 50,000 438,333 30,792 30,792 30,792 30,792 369,508
31,080 31,080 31,080 31,080 278,714 15,178 15,178 15,178 15,178 182,139 15,157 15,157 15,157 15,157 181,878 59,584 59,584 59,584 59,584 715,008 31,378 31,378 31,378 31,378 243,938
24,012 24,012 24,012 24,012 168,086
21,070 21,070 21,070 21,070 147,490 19,487 19,487 14,742 19,487 142,352 7,696 7,696 7,696 7,696 92,352 1,781 1,781 1,781 1,781 10,684
- 10,505 10,505 10,505 10,505 87,770 14,742 14,742 19,487 14,742 123,633
58,123 36,037 36,037 36,037 835,436 835436 0.10
26,037 26,037 26,037 26,037 298,559
10,686 187,359
11,400 199,879 10,000 10,000 10,000 10,000 63,667
-
-
85,972
-
-
157,279 157,279 157,279 157,279 1,870,181 1870181 (0.41) 22,919 22,919 22,919 22,919 275,032
21,542 21,542 21,542 21,542 258,500
21,919 21,919 21,919 21,919 263,029 18,632 18,632 18,632 18,632 223,587
21,110 21,110 21,110 21,110 253,315 36,736 36,736 36,736 36,736 440,834 10,508 10,508 10,508 10,508 126,095 3,913 3,913 3,913 3,913 29,789
-
378,446 367,446 367,446 367,446 4,267,787 4267787 (0.20)
50,000 50,000 50,000 50,000 573,333 -
28,416 28,416 28,416 28,416 247,493 31,289 31,289 31,289 31,289 375,471
29,514 29,514 29,514 29,514 354,173
28,984 28,984 28,984 28,984 347,810 -
19,840 19,840 19,840 19,840 238,086 11,000 77,710 31,675 31,675 31,675 31,675 280,990 29,177 29,177 29,177 29,177 350,123 12,076 12,076 12,076 12,076 144,910 54,534 54,534 54,534 54,534 654,411 29,350 29,350 29,350 29,350 352,205 17,211 17,211 17,211 17,211 206,531 5,378 5,378 5,378 5,378 64,541
- - -
13,930 - - - 126,963 126964.39 1.69 4,494 27,912 3,597 19,968 5,839 40,413
- - 34,246 - 4,424 -
10,282,252
10,282,254 1
- (1)
Profit & Loss Account Statement: Shalimar Bagh Food Court
Apr-10 May-10 Jun-10
LEASINGIncome 3.78 4.95 5.24
Rental Income(h) 2.79 3.69 3.69Rental Income( Aditional Tenancy)(i) 0.10 0.10 0.10Total Rental Income(j=i+h) 2.89 3.79 3.79Signage Income 0.00 0.20 0.45Marketing & BTL 0.10 0.17 0.21
0.79 0.79 0.79
Expenses 4.8 5.0 5.0Operating Cost 4.0 4.1 4.1Marketing Expense 0.0 0.1 0.1
Ground Rent & Property Tax 0.8 0.8 0.8Overheads
Gross Margin - EBITDA ('c) -1 0 0
EBITDA % {('c)/(a) } -27% 0% 4%
Profit & Loss Account Statement: Retail-Maintenance
Profit & Loss Account(Rs Lacs)
Ground Rent & Property Tax Recovery
Profit & Loss Account(Rs Lacs)
Apr-10 May-10 Jun-10
MAINTENANCE (ONLY CAM)Maintenance Income 0.4 0.8 0.8
Maintenance Expenses 3.27 3.27 3.27
Gross Margin - EBITDA ('c) (3) (3) (3)
EBITDA % {('c)/(a) } -695% -330% -330%
TOTAL FOODCOURT INCOME (d) (4) (3) (2)
TOTAL FOODCOURT INCOME /SFT 31 42 42
Rent to Mall(e) 7.9 7.9 7.9 Depreciation(f) 2.2 2.2 2.2
NET FOODCOURT INCOME(g=d-(e+f))NET FOODCOURT INCOME/SFT
Note:- Pls include Water charges under operating cost & have a detailed breakup of the operating cost.
Profit & Loss Account(Rs Lacs)
Profit & Loss Account Statement: Shalimar Bagh Food Court
Q1 Jul-10 Aug-10 Sep-10 Q2 Oct-10 Nov-10 Dec-10
13.96 5.50 5.55 5.55 16.60 5.55 5.55 5.7410.17 3.56 3.56 3.56 10.67 3.56 3.56 3.740.30 0.10 0.10 0.10 0.30 0.10 0.10 0.10
10.47 3.66 3.66 3.66 10.97 3.66 3.66 3.840.65 0.85 0.90 0.90 2.65 0.90 0.90 0.900.47 0.21 0.21 0.21 0.62 0.21 0.21 0.21
2.37 0.79 0.79 0.79 2.37 0.79 0.79 0.79
14.8 4.9 5.0 4.9 14.8 4.7 4.6 4.112.2 4.1 4.1 4.0 12.1 3.8 3.7 3.2
0.2 0.1 0.1 0.1 0.3 0.1 0.1 0.12.4 0.8 0.8 0.8 2.4 0.8 0.8 0.80.0 0.0
-1 1 1 1 2 1 1 2
-6% 10% 10% 13% 11% 15% 17% 29%
Q1 Jul-10 Aug-10 Sep-10 Q2 Oct-10 Nov-10 Dec-10
1.9 0.8 0.8 0.8 2 0.8 0.8 0.8 9.8 3.27 3.27 3.27 9.8 3.27 3.27 3.27
(7.88) (3) (3) (3) (7.53) (3) (3) (3)
-407% -330% -330% -330% -330% -330% -330% -330%
(9) (2) (2) (2) (6) (2) (2) (1)
41 41 41 40 40 39
23.7 7.9 7.9 7.9 23.7 7.9 7.9 7.9 6.5 2.2 2.2 2.2 6.5 2.2 2.2 2.2
Note:- Pls include Water charges under operating cost & have a detailed breakup of the operating cost.
Q3 Jan-11 Feb-11 Mar-11 Q4
16.84 5.74 5.60 5.60 16.94 64.33 30.28910.85 3.74 3.61 3.61 10.95 42.64 25.580.30 0.10 0.10 0.10 0.30 1.20 1.05
11.15 3.84 3.71 3.71 11.25 43.84 26.632.70 0.90 0.90 0.90 2.70 8.70 0.000.62 0.21 0.21 0.21 0.62 2.32 0.00
2.37 0.79 0.79 0.79 2.37 9.48 3.66
13.4 4.0 3.9 4.3 12.1 55.1 26.710.7 3.1 3.0 3.4 9.5 44.6 20.81
0.3 0.1 0.1 0.1 0.3 1.1 0.02.4 0.8 0.8 0.8 2.4 9.5 5.860.0 0.0 0.0
3 2 2 1 5 9 4
20% 31% 31% 24% 28% 14% 12%
Total- 2010/11
(a)
Actual 09-10 (b)
Q3 Jan-11 Feb-11 Mar-11 Q4
2 0.8 0.8 0.8 2 9 8.359.8 3.27 3.27 3.27 9.8 39.26 29.19
(7.53) (3) (3) (3) (7.53) (30) (21)
-330% -330% -330% -330% -330% -347% -249%
(4) (1) (1) (1) (3) (21) (17)
39 37 39
23.7 7.9 7.9 7.9 23.7 95 26 6.5 2.2 2.2 2.2 6.5 26.0
Total- 2010/11
(a)
2009/10 YTD+Forecast
(b)
Rs lacs
34.0417.060.15
17.218.702.32
5.82
28.523.741.103.62
6
16%
Variance (c=a-b)
0.4310.08
(10)
-2237%
(4)
69.4026.00
Variance (c=a-b)
Marketing & BTL Income
S.No Location Rental
1 Food Court-entrance Gaming zone 10000 100002 Food Court Astrolozy 4500 03 Food Court Helium Baloons 20004 Food Court Candy Cart 4000 0
0
Total 10000
Marketing Expenses
S.No Location Expenses April-10
1 Food Court0
Total 0
Apr 10 Rental
Live Music / tatoo Artist / Magician
Sep 10 Rental Nov 10 Rental Dec 10 Rental
10000 10000 10000 10000 10000 10000 10000 100004500 4500 4500 4500 4500 4500 4500 45002000 2000 2000 2000 2000 2000 2000 2000
0 4000 4000 4000 4000 4000 4000 40000 0 0 0 0 0 0 0
16500 20500 20500 20500 20500 20500 20500 20500
May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10
10000 10000 10000 10000 10000 10000 10000 10000
10000 10000 10000 10000 10000 10000 10000 10000
May 10 Rental
June 10 Rental
Jul 10 Rental
Aug 10 Rental
Oct 10 Rental
Total
10000 10000 10000 1200004500 4500 4500 495002000 2000 2000 220004000 4000 4000 40000
0 0 0 0
20500 20500 20500 231500
Jan-10 Feb-10 Mar-10 Total
10000 10000 10000 110000
10000 10000 10000 110000
Jan 11 Rental
Feb 11 Rental
Mar 11 Rental
PROFITABILITY STATEMENT OF SHALIMAR BAGH FOOD COURTRs. in Lacs
Particulars Apr/10 May/10 Jun/10 Jul/10 Aug/10 Sep/10 Oct/10 Nov/10 Dec/10 Jan/11 Feb/11 Mar/11 TotalRental Income (MG) 2.8 3.7 3.7 3.6 3.6 3.6 3.6 3.6 3.7 3.7 3.6 3.6 42.6 CAM Recovery 0.4 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 8.8 Ground Rent & Property tax 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 9.5 Signage Revenue 0.0 Electricty Recovery 0.9 1.4 1.5 1.4 1.5 1.4 1.3 1.2 0.9 0.8 0.8 1.0 14.1
TOTAL INCOME 4.9 6.7 6.7 6.5 6.6 6.5 6.4 6.3 6.2 6.1 5.9 6.2 75.0
Fair Rental 7.9 7.9 7.9 7.9 7.9 7.9 7.9 7.9 7.9 7.9 7.9 7.9 95.0 Ground Rent & Property tax 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 9.5 CAM - - - - - - - - - - - - 0.0 Payroll&Resourcing 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 5.7 Electricity 0.0 Operating Exp. 4.0 4.1 4.1 4.1 4.1 4.0 3.8 3.7 3.2 3.1 3.0 3.4 44.6 Marketing exp. 0.0
TOTAL OPERATING EXPENSE 13.2 13.3 13.3 13.2 13.3 13.1 13.0 12.9 12.4 12.3 12.2 12.6 154.7
CASH PROFIT (8.3) (6.6) (6.6) (6.7) (6.7) (6.7) (6.6) (6.6) (6.2) (6.1) (6.2) (6.4) (79.7)
Depreciation 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 26.0
NET PROFIT (10.4) (8.7) (8.8) (8.9) (8.9) (8.8) (8.8) (8.7) (8.3) (8.3) (8.4) (8.6) (105.7)
Total Income / Sq. Ft. 31 42 42 41 41 41 40 40 39 39 37 39 39 Operating Exp. / Sq. Ft. 83 84 84 84 84 83 82 81 78 78 77 79 81
EXPECTED SALES COLLECTION
Shop No Particulars Apr/10 May/10 Jun/10 Jul/10 Aug/10 Sep/10 Oct/10 Nov/10 Dec/10 Jan/11 Feb/11 Mar/11 Total
FC1 Dominos 11.00 11.00 11.00 10.00 10.00 10.00 10.00 10.00 11.50 11.50 10.50 10.50 127.00 FC2 Yo China 4.50 4.50 4.00 4.50 4.50 5.00 4.50 5.00 4.50 4.50 4.00 49.50 FC3 Madras Mail 3.50 3.50 3.00 3.50 3.50 4.00 4.00 3.00 3.50 3.50 3.50 38.50 FC4 Moti Mahal 3.50 3.50 3.50 3.25 3.25 3.25 3.25 3.25 3.50 3.50 3.25 3.25 40.25 FC5 Bikano 3.00 3.00 3.00 2.75 2.75 2.75 2.50 2.50 3.00 3.00 2.50 2.50 33.25 FC6 Bikano SI 1.50 1.50 1.50 1.25 1.25 1.25 1.00 1.00 1.50 1.50 1.25 1.25 15.75 K3 Gyanis 0.60 0.60 0.40 0.50 0.60 0.70 0.60 0.80 0.60 0.60 0.60 6.60
TOTAL 19.00 27.60 27.60 24.65 25.75 25.85 26.45 25.85 28.30 28.10 26.10 25.60 310.85
FOOD COURT RENTAL INCOME
Shop No Particulars Apr/10 May/10 Jun/10 Jul/10 Aug/10 Sep/10 Oct/10 Nov/10 Dec/10 Jan/11 Feb/11 Mar/11 Total
10% Dominos 1.10 1.10 1.10 1.00 1.00 1.00 1.00 1.00 1.15 1.15 1.05 1.05 12.70 fixed Yo China 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 3.30 fixed Amritsari Express 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 5.50 14% Moti Mahal 0.49 0.49 0.49 0.46 0.46 0.46 0.46 0.46 0.49 0.49 0.46 0.46 5.64
12.00% Bikano 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 7.68 12.00% Bikano SI 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 6.72 fixed Gyanis 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 1.10
TOTAL 2.79 3.69 3.69 3.56 3.56 3.56 3.56 3.56 3.74 3.74 3.61 3.61 42.64
CAM Recovery (Assuming CAM is Rs. 23.89 per sq.ft) 15829 20.67 327185
Shop No Particulars Apr/10 May/10 Jun/10 Jul/10 Aug/10 Sep/10 Oct/10 Nov/10 Dec/10 Jan/11 Feb/11 Mar/11 Total Area FC1 Dominos 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 1.66 667.62 FC2 Made About China 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 1.29 566.26 FC3 Madras Mail 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 0.12 1.37 604.10 566FC4 Moti Mahal 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 1.55 624.38 FC5 Bikano 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.08 0.93 373.92 775350FC6 Bikano SI 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.07 0.81 326.14 K3 Gyanis 0.11 0.11 0.11 0.11 0.11 0.11 0.11 0.11 0.11 0.11 0.11 1.18 367.40
TOTAL 0.41 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 8.79
PAYROLLParticulars Apr/10 May/10 Jun/10 Jul/10 Aug/10 Sep/10 Oct/10 Nov/10 Dec/10 Jan/11 Feb/11 Mar/11 Total
Shift Manager (2) 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 2.88 Cashier (4) 0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.23 2.78
TOTAL 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 5.66
OPERATING EXP.Particulars Apr/10 May/10 Jun/10 Jul/10 Aug/10 Sep/10 Oct/10 Nov/10 Dec/10 Jan/11 Feb/11 Mar/11 Total
Housekeeping 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 11.04 Security Charges - - - - - - - - - - - - - Electrical Contrator 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 3.60 Pest Control 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.60 Printing & Stationary 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.60 Repair & Maintenance 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 1.20 AMC - Shawman 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.28 Insurance Cost 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.08 Telephone charges 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.30 Commission for tenners 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.60 Legal & professional 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.25 Electricty Charges(@Rs. 7.5/un 2.32 2.38 2.42 2.36 2.43 2.27 2.15 2.01 1.50 1.40 1.28 1.69 24.21 Water ChargesMisc. 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 1.80
TOTAL 4.02 4.08 4.12 4.06 4.13 3.97 3.85 3.71 3.20 3.10 2.98 3.39 44.56
Assumptions
1 Revenue rental income is being assumed based on pure MG basis.
2 There shall be no Electricity cost as the recovery of Electricity income from Kiosk operator will be set-off with the expense.
3 CAM expense rate shall be Rs. 16.25/- p.s.f. per month charged by DSL on cost-to-cost basis.
4 Ground Rent & Property tax expense will be charged by Mall owning company @ Rs.5.72/- p.s.f. per month.
Profit & Loss Account Statement: Saket Food Court
LEASINGIncome 64.33
Rental Income(h) 42.64Rental Income( Aditional Tenancy)(i) 1.20Total Rental Income(j=i+h) 43.84Signage Income 8.70Marketing & BTL 2.32
9.48
Expenses 55.1Operating Cost 44.6Marketing Expense 1.1
Ground Rent & Property Tax 9.5Overheads 0.0
Gross Margin - EBITDA ('c) 9
EBITDA % {('c)/(a) } 14%
Profit & Loss Account Statement: Retail-Maintenance
Profit & Loss Account(Rs Lacs) Budget 2010/11
(a)
Ground Rent & Property Tax Recovery
Profit & Loss Account(Rs Lacs) Total- 2010/11
(a)
MAINTENANCE (ONLY CAM)Maintenance Income 9
Maintenance Expenses
Gross Margin - EBITDA ('c) 9
EBITDA % {('c)/(a) } 100%
TOTAL FOODCOURT INCOME(d) 18
TOTAL FOODCOURT INCOME/SFT
Rent to Mall(e) 95 Depreciation(f) 26
NET FOODCOURT INCOME(g=d-(e+f))NET FOODCOURT INCOME/SFT
Profit & Loss Account Statement: Saket Food Court Rs lacs
3.63 43.370.17 42.470.30 0.900.47 43.37
3.16
55.2 0.049.4
5.9
-52 43
-1422% 100%
Profit & Loss Account Statement: Retail-Maintenance
Actual - Best 4 months * 3 (Dec09- Mar10)
(b)
Variance (c=a-b)
2009/10 YTD+Forecast
(b)Variance
(c=a-b)
- -
#DIV/0! #DIV/0!
(52) 43
Apr-09 May-09 Jun-09 Jul-09 Aug-09X521036 Common Pool/ Int 1,305,273 1,305,273 1,305,273 1,305,273 1,305,273
Chandigarh 173,471 173,471 173,471 173,471 173,471 Saket 461,158 461,158 461,158 461,158 461,158 Vasant Kunj 439,910 439,910 439,910 439,910 439,910 Shalimar Bagh 230,734 230,734 230,734 230,734 230,734
Sep-09 Oct-09 Nov-09 Dec-09 Jan-10 Feb-10 Mar-10 TOTAL 1,305,379 1,305,378 1,348,908 1,331,757 1,331,757 1,331,760 1,331,759 15,813,063 173,471 173,471 173,471 173,470 173,468 173,468 173,471 2,081,644 461,157 461,157 461,157 461,155 461,157 461,157 461,157 5,533,886 439,910 439,910 439,910 439,909 439,910 439,910 439,910 5,278,920 230,841 230,840 274,370 257,223 257,222 257,225 257,221 2,918,612
LOCATION SHOP NO. PARTY NAME BRAND Apr-09TOTAL PROMENADE 274,840
Shalimar Bagh FC1 Dominos Pizza India Ltd. Domnos 17,982
Shalimar Bagh FC2 Consortium Consumercare Pvt. Ltd. Magic Wok 13,030
Shalimar Bagh FC3 Consortium Consumercare Pvt. Ltd. Santinos 24,872
Shalimar Bagh FC4 Moti Mahal
Shalimar Bagh FC5 Bikanerwala Foods Pvt. Ltd. Bikano 22,163
Shalimar Bagh FC6 Bikanerwala Foods Pvt. Ltd. Bikano SI 10,561
Shalimar Bagh K3 Kamlesh Gupta Kwality Walls 7,369
Shalimar Bagh FC2 Yo China 0.30
Shalimar Bagh FC3 Amritsari Exp[ress 0.50
Shalimar Bagh K3 Gyanis 0.10
TOTAL SHALIMAR BAGH 95,977
TOTAL FOOD COURT 1,426,575
Shalimar Bagh Fun Rides Fund Rides
South Asian Hoapitality Services Pvt. Ltd.
Open Place
May-09 Jun-09 Jul-09 Aug-09 Sep'09 Oct'09 404,458 369,579 731,531 955,623 1,147,807 1,450,925
64,904 65,978 76,871 81,054 67,762 80,453
14,000 13,243 16,867 18,966 13,495 100,000
18,879 19,814 25,138 25,846 16,510 125,000
12,282 34,807
21,461 18,568 19,239 19,409 14,615 27,482
19,742 23,357 18,919 30,700 16,627 5,758
9,555 9,863 7,715 8,461 4,840 0.30 0.30 0.30 0.30 0.30 0.30
0.50 0.50 0.50 0.50 0.50 0.50
0.10 0.10 0.10 0.10 0.10 0.10
148,541 150,823 164,749 184,436 146,131 373,500
2,045,736 2,189,482
AS PER RAMCO
Diff.
7,500 17,500 20,000
Nov'09 Dec'09 Jan'10 Feb'10 Mar'10 TOTAL 1,500,197 1,587,420 1,656,318 1,547,028 1,619,358 13,245,085
-
94,456 127,190 98,300 75,000 75,767 925,717
100,000 100,000 389,601
125,000 125,000 506,059
44,158 43,667 35,887 27,082 26,128 224,011
30,379 30,379 30,379 21,059 17,047 272,180
15,517 15,517 15,517 10,528 9,537 192,280
47,803 0.30 0.30 0.30 0.30 0.30
3.60 0.50 0.50 0.50 0.50 0.50
6.00
0.10 0.10 0.10 0.10 0.10 1.20
409,510 441,753 180,083 133,669 128,479 2,557,651
4,320,042 40,977,500
Ramco 41,684,182 706,682
20,000 10,000 15,000 15,000 105,000
Best 4 Avg. Income###
100,100
###
###
39,630
29,655
14,270
0.30
0.50
0.10 183,655
183,655
16,875
PROFITABILITY STATEMENT OF SHALIMAR BAGH FOOD COURTRs. in Lacs
Particulars Apr/09 May/09 Jun/09 Jul/09 Aug/09 Sep/09 Oct/09 Nov/09 Dec/09 Jan/10 Feb/10 Mar/10 TotalRental Income (MG) 1.0 1.4 2.2 2.4 2.4 2.4 4.9 4.9 5.2 5.1 4.9 4.9 41.8 CAM Recovery 0.8 0.8 0.8 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 11.3
TOTAL INCOME 1.7 2.2 3.0 3.4 3.4 3.4 5.9 5.9 6.2 6.1 5.9 5.9 53.1
Fair Rental 7.8 7.8 7.8 7.8 7.8 7.8 7.8 7.8 7.8 7.8 7.8 7.8 93.0 CAM 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 26.6 Payroll&Resourcing 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.2 2.9 Operating Exp. 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 20.0
TOTAL OPERATING EXPENSE 11.9 11.9 11.9 11.9 11.9 11.9 11.9 11.9 11.9 11.9 11.9 11.9 142.5
CASH PROFIT (10.2) (9.7) (8.9) (8.5) (8.5) (8.5) (5.9) (5.9) (5.7) (5.8) (5.9) (5.9) (89.5)
Depreciation 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4 2.4 28.8
NET PROFIT (12.6) (12.1) (11.3) (10.9) (10.9) (10.9) (8.3) (8.3) (8.1) (8.2) (8.3) (8.3) (118.3)
Total Income / Sq. Ft. 15 19 26 29 29 29 51 51 53 52 51 51 38 Operating Exp. / Sq. Ft. 102 102 102 101 101 101 101 101 101 101 101 101 101
EXPECTED SALES COLLECTION
Shop No Particulars Apr/09 May/09 Jun/09 Jul/09 Aug/09 Sep/09 Oct/09 Nov/09 Dec/09 Jan/10 Feb/10 Mar/10 Total
FC1 Dominos 2.09 3.00 5.00 4.00 4.00 4.00 4.00 4.00 5.00 4.00 4.00 4.00 47.09 FC2 Magic Wok 1.04 1.50 2.00 1.50 1.50 1.50 1.50 1.50 2.00 2.00 1.50 1.50 19.04 FC3 Santinos 2.01 2.50 3.00 2.50 2.50 2.50 2.50 2.50 3.00 3.00 2.50 2.50 31.01 FC4 Moti Mahal 4.00 4.00 4.00 4.00 4.00 5.00 4.00 4.00 4.00 37.00 FC5 Bikano 1.98 3.00 3.00 2.50 2.50 2.50 2.50 2.50 3.00 3.00 2.50 2.50 31.48
FC6 Bikano SI 0.94 2.00 2.00 1.50 1.50 1.50 1.50 1.50 2.00 2.00 1.50 1.50 19.44 K3 Kwality Walls 0.46 0.75 0.75 0.50 0.50 0.50 0.50 0.50 0.75 0.75 0.50 0.50 6.96
TOTAL 8.52 12.75 15.75 16.50 16.50 16.50 16.50 16.50 20.75 18.75 16.50 16.50 192.02
FOOD COURT RENTAL INCOME
Shop No Particulars Apr/09 May/09 Jun/09 Jul/09 Aug/09 Sep/09 Oct/09 Nov/09 Dec/09 Jan/10 Feb/10 Mar/10 Total
10% Dominos 0.19 0.27 0.44 0.36 0.36 0.36 0.75 0.75 0.75 0.75 0.75 0.75 6.46 14% Magic Wok 0.13 0.19 0.25 0.19 0.19 0.19 1.00 1.00 1.00 1.00 1.00 1.00 7.12 14% Santinos 0.25 0.31 0.37 0.31 0.31 0.31 1.25 1.25 1.25 1.25 1.25 1.25 9.37 14% Moti Mahal - - - 0.50 0.50 0.50 0.50 0.50 0.62 0.50 0.50 0.50 4.60
12.50% Bikano 0.22 0.33 0.33 0.28 0.28 0.28 0.28 0.28 0.33 0.33 0.28 0.28 3.50 12.50% Bikano SI 0.10 0.22 0.22 0.17 0.17 0.17 0.17 0.17 0.22 0.22 0.17 0.17 2.16
18% Kwality Walls 0.07 0.12 0.12 0.08 0.08 0.08 0.50 0.50 0.50 0.50 0.50 0.50 3.55 Cart 1 Vacant 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 2.50 Cart 2 Vacant 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 2.50
TOTAL 0.96 1.44 2.24 2.38 2.38 2.38 4.94 4.94 5.18 5.05 4.94 4.94 41.77
Avg Contribution Margin 11% 11% 11% 11% 11% 11% 27% 27% 23% 24% 27% 27% 19%
CAM Recovery (Assuming CAM is Rs. 18 per sq.ft)
Shop No Particulars Apr/09 May/09 Jun/09 Jul/09 Aug/09 Sep/09 Oct/09 Nov/09 Dec/09 Jan/10 Feb/10 Mar/10 TotalFC1 Dominos 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 1.68 FC2 Magic Wok 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 2.88 FC3 Santinos 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 2.88 FC4 Moti Mahal - - - 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 2.16 FC5 Bikano - - - - - - - - - - - - - FC6 Bikano SI - - - - - - - - - - - - - K3 Kwality Walls 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 0.14 1.68
TOTAL 0.76 0.76 0.76 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 11.28
PAYROLLParticulars Apr/09 May/09 Jun/09 Jul/09 Aug/09 Sep/09 Oct/09 Nov/09 Dec/09 Jan/10 Feb/10 Mar/10 Total
Shift Manager (2) - - - - - - - - - - - - - Cashier (4) 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 2.88
TOTAL 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 2.88
OPERATING EXP.Particulars Apr/09 May/09 Jun/09 Jul/09 Aug/09 Sep/09 Oct/09 Nov/09 Dec/09 Jan/10 Feb/10 Mar/10 Total
Housekeeping 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 11.40 Security Charges - - - - - - - - - - - - - Electrical Contrator 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 3.60 Pest Control 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.60 Printing & Stationary 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.60 Repair & Maintenance 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 1.20 Insurance Cost 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.62 Bank Charges 0.05 0.05 0.05 0.15 Misc. 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0.15 1.80
TOTAL 1.70 1.70 1.70 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 19.97
RENT METHOD
Fair Rental Value based on Land + Construction CostSuper Area
Saleable Area in sq. ft. (Retail) 256443Land Cost 57.03 2,224 Construction Cost 62.07 2,420 Total Cost 4,644
Total Cost (Rs. In Cr.)
10% Cost (Rs. In Crore) 11.91Rent per month (in Cr.) 0.99 Monthly Rent / sq. ft. 38.70
Area 15507
Monthly Rent 6.00
RENTParticulars Apr/09 May/09 Jun/09 Jul/09 Aug/09 Sep/09 Oct/09 Nov/09 Dec/09 Jan/10 Feb/10 Mar/10 Total
Fair Rent 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 25% of rental collected 0.24 0.36 0.56 0.59 0.59 0.59 1.24 1.24 1.29 1.26 1.24 1.24
RENT FOR FOOD COURT 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 6.00 (Higher of aboove 2)
304.5
22%
Shalimar Bagh Ground Rent for FY 09-10Unique No Property Customer Name Due Amount Received Balance71181 DTC301E#DCC WELLTIME HOUSING & FINANCE PVT LTD 176,784.00 88,392.00 88,392.0071185 DTC301A#DCC NITIN M NAGPAL 168,312.00 84,156.00 84,156.0071186 DTC301B#DCC NITIN M NAGPAL 162,438.00 81,219.00 81,219.0071618 DTC301D#DCC PRIYA PASSI 156,304.00 78,152.00 78,152.0071911 DT301C#DCC SAVINDER GROVER 158,954.00 0.00 158,954.00
Total 822,792.00 331,919.00 490,873.00
Total Property Tax 129,345.00 34,377.00 94,968.00
952,137.00 366,296.00 585,841.00
Property Tac for fy 09-10 - Shalimar Baghunique_no rel_name cust_name Due Received Bal 71181 DTC301E#DCC WELLTIME HOUSING & FINANCE PVT LTD 34,377.00 34,377.00 - 71185 DTC301A#DCC NITIN M NAGPAL 32,729.00 - 32,729.00 71186 DTC301B#DCC NITIN M NAGPAL 31,587.00 - 31,587.00 71618 DTC301D#DCC PRIYA PASSI 15,197.00 - 15,197.00 71911 DT301C#DCC SAVINDER GROVER 15,455.00 - 15,455.00
129,345.00 34,377.00 94,968.00
Signage Backup
Signage Length (ft) (a) Width (ft) (b) QTY Area (ft) (c=a*b)
1 Pillars 7 3 1 21 5000
2 Pillars 7 3 1 21 5000
3 Pillars 7 3 1 21 5000
4 Pillars 7 3 1 21 5000
5 Pillars 7 3 1 21 5000
6 Pillars 7 3 1 21 5000
7 Pillars 7 3 1 21 5000
8 Pillars 7 3 1 21 5000
9 Tables 4 2 75 600 25000
10 Frond Wall Signage 24 6 1 144 15000
Signage Inventory
NoPictures
(Thumbnail)Monthly Amount
11 Floor Graphics 5 3 2 30 10000
Total 942 90000Occupancy
Apr 10 Rental May 10 Rental June 10 Rental Jul 10 Rental Aug 10 Rental Sep 10 Rental Oct 10 Rental
5000 5000 5000 5000 5000 5000
5000 5000 5000 5000 5000 5000
5000 5000 5000 5000 5000 5000
5000 5000 5000 5000 5000 5000
5000 5000 5000
5000 5000 5000 5000
5000 5000 5000 5000
5000 5000 5000 5000
25000 25000 25000 25000
15000 15000 15000 15000 15000
10000 10000 10000 10000 10000
0 20000 45000 85000 90000 90000 900000% 22% 50% 94% 100% 100% 100%
Nov 10 Rental Dec 10 Rental Jan 11 Rental Feb 11 Rental Mar 11 Rental Total
5000 5000 5000 5000 5000 55000
5000 5000 5000 5000 5000 55000
5000 5000 5000 5000 5000 55000
5000 5000 5000 5000 5000 55000
5000 5000 5000 5000 5000 40000
5000 5000 5000 5000 5000 45000
5000 5000 5000 5000 5000 45000
5000 5000 5000 5000 5000 45000
25000 25000 25000 25000 25000 225000
15000 15000 15000 15000 15000 150000
10000 10000 10000 10000 10000 100000
90000 90000 90000 90000 90000 870000100% 100% 100% 100% 100%
Outstanding Status- Retail Malls as on 30th Nov'09
A Rent & CAM Rs Crores
Mall Billing-Nov'09
Emporio 10.24 8.50 (9.14) 9.60 0.60 9.00 32 (0.12) 8.88 1.52 7.36 26 Promenade 7.18 5.67 (3.55) 9.30 0.85 8.45 45 (0.30) 8.15 0.23 7.92 42 Saket 6.90 5.12 (2.07) 9.95 2.30 7.65 45 (0.60) 7.05 0.56 6.49 38 Chandigarh 1.90 1.00 (0.98) 1.92 0.07 1.85 55 - 1.85 0.09 1.76 53 Total 26.22 20.29 (15.74) 30.77 3.82 26.95 40 (1.02) 25.93 2.41 23.52 35
B Ground Rent/Property Tax
Mall Billing-Nov'09
Emporio 3.03 - (0.20) 2.83 0.14 2.69 2.83 Promenade 3.16 - (0.06) 3.10 0.27 2.83 3.10 Saket 0.85 - (0.05) 0.80 0.25 0.55 0.80 Chandigarh - - - - Total 7.04 - (0.31) 6.73 0.66 6.07 - 6.73
C Security Deposits
Mall Billing-Nov'09
Emporio 3.79 0.31 (1.37) 2.73 0.79 1.94 2.73 Promenade 1.79 - (0.97) 0.82 0.15 0.67 0.82 Saket 2.15 0.03 (0.13) 2.05 0.71 1.34 2.05 Chandigarh 0.13 (0.13) - (0.03) 0.03 - Total 7.86 0.34 (2.60) 5.60 1.62 3.98 - 5.60
Grand Total (A+B+C)
Mall Billing-Nov'09
Emporio 17.06 8.81 (10.71) 15.16 1.53 13.63 (0.12) 15.04 Promenade 12.13 5.67 (4.58) 13.22 1.27 11.95 (0.30) 12.92 Saket 9.90 5.15 (2.25) 12.80 3.26 9.54 (0.60) 12.20 Chandigarh 2.03 1.00 (1.11) 1.92 0.04 1.88 - 1.92 Total 41.12 20.63 (18.65) 43.10 6.10 37.00 (1.02) 42.08
Signage outstanding is as under :
Signage Outstanding
MallEmporio 1.85Promenade 2.18Saket 2.74Chandigarh 0.18Total 6.95
Oustanding till Oct'09 end
Collections-Nov'09
Oustanding-till Nov'09 end
Terminated dues included in outstanding
O/s till Nov'09 end Net of Terminated
O/s as No. of Days Billing
(net of terminated)
Book Adj Pending
Projected Oustanding after
pending adjService Tax
DisputedNet Collectible w/o Service tax
O/s as No. of Days Billing
Oustanding till Oct'09 end
Collections-Nov'09
Oustanding-till Nov'09 end
Terminated dues included in outstanding
O/s till Nov'09 end Net of Terminated
O/s as No. of Days Billing
(net of terminated)
Book Adj Pending
Projected Oustanding after
pending adj
Oustanding till Oct'09 end
Collections-Nov'09
Oustanding-till Nov'09 end
Terminated dues included in outstanding
O/s till Nov'09 end Net of Terminated
O/s as No. of Days Billing
(net of terminated)
Book Adj Pending
Projected Oustanding after
pending adj
Oustanding till Oct'09 end
Collections-Nov'09
Oustanding-till Nov'09 end
Terminated dues included in outstanding
O/s till Nov'09 end Net of Terminated
O/s as No. of Days Billing
(net of terminated)
Book Adj Pending
Projected Oustanding after
pending adj
Outstanding As on date