Create Project report in 10 mins by following the 3 steps.
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.
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.
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.
Supermarket
Address
: | [email protected] | |
Phone | : | 000000 |
Constitution | : | Proprietership |
Total project cost | : | ******* |
Fixed Capital | : | ******* |
Working Capital | : | ******* |
Total Bank loan | : | ******* |
Promoter(s) contribution | : | ******* |
Term loan | : | ******* |
Working capital loan | : | ******* |
|
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 |
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.
Get help from our experts. Drop us a Whatsapp message now
A good project report may contain the specific segments and in detailed format to gain confidence from the loan issuing authority
Check formatGet help from our experts. Drop us a Whatsapp message now! View video help