Introduction

Two decades back, the average consumer spending on healthcare was eight percent; today it is 20 percent. The customer has also become aware of various offerings in the pharma market and is demanding better services. The mercury has reached a new high where the Indian consumer's priority for healthcare is concerned today.
The spending on healthcare is comparatively higher than what he spends on apparel or entertainment. Pharmacy retailing is expected to become more organized and corporatized in the coming years. Indian Retail Pharmacy industry is widely fragmented throughout the country. The total Indian retail pharmacy market has been growing at an average of 18% per annum over the last few years and is anticipated to grow by even higher numbers in the future.

Market potential & Strategy

The total size of the global health and beauty market is between US$ 18 to 20 billion (approximately Rs 900 billion), which includes over 7.5 lakh chemist shops. The market is growing by approximately 18 percent per annum. Statistics reveal that pharmacy retailing in India has a market size of over Rs 32,000 crore. The increasingly health-conscious Indian today has numerous retail pharmacies jostling for his attention (and money). These pharmacies offer a great choice to the consumer.
With pharmacy retailing becoming more and more organized, and a large number of retail formats coming up, the consumer has a greater choice concerning quality, price, and variety.

Project at a glance

Name & Address of Unit

Medical shop

Address

Details of unit

Email	:	[email protected]
Phone	:	000
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]

Project Feasibility Ratios

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

Project Feasibility graph

Net profit Sales %

Quick ratio

Revenue v/s Expense

Expense Splitup

Project Cost

Sl. no	Item	Amount Rs
1	Building Advance	*******
2	Refrigetaror	*******
3	Racks and storage units	*******
4	Counter table and chairs	*******
5	Electrification	*******
6	Preliminary expenses	*******
7	Illuminating name board	*******
8	Glass work	*******
9	Working Capital	*******
	Total	*******

Working Capital Computation

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

Annual Sales / Revenue

Sl. no	Item	Rate		Quantity	Unit	Total Rs
1	Sales	*******	X	7800	Number	*******
	Total					*******

Total Yearly Expense

Sl. no	Item	Amount Rs
1	Shop Rent	*******
2	Salary	*******
3	Electricity charges	*******
4	Office Stationary	*******
5	Rawmaterials	*******
6	Advertisement	*******
	Total	*******

Application of Fund

Sl. no	Item	Subsidy %	No.	Rate	Amount Rs
1	Building Advance	*******	1	*******	*******
2	Refrigetaror	*******	1	*******	*******
3	Racks and storage units	*******	1	*******	*******
4	Counter table and chairs	*******	1	*******	*******
5	Electrification	*******	1	*******	*******
6	Preliminary expenses	*******	1	*******	*******
7	Illuminating name board	*******	1	*******	*******
8	Glass work	*******	1	*******	*******
	Total Investment				*******
	Total Subsidy				*******
	Net Investment				*******

Means of Finance

Sl. no	Item	Amount
1	Term Loan	*******
2	Working capital Loan	*******
3	Total loan	*******
4	Term Loan contribution	*******
5	Working capital contribution	*******

Profitability Statement

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

Cash flow statement

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

Balance sheet

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

Repayment of Term loan

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

Debt Service Coverage Ratio

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

Depreciation

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

Conclusion

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.

View a sample report in pdf

Click here to create a project report for your business in less than 10 mins