ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
CASE-03
4
5
6
Project Title : Financial Modeling and Analysis of 50 Flats Housing Project in Gurgaon, Haryana IN
7
8
9
10
Techvardhan Infra Pvt. Ltd (Any Company) “CLIENT” has acquired a piece of land near Gurugram HR and wants to develop it as a residential building having 50 flats of 900 sq. ft each.

They are expecting to sell the flats at a rate of Rs. 4000 / sq.ft. The expected CapEx is Rs. 8 Crore and OpEx is Rs. 50 Lacs / per annum for the whole project.

They are seeking a non-recourse debt (project financing) with 70:30 as D/E ratio from leading commercial banks in India as a 12 years term loan.

Please prepare a financial model and analyse the cost, revenue and debt repayment along with finflow / cash flow analysis. Calculate equity IRR and DSCR.
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100