Introduction

Retail is the second-largest sector in the Indian economy after agriculture. It accounts for nearly 10% of the GDP and employs approximately 7% population of the country.

India is seen as one of the fastest-growing economies in the world and has a huge potential for organised retail as currently about 3% of the Indian retail is organised. The remaining 97% share is taken by the local mom and pop shops, an unorganized retail that constitutes of India’s Informal Economy.

Even the government is taking measures to help the organised retail sector in its expansion like relaxing restrictions such as franchising, licensing, wholesaling. About 13 million small retailers exit in India, accounting for more than 83% of the Indian F&G sector, which would be projected to exceed USD 950 billion by 2022. But in a country like India which finds it tough to employ its ever-expanding workforce, a large-scale liberalization will adversely affect the large, unorganised retail sector.

Product / Services & process

We offer a supermarket with a self-service shop offering a wide variety of food, beverages, and household products, organized into sections and shelves. It is larger and has a wider selection than earlier grocery stores.

Market potential & Strategy

Inia is the world’s 6 largest grocery market with enormous development possibilities owing to expanding population and spending power. The Indian grocery sector, which represents 69 percent of India's overall retail sector provides merchants with several options. Numerous retail players had attempted to capitalize on this opportunity with little success. The small Kirana has always been the core of the Indian grocery market, accounting for 90 percent of sales. Even while retails giants compete for customer loyalty whenever it comes to grocery shopping, local business has kept their ground.

Furthermore, with growing spending power and internet usage, the e- supermarket is anticipated to develop at a rapid pace in the next years. The market for e – supermarket, which was valued at USD 1 billion in 2020, is expected to increase to USD 22 billion by 2022.

The fact that India is home to the youngest population in the world (avg. age - 27.6 yrs) plays a major role in the predicted shift in the Indian grocery market. This created a dynamic market environment in India and has opened up opportunities for the organized e-retail players.

Project at a glance

Name & Address of Unit

Supermarket

Address

Details of unit

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

Name & address of promoter(s)

Name		: Your name
Address		: Address
Phone		: 00000
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	Building advance	*******
2	Freezers	*******
3	Generator	*******
4	Computer and biling equipments	*******
5	Aircondition	*******
6	Racks and storage	*******
7	Electrification	*******
8	Preliminary expenses	*******
9	Interior work	*******
10	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	*******
9	Working capital loan	*******

Annual Sales / Revenue

Sl. no	Item	Rate		Quantity	Unit	Total Rs
1	Revenue from Sales	*******	X	312	Day	*******
	Total					*******

Total Yearly Expense

Sl. no	Item	Amount Rs
1	Rent	*******
2	Salary	*******
3	Accounts and admin	*******
4	Repairs & Maintanance	*******
5	Electricity	*******
6	Office expense & utilities	*******
7	Raw material purchase	*******
8	Wages	*******
9	Marketing/Advertisement	*******
	Total	*******

Application of Fund

Sl. no	Item	Subsidy %	No.	Rate	Amount Rs
1	Building advance	*******	1	*******	*******
2	Freezers	*******	2	*******	*******
3	Generator	*******	1	*******	*******
4	Computer and biling equipments	*******	1	*******	*******
5	Aircondition	*******	1	*******	*******
6	Racks and storage	*******	1	*******	*******
7	Electrification	*******	1	*******	*******
8	Preliminary expenses	*******	1	*******	*******
9	Interior work	*******	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