Introduction

Coconut is a small holder’s plantation crop grown in the humid tropics and tropical regions. India is a major producer of coconut in the world. The country’s production is 12535.9 million nuts from an area of 17.54 lakhs hectares. Virgin coconut oil is obtained from fresh matured coconut. This oil is mainly used as a body massage oil and as an ingredient in Ayurveda medicine. It is used as hair oil. It is applied on the body of babies to protect from skin troubles. There is very good demand of virgin coconut oil rather than general coconut oil. There is demand growth of coconut oil is 10% per annum. Govt. of India declared minimum support price for both milling and edible copra. The prices of coconut oil and copra continued to rule at low level in all the major markets. Virgin coconut oil has very good demand. To looking this increasing demand, we can say that any new entrepreneur can venture into this field.

Coconut oil or coconut butter is an edible oil derived from the wick, meat, and milk of the coconut palm fruit. Coconut oil is a white solid fat, melting at warmer room temperatures of around 25 °C (78 °F), in warmer climates during the summer months it is a clear thin liquid oil. Unrefined varieties have a distinct coconut aroma. It is used as a food oil, and in industrial applications for cosmetics and detergent production. Due to its high levels of saturated fat, numerous health authorities recommend limiting its consumption as a food. Coconut oil, is an edible oil extracted from the kernel or meat of mature coconuts harvested from the coconut palm. Today, consumers desiring to purchase coconut oil have a wide variety of choices. Coconut oil is often described as the “healthiest oil on earth.”

Market potential & Strategy

The India coconut oil-based cosmetics market stood at a value of 8225 INR Crore in 2020. The market is further expected to grow at a CAGR of 6.8% in the forecast period of 2021-2026 to attain 12523 INR Crore by 2026. This can be attributed to the rising awareness about the advantages of using coconut oil-based skin care products. The demand for coconut oil in anti-aging creams, owing to its anti-oxidant properties, has been significant. It is utilized as one of the base ingredients in popular skin care as well as hair care products. Furthermore, coconut oil-based cosmetics reduce inflammation, keep skin moisturized, and prevents acne. Therefore, they have a significant demand in the beauty industry in India. Over the forecast period, the coconut oil-based hair care products are likely to witness a robust growth in the country owing to the rising pollution in states like Delhi, Haryana, Uttar Pradesh, and Maharashtra, among others, as they are effective in preventing the damage of hair. The rising disposable income, increasing competition among key market players in the cosmetics and personal care sector, and the descent growth rate of India’s economy are expected to further bolster the market growth in the forecast period.

Project at a glance

Name & Address of Unit

Coconut Oil

Your address

Details of unit

Email	:	[email protected]
Phone	:	0000000000
Constitution	:	Proprietership
Total project cost	:	*******
Fixed Capital	:	*******
Working Capital	:	*******
Total Bank loan	:	*******
Promoter(s) contribution	:	*******
Term loan	:	*******

Name & address of promoter(s)

Name		: Proprator
Designation		: Proprator
Category		: General

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

Total Yearly Expense

Sl. no	Item	Amount Rs
	Total	*******

Application of Fund

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