0% found this document useful (0 votes)
28 views8 pages

Final - Malvia Nagar DCF

The document outlines a real estate development project including land area, permissible FAR, saleable areas, parking requirements, and construction costs. It provides detailed financial projections, including revenue assumptions, cash flow projections, and cost estimates for both super and sub-structures. Additionally, it includes WACC estimates and NPV calculations for the project, indicating a potential for significant revenue generation over the development period.

Uploaded by

Surbhi Zutshi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
28 views8 pages

Final - Malvia Nagar DCF

The document outlines a real estate development project including land area, permissible FAR, saleable areas, parking requirements, and construction costs. It provides detailed financial projections, including revenue assumptions, cash flow projections, and cost estimates for both super and sub-structures. Additionally, it includes WACC estimates and NPV calculations for the project, indicating a potential for significant revenue generation over the development period.

Uploaded by

Surbhi Zutshi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Details Acres sqm

Land Area 4.8301071152 19,547


Land value per acre 60
Maximum Permissble FAR Area 3
Maximum permissible FAR area 631,198 [Link].

FSI Distribution
Residential GH 50% 315,599
Commercial & Retail 30% 189,360

Saleable Areas Loading factors


Residential GH 1.35 426,059
Commercial Retail 1.4 265,103

Parking Requirement
No. of Dwelling Units in GH

Product mIx for Resi GH Saleable Area % Distribution


1BHK/ Studio Apartment 550 20%
2 BHK 1200 40%
3 BHK 1800 30%
4 BHK 2200 10%
Total

Weighted Average Salebale Area per unit 1,102 [Link].

Parking Requirement
ECS for Residential 2 776
Commercial 3 528
Total Parking Space Required 1,304

Basement Reuired
Land Area unitlized for basement 60% 11,728
Basement 32 sqm
Stilt 30 sqm
Open 28 sqm

No. of cars that can be accomodated in basement 367


No. of Basements 3.0
No. of cars in 3 Basements 1,100

Remaing carparking space 204 ECS


Open 5,719 sqm
Percentage of site under open car park 29%

Total Area of basement to be constructed 378,719 [Link].


Total Built-up area
Super Structure 504,959 [Link].
Non FAR Super Structure 75,744 [Link].
Sub Structure 378,719 [Link].
959,422 [Link].

Total Salebale Areas


Residential GH 426,059 [Link].
Commercial Retail 265,103 [Link].

Costing Assumptions INR


Cosntruction Cost Super Structure 2,200 on BUA
Construction Cost Sub Structure + other Non FAR
Area 1,800 on BUA
Site Development Cost 250 on BUA
Approvals & Permissions 50 on BUA
Admin & Overheads 100 on BUA
Consultant & PMC 75 on BUA
Contingency 3% on Development Cost
Marketing & Brokerage 5% on Sales Revenue
Annual Cost Escalation 5%

Revenue Assumptions
Starting Sale Price for Residential 9,000
Starting Sale Price for Commercial 12,000
Annual escalation in sale Price 6%

Construction Timeline
No. of Years 1 2
Percentage of Work Completed
Super Structure 15%
Sub Structure + Non FAR Area 10% 40%
Site Development

Sales Velocity 1 2
Residential 19
Commercial 5%

Cashflow projection
No. of Years 1 2
Outflows
Super Structure Area Constructed - 75,744
Cost of Construction of Super Area 2,200 2,310
Sub Structure & Non FAR Area Constructed 45,446.28 181,785.13
Cost of Construction of Sub Structure & Non FAR
Area 1,800 1,890
Total Construction Cost Incurred 8.18 51.85
Area of Site Developed ([Link].) - -
Cost of Site Development 250 263
Site Development Cost incurred - -

Other Additional Costs


Approvals & Permissions 1.92 0.48
Admin & Overheads 0.45 2.58
Consultant & PMC 0.34 1.93
Contingency 0.25 1.56
Total Other Additional Costs 2.96 6.54

Total Project Development Cost 300.95 58.40

Revenue Projections 1 2
No. of GH Apartments sold 0 19.4
Area of GH sold - 21,373
Sale Rate 9,000 9,540
Total Sales - 20.39
1 15%
2
3
4
5
Total Sales Revenue Received 3.06
Marketing & Brokerage Cost - 1.02
Net Revenue from Sales of GH - 2.04

Revenue from Sale of Commercial Space


Years 1 2
Percentage of Commercila Area sold - 0.05
Commercial Area sold - 13,255
Sale Price of Commercial 12,000 12,720
Total Revenue from Commercial - 17
Marketing & Brokerage Cost - 0.84
Net Revenue from Sales of GH - 16.02

Total Revenue from Sale in the project - 18.06

Net Cash flows from the Project


Years 1 2
Net Cash Flow -300.95 -40.34

WACC Estimate
Cost of Debt 12%
Cost of Equity 24%
Debt Weightage 2
Equity Weightage 1

WACC - Discount Rate 16%

NPV of the land ₹ 30.61 INR Cr.

-59.23 -54.61

Years 7/11/2025 7/11/2026


Net Cash Flow -300.95 -40.34

YR 1 (11-07-2025) YR 2 (11-07-2026)
Total Project Development Cost 300.9 58.4
Total Revenue from Sale in the project 0.00 18.06
Net Cash Flow -300.95 -40.34

WACC - Discount Rate 0.16

NPV of project 35 INR Cr


IRR 20%
[Link].
210,399

58,640.30 Sq.m

[Link].
[Link].

No. of Units of
each Type No. of Units Actual
154.93 155
142.02 142
71.01 71
19.37 20
388

ECS
ECS
ECS

sqm Effective parking area ≈ 60%–75% of the plot area per basement level.
3 4 5

25% 30% 30%


20% 15% 15%
33% 33% 34%

3 4 5
155 155 58
40% 40% 15%

3 4 5

126,240 151,488 151,488


2,426 2,547 2,674
90,892.56 68,169.42 68,169.42

1,985 2,084 2,188


48.66 52.79 55.42 216.90 INR Cr.
69,432 69,432 71,536
276 289 304
1.91 2.01 2.17 6.10 INR Cr.

- 0.48 1.92 4.80 INR Cr.


2.17 2.20 2.20 9.59 INR Cr.
1.63 1.65 1.65 7.20 INR Cr.
1.52 1.64 1.73 21.59 INR Cr.
5.32 5.97 7.49 28.28 INR Cr.

55.89 60.76 65.09 541.08 INR Cr.

3 4 5
155.2 155.2 58.2
170,980 170,980 64,117
10,112 10,719 11,362
172.90 183.28 72.85 449.42 INR Cr.
25% 30% 30%
40% 30% 30%
70% 30%
100%

74.26 186.28 185.82 449.42 INR Cr.


8.65 9.16 3.64 22.47 INR Cr.
65.61 177.12 182.18 426.95 INR Cr.

3 4 5
0.40 40% 15%
106,041 106,041 39,765
13,483 14,292 15,150
143 152 60 372 INR Cr.
7.15 7.58 3.01 19 INR Cr.
135.83 143.98 57.23 353

201.44 321.10 239.41 780 INR Cr.

3 4 5
145.55 260.33 174.32 239 INR Cr.
-33.24 116.22 168.06 298.46 0.00
49%

7/11/2027 7/11/2028 7/11/2029


145.55 260.33 174.32

YR 3(11-07-2027) YR 4(11-07-2028) YR 5(11-07-2028) TOTAL


55.9 60.8 65.1 541.1 INR Cr.
201.44 321.10 239.41 780.00 INR Cr.
145.55 260.33 174.32 238.92 INR Cr.

You might also like