Project report for Packaged drinking water

Introduction

Water forms an essential part of every human being. Since it is a human necessity it makes the best sense to do business. As a normal human being requires an average of 2-3 liters of water every day and the world population is more than one billion (growing at 2-3% annually) the business opportunity is enormous and the potential is largely untapped. The bottled water industry is estimated to be a whopping 1600 crores business. It has grown at a rate of 38-40% annually over the past four years. Initially, bottled water brands like the French manufactured Damone were promoted at clubs, fitness centers, cinemas, department stores, malls, ice-cream parlors, cafes, and retail sports outlets, besides restaurants, hotels, and supermarkets with a price tag of ` 70/-for 1 liter bottle. Other brands later began pitching for the larger middle class and lower-middle-class markets

Market potential & Strategy

Earlier bottled drinking water was privileged to high class, foreign tourist and highly health-conscious people but the present decade has witnessed increasing popularity among average consumers, increasing living standards,  disposable income, education and awareness among the consumers domestic and foreign tourist, sophisticated business houses, and offices has increased rapidly the sales of bottled water in recent years. The growing demand for bottled water speaks volumes of the scarcity of clean drinking water and the quality of tap water. It has become an icon of a healthy lifestyle emerging in India. Selling –‘safety’ –i.e. pure and simple water has now become one of the fastest-growing industries in India despite the harsh truth it is built on the foundation of bad governance, inequality, and obvious exploitation.  

However, bottled water provides the distance  advantages of convenient packing,  consistent quality, and are ubiquitous. This particular industry in India has never looked back after the economic liberalization process of 1991-92. The fastest growth in the consumption of bottled water in the world has been recorded in India according to a new study conducted by the US-based earth policy institute. According to the Bureau of Indian Standards (BIS), there are 1200 bottling plants (out of which 600 are in the state of Tamilnadu) and 200 brands of packed drinking water across the country (nearly 80% of which are local) hitting over the markets which thoroughly signifies the market is big, even by international standards. 

These are boom times for the Indian bottled water industry –more so because the economics are sound. India is the tenth-largest bottled water consumer in the world. The consumption of smaller units of 500 ml has increased by around 140% perceptibly. Even school children are carrying the 500 ml packs in their school bags. The 20-liter bulk water jars have found phenomenal acceptance in households and at the workplace. With the growing market size, one can imagine the employment opportunity being created with the surge in the bottled water industry. The bottled water market is dominated by major players such as Coca-cola, Pepsico, Parle, K.K. Beverages, Manikkchand, Tata-Mount Everest. Although we have a large number of players, Parle was the pioneer among the major player when it was launched in India, 35 years ago.

Name & Address of Unit

Packaged drinking water

Address

Details of unit
Email : [email protected]
Phone : 0000000
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 : 0000000
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 Land and Building *******
2 Motor and related pump sets *******
3 RO system and Other filtering equipments *******
4 Testing equipments *******
5 Computer, CCTV, Printer *******
6 Computer tables and furnitures *******
7 Electrification *******
8 Preliminary expenses *******
9 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 420000 liter *******
Total *******

Sl. no Item Amount Rs
1 Salary *******
2 Accounts and admin *******
3 Repairs & Maintanance *******
4 Electricity *******
5 Office expense & utilities *******
6 Wages *******
7 Marketing/Advertisement *******
Total *******
Sl. no Item Subsidy % No. Rate Amount Rs
1 Land and Building ******* 1 ******* *******
2 Motor and related pump sets ******* 1 ******* *******
3 RO system and Other filtering equipments ******* 1 ******* *******
4 Testing equipments ******* 1 ******* *******
5 Computer, CCTV, Printer ******* 1 ******* *******
6 Computer tables and furnitures ******* 1 ******* *******
7 Electrification ******* 1 ******* *******
8 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.

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