Dhruv DPR Final
Dhruv DPR Final
INDIA
1
DECLARATION
CERTIFICATE
Date:
2
ACKNOWLEDGMENT
I would like to express my sincere gratitude to my mentors, Dr. Sheetal Thomas and Mr.
Shiv Kothari, for their invaluable guidance, encouragement, and continuous support
throughout the preparation of this Detailed Project Report (DPR) on “Establishing Peanut
trading and export Business”. Their expert insights, constructive feedback, and
unwavering patience have been instrumental in refining my ideas and enhancing the
quality of this report.
I would also like to thank my family, friends, and peers for their constant support,
motivation, and encouragement throughout this journey. Their belief in my abilities and
willingness to assist me whenever needed have been a great source of strength.
[Dhruv Tavethia]
4
1. Cost of Project 31
2. Means of finance 31
G Risk Involved 32
H Implementation 33
1. Time Required 33
2. Critical Areas 33
I Key Success Factors & Challenges 34
1. SWOT Analysis 34
2. Key Success factors 35
3. Key challenges and proposed action plan 35
J Data Sources/References 36
1. Data Sources/ References 36
2. Assistance sought 36
K Annexures
1. Promoter’s Biodata 37
2. Projected Profit & Loss sheet 37
3. Cash Flow Projections 38
4. Projected Balance Sheet 39
5. Proposed Organization chart and annual manpower 40
costs
6. Working Capital Assessment 40
7. Cost of Project & Depreciation Calculation 41
8. Loan Repayments 41
9. Sales Projections 42
10. Overheads 42
11. Raw Materials calculations 42
12. Means of Finance 43
13. Break Even Analysis 43
14. Calculation of Debt Equity Ratio 43
15. Payback Period Calculations 44
16. IRR Calculations 44
17. Interest Coverage Ratio 45
18. Key Indicators of the Project 45
5
A. Executive Summary
The business aims to export and trade high-quality peanuts sourced from Junagadh, Gujarat,
India. The company will focus on sourcing, processing, packaging, and exporting peanuts to
international markets. The target markets include indian markets and countries with growing
demand for healthy, nutritious, and organic food products, such as the Middle East, Europe,
and Southeast Asia.
The idea stems from the global demand for nutritious, plant-based protein and organic foods.
While peanuts are one of India’s major agricultural exports, there is a need for consistent
supply, high-quality (preferably organic) peanuts that meet international food safety standards.
Existing supply chains often fail to meet these high demands, leaving international markets with
gaps in supply.
Problem:
Inconsistent Quality and Supply: There is an issue with the supply of high-quality
peanuts due to varying farming practices, quality control gaps, and inconsistent post-
harvest handling.
Safety and Quality Assurance: Many international markets have stringent food safety
standards (e.g., HACCP, ISO), which are not always met by existing peanut suppliers
from India and other regions.
Supply Chain Disruptions: Global trade disruptions and poor logistics infrastructure can
delay the delivery of high-quality peanuts.
Solution:
Sourcing: The business will establish long-term relationships with local peanut farmers
in Junagadh to secure premium-grade Groundnuts.
Processing: The peanuts will undergo cleaning, grading, color sorting and
packaging at a modern facility to ensure they meet international food safety
standards (ISO, HACCP).
Export: The company will create a reliable and efficient distribution network to sell it
into indian market at premium price as well as to export the peanuts, focusing on high-
demand markets like the Middle East, Europe, and Southeast Asia. Emphasis will be
placed on high-quality, organic, and traceable products.
6
2. Expected Initial Investment, Return on Investment (ROI), and Payback Period
TOTAL 2,23,45,479.80
The projected revenue model is based on the sale of high-quality peanuts and value-added
products (roasted, salted peanuts, peanut butter, etc.) to domestic and international buyers.
Projected Annual Revenue: ₹ 5,00,00,000 from the sale of raw peanuts and value added peanuts.
Expected ROI:
Payback Period:
Conduct market research, secure farmer partnerships, and develop the business plan.
Set up the processing facility, obtain certifications, and install necessary equipment.
Finalize farmer contracts, source peanuts, and initiate production and quality control.
Begin trading & exports, establish logistics, and scale production based on demand.
Introduce value-added products, expand to new markets, and increase production capacity.
8
4. Findings & Conclusion
Findings:
Strong Demand for Peanuts: There is consistent indian market and global demand for
peanuts, especially in regions like the Middle East, Europe, and Southeast Asia, driven
by their nutritional value and usage in various food products.
Government Support: The Indian government has a favorable policy environment for
agricultural exports, offering incentives and subsidies to businesses in this sector.
Scalability Potential: The business has considerable growth potential, not only by
increasing peanut production but also by expanding into value-added products like
peanut butter, oil, and roasted peanuts, which will cater to a broader consumer base.
Conclusion: The proposed business of exporting high-quality peanuts from Junagadh, Gujarat,
offers a unique opportunity in the agriculture export sector. With strong demand for
peanuts, especially in international markets, and a robust export strategy, the business is well-
positioned to succeed. Additionally, by ensuring high standards of quality control, compliance
with international certifications, and developing value-added products, the business can create a
competitive edge in the market.
Financially, the business offers promising returns, with a payback period of just over 23
months, and considerable growth potential as demand for healthy and plant-based foods
continues to rise globally.
9
B. General
Product Overview:
The proposed business focuses on the export and trading of high-quality peanuts sourced from
Junagadh, Gujarat, India. The peanuts will undergo rigorous cleaning, grading, color sorting
and packaging before being exported to international markets. The product offerings will
primarily be raw peanuts, but the company will also explore value-added products such as
roasted peanuts, peanut butter, and peanut oil as the business grows.
Peanuts, known for their high nutritional value, are widely consumed in various forms globally.
They are rich in proteins, healthy fats, and essential vitamins, making them a staple in many
diets. The product range will be targeted at consumers, food manufacturers, snack companies,
and health-conscious individuals, especially in indian regions and regions such as the Middle
East, Europe, and Southeast Asia, where peanuts are popular.
Applications:
Food Industry: Peanuts are used in multiple food products such as snacks, confectionery
(e.g., peanut brittle), sauces, and garnishes. Roasted and salted peanuts are popular as a
snack in many cultures.
Peanut Butter Production: Ground peanuts are processed into peanut butter, a popular
product in countries like the United States, Canada, and Europe. Peanut butter is used
in spreads, snacks, and various food preparations.
Oil Extraction: Groundnut oil is a commonly used cooking oil due to its neutral flavor
and high smoking point. It is also used in the cosmetic industry.
Animal Feed: Peanut meal, the by-product from oil extraction, is rich in protein and used
as animal feed.
Health Foods: There is a growing trend towards plant-based foods, and peanuts are a
primary source of protein in vegetarian and vegan diets. Peanuts are also used in energy
bars, protein powders, and other health-conscious snack products.
10
2. Government Policy & Support
The Indian government has consistently supported the agricultural export sector, including
peanuts, through various policies, initiatives, and schemes to enhance exports and improve
infrastructure. Some of the key support mechanisms and policies are:
Export Promotion Schemes: The Indian government offers incentives under schemes
like the Merchandise Export from India Scheme (MEIS), which provides export
incentives and duty remission to exporters. This helps reduce export costs and enhance
competitiveness in international markets.
Agricultural Export Zones (AEZ): Gujarat, where Junagadh is located, falls under the
Agricultural Export Zone scheme. The government provides financial support to
businesses in these zones to develop infrastructure and logistics for exports.
Farming Support Programs: The National Mission on Edible Oils (NMEO) and other
crop-specific programs support peanut farmers in India by improving production
techniques, quality, and yields, which ultimately benefits the peanut export sector.
Food Safety Standards: The government, through agencies such as the Food Safety and
Standards Authority of India (FSSAI), ensures that exported agricultural products meet
international standards. Obtaining HACCP (Hazard Analysis Critical Control Point) and
ISO certifications for the production facility is essential to comply with these standards.
Customs and Trade Facilitation: The government has simplified the customs clearance
process for agricultural exports and has worked towards enhancing infrastructure like
ports, highways, and cold storage facilities to support the efficient export of products like
peanuts.
Subsidies for Organic Farming: If the business decides to include organic peanuts in
the product range, there are various government subsidies available under organic
farming schemes, including those for certification and promoting organic farming.
3. Promoter Background
11
4. Locational Advantage
The business will be located in Junagadh, Gujarat, a prime location for groundnut
cultivation. Junagadh is renowned for producing some of the highest-quality peanuts in India
due to its ideal climate, soil conditions, and established farming practices.
Access to Ports: Junagadh is strategically located in Gujarat, which has several major
ports like Kandla Port and Mundra Port. These ports facilitate the efficient export of
peanuts to international markets. The proximity to these ports reduces logistical costs and
time for international shipping.
12
C. Market
1. Industry Research
Industry Size:
India is the largest producer of peanuts globally, accounting for roughly 35% of the world’s total
production, which was approximately 6 million tons in the most recent harvest year (Ministry of
Agriculture, India, 2023). Gujarat is the leading state in peanut production, contributing nearly
40% of the national total. The state has about 1.5 million hectares dedicated to peanut
cultivation, with an average yield of approximately 1,800 kg per hectare. Moreover, India’s
diverse agro-climatic conditions allow for the cultivation of various peanut varieties, including
Java, Bold, and Spanish, catering to different market demands.
3. Export Potential
India's peanut exports were valued at around $1.5 billion in 2023, with significant portions
shipped to markets in the Middle East, Europe, and Asia (APEDA, 2023). Major importers
include countries like the United States, China, and the European Union, with the U.S. alone
accounting for over 25% of India’s total peanut exports. Furthermore, recent trade agreements
and partnerships have opened new markets in regions such as Southeast Asia and Africa,
enhancing India's export potential.
13
2. Business Idea, Pain Points, and Solutions – Clear Value Proposition
Business Idea:
The business will focus on both trading peanuts within India and exporting high-quality peanuts,
including raw and value-added products (roasted peanuts, peanut butter, peanut oil), to
international markets. It will serve both domestic and global demand for healthy and sustainable
food options.
1. Inconsistent Quality
Solution: Focus on eco-friendly farming practices with peanuts that enrich soil
naturally, supporting both local farmers and the environment.
Solution: Offer a broad product range (raw, roasted, peanut butter, peanut oil)
with custom solutions like private labeling for both Indian retailers and
international buyers.
Solution: Utilize Junagadh’s strategic location for smooth trade within India and
facilitate international exports. An online platform will ensure easy access for
both domestic and global consumers.
Value Proposition:
The business delivers high-quality peanuts with a strong focus on sustainability, a diverse
product range, and accessibility in both domestic and global markets, ensuring consistency
and premium offerings for a wide customer base.
14
3. Target Market – KYC (Know Your Customer) and Buyer Persona
B2B Buyers: Indian and International wholesalers, distributors, and retailers of raw
peanuts and value-added products (like roasted peanuts, peanut butter, peanut oil).
Geographies: Targeting Middle Eastern, European, and Southeast Asian markets with
rising demand for high-quality organic peanuts.
Buyer Persona:
Buyer Type: Retail chains, health food stores, snack manufacturers, and exporters.
Demographics: Typically large food manufacturers or retail companies that need high-
quality and certified organic peanuts.
Growing Demand for Varieties and Processed Products: Adapt supply strategies to
focus on specific peanut varieties and processed products in response to market feedback.
15
5. Present and Projected Market Size, Market Growth Potential, and Market Share
(5-7 years)
Global Peanut Market (TAM): The global peanut market is valued at approximately
$32 billion in 2023 and is expected to reach $35 billion by 2027. This includes raw
peanuts, processed products like peanut butter, peanut oil, and snacks.
Indian Peanut Market (SAM): India’s share in the global peanut market is valued at $5
billion. India remains the largest producer and exporter of peanuts globally, with Gujarat
contributing to around 40% of the country’s peanut production.
Junagadh’s Market (SOM): The local market for Junagadh-based businesses can be
estimated at $1 billion. This represents the realistic portion of the market that businesses
in Junagadh can capture, factoring in competition and export potential.
Global Market Growth: The global peanut market is projected to grow at a compound
annual growth rate (CAGR) of 3-4% over the next 5-7 years, driven by the increasing
awareness of health benefits, the rise in demand for plant-based protein, and growing
consumption in emerging markets.
Indian Market Growth: India’s peanut exports, currently valued at $1.5 billion, are
expected to increase as the global demand for high-quality peanuts continues to grow.
The export value is projected to reach $2 billion by 2027, with Junagadh’s contribution
seeing a steady rise, especially in value-added products like peanut butter and snacks.
Junagadh’s Market Potential: With Junagadh’s premium quality peanuts and the
strategic positioning of businesses, Junagadh-based exporters can increase their share of
the $1 billion market to approximately $1.2 billion by 2027. Growth will be driven by
expanding exports to emerging markets like Southeast Asia and Africa, as well as a
stronghold in traditional markets like the U.S. and Europe.
16
Market Growth Potential:
Health and Wellness Trends: Rising demand for plant-based protein and healthier snack
options will contribute to an expanding market for peanuts. The global market for plant-
based proteins is expected to reach $27 billion by 2027, creating a massive opportunity
for peanuts.
Emerging Markets: Southeast Asia, Africa, and other regions are showing increased
demand for peanuts, driven by the rising middle class, changing dietary habits, and a
need for affordable protein. These regions offer significant potential for expansion, with
an estimated $500 million market potential for Junagadh-based exporters.
Value-Added Products: The market for value-added peanut products (peanut butter,
snacks, oils) is rapidly growing, with the global peanut butter market expected to reach
$4.4 billion by 2025. Junagadh, producing premium peanuts, is well-positioned to capture
this market through processed goods exports.
E-Commerce and Direct Sales: The shift to e-commerce and direct-to-consumer sales
channels is expected to increase accessibility to international markets. By leveraging
online platforms, businesses in Junagadh can directly tap into health-conscious
consumers and niche markets.
17
6. Competitor Analysis
18
Advanced Higher
processing production
Peanut
Leading technology, costs,
butter,
ADM (Archer United global food strong competition
roasted
Daniels Midland) States processing presence in from
peanuts,
company North emerging
peanut oil.
America markets like
and Europe. India.
Focus on
Small-scale
organic and
operation
non-GMO Organic
Growing compared
Parivar Agro Rajkot, peanuts, peanuts,
Indian peanut to larger
Foods Gujarat expanding peanut
exporter firms like
presence in kernels.
Olam or
premium
ADM.
markets.
Limited
Local
export
sourcing
Local player reach, Raw
from
with lower peanuts,
Khedut Feeds & Junagadh, Junagadh
expanding economies peanut oil,
Foods Pvt. Ltd. Gujarat farmers,
export of scale peanut
good quality
capacity compared flour.
control and
to global
certification.
firms.
Advanced
R&D in Strong
Peanut oil,
Key global peanut- competition
peanut
Golden Peanut United player in based in price-
butter,
and Tree Nuts States peanut products, sensitive
roasted
processing extensive markets like
peanuts.
supply India.
chain.
Focus on
high-
quality, Limited to Peanut
Leading
value-added select butter,
Bhavnagar, peanut
VK Industries peanut markets like peanut
Gujarat exporter from
products, the Middle kernels,
Gujarat
growing East. peanut oil.
international
footprint.
19
7. Details of existing players, their names, market share and marketing channels
Market Share: Leading exporter from India, large-scale exports to Europe and Asia.
Marketing Channels: B2B sales through wholesalers, food processors, and large-
scale retail chains.
3. Bajaj Pulses
4. Olam International
Market Share: Leading global food processing company with a solid market
presence in North America and Europe.
Marketing Channels: Retail distribution through supermarkets, wholesalers, and
food manufacturers.
20
7. Khedut Feeds & Foods Pvt. Ltd.
9. VK Industries
Present Market Opportunity: The global peanut market is expanding due to increasing health
awareness, with consumers seeking plant-based protein and nutritious snacks. India, as the largest
producer, is well-positioned to meet both domestic and international demand, particularly from North
America, Europe, and the Middle East. In 2023, India’s peanut exports were valued at $1.5 billion,
with demand for raw and processed peanut products growing. The rise of e-commerce provides new
opportunities for direct-to-consumer sales, particularly for health-conscious and organic products.
Additionally, emerging markets in Southeast Asia and Africa are experiencing rising peanut
consumption, driven by growing middle-class incomes and demand for affordable protein.
Future Market Opportunity (Next 5-7 Years): The future scope is highly promising, with
significant growth in value-added peanut products like peanut butter, snacks, and peanut oil. The
global peanut butter market is projected to reach $4.4 billion by 2025, and the demand for plant-
based proteins is set to rise to $27 billion by 2027. Junagadh, with its premium peanuts, has an
opportunity to capture these markets. Emerging markets in Southeast Asia, Africa, and the Middle
East present substantial export growth potential. Furthermore, the increasing preference for
sustainable and organic products aligns with the eco-friendly nature of peanuts, providing a niche for
organic and certified peanuts in premium markets. Technological advancements in product
development and digital marketing will further enhance global market access and customer
engagement.
21
9. Proposed Marketing Channels, Reasons, and Feasibility of Using Those Channels
National Supermarkets and Health Stores: Supply packaged peanuts and peanut-
based products to national and regional retail chains.
B2B Sales Channels are essential for securing long-term, stable revenue from large-scale
buyers like food manufacturers and distributors. Exporting directly to international markets
will cater to high demand regions like the U.S. and Europe.
E-commerce aligns with the growing trend of online shopping, especially among younger
consumers. Direct-to-consumer sales via online platforms allow for broader market reach and
a more personalized customer experience.
Retail Channels enable access to mass-market customers and provide visibility for the
products in high-traffic locations. It also allows the brand to tap into a large volume of
consumer purchases, especially for peanuts and snacks.
22
10. Pricing Considerations Vis-à-Vis Competitors
Pricing Considerations:
Cost-Plus Pricing Strategy: Pricing will be based on the production cost of peanuts, processing
costs, packaging, and logistics, with a reasonable margin added. For value-added products, like
peanut butter, a higher markup will be applied based on the added value of processing.
Competitor Benchmarking: Price comparisons with global competitors (e.g., U.S., China) will
guide pricing strategy. India's pricing advantage lies in the lower production costs due to efficient
farming practices in Junagadh.
Premium Products Pricing: Organic, sustainable, or specialized peanut products (e.g., peanut
butter, organic peanuts) will be priced at a premium to cater to health-conscious consumers and
niche markets.
Bulk and Contract Pricing: Offering discounts for bulk orders and long-term contracts to food
manufacturers and retailers, which incentivizes larger and repeat orders.
Promotional Strategies:
Digital Marketing:
o SEO and Content Marketing: Developing a strong online presence through search
engine optimization and content related to the health benefits of peanuts.
o Social Media Campaigns: Utilizing platforms like Instagram, Facebook, and
YouTube to engage health-conscious consumers, promoting the nutritional benefits
and sustainability of peanuts.
o Influencer Partnerships: Collaborating with health and wellness influencers to
endorse peanut products.
23
Sampling and Promotions:
o Local Market Focus: Initial focus on the domestic market in major Indian cities such
as Mumbai, Delhi, Bengaluru, and Kolkata, where demand for peanuts is high.
Building strong relationships with local distributors, wholesalers, and retailers will
help establish a stable customer base.
o Retail Partnerships: Partnering with regional supermarkets and health food stores to
place products on the shelves.
o Target High-Demand Export Regions: Focus on markets like the U.S., Europe, and
the Middle East where peanut consumption is high. Establish relationships with
international importers and distributors who understand local consumer preferences.
o E-commerce for International Expansion: Using e-commerce platforms like
Amazon and local food marketplaces in key export regions to sell directly to
international consumers.
24
D. Technology
1. Alternate Technologies / Processes Available, Advantages / Disadvantages, and
Cost/Benefit Analysis
Roasting Technology: Enhances flavor and shelf life but is energy-intensive. High initial
costs, but offers premium pricing in the snack market.
Cold Press Peanut Oil Extraction: Retains nutrients and flavor, appealing to health-
conscious consumers. Higher cost due to slower processing, but higher margins from
premium pricing.
Blanching: Improves color and texture for processed products like peanut butter. Energy-
consuming, but cost-effective for mass production.
Peanut Butter Processing: High market demand, but machinery is costly. Long-term profits
due to strong demand for natural peanut butter.
Precision Agriculture: Increases yield through data-driven farming but requires high
investment. Long-term gains through improved efficiency and sustainability.
Quality Control: Consistency can be difficult. Solution: Automated grading and AI-based
quality monitoring.
Supply Chain: Managing logistics effectively. Solution: Blockchain for traceability and
optimized logistics.
Farmer Technology Adoption: Small-scale farmers may resist new tech. Solution: Provide
training and incentives for adopting precision agriculture.
Domestic: High potential for scaling advanced processing technologies and precision
farming. Partner with technology firms for adoption.
25
E. Infrastructure / Utilities
1. Equipment Required, Manpower Requirements, Hiring, Training & Retention Plans,
Utilities Requirements, Other Licenses
Process Flow:
26
Equipment:
Packaging Machinery: Automated packaging lines for raw peanuts and value-added
products.
Storage Facilities: For raw peanuts, processed goods, and finished products.
Manpower Requirements:
Quality Control Experts: Staff for ensuring compliance with international food
safety standards.
Sales and Marketing Team: Experts in B2B and B2C marketing, trade negotiations,
and customer relationship management.
Training: Regular technical training to ensure the workforce is up-to-date with the
latest industry standards and machinery.
27
Utilities Requirements:
Internet & Communication: For supply chain management, digital marketing, and
communication with international buyers.
Other Licenses:
Location Advantages:
Proximity to Peanut Farms: Being based in Junagadh, the business benefits from
direct access to high-quality peanuts grown locally. Gujarat is one of the largest
peanut-producing states in India.
Export Accessibility: Gujarat’s well-developed ports like Mundra and Kandla offer
easy access to international markets, especially in Asia, Europe, and North America.
28
Infrastructure Requirements:
Processing Facility: Modern facilities with space for all stages of processing,
including cleaning, roasting, and packaging.
Warehousing: Large storage spaces for raw materials and finished products to ensure
smooth operations and maintain product quality.
29
3. Exceptional Utilities/Resources Required like Water, Fuel, Electricity, Air, etc.
Water: Significant amounts will be needed for cleaning and processing peanuts. Recycling
systems may be installed to ensure sustainable water use.
Fuel: Roasting peanuts and other processes may require fuel (natural gas or LPG). A backup
fuel supply is necessary for continuous operations.
Electricity: Power is crucial for operating heavy machinery, lighting, and the cooling
systems in the warehouse.
Air: Clean, dry air is necessary to maintain the quality of peanuts during storage and
processing. Proper ventilation systems should be in place.
30
F. Finance:
1. Cost of Project
The initial investment required for setting up the business involves costs across various areas
including infrastructure, equipment, working capital, and certifications. Below is a detailed
breakdown:
TOTAL 2,23,45,479.80
2. Means of Finance
The financing for this project will be sourced from a combination of equity capital, loans, and
possible government grants. Here’s the financing breakdown:
Means of Finance
Sr.No. Source Amount % of total
1 Own / Family savings 1,34,07,287.88 60%
31
G. Risks Involved
1. Technology Risks:
Risk: Challenges with adopting new technology may cause production delays.
5. Manpower Retention:
Mitigation: Stay updated on regulations, ensure compliance, and have contingency plans.
32
H. Implementation
Months 6-7: Initial raw material procurement, hiring, and training staff.
Months 8-9: Production trials, marketing campaign launch, and export logistics setup.
Supply Chain Setup: Establishing reliable supply chain links with farmers, vendors,
and exporters could face logistical challenges.
Skilled Workforce: Recruiting and training the right manpower, especially for
technical operations, may take time.
33
I. Key Success Factors & Challenges
1. SWOT Analysis:
Strengths:
Weaknesses:
Opportunities:
Threats:
Intense competition from established players like Olam, ADM, and regional
exporters.
Risks associated with changing government policies and regulations on
exports.
Currency fluctuations and trade barriers in global markets.
34
2. Key Success Factors:
Effective Export Network: Establishing a robust logistics and export network for
efficient delivery to international markets.
Action Plan: Develop strong relationships with local farmers, invest in supply
chain resilience, and use forward contracts to stabilize pricing.
Action Plan: Stay updated on trade policies, build relationships with export
promotion agencies, and ensure compliance with international standards and
certifications.
35
J. Data Sources / References
1. Websites Visited and Data Retrieved:
36
K. Annexures
1. Promoter Biodata
2. Profitability
Profitability
Sr.No. Particulars INR Rounded off to None % of Sales
Year-1 Year-2 Year-3 Year-4 Year-5 in Year-1
A) Gross Revenue (Sales) 5,03,72,270.75 5,33,35,345.50 5,62,98,420.25 5,62,98,420.25 5,62,98,420.25 1.00
Less: Variable Expenses
1 Raw Materials 3,18,75,000.00 3,37,50,000.00 3,56,25,000.00 3,56,25,000.00 3,56,25,000.00 0.63
2 Consumables - - - - - -
3 Utilities 4,01,520.00 4,25,138.82 4,48,757.65 4,48,757.65 4,48,757.65 0.01
4 Packing Materials 15,00,000.00 15,00,000.00 18,00,000.00 18,00,000.00 18,00,000.00 0.03
5 Direct Labour cost 19,80,000.00 19,80,000.00 30,60,000.00 30,60,000.00 30,60,000.00 0.04
Variable Marketing Expenses like
6 commission on sales per year -
Variable Logistics/ payment Gateway
7 charges etc per year -
8 Variable expenses - 3 per year -
9 Variable expenses - 4 per year -
Total Variable cost 3,57,56,520.00 3,76,55,138.82 4,09,33,757.65 4,09,33,757.65 4,09,33,757.65 0.71
37
3. Cash Flow Statement
Outflows
Payment of interest:
a) on term loans 4,46,909.50 4,02,218.55 3,57,527.60 3,12,836.65 2,68,145.70
b) on working capital 3,98,235.19 4,21,250.12 4,47,499.05 4,47,697.05 4,47,829.05
c) on other borrowings 2,23,454.80 2,01,109.32 1,56,418.36 1,11,727.40 67,036.44
Payment of income tax 19,93,865.25 22,14,580.74 19,87,698.52 19,94,735.30 20,05,385.28
Payment of dividend - 2,68,145.76 5,36,291.52 8,04,437.27 8,04,437.27
Payment of dividend distribution tax - 26,814.58 53,629.15 80,443.73 80,443.73
Repayment of /reduction in borrowings
a) term loans 4,46,909.50 4,46,909.50 4,46,909.50 4,46,909.50 4,46,909.50
b) working capital
c) other borrowings 2,23,454.80 4,46,909.60 4,46,909.60 4,46,909.60 4,46,909.60
Increase in Inventory 74,94,638.69 4,33,608.88 4,58,266.42 - -
Increase in Sundry Debtors 41,40,186.64 2,43,540.39 2,43,540.39 - -
Investment in new fixed assets / projects 1,69,15,000.00 - - - - -
Withdrawals from business
Summary
Opening balance - 54,30,479.80 93,71,175.05 1,84,17,540.05 2,63,64,315.83 3,42,57,581.94
Add: Inflows 2,23,45,479.80 1,93,08,349.61 1,41,51,452.43 1,30,81,465.89 1,25,38,962.60 1,25,00,862.60
Less: Outflows 1,69,15,000.00 1,53,67,654.36 51,05,087.44 51,34,690.11 46,45,696.50 45,67,096.57
Closing balance 54,30,479.80 93,71,175.05 1,84,17,540.05 2,63,64,315.83 3,42,57,581.94 4,21,91,347.97
38
4. Projected Balance Sheet
Applications of funds
1 Fixed Assets:
Opening Gross Block - 1,68,35,000.00 1,61,61,175.00 1,54,82,450.00 1,48,03,725.00 1,41,25,000.00
Additions during the year 1,68,35,000.00 - - - - -
Less: Depreciation during the year - 6,73,825.00 6,78,725.00 6,78,725.00 6,78,725.00 6,78,725.00
Less: Sale/scrap during the year - - - - - -
Net Block 1,68,35,000.00 1,61,61,175.00 1,54,82,450.00 1,48,03,725.00 1,41,25,000.00 1,34,46,275.00
2 Current Asssets:
Inventories 74,94,638.69 79,28,247.58 83,86,513.99 83,86,513.99 83,86,513.99
Cash & Bank Balance 54,30,479.80 93,71,175.05 1,84,17,540.05 2,63,64,315.83 3,42,57,581.94 4,21,91,347.97
Sundry Debtors 41,40,186.64 43,83,727.03 46,27,267.42 46,27,267.42 46,27,267.42
Other current assets
Gross current assets 54,30,479.80 2,10,06,000.38 3,07,29,514.65 3,93,78,097.24 4,72,71,363.35 5,52,05,129.38
Less: Sundry Creditors - 29,68,279.00 31,26,298.09 33,82,474.72 33,86,974.72 33,89,974.72
Net Current Assets 54,30,479.80 1,80,37,721.38 2,76,03,216.56 3,59,95,622.52 4,38,84,388.62 5,18,15,154.66
3 Prelim & Preop. Expenses not written off 80,000.00 72,000.00 64,000.00 56,000.00 48,000.00 40,000.00
4 P&L Account:
Opening balance - - - - - -
Additions during the year
Closing balance - - - - - -
39
5. Proposed Organization Chart and Annual Manpower Costs Organization chart
Manpower required / Employment Generated
Monthly salary per
Sr.No. Category Position Number of employees Annual Wage Bill rounded off to None
employee in
INR Year-1 Year-2 Year-3 Year-4 Year-5 Year-1 Year-2 Year-3 Year-4 Year-5
(A) Fixed cost manpower (irrespective of level of activity)
1 Marketing function Marketing Manager 35,000 1 1 2 2 2 4,20,000.00 4,20,000.00 8,40,000.00 8,40,000.00 8,40,000.00
sub-total of marketing function 4,20,000.00 4,20,000.00 8,40,000.00 8,40,000.00 8,40,000.00
2 Administrative Supervisor - Operations 25,000 2 2 3 3 3 6,00,000.00 6,00,000.00 9,00,000.00 9,00,000.00 9,00,000.00
Function
Accountant 20,000 1 1 1 1 1 2,40,000.00 2,40,000.00 2,40,000.00 2,40,000.00 2,40,000.00
1 Raw Materials No. of days consumption 30 26,19,863.01 27,73,972.60 29,28,082.19 29,28,082.19 29,28,082.19
2 Consumables No. of days consumption 30 - - - - -
3 Packing Materials No. of days consumption 30 1,23,287.67 1,23,287.67 1,47,945.21 1,47,945.21 1,47,945.21
4 Work in Process: No. of days production 7 6,11,301.37 6,47,260.27 6,83,219.18 6,83,219.18 6,83,219.18
5 Finished goods No. of days production 30 41,40,186.64 43,83,727.03 46,27,267.42 46,27,267.42 46,27,267.42
4 Receivables No. of days Sales 30 41,40,186.64 43,83,727.03 46,27,267.42 46,27,267.42 46,27,267.42
5 Utilities 1 month's expenses 1 33,460.00 35,428.24 37,396.47 37,396.47 37,396.47
6 Overheads 1 month's expenses 1 1,58,666.67 1,58,666.67 2,32,166.67 2,36,666.67 2,39,666.67
sub-total 1,18,26,952.00 1,25,06,069.50 1,32,83,344.55 1,32,87,844.55 1,32,90,844.55
Less: Creditors No. of days purchases 30 27,76,152.33 29,32,203.19 31,12,911.59 31,12,911.59 31,12,911.59
40
7. Depreciation Calculations
Additions during subsequent years Depreciation
Detailed
Sr.No. Particulars Project Cost Deprecia-
Annexure Year-1 Year-2 Year-3 Year-4 Year-5 Year-1 Year-2 Year-3 Year-4 Year-5
tion %
1 Land & site development: 24,00,000.00 0.00% - - - - -
2 Buildings 35,00,000.00 3.00% 1,05,000.00 1,05,000.00 1,05,000.00 1,05,000.00 1,05,000.00
3 Plan & Machinery / 95,00,000.00 4,75,000.00 4,75,000.00 4,75,000.00 4,75,000.00 4,75,000.00
equipments 5.00%
4 Infrastructure 12,00,000.00 7.00% 84,000.00 84,000.00 84,000.00 84,000.00 84,000.00
5 Furniture 45,000.00 8.50% 3,825.00 3,825.00 3,825.00 3,825.00 3,825.00
6 Electrical Installations 70,000.00 7.00% - 4,900.00 4,900.00 4,900.00 4,900.00
7 Other Assets 1,20,000.00 5.00% 6,000.00 6,000.00 6,000.00 6,000.00 6,000.00
8 Preliminary & Preoperative 80,000.00
Expenses
8 Margin for working capital 60% 54,30,479.80
TOTAL 2,23,45,479.80 0.00 0.00 0.00 0.00 0.00 6,73,825.00 6,78,725.00 6,78,725.00 6,78,725.00 6,78,725.00
8. Loan Repayments
41
9. Sales Projections
Sales Projections / Capacity Utilization during first 5 years
Margin % on Sale Annual
Sr.No. Product name / Service Description Unit of Quantity sold Sales Revenue rounded off to None
Unit Rate in Price in case of
Production / Sale Proposed capacity utilization as % of installed capacity
Measurement Retailing business
(leave blank for quantity at
INR manufacturing Year 1 Year 2 Year 3 Year 4 Year 5 Year 1 Year 2 Year 3 Year 4 Year 5 Year 1 Year 2 Year 3 Year 4 Year 5
business)
maximum
capacity level
10.Overheads
Overheads
Sr.No. Particulars Basis of calculation or assumption Monthly expenditure in INR Annual expenditure rounded off to None
During Yr-1 During Yr-2 During Yr-3 During Yr-4 During Yr-5 Year-1 Year-2 Year-3 Year-4 Year-5
(A) Sales & Marketing Overheads
1 Salary of Sales/Marketing personnel 4,20,000.00 4,20,000.00 8,40,000.00 8,40,000.00 8,40,000.00
2 Advertisement & Publicity 10,000 10,000 15,000 15,000 15,000 1,20,000.00 1,20,000.00 1,80,000.00 1,80,000.00 1,80,000.00
3 Travelling of marketing team 5,000 5,000 7,000 7,000 7,000 60,000.00 60,000.00 84,000.00 84,000.00 84,000.00
Sub-total of Marketing overheads 6,00,000.00 6,00,000.00 11,04,000.00 11,04,000.00 11,04,000.00
(B) Administrative Overheads
1 Salary of Administrative & misc. 10,08,000.00 10,08,000.00 13,08,000.00 13,08,000.00 13,08,000.00
personnel
2 Rent - - - - -
3 Building repairs & Maintenance 10,000 10,000 12,000 15,000 18,000 1,20,000.00 1,20,000.00 1,44,000.00 1,80,000.00 2,16,000.00
4 Telecommunications 1,000 1,000 1,500 2,000 2,000 12,000.00 12,000.00 18,000.00 24,000.00 24,000.00
6 Other expenses (specify major) Audit 5,000 5,000 7,000 8,000 8,000 60,000.00 60,000.00 84,000.00 96,000.00 96,000.00
Sub-total of Administrative 12,00,000.00 12,00,000.00 15,54,000.00 16,08,000.00 16,44,000.00
overheads
TOTAL OVERHEADS 18,00,000.00 18,00,000.00 26,58,000.00 27,12,000.00 27,48,000.00
11.Raw Materials
Important Raw Material and other Inputs
Proposed supplier's name &
Sr.No. Particulars UOM Rate in Annual requirements (Quantity) Value rounded off to None
location
INR Year-1 Year-2 Year-3 Year-4 Year-5 Year-1 Year-2 Year-3 Year-4 Year-5
1 Raw Materials
a) Ground Nut Farmers/Mandis Kilogram 50 6,37,500 6,75,000 7,12,500 7,12,500 7,12,500 3,18,75,000.00 3,37,50,000.00 3,56,25,000.00 3,56,25,000.00 3,56,25,000.00
Sub-total 3,18,75,000.00 3,37,50,000.00 3,56,25,000.00 3,56,25,000.00 3,56,25,000.00
42
12. Means of Finance
Means of Finance
Sr.No. Source Amount % of
total
1 Own / Family savings 1,34,07,287.88 60%
Break-Even Analysis
Sr.No. Particulars Value
Year-1 Year-2 Year-3 Year-4 Year-5
1 Sales Realization 5,03,72,270.75 5,33,35,345.50 5,62,98,420.25 5,62,98,420.25 5,62,98,420.25
2 Variable costs 3,57,56,520.00 3,76,55,138.82 4,09,33,757.65 4,09,33,757.65 4,09,33,757.65
3 Fixed costs incl. interest but excluding 29,64,599.49 29,20,577.99 37,39,445.01 37,04,261.10 36,51,011.19
depreciation & prelim exp w/off
4 Fixed costs incl depreciation & prelim exp w/off 36,46,424.49 36,07,302.99 44,26,170.01 43,90,986.10 43,37,736.19
5 Cash BEP as % of planned capacity utilization 20.28% 18.63% 24.34% 24.11% 23.76%
6 Total BEP as % of planned capacity utilization 25% 23% 29% 29% 28%
3 Debt Equity Ratio (A) / (B) 0.43 0.25 0.15 0.10 0.07 0.04
43
15. Payback Period
44
17. Debt Service Coverage Ratio
7 Int. Coverage Ratio = (A) / (B) 18.37 22.14 23.60 28.45 35.92
45