Index
1 Collateral Security Details
2 Procject Background
3 Project Specific Details
4 Sales Details - Developers Share
5 Landowner Unit Details
6 Key Persons
7 Past & Ongoing Projects
8 Work Completion - Payment Schedule
9 Bank & Loan Details
10 Group Debt
11 Compliances
12 Documents Required
Note - Please fill the excel file in all respects and forward the same alongwith all the necessary documents for evaluatio
ry documents for evaluation
Home
A) Details of Collateral Security
Description of Carpet Area
Sr. No. Type of Propety property Name of owner (in Sq. Ft.)
Provide the details of Loan if any on
Collateral Property
Google
Market Value Location of property Map Link Lender Sanction Outstanding
Details for Project Loan
Applicant Name
Registered Office Address
Project Name
Project Address --(Copy Google Map Link for location of project here)--
Amount of Loan
RERA ID
Expected Date of Completion as per RERA
Date of Incorporation
PAN
GST
Breif Background of the Company/Firm/Group
(Provide the backgound specifying the profile and track record of the
Company/firm/group )
Breif Background of the (Provide the backgound specifying the profile, education qualification,
Directors/Partners/Shareholders/Gurantors profession and track record of each
Directors/Partners/Shareholders/Gurantors )
1.Name of Directors/Partners/Shareholders/Gurantors
2.Name of Directors/Partners/Shareholders/Gurantors
3.Name of Directors/Partners/Shareholders/Gurantors
Name of Project
No of Phases
No of Buildings
No of Wings
Type of Project Slum Rehabilitation Project
Project Start Date
Construction Area Sq ft
Carpet Area Sq ft
Approvals Received till Date (Phase Wise/Building Wise/ Wing wise)
Particulars Date & Reference No. Authority
NA
IOD -
Approved Plan
Construction permission/CC
Environmental Clearance
Hydro NOC
Fire NOC
Sewerage NOC
* If any of the above approval is not applicable please provide the reasons for the same
Current Stage of Construction
Current Stage of
Building No. Approval stage (mention the slab upto which CC is approved) Proposed upto
Construction
Details of Land Acquistion
------(Breif History of Land acqusition )------
Name of Landowner
Type of Agreement (Development, Purchase etc )
Whether the agreement is registered ? No
Total Land Area sq ft
Cost incurred for acqusition
Whether the Project Land is Mortagageble Yes
Incase of Joint Venture (Share in terms of Carpet Area in Sq ft ) Area in Sq Ft Area %
Landowner's Share - #DIV/0!
Developers Share - #DIV/0!
Home
PROJECT SPECIFIC ANALYSIS
Name of Developer: -
Project Name: -
Location Address : -
RERA ID: -
A. Land Details
Land Area (sq. ft.) -
Market Value of Land -
Type of land -
Name of the landowner -
In case of Joint Venture (share in terms of built up area) Landowner's Share #DIV/0!
Developer's Share #DIV/0!
TDR (if any) TDR Amount (mention paid or to be paid) ---->
B. Structure Specification
Total Construction Area (sq ft) -
Residential Construction Area
Commercial Construction Area
Buildingwise /Wing Structure (G= Ground, P=Podium, B=Basement , F= Floors
C. Sharing Ratio (in case of JV)
Particulars Carpet area (sqft) No. of flats No. of shops No. of offices
Promoters Share
Joint Venture Partner's/ Landowners's Share
Total - - - -
D. Break up of units (Provide building wise details)
Particulars Building 1 Building 2
Rehab (if any) Sale
Residential Commercial Residential Commercial
Construction Work Start date
Expected Completion Date
No. of Floors (Structure of the Building )
Flats
No. of flats
Average carpet Area per flat (sq ft)
Carpet Area (sqft.)
Shops
No. of shops / offices
Average carpet Area per shop/office (sq ft)
Carpet Area (sqft.)
Offices
No. of shops / offices
Average carpet Area per shop/office (sq ft)
Carpet Area (sqft.)
Total No. of Units (Flats+shops+offices)
Total Carpet Area (sqft.)
E. Financial Closure
Project Cost
Already incurred
upto dd/mm/yyyy
(mention latest date
information)
Particulars To be incurred Total Cost of the project Per Sq ft
Land cost #DIV/0!
Development cost #DIV/0!
TDR Cost #DIV/0!
Construction Cost #DIV/0!
Plan Approval Charges #DIV/0!
Architect Fees / Consultancy Charges #DIV/0!
Marketing & Administrative Expenses #DIV/0!
Interest on loan #DIV/0!
Contingencies #DIV/0!
Total - - - #DIV/0!
Means of financing
Already brought in To be brought in Total means of financing
Particulars upto dd/mm/yyyy
Promoters contribution
Unsecured loans for project
Sales Proceeds
Project Loan
Total - - -
- -
F. Profitability
Total Sales Value -
Total Project Cost -
Profit -
Profit Percentage on cost #DIV/0!
G. Sales Details (Promoters share) (Amt in crores)
Particulars Sale Buildings Total
Sold Residential Shops Offices
No. of Units -
Carpet Area (sqft.) -
Agreement Value -
Amount Received till date -
Balance Receivables - - -
Unsold
No. of Units -
Carpet Area (sqft.) -
Estimated Sale Rate (per sqft)
Sale Value - -
Total (Sold + unsold)
Carpet Area (sqft.) - -
Sale Value - -
Total
-
-
(Amt in crores)
% of total Cost
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Only developers share to be mentioned Home
Sr No. Building No. Floor No. Flat No. Flat / TYPE Unit Share
Shop/ (1BHK/2BHK/3 (Developer/
Office BHK) Tenant )
1
2
3
4
5
6
7
8
9
10
11
TOTAL
Carpet Area (in Saleable Sale status booked Name of the Home loan
sq. ft.) Area (in /Sold (means sold and Purchaser financed by (must
sq. ft.) registered) / Unsold be filled)
-
PAN No. of Booking date Reg. date of Sale value/ Rate per sq.ft. Amt recd. Upto
purchaser Sale Agreement dd/mm/yyyy (Rs.)
Agreement Value (Rs.)
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
- #DIV/0! -
Balance Other Cost
Receivables (Rs.)
-
-
-
-
-
-
-
-
-
-
-
-
- -
Only landowner's/joint venture partner's share to be mentioned (In case of JDA)
Home
Sr No. Floor No. Flat No. Flat / Carpet Area (in Saleable Area
Shop sq. ft.) (in sq. ft.)
Home
Details of the every partner /director of the borrower firm/company
Sr No Name Birth Date PAN NO.
Date of
Details of Firm/Comapny Incorporation/ Date
of Formation (as per
Sr No. Name PAN) PAN
Statement Showing other key persons of the group
Sr No Name of Person Qualification Function Handled
No. of Years
Gender Residential Address Share% in the group
Address
No. of Years in
the group
Net worth as on
date dd/mm/yyyy
(Rs.) Qualification Function Handled
Home
Past Projects
Sr
Name of the Group Concern Project Name Location
No.
1
2
3
4
Total
Ongoing Project
Sr
Name of the Group Concern Project Name Location
No.
1
2
3
Total
Construction Work (Start Built Up Area Total No of Sold/Unsold Project Cost
& End Month) (Sq. Ft.) units Stock Status (Rs. in Cr.)
0 0 0 0
Construction Work (Start Built Up Area Total No of Sold/Unsold Project Cost
& End Month) (Sq. Ft.) units Stock Status (Rs. in Cr.)
0 0 0 0
Sale Value
Occupancy Status
(Rs. in Cr.)
Sale Value
Occupancy Status Name of the Banks/ FI's Funding raised Rs. in Cr.
(Rs. in Cr.)
0
Current Stage of Progress (%)
Home
Implementation Schedule of the project
SR. NATURE OF WORK COMMENCEMENT COMPLETION
NO.
1 Land Acquisition
2 Plan Approvals
3 Land Development
4 Plinth
5 Slabs/ RCC
6 Brick work
7 Internal plastering
8 Sanitary
9 Flooring
10 Electrical
11 Painting
12 External plastering
13 Water supply
Payment Schedule
SR. NO. PARTICULARS BUILDING NO. %
1 Earnest Money
2 Plinth Work
3 1st Slab
4 2nd Slab
5 3rd Slab
6 4th Slab
7 5th Slab
8 6th Slab ------
9 Brick Work
10 Plastering Work
11 Plumbing Work
12 Electrical Work
13 Painting Work
14 On Possession
TOTAL 0
Home
Bank Details - Company, Director/ partners
Sr.no Name of Financial Account Type of Account
Institution Holder
1
2
3
Bank Address Account Contact Person in
Number Bank
Home
Name of the group Name of Partners /
Sr No. Concern directors / shareholders
Provide the details for all ongoing Loans of the group
Name of Bank Name of Borrowing entity Type of loan
Profit sharing ratio / Shareholding
pattern
Expected Project Sanctioned
Project Completion Date Security ROI Amount
Amount of loan Loan Repayment start
drawn Outstanding date Repayment end date
Home
* Required in case of borrower, co-borrowers and guarantors
Status with Income Tax Department
Financial Year Income Tax Paid Return Filed (Y/ N) Return Filed on Assessment Status
2014 – 2015
2015 – 2016
2016 – 2017
2017 – 2018
2018 – 2019
Status with GST
Return Filed on
Financial Year Turnover GST Paid
GSTR1 GSTR3B
07/17
08/17
09/17
10/17
11/17
12/17
01/18
02/18
03/18
04/18
05/18
06/18
07/18
08/18
09/18
10/18
11/18
12/18
01/19
02/19
03/19
04/19
05/19
06/19
Home
Sr No. Particulars Status
1 Sale Deed for Land Purchased,Development Agreement or JDA as applicable
2 Partnership Deed / MOA & AOA, as the case may be
3 Approved Plan
4 Copy of IOD & CC
5 Sanction Letter & Statement of Account from previous lender, if any
6 Project Location on Google Maps
7 Latest Site Photographs