Project report for Supermarket

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.

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]
Debt Service Coverage Ratio (Average) :1.87
Current ratio (Average) :2.63
Year 1Year 2Year 3Year 4Year 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
Net profit Sales %
Quick ratio
Revenue v/s Expense
Expense Splitup
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 *******

 

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 *******

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

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 *******
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 *******
Sl. no Item Amount
1 Term Loan *******
2 Working capital Loan *******
3 Total loan *******
4 Term Loan contribution *******
5 Working capital contribution *******

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

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.

Read in the language you are comfortable with - image
Read in the language you are comfortable with - image
Click buttons to create report

Project report format for bank loan

A good project report may contain the specific segments and in detailed format to gain confidence from the loan issuing authority

Check format >

Need assistance?

Get help from our experts. Drop us a Whatsapp message now! View video help >

WhatsApp Icon WhatsApp us  Chat Icon Chat with expert

Have some questions?

Share your details, we will call you