PROJECT FEASIBLITY REPORT OF .

Company Name

Facts
Type of Land
Project Name/Location
Land Area (Acres) (Appx.)
Land Area (Sq.Mtrs)
FAR
FSI (Sq.ft.) (approx)
Saleable Area (Sq.ft.) (Appx.)
Built up Area(Sq.ft.)(Appx.)

Sales (till 12.07.2014)

Total Area
(Sq. ft.)

Sold Area
(Sq. ft.)

Stock for sale

(Sq. ft.)

Total Sales Area- (Residential+ Commercial )

Residential Area
Commercial Area

0
0
0

Construction Cost

Rs. (In Crore)

Average COC (INR) (PSF)- On Built Up Area

Total COC (INR)

Realisation
0

Total value of
stock
0

Already Sold Value

0

Unsold Stock
Value
0

Expected Realisation
0

Residential (INR)
Retail Shop (INR)
Remaining Cash receivable on sold stock (INR)

Total Realisation (INR)

Cost

Total
Rs. (In Crore)

Already done
Rs. (In Crore)

Balance
Rs. (In Crore)

Total Cost
Rs. (In Crore)

Cost of Construction (INR)

Cost of Land- Book Value(INR) (including Interest Cost)
Overhead Expenses(INR)

Total Cost (INR)

Rs. (In Crore)

Note:-

Fund Requirement:
Sales Status

Particulars
Sales done as on date
-Residential (INR)
-Retail Shop (INR)
Total Sale
Retention 5%- Fund received once units delivered

Fund receivable
Fund received so far

Fund Inflow

Cost Status
Particulars
Cost of Construction (INR)
Cost of Land- Book Value(INR) (including Interest Cost)

Sold Unit Value

Unsold Stock Value

Rs. (In Crore)

Rs. (In Crore)

Total

Incurred

Balance

Rs. (In Crore)

Rs. (In Crore)

Rs. (In Crore)

Project DetailsProject Name

Project Address
Plot Area
No. of Buildings / Flats
No. of Floors

Size of the Flats

Flat Type

1 BHK- Size 390 Sq. Ft., 490 Sq. Ft., 790 Sq.Ft.
2 BHK- 1 BHK
995 Sq. Ft.
3 BHK- 1295 Sq.
2 BHK
Ft., 1595 Sq. Ft., 1825 Sq. Ft.
4 BHK- 2350 Sq. Ft.
3 BHK
4 BHK
Commercial
Total
Total Saleable Area - Sq. Ft

Project Cost
1. Land
2. Devt. Cost
4. Construction Cost
5. Financial Charges Arc, OH & Conting
Total Project Cost
Selling Price

Total Sales Value

Profit Margin
Bookings made so far

Expected Project Completion Date

Rs. in Lacs

Project Commencement date

No. of Units Avg. Size of the Saleable

Area of Flat (Sq. Ft.)

Avg. Cost of
Flat (Rs. in
Lacs)

0
Residential
Commercial
Total

Amt. Spent

Sources of Financing

Inv So far

Promoters Contribution
Booking Money / Sales
LICHFL Loan
Bank Loan
0
0

Total Funds
Residential per Sq. Ft.
Commercial per Sq. Ft.
0
Car Parking
Plots
Commercial
Total Sales
Less: Joint Venture Portion
Net Sales to the Builder
Residential Flats
Commercial
Total Bookings made so far
Tied Up Sales (Received)
Tied Up Sales (Receivables)
Untied Sales

0
0
0
0

Total Area
(Sq ft)

Sou. of Funds
Capital

Company Name
Income Statement
Year 1 to 5 years
(Rs.)
Year 2
2012
Rupees

Particulars
Net Revenues
- Sales Accounts
- Indirect Income

Cost of Revenue
- Change in Inventories
- Pruchases/ Work in Progess
- Direct Expenses

% of Revenues
Gross Profit
% of Revenues
- Operating Expenses
-- Administrative Expense
-- Financial Expense
-- Salary & Wages
-- Selling and Distribution Expenses
-- Misc. Expenditure writeen off.

% of Revenues
EARNINGS FROM OPERATIONS
EXTRAORDINARY INCOME / (EXPENSE)
EARNINGS BEFORE INTEREST & TAXES
INTEREST INCOME / (EXPENSE)
NET EARNINGS BEFORE TAXES
TAXES

NET EARNINGS
% of Revenues

Projected Numbers
Year 3
2013
Rupees

Year 4
2014
Rupees

Year 5
2015
Rupees

###

Year 6
2016
Rupees

Total
Rupees

Company Name
Balance Sheet
Year 1 to 5 years
(Rs.)

Particulars

Year 1
2011
Rupees

ASSETS
- CURRENT ASSETS
-- Cash and cash equivalents
-- Short term loans and advance
-- Inventory
-- Other Current Assets

Total Current Assets

- Non-CURRENT ASSETS
-- Tangible Assets
-- Long term loans and advances
-- Non current investments

Total Non-Current Assets

TOTAL ASSETS

LIABILITIES & SHAREHOLDERS' EQUITY

- CURRENT LIABILITIES
-- Short Term Debt
-- Accounts Payable & Accrued Expen
-- Other Current Liab
-- Short Term Provision

Total Current Liabilities

-LONG TERM DEBT (less current portion)

-STOCKHOLDERS' EQUITY
--Share Capital
--Reserves and surplus
Total Equity

TOTAL LIABILITIES & EQUITY

Year 2
2012
Rupees

Year 3
2013
Rupees

Year 4
2014
Rupees

Projected Numbers
Year 5
2015
Rupees

Year 6
2016
Rupees

Total
Rupees

10/31/2016
06:31:15

Company Name
Property and Equipment
Years 1 to 5
(Rs.)

Net Revenues
Capital Expenditures
Computers, Software & Office Equipment
Plant & Equipment
Other
Total Capital Expenditures
% of Revenue

Year 0
Purchased
Assets

Year 1
2011

Year 2
2012
0

#DIV/0!

#DIV/0!

Depreciation Computers, Sofware & Office Equipment (allocated to General & Administrative Expenses)
Depreciation Rate: Years
1
3
3
Year 0
0
0
Year 1
0
0
Year 2
0
Year 3
Year 4
Year 5
Total Depreciation
0
0

Depreciation on Plant and Equipment (allocated to Cost of Revenue)

Depreciation Rate: Years
1
Year 0
Year 1
0
Year 2
Year 3
Year 4
Year 5
Total Depreciation

Depreciation Other (allocated to Cost of Revenue)

Depreciation Rate: Years
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Total Depreciation

Total Depreciation
% of Revenue
Property & Equipment
Gross Asset Value
Accumulated Depreciation
Net Property and Equipment
% of Revenue

0
0

7
0
0

7
0
0
0

10
0
0

10
0
0
0

10/31/2016
06:31:15

Year 3
2013

Year 4
2014
0

#DIV/0!

Year 5
2015
0

#DIV/0!

#DIV/0!

ministrative Expenses)
3
0
0
0
0

3
0
0
0
0
0

7
0
0
0
0

7
0
0
0
0
0

10
0
0
0
0

10
0
0
0
0
0

3
0
0
0
0
0
0
0

7
0
0
0
0
0
0
0

10
0
0
0
0
0
0
0

10/31/2016
06:31:15

Company Name
Working Capital
Years 1 to 5
(Rs.)

Year 1

Year 2

Year 3

Year 4

2012

2013

2014

2015

Net Revenues

Accounts Receivable
% of Revenue
Days Outstanding
Accounts Receivable
(Increase)/Decrease from Prev. Period

#REF!
#REF!
#REF!
#REF!

8.3%
30
#REF!
#REF!

8.3%
30
#REF!
#REF!

8.3%
30
#REF!
#REF!

Inventory
% of Revenue
Inventory Turns
Inventory Days
Inventory
(Increase)/Decrease from Prev. Period

#DIV/0!
#DIV/0!
#DIV/0!
152,966,609
#VALUE!

6.7%
15
24
186,390,889
(33,424,280)

6.7%
15
24
#REF!
#REF!

6.7%
15
24
#REF!
#REF!

Other Current Assets

% of Revenue
Days
Other CA Value
(Increase)/Decrease from Prev. Period

1.0%
4
#REF!
#REF!

1.0%
4
#REF!
#REF!

1.0%
4
#REF!
#REF!

1.0%
4
#REF!
#REF!

0.0%
0
0
#VALUE!

0.0%
0
72,377,024
72,377,024

0.0%
0
#REF!
#REF!

0.0%
0
#REF!
#REF!

#DIV/0!
#DIV/0!
111,731,976
#VALUE!

1.0%
4
#REF!
#REF!

1.0%
4
#REF!
#REF!

1.0%
4
#REF!
#REF!

Accounts Payable & Accrued Expenses

% of Revenue
Days
AP & Accrued Value
Increase/(Decrease) from Prev. Period

Other Current Liabilites

% of Revenue
Days
Other Current Liabilities
Increase/(Decrease) from Prev. Period

Revenues by Months & Quarters

(Rs.)
Year 2
2012

Year 3
2013

Year 4
2014

Year 5
2015

Month 1
Month 2

0
0

0
0

0
0

0
0

Month 3

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Total 1st Quarter

Month 4
Month 5
Month 6

Total 2nd Quarter

Month 7
Month 8
Month 9

Total 3rd Quarter

Month 10
Month 11
Month 12

Total 4th Quarter

Total for year

Company Name
Funding Projections
Years 1 to 5
(Rs.)
Begin

Beginning Cash
Equity
Common
Increase / (Decrease) Previous Period
Preferred
A Round
Total Preferred
Increase / (Decrease) Previous Period

Total Equity

Debt
Short Term Debt
Increase / (Decrease) Previous Period
Long Term Debt
Current Portion
Long Term Portion

Total Long Term Debt

Increase / (Decrease) Previous Period
Current Portion
Long Term Protion

Total Long Term Debt

Total Equity & Debt

Interest
Interest Rate
Short Term Debt
Long Term Debt
Interest Expense
Short Term Debt
Long Term Debt

Total Interest
Retained Earnings
Net Income
Dividends
Increase / (Decrease) Retained Earnings

Beginning Retained Earnings

Ending Retained Earnings

Projected Num
Year 1
2011

Year 2
2012

Year 3
2013

Year 4
2014

###
0

###
0

###
###
-

###

###

0%
0%

0%
0%

15%
0%

15%
0%

###
-

###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###

###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###

Projected Numbers
Year 5
2015

Year 6
2016

0
-

15%
0%

10000000

Projected Cashflow

(Amount in Rs. Crores)

Particulars
Total
(A) Cash In flows
Opening Balance
(i) Equity
(ii)Advance form Sales/ Booking
(iii) Loan
(iv) Balance Cash from already sold stock
Total (A)
0.00
(B) Cash Outflow
(i) Land
(ii) Development Exp.
(iii) Construction Exp.
(iv)Architect exps/PMC
(iv) Sales/ Marketing Exp.
(v) Administrative Exp.
(vi) Interest Exp.
(vii) Contingencies
(viii) Repayment of Loan
Total (B)
(A-B) Surplus/(Deficit)

Already incurred as
Balance
on date

0.00

Sep-14 Dec-14

0.00

0.00

0.00

Mar-15

0.00

Jun-15 Sep-15 Dec-15

0.00

0.00

0.00

Mar-16

0.00

Jun-16 Sep-16

0.00

0.00
0.00

0.00
0.00
0.00

0.00
0.00

0.00
0.00

0.00
0.00

0.00
0.00

0.00
0.00

0.00
0.00

0.00
0.00

0.00
0.00

0.00
0.00

Assumptions
1
2
3
4
5
6

7
8
9
10
11

Total

Dec-16

Mar-17

Jun-17

Sep-17

Dec-17

Mar-18

0.00

0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
8.02
50.00
0.00
58.02

43.69
0.00
8.02
0.00
0.00
51.70

35.14
0.00
8.02
0.00
0.00
43.15

28.83
0.00
8.02
0.00
0.00
36.84

20.27
0.00
8.02
0.00
0.00
28.29

13.96
0.00
8.02
0.00
0.00
21.98

0.00
0.00

0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.00
11.67
0.00
0.08
0.08
1.50
1.00
0.00
14.33
43.69

2.24
0.00
11.67
0.00
0.08
0.08
1.50
1.00
0.00
16.57
35.14

0.00
0.00
11.67
0.00
0.08
0.08
1.50
1.00
0.00
14.33
28.83

2.24
0.00
11.67
0.00
0.08
0.08
1.50
1.00
0.00
16.57
20.27

0.00
0.00
11.67
0.00
0.08
0.08
1.50
1.00
0.00
14.33
13.96

0.00
0.00
11.67
0.00
0.08
0.08
1.50
1.00
125.00
139.33
-117.35

Company Name
Funding Projections
Years 1 to 5
(Rs.)

Income Statement
Year 1 (i.e. 2011) by Months
Month 1

Month 2

NET REVENUES

###

COST OF REVENUE
GROSS PROFIT

###
-

Total Operating Expenses

###
###
###
-

EARNINGS FROM OPERATIONS

EXTRAORDINARY INCOME / (EXPENSE)

###

EARNINGS BEFORE INTEREST & TAXES

INTEREST INCOME / (EXPENSE)

NET EARNINGS BEFORE TAXES

OPERATING EXPENSES
Sales & Marketing
Research & Development
General and Administration

TAXES

NET EARNINGS

Income Statement
Year 2 (i.e. 2012) by Months
Month 1

Month 2

NET REVENUES

###

COST OF REVENUE
GROSS PROFIT

###
-

OPERATING EXPENSES

Sales & Marketing

Research & Development
General and Administration

Total Operating Expenses

EARNINGS FROM OPERATIONS

EXTRAORDINARY INCOME / (EXPENSE)

EARNINGS BEFORE INTEREST & TAXES

INTEREST INCOME / (EXPENSE)

NET EARNINGS BEFORE TAXES

TAXES

NET EARNINGS

###
###
###
-

Income Statement
Year 3 (i.e. 2013) by Months
Month 1

Month 2

NET REVENUES

###

COST OF REVENUE
GROSS PROFIT

###
-

Total Operating Expenses

###
###
###
-

EARNINGS FROM OPERATIONS

EXTRAORDINARY INCOME / (EXPENSE)

###

EARNINGS BEFORE INTEREST & TAXES

INTEREST INCOME / (EXPENSE)

NET EARNINGS BEFORE TAXES

OPERATING EXPENSES
Sales & Marketing
Research & Development
General and Administration

TAXES

NET EARNINGS

Income Statement
Year 4 (i.e. 2014) by Months
Month 1

Month 2

NET REVENUES

###

COST OF REVENUE
GROSS PROFIT

###
-

Total Operating Expenses

###
###
###
-

EARNINGS FROM OPERATIONS

EXTRAORDINARY INCOME / (EXPENSE)

###

EARNINGS BEFORE INTEREST & TAXES

INTEREST INCOME / (EXPENSE)

NET EARNINGS BEFORE TAXES

OPERATING EXPENSES
Sales & Marketing
Research & Development
General and Administration

TAXES

NET EARNINGS

Income Statement
Year 5 (i.e. 2015) by Months
Month 1

Month 2

NET REVENUES

###

COST OF REVENUE
GROSS PROFIT

###
-

OPERATING EXPENSES
Sales & Marketing
Research & Development

###
###

Total Operating Expenses

General and Administration

###
-

EARNINGS FROM OPERATIONS

EXTRAORDINARY INCOME / (EXPENSE)

###

EARNINGS BEFORE INTEREST & TAXES

INTEREST INCOME / (EXPENSE)

NET EARNINGS BEFORE TAXES

TAXES

NET EARNINGS

Month 3

Month 4

Month 5

Month 6

Month 7

###

###
-

###
###
###
-

###

Month 3

Month 4

Month 5

Month 6

Month 7

###

###
-

###
###
###
###
###
###
###
-

0
0

Month 3

Month 4

###

###
-

###
###
###
-

###

Month 5

###
###
###
-

Month 6

Month 7

Month 5

Month 6

Month 3

Month 4

Month 7

###

###
-

###
###
###
-

###

Month 3

Month 4

Month 5

Month 6

Month 7

###

###
-

###
###

###
-

###

Month 8

Month 9

Month 10

Month 11

Month 12

###

###
-

###
-

###
###
-

###

Month 8

Month 9

Month 10

Month 11

Month 12

###

###
-

###
-

###
###
-

###

Month 8

Month 9

Month 10

Month 11

Month 12

###

###
-

###
-

###
###
-

###

Month 8

Month 9

Month 10

Month 11

Month 12

###

###
-

###
-

###
###
-

###

Month 8

Month 9

Month 10

Month 11

Month 12

###

###
-

###
-

###

###
-

###

Total
12 Months
-

0
0

Total
12 Months
-

0
0

Total
12 Months
-

Total
12 Months
-

0
0

Total
12 Months
-

0
0

Company Name
Construction in progress- XXXXX ( Two Years)
Project Management Consultant

Cost to be Incurred
Structure
Construction Cost
Rs. (Crore)

Month Wise

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

Finishing Cost
Rs. (Crore)

July'14
Aug'14
Sep'14
Oct'14
Nov'14
Dec'14
Jan'15
Feb'15
Mar'15
Apr'15
May'15
June'15
July'15
Aug'15
Sep'15
Oct'15
Nov'15
Dec'15

Total Cost
Rs. (Crore)
-