shashwat homes sensitivity

8/22/2019 Shashwat Homes Sensitivity

1/44

Annexure - I

Shashwat Homes Pvt. Ltd.

Pheasewise Development

Particulars

Saleable

Area per

Bunglow

(Sq.Yards)

Carpet

Area per

Bunglow

(Sq.Yards)

Phase I 0 0 0

No. of Bunglows

Bunglow Type "A" 120 125 80 71 396Bunglow Type "B" 120 100 40 78 338Bunglow Type "C" (average for odd

size plots)- 15 10 4 29

Bunglow Type "D" - - 35 23 58

240 240 165 176 821Plot Area (Sq.Yards)

Bunglow Type "A" 239 28,680 29,875 19,120 16,969 94,644Bunglow Type "B" 395 47,400 39,500 15,800 30,810 133,510Bunglow Type "C" 275 - 4,125 2,750 1,100 7,975Bunglow Type "D" 1,047 - - 36,645 24,081 60,726

76,080 73,500 74,315 72,960 296,855

Constructed Areas (Sq.Yards)Bunglow Type "A" 250 198 23,760 24,750 15,840 14,058 78,408Bunglow Type "B" 366 290 34,800 29,000 11,600 22,620 98,020Bunglow Type "C" 250 198 - 2,970 1,980 792 5,742Bunglow Type "D" 469 372 - - 13,020 8,556 21,576

58,560 56,720 42,440 46,026 203,746

Commercial Area

Land Area (Sq.Yards) 9,000 9,000 9,000 7,000 34,000

Constructed Area (Sq.Fts.) 150,000 150,000 150,000 100,000 550,000

Say4,500

Selling Price 6,200

Bunglow Type "A" 239 1,075,500250 1,548,406 2,623,906 26.00

Bunglow Type "B" 395 1,777,500366 2,267,868 4,045,368 40.00

Bunglow Type "D" 275 1,237,500250 1,548,406 2,785,906 28.00

Bunglow Type "C" 1,047 4,711,500469 2,909,127 7,620,627 76.00

Note : The no. of units in Phase II to IV will change depending on demand for bunglows with large & small size land area. Final

Planning for Bunglow Type D is yet not finalized.


2/44

(Rs.Crore)

Phase I

Total No. of Bunglows 240Cost of Project

Land 54.00

Site Development 10.00

Common facilities 6.00

Plant & Machinery 4.70

Preliminary & Pre-Operative Expenses 6.51

Provision for Contingencies 2.55

Working Capital Margin 3.49

Total 87.25

Means of Finance

Promoters' ContributionEquity Share Capital 20.00Redeemable Preference Share Capital 10.00

Unsecured Deposits 12.67Internal Cash Accruals -

Term Loan for Phase I 44.58

Total 87.25


Cost of Project & Means of Finance


3/44


Detailed Cost of Project(Rs.Crore)

Particulars Phase I

No. of Bunglows - Type "A" 120

"B" 120

"C" -

"D" -

Commercial Area150,000

Land

Land at Reveue Village Kali & Chainpur, Dist.

Ahmedabad42.10

Add : Stamp Duty & Registration Charges 4.21Statutory Dues (Panchayat & Municipal Dues) 3.28

Land Use Conversion Charges 4.41

54.00

Site Development 10.00

Building (Civil Cost)

Civil Work of Bunglow @ Rs.4,000/- per sq.yard 23.42

Civil Work for Commercial Area @ Rs.500/- per sq.fts. 7.50

Civil Work for Common Facilities 6.00

Architect, Structural Engineer & Other Consultants'

Fees

0.50

37.42

Plant & Machinery

Electrification for Bunglows / BuildingsType "A" @ Rs.75,000/- 0.90

Type "B" @ Rs.1,00,000/- 1.20

Type "C" @ Rs.1,00,000/- -

Type "I" @ Rs.6,00,000/- -

Electrification in Common Areas / Utilities 1.75

Water Treatment Plant & Supply 1.50

Other Common Amenities 0.75

Fire Fighting Equipments 0.20

Health & Sports Club Equipments 0.30

Swimming Pool Filteration Plant 0.20

6.80

Preliminary & Pre-Operative Expenses

Interest during Construction 11.00

Establishment Expenses 0.75

Upfront & Legal Charges 0.50

Power & Other Deposit 0.50Advertising & Marketing Expenses . 0.75

13.50

Provision for Contingencies

Civil Work @ 5% 1.87Plant & Machinery @ 10% 0.68

2.55

Working Capital Margin 0.72

TOTAL 125.00


4/44


(Rs.Crore)

Particulars

Term Loan W.C.

Facility

Land

Land at Reveue Village Kali & Chainpur, Dist. Ahmedabad 42.10 33.68 * -

Add : Stamp Duty & Registration Charges 4.21 3.37 * -

Statutory Dues (Panchayat & Municipal Dues) 3.28 3.28 -Land Use Conversion Charges 4.41 4.41 -

54.00 44.74 -

Site Development 10.00 10.00 -

Building (Civil Cost)

Civil Work of Bunglow @ Rs.4,000/- per sq.yard 23.42 - 23.42Civil Work for Commercial Area @ Rs.500/- per sq.fts. 7.50 - 7.50Civil Work for Common Facilities 6.00 6.00 -

Architect, Structural Engineer & Other Consultants' Fees 0.50 - 0.5037.42 6.00 31.42

Plant & Machinery

Electrification for Bunglows / BuildingsType "A" @ Rs.75,000/- 0.90 - 0.90Type "B" @ Rs.1,00,000/- 1.20 - 1.20Type "C" @ Rs.1,00,000/- - - -Type "I" @ Rs.6,00,000/- - - -Electrification in Common Areas / Utilities 1.75 1.75 -Water Treatment Plant & Supply 1.50 1.50 -Other Common Amenities 0.75 0.75 -Fire Fighting Equipments 0.20 0.20

Health & Sports Club Equipments 0.30 0.30Swimming Pool Filteration Plant 0.20 0.20

6.80 4.70 2.10

Preliminary & Pre-Operative Expenses

Interest during Construction 4.80 4.80 -Establishment Expenses 0.75 0.75 -Upfront & Legal Charges 0.50 0.50 -Power & Other Deposit 0.50 0.50 -Advertising & Marketing Expenses . 0.75 0.75 -

7.30 7.30 -

Provision for Contingencies

Civil Work @ 5% 1.87 1.87Plant & Machinery @ 10% 0.68 0.68

2.55 2.55

Working Capital Margin -

Total 118.08 75.29 33.52

Margin 40.00%Eligible Credit Facilities 44.58

* - 20% of Land is offered as Collateral Security having market value of more than Rs.20 crores.

Cost of

Project

Eligible for

Eligible Assets for Credit Facilities - Phase - I


5/44

Cost of Construction for bungalows Rs in lacs

A type A no Total A B type B no. Total B Grand Tota Total of A & B

7.92 40 316.8 11.6 40 464 7.808 21.472

Expenses upto June 07 4.6848

Commerci 750 7.5

Total 12.1848

Electrification 0.75 1 1.925

Total constrction +electr 23.397

Percentagewise Cost of construction for various months

1st Month 2 nd month 3rd Month Total %

Start quart 2 3 5 10

Quarter 2 5 7 8 20

Quarter 3 8 10 12 30


6/44


Projected Monthly Term Loan statement - Phase I Annexure

Particulars Till date Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06

No. of Month - 1 2 3 4 5 6% of Work per Month - Site De - 1.00% 2.00% 2.00% 15.00% 20.00% 15.00%

Civil Work commercial area - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

other - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

Advertising & Marketing Exp. - 0.50% 0.50% 0.50% 1.00% 1.50% 3.00%

OUT FLOW

Land Cost 22.850 0.000 23.460 0.000 7.690 0.000 0.000

Site Development 0.000 0.100 0.200 0.200 1.500 2.000 1.500

Construction cost - Common Fac 0.000 0.000 0.000 0.000 0.000 0.000 0.000

Plant and Machineries/Equipm 0.000 0.000 0.000 0.000 0.000 0.000 0.000

Administrative Expenses(incl. U 0.000 0.000 0.000 0.000 0.000 0.000 0.000

Power & Other Deposits 0.000 0.000 0.000 0.000 0.000 0.000 0.000Advertisement & Marketing Ex 0.000 0.004 0.004 0.004 0.008 0.011 0.023

Contigency

TOTAL 22.850 0.104 23.664 0.204 9.198 2.011 1.523

Term Loan interest 0.000 0.082 0.164 0.184 0.209 0.217

Cumulative investment 22.850 22.954 46.618 46.821 56.019 58.030 59.553

Eligible for term loan 37.358 37.561 46.759 48.770 50.293

term loan to meet interest during construction

Term Loan DP for disbu 26.150 26.293 32.731 34.139 35.205

Term Loan disbursement 26.150 0.143 6.438 1.408 1.066

Projected monthly Working Capital StatementCivil Cost-Residential Bungalow

Additional construction cost for completion

Total Construction for bungalows 0.000 0.000 0.000 0.000 0.000 0.000

-Commercial Areas 0.000 0.000 0.000 0.000 0.000 0.000

-Architect's & Engineer's Fees 0.050 0.050

Plant and Machineries/Equipments

less cost of bungalow sold

less cost of commercial area sold

Total assts 0.050 0.000 0.000 0.050 0.000 0.000

cumulative assets 0.050 0.050 0.050 0.100 0.100 0.100

Possession of bungalows

Less net booking advance bungalows

Less net booking advance commercial


7/44

profit reinvested from bungalo 19.880

profit reinvested from commerci 1300

Eligible assets 0.050 0.050 0.050 0.100 0.100 0.100

Working Capital 75% of assets 0.038 0.038 0.038 0.075 0.075 0.075

Outflow of funds 22.850 0.154 23.664 0.204 9.248 2.011 1.523Term loan interest 0.000 0.082 0.164 0.184 0.209 0.217

Interest on working capital loan 0.000 0.000 0.000 0.000 0.001 0.001 0.001

repayment of term loan

total outflow 22.850 0.154 23.746 0.368 9.432 2.221 1.740

Cash InflowEquity capital 20.000

redeemable pref shares 3.000 1.000 1.000

interest free deposits 2.850 0.500 1.150 1.000 1.500 1.000 1.000

booking advance from bungalowssales realisation bungalows

booking advance from comm.

sales realisation commercial area

term loan disbursment 0.000 0.000 26.150 0.143 6.438 1.408 1.066

working capital loan incrementa 0.000 0.038 0.000 0.000 0.038 0.000 0.000

total inflow 22.850 0.538 27.300 1.143 10.976 3.408 3.066

opening balance 0.000 0.000 0.383 3.938 4.713 6.256 7.443

cash surplus/(deficits) 0.000 0.383 3.555 0.775 1.543 1.187 1.326

closing balance 0.000 0.383 3.938 4.713 6.256 7.443 8.769

Interest during constuction 0.000 - 0.08 0.16 0.18 0.21 0.22


8/44

IV . Cont

(Rs. in Crores)

Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07

7 8 9 10 11 12 13 14 1510.00% 10.00% 10.00% 10.00% 2.00% 1.00% 1.00% 1.00% 0.00%

0.00% 0.00% 0.00% 2.00% 2.00% 3.00% 3.00% 3.00% 3.00%

0.00% 0.00% 10.00% 10.00% 10.00% 10.00% 10.00% 13.00% 17.00%

3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 4.00% 4.00% 4.00%

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

1.000 1.000 1.000 1.000 0.200 0.100 0.100 0.100 0.000

0.000 0.000 0.600 0.600 0.600 0.600 0.600 0.780 1.020

0.000 0.000 0.470 0.470 0.470 0.470 0.470 0.611 0.799

0.000 0.000 0.125 0.125 0.125 0.125 0.125 0.163 0.213

0.000 0.000 0.050 0.050 0.050 0.050 0.050 0.065 0.0850.023 0.023 0.023 0.023 0.023 0.023 0.030 0.030 0.030

1.023 1.023 2.268 2.268 1.468 1.368 1.375 1.749 2.147

0.222 0.227 0.234 0.244 0.252 0.258 0.264 0.271 0.280

60.575 61.598 63.865 66.133 67.600 68.968 70.343 72.091 74.238

51.315 52.338 54.605 56.873 58.340 59.708 61.083 62.831 64.978

35.921 36.636 38.224 39.811 40.838 41.795 42.758 43.982 45.484

0.716 0.716 1.587 1.587 1.027 0.957 0.962 1.224 1.503

0.172 0.258 0.429 0.429 0.601 0.687

0.000 0.000 0.000 0.172 0.258 0.429 0.429 0.601 0.687

0.000 0.000 0.000 0.150 0.150 0.225 0.225 0.225 0.225

0.050 0.020 0.050

0.050 0.000 0.000 0.322 0.408 0.654 0.654 0.846 0.962

0.150 0.150 0.150 0.472 0.879 1.534 2.188 3.035 3.997


9/44

0.150 0.150 0.150 0.472 0.879 1.534 2.188 3.035 3.997

0.113 0.113 0.113 0.354 0.660 1.150 1.641 2.276 2.997

1.073 1.023 2.268 2.589 1.875 2.022 2.029 2.595 3.109

0.222 0.227 0.234 0.244 0.252 0.258 0.264 0.271 0.280

0.001 0.001 0.001 0.003 0.005 0.008 0.012 0.017 0.022

1.296 1.250 2.502 2.836 2.132 2.289 2.306 2.882 3.410

1.000 1.000 1.000 2.000 1.000

1.000

0.716 0.716 1.587 1.587 1.027 0.876 0.962 1.224 1.503

0.038 0.000 0.000 0.241 0.306 0.491 0.491 0.635 0.722

1.753 1.716 1.587 1.829 2.333 1.367 2.453 3.859 3.224

8.769 9.227 9.692 8.777 7.770 7.971 7.050 7.197 8.174

0.458 0.466 -0.915 -1.007 0.201 -0.921 0.148 0.976 -0.186

9.227 9.692 8.777 7.770 7.971 7.050 7.197 8.174 7.988

0.22 0.23 0.23 0.24 0.25 0.26 0.26 0.27 0.28


10/44

d..

(Rs. in Crores)

Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07 Dec-07

16 17 18 19 20 21 22 23 240.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

3.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00%

10.00% 5.00% 5.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 3.00% 3.00%

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.600 0.300 0.300 0.000 0.000 0.000 0.000 0.000 0.000

0.470 0.235 0.235 0.000 0.000 0.000 0.000 0.000 0.000

0.125 0.063 0.063 0.000 0.000 0.000 0.000 0.000 0.000

0.050 0.025 0.025 0.000 0.000 0.000 0.000 0.000 0.0000.030 0.030 0.030 0.030 0.030 0.030 0.030 0.023 0.023

2.550

3.825 0.653 0.653 0.030 0.030 0.030 0.030 0.023 0.023

0.293 0.302 0.305 0.307 0.307 0.307 0.307 0.307 0.307

78.063 78.715 79.368 79.398 79.428 79.458 79.488 79.510 79.533

68.803 69.455 70.108 70.138 70.168 70.198 70.228 70.250 70.273

48.162 48.619 49.075 49.096 49.117 49.138 49.159 49.175 49.191

2.678 0.457 0.457 0.021 0.021 0.021 0.021 0.016 0.016

0.687 0.859 1.031 0.172 0.258 0.429 0.429 0.601 0.687

0.215 0.215 0.215 0.215 0.215 0.215

0.286 0.286 0.286

0.687 0.859 1.031 0.386 0.472 0.644 0.930 1.102 1.188

0.225 0.375 0.375 0.375 0.375 0.375 0.375 0.375 0.375

0.035 0.025 0.025 0.025 0.025 0.025 0.025 0.015 0.010

0.263

0.000 0.000 0.000

0.000 0.000 0.000

0.947 1.259 1.431 0.786 0.872 1.044 1.593 1.492 1.573

4.944 6.203 7.633 8.420 9.292 10.336 11.929 13.422 14.995

0.000 0.000 0.000 0.097 0.097 0.097 0.580 0.580 0.580

0.000 0.000 0.000 0.450 0.450 0.450


11/44

0.000 0.000 0.000

0.000 0.000 0.000

4.944 6.203 7.633 8.323 9.195 10.240 10.899 12.392 13.965

3.708 4.652 5.725 6.242 6.897 7.680 8.174 9.294 10.473

4.772 1.911 2.083 0.816 0.902 1.074 1.623 1.515 1.596

0.293 0.302 0.305 0.307 0.307 0.307 0.307 0.307 0.307

0.027 0.034 0.042 0.046 0.050 0.056 0.060 0.068 0.076

5.092 2.248 2.430 1.169 1.260 1.437 1.990 1.890 1.979

1.000 1.000 1.000 1.000 1.000 1.000

0.097 0.097 0.097 0.483 0.483 0.483

0.450 0.450 0.450

0.000 0.000 0.000

2.678 0.457 0.457 0.021 0.021 0.021 0.021 0.016 0.016

0.710 0.944 1.073 0.517 0.654 0.783 0.495 1.119 1.180

4.388 2.401 2.530 1.635 1.772 0.901 1.999 1.618 1.679

7.988 7.284 7.437 7.537 8.003 8.515 7.979 7.988 7.717

-0.704 0.153 0.100 0.466 0.512 -0.536 0.009 -0.272 -0.300

7.284 7.437 7.537 8.003 8.515 7.979 7.988 7.717 7.416

0.29 0.30 0.31


12/44

. Contd..

Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08

25 26 27 28 29 30 31 32 330.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 1.00%

0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 2.00% 2.00% 2.00%

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.0000.023 0.023 0.023 0.023 0.023 0.023 0.015 0.015 0.015

0.023 0.023 0.023 0.023 0.023 0.023 0.015 0.015 0.015

0.316 0.321 0.310 0.296 0.278 0.256 0.227 0.190 0.150

79.555 79.578 79.600 79.623 79.645 79.668 79.683 79.698 79.713

70.295 70.318 70.340 70.363 70.385 70.408 70.423 70.438 70.453

2.405

51.611 49.222 49.238 49.254 49.270 49.285 49.296 49.306 49.317

2.421

0.687 0.859 1.031 0.172 0.258 0.429 0.429 0.601 0.687

0.286 0.286 0.286

0.429 0.429 0.429 0.429 0.429 0.429

0.429 0.429 0.429 0.429 0.429 0.429

1.403 1.575 1.746 1.031 1.117 1.288 0.859 1.031 1.117

0.375 0.375 0.375 0.375 0.375 0.375 0.375 0.375 0.075

0.010 0.010 0.010 0.010 0.010 0.005 0.005 0.005 0.005

0.350 0.525 0.525

1.170 1.170 1.170 1.560 1.560 1.560 2.340 2.340 2.340

0.500 0.500 0.500 0.750 0.750 0.750 1.250 1.250 1.250

0.468 0.290 0.462 -0.369 -0.808 -0.641 -1.826 -2.179 -2.393

15.463 15.752 16.214 15.845 15.037 14.395 12.569 10.390 7.997

15 20 30

0.483 0.483 0.483 1.450 1.450 1.450 2.175 2.175 2.175

0.675 0.675 0.675 1.575 1.575 1.575 1.125 1.125 1.125


13/44

0.994 0.994 0.994 1.325 1.325 1.325 1.988 1.988 1.988

1.300 1.300 1.300 1.950 1.950 1.950 3.250 3.250 3.250

12.010 12.300 12.762 9.544 8.736 8.095 4.031 1.852 -0.541

9.008 9.225 9.571 7.158 6.552 6.071 3.023 1.389 -0.406

0.490 0.312 0.484 -0.347 -0.786 -0.619 -1.811 -2.164 -2.378

0.316 0.321 0.310 0.296 0.278 0.256 0.227 0.190 0.150

0.066 0.067 0.070 0.052 0.048 0.044 0.022 0.010 0.000

1.000 2.000 2.000 3.000 3.000 5.000 5.000 6.000

0.872 1.701 2.864 2.001 2.540 2.681 3.438 3.036 3.772

-1.000 -0.500 -1.000 -1.050

0.628 0.628 0.628 1.208 1.208 1.208 1.208 1.208 1.2082.175 2.175 2.175 2.900 2.900 2.900 4.350 4.350 4.350

0.675 0.675 0.675 1.125 1.125 1.125 0.000 0.000 0.000

1.350 1.350 1.350 2.025 2.025 2.025 3.375 3.375 3.375

2.421

-1.466 0.217 0.346 -2.413 -0.606 -0.481 -3.048 -1.634 -1.795

5.108 3.371 4.499 3.720 5.027 5.652 4.886 6.249 7.138

7.416 11.652 13.321 14.957 16.676 19.163 22.134 23.582 26.795

4.236 1.670 1.635 1.719 2.487 2.971 1.448 3.213 3.367

11.652 13.321 14.957 16.676 19.163 22.134 23.582 26.795 30.161


14/44

(Rs. in Crores)

Oct-08 Nov-08 Dec-08 Jan-09

34 35 360.00% 0.00% 0.00% 100.00%

0.00% 0.00% 0.00% 100.00%

0.00% 0.00% 0.00% 100.00%

2.00% 2.00% 1.00% 100.00%

0.000

0.000 0.000 0.000 54.000

0.000 0.000 0.000 10.000

0.000 0.000 0.000 0.000 6.000

0.000 0.000 0.000 0.000 4.700

0.000 0.000 0.000 1.250

0.000 0.000 0.000 0.5000.015 0.015 0.008 0.750

0.015 0.015 0.008 77.200

0.103 0.059 0.020

79.728 79.743 79.750

70.468 70.483 70.490

2.405

49.327 49.338 49.343

0.005 51.617

0.687 0.859 1.031 15.460

1.288

1.718

2.577

2.577

0.687 0.859 1.031 23.619

0.000 0.000 0.000 7.500

0.500

0.000 1.663

2.340 2.340 2.340

0.000 0.000 0.000

-1.653 -1.481 -1.309 33.282

6.344 4.864 3.555

30

4.350 4.350 4.350 4.350

0.000 0.000 0.000


15/44

1.988 1.988 1.988

0.000 0.000 0.000 1319.500

0.006 -1.474 -2.783

0.005 -1.106 -2.088

-1.638 -1.466 -1.302 83.305

0.103 0.059 0.020

0.000 0.000 0.000

7.000 5.000 12.611 51.611

5.465 3.593 11.330

20.000

11.000

12.450

2.175 2.175 2.175 17.4004.350 4.350 4.350 41.325

0.000 0.000 0.000 6.750

0.000 0.000 0.000 0.000 20.250

51.530

0.411 -1.111 -0.982 2.088 0.000

6.936 5.414 5.543 171.868

30.161 31.632 33.453

1.470 1.821 -5.787

31.632 33.453 27.667

4.008


16/44


Projected Monthly Term Loan statement - Phase I

Particulars Till date Jan-06 Feb-06 Mar-06 Apr-06 May-06

No. of Month - 1 2 3 4 5% of Work per Month - Site De - 1.00% 2.00% 2.00% 15.00% 20.00%

Civil Work commercial area - 0.00% 0.00% 0.00% 0.00% 0.00%

other - 0.00% 0.00% 0.00% 0.00% 0.00%

Advertising & Marketing Exp. - 0.50% 0.50% 0.50% 1.00% 1.50%

OUT FLOW

Land Cost 22.850 0.000 23.460 0.000 7.690 0.000

Site Development 0.000 0.100 0.200 0.200 1.500 2.000

Construction cost - Common Faci 0.000 0.000 0.000 0.000 0.000 0.000

Plant and Machineries/Equipme 0.000 0.000 0.000 0.000 0.000 0.000

Administrative Expenses(incl. Up 0.000 0.000 0.000 0.000 0.000 0.000

Power & Other Deposits 0.000 0.000 0.000 0.000 0.000 0.000Advertisement & Marketing Exp 0.000 0.004 0.004 0.004 0.008 0.011

Contigency

TOTAL 22.850 0.104 23.664 0.204 9.198 2.011

Term Loan interest 0.000 0.082 0.164 0.184 0.209

Cumulative investment 22.850 22.954 46.618 46.821 56.019 58.030

Eligible for term loan 37.358 37.561 46.759 48.770


Term Loan DP for disbu 22.415 22.537 28.055 29.262

Term Loan disbursement 0.000 0.000 22.415 0.122 5.519 1.207



Total Construction for bungalows 0.000 0.000 0.000 0.000 0.000

-Commercial Areas 0.000 0.000 0.000 0.000 0.000

-Architect's & Engineer's Fees 0.050 0.050




Total assts 0.050 0.000 0.000 0.050 0.000

cumulative assets 0.050 0.050 0.050 0.100 0.100





17/44

profit reinvested from bungalows 19.880

profit reinvested from commerci 1300

Eligible assets 0.050 0.050 0.050 0.100 0.100

Working Capital 75% of assets 0.038 0.038 0.038 0.075 0.075

Outflow of funds 22.850 0.154 23.664 0.204 9.248 2.011Term loan interest 0.000 0.082 0.164 0.184 0.209

Interest on working capital loan 0.000 0.000 0.000 0.000 0.001 0.001


total outflow 22.850 0.154 23.746 0.368 9.432 2.221

Cash InflowEquity capital 20.000

redeemable pref shares 3.000 1.000

interest free deposits 2.850 0.500 1.150 1.000 1.500 1.000




term loan disbursment 0.000 0.000 22.415 0.122 5.519 1.207

working capital loan incremental 0.000 0.038 0.000 0.000 0.038 0.000

total inflow 22.850 0.538 23.565 1.122 10.056 3.207

opening balance 0.000 0.000 0.383 0.202 0.957 1.580

cash surplus/(deficits) 0.000 0.383 -0.181 0.754 0.624 0.986

closing balance 0.000 0.383 0.202 0.957 1.580 2.566

Interest during constuction 0.000 - 0.08 0.16 0.18 0.21


18/44

(Rs. in Crores)

Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07

6 7 8 9 10 11 12 13 1415.00% 10.00% 10.00% 10.00% 10.00% 2.00% 1.00% 1.00% 1.00%

0.00% 0.00% 0.00% 0.00% 2.00% 2.00% 3.00% 3.00% 3.00%

0.00% 0.00% 0.00% 10.00% 10.00% 10.00% 10.00% 10.00% 13.00%

3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 4.00% 4.00%

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

1.500 1.000 1.000 1.000 1.000 0.200 0.100 0.100 0.100

0.000 0.000 0.000 0.600 0.600 0.600 0.600 0.600 0.780

0.000 0.000 0.000 0.470 0.470 0.470 0.470 0.470 0.611

0.000 0.000 0.000 0.125 0.125 0.125 0.125 0.125 0.163

0.000 0.000 0.000 0.050 0.050 0.050 0.050 0.050 0.0650.023 0.023 0.023 0.023 0.023 0.023 0.023 0.030 0.030

1.523 1.023 1.023 2.268 2.268 1.468 1.368 1.375 1.749

0.217 0.222 0.227 0.234 0.244 0.252 0.258 0.264 0.271

59.553 60.575 61.598 63.865 66.133 67.600 68.968 70.343 72.091

50.293 51.315 52.338 54.605 56.873 58.340 59.708 61.083 62.831

30.176 30.789 31.403 32.763 34.124 35.004 35.825 36.650 37.699

0.913 0.614 0.614 1.360 1.361 0.880 0.821 0.825 1.049

0.172 0.258 0.429 0.429 0.601

0.000 0.000 0.000 0.000 0.172 0.258 0.429 0.429 0.601

0.000 0.000 0.000 0.000 0.150 0.150 0.225 0.225 0.225

0.050 0.020

0.000 0.050 0.000 0.000 0.322 0.408 0.654 0.654 0.846

0.100 0.150 0.150 0.150 0.472 0.879 1.534 2.188 3.035


19/44

0.100 0.150 0.150 0.150 0.472 0.879 1.534 2.188 3.035

0.075 0.113 0.113 0.113 0.354 0.660 1.150 1.641 2.276

1.523 1.073 1.023 2.268 2.589 1.875 2.022 2.029 2.595

0.217 0.222 0.227 0.234 0.244 0.252 0.258 0.264 0.271

0.001 0.001 0.001 0.001 0.003 0.005 0.008 0.012 0.017

1.740 1.296 1.250 2.502 2.836 2.132 2.289 2.306 2.882

1.000 1.000 1.000 1.000 2.000

1.000 1.000

0.913 0.614 0.614 1.360 1.361 0.880 0.740 0.825 1.049

0.000 0.038 0.000 0.000 0.241 0.306 0.491 0.491 0.635

2.914 1.651 1.614 1.360 1.602 2.186 1.230 2.316 3.684

2.566 3.740 4.095 4.459 3.317 2.083 2.137 1.079 1.089

1.174 0.355 0.363 -1.142 -1.234 0.054 -1.058 0.010 0.801

3.740 4.095 4.459 3.317 2.083 2.137 1.079 1.089 1.891

0.22 0.22 0.23 0.23 0.24 0.25 0.26 0.26 0.27


20/44

. Contd..

(Rs. in Cro

Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07

15 16 17 18 19 20 21 22 230.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

3.00% 3.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00%

17.00% 10.00% 5.00% 5.00% 0.00% 0.00% 0.00% 0.00% 0.00%

4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 3.00%

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

1.020 0.600 0.300 0.300 0.000 0.000 0.000 0.000 0.000

0.799 0.470 0.235 0.235 0.000 0.000 0.000 0.000 0.000

0.213 0.125 0.063 0.063 0.000 0.000 0.000 0.000 0.000

0.085 0.050 0.025 0.025 0.000 0.000 0.000 0.000 0.0000.030 0.030 0.030 0.030 0.030 0.030 0.030 0.030 0.023

2.550

2.147 3.825 0.653 0.653 0.030 0.030 0.030 0.030 0.023

0.280 0.293 0.302 0.305 0.307 0.307 0.307 0.307 0.307

74.238 78.063 78.715 79.368 79.398 79.428 79.458 79.488 79.510

64.978 68.803 69.455 70.108 70.138 70.168 70.198 70.228 70.250

38.987 41.282 41.673 42.065 42.083 42.101 42.119 42.137 42.150

1.288 2.295 0.392 0.392 0.018 0.018 0.018 0.018 0.013

0.687 0.687 0.859 1.031 0.172 0.258 0.429 0.429 0.601

0.215 0.215 0.215 0.215 0.215

0.286 0.286

0.687 0.687 0.859 1.031 0.386 0.472 0.644 0.930 1.102

0.225 0.225 0.375 0.375 0.375 0.375 0.375 0.375 0.375

0.050 0.035 0.025 0.025 0.025 0.025 0.025 0.025 0.015

0.263

0.000 0.000

0.000 0.000

0.962 0.947 1.259 1.431 0.786 0.872 1.044 1.593 1.492

3.997 4.944 6.203 7.633 8.420 9.292 10.336 11.929 13.422

0.000 0.000 0.000 0.097 0.097 0.097 0.580 0.580

0.000 0.000 0.000 0.450 0.450


21/44

0.000 0.000

0.000 0.000

3.997 4.944 6.203 7.633 8.323 9.195 10.240 10.899 12.392

2.997 3.708 4.652 5.725 6.242 6.897 7.680 8.174 9.294

3.109 4.772 1.911 2.083 0.816 0.902 1.074 1.623 1.515

0.280 0.293 0.302 0.305 0.307 0.307 0.307 0.307 0.307

0.022 0.027 0.034 0.042 0.046 0.050 0.056 0.060 0.068

3.410 5.092 2.248 2.430 1.169 1.260 1.437 1.990 1.890

1.000

1.000 1.000 1.000 1.000 1.000 1.000

0.097 0.097 0.097 0.483 0.483

0.450 0.450

0.000 0.000

1.288 2.295 0.392 0.392 0.018 0.018 0.018 0.018 0.013

0.722 0.710 0.944 1.073 0.517 0.654 0.783 0.495 1.119

3.009 4.005 2.336 2.464 1.632 1.769 0.898 1.996 1.616

1.891 1.490 0.404 0.492 0.526 0.989 1.498 0.959 0.965

-0.401 -1.086 0.088 0.034 0.463 0.509 -0.539 0.006 -0.274

1.490 0.404 0.492 0.526 0.989 1.498 0.959 0.965 0.692

0.28 0.29 0.30 0.31


22/44

. Contd..

res)

Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08

24 25 26 27 28 29 30 31 320.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00%

0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 2.00% 2.00%

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.0000.023 0.023 0.023 0.023 0.023 0.023 0.023 0.015 0.015

0.023 0.023 0.023 0.023 0.023 0.023 0.023 0.015 0.015

0.307 0.316 0.321 0.310 0.296 0.278 0.256 0.227 0.190

79.533 79.555 79.578 79.600 79.623 79.645 79.668 79.683 79.698

70.273 70.295 70.318 70.340 70.363 70.385 70.408 70.423 70.438

2.405

42.164 44.582 42.191 42.204 42.218 42.231 42.245 42.254 42.263

0.014 2.418

0.687 0.687 0.859 1.031 0.172 0.258 0.429 0.429 0.601

0.215

0.286 0.286 0.286 0.286

0.429 0.429 0.429 0.429 0.429 0.429

0.429 0.429 0.429 0.429 0.429

1.188 1.403 1.575 1.746 1.031 1.117 1.288 0.859 1.031

0.375 0.375 0.375 0.375 0.375 0.375 0.375 0.375 0.375

0.010 0.010 0.010 0.010 0.010 0.010 0.005 0.005 0.005

0.350 0.525 0.525

0.000 1.170 1.170 1.170 1.560 1.560 1.560 2.340 2.340

0.000 0.500 0.500 0.500 0.750 0.750 0.750 1.250 1.250

1.573 0.468 0.290 0.462 -0.369 -0.808 -0.641 -1.826 -2.179

14.995 15.463 15.752 16.214 15.845 15.037 14.395 12.569 10.390

15 20 30

0.580 0.483 0.483 0.483 1.450 1.450 1.450 2.175 2.175

0.450 0.675 0.675 0.675 1.575 1.575 1.575 1.125 1.125


23/44

0.000 0.994 0.994 0.994 1.325 1.325 1.325 1.988 1.988

0.000 1.300 1.300 1.300 1.950 1.950 1.950 3.250 3.250

13.965 12.010 12.300 12.762 9.544 8.736 8.095 4.031 1.852

10.473 9.008 9.225 9.571 7.158 6.552 6.071 3.023 1.389

1.596 0.490 0.312 0.484 -0.347 -0.786 -0.619 -1.811 -2.164

0.307 0.316 0.321 0.310 0.296 0.278 0.256 0.227 0.190

0.076 0.066 0.067 0.070 0.052 0.048 0.044 0.022 0.010

1.000 2.000 2.000 3.000 3.000 5.000 5.000

1.979 0.872 1.701 2.864 2.001 2.540 2.681 3.438 3.036

-1.000 -0.500 -1.000 -1.050

0.483 0.628 0.628 0.628 1.208 1.208 1.208 1.208 1.2082.175 2.175 2.175 2.900 2.900 2.900 4.350 4.350

0.450 0.675 0.675 0.675 1.125 1.125 1.125 0.000 0.000

0.000 1.350 1.350 1.350 2.025 2.025 2.025 3.375 3.375

0.014 2.418

1.180 -1.466 0.217 0.346 -2.413 -0.606 -0.481 -3.048 -1.634

1.677 5.106 3.371 4.499 3.720 5.027 5.652 4.886 6.249

0.692 0.389 4.622 6.292 7.927 9.646 12.134 15.105 16.553

-0.303 4.233 1.670 1.635 1.719 2.487 2.971 1.448 3.213

0.389 4.622 6.292 7.927 9.646 12.134 15.105 16.553 19.765


24/44

(Rs. in Crores)

Sep-08 Oct-08 Nov-08 Dec-08 Jan-09

33 34 35 360.00% 0.00% 0.00% 0.00% 100.00%

1.00% 0.00% 0.00% 0.00% 100.00%

0.00% 0.00% 0.00% 0.00% 100.00%

2.00% 2.00% 2.00% 1.00% 100.00%

0.000

0.000 0.000 0.000 0.000 54.000

0.000 0.000 0.000 0.000 10.000

0.000 0.000 0.000 0.000 0.000 6.000

0.000 0.000 0.000 0.000 0.000 4.700

0.000 0.000 0.000 0.000 1.250

0.000 0.000 0.000 0.000 0.5000.015 0.015 0.015 0.008 0.750

0.015 0.015 0.015 0.008 77.200

0.150 0.103 0.059 0.020

79.713 79.728 79.743 79.750

70.453 70.468 70.483 70.490

2.405

42.272 42.281 42.290 42.294

0.005 44.586

0.687 0.687 0.859 1.031 15.460

1.288

1.718

2.577

0.429 2.577

1.117 0.687 0.859 1.031 23.619

0.075 0.000 0.000 0.000 7.500

0.005 0.500

0.000 1.663

2.340 2.340 2.340 2.340

1.250 0.000 0.000 0.000

-2.393 -1.653 -1.481 -1.309 33.282

7.997 6.344 4.864 3.555

30

2.175 4.350 4.350 4.350 4.350

1.125 0.000 0.000 0.000


25/44

1.988 1.988 1.988 1.988

3.250 0.000 0.000 0.000 1319.500

-0.541 0.006 -1.474 -2.783

-0.406 0.005 -1.106 -2.088

-2.378 -1.638 -1.466 -1.302 83.305

0.150 0.103 0.059 0.020

0.000 0.000 0.000 0.000

6.000 7.000 5.000 5.580 44.580

3.772 5.465 3.593 4.299

20.000

11.000

12.450

1.208 2.175 2.175 2.175 17.4004.350 4.350 4.350 4.350 41.325

0.000 0.000 0.000 0.000 6.750

3.375 0.000 0.000 0.000 0.000 20.250

44.501

-1.795 0.411 -1.111 -0.982 2.088 0.000

7.138 6.936 5.414 5.543 164.838

19.765 23.132 24.602 26.424

3.367 1.470 1.821 1.244

23.132 24.602 26.424 27.668

4.008


26/44


Projected Monthly Term Loan statement - Phase I

Particular Till date Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06

No. of Mo - 1 2 3 4 5 6 7% of Wor - 1.00% 2.00% 2.00% 15.00% 20.00% 15.00% 10.00%

Civil Wo - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

other - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

Advertisi - 0.50% 0.50% 0.50% 1.00% 1.50% 3.00% 3.00%

OUT FLOW

Land Cost 22.850 0.000 23.460 0.000 7.690 0.000 0.000 0.000

Site Devel 0.000 0.100 0.200 0.200 1.500 2.000 1.500 1.000

Constructi 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

Plant and 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

Administr 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

Power & 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000Advertise 0.000 0.004 0.004 0.004 0.008 0.011 0.023 0.023

Contigency

TOTAL 22.850 0.104 23.664 0.204 9.198 2.011 1.523 1.023

Term Loan interest 0.000 0.082 0.164 0.184 0.209 0.217 0.222

Cumulati 22.850 22.954 46.618 46.821 56.019 58.030 59.553 60.575

Eligible for term loan 37.358 37.561 46.759 48.770 50.293 51.315


Term Loan DP for disbu 22.415 22.537 28.055 29.262 30.176 30.789

Term Loa 0.000 0.000 22.415 0.122 5.519 1.207 0.913 0.614



Total Construction fo 0.000 0.000 0.000 0.000 0.000 0.000 0.000

-Commer 0.000 0.000 0.000 0.000 0.000 0.000 0.000

-Architect' 0.050 0.050 0.050




Total assts 0.050 0.000 0.000 0.050 0.000 0.000 0.050

cumulative assets 0.050 0.050 0.050 0.100 0.100 0.100 0.150





27/44

profit rein 19.880

profit rein 1300

Eligible assets 0.050 0.050 0.050 0.100 0.100 0.100 0.150

Working Capital 75% 0.038 0.038 0.038 0.075 0.075 0.075 0.113

Outflo 22.850 0.154 23.664 0.204 9.248 2.011 1.523 1.073Term loan interes 0.000 0.082 0.164 0.184 0.209 0.217 0.222

Interest o 0.000 0.000 0.000 0.000 0.001 0.001 0.001 0.001


total outfl 22.850 0.154 23.746 0.368 9.432 2.221 1.740 1.296

Cash InflowEquity ca 20.000

redeemable pref shares 3.000 1.000 1.000

interest fr 2.850 0.500 1.150 1.000 1.500 1.000 1.000 1.000




term loan 0.000 0.000 22.415 0.122 5.519 1.207 0.913 0.614

working c 0.000 0.038 0.000 0.000 0.038 0.000 0.000 0.038

total inflo 22.850 0.538 23.565 1.122 10.056 3.207 2.914 1.651

opening b 0.000 0.000 0.383 0.202 0.957 1.580 2.566 3.740

cash surp 0.000 0.383 -0.181 0.754 0.624 0.986 1.174 0.355

closin 0.000 0.383 0.202 0.957 1.580 2.566 3.740 4.095

Interest d 0.000 - 0.08 0.16 0.18 0.21 0.22 0.22


28/44

. Contd..

(Rs. in Crores)

Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07 Apr-07

8 9 10 11 12 13 14 15 1610.00% 10.00% 10.00% 2.00% 1.00% 1.00% 1.00% 0.00% 0.00%

0.00% 0.00% 2.00% 2.00% 3.00% 3.00% 3.00% 3.00% 3.00%

0.00% 10.00% 10.00% 10.00% 10.00% 10.00% 13.00% 17.00% 10.00%

3.00% 3.00% 3.00% 3.00% 3.00% 4.00% 4.00% 4.00% 4.00%

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

1.000 1.000 1.000 0.200 0.100 0.100 0.100 0.000 0.000

0.000 0.600 0.600 0.600 0.600 0.600 0.780 1.020 0.600

0.000 0.470 0.470 0.470 0.470 0.470 0.611 0.799 0.470

0.000 0.125 0.125 0.125 0.125 0.125 0.163 0.213 0.125

0.000 0.050 0.050 0.050 0.050 0.050 0.065 0.085 0.0500.023 0.023 0.023 0.023 0.023 0.030 0.030 0.030 0.030

2.550

1.023 2.268 2.268 1.468 1.368 1.375 1.749 2.147 3.825

0.227 0.234 0.244 0.252 0.258 0.264 0.271 0.280 0.293

61.598 63.865 66.133 67.600 68.968 70.343 72.091 74.238 78.063

52.338 54.605 56.873 58.340 59.708 61.083 62.831 64.978 68.803

31.403 32.763 34.124 35.004 35.825 36.650 37.699 38.987 41.282

0.614 1.360 1.361 0.880 0.821 0.825 1.049 1.288 2.295

0.172 0.258 0.429 0.429 0.601 0.687 0.687

0.000 0.000 0.172 0.258 0.429 0.429 0.601 0.687 0.687

0.000 0.000 0.150 0.150 0.225 0.225 0.225 0.225 0.225

0.020 0.050 0.035

0.000 0.000 0.322 0.408 0.654 0.654 0.846 0.962 0.947

0.150 0.150 0.472 0.879 1.534 2.188 3.035 3.997 4.944

0.000


29/44

0.150 0.150 0.472 0.879 1.534 2.188 3.035 3.997 4.944

0.113 0.113 0.354 0.660 1.150 1.641 2.276 2.997 3.708

1.023 2.268 2.589 1.875 2.022 2.029 2.595 3.109 4.772

0.227 0.234 0.244 0.252 0.258 0.264 0.271 0.280 0.293

0.001 0.001 0.003 0.005 0.008 0.012 0.017 0.022 0.027

1.250 2.502 2.836 2.132 2.289 2.306 2.882 3.410 5.092

1.000 1.000 1.000 2.000 1.000

1.000

0.614 1.360 1.361 0.880 0.740 0.825 1.049 1.288 2.295

0.000 0.000 0.241 0.306 0.491 0.491 0.635 0.722 0.710

1.614 1.360 1.602 2.186 1.230 2.316 3.684 3.009 4.005

4.095 4.459 3.317 2.083 2.137 1.079 1.089 1.891 1.490

0.363 -1.142 -1.234 0.054 -1.058 0.010 0.801 -0.401 -1.086

4.459 3.317 2.083 2.137 1.079 1.089 1.891 1.490 0.404

0.23 0.23 0.24 0.25 0.26 0.26 0.27 0.28 0.29


30/44

(Rs. in Crores)

May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08

17 18 19 20 21 22 23 24 250.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00%

5.00% 5.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 3.00% 3.00% 3.00%

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.300 0.300 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.235 0.235 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.063 0.063 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.025 0.025 0.000 0.000 0.000 0.000 0.000 0.000 0.0000.030 0.030 0.030 0.030 0.030 0.030 0.023 0.023 0.023

0.653 0.653 0.030 0.030 0.030 0.030 0.023 0.023 0.023

0.302 0.305 0.307 0.307 0.307 0.307 0.307 0.307 0.316

78.715 79.368 79.398 79.428 79.458 79.488 79.510 79.533 79.555

69.455 70.108 70.138 70.168 70.198 70.228 70.250 70.273 70.295

2.405

41.673 42.065 42.083 42.101 42.119 42.137 42.150 42.164 44.582

0.392 0.392 0.018 0.018 0.018 0.018 0.013 0.014 2.418

0.859 1.031 0.172 0.258 0.429 0.429 0.601 0.687 0.687

0.215 0.215 0.215 0.215 0.215 0.215

0.286 0.286 0.286 0.286

0.429

0.859 1.031 0.386 0.472 0.644 0.930 1.102 1.188 1.403

0.375 0.375 0.375 0.375 0.375 0.375 0.375 0.375 0.375

0.025 0.025 0.025 0.025 0.025 0.025 0.015 0.010 0.010

0.263 0.350

0.000 0.000 0.000 1.170

0.000 0.000 0.000 0.500

1.259 1.431 0.786 0.872 1.044 1.593 1.492 1.573 0.468

6.203 7.633 8.420 9.292 10.336 11.929 13.422 14.995 15.463

15

0.000 0.000 0.097 0.097 0.097 0.580 0.580 0.580 0.483

0.000 0.000 0.000 0.450 0.450 0.450 0.675


31/44

0.000 0.000 0.000 0.994

0.000 0.000 0.000 1.300

6.203 7.633 8.323 9.195 10.240 10.899 12.392 13.965 12.010

4.652 5.725 6.242 6.897 7.680 8.174 9.294 10.473 9.008

1.911 2.083 0.816 0.902 1.074 1.623 1.515 1.596 0.490

0.302 0.305 0.307 0.307 0.307 0.307 0.307 0.307 0.316

0.034 0.042 0.046 0.050 0.056 0.060 0.068 0.076 0.066

2.248 2.430 1.169 1.260 1.437 1.990 1.890 1.979 0.872

1.000 1.000 1.000 1.000 1.000

0.097 0.097 0.097 0.483 0.483 0.483 0.6282.175

0.450 0.450 0.450 0.675

0.000 0.000 0.000 1.350

0.392 0.392 0.018 0.018 0.018 0.018 0.013 0.014 2.418

0.944 1.073 0.517 0.654 0.783 0.495 1.119 1.180 -1.466

2.336 2.464 1.632 1.769 0.898 1.996 1.616 1.677 5.106

0.404 0.492 0.526 0.989 1.498 0.959 0.965 0.692 0.389

0.088 0.034 0.463 0.509 -0.539 0.006 -0.274 -0.303 4.233

0.492 0.526 0.989 1.498 0.959 0.965 0.692 0.389 4.622

0.30 0.31


32/44

. Contd..

(Rs. in Cro

Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Oct-08

26 27 28 29 30 31 32 33 340.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 1.00% 0.00%

0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

3.00% 3.00% 3.00% 3.00% 3.00% 2.00% 2.00% 2.00% 2.00%

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.0000.023 0.023 0.023 0.023 0.023 0.015 0.015 0.015 0.015

0.023 0.023 0.023 0.023 0.023 0.015 0.015 0.015 0.015

0.321 0.310 0.296 0.278 0.256 0.227 0.190 0.150 0.103

79.578 79.600 79.623 79.645 79.668 79.683 79.698 79.713 79.728

70.318 70.340 70.363 70.385 70.408 70.423 70.438 70.453 70.468

42.191 42.204 42.218 42.231 42.245 42.254 42.263 42.272 42.281

0.859 1.031 0.172 0.258 0.429 0.429 0.601 0.687 0.687

0.286 0.286

0.429 0.429 0.429 0.429 0.429

0.429 0.429 0.429 0.429 0.429 0.429

1.575 1.746 1.031 1.117 1.288 0.859 1.031 1.117 0.687

0.375 0.375 0.375 0.375 0.375 0.375 0.375 0.075 0.000

0.010 0.010 0.010 0.010 0.005 0.005 0.005 0.005

0.525 0.525 0.000

1.170 1.170 1.560 1.560 1.560 2.340 2.340 2.340 2.340

0.500 0.500 0.750 0.750 0.750 1.250 1.250 1.250 0.000

0.290 0.462 -0.369 -0.808 -0.641 -1.826 -2.179 -2.393 -1.653

15.752 16.214 15.845 15.037 14.395 12.569 10.390 7.997 6.344

20 30 30

0.483 0.483 1.450 1.450 1.450 2.175 2.175 2.175 4.350

0.675 0.675 1.575 1.575 1.575 1.125 1.125 1.125 0.000


33/44

0.994 0.994 1.325 1.325 1.325 1.988 1.988 1.988 1.988

1.300 1.300 1.950 1.950 1.950 3.250 3.250 3.250 0.000

12.300 12.762 9.544 8.736 8.095 4.031 1.852 -0.541 0.006

9.225 9.571 7.158 6.552 6.071 3.023 1.389 -0.406 0.005

0.312 0.484 -0.347 -0.786 -0.619 -1.811 -2.164 -2.378 -1.638

0.321 0.310 0.296 0.278 0.256 0.227 0.190 0.150 0.103

0.067 0.070 0.052 0.048 0.044 0.022 0.010 0.000 0.000

1.000 2.000 2.000 3.000 3.000 5.000 5.000 6.000 7.000

1.701 2.864 2.001 2.540 2.681 3.438 3.036 3.772 5.465

-1.000 -0.500 -1.000 -1.050

0.628 0.628 1.208 1.208 1.208 1.208 1.208 1.208 2.1752.175 2.175 2.900 2.900 2.900 4.350 4.350 4.350 4.350

0.675 0.675 1.125 1.125 1.125 0.000 0.000 0.000 0.000

1.350 1.350 2.025 2.025 2.025 3.375 3.375 3.375 0.000

0.217 0.346 -2.413 -0.606 -0.481 -3.048 -1.634 -1.795 0.411

3.371 4.499 3.720 5.027 5.652 4.886 6.249 7.138 6.936

4.622 6.292 7.927 9.646 12.134 15.105 16.553 19.765 23.132

1.670 1.635 1.719 2.487 2.971 1.448 3.213 3.367 1.470

6.292 7.927 9.646 12.134 15.105 16.553 19.765 23.132 24.602


34/44

res)

Nov-08 Dec-08 Jan-09

35 360.00% 0.00% 100.00%

0.00% 0.00% 100.00%

0.00% 0.00% 100.00%

2.00% 1.00% 100.00%

0.000

0.000 0.000 54.000

0.000 0.000 10.000

0.000 0.000 0.000 6.000

0.000 0.000 0.000 4.700

0.000 0.000 1.250

0.000 0.000 0.5000.015 0.008 0.750

0.015 0.008 77.200

0.059 0.020

79.743 79.750

70.483 70.490

2.405

42.290 42.294

0.005 44.586

0.859 1.031 15.460

1.288

1.718

2.577

2.577

0.859 1.031 23.619

0.000 0.000 7.500

0.500

1.663

2.340 2.340

0.000 0.000

-1.481 -1.309 33.282

4.864 3.555

4.350 4.350 4.350

0.000 0.000


35/44

1.988 1.988

0.000 0.000 1319.500

-1.474 -2.783

-1.106 -2.088

-1.466 -1.302 83.305

0.059 0.020

0.000 0.000

5.000 5.580 44.580

3.593 4.299

20.000

11.000

12.450

2.175 2.175 17.4004.350 4.350 41.325

0.000 0.000 6.750

0.000 0.000 0.000 20.250

44.501

-1.111 -0.982 2.088 0.000

5.414 5.543 164.838

24.602 26.424

1.821 1.244

26.424 27.668

4.008


36/44

Projected Monthly Term Loan statement - Phase I(Rs. in

Particulars Till date Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-0

No. of Month - 1 2 3 4 5 6 7 8 9 10 11

% of Work per Month - Site De - 1.00% 2.00% 2.00% 15.00% 20.00% 15.00% 10.00% 10.00% 10.00% 10.00% 2.00Civil Work commercial area - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.00% 2.00

other - 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 10.00% 10.00% 10.00

Advertising & Marketing Exp. - 0.50% 0.50% 0.50% 1.00% 1.50% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00

OUT FLOW

Land Cost 22.850 0.000 23.460 0.000 7.690 0.000 0.000 0.000 0.000 0.000 0.000 0.00

Site Development 0.000 0.100 0.200 0.200 1.500 2.000 1.500 1.000 1.000 1.000 1.000 0.20

Construction cost - Common Fac 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.600 0.600 0.60

Plant and Machineries/Equipme 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.470 0.470 0.47

Administrative Expenses(incl. U 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.125 0.125 0.12

Power & Other Deposits 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.050 0.050 0.05

Advertisement & Marketing Exp 0.000 0.004 0.004 0.004 0.008 0.011 0.023 0.023 0.023 0.023 0.023 0.02

Contigency

TOTAL 22.850 0.104 23.664 0.204 9.198 2.011 1.523 1.023 1.023 2.268 2.268 1.46

Term Loan interest 0.000 0.082 0.164 0.184 0.209 0.217 0.222 0.227 0.234 0.244 0.25Cumulative investment 22.850 22.954 46.618 46.821 56.019 58.030 59.553 60.575 61.598 63.865 66.133 67.60

Eligible for term loan 37.358 37.561 46.759 48.770 50.293 51.315 52.338 54.605 56.873 58.34


Term Loan DP for disbu 22.415 22.537 28.055 29.262 30.176 30.789 31.403 32.763 34.124 35.00

Term Loan disbursement 0.000 0.000 22.415 0.122 5.519 1.207 0.913 0.614 0.614 1.360 1.361 0.88


37/44

. Contd..

res) (Rs. in Crores)

Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Oct-08 Nov-08 Dec-08

24 25 26 27 28 29 30 31 32 33 34 35 36

0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 1.00% 0.00% 0.00% 0.00%

0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 2.00% 2.00% 2.00% 2.00% 2.00% 1.00%

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000

0.023 0.023 0.023 0.023 0.023 0.023 0.023 0.015 0.015 0.015 0.015 0.015 0.008

0.023 0.023 0.023 0.023 0.023 0.023 0.023 0.015 0.015 0.015 0.015 0.015 0.008

0.307 0.316 0.321 0.310 0.296 0.278 0.256 0.227 0.190 0.150 0.103 0.059 0.02079.533 79.555 79.578 79.600 79.623 79.645 79.668 79.683 79.698 79.713 79.728 79.743 79.750

70.273 70.295 70.318 70.340 70.363 70.385 70.408 70.423 70.438 70.453 70.468 70.483 70.490

2.405

42.164 44.582 42.191 42.204 42.218 42.231 42.245 42.254 42.263 42.272 42.281 42.290 42.294

0.014 2.418 0.005


38/44


Pro ected Monthl Cash FlowStatement - Phase I

Particulars Till date an-0

No. of Month - 1% of Work er Month - Site Develo ment - 1.00%

- Civil Work - 0.00%

- P & P Ex enses - 0.50%

OUT FLOW

Land Cost 22.850 -

Site Develo ment - 0.100

Civil Cost-Residential Bun low - -

-Commercial Areas - -

-Common Facilities - 0.060

-Architect's & En ineer's Fees - 0.050

Plant and Machineries E ui ments - -

Administrative Ex enses incl. U front & Le al Char es - 0.006

Power & Other De osits - 0.003

Advertisement & Marketin Ex enses - 0.004

Contin encies / Cost Escalation - -

Interest on Term Loan - -

Interest on Workin Ca ital Facilities - -

Re a ment of Term Loan - -

Pa ment of Income Tax - -

Internal Accurals used for Phase - II - -

TOTAL 22.850 0.223

INFLOW

Bookin Advance - -

Sales Realisation - Bun lows - -

- Commercial Area - -

E uit Share Ca ital 20.000 -

Redeemable Preference Share - -Unsecured Interest Free De osits 2.850 0.500

Creditors - -

Term Loan - -

TOTAL 22.850 0.500

O enin Balance - -

Cash Deficit / Sur lus - 0.278

Eli ible Workin Ca ital Facilities - -

Closin Balance - 0.278

Promoters' Contribution 22.850 23.350

Term Loan - -Workin Ca ital Outstandin - -

D.E.R. - -


39/44


Term Loan Interest & Repayment Sechedule

Term Loan Amount : 44.58 Rs.Crores

Rate of Interest : 8.75%

(Rs.Crores)

Quarter Month Opening

Balance

Disbrusement Repayment Closing

Balance

Interest

I Jan-06 - - - - 0.00Feb-06 - 22.41 - 22.41 0.08

Mar-06 22.41 0.12 22.54 0.16

II Apr-06 22.54 5.52 28.06 0.18

May-06 28.06 1.21 29.26 0.21

Jun-06 29.26 0.91 30.18 0.22

III Jul-06 30.18 0.61 30.79 0.22

Aug-06 30.79 0.61 31.40 0.23

Sep-06 31.40 1.36 32.76 0.23

IV Oct-06 32.76 1.36 34.12 0.24

Nov-06 34.12 0.88 35.00 0.25

Dec-06 35.00 0.82 35.82 0.26

V Jan-07 35.82 0.83 36.65 0.26

Feb-07 36.65 1.05 37.70 0.27

Mar-07 37.70 1.29 38.99 0.28

VI Apr-07 38.99 2.30 41.28 0.29

May-07 41.28 0.39 41.67 0.30

Jun-07 41.67 0.39 42.06 0.31

VII Jul-07 42.06 0.02 42.08 0.31

Aug-07 42.08 0.02 42.10 0.31

Sep-07 42.10 0.02 42.12 0.31

VIII Oct-07 42.12 0.02 42.14 0.31

Nov-07 42.14 0.01 42.15 0.31

Dec-07 42.15 0.01 42.16 0.31IX Jan-08 42.16 2.42 - 44.58 0.32

Feb-08 44.58 - 1.00 43.58 0.32

Mar-08 43.58 - 2.00 41.58 0.31

X Apr-08 41.58 - 2.00 39.58 0.30

May-08 39.58 - 3.00 36.58 0.28

Jun-08 36.58 - 3.00 33.58 0.26

XI Jul-08 33.58 - 5.00 28.58 0.23

Aug-08 28.58 - 5.00 23.58 0.19

Sep-08 23.58 - 6.00 17.58 0.15

XII Oct-08 17.58 - 7.00 10.58 0.10

Nov-08 10.58 - 5.00 5.58 0.06

Dec-08 5.58 - 5.58 - 0.02


40/44

Calculation of Booking Advance - Phase I

Quarter I II III IV V VI VII VIII IX X XI XII

Bunglow Type

Jan.06 to

Mar.06

Apr.06

to Jun.06

Jul.06

to

Sep.06

Oct.06

to

Dec.06

Jan.07

to

Mar.07

Apr.07

to

Jun.07

Jul.07 to

Sep.07

Oct.07 to

Dec.07

Jan.08 to

Mar.08

Apr.08 to

Jun.08

Jul.08 to

Sep.08

Oct.08 to

Dec.08

No. of Bunglows / Residential Building Booked

A - - - - - - 10 10 25 25 25 25

B - - - - - - 10 10 25 25 25 25C - - - - - - - - - - - -

D - - - - - - - - - - - -

Possession

A - - - - - - - - 15 20 30 30B - - - - - - - - 15 20 30 30

C - - - - - - - - - - - -

D - - - - - - - - - - - -

Booking Advance 5% 20%A 25.00 - - - - - - 12.50 62.50 81.25 156.25 156.25 281.25

B 33.00 - - - - - - 16.50 82.50 107.25 206.25 206.25 371.25C - - - - - - - - - - - - -

D - - - - - - - - - - - - -- - - - - - 29.00 145.00 188.50 362.50 362.50 652.50

Sale ProceedsA 25.00 - - - - - - - - 375.00 500.00 750.00 750.00

B 33.00 - - - - - - - - 495.00 660.00 990.00 990.00

C - - - - - - - - - - - - -D - - - - - - - - - - - - -

profit from bungalow A

profit from bungalow B- - - - - - - - 870.00 1,160.00 1,740.00 1,740.00

Less : Booking Advance - - - - - - - - 217.50 290.00 435.00 435.00Net Recepits on Possession - - - - - - - - 652.50 870.00 1,305.00 1,305.00

Cummulative booking advance 29.00 174.00 362.50 725.00 1,087.50 1,740.00

Less advance bookinng on possetion - - 217.50 290.00 435.00 435.00Net cummulative advance 29.00 174.00 145.00 435.00 652.50 1,305.00

Cost of bungalows sold 3.51 4.68 7.02 7.02Booking of commercial Area

Advance recived 5.00% 7.50% 12.50%

sales realisation 20.00% 30.00% 50.00%

Net sales realisation

Booking advance 27.00 1.35 2.03 3.38Sale of commercial area 5.40 8.10 13.50

Net sales realisation 4.05 6.08 10.13

Cost of commercial area s 7.50 1.50 2.25 3.75Cummulative booking advance 1.35 3.38 6.75 6.75

Less advance bookinng on possetion 0.00 1.35 2.03 3.38

Net cummulative advance 1.35 2.03 4.73 3.38


41/44


Projected Monthly Cash FlowStatement - Phase II

Particulars Oct-08 Nov-08 Dec-08

No. of Month 1 2 3

% of Work per Month - Civil Work 2.00% 2.00% 2.00%

- P & P Expenses 2.00% 2.00% 2.00%

OUT FLOWLand Cost - - -

Site Development - - -

Civil Cost-Residential Bunglow #REF! #REF! #REF!

-Commercial Areas #REF! #REF! #REF!

-Architect's & Engineer's Fees #REF! #REF! #REF!

Plant and Machineries/Equipments - - -

Administrative Expenses(incl. Upfront & Legal Charges) #REF! #REF! #REF!

Power & Other Deposits #REF! #REF! #REF!

Advertisement & Marketing Expenses #REF! #REF! #REF!

Contingencies / Cost Escalation - - -

Interest on Term Loan - - -

Interest on Working Capital Facilities - - -

Repayment of Term Loan - - -Payment of Income Tax - - -

TOTAL #REF! #REF! #REF!

INFLOW

Booking Advance - - -

Sales Realisation - Bunglows - - -

- Commercial Area - - -

Equity Share Capital - - -

Redeemable Preference Share - - -

Unsecured Interest Free Deposits - - -

Internal Cash Accruals of Phase - I 3.000 3.000 4.000

Creditors - - -

Term Loan - - -

TOTAL 3.000 3.000 4.000Opening Balance - #REF! #REF!

Closing Balance of Phase - I - - -

Cash Deficit / (Surplus) #REF! #REF! #REF!

Eligible Working Capital Facilities - - -

Closing Balance #REF! #REF! #REF!


Projected Profitability - Phase II

Particulars (Rs. in Crores)Sales Realisation

Bun lows 67.03C i l A #REF!


42/44


Term Loan Interest & Repayment Sechedule - Phase II

Term Loan Sanctioned Amount : 44.58 Rs.Crores

Outstanding Amount : - Rs.Crores

Rate of Interest : 8.75%(Rs.Crores)

Quarter Month Opening

Balance

Disbrusement Repayment Closing

Balance

Interest

I Jan-09 - - 5.58 (5.58) -

Feb-09 (5.58) - 5.58 (11.16) (0.04)

Mar-09 (11.16) - 5.58 (16.75) (0.08)

- 16.75 (0.12)

II Apr-09 (16.75) - 5.58 (22.33) (0.12)

May-09 (22.33) - 5.58 (27.91) (0.16)

Jun-09 (27.91) - 5.58 (33.49) (0.20)

- 16.75 (0.49)

III Jul-09 (33.49) - 5.58 (39.07) (0.24)

Aug-09 (39.07) - 5.58 (44.65) (0.28)

Sep-09 (44.65) - 5.58 (50.24) (0.33)

- 16.75 (0.85)

IV Oct-09 (50.24) - 5.58 (55.82) (0.37)

Nov-09 (55.82) - 5.58 (61.40) (0.41)

Dec-09 (61.40) - 5.58 (66.98) (0.45)

- 16.75 (1.22)

V Jan-10 (66.98) - 5.58 (72.56) (0.49)

Feb-10 (72.56) - 5.58 (78.15) (0.53)

Mar-10 (78.15) - 5.58 (83.73) (0.57)

- 16.75 (1.59)

VI Apr-10 (83.73) - 5.58 (89.31) (0.61)

May-10 (89.31) - 5.58 (94.89) (0.65)

Jun-10 (94.89) - 5.58 (100.47) (0.69)

- 16.75 (1.95)

VII Jul-10 (100.47) - 5.58 (106.05) (0.73)

Aug-10 (106.05) - 5.58 (111.64) (0.77)

Sep-10 (111.64) - 5.58 (117.22) (0.81)

- 16.75 (2.32)

VIII Oct-10 (117.22) - 5.58 (122.80) (0.85)

Nov-10 (122.80) - 5.58 (128.38) (0.90)

Dec-10 (128.38) - 5.58 (133.96) (0.94)

- 16.75 (2.69)

133.96 (11.23)

#REF! #REF! #REF!


43/44


Calculation of Booking Advance - Phase II

Quarter I II III IV V VI VII VIII

Bunglow TypeOct.08 to

Dec.08

Jan.09 to

Mar.09

Apr.09 to

Jun.09

Jul.09 to

Sep.09

Oct.09 to

Dec.09

Jan.10 to

Mar.10

Apr.10 to

Jun.10

Jul.10 to

Sep.10

Oc

No. of Bunglows / Residential Building BookedA - - 20 20 20 20 20 15

B - - 15 15 15 15 15 15C - - 2 2 2 2 3 2

D - - - - - - - -PossessionA - - - - 20 20 20 20

B - - - - 15 15 15 15C - - - - 2 2 2 2D - - - - - - - -

Booking Advance 5% 25%A 25.00 - - 25.00 125.00 125.00 125.00 125.00 118.75B 33.00 - - 24.75 123.75 123.75 123.75 123.75 123.75

C 27.00 - - 2.70 13.50 13.50 13.50 14.85 18.90

D - - - - - - - - -- - 52.45 262.25 262.25 262.25 263.60 261.40

Sale ProceedsA 25.00 - - - - 500.00 500.00 500.00 500.00 1,B 33.00 - - - - 495.00 495.00 495.00 495.00 1,3

C 27.00 - - - - 54.00 54.00 54.00 54.00D - - - - - - - - -

- - - - 1,049.00 1,049.00 1,049.00 1,049.00 2,

Less : Booking Advance - - - - 262.25 262.25 262.25 262.25Net Recepits on Possession - - - - 786.75 786.75 786.75 786.75 1,


44/44

Annexure - IV


Calculation of Carpet Area and Saleable (Super Built-up) Area

1. Total Plot Area 455,509 Sq.Mtr.2. 20% of Plot Area 91,102 Sq.Mtr.

3. Net Plot Area 364,407 Sq.Mtr.4. Area in Commercial 28,390 Sq.Mtr.5. Area in Residential 336,017 Sq.Mtr.

No. of Bunglows No. of

Bunglows

Total Area

Sq.Yds. Sq.Mtr. Sq.Mtr.Bunglow Type "A" 396 239 200 79,134Bunglow Type "B" 338 395 330 111,630

Bunglow Type "C" (average f 29 275 230 6,668Bunglow Type "D" 58 1,047 875 50,7746. Net Area in Residential 248,207

26.13%

Particulars Carpet

Area per

Bunglow

(Sq.Yards)

Saleable

Area per

Bunglow

(Sq.Yards)

Plot Area (Sq.Yards)

Bunglow Type "A" 239 301Bunglow Type "B" 395 498Bunglow Type "C" 275 347

Bunglow Type "D" 1,047 1,321

Constructed Areas (Sq.Yards)Bunglow Type "A" 198 250Bunglow Type "B" 290 366

Bunglow Type "C" 198 250Bunglow Type "D" 372 469

Net Plot Area

Excess Land Area in Common Facilities to be included for

Saleable Area((5-6)/5)

shashwat homes sensitivity

Documents