Project report for Ecommerce

Introduction

E-commerce has transformed the way business is done in India. The Indian E-commerce market is expected to grow to US$ 200 billion by 2026 from US$ 38.5 billion as of 2017. Much of the growth for the industry has been triggered by an increase in internet and smartphone penetration. The ongoing digital transformation in the country is expected to increase India’s total internet user base to 829 million by 2021. The new normal life after the COVID -19 will defenitely make the purchase behaviour of the user at the same time the business models too. people prefer to buy thngs without direct contact and the invent of new cheap devices, people tend to go digitally.Propelled by rising smartphone penetration, launch of 4G network and increasing consumer wealth, the Indian E-commerce market is expected to grow to US$ 200 billion by 2026 from US$ 38.5 billion in 2017.Smartphone shipments in India increased eight per cent y-o-y to reach 152.5 million units in 2019, thereby making it the fastest among the top 20 smartphone markets in the world. We saw the changes during lockdown as people tend to buy mostly through online mediums than direct purchases. Internet penetration in India grew from just 4 per cent in 2007 to 52.08 per cent in 2019, registering a CAGR of 24 per cent between 2007 and 2019. The number of internet users in India is expected to increase from 687.62 million as of September 2019 to 829 million by 2021.

Market potential & Strategy

Owing to the increasing internet user base and favorable market conditions, India has a lot of potential in the e-commerce industry. Growing at an exponential rate, the market value of the e-commerce industry in India was approximately 50 billion U.S dollars in 2018. This number was estimated to reach 200 billion U.S. dollars by 2027. Since 2014, the Government of India has announced various initiatives, namely Digital India, Make in India, Start-up India, Skill India, and Innovation Fund. The timely and effective implementation of such programs will likely support the growth of E-commerce in the country. The behavioral pattern of the user dramatically changed post-COVID-19. So the scope of eCommerce based business is on the higher side. The E-commerce industry has been directly impacting micro, small & medium enterprises (MSME) in India by providing means of financing, technology, and training and has a favorable cascading effect on other industries as well. The Indian E-commerce industry has been on an upward growth trajectory and is expected to surpass the US to become the second-largest E-commerce market in the world by 2034. Technology-enabled innovations like digital payments, hyper-local logistics, analytics-driven customer engagement, and digital advertisements will likely support the growth in the sector. The growth in the E-commerce sector will also boost employment, increase revenues from export, increase tax collection by ex-chequers, and provide better products and services to customers in the long-term. The rise in smartphone usage is expected to rise 84 percent to reach 859 million by 2022. We will market through social media, google, SEO/SEM, etc. The cost of digital marketing is cheap compared with the traditional mode of advertisement. At the same time, the effectiveness comparing to the cost is at the higher side too. By giving catchy ads on social media, people will notice, and also by giving offers and innovative digital marketing techniques, the sales can skyrocket. 

Name & Address of Unit

Ecommerce

Your address

Details of unit
Phone : 123
Constitution : Proprietership
Number of employment : 10
Total project cost : *******
Fixed Capital : *******
Working Capital : *******
Total Bank loan : *******
Promoter(s) contribution : *******
Term loan : *******
Name & address of promoter(s)
Name : Your name
Designation : Proprietor
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 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 *******

Sl. no Item Amount Rs
Total *******
Sl. no Item Subsidy % No. Rate Amount Rs
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