Introduction

Real estate has proved to be real engine growth. Over the years the real estate sector in India has emerged as a big engine for economic growth, as it has been the second-largest employer next only to agriculture. It has several linkages for several other sectors and over 250 associated industries. According to the estimates, every rupee being invested in this sector results in 78 paise being added to the GDP. Accordingly, a unit increase in expenditure has a multiplier effect, and the capacity to generate income is as high as five times. The sector size is close to 12bn USD and is growing at 30% per annum. Presently, it's contributing 5% of the country's GDP and is expected to rise at rate of 6% per annum.

Scope of the project

The project is located in the main heart of the city, where land is scarce and the demand has no limits. The area is a big commercial hub and offering such a project to the public will pull buyers accordingly.

Product / Services & process

It is a real estate commercial project with proposed of 7 floors (including ground) with a basement parking.

Raw materials / Consumables

Major raw materials required for the project are:

1. Cement: ACC Cements Ltd.

2. Steel rods: Tata Steel.

3. Electrical wiring,lighting and insulations: Havels Group.

4. Transformer: BHEL

5. Other raw materials such as granite chips, sand, marble will be taken as per cheap availibility and price.

Market potential & Strategy

The proposed site is at the main heart of the city. There is a huge scarcity of land at the site and demand has no limits. As part of the Land is already having structures on it and is under a lease, the first step is to build the first two floors and shift them to that place. Besides as the property is already generating a revenue of 9 lacs INR per month, it would also reduce a burden as we build the project.

Project at a glance

Name & Address of Unit

Commercial building- Realestate

Address

Details of unit

Email	:	[email protected]
Phone	:	00000
Constitution	:	Proprietership
Total project cost	:	*******
Fixed Capital	:	*******
Working Capital	:	*******
Total Bank loan	:	*******
Promoter(s) contribution	:	*******
Term loan	:	*******

Name & address of promoter(s)

Name		: Your name
Address		: Address
Phone		: 000000
Designation		: Proprietor
E-mail		: [email protected]

Project Feasibility Ratios

Debt Service Coverage Ratio (Average)

:1.87

Current ratio (Average)

:2.63

	Year 1	Year 2	Year 3	Year 4	Year 5
Current ratio	1.53	2.06	2.62	3.19	3.76
Quick ratio	1.13	1.56	2.10	2.64	3.18
Interest coverage ratio	3.87	5.55	7.00	9.48	14.71
Debt equity ratio	2.863	2.080	1.528	1.020	0.542
TOL/TNW	3.02	1.45	0.79	0.43	0.21
DSCR	1.65	1.86	1.90	1.94	1.97
Gross profit Sales Percentage %	29.23 %	28.54 %	28.18 %	27.86 %	27.50 %
Net profit Sales Percentage %	10.84 %	10.56 %	11.10 %	11.57 %	11.90 %
BEP in % of installed capacity %	49.90 %	27.12 %	27.12 %	27.12 %	27.12 %
BEP in sales of Rs	2,620,800.00	1,840,695.65	1,972,173.91	2,103,652.17	2,235,130.43
Return On Capital Employed	0.26	0.34	0.34	0.33	0.33

Project Feasibility graph

Net profit Sales %

Quick ratio

Revenue v/s Expense

Expense Splitup

Project Cost

Sl. no	Item	Amount Rs
1	Land and Building	*******
2	Preliminary expenses	*******
3	Working Capital	*******
	Total	*******

Working Capital Computation

Sl. no	Item	Amount Rs
1	Consumables / stock in hand	*******
2	Work in progress	*******
3	Finished goods	*******
4	Working expense.	*******
5	Receivables/Sundry debtors	*******
6	Payables	*******
7	Total working capital	*******
8	Own Contribution	*******

Annual Sales / Revenue

Sl. no	Item	Rate		Quantity	Unit	Total Rs
1	Rate of finished site per sqft	*******	X	1140000	Square feet	*******
	Total					*******

Total Yearly Expense

Sl. no	Item	Amount Rs
1	Salary for construction	*******
2	Admin and office staff	*******
3	Repairs & Maintanance	*******
4	Electricity	*******
5	Raw Materials	*******
6	Cleaning staff	*******
7	Wages to workers	*******
	Total	*******

Application of Fund

Sl. no	Item	Subsidy %	No.	Rate	Amount Rs
1	Land and Building	*******	1	*******	*******
2	Preliminary expenses	*******	1	*******	*******
	Total Investment				*******
	Total Subsidy				*******
	Net Investment				*******

Means of Finance

Sl. no	Item	Amount
1	Term Loan	*******
2	Working capital Loan	*******
3	Total loan	*******
4	Term Loan contribution	*******
5	Working capital contribution	*******

Profitability Statement

		Year 1(!*)	Year 2	Year 3	Year 4	Year 5
Revenue from operation
Sales	15.93	*****	*****	*****	*****	*****
Add :
Closing stock		*****	*****	*****	*****	*****
Total		*****	*****	*****	*****	*****
Less :
Opening stock		*****	*****	*****	*****	*****
Stock purchase	7.20	*****	*****	*****	*****	*****
Salary	3.60	*****	*****	*****	*****	*****
Repairs and maintenance charges	0.24	*****	*****	*****	*****	*****
gas	0.12	*****	*****	*****	*****	*****
ELECTRICITY bill	0.12	*****	*****	*****	*****	*****
Total		*****	*****	*****	*****	*****
Gross profit		*****	*****	*****	*****	*****
Less :
Rent	0.12	*****	*****	*****	*****	*****
Telephone/Postal &internet charge	0.12	*****	*****	*****	*****	*****
Total		*****	0*****	*****	*****	*****
Depreciation		*****	*****	*****	*****	*****
Interest on TL		*****	*****	*****	*****	*****
Interest on WC		*****	*****	*****	*****	*****
Total		*****	*****	*****	*****	*****
Profit before tax		*****	*****	*****	*****	*****
Income Tax		*****	*****	*****	*****	*****
Profit after tax		*****	*****	*****	*****	*****

Cash flow statement

Cash Inflow	Pre operative period	Year 1	Year 2	Year 3	Year 4	Year 5
Capital	0.63	*****	*****	*****	*****	*****
Subsidy	*****	*****	*****	*****	*****	*****
Termloan	*****	*****	*****	*****	*****	*****
Profit before tax with interest	*****	*****	*****	*****	*****	*****
Increase in WC loan	*****	*****	*****	*****	*****	*****
Depreciation	*****	*****	*****	*****	*****	*****
Increase in Current liability	*****	*****	*****	*****	*****	*****
Total Cash Inflow	*****	*****	*****	*****	*****	*****
Cash Outflow
Fixed Assets	*****	*****	*****	*****	*****	*****
Increase in Current asset		*****	*****	*****	*****	*****
Interest on TL	*****	*****	*****	*****	*****	*****
Interest on WC	*****	*****	*****	*****	*****	*****
Income Tax	*****	*****	*****	*****	*****	*****
Decrease in Term loan		*****	*****	*****	*****	*****
Drawing	*****	*****	*****	*****	*****	*****
Total Cash Outflow	*****	*****	*****	*****	*****	*****
Opening balance	*****	*****	*****	*****	*****	*****
Net Cashflow	*****	*****	*****	*****	*****	*****
Closing balance	*****	*****	*****	*****	*****	*****

Balance sheet

Liability	Pre operative period	Year 1	Year 2	Year 3	Year 4	Year 5
A. Share holders funds
Capital	*****	*****	*****	*****	*****	*****
Reserve & Surplus	*****	*****	*****	*****	*****	*****
B.Non current Liabilities
Termloan	*****	*****	*****	*****	*****	*****
C.Current Liabilities
Working capital loan	*****	*****	*****	*****	*****	*****
Account payable		*****	*****	*****	*****	*****
Total Liability	*****	*****	*****	*****	*****	*****
Asset
A. Non current Assets
Fixed Assets	*****	*****	*****	*****	*****	*****
B. Current Assets
Inventory	*****	*****	*****	*****	*****	*****
Trade receivables	*****	*****	*****	*****	*****	*****
Cash and cash equivalence	*****	*****	*****	*****	*****	*****
Total Asset	*****	*****	*****	*****	*****	*****

Repayment of Term loan

Year	Installment	Outstanding at the beginning	Principal repayment	Interest	Amount paid	Outstanding at the end
1	1	*****	*****	*****	*****	*****
1	2	*****	*****	*****	*****	*****
1	3	*****	*****	*****	*****	*****
1	4	*****	*****	*****	*****	*****
1	5	*****	*****	*****	*****	*****
\|	\|	\|	\|	\|	\|	\|
\|	\|	\|	\|	\|	\|	\|
5	56	*****	*****	*****	*****	*****
5	57	*****	*****	*****	*****	*****
5	58	*****	*****	*****	*****	*****
5	59	*****	*****	*****	*****	*****
5	60	*****	*****	*****	*****	*****

Debt Service Coverage Ratio

Particulars	Year 1	Year 2	Year 3	Year 4	Year 5
Receipts
a).Net Profit	*****	*****	*****	*****	*****
b).Depreciation	*****	*****	*****	*****	0.30
c).Interest on termloan	*****	*****	*****	*****	*****
Total	*****	*****	*****	*****	*****
Repayments
a).Loan Principal	*****	*****	*****	*****	*****
b).Interest on termloan	*****	*****	*****	*****	*****
Total	*****	*****	*****	*****	*****
DSCR	*****	*****	*****	*****	*****

Depreciation

Particulars	Rate	Year 1	Year 2	Year 3	Year 4	Year 5
Building	*****	*****	*****	*****	*****	*****
Less Depreciation		*****	*****	*****	*****	*****
Written down value		*****	*****	*****	*****	*****
Computers/ Printers /Photocopier/Electronic gadget	00	*****	*****	*****	*****	*****
Less Depreciation		*****	*****	*****	*****	*****
Written down value		*****	*****	*****	*****	*****
Furniture & fixtures	00	*****	*****	*****	*****	*****
Less Depreciation		*****	*****	*****	*****	*****
Written down value		*****	*****	*****	*****	*****
Racks & storage/Interior works	00	*****	*****	*****	*****	*****
Less Depreciation		*****	*****	*****	*****	*****
Written down value		*****	*****	*****	*****	*****
new item	00	*****	*****	*****	*****	*****
Less Depreciation		*****	*****	*****	*****	*****
Written down value		*****	*****	*****	*****	*****
new	00	*****	*****	*****	*****	*****
Less Depreciation		*****	*****	*****	*****	*****
Written down value		*****	*****	*****	*****	*****
Air-conditioning	00	*****	*****	*****	*****	*****
Less Depreciation		*****	*****	*****	*****	*****
Written down value		*****	*****	*****	*****	*****
Other investments	00	*****	*****	*****	*****	*****
Less Depreciation		*****	*****	*****	*****	*****
Written down value		*****	*****	*****	*****	*****
Total less depreciation		*****	*****	*****	*****	*****
Total written down value		*****	*****	*****	*****	*****

Conclusion

The project as a whole describes the scope and viability of the Trading industry and mainly of the financial, technical and its market potential.The project guarantee sufficient fund to repay the loan and also give a good return on capital investment. When analyzing the social- economic impact, this project is able to generate an employment of 5 and above. It will cater the demand of Trading and thus helps the other business entities to increase the production and service which provide service and support to this industry. Thus more cyclic employment and livelihood generation. So in all ways, we can conclude the project is technically and socially viable and commercially sound too.

View a sample report in pdf

Click here to create a project report for your business in less than 10 mins