Manjot's Study on TCS Working Capital
Manjot's Study on TCS Working Capital
Of the degree of
(2015-2018)
PATIALA
1
CERTIFICATE OF COMPLITION
This is to certify that Mr. MANJOT GILL from BBA (6TH Semester)
as successfully completed his project title “AN ANALYTICAL STUDY
OF WORKING CAPITAL OF TATA CONSULTANCY SERVICES ION
PATIALA’’ under the guidance of Mr. MANISH KUMAR this is in
the partial fulfillment of his BBA curriculum (2015-2018).
Dated
(Project guide)
2
DECLARATION
MANJOT GILL
3
PREFACE
4
ACKNOWLEDGEMENT
I would like to thank all the finance department of “TCS - ION “especially
Mr. Manish Kumar, and the employees in the finance department for
guiding me and helping me in successful completion of the project.
I will also specifically thank to Prof. Kusum Rani Department, Head, and
Khalsa College Patiala for the (Internal Guide) for extending the
cooperation in doing this project.
Last but not the least; I will like to thank God for blessing me and
giving me such a wonderful opportunity.
5
INDEX
CH NO. TOPIC PAGE
NO.
1. Company profile 6-32
8. Findings 97-98
9. Limitations 99-100
6
CH 1
COMPANY
PROFILE
7
Tata Consultancy Services Limited (TCS)is an Indian multinational
information technology(IT) service, consulting and business solutions
company headquartered in Mumbai, Maharashtra. It is a subsidiary of
the Tata Group and operates in 46 [Link] is one of the largest Indian
companies by market capitalization ($80 billion). TCS is now placed among
the ‘Big 4’ most valuable IT services brands worldwide. In 2015, TCS is
ranked 64th overall in the Forbes World's Most Innovative Companies
ranking, making it both the highest-ranked IT services company and the
first Indian company. It is the world's 10th largest IT services provider,
measured by the revenues.
History:
1968 to 2000:
In 1975, TCS conducted its first campus interviews, held at IISc, Bangalore
and Mumbai. The recruits comprised 12 Indian Institutes of
Technology graduates and three IISc graduates, who became the first TCS
employees to enter a formal graduate trainee programme.
8
In 1981, TCS established India's first dedicated software research and
development centre, the Tata Research Development and Design Centre
(TRDDC) in Pune.
In early the Indian IT outsourcing industry grew rapidly due to the Y2K bug
and the launch of a unified European currency, Euro. Tata Consultancy
Services created the factory model for Y2K conversion and
developed software tools which automated the conversion process and
enabled third-party developer and client implementation
2004 to present
In 2006, TCS designed an ERP system for the Indian Railway Catering and
Tourism Corporation.
TCS entered the small and medium enterprises market for the first time in
2011, with cloud-based offerings. On the last trading day of 2001 TCS
overtook RIL to achieve the highest market capitalization of any India-based
company.
In the 2011/12 fiscal year, TCS achieved annual revenues of over US$10
billion for the first time.
In May 2013, TCS was awarded a six-year contract worth over ₹ 1100
Crores to provide services to the Indian Department of Posts.
9
In 2014, TCS moved from the 13th position to 10th position in the League of
top 10 global IT services companies
In July 2014, TCS became the first Indian company to cross the Rs 5 lakh
crores mark in market capitalization.
In Jan 2015, TCS ends RIL's 23-year run as most profitable firm.
Service lines:
TCS' services are currently organized into the following service lines
(percentage of total TCS revenues in the 2014-15 fiscal year generated by
each respective service line is shown in parentheses):
Consulting (2.00%);
10
IT infrastructure services (11.50%).
Operations:
TCS have 289 offices across 46 countries and 147 delivery centers in 21
countries. At the same date TCS had a total of 58 subsidiary companies.
Locations:
TCS has operations in the following locations:
Oceania: Australia
11
systems research. Research at TRDDC has also resulted in the development
of Sujal, a low-cost water purifier that can be manufactured using locally
available resources. TCS deployed thousands of these filters in the Indian
Ocean Tsunami disaster of 2004 as part of its relief activities. This product
has been marketed in India as Tata swatch, a low cost water purifier.
Innovation Labs:
In 2007, TCS launched its co-innovation network, a network of innovation
labs, startup alliances, university research departments, and venture
capitalists. In addition, TCS has 19 innovation labs based in three
[Link]' partners include Collabnet, Cassatt, academic institutions
such as IITs, Stanford, MIT, Carnegie Mellon and venture capitalists
like Sequoia and Kleiner Perkins.
Employees:
TCS is one of the largest private sector employers in India, and the second-
largest employer among listed Indian companies (after Coal India Limited).
TCS had a total of over 387000 employees as of December 2016, of which
31% were women. The number of non-Indian nationals was 21,282 as at
March 31, 2013 (7.7%).The employee costs for the FY 2012-13 were
US$4.38 billion, which was approx. 38% of the total revenue of the company
for that period. In the fiscal year 2012-13, TCS recruited a total of 69,728
new staff, of whom 59,276 were based in India and 10,452 were based in
the rest of the world. In the same period, the rate of attrition was 10.6%. The
average age of a TCS employee is 28 years. The employee utilization rate,
excluding trainees, for the FY 2013-15 was 82%. TCS was the fifth-largest
United States visa recipient in 2010 (after Infosys, CTS, Wipro and Mahindra
Satyam).In 2012, the Tata group companies, including TCS, was the second
largest recipient of H-1B visas.
As of June 2017, TCS has over 387,000 employees. It is world's third largest
IT employer behind IBM and HP..
12
Tata Consultancy Services Limited
Type Public
NSE: TCS
TRDDC
13
Slogan Experience certainty
Website [Link]
TCS- ION
Now TCS is dealing in education and web development under the name of
[Link]-ION is at present, the strap idly growing online web Solutions
Company in India, providing IT enabled services, consultation and
outsourcing to companies spread in more than165 countries across 7
continents. Their advanced delivery model blends technology practices
with functional expertise help us improve our business processes and
boost performance.
They also double passed digital marketing agency that serves leading
brands, corporate clients as well as other players. Their cost-effective and
customized web development and online media solutions are tailor-made
to suit our specific needs and requirements. TCS-ION offers us cutting
14
edge services for website designing, development and internet marketing.
Their aim is to convert our “Creating Global Profession ate’’.
15
web designers employ fresh innovative ideas and advanced designing tools
to produce optimized and profit generative websites for you.
IT - as - a Service:
The IT-as-a Service business model of ION a cloud based ERP solution was
conceptualized by TCS through close interactions with Small and Medium
Businesses (SMB) across relevant stakeholders, developing a deep
understanding of their ICT consumption pattern and business challenges.
An innovative service model, ION uses emerging technologies like cloud
computing and virtualization to create a holistic, fit-for-purpose solution
stack for SMBs integrating hardware, network, software and services. And
all of this is backed by business, technical and consulting services by ION.
The ION Cloud ERP Solution is highly modular, scalable and configurable
giving SMBs the benefits of increased efficiencies; faster go to market,
predictability of technology as well as spend, IT talent on call and better
business results.
16
Increased agility:
We bring in the agility to keep pace with changing processes or a new line of
business. We help you configure the processes to work as you currently do
or the software recommends and allows you to choose industry best
practices based on your business parameters. ION gives you increased
convenience allowing you to perform various tasks from your mobile device,
no matter where you are. Being automatically compliant with statutory
requirements, the solution ensures your company is always audit ready and
legally compliant.
A pay-as-you-use model:
Our model eliminates capital investment up front as we facilitate
procurement of the IT infrastructure and software on rent for the duration of
the contract. Additionally, you only pay for the number of users who
actually use the software. Thus, you pay as you use on a monthly basis
which includes maintenance and training. Typically, with the ION Cloud
ERP the ROI exceeds rental within three months, when best practices are
well followed.
Personalized solution:
Although ION is a cloud service for small and medium businesses, the
software is configurable to each business. You will always get the flavor of
your business by picking and choosing what processes you would need.
Furthermore, the multilingual capability of the software allows you to
customize the solution label names to read in vernacular languages (like
Hindi, Marathi, Tamil etc.) enabling users to learn and operate the solution
with ease.
Automatic upgrades:
We continuously invest in our cloud based ERP solutions to incorporate best
practices. The software is constantly enriched based on user feedback and
17
industry and statutory changes. You will get the upgrades without
disrupting your business operations or any additional cost. Being in
perpetual beta ensures that there is no technology obsolescence.
PARTNER:
ION Partners play a key role in helping organizations of all sizes transform
their businesses. We help customers buy and implement solution that best
fit their unique needs. ION Partners also provide continuous support to
customers after the implementation of the solution.
18
A Manufacturing nervous system
Recording orders, sales and purchases would have little meaning unless
they were connected. At the heart of our manufacturing solution lies a
production system that ensures that these are in sync. You procure as
much as you produce; and produce as much as you are able to sell. The goal
is as simple as keeping the lowest inventory.
At ION, we tend to make the complex manufacturing process look simple by
connecting the different parts of the operations. The software is organized
into planning and execution. Production plan for instance, would tell your
operations to expect the right amount of sales, and then initiate the right
quantity of procurement. But what happens when the execution slips from
what is planned? Vigilant reports and dashboards would alert you in time.
Solution track
19
Power your workforce performance:
Across industries, organizations are looking at new ways to manage their
workforce and measure performance through HR analytics, performance
management systems, and social media.
20
Managed Service: Manages the process end-to-end with the service
delivered as an output.
TCS IN EDUCATION:
Campus System:
21
enquiry to alumni. Offerings are integrated, yet modular in nature, which
can help automate certain functions within the institution depending on
preference and suitability. With Pre-built business processes and easy-to-
configure solution capabilities, institutions can start using the system with
minimal implementation time and effort. To make the delivery process
smooth and effective for the end users, some of the modules are available in
a Managed Services model as well.
Assessment Management:
Digital evaluation:
22
Thus, ION Digital Evaluation solution from TCS addresses the major issues
of the current evaluation process like missing answer scripts in transit,
human error in evaluation, tabulation and award lists and most importantly
struggling to announce results on time.
Demat Service:
Communicator:
23
Exam management:
Course management:
Leading Exchange:
24
Empower Learning:
Personalized Feedback:
The power to conduct assessments after every learning module and provide
personalized feedback in an on-going manner helps learners to be ahead on
the learning curve. Personalized mentoring can be provided to each learner
using Taxonomy and LOD tagging of assessments linked to feedback and
"incremental assist publishing". Results and Analytics of learner groups help
teachers to undertake remedial interventions for bringing parity in learning.
Peer learning:
Learning outcomes can be paced faster by enabling room for peer learning.
ION Learning Exchange is designed for community based learning where
learners share their expertise and concerns using a suite of collaboration
tools including Forums, Blog, Debate, Surveys, Questions, Wiki and more.
Peer to peer benchmarking and peer speak provide the necessary impetus
for pacing each other for better outcomes.
25
Content Management System:
Create Courses for various topics and subjects engaging members of the
Institution in a collaborative learning environment. Populate course content
in multiple modes (SCORM Compliant) and co-create content repository, co-
deliver curriculum, collaborate with industry and experts across geographies
to bring best of class value delivery to your class rooms.
Testing Engine:
Analytics Engine:
Communication tools:
26
Web programming
Every online business is different from other, even similar niche website.
TCS-ION India understands and respect individual clients needs and
provide custom web programming services to serve unique web
requirements. Their team of qualified professionals uses strategic planning
and smart development process with quick operationally efficient and
productive website. Their aim is to provide smart and practical solutions
from their website. TCS-ION India’s custom website programming services
cause dramatic and measureable growth in their website.
Flash design
Creative heads at TCS-ION India exploit Flash’s vector technology to
produce, beautiful and eye-catching designs for you. From Flash intros,
banners logos and advertisements to full-blown Flash websites, they give
our website the interactive zing it desires. Their creative Flash design
services help transform our website into an effective communication
interface.
Logo design
27
Branding that delivers your message
The quickest way to increase the value of the company’s brand is with a
well-integrated design theme that is consistent across the web as well as on
paper. A great logo is the keystone of this theme and will attract the
attention you want and deliver the sales that company needs.
Their logos don’t just create an identity; they create a connection with the
audience they speak to and differentiate the product or service being offered.
Their logo and branding should allow their customer to see you as providing
a distinct solution to their unique problem. A logo speaks volumes about
what the company does, what its values are and what it can achieve. They
make sure the logo has as much personality as you do.
SERVICES OF COMPANY
At ION they offer PSD to CSS3 / JS / HTML5 services for their custom web
design needs. We will help us in getting the best web site design coded in
HTML5 which is rich in structural functionality and in CSS3 to enhance the
presentation of your website’s content. Also HTML5/CSS3 expert takes into
account page’s loading time, SEO and web browsers compatibility
CMS
28
Ecommerce Website Development
SEO
Research
29
Analyze
After research they analyze the market potential and the present
competition. They analyze the market potential to ensure that the website is
optimized in compliance with search engine guidelines and they study the
competition to identify the potential gap which needs to be addressed by
you.
One of their biggest priorities of all is close collaboration with their clients.
Whatever the size of our company or, indeed, your proposed project, they
take steps here at TCS - ION to ensure that your project is carefully tracked
and monitored, from the initial user analysis to the final stage of usability
testing.
ION is the company which gives the guarantee that we can help your
business or organization to be the best by improving your profitability and
efficiency.
They understand that you could be concerned about why you should utilize
our services for your requirements. It is but natural that you logically put
these questions to yourself. In an era where there are many others out there
30
offering similar services claiming similar advantages, it is worth considering
the following points. At [Link] we thoroughly undertake the following
globally acknowledged advanced practices.
Latest technologies
Excellent support
They offer the most excellent support and dedicated service by a full-fledged
web expert’s team.
Best talent
They hire only the best talent available in the market and ensure that we
utilize the cutting edge top range methodologies and techniques to develop
and execute your projects.
Satisfied Clientele
Needless to say, they have been able to develop a large list of satisfied clients
in countries around the globe. They are really proud to say that all this is
due to our honest and equilateral commitment in understanding the needs
31
of our clients and providing them with precise solutions in accordance with
their individual requirements.
SERVICES
Their e-commerce solutions are the best blend of:
Website Development
There are many variations of passages of LoremIpsum available, but the joy
has suffered alteration in some format, by injected humor.
Website Designing
There are many variations of passages of LoremIpsum available, but the joy
has suffered alteration in some format, by injected humor.
Internet Marketing
There are many variations of passages of LoremIpsum available, but the joy
has suffered alteration in some format, by injected humor.
Website Maintenance:
They offer you fast and efficient website maintenance services. They will
update, enhance, backup and repair our site quickly and efficiently, while
you can go on running your business. They will maintain the quality of our
website, keeping it fresh for our return clients. If you need to add more
images, new banners, new calendar events, change the content of the site,
back up any important data, add new plug-in and functionality, let us do it
for you . Their website maintenance services are professional and affordable
with quick turn around and delivery times. They always have custom
solutions to website functionality problems at an affordable cost. They offer
professional help with any bagworm is fortunes which may happen to your
site. Their site monitoring is effective and professional. As soon as they
32
receive maintenance requests, the sites get updated or fixed right away. All
the website development and maintenance is being performed in a secure
way, with non-disclosure of the passwords or any site information.
33
CH 2
INTRODUCTION
TO THE TOPIC
34
“Working Capital is the Life-Blood and Controlling Nerve
Center of a Business”
No one can start business or run an enterprise without adequate funds.
Every business requires money to start and to carry out its day-to-day
operations as requirement of amount of capital depends on size and nature
of business. To fulfill day to day requirement such as purchase of current
assets or marketable securities which can be easily converted into cash,
purchase of raw material, payment of wages and other routine expenses, an
entrepreneur has required working capital. Those finance which are needed
in short term to carry on operating and short term activities is known as
Working Capital, while long term finance which is required to establish
business through purchase of fixed assets such as Plant & Machinery, Land
and Building, etc.,. Is called Fixed Capital.
35
The rationale behind this project “study of Working Captal Management” is
to determine the amount of working capital requirement on the basis of
various financial ratios which help a business man to take adequate
decision through proper planning and control over business activities. The
project also depends on study of changes in the uses and sources of working
capital to understand that how a manager can increase the efficiency of
business in management of working capital.
Working capital represents the total of all current assets. In other words it is
the Gross working capital, it is also known as Circulating capital or Current
capital for current assets are rotating in their nature.
36
Working capital comprises current assets which are distinct from other
assets. In the first instance, current assets consist of these assets which are
of short duration. Working capital may be regarded as the life blood of a
business. Its effective provision can do much to ensure the success of a
business while its inefficient management can lead not only to loss of profits
but also to the ultimate downfall of what otherwise might be considered as a
promising concern.
Fixed assets are those which yield the returns in the due course of time.
The various decisions like in which fixed assets funds should be invested
and how much should be invested in the fixed assets etc. are in the form of
capital budgeting decisions. This can be said to be fixed capital
management.
37
CLASSIFICATION OF WORKING CAPITAL
39
to cover the requirement of funds during this time gap, and the quantum of
working capital needs varies as per the length of this time gap.
Working capital cycle indicates the length of time between firms’s paying for
materials entering into stock and receiving the cash from sale of finished
goods. In a manufacturing firm, the duration of time required to complete
the sequence of called events is operating.
40
In case of a manufacturing company, the operating cycle is the length of
time necessary to complete the following cycle of events –
The above operating cycle is repeated again and again over the period
depending upon the nature of the business and type of product etc. the
duration of the operating cycle for the purpose of estimating working capital
is equal to the sum of duration allowed by the suppliers.
R+W+F+D+C
Where,
R - Raw material storage period = avg. stock of raw material / avg. cost of
production per day
F – Finished goods storage period = avg. stock of finished goods / avg. cost
of goods sold per day
D – Debtors collection period = avg. book debts / avg. credit sales per day
41
WORKING CAPITAL MANAGEMENT
To start any business, First of all we need finance and the success of that
business entirely depends on the proper management of day-to-day finance
and the management of this short term capital or finance of the business is
called Working Capital Management.
Working Capital is the key difference between the long term financial
management and short term financial management in terms of the timing of
cash. Working capital management is a short term financial management.
Working capital management is concerned with the problems that arise in
attempting to manage the current assets, the current liabilities & the inter
relationship that exists between them. The current assets refer to those
assets which can be easily converted into cash in ordinary course of
business, without disrupting the operations of the firm.
42
is maintained, i.e. it is neither adequate nor excessive as both the situations
are bad for any firm. There should be no shortage of funds and also no
working capital should be ideal. WORKING CAPITAL MANAGEMENT
POLICES of a firm has a great on its probability, liquidity and structural
health of the organization. So working capital management is three
dimensional in nature as
43
SIGNIFICANCE OF WORKING CAPITAL MANAGEMENT
44
IMPORTANCE OR ADVANTAGE OF ADEQUATE
WORKING CAPITAL
45
dividends to its investors and gains confidence of the investors and
can raise more funds in future.
46
DISADVANTAGES OF INADEQUATE WORKING CAPITAL
Every business needs some amounts of working capital. The need for
working capital arises due to the time gap between production and
realization of cash from sales. There is an operating cycle involved in sales
and realization of cash. There are time gaps in purchase of raw material and
production; production and sales; and realization of cash.
For studying the need of working capital in a business, one has to study the
business under varying circumstances such as a new concern requires a lot
of funds to meet its initial requirements such as promotion and formation
etc. These expenses are called preliminary expenses and are capitalized. The
amount needed for working capital depends upon the size of the company
and ambitions of its promoters. Greater the size of the business unit,
generally larger will be the requirements of the working capital.
47
FACTORS AFFECTING WORKING CAPITAL MANAGEMENT
• NATURE OF BUSINESS
Some businesses are such, due to their very nature, that their requirement
of fixed capital is more rather than working capital. These businesses sell
services and not the commodities and not the commodities and that too on
cash basis. As such, no funds are blocked in piling inventories and also no
funds are blocked in receivables. E.g. Public utility services like railways,
electricity boards, infrastructure oriented projects etc. Their requirement of
working capital is less. On the other hand, there are some business like
trading activity, where the requirement of fixed capital is less but more
money is blocked in inventories and debtors. Their requirement of the
working capital is more.
In some business like machine tool industry, the time gap between the
acquisitions of raw material till the end of final production of finished
product itself is quite high. As such more amounts may be blocked either in
raw materials, or work in progress or finished goods or even in debtors.
Naturally, their needs of working capital are higher. On the other hand, if
the production cycle is shorter, the requirement of working capital is also
less.
In very small companies the working capital requirements are quite high
overheads, higher buying and selling costs etc. As such, the medium sized
companies positively have an edge over the small companies. But if the
business starts growing after a certain limit, the working capital
requirements may be adversely affected by the increasing size.
48
BUSINESS/TRADE CYCLE
• CREDIT POLICY
• SEASONAL VARIATIONS
In certain industries like raw material is not available throughout the year.
They have to buy raw material in bulk during the season to ensure an
uninterrupted flow and process them during the year. Generally, during the
busy season, a firm requires larger working capital than in slack season.
Some firms have more earning capacity than other due to quality of their
products, monopoly conditions, etc. Such firms may generate cash profits
49
from operations and contribute to their working capital. The dividend policy
also affects the requirement of working capital. A firm maintaining a steady
high rate of cash dividend irrespective of its profits needs working capital
than the firm that retains larger part of its profits and does not pay so high
rate of cash dividend.
Changes in the price level also affect the working capital requirements.
Generally rise in prices leads to increase in working capital.
• PRODUCTION POLICY
50
The extent to which profit can be earned is dependent upon the magnitude
of sales. Sales are necessary for earning profits. However, sales do not
convert into cash instantly; there is invariably a time lag between sale of
goods and the receipt of cash. WC management effect the profitability and
liquidity of the firm which are inversely proportional to each other, hence
Proper balance should be maintained between two.
To convert the sale of goods into cash, there is need for WC in the form of
current asset to deal with the problem arising out of immediate realization of
cash against good sold. Sufficient WC is necessary to sustain sales activity.
This is referred to as the operating or cash cycle.
INVENTORY MANAGEMENT
Inventories constitute the most important part of the current assets of large
majority of companies. On an average the inventories are approximately
60% of the current assets in public limited companies in India. Because of
the large size of inventories maintained by the firms, a considerable amount
of funds is committed to them. It is therefore, imperative to manage the
inventories efficiently and effectively in order to avoid unnecessary
investment.
Nature of Inventories
• Raw Material: It is the basic input that is converted into the finished
product through the manufacturing process. Raw materials are those
units which have been purchased and stored for future production.
51
• Work-in-progress: Inventories are semi-manufactured products.
They represent product that need more work they become finished
products for sale.
52
Requisition
Purchase Ordering
Transporting
Receiving
Inspecting
Storing
Ordering cost increase with the number of orders placed; thus the
more frequently inventory is acquired, the higher the firm’s ordering
costs. On the other hand, if the firm maintains large inventory’s level,
there will be few orders placed and ordering costs will be relatively
small. Thus, ordering costs decrease with the increasing size of
inventory.
Carrying costs are varying with inventory size. This behavior is contrary to
that of ordering costs which decline with increase in inventory size. The
economic size of inventory would thus depend on trade-off between carrying
costs and ordering cost.
53
Long term financing:
It includes ordinary share capital, preference share capital, and
debentures, long term borrowings from financial institutions and reserves
and surplus.
Matching Approach
In this, the firm follows a financial plan, which matches the expected life of
assets with the expected life of source of funds raised to finance assets.
When the firm follows this approach, long term financing will be used to
finance fixed assets and permanent current assets and short term
financing to finance temporary or variable current assets.
Conservative Approach
In this, the firm finances its permanent assets and also a part of temporary
current assets with long term financing. In the periods when the firm has no
need for temporary current assets, the long-term funds can be invested in
tradable securities to conserve liquidity. In this the firm has less risk of
facing the problem of shortage of funds.
Aggressive Approach
In this, the firm uses more short term financing than warranted by the
matching plan. Under an aggressive plan, the firm finances a part of its
current assets with short term financing.
54
ADVANTAGES OF WORKING CAPITAL MANAGEMENT
55
CH 3
REVIEW OF
LITERATURE
56
Dr. G. Vara Kumar (2014) studied that working capital is the lifeblood and
nerve center of any business. No business can run successfully without
adequate working capital. Hence, working capital management is very
important of corporate finance because it directly affects the liquidity and
profitability of the firm. An efficient working capital management (WCM) has
a significant effect towards the creation of firm’s value. The present paper
gives various review of Literature on working capital management
(conceptual and research). The main objective of this paper is to provide the
wide variety of reviews on working capital management in different
industries and fields to identify the research gap for further studies. The
study has been identified that research studies of general nature relating to
working capital management are limited. Further, research studies touching
upon finance are of Automotive Battery industry are also very limited, while
working capital management in Automotive Battery Industry is hither to a
much neglected area.
57
Bhaskar Bagchi (2012)The paper aims to explore the effects of components
of working capital management like cash conversion cycle (CCC), age of
inventory (AI), age of debtors (AD), age of creditors (AC), debt to total assets
(DTA) and debt equity ratio (DER) on profitability of FMCG firms. The
profitability of firms is measured in terms of return on total assets (ROTA)
and return on investment (ROI). Working capital management is considered
to be a vital issue in financial management decision and it affects both
liquidity and profitability of the firm. The secondary data for analysis is
retrieved from Prowess Database of CMIE for ten year period from 2000
01to2009-10.
Amalendu Bhunia (2011) studied that the present study aims to identify
the financial strengths and weaknesses of the Indian public sector
pharmaceutical enterprises by properly establishing relationships between
the items of the balance sheet and profit and loss account. The study covers
two public sector drug and pharmaceutical enterprises listed on BSE. The
study has been undertaken for the period of twelve years from 1997-98 to
2008-09 and the necessary data have been obtained from CMIE database.
The liquidity position was strong in case of both the selected companies
thereby reflecting the ability of the companies to pay short-term obligations
on due dates and they relied more on external funds in terms of long-term
borrowings thereby providing a lower degree of protection to the creditors.
Financial stability of both the selected companies has showed a downward
trend and consequently the financial stability of selected pharmaceutical
companies has been decreasing at an intense rate. The study exclusively
depends on the public sectors published financial data and it does not
compare with private sector pharmaceutical enterprises. This is a major
limitation of the research. The study is of crucial importance to measure the
firm’s liquidity, solvency, profitability, stability and other indicators that the
business is conducted in a rational and normal way; ensuring enough
returns to the shareholders to maintain at least its market value. The study
58
will help investors to identify the nature of Indian pharmaceutical industry
and will also help to take decision regarding investment.
Dr. Muhammad AZAM and Syed Irfan HAIDER (2011) studied that the
purpose of this study is to investigate the impact of working Capital
Management on firms’ performance for non-financial institutions listed in
Karachi Stock Exchange (KSE- 30) Index. A panel data has been used in this
study for 21 Kse-30 Index listed firms over a period for the year 2001 to
2010. The results are obtained by using Canonical Correlation Analysis for
identifying the relationship between working capital management and firms’
performance. The findings show that working capital management has
significant impact on firms’ performance and it is concluded that managers
can increase value of shareholder and return on asset by reducing their
inventory size, cash conversion cycle and net trading cycle. Increase in
liquidity and time period to supplier will also lead firms’ overall
performances.
59
Ashok Kumar Panigrahi (2010) studied that since the liberalization of
Indian economy, there has been an upsurge in research on company
finance, particularly aimed at understanding how companies finance their
activities and why they finance their activities in these specific ways. In
practice, it is observed that finance managers use different combinations of
debt and equity. The present study is aimed at to find out the trend and
pattern of financing by the Indian companies before and after the
liberalization. The sheer size and diversity of the Indian capital market are,
on their own, more than sufficient reasons for investigating Indian company
financing in depth. In addition, the liberalization of the market offers a
unique laboratory for evaluating the development of companies as
liberalization proceeds. In this study, we attempt to compare and contrast
the capital structure of Indian corporate before and after liberalization.
Going beyond this, we examine the impact of liberalization and changes if
any noticed due to liberalization, on the capital structure of Indian
companies. Effort is also made to analyze the capital structure decisions of
Indian companies in the recent past.
60
CH 4
RESEARCH
METHODOLOGY
61
Research methodology is a systematic way to solve the problem. It may be
understood as a science of study how research is done. We can say that
research methodology has many dimension and research methods do
constitute as a part of research methodology. The study of research
methodology gives the necessary training in gathering material and
arranging them, participation in field work when it required, and also
training in techniques of data collection appropriate to particular problem,
questionnaire and control on data. It helps to sorting the data and
interpreting it. Knowledge of project report plays a key role in project work.
The study of research method provides you with the knowledge and skills
you need to solve the problem and meet the challenges of the fast- based
decision. Marketing environment we define Business Research as a
systematic inquiry whose objective is to provide information to solve
managerial problem.
It seeks to find explanation to unexplored phenomena to clarify the doubtful
facts and to correct the misconceived facts.
Research Type-:
Research is a systematic way activity to achieve the truth. Research includes
the procedure of collecting the data, analysis it, and finding the truth. The
research depends upon the scientific methods.
62
Descriptive Research
Descriptive study is a fact- finding investigation with adequate
interpretation. It is the simplest type of research. It is more specific than an
explanatory study, as it has focus on particular aspect of the problem
studied. It is designed to get her descriptive information and provide
information for formulating more sophisticated studies. Data are collected
by using one or more appropriate method, observation, interviewing and
mail questionnaire.
It is also called a statically research. In this I have describe the data and
characteristics of population. In research I tried to find the answer of
questions who, what, when and how. In descriptive research I choose
frequency, average, and other statically calculation. I have conducted a
survey.
Research Design-:
Research Design is a framework to conduct the research.
This study used descriptive research. Descriptive research involves
gathering data that describe events and then organizes, tabulates,
depicts, and describes the data collection . It often uses visual aids such
as graphs and charts to aid the reader in understanding the data
distribution and therefore offered a better clarification on online advertising,
and ultimately give a clear picture on the effectiveness and reliability of
online advertising and its relationship to purchase decision.
63
research cannot be used to as the basis of a causal relationship, where one
variable affects another. In other words, descriptive research can be said to
have a low requirement for internal validity.
• The most basic form of Research involves the description of the forms,
actions, changes over time of the natural and non-natural
phenomena. It also involves the description of similarities with other
phenomena.
• With the help of descriptive study I able to find the result accurately
as well in good manner.
• In descriptive study I able to collect the both data like qualitative and
quantitative.
Data collection
Secondary data-:
It includes the data from internet hyperlinks and books, journals and
newspaper. Mainly I have collected data from internet and books. The main
aim to collect the secondary data is to understand the meaning of
consumer’s behavior, process, and importance.
It is far cheaper to collect secondary data than to obtain primary data. For
the same level of research budget a thorough examination of secondary
65
sources can yield a great deal more information than can be had through a
primary data collection exercise.
The time involved in searching secondary sources is much less than that
needed to complete primary data collection.
Secondary sources of information can yield more accurate data than that
obtained through primary research. This is not always true but where a
government or international agency has undertaken a large scale survey, or
even a census, this is likely to yield far more accurate results than custom
designed and executed surveys when these are based on relatively small
sample sizes.
It should not be forgotten that secondary data can play a substantial role in
the exploratory phase of the research when the task at hand is to define the
research problem and to generate hypotheses. The assembly and analysis of
secondary data almost invariably improves the researcher's understanding
of the marketing problem, the various lines of inquiry that could or should
be followed and the alternative courses of action which might be pursued.
• Difficulties in measurement.
66
CH 5
OBJECTIVES OF
STUDY
67
The major objectives of this project are:
68
CH 6
DATA ANALYSIS
AND
INTERPRETATION
69
CURRENT RATIO:
Current Liabilities
(Amount in Rs.)
Current Ratio
70
CURRENT RATIOS
5
4.5
4
3.5
3
2.5
4.48
2 3.82
1.5
1 1.94
0.5
0
2015 2016 2017
Interpretation
As a rule, the current ratio with 2:1 (or) more is considered as satisfactory
position of the firm.
When compared with 2016, there is an increase in the provision for tax,
because the debtors are raised and for that the provision is created. The
current liabilities majorly included of company for consultancy additional
services.
The sundry debtors have increased due to the increase to corporate taxes.
In the year 2016, the cash and bank balance is reduced because that is
used for payment of dividends. In the year 2017, the loans and advances
include majorly the advances to employees and deposits to government. The
loans and advances reduced because the employees set off their claims. The
other current assets include the interest attained from the deposits. The
deposits reduced due to the declaration of dividends. So the other current
assets decreased.
The huge increase in sundry debtors resulted an increase in the ratio, which
is above the benchmark level of 2:1 which shows the comfortable position of
the firm.
71
QUICK RATIO
Liquid liabilities
(Amount in Rs.)
Quick Ratio
72
GRAPHICAL REPRESENTATION:
QUICK RATIOS
5
4.5
4 4.35
3.5 3.81
2.5
2
1.9
1.5
0.5
0
2015 2016 2017
Interpretation
Quick assets are those assets which can be converted into cash within a
short period of time, say to six months. So, here the sundry debtors which
are with the long period does not include in the quick assets.
Compare with 2016, the Quick ratio is increased because the sundry
debtors are increased due to the increase in the corporate tax and for that
the provision created is also increased. So, the ratio is also increased with
the 2016.
73
ABOSULTE LIQUIDITY RATIO:
Absolute Liquid Assets include cash in hand and at bank and marketable
securities or temporary investments. The acceptable norm for this ratio is
50% or 0.5: 1 or 1: 2 i.e. Re. 1 worth absolute liquid assets are considered
adequate to pay Rs. 2 worth current liabilities in time as all the creditors are
not expected to demand cash at the same time and then cash may also be
realized from debtors and inventories.
(Amount in Rs.)
GRAPHICAL REPRESENTATION
LIQUIDITY RATIOS
3
2.5
2.46
2
1.5
1 1.18
1.14
0.5
0
2015 2016 2017
74
Interpretation
The current assets which are ready in the form of cash are considered as
absolute liquid assets. Here, the cash and bank balance and the interest on
fixed assets are absolute liquid assets.
In the year 2016, the cash and bank balance is decreased due to decrease in
the deposits and the current liabilities are also reduced because of the
payment of dividend. That causes a slight increase in the current year’s
ratio.
75
LEVERAGE RATIOS
PROPRIETORY RATIO:
The proprietary ratio (also known as the equity ratio) is the proportion of
shareholders' equity to total assets, and as such provides a rough estimate
of the amount of capitalization currently used to support a business
(Amount in Rs.)
Proprietary Ratio
GRAPHICAL REPRESENTATION
76
PROPRIETARY RATIOS
0.9
0.8
0.79
0.7 0.75
0.6
0.5
0.53
0.4
0.3
0.2
0.1
0
2015 2016 2017
Interpretation
The shareholder’s funds include capital and reserves and surplus. The
reserves and surplus is increased due to the increase in balance in profit
and loss account, which is caused by the increase of income from services.
Total assets, includes fixed and current assets. The fixed assets are reduced
because of the depreciation and there are no major increments in the fixed
assets. The current assets are increased compared with the year 2016. Total
assets are also increased than precious year, which resulted an increase in
the ratio than old.
77
ACTIVITY RATIOS
The working capital turnover ratio measures how well a company is utilizing
its working capital to support a given level of sales. Working capital is
current assets minus current liabilities. A high turnover ratio indicates that
management is being extremely efficient in using a firm's short-term assets
and liabilities to support sales. Conversely, a low ratio indicates that a
business is investing in too many accounts receivable and inventory assets
to support its sales, which could eventually lead to an excessive amount of
bad debts and obsolete inventory.
(Amount in Rs.)
GRAPHICAL REPRESENTATION
1.35
WORKING CAPITAL TURNOVER RATIOS
1.3
1.31
1.25
1.26
1.2
1.15
1.1 1.13
1.05
1
2015 2016 2017
78
Interpretation
Income from services is greatly increased due to the extra invoice for
Operations & Maintenance fee and the working capital is also increased
greater due to the increase in from services because the huge increase in
current assets.
The income from services is raised and the current assets are also raised
together resulted in the decrease of the ratio of 2017 compared with 2016.
79
FIXED ASSETS TURNOVER RATIO:
(Amount in Rs.)
GRAPHICAL REPRSENTATION
7
6.82
6
4
4.24
3 3.69
0
2015 2016 2017
80
Interpretation
Fixed assets are used in the business for producing the goods to be sold.
This ratio shows the firm’s ability in generating sales from all financial
resources committed to total assets. The ratio indicates the account of one
rupee investment in fixed assets.
The income from services is greatly increased in the current year due to the
increase in the Operations & Maintenance fee due to the increase in extra
invoice and the net fixed assets are reduced because of the increased charge
of depreciation. Finally, that effected a huge increase in the ratio compared
with the previous year’s ratio.
81
CAPITAL TURNOVER RATIO
(Amount in Rs.)
GRAPHICAL REPRESENTATION
1.04
1.04
1.03
1.02
1.01
1
1
0.99
0.98
0.98
0.97
0.96
0.95
2015 2016 2017
82
Interpretation
The income from services is greatly increased compared with the previous
year and the total capital employed includes capital and reserves &
surplus. Due to huge increase in the net profit the capital employed is
also increased along with income from services. Both are effected in the
increment of the ratio of current year.
83
CURRENT ASSETS TO FIXED ASSETS RATIO
(Amount in Rs.)
GRAPHICAL REPRESENTATION
8
8.17
6
6.07
4
4.2
0
2015 2016 2017
84
Interpretation
Current assets are increased due to the increase in the sundry debtors
and the net fixed assets of the firm are decreased due to the charge of
depreciation and there is no major increment in the fixed assets.
The increment in current assets and the decrease in fixed assets resulted
an increase in the ratio compared with the previous year
85
PROFITABILITY RATIOS
(Amount in Rs.)
GRAPHICAL REPRESENTATION
0.4 0.42
0.35
0.3 0.33
0.25
0.2 0.23
0.15
0.1
0.05
0
2015 2016 2017
86
Interpretation
The net profit ratio is the overall measure of the firm’s ability to turn each
rupee of income from services in net profit. If the net margin is inadequate
the firm will fail to achieve return on shareholder’s funds. High net profit
ratio will help the firm service in the fall of income from services, rise in cost
of production or declining demand.
The net profit is increased because the income from services is increased.
The increment resulted a slight increase in 2017 ratio compared with the
year 2016.
87
2. OPERATING PROFIT RATIOS
(Amount in Rs.)
Operating Profit
GRAPHICAL REPRESENTATION
0.7
0.7
0.6
0.57
0.5
0.4
0.41
0.3
0.2
0.1
0
2015 2016 2017
88
Interpretation
The operating profit ratio is used to measure the relationship between net
profits and sales of a firm. Depending on the concept, it will decide.
The operating profit ratio is increased compared with the last year. The
earnings are increased due to the increase in the income from services
because of Operations & Maintenance fee. So, the ratio is increased slightly
compared with the previous year.
89
3. RETURN ON TOTAL ASSETS RATIO
(Amount in Rs.)
GRAPHICAL REPRESENTATION
0.3 0.31
0.25
0.2
0.19
0.15 0.17
0.1
0.05
0
2015 2016 2017
90
Interpretation
This is the ratio between net profit and total assets. The ratio indicates the
return on total assets in the form of profits.
The net profit is increased in the current year because of the increment in
the income from services due to the increase in Operations & Maintenance
fee. The fixed assets are reduced due to the charge of depreciation and no
major increments in fixed assets but the current assets are increased
because of sundry debtors and that effects an increase in the ratio
compared with the last year i.e. 2017.
91
4. RESERVES & SURPLUS TO CAPITAL RATIO
(Amount in Rs.)
GRAPHICAL REPRESENTATION
4 4.19
3.5
2.5 2.75
2
2.02
1.5
0.5
0
2015 2016 2017
92
Interpretation
The ratio is used to reveal the policy pursued by the company a very high
ratio indicates a conservative dividend policy and vice-versa. Higher the ratio
better will be the position.
The reserves & surplus is decreased in the year 2016, due to the payment of
dividends and in the year 2017 the profit is increased. So the increase in the
reserves & surplus caused a greater increase in the current year’s ratio
compared with the older.
93
1. EARNINGS PER SHARE
Formula: Net profit After Tax/ No. of equity shares
(Amount in Rs.)
GRAPHICAL REPRESENTATION
20
15
10
Interpretation
94
Earnings per share ratio are used to find out the return that the
shareholder’s earn from their shares. After charging depreciation and after
payment of tax, the remaining amount will be distributed by all the
shareholders.
Net profit after tax is increased due to the huge increase in the income from
services. That is the amount which is available to the shareholders to take.
There are 1,871,928 shares of Rs.10/- each. Due to the huge increase in net
profit the earnings per share is greatly increased in 2017.
95
(Amount in Rs.)
GRAPHICAL REPRESENTATION
4.5
4 4.15
3.5
3
3.09
2.5
2.39
2
1.5
0.5
0
2015 2016 2017
Interpretation
96
share of a company.
The market price per share is increased due to the increase in the reserves
& surplus. The earnings per share are also increased greatly compared with
the last year because of increase in the net profit. So, the ratio is decreased
compared with the previous year.
97
CH 7
FINDINGS
98
Current ratio is decreasing as compare to the ratios of last years and it is
not up to this mark as per as rule of thumb is concerned. This shows
that company’s liquidity position is not so much good although Current
Asset more than Current Liabilities.
Quick ratio is also not in such a sufficient position than the previous
year’s quick ratio.
Current asset turnover ratio is increasing from 2015 – 2016 but it’s
decreased in the year of 2017.
Working capital turnover ratio has increased in 2015to 2017.
Debtor turnover ratio is deceased because debtors are decreasing due to
decreased in sales.
Net profit of company going negative where gross profit is also coming
down but still its positive which states that company is still in a position
of profit.
Company has more borrowed funds as comparing to cash fund or
business fund.
Company is not maintaining its stocks properly as what we got from the
above data interpretation
99
CH 8
LIMITATIONS
100
1. The study is being conducted under time and money constraints.
2. Due to shortage of time the study is conducted on very small scale i.e.
based upon material and information provided by the company.
3. I have faced a lot of problem in collecting the information about the
company because the company has refused to provide most of the
information being confidential in nature.
101
CH 9
CONCLUSION
102
On the basis of above discussion I conclude that working capital
management is must be followed by every business of both level large as well
as small levels because it helps company to understand there financial
position as well working capital position in the market .
This analysis includes such kinds of tools which help whole company and
there all employees to position out there company in stock market properly.
After reading out this project report or go through of this project report I
conclude that the position of this company not so strong in the market but
it does not says that this company has no market value.
It has, as it sales are increased 7-8% in the last three years. As income of
this company is not crossed its breakeven point but it still going well in the
form of production and sales.
103
CH 10
BIBLOGRAPHY
104
[Link]
[Link]
O&oq=4.+ABOSULTE+LIQUIDITY+RATIO&aqs=chrome..69i57.2906j0j
8&sourceid=chrome&espv=2&es_sm=93&ie=UTF-
8#q=WORKING+CAPITAL+TURNOVER+RATIOital-turnover-ratio
[Link]
O&oq=4.+ABOSULTE+LIQUIDITY+RATIO&aqs=chrome..69i57.2906j0j
8&sourceid=chrome&espv=2&es_sm=93&ie=UTF-
8#q=WORKING+CAPITAL+TURNOVER+RATIO
[Link]
to-calculate-absolute-liquid-ratio-or-cash-ratio-with-equations-test-of-
liquidity/67030/
[Link]
[Link]
statement-analysis/working-capital-869
105
CH 11
ANNEXURES
106
Balance sheet of Tata In rupees crores
consultancy services
SHAREHOLDER’S FUNDS
NON-CURRENT LIABILITIES
CURRENT LIABILITIES
107
Short term provisions 8219.59 7019.35 5827.83
ASSETS
NON-CURRENT ASSETS
CURRENT ASSETS
108
OTHER ADDITIONAL
INFORMATION
CONTIGENT LIABILITIES,
COMMITMENTS
EXPENDITURE IN FOREIGN
EXCHANGE
REMITTANCES IN FOREIGN
CURRENCIES FOR DVIDENDS
EARNING IN FOREIGN
EXCHANGE
BONUS DETAILS
NON-CURRENT INVESTMENTS
109
market value
CURRENT INVESTMENTS
110
111
112