Assumptions

A Area Related Assumptions

Particulars Unit Value Notes for the Model

Land Area acre 7 Please fill details in all the tables where it is blank
Land Area Sq.m 28,300 Numbers in BLUE font is input assumption cell. Please put your numbers as per your p
Less: RG area Sq.m 10% Please do not try to input infomration in the cells with black font numbers
Less: Setback area Sq.m 67% Please do not change any formulas
Net Land area 6,509 Please note, T1, T2, T3 and so on, are Tower 1, Tower 2, Tower 3
FSI 1.80 Please look out for comments section on the cells marked with RED patch on right top c
FSI Sq.m 50,940 Please keep all values in 2 decimal places
FSI [Link]. 548,114
Conversion to carpet area 0.99
Carpet area [Link]. 544,023
Loading 1.33
Saleable area [Link]. 723,551
1 BHK 20% 144,710
2 BHK 57% 412,424
3 BHK 23% 166,417 1 BHK 144,234.8 20.00
FSI Area 2 BHK 413,156.2 57.00
1 BHK 20% 109,623 3 BHK 166,160 23.00
1.5 BHK 57% 312,425 723,551.0
2 BHK 23% 126,066

Sources of Funding
Equity & Debt Contribution INR cr
Hurdle rate for Taxation 25.00%
Tax Rate (based on amendements) 25.17%

B. Construction Cost Assumptions INR/[Link]

Structure - Civil Works INR/[Link] of salable 780
MEP INR/[Link] of salable 200
Finishing INR/[Link] of salable 300
Sub-Total INR/[Link] 1,280
Infrastructure INR/[Link] of Salable Area 150
Total INR/[Link] 1,430
Approvals Charges INR per sqft 110
 Architect & Consultants Fees % of Construction Cost 1.00%
Marketing & Other Overheads % of Sales Value 1.00%
Contingencies % of Construction Cost 0.50%
Development Management Fees % of Sales Collection

Construction Cost Escalation p.q. % 0.00%

Unit Size Break up 1 BHK 2 BHK 3 BHK <please note, enter weighted average areas for respective units if there is more than 1 varient in either of 1,2 or
Bedroom 145.30 279.64 479.20
Study Room - -
Utility -
Kitchen 76.85 81.37 96.12
Living/Dining 235.00 324.10 430.72
Bathroom 46.40 81.37 128.73
Balcony 102.30 100.42 167.05
Total 605.85 866.9 1,301.8
Carpet Area as per RERA 605.85 866.90 1,301.82

C Revenue Assumptions

Particulars Unit Value

Saleable Area 723551 [Link]. 2,230,458,057
Residential area 723551 [Link]. 2,230,458,057
Residential Overview
Total No. of Flats 633 10

Sold Flats 167 167.00

Unsold Flats 466 (157.00)
Total Saleable area 723551 [Link] 2,230,458,057
Sold Area 206920 [Link] 521,151,395
Unsold area 516631 [Link] 1,709,306,662
Base Selling price INR psft. 3,500
Price escalation % p.q. 0.00%
As per Excel sheet attached
Types Saleable area (sft) Unit Size (sft) No of Units Units per floor No of floors No of Towers Cumulative
1.0 144,710 806 179 8 14 2.00 2.00
2.0 412,424 1,153 358 8 14 3.00 5.00
3.0 166,417 1,731 96 8 14 1.00 6.00
Amenity Area
Total 723,551 633

C Project Cost Break-up Tower wise break-up

Project Total (incl. GST) Tower A
 Cost incurred till Cost to be Cost incurred Cost to be
Project Total
date incurred till date incurred

Land INR cr 18.96 - 18.96

Construction Costs (incl. amenities cost) INR cr 42.92 59.08 102.00
Development Cost INR cr 3.20 - 3.20
Approvals-related Costs INR cr 3.80 0.70 4.50
Architect & Consultant Fees INR cr 0.39 0.86 1.25
Marketing & Other Overheads INR cr 0.38 0.87 1.25
Contingencies INR cr - - -
Admin Cost INR cr 7.60 1.90 9.50
Other Cost INR cr 0.35 0.40 0.75
RERA Penalties (for delay) INR cr - - -
Interest Cost INR cr 18.54 4.46 23.00
Project Management Fees INR cr - - -
Total 96.14 68.27 164.41 - -
PLEASE PROVIDE INCLUDING GST COST DETAILS

D Sales & Construction Schedule

Wt. Average No of car parks Car park area
Residential Unit Type No. of Units Approved? Total Car park
Unit Size ([Link].) per unit in sft
1 1 BHK 70 821 Yes - -
Wing A
2 BHK 13 1,151 Yes 1 13 135
2 1 BHK 11 809 Yes - -
WING B
2 BHK 45 1,164 Yes 1 45 135
1 BHK 11 809 Yes - -
WING C
2 BHK 45 1,164 Yes 1 45 135
3 1 BHK 13 799 Yes - -
WING D 2 BHK 14 1,186 Yes 1 14 135
3 BHK 28 1,751 Yes 1 28 135
4 2 BHK 27 1,120 Yes 1 27
WING E
3 BHK 28 1,706 Yes 1 28 135
1 BHK 26 748 Yes - -
WING F 2 BHK 28 1,127 Yes 1 28 135
3 BHK 14 1,780 Yes 1 14 135
1 BHK 10 806 Yes - -
WING G
2 BHK 45 1,163 Yes 1 45 135
1 BHK 10 805 Yes - -
WING H
2 BHK 45 1,163 Yes 1 45 135
1 BHK 28 823 Yes - -
WING I
2 BHK 68 1,161 Yes 1 68 135
2 BHK 28 1,709 Yes 1 28 135
WING J
3 BHK 26 1,120 Yes 1 26 135

Total 633 1,131

E Historcial Performance
Amount Construction
Area sold till Sales price achieved Sales Revenue till
Residential Phase Units sold till date collected till Cost incurred till
date till date date
date date
Wing A Phase 4 11 12,656 3,356 4 4 11
Wing B 16 18,152 2,588 5 1
Wing C 13 15,259 2,270 3 1
Wing D Phase 3 18 25,837 2,434 6 1 14
Wing E 11 15,251 2,540 4 1
Wing F Phase 2 22 25,804 2,572 7 2 19
Wing G 15 16,371 2,437 4 1
Wing H 5 5,895 2,421 1 1
Wing I 25 27,557 2,333 6 3
Wing J Phase 1 31 44,137 2,568 11 3 53
Total 167 206,919 52 18 97

Construction
Others Unit Type Total No. of Units Cost (INR psft.) Total Costs
Area ([Link].)
Infra & Landscaping 633 729,899 150 10.9
Total Approval Costs 729,899 110 8.0

Financing Assumptions

Existing Situation (In Crores)

Particulars Value
Equity 10.00
Sales Proceeds 24.48
Project Loan 15.83
USL and Other Advances 45.87
Total Investment 96.18

Cost Phasing
Particulars Till Date 3/31/2020 6/30/2020 9/30/2020 12/31/2020 3/31/2021 6/30/2021
Construction Phasing This is only cost of construction and should not include cost of infra and landscape, approvals and marketing.
Wing A 10.0% 10.0% 10.0%
Wing B 12.5% 10.0% 10.0% 10.0% 10.0%
Wing C 12.5% 10.0% 10.0% 10.0% 10.0%
Wing D 12.5% 10.0% 10.0% 10.0% 10.0%
Wing E 31.0% 1.0% 10.0% 10.0% 10.0% 10.0% 10.0%
 Wing F 48.0% 2.0% 10.0% 10.0% 8.0% 8.0% 6.0%
Wing G 50.0% 5.0% 10.0% 8.0% 8.0% 7.0% 5.0%
Wing H 57.0% 7.0% 7.0% 7.0% 6.0% 6.0% 5.0%
Wing I 77.0% 4.0% 4.0% 4.0% 3.0% 3.0% 2.0%
Wing J 81.0% 4.0% 3.0% 3.0% 2.0% 2.0% 2.0%
etc (Please extend this table to total number of towers in the project which are under construction only)

Infra & Landscaping 60.0% 0.00% 0.00% 0.00% 0.0% 5.0% 5.0%
Approval 95.0% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Administration Cost 1.90 Crores <please highlight cost to be incurred till the end of the project in INR cr
Administration Cost Phasing 3.00% 4.50% 4.50% 4.50% 4.50% 4.50%

Architech & Other Professional Fees 0.86 crores <please highlight cost to be incurred till the end of the project in INR cr
Architech & Other Professional Fees 5.00% 5.00% 5.00% 5.00% 5.00% 5.00%

Marketing and Brokerage 0.87 crores <please highlight cost to be incurred till the end of the project in INR cr
5.00% 5.00% 5.00% 5.00% 5.00% 5.00%

Project Management Fees 0.40 crores <please highlight cost to be incurred till the end of the project in INR cr
5.00% 5.00% 5.00% 5.00% 5.00% 5.00%

Sales Velocity Phasing

Particulars Till Date 3/31/2020 6/30/2020 9/30/2020 12/31/2020 3/31/2021 6/30/2021
this is percentage of salable are sold for a given quarter
Wing A 13.25% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Wing B 28.57% 0.00% 0.00% 0.00% 0.00% 1.79% 3.57%
Wing C 23.21% 0.00% 0.00% 0.00% 0.00% 3.57% 3.57%
Wing D 32.73% 0.00% 0.00% 0.00% 0.00% 1.82% 3.64%
Wing E 20.00% 0.00% 0.00% 3.64% 5.46% 7.27% 3.64%
Wing F 32.35% 0.00% 0.00% 2.94% 2.94% 4.41% 2.94%
Wing G 27.27% 0.00% 3.64% 5.46% 5.46% 7.27% 9.09%
Wing H 9.09% 0.00% 1.82% 3.64% 7.27% 7.27% 9.09%
Wing I 26.04% 2.08% 3.13% 5.21% 6.25% 4.17% 3.13%
Wing J 57.41% 1.85% 1.85% 3.70% 5.56% 3.70% 5.56%
etc (Please extend this table to total number of towers in the project which are under construction only)

Collection Phasing
Particulars Till Date 3/31/2020 6/30/2020 9/30/2020 12/31/2020 3/31/2021 6/30/2021
Collection (% of Sales) This is cumulative collection schedule for each tower
Wing A 15.51% 15.51% 15.51% 15.51% 15.51% 20.00% 30.00%
Wing B 5.97% 5.97% 12.50% 22.50% 32.50% 42.50% 52.50%
Wing C 4.16% 4.16% 12.50% 22.50% 32.50% 42.50% 52.50%
Wing D 5.71% 5.71% 12.50% 22.50% 32.50% 42.50% 52.50%
Wing E 2.78% 2.78% 42.00% 52.00% 62.00% 72.00% 82.00%
 Wing F 9.02% 9.02% 60.00% 70.00% 78.00% 86.00% 92.00%
Wing G 5.53% 5.53% 65.00% 73.00% 81.00% 88.00% 93.00%
Wing H 3.52% 3.52% 71.00% 78.00% 84.00% 90.00% 95.00%
Wing I 8.27% 8.27% 85.00% 89.00% 92.00% 95.00% 97.00%
Wing J 12.26% 12.26% 88.00% 91.00% 93.00% 95.00% 97.00%
etc (Please extend this table to total number of towers in the project which are under construction only)
 tion cell. Please put your numbers as per your project status
n the cells with black font numbers

Tower 1, Tower 2, Tower 3

n the cells marked with RED patch on right top corner for directions

179 805.781005586592 596.874818953031

358 1154.06759776536 854.864887233602
96 1730.83333333333 1282.0987654321
633
s if there is more than 1 varient in either of 1,2 or 3 BHK

FSI Area Construction Area Car Parking Ratio

109,623 144,340
312,425 411,370
126,066 165,991
8,197
548,114 729,899

Tower B Tower C Tower D Tower E Tower F

 Cost
Cost to be Cost incurred Cost to be Cost to be Cost incurred Cost to be
Cost incurred till date Cost to be incurred Cost incurred till date incurred till
incurred till date incurred incurred till date incurred
date

- - - - - - - - - -

Construction Area Saleable Construction

Total Car Park Area in sqft FSI Area ([Link].)
([Link].) Area(sft) Cost (INR psft.)
- 80,155 56,472 57,470 1,430 P
1,755 14,963 1,430
- 61,854 45,743 8,899 1,430
6,075 52,380 1,430
- 61,854 45,743 8,899 1,430
6,075 52,380 1,430
- 10,387 1,430
1,890 73,243 58,739 16,604 1,430
3,780 49,028 1,430
- 30,240 1,430
76,725 58,175
3,780 47,768 1,430
- 19,448 1,430
3,780 79,836 57,514 31,556 1,430
1,890 24,920 1,430
- 8,060 1,430
61,712 44,803
6,075 52,335 1,430
- 8,050 1,430
61,712 44,803
6,075 52,335 1,430
- 23,044 1,430
106,728 78,180
9,180 78,948 1,430
3,780 47,852 1,430
66,079 57,942
3,510 29,120 1,430

729,899 548,114 724,686

Construction Cost incurred
(%)

11%

14%

20%

55%
1

9/30/2021 12/31/2021 3/31/2022 6/30/2022 9/30/2022 12/31/2022 3/31/2023 6/30/2023 9/30/2023 Check

10.0% 10.0% 10.0% 10.0% 8.0% 8.0% 6.0% 6.0% 2.0% 100.00% <this should not be more than 100%
10.0% 10.0% 9.0% 8.0% 8.0% 2.5% 100.00% <this should not be more than 100%
10.0% 10.0% 9.0% 8.0% 8.0% 2.5% 100.00% <this should not be more than 100%
10.0% 10.0% 9.0% 8.0% 8.0% 2.5% 100.00% <this should not be more than 100%
8.0% 5.0% 5.0% 100.00% <this should not be more than 100%
 4.0% 2.0% 2.0% 100.00% <this should not be more than 100%
4.0% 3.0% 100.00% <this should not be more than 100%
3.0% 2.0% 100.00% <this should not be more than 100%
2.0% 1.0% 100.00% <this should not be more than 100%
2.0% 1.0% 100.00% <this should not be more than 100%

5.0% 5.0% 8.0% 8.0% 0.0% 4.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.00% 0.00% 3.0% 0.0% 0.0% 0.0% 0.0% 0.0% 2.0% 0.0% 0.0% 0.0%

5.00% 5.00% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%

5.00% 5.00% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%

5.00% 5.00% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%

5.00% 5.00% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%

9/30/2021 12/31/2021 3/31/2022 6/30/2022 9/30/2022 12/31/2022 3/31/2023 6/30/2023 9/30/2023 12/31/2023 3/31/2024 6/30/2024

2.41% 0.00% 2.41% 2.41% 3.61% 3.61% 3.61% 2.41% 4.82% 6.02% 8.43% 12.05%
3.57% 3.57% 5.36% 5.36% 7.14% 5.36% 3.57% 1.79% 5.36% 3.57% 0.00% 1.79%
5.36% 3.57% 7.14% 7.14% 5.36% 8.93% 5.36% 5.36% 7.14% 5.36% 5.36% 3.57%
3.64% 5.46% 3.64% 5.46% 5.46% 5.46% 3.64% 5.46% 3.64% 5.46% 5.46% 5.46%
5.46% 7.27% 1.82% 5.46% 5.46% 5.46% 7.27% 5.46% 0.00% 3.64% 3.64% 3.64%
2.94% 5.88% 2.94% 2.94% 4.41% 2.94% 4.41% 4.41% 5.88% 5.88% 5.88% 5.88%
7.27% 5.46% 5.46% 3.64% 7.27% 0.00% 5.46% 3.64% 3.64% 0.00% 0.00% 0.00%
5.46% 7.27% 7.27% 5.46% 7.27% 9.09% 5.46% 5.46% 5.46% 3.64% 0.00% 0.00%
4.17% 5.21% 7.29% 5.21% 5.21% 4.17% 5.21% 4.17% 3.13% 3.13% 3.13% 0.00%
5.56% 3.70% 3.70% 5.56% 1.85% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

9/30/2021 12/31/2021 3/31/2022 6/30/2022 9/30/2022 12/31/2022 3/31/2023 6/30/2023 9/30/2023 12/31/2023 3/31/2024 6/30/2024

40.00% 50.0% 60.0% 70.0% 78.0% 86.0% 92.0% 98.0% 100.0% 100.0% 100.0% 100.0%
62.50% 72.5% 81.5% 89.5% 97.5% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
62.50% 72.5% 81.5% 89.5% 97.5% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
62.50% 72.5% 81.5% 89.5% 97.5% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
90.00% 95.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
96.00% 98.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
97.00% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
98.00% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
99.00% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
99.00% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%
Conversion Parameter
Particulars Acre Sq.m
Acre 1.00 4,046.86
Sq.m 0.00 1.00
[Link] 0.00 10.76
be more than 100%
be more than 100%
be more than 100%
be more than 100%
be more than 100%
be more than 100%
be more than 100%
be more than 100%
be more than 100%
be more than 100%

0.0% 0.0% 0.0% 100.00% <this should not be more than 100%
0.0% 0.0% 0.0% 100.00% <this should not be more than 100%

5.0% 5.0% 4.5% 100.00% <this should not be more than 100%

5.0% 5.0% 0.0% 100.00% <this should not be more than 100%

5.0% 5.0% 0.0% 100.00% <this should not be more than 100%

5.0% 5.0% 0.0% 100.00% <this should not be more than 100%

9/30/2024 12/31/2024 3/31/2025 Check

12.05% 10.84% 12.05% 100.0% <this should not be more than 100%
5.36% 7.14% 7.14% 100.0% <this should not be more than 100%
0.00% 0.00% 0.00% 100.0% <this should not be more than 100%
3.64% 0.00% 0.00% 100.1% <this should not be more than 100%
5.46% 0.00% 0.00% 100.1% <this should not be more than 100%
0.00% 0.00% 0.00% 100.0% <this should not be more than 100%
0.00% 0.00% 0.00% 100.0% <this should not be more than 100%
0.00% 0.00% 0.00% 100.0% <this should not be more than 100%
0.00% 0.00% 0.00% 100.0% <this should not be more than 100%
0.00% 0.00% 0.00% 100.0% <this should not be more than 100%

9/30/2024 12/31/2024 3/31/2025 Check

100.0% 100.0% 100.0%

100.0% 100.0% 100.0%
100.0% 100.0% 100.0%
100.0% 100.0% 100.0%
100.0% 100.0% 100.0%
100.0% 100.0% 100.0%
100.0% 100.0% 100.0%
100.0% 100.0% 100.0%
100.0% 100.0% 100.0%
100.0% 100.0% 100.0%
 [Link]
43,560.00
0.09
1.00
 Project Configurati

Project _______

Phase/ Block Building No. of Floors Unit per Flat Type

No. No./Name Floor (2/3/4BHK)

A BASEMENT+STILT+14
PHASE 1
A BASEMENT+STILT+14
C
PHASE 2
D
E
PHASE 3
F
G
H
PHASE 4
I
J

Total
Commercial NIL
Project Configuration

Carpet Area in sft Saleable Area No of Units Total Carpet Area in Total Saleable Area
in sq. ft. sqft in sq. ft.

- - - - -
Total FSI Area in Total Construction
sft Area in sft

- -
PROJECT SPECIFIC DETAILS

Location and Access

The Project is located at along xxx (Pls mention in detail the location, key landmarks, selling points of the Project etc).
Various Industries like Hero Honda, Honda Scooters, Shree Cements, Kajaria etc. have industrial presence in and around
driving factor for demand of residential units in the micro market. (Pls mention key demand drivers for the location
manufacturing cos, IT etc)

Land details
Land details
Land Area: xx acres of freehold land
Zoning: Residential use
Ownership details: XYZ Pvt Ltd had acquired ~xx acres of land for Rs. Xx crore in (year). This is a freehold / leasehold land on a
and all the payments have been made to the authorities/ seller. (Pls mention in detail the arrangement if the land owning enti
development entity is different).

FSI: Maximum Permissible FSI is 2.25 which includes Basic FSI of 1.33 and 0.92 Purchasable FSI + Incentive FSI for 0.5
Obligations + FSI against area handed over.

Project has achieved FSI of 1.92 (Basic FSI of 1.33, Purchasable FSI of 0.06, 0.5 FSI against EWS/LIG Obligations, and 0.03 for R
Over). (Pls mention applicable details essentially explaining the scheme under which project is being implemented, FSI availa
and other details )
(PLS PROVIDE DETAILS OF ALL UNITS - BOTH SOLD AND UNSOLD UNITS)

Booking Registration/ Date of completion as Amount recd. Till Date of

Sr. No.
date Agreement date per Agreement* Completion in 3 (Cr)

1 2 3 4
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Total
 Project details

Unit Type Saleable Area

Unit No. Tower Name Unit Config. Sold / Unsold Customer Name
(Resi/Comm) (Sq. ft.)

-
 SALES MIS
Sales Consid

RERA Carpet Area Aggrement Club Car Other

(Sq. ft.) Value Charges Parking charges

A B C D

- - - - -
 Sales Consideration (excl. taxes) - Cr

Total Sales Amount demanded Amount Recd

Sale price (Carpet) Sale price (Saleable)
Value (excl taxes) (excl taxes)

A+B+C+D = E Rs psf Rs psf F G

- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a.
- n.a. n.a. - -
 Taxes (GST, VAT, ST etc.)

Receivable Demanded yet Total tax Amount Amt

Receivable
(excl taxes) unpaid amount demanded Recd

E-G=H F-G=I J K L J-L=M

- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - - - -
 Total (incl. taxes) Mode of Sales

Amount Own/ Broker/ CP/ Name of

Total consideration Amount Recd
receivable Others Broker/ CP/ Others

E+J G+K H+M

- - - Direct Sales eg only
- - - Broker Magic Bricks
- - - CP Anarock, Xanadu
- - - Others Customer referrals
- - - Barter
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
 OTHER DETAILS
Sales Payment Plan
Brokerage Payment Plan
Amount paid under
(Rs psf on (CLP/ Subvention/ Payment Plan Detail
saleable area) Others) Subvention till date

eg only
20:80
10:90
Higher down payment
OTHER DETAILS
Bank Details
Estimated Loan Amt
Comments / Any Home Loan Loan Amt Bank/ Inst.
balance amount Sanctioned
(to be paid) Highlights (Y/N) (Rs) Disbursed (Rs) Name

Cr Cr
eg only
No floor rise
No GST
ank Details

Rate of Loan Tenure Comments /

Interest (%) (Yrs) Any Highlights
 Sr No Construction Milestone Cumulative Construction Cost (%) Payment
1 Booking 10% 10%
2 Plinth 20% 20%
3 1st Slab 30% 8%
4 2nd Slab 35% 8%
5 3rd Slab 40% 8%
6 4th Slab 45% 8%
7 5th Slab 50% 8%
8 6th Slab 55% 8%
9 7th Slab 60% 8%
10 Brickwork & Flooring 80% 8%
11 Painting 90% 5%
12 Possesion 100% 1%

Note
Cumulative construction cost to be mentioned in Column C
Cumulative Payment
10%
30%
38%
46%
54%
62%
70%
78%
86%
94%
99%
100%
Config wise details
Saleable Total Saleable
Type No. Of Units
Area(sqft) Area (sqft)

2 BHK

3 BHK

1 BHK
Shops
Total 0 0

Home loan details

Particulars Unit % of total cases Area Sold

Home Loan 119 50.20% 122,051

Self-Funding 118 49.80% 118,123
Total 237 100.00% 240,174

Year on Year gross Cancellation Cases

Particulars Units
2010 0
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
Total 0

Project Amenities
Area sold Area Sold
Saleable Area %
(sq. ft.) No of units

0 0

Sale Value
Amt recd. % Collection
(Cr)
32.8 24.6 75%
30.7 21.2 69%
63.5 45.8 72%
Key Comparable Projects
Total
Name of Project Developer Location
Units
Unsold Saleable rate
(INR/sft)
units
List of All Approvals
Approval Issuing Authority
RERA Registration
Fire Safety Certificate
Airforce NOC
Pollution NOC
Environment Clearance
Consent to Establish
IOD
CC
LOI
OC

List of key consultants involved in the project

Sr. no. Scope
1 Master plan
2 Architectural
3 Civil Structural
4 Landscape
5 MEP
6 Electrical (Standalone)
7 Other important contractors
 Issue Date Validity If expired, timelines for renewal

Name
 COST BREAKUP of PROJECTS

Cost of Project (INR CR) Total Project

Uses of funds Already incurred To be incurred Total
FSI/TDR Cost - - -
Infrastructure cost - - -
Land Cost - - -
Construction cost - - -
Rehab Const Cost - - -
Approvals-related Costs - - -
Admin cost - - -
Marketing & sales cost - - -
Subvention Cost - - -
Contingencies - - -
Finance Cost - - -
Delay Penalty - - -
Other cost - - -
Total cost* - - -
Means of Finance (INR Cr)
Source of funds Already brought in To be brought Total
Equity
Sales Proceeds
Project Loan
Others
Total Funds - - -
PLS PROVIDE TOWER WISE BREAK-UP OF COSTS (whichever possible)

Tower 1 Tower 2
Already incurred To be incurred Total Already incurred To be incurred Total
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- - - - - -
 Tower 3
Already incurred To be incurred Total
-
-
-
-
-
-
-
-
-
-
-
-
-
- - -
Cashflows for last 8 qtrs
30-Sep-20 30-Jun-20 31-Mar-20 31-Dec-19
Inflows - - - -
Sold receivables
New sales
Equity contribution
Debt infusion

Outflows - - - -
Approvals
Construction
Interest
Others

Net Cashflow - - - -
30-Sep-19 30-Jun-19 31-Mar-19 31-Dec-18 30-Sep-18
- - - - -

- - - - -

- - - - -
 This is Sample Format…Kindly change/customise the same as per your pr

Structural Work
Excavation RCC
TOWER-1 100% 100%
TOWER-2 100% 100%
TOWER-3 100% 100%
BUILDING-1 100% 100%
BUILDING-2 100% 100%
BUILDING-3 100% 100%
BUILDING-4 100% 100%
BUILDING-5 100% 100%
BUILDING-6 100% 100%
BUILDING-7 100% 100%
BUILDING-8 100% 100%
BUILDING-9 100% 100%
BUILDING-10 100% 100%
EWS 100% 100%

% Completion
0%-25%
26%-50%

Total Est.
Blocks Construction Status
constn Cost
Block 1 Plastering paint in progress. Door & window fixing in progress
Block 2 RCC work completed, brick work in progress.
Block 3 RCC work completed, brick work in progress.
RCC work done, plastering, flooring & wooden frame work in
Block 4
progress.
Block 5 RCC work done, brick work in progress
Block 6 RCC foundation & plinth beams done
Block 7 RCC foundation & plinth beams done
Block 8 RCC and brick work done, wooden frame work in progress
Block 9 RCC & brick work done, flooring & paint work in progress
Block 10 Completed except finishing item
Total 0
the same as per your project configuration

ructural Work MEP

BrickWork Internal Plaster External Plaster Flooring Mechanical Electrical Plumbing
100% 100% 80% 0% 0% 0% 100%
100% 100% 80% 0% 0% 0% 0%
100% 100% 50% 0% 0% 0% 0%
100% 100% 100% 90% 67% 0% 100%
100% 100% 100% 90% 67% 10% 100%
100% 100% 90% 90% 33% 0% 100%
100% 100% 90% 90% 33% 0% 100%
100% 100% 90% 90% 33% 0% 100%
100% 100% 90% 90% 33% 0% 100%
100% 100% 90% 0% 0% 0% 0%
100% 100% 90% 0% 0% 0% 0%
100% 100% 50% 0% 0% 0% 0%
100% 100% 40% 0% 0% 0% 0%
80% 0% 40% 0% 0% 0% 0%

Color Code % Completion Color Code

51%-75%
76%-100%

%
Cost incurred (Cr)
incurred
#DIV/0!
#DIV/0!
#DIV/0!

#DIV/0!

#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0 #DIV/0!
 Finishing
Internal External
0% 15%
0% 8%
0% 8%
60% 70%
60% 70%
50% 55%
50% 55%
50% 55%
50% 10%
0% 10%
0% 10%
0% 0%
0% 0%
0% 0%
Please copy/paste Excel P&L And B/s for the Project SPV And HoldCo here

Profit and Loss Account (In INR Lakhs/ INR cr - mention)

Period Ending 31-Mar-18 31-Mar-19
Revenue from Operations
Other Income
Total Income
Depreciation and Amortization
Employees Cost
Finance Cost
Other Expenses
Total Expense
Profit Before Tax
Current Tax
Deferred Tax
Total Tax
Profit After Tax

Balance sheet (In INR Lakhs/ Cr - pls mention)

Period Ending 31-Mar-18 31-Mar-19
Share Capital
Other Equity
Reserves & Surplus
Total Equity
Borrowings (Long term)
Financial Liabilities
Other Provisions & Deferred Tax
Non-Current Liabilities
Borrowings(Short term)
Trade Payables
Other Current Liabilities
Financial Liabilities
Provisions
Tax Liabilities
Current Liabilities
Total Liabilities
Inventories
Other CA and Financial Assets
Current Assets
Non- Current Assets
Total Assets
31-Mar-20

31-Mar-20
Key Management Team
Name Designation Experience
Director
Director
Architect
Structural Design Engineer
Project Manager
General Manager
Others

Project Team Details

Team Team Head No of employees
Construction
Architect
Legal
Finance
Sales & Mktg
Others

Total 0
Key experience

Any remarks
 Holding Company Details

Shareholding Pattern
Sr No. Stakeholder No of Shares held % Shareholding Shares held in Physica/Demat Form
1
2
Total

List of Directors
Sr No Name of DirecDIN Effective from Valid upto
1
2
3

SPV Details

Shareholding Pattern
Sr No. Stakeholder No of Shares held % Shareholding Shares held in Physica/Demat Form
1
2
Total

List of Directors
Sr No Name of DirecDIN Effective from Valid upto
1
2
3

Landholding Entity

Shareholding Pattern
Sr No. Stakeholder No of Shares held % Shareholding Shares held in Physica/Demat Form
1
2
Total

List of Directors
Sr No Name of DirecDIN Effective from Valid upto
1
2
3
Group's Strengths & Challenges
Strengths
Challenges
Completed Projects
SBA
Project name Location City
(Lac sqft)

Total 0

Ongoing Projects
SBA
Project name Location City
(Lac sqft)

Total 0

Upcoming projects
SBA
Project name Location City
(Lac sqft)
Total 0
 Structure # of
Completion year
configuration
units

Structure # of
Completion year
configuration units

Structure # of
configuration Completion year
units
0
SPV Debt
Sr. No. Name of the Lender Project Name Location Borrowing Entity

1
2
3
4
5
6
7
8
9
10
11
Total

Group Level Debt

Sr. No. Borrowing Entity Sanction Amount Disburseme
nt Amount
Amount O/s as on
date
1
2
3
4
5
6
7
8
9
10
11
Total
 Repayment Start Repayment End
Sanction Amount Disbursement Amount Amount O/s as on date Date Date

Repayment Start Repayment End Date ROI Ṇ,MQBW

Date
ROI Security Offered