SR NO
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
PARTICLURAS
Application on company letter head
Pan card of unit and KYC documents of Entity
Latest 3 Years - Audited Balance Sheet of entity/company with ITR copies
Provisional Balance Sheet entity/company till date.
Balance sheet of all associate/group companies
Address of bankers of associate companies
Pan card of guarantors/Borrowers with 3 photos /KYC Documents of borrower
Latest 3 Years - ITRs of Guarantors/Borrowers
MOA & AOA or partnership deed (DIR if any changes)
Sanction letter of existing bankers
Outstanding loan of existing loans in Loan Account Statement
Any group banking with bank? If yes, name and address of branch, sanction letter and outstanding
Account statement of latest 6 months
Brochure of the project
Copy of sanctioned (Blue Prints) plans and approvals.
Land agreement/ Joint Development Agreement + POA. (whichever applicable)
Land related documents like 7/12, Pher Phar, NA order, etc…
TDR Agreement... if applicable.
Collateral security related Documents
Valuation report of primary security & collateral Security.
Title report of primary security & collateral Security.
CA certified Net worth statement of guarantors
CA certificate for provisional Balance Sheet
CA certificate that no statutory dues are pending as on date
CA certificate for all loans are standard assets in the books of existing bankers
CA Certificate certifying the genuineness of the source of unsecured loans.
CA Certificate certifying the amount infused into the project, the cost incurred till date, advances rece
Undertaking by entity that unsecured loans will not be withdrawn.
Agreement of sale
Architect certificate (structural design)
Engineer certificate (stating % of Current status of project)
Letter from promoter that the Unsecured loan and Capital Invested will not be removed till Loan Durat
flats booked
Andaman & Nicobar Islands
Andhra Pradesh
Arunachal Pradesh
Assam
Bihar
Chandigarh
Chattisgarh
Dadra and Nagar Haveli
Daman & Diu
Delhi
Goa
Gujarat
Haryana
Himachal Pradesh
Jammu & Kashmir
Jharkhand
Karnataka
Kerala
Lakshadweep
Madhya Pradesh
Maharashtra
Manipur
Meghalaya
Mizoram
Nagaland
Orissa
Pondicherry/Puducherry
Punjab
Rajasthan
Sikkim
Tamil Nadu
Tripura
Uttar Pradesh
Uttaranchal/Uttarakhand
West Bengal
Telangana
Completed Projects
Type of Worked as Total No
S. No. Name of Location Project(resid Company PAN Builder/Co Saleable of Units Sold
Project ential/comm Name ntractor area in sft Units
ercial/mix)
1 Shilp - 1
BYUPV14
Iskcon commercial Shivalik Builder 50000 60 50
32L
2 Shilp - 2
BYUPV14
CG Road Residential Shivalik Builder 30000 30 25
32L
3 Shilp - 3
BYUPV14
Iskcon Mix Shivalik Builder 50000 50 10
32L
Total 130000 140
Rs in Crs.
Total Sales OC Whether
Units Value of Total Cost Project Project Received(y Reason for any over Extended Present
Unsold project of project start date end date es/no) unsold run in date position
project
10 125 75 no no ###
8/15/2021 ###
5 100 80 no no ###
3/3/2022 8/15/2023
40 125 75 no location no ###
9/15/2023 ###
350 230
Loan on the Bank / FI
project Name
20 HDFC
No
No
Project Name Shilp - 4 Project 2
RERA Number
Project is undder JV / Owned JV
Location Ahmedabad
Type of Project(residential/commercial/mix) Mix
Company Name/ Developer Entity Shivalik
PAN BYUPV1432L
Total Units 50
Landowner Share 25
Developer Share 25
Sold Units (from developer share) 2
Unsold Units 48 0
Total Built-up area (sq ft) 10000
Total Saleable Area -Sq ft 50000
Sq ft Sold till date(from developer share) 2000
Sq ft Unsold till date (from developer share) 48000 0
Start Date (Actual) Feb-24
End Date (proposed) Aug-24
RERA Start Date Feb-24
RERA Completion Date Aug-24
Total value of the project 70.00 -
Value of Sold Area 36
Amount Received from Sold Area 0.5
Receivables from sold Area 35.5 0
Average rate of sold area 180000 #DIV/0!
Per sq ft rate consider for unsold area 5500
Receivable from unsold area 26.4 0
Total Future receivable 61.9 0
Land Cost 30
Construction Cost 30
Other Cost 5
Total Cost of the project 65 0
Cost incurred 5
Per sq ft construction cost 30000 #DIV/0!
Pending Cost 60 0
Total Surplus (on project level) 5.00 -
Loan outstanding on project 1
Average interest cost 0.4
Total debt repayment 1.4 0
Total future Surplus in the project 0.499999999999999 0
Approval Status (including RERA) Approved
Current Stage of construction 40%
Project 3 Project 4 TOTAL
50
25
25
2
0 0 48
50000
2000
0 0 48000
45337
45535
- - 36.00
36
1
0 0 35.5
#DIV/0! #DIV/0! 180000
0 0 0
0 0 35.5
30
5
0 0 35
5
#DIV/0! #DIV/0! #DIV/0!
0 0 30
- - 1.00
1
0
0 0 1
0 0 4.1
Upcoming Projects
Type of Total Saleable
Total No
Sr no Project Name Project(residential/com Area of land (sq mtr)
of Units
area
mercial/mix) (sqft)
1 Shilp-5 Residential 300 10 3230
2
3
Total
Rs in Crs.
Total Project Total
Profit
Sale Value Cost
20 15 5
20 15 5
Term Lenders of Partners and Company/Firm
Sr. No Name of Borrower Sanctioned Undisbursed
Bank / FI Loan Type Disbursed
amount amount
1 Parthiv Patel HDFC Current 25 10 20
Total
ROI at the Loan
Current ROI Door to door Loan Start
EMI Amount o/s time of Moratorium Closure
(%) tenor Date
Sanction (%) Date
30 40 8 8.1 24 3 1/3/2024 1/3/2026
Delay/
Security Overdue/
Remarks
of Loan Bounce if
any
Property EMI On Time No Delay
CF loan details ( ongoing & recently closed)
Project Finance Details
Sr. No. Borrower Financing Loan Type (CF Sanction Amt Disbursed Amt O/s Amt
institution or Inventory
Funding)
1 Virat Kohli Axis Bank CF 50 40 30
2
3
4
5
6
Total 50 30
d)
In Rs.
Loan Repaid Loan Start date Loan closure Security EMI Name of Contact
date details Relationship Number of
Manager of Relationship
Bank Manager of
Bank
20 Mar-24 Mar-27 Property 45000 Rahul 9898986767
20 - - -
Details of land holdings
Sr. No. Location Area Area Valuation
(in Sq. Mtr.) (in sqft)
1 CG Road 929.03 10000 50
2 Iskon 929.03 10000 60
Total 1,858 20,000 110
Share in Land (%)
50
60
COP-MOF
Incurred To be
Cost of Project % Total incurred
Cost of Land 0.08928571 0.25 0.25
Development Cost 0.125 0.35 0.35
Cost of Construction 0.17857143 0.5 0.5
Administrative Cost 0.10714286 0.3 0.3
Marketing Cost & Sales Commission 0.07142857 0.2 0.2
Finance Cost 0.21428571 0.6 0.6
Contingencies, if any 0.21428571 0.6 0.6
Total 2.8 0 2.8
COP-MOF
Means of Finance % Total Incurred To be
incurred
Promoters Fund & Internal Accruals 0.2 0.2 0.8 0.2
Booking Advances 0.2 0.2 0.8 0.2
Term Loan 0.2 0.2 0.6 0.2
Creditors 0.2 0.2 0.1 0.2
Unsecured Loans 0.2 0.2 0.1 0.2
0 0
0 0
Total 1 2.4 1
Booking MIS
Configura Flat/Shop Developer/ RERA Carpet Actual Carpet
S No Block Building
tion Number Land owner Area Area Sft
1A Alpha 2 BHK A101 Developer 800 750
2A Alpha 2 BHK A102 Developer 800 750
3A Alpha 2 BHK A103 Developer 800 750
4B Beta 3 BHK B101 Developer 800 750
5B Beta 3 BHK B102 Developer 800 750
6B Beta 3 BHK B103 Land owner 800 750
7B Beta 3 BHK B104 Land owner 800 750
Rate per Booking
Built Up Saleabale Sft on Status Booking Agreement Name of
Agreement date
Area SFT Area SFT Saleable (Sold/Unsol Date status Purchaser
area d)
900 800 2500 sold ### pending John
900 800 150 sold ### pending John
900 800 150 sold ### pending John
900 800 2500 sold ### pending John
900 800 150 sold ### pending John
900 800 150 sold ### pending John
900 800 150 sold ### pending John
Sales Agreement
Amount demanded Amount Received % of
Contact Value (excluding Amount to be
(excluding taxes and (excluding taxes money
Number taxes and other received
other charges) and other charges) received
charges)
123-456-7890 2000000 2000000 300000 1200000 666.67%
123-456-7891 2000000 1500000 300000 1200000 500.00%
123-456-7892 2000000 1500000 300000 1200000 500.00%
123-456-7890 2000000 2000000 300000 1200000 666.67%
123-456-7891 2000000 1500000 300000 1200000 500.00%
123-456-7892 2000000 1500000 300000 1200000 500.00%
123-456-7892 2000000 1500000 300000 1200000 500.00%
Home Loan Bank / FI
Availed Name
yes xyz bank
yes xyz bank
yes xyz bank
yes xyz bank
yes xyz bank
yes xyz bank
yes xyz bank
Schedule D
Sr. No. Mode of Bank Paid/Issued/PDC's Payment / Cheque Date
Payment
(Cheque/
Cash/
Online)
1
2
3
4
5
6
7
8
9
10
Total
Schedule Data of Land Payment
Issued To Amount (in Cr)
-
Other Event
Sr. No. First Name Last Name Date of Birth
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Total
Gua
Gender Address Type Pin Code City State
Guarantor or Partner Details
Constitution PAN Aadhaar Relation Key Partner
Education Address Street Phone number % shareholding /
profit sharing
-
Role in the project / firm Net Worth (in Cr)
