Create Project report in 10 mins by following the 3 steps.
India has an internet users base of about 475 million as of July 2018, about 40% of the population. Despite being the second-largest user base in world, only behind China (650 million, 48% of population), the penetration of e-commerce is low compared to markets like the United States (266 million, 84%), or France (54 M, 81%), but is growing at an unprecedented rate, adding around 6 million new entrants every month. India's e-commerce market was worth about $3.9 billion in 2009, it went up to $12.6 billion in 2013. In 2013, the e-retail segment was worth US$2.3 billion. About 79% of India's e-commerce market is travel related. According to Google India, there were 35 million online shoppers in India in 2014 Q1 and was expected to cross 100 million marks by the end of the year 2016. CAGR vis-à-vis a global growth rate of 8–10%. Electronics and Apparel are the biggest categories in terms of sales. According to Google India Research, by 2021 India is expected to generate $100 billion online retail revenue out of which $35 billion will be through fashion e-commerce. Online apparel sales are set to grow four times in the coming years.
The company focuses on Retail Business before expanding into other product categories such as Home furnishing, fashion, and lifestyle products.Firm is planning to sell high quality imported fashion products, mobiles, electronics, home appliances, & furniture. etc. The company is planning to sell high-quality items at an affordable price. The vast improving consumer base of Flipkart, Amazon, snapdeal like platforms are ideal for selling these kinds of products. Flipkart, Amazon, Snapdeal, Paytm, Shopclues, Myntra, Jabong, YepMe, Voonik tc were the leading providers identified and planning to sell through these platforms.
India has the fastest growing online retail market among top global economies. The country’s online retail market witnessed a compound annual growth rate (CAGR) of 53% for the period 2013 to 2017. The rapid growth, albeit over a small base, has been driven by aggressive discount-driven e-commerce marketplaces, advances in delivery infrastructure and increased smartphone penetration and data usage. Retail ecosystems comprise communities of consumers, retailers etailers and partners that rapidly reshape the retail landscape. A fast-growing economy and robust demographics provide a positive outlook to the consumer businesses in India.
Firm's products are looking to sell purely through the online media. With the invent of Jio fiber optics by 2019 September the online penetration in India will reach three-fold increase. The firm is planning to sell high quality imported fashion products, mobiles, electronics, home appliances, & furniture. etc. Flipkart, Amazon, Snapdeal, Paytm, Shopclues, Myntra, Jabong, YepMe, Voonik tc were the leading providers identified and planning to sell through these platforms. .The marketing is planning through social media and digital marketing. Providing sufficient discounts and providing proper customer service will help the firm to achieve the success very easily.
e-commerce (Electronics/Apparels)
Address
: | [email protected] | |
Phone | : | 000000 |
Constitution | : | Proprietership |
Scheme | : | |
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 | Office furnitures | ******* |
3 | Aircondition | ******* |
4 | Stands and racks | ******* |
5 | Laptops , scanner & printer | ******* |
6 | Preliminary expenses | ******* |
7 | 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 | 27000 | Number | ******* |
Total | ******* |
Sl. no | Item | Amount Rs |
---|---|---|
1 | Office rent | ******* |
2 | Online marketing &SEO | ******* |
3 | Manager | ******* |
4 | Accounts and admin | ******* |
5 | Repairs & Damage | ******* |
6 | Electricity | ******* |
7 | Office expense & utilities | ******* |
8 | Purchase of stock | ******* |
9 | Marketing/Advertisement | ******* |
Total | ******* |
Sl. no | Item | Subsidy % | No. | Rate | Amount Rs |
---|---|---|---|---|---|
1 | Building advance | ******* | 1 | ******* | ******* |
2 | Office furnitures | ******* | 1 | ******* | ******* |
3 | Aircondition | ******* | 1 | ******* | ******* |
4 | Stands and racks | ******* | 1 | ******* | ******* |
5 | Laptops , scanner & printer | ******* | 1 | ******* | ******* |
6 | Preliminary expenses | ******* | 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