Sanjana Bansal Summer Internship Report
Sanjana Bansal Summer Internship Report
Sanjana Bansal Summer Internship Report
Data-Driven Analysis
Submitted towards completion of Course 3.1 titled “Summer Training and Project
in partial fulfilment of the requirement of the PGDGBO Programme
Submitted by
Sanjana Bansal
23GB042
GBO BATCH 2023-25
Under
Anuj Bhatia
Project Mentor
Certificate
Page 2 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
Index
Acknowledgment 4
Introduction 5
References 29
Conclusion 30
Page 3 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
Acknowledgment
Throughout the internship, the Finance Team team at Hindustan Unilever Limited provided
invaluable insights and advice that helped me grow professionally. Their constructive feedback
helped me improve my skills and approach to my tasks, and their encouragement kept me
motivated and focused. I am also deeply thankful to Shri Ram College of Commerce (SRCC)
for equipping me with the foundational knowledge and skills necessary for excelling in this
internship.
Page 4 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
1. Introduction
1.1. Background:
● Intermediary Function: The finance team at HUL acts as a crucial intermediary between
different business functions such as marketing, supply chain, and legal. This team ensures
financial strategies are integrated into decision-making across departments, facilitating
alignment with HUL’s broader corporate strategies. This coordination is vital for the financial
viability and compliance of various business operations, including new product launches,
supply chain optimizations, and mergers, such as the integration of GSK Consumer Healthcare
into HUL’s business.
● Integration with Finance Strategy: The finance team's operations are closely aligned with
HUL’s overall financial strategy. As the Vice President and Chief Financial Officer (CFO),
Ritesh Tiwari plays a pivotal role in ensuring that financial policies and operations support
HUL’s long-term goals. Under his leadership, the team focuses on performance management,
risk mitigation, and strategic financial planning, contributing to HUL’s profitability and
sustainable growth.
Page 5 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
● Experience and Expertise: HUL’s finance team comprises individuals with deep expertise in
finance, risk management, compliance, and governance. Leaders like Ritesh Tiwari have
extensive international experience, having worked in various financial roles within Unilever
globally. The team's collective expertise encompasses core finance, mergers, acquisitions, and
global financial performance management, making them adept at steering HUL’s financial
health.
Page 6 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
● Risk Mitigation and Assessment: The finance team plays a critical role in identifying
and managing financial risks at HUL. These risks include market risks, credit risks, and
compliance-related issues, among others. By conducting comprehensive assessments
and implementing robust risk management strategies, the team minimizes potential
liabilities and ensures the company's financial health. Their proactive approach
mitigates unforeseen risks that may arise from internal and external factors, helping
HUL maintain its leadership in the FMCG sector.
Page 8 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
The finance team at Hindustan Unilever Limited (HUL) plays a critical role in driving cross-
functional collaboration across key departments such as marketing, sales, and supply chain. By
serving as a strategic partner, the finance team integrates financial insights into various business
processes, ensuring that decision-making aligns with broader corporate objectives. This
collaboration supports efficient budget planning and allocation, where resources are directed
toward high-impact areas, helping to optimize financial performance. The finance team’s
involvement in pricing strategies ensures that market competitiveness is balanced with
profitability targets, while its role in cost management identifies areas for savings across
procurement, production, and logistics. This approach not only enhances operational efficiency
but also promotes transparency and accountability, reinforcing the financial foundation
necessary for HUL’s sustainable growth and market leadership.
Page 9 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
2.3. Management:
HUL’s management structure is designed to facilitate innovation and operational efficiency.
The company's Board of Directors is led by Sanjiv Mehta, who has served as CEO and
Chairman since 2013. The board comprises experienced professionals who drive HUL’s
strategic initiatives, including its Sustainability Living Plan and digital transformation
strategies. The company’s management has an integrated approach, where finance, marketing,
and operations work closely to ensure alignment between business objectives and market
demands. The Chief Financial Officer (CFO) plays a critical role in overseeing financial health,
ensuring the company maximizes shareholder value while maintaining liquidity and
operational efficiency..
Page 10 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
Page 11 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
● FMCG Industry Dynamics: I researched current trends in the FMCG industry, focusing
on the growing consumer demand for sustainable and health-focused products. This
analysis revealed that HUL could benefit from further expanding its health and wellness
product portfolio.
● Marketing Mix (4Ps): I worked on analysing the marketing mix for Dove, exploring how
product features, pricing strategies, distribution channels, and promotion tactics could be
optimized to meet HUL’s business goals. For instance, my pricing analysis indicated that
a slight price adjustment could increase profitability without affecting market share.
Page 12 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
● Brand Perception Studies: I was involved in studies that explored how consumers
perceive HUL’s brands. Through surveys and focus groups, I gathered data on brand
loyalty, trust, and consumer preferences, which were crucial for refining HUL’s brand-
building strategies.
Page 13 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
● Distributors' ROI Analysis: I was tasked with evaluating the Return on Investment (ROI)
for HUL’s distributors across various regions. By analysing gross margin, net profit
margin, and inventory turnover, I identified inefficiencies in underperforming regions. My
recommendation to revise credit terms and improve inventory management had the
potential to boost distributor ROI by 10%.
● Sales and Profitability Analysis: My sales analysis revealed that specific product lines,
such as Dove and Lifebuoy, were more profitable in certain regions due to localized
consumer preferences. This insight prompted me to recommend adjusting the product mix,
potentially increasing profitability by 5%.
● Pricing Analysis: I conducted a detailed pricing analysis using price elasticity of demand
models. By understanding the sensitivity of demand to price changes, I recommended a
small price increase for inelastic products. This strategy could increase revenue by
approximately 3%.
● Consumer Finance: I analyzed HUL’s consumer credit data to assess the risk profiles of
various customer segments. Based on my findings, I suggested offering more tailored
financial products to reduce credit risk while improving customer satisfaction.
Page 14 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
The primary problem I addressed during my internship was identifying and resolving
inefficiencies in both financial performance and strategic marketing execution at HUL.
Specifically, my goal was to:
Page 15 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
Problem Statement
Analyse and Optimize
Distributors' ROI
Evaluate the
effectiveness
Assess various
business metrics
Page 16 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
The core focus of my internship at Hindustan Unilever Limited (HUL) was to tackle significant
inefficiencies in the areas of financial performance and strategic marketing execution. These
challenges were particularly evident in distributor Return on Investment (ROI), regional sales
variations, marketing alignment, and cash flow management. To systematically address these
issues, I set out several well-defined objectives that guided my work throughout the internship:
● Financial Optimization:
Objective: Enhance the ROI for HUL’s distributors by implementing strategic improvements
in inventory management and credit terms.
Distributors are the backbone of HUL’s supply chain, and their profitability directly impacts
Page 17 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
the company’s market reach and financial health. Distributors across various regions exhibited
inconsistent performance, primarily due to high inventory levels, slow turnover rates, and rigid
credit terms. These issues led to cash flow bottlenecks, reduced profitability, and strained
distributor relations.
I began with a thorough analysis of financial ratios, including gross margin, net profit margin,
and inventory turnover, to identify underperforming regions. This data-driven approach helped
to pinpoint critical regions where distributors were unable to maintain optimal profitability due
to delayed inventory turnover and unfavorable credit terms. To improve ROI, I suggested
employing advanced demand forecasting tools to optimize order quantities, which would
reduce excess inventory and improve cash flow. Additionally, I recommended introducing
more flexible credit terms, allowing distributors to clear outstanding dues faster while
improving overall profitability.
Objective: Leverage statistical tools and data analysis techniques to uncover trends in regional
sales and improve the product mix for higher profitability.
HUL operates in a highly competitive FMCG market where regional consumer preferences
significantly influence sales outcomes. My analysis focused on high-performing product lines
like Dove and Lifebuoy, where profitability varied notably across regions.
I employed statistical tools like pivot tables and regression analysis to dissect sales data across
different geographies. This analysis revealed key insights, such as which product lines
performed better in specific regions and how localized preferences impacted overall
profitability.
I also considered factors like pricing elasticity, demographic variations, and local consumer
behavior patterns, which informed my recommendations for adjusting the product mix. For
instance, regions with a stronger preference for health-centric products like Lifebuoy were
suggested to receive increased product allocations.
Outcome: By refining the product mix in alignment with regional demand, HUL could
potentially achieve a 5% increase in profitability in target regions. This approach not only
Page 18 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
supports higher sales but also improves overall brand positioning by meeting local consumer
demands more effectively.
● Strategic Marketing:
The FMCG sector demands a dynamic marketing strategy that adapts to evolving consumer
preferences. HUL needed a more granular understanding of its target segments, including
millennials, health-conscious consumers, and urban professionals.
A significant part of my work involved competitor analysis, focusing on leading brands like
Procter & Gamble and Nestlé. I conducted a SWOT analysis to identify their strengths,
weaknesses, and positioning strategies, which provided insights into HUL’s strategic
positioning.
I also refined the marketing mix (4Ps) for HUL’s products, focusing on pricing strategies,
distribution channels, and promotional tactics. I recommended targeted campaigns, tailored
product launches, and optimized pricing to tap into high-demand segments.
Outcome: The refined marketing strategies could drive a 3% increase in revenue by optimizing
product positioning, pricing strategies, and promotional efforts. This would ensure stronger
brand loyalty, increased market share, and better alignment with consumer expectations in
high-growth segments.
Inconsistent cash inflows from specific product lines threatened to create liquidity issues,
potentially impacting HUL’s ability to maintain smooth operations. The challenge was to
identify product lines with volatile cash inflows and adjust resource allocation accordingly.
I analyzed cash flow statements, focusing on the performance of different product lines. I
Page 19 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
identified gaps where cash inflows were irregular, primarily due to factors like seasonal
demand variations, slower distributor payments, and regional supply chain delays.
To mitigate these issues, I proposed the use of advanced cash flow forecasting models that
could predict shortfalls and guide preemptive measures. I also recommended reallocating
resources from product lines with excess liquidity to those facing shortages, ensuring balanced
liquidity across operations.
Outcome: Implementing these measures could result in more consistent liquidity management,
reducing the risk of cash flow disruptions and improving overall financial stability. This
approach would allow HUL to maintain smoother operations, especially in high-demand
periods.
Objective: Develop customized financial solutions that reduce credit risk and enhance
customer satisfaction, particularly among underserved market segments.
A significant portion of HUL’s consumer base includes segments with varying credit risk
profiles. Tailored financial products could play a crucial role in increasing sales, enhancing
customer loyalty, and mitigating credit risk.
I analyzed historical credit data to segment consumers based on their credit behavior, focusing
on factors like payment patterns, credit history, and purchasing behavior. This segmentation
allowed me to propose financial products that cater to specific customer needs.
For high-risk consumers, I recommended offering smaller credit lines with shorter repayment
periods to minimize risk while maintaining customer engagement. For loyal customers with a
strong credit history, I proposed more attractive terms, such as extended repayment periods or
discounts on bulk purchases.
Outcome: By implementing these tailored financial products, HUL could not only reduce
credit risk but also drive repeat purchases, build long-term customer loyalty, and maintain
steady cash flow from consumer financing.
Page 20 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
Page 21 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
Week 7: Preparation of
Financial Reports
Page 22 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
• Financial Ratio Analysis: I used ratios like gross margin, net profit margin, and ROI to
evaluate financial performance.
For instance, when working on the sales and profitability analysis, I used pivot tables and
statistical tools to uncover trends in the data, such as which regions were driving higher
profitability and why certain product lines were underperforming. The ability to analyze large
datasets and distill them into clear, concise reports for management is a skill that I believe will
be invaluable throughout my career.
Page 23 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
Page 24 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
7.1 Conclusion
My internship at Hindustan Unilever Limited (HUL) has been a transformative experience,
offering me deep insights into both financial optimization and strategic marketing within one
of the world’s most competitive industries, the FMCG sector. Over two months, I had the
opportunity to apply theoretical knowledge in practical, real-world situations and contribute to
the company’s efforts in addressing key business challenges.
In the financial domain, I was able to identify opportunities for optimizing distributor Return
on Investment (ROI) by improving inventory turnover ratios and credit terms. The financial
reporting and analysis work also revealed critical insights into the company’s cash flow
management, where I was able to recommend resource reallocation to prevent liquidity issues
in certain product lines.
The internship also sharpened my ability to work with large datasets, performing data
collection, analysis, and structured presentation of insights. This experience helped me
understand the pivotal role that data analytics plays in shaping business strategies, especially
in a company of HUL’s scale.
Overall, my time at HUL has equipped me with the technical and analytical skills necessary
for a successful career in finance and marketing. The experience has also deepened my
understanding of the synergy between finance and marketing, where both functions need to
work in tandem to achieve sustainable business growth.
Page 25 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
7.2 Recommendations
Based on the findings and experiences throughout my internship at Hindustan Unilever
Limited, I have outlined the following recommendations aimed at improving both financial
performance and marketing effectiveness:
The analysis of distributor performance showed that inventory turnover and credit terms are
critical factors impacting ROI. I recommend that HUL undertake the following actions:
Offering more flexible credit terms, particularly in regions where distributors are struggling,
can lead to improved relationships and higher ROI. A detailed review of current terms,
followed by a data-driven adjustment, could increase distributor ROI by up to 10% in
underperforming areas.
My analysis of HUL’s financial statements highlighted potential cash flow issues in certain
product lines. To prevent liquidity problems, I recommend:
HUL should invest in more robust cash flow forecasting models that can predict shortfalls or
surpluses in specific product lines. This would allow for pre-emptive measures to ensure
consistent liquidity across the board.
Page 26 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
One of the key insights from the sales analysis was that regional differences in consumer
preferences significantly impacted product performance. To capitalize on this, I recommend:
Customizing the Product Mix: HUL should explore tailoring its product offerings in different
regions. For example, in regions where personal care products like Dove and Lifebuoy are
more popular, the company can increase focus on these brands, leading to an estimated 5%
increase in profitability.
● Data-Driven Segmentation
Utilizing detailed market segmentation data, HUL can create region-specific marketing
campaigns that address local consumer needs. This approach will not only boost profitability
but also improve consumer loyalty.
The pricing analysis revealed that certain HUL products have inelastic demand, meaning that
small price changes would not significantly affect sales volumes. To optimize pricing
strategies, I recommend:
Price Increases for Inelastic Products: HUL should consider a 2-3% price increase for high-
demand, inelastic products such as Dove and Lifebuoy. This pricing strategy could result in
additional revenue growth of 3% without negatively impacting market share.
Page 27 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
8. References
● Annual Reports of HUL:
HUL's annual reports provide detailed insights into financial performance, strategic initiatives,
and sustainability efforts, covering key financial metrics like turnover, EBITDA margins, cash
flow, and net profits.
This report details HUL's financial growth strategies, turnover trends, cash flow management,
and key decisions related to digital transformation, ensuring consistent, competitive, and
profitable growth.
HUL's approach to market segmentation, consumer behavior studies, and targeted marketing
strategies, especially for personal care, home care, and wellness products, is well-documented
in its marketing and performance reports.
The finance team’s integration with HUL’s broader strategies, including risk assessment,
revenue recognition, and collaboration with marketing and supply chain, is outlined in HUL's
financial management documents.
Leadership profiles, such as that of Ritesh Tiwari, Executive Director of Finance, explain how
finance leaders contribute to strategic decisions and overall financial health.
Page 28 of 30
Financial Analyst Intern at Hindustan Unilever Ltd.
9. Conclusion
The internship at Hindustan Unilever Limited (HUL) offered a rich learning experience in both
finance and strategic marketing within the dynamic FMCG sector. It provided practical
exposure to financial analysis, market segmentation, pricing strategies, and risk management.
The key outcomes of this internship included optimizing distributor ROI, improving product
mix for profitability, and enhancing cash flow management. Analyzing consumer behavior and
competitor strategies further refined marketing approaches. Additionally, working closely with
HUL’s finance team underscored the importance of financial insights in strategic decision-
making. Overall, the internship strengthened my analytical skills, strategic thinking, and
understanding of how finance and marketing collaboratively drive business growth. This
experience will serve as a strong foundation for my future career in finance and strategy.
Page 29 of 30