MBA Study: Working Capital Analysis
MBA Study: Working Capital Analysis
CHAPTER I
INTRODUCTION OF THE STUDY
1.1 INTRODUCTION
Working capital plays an important role in any organization, as the company needs
capital for its day to day expenditure .Thousands of companies fail each year due to poor
working capital management practices. Entrepreneurs often don’t account for short term
disruptions to cash flow and are forced to close their operations .In simple term, working
capital is an excess of current asset than the current liabilities .Good working capital
management reveals higher returns of current asset than the current liabilities to maintain a
steady liquidity position of company .Otherwise, working capital is requirement of funds to
meet the day to day working expenses. So a proper way of management of working capital is
highly essential to ensure a dynamic stability of the financial position an organization.
Yashashri polyextrusion ltd, Jaysingpur is one of the well-known company in
Kolhapur district. Seeing the good opportunities to study financial system and practices of
Yashashri polyextrusion, it is relatively important take up internship assignment on
“WORKING CAPITAL MANAGEMENT IN YASHASHRI POLYEXTRUSION LTD,
JAYSINGPUR. Decisions relating to working capital and short term financing are referred to
as working capital management .These involve managing the relationship between firm’s
short-term assets and its short-term liabilities .The goal of working capital management is to
ensure that the firm is able to continue its operations and that it has sufficient money flow to
satisfy both maturing short term debt and upcoming operational expenses.
The project is mainly focus on the industry profile, company profile, SWOT analysis,
annual report and about working capital and financial ratios. The study covers analysis and
interpretation of working capital statements of industry for last five years. Capital required
for a business can be classified under two main categories via, 1) Fixed Capital 2) Working
Capital.
Current assets and current liabilities include three accounts which are of special
importance. These accounts represent the areas of the business where managers have the most
direct impact.
-Account receivable (current assets)
-Inventory (Current assets), and
-Account payable (current liabilities)
CHAPTER II
COMPANY PROFILE
Turnover of Yashpoly 20 Cr
No of Staff Members 25
Mission:
To build enduring relationships with customers, suppliers, employees and peer groups
Leveraging the very latest technology and providing high quality products and services and
company intends to bring the best of uPVC eco-friendly profiles across the world
Strengths:
Extrusion Technology: Kraussmaffie (Austria) and Cincinnati (Germany)
80+ Fabrication units across India BHUTAN and DUBAI
40+ high Grade uPVC profile for windows. Doors .and prefab cabins
Pioneer in WPC (Wood Polymer Composite) Multicity Extrusion doors in India.
2.5 TECHNOLOGY:
Four highly precise and advanced European machinery from Cincinnati (Germany)
and Krusussmaffic (Austria) give our profiles and edge over others. High grade raw material
and experience of over two decade in uPVC compounding are our unique selling prepositions
Along with this best in class in-house lamination unit, GI reinforcement, TPE and
EPDM Gasket manufacturing plant and dedicated window manufacturing software division
makes us a one stop shop for all uPVC and WPC requirements.
2. PROFILE DESIGN
3. PARTITIONS
4. uPVC DOORS
5. CABINS
6. uPVC ceiling
MANAGING DIRECTOR
Mrs Rajesh Patil
GENERAL
GENERAL MANAGER (sales)
MANAGER
ACCOUNTANT PURCHASE
MANAGER
HR MANAGER
FACTORY
MANAGER
PRODUCTION
MANAGER
STORE MANAGER
QUALITY CONTROL
CHAPTER III
THEORETICAL BACKGROUND
3.1 INTRODUCTION
One of the most important areas in day-to-day management of the firm deals
with the Management of working capital. Which is defined as all the short-term assets used in
daily Operations. These consist primarily of cash, marketable. Securities. Account receivable
and Inventories. Some of the decisions taken in working capital management are-
1) An adequate supply of raw materials.
2) Cash to meet the operation Payments.
3) The ability to grant credit to customers.
4) The capacity to wait for market for its finished products.
5) Investments in various current assets.
6) Appropriate sources of fund to finance current assets.
7) Proportion of long term and short term funds to finance current assets.
It may be clear that the objective of working capital management is to
maintain a satisfactory level to working capital. In other words, the current assets should not
only be sufficient enough to cover the current liabilities but at the same Time should also
ensure the reasonable amount of safety margin. This is possible only when the different
components of working capital are properly balanced.
“A working capital is the amount funds necessary to cover the cost of operating
Enterprises”.
-Shan
“Working capital refers to a firm’s investment in short term asset cash short Term
Securities account receivable inventories”.
-Weston& Brigham.
“The sum of the current asset in the working capital of the business.”
-J.S. Mill.
Gross working capital refers to the firm’s investment in current assets are the Assets
which can be converted into cash within an accounting year and include cash short Term
securities, debtors, bill receivables and inventories.
It is difference between the current assets and current liabilities or the excess of
Total current assets over total current liabilities. It can also be defined as that part of a Firm’s
current asset which is financed with long term funds. It may be either negative or Positive.
When the current assets exceed the current liabilities, the working capital is Positive and
vice-versa.
5 Gross concept suitable for 5 Net concept suitable for sole trader
companies. and partnership firm.
6 It cannot revel the true financial 6 It is very useful to find out true the
position of the company. financial position of a company
Current Asset-
Components of current asset
a) Stock of material in trade.
b) Sundry debtors.
c) Bill of exchange.
e) Deposits.
i) Prepaid expenses.
j) Outstanding income.
Current liabilities.
Current liabilities include all the obligations of the concern that are maturing
Within accounting year.
Components of current liabilities-
a) Sundry creditors.
e) Outstanding expenses.
a sufficient amount of Cash to maintain reasonable quantities of raw materials for processing
into Finished goods to ensure quick delivery etc.
Beyond initial and regular working capital, most businesses will require at stated
Intervals a large amount of current assets to fill the demands of the seasonal busy perilous
During the season, the business enterprises have to push up purchase of raw materials And
employ more people to convert them into finished goods and thus require large amount of
working capital.
It is that part of the variable capital which is needed for financing special
operations such as the organization of special campaigns for increasing sales through
advertisement or other sale Promotion activities for conducting research experiments or
execution of special orders of Government that will have to be financed by additional
working capital. The distinction between Permanent and variable Working capital is
important in arranging the finance for an enterprise. Permanent working Capital should be
raised in the same way as fixed capital is period.
Time
Temporary working capital the above figure illustrate that the permanent working capital is
stable overtime. While temporary working capital is fluctuating, sometimes increasing and
sometimes decreasing However the permanent working capital line need not be horizontal, if
the firm’s requirement for Permanent working capital is increasing or decreasing over a
period.
Time
A firm must have to invest sufficient funds in working capital i.e. as much as needed
by the firm. It should neither be excessive nor inadequate. Both situations are dangerous.
Excessive working Capital means the firm has idle funds, which earns nothing for the firm. In
adequate working Capital means the firm does not have sufficient fund to meet its current
obligations, which ultimately affect the production process and all operations of the firm, and
ultimately checks the Bottom line.
The last phase, phase 3, represents the sage when reworking capital cycle/
operating cycle. Thus the firm has moved from cash to inventory, to receivables and to cash
again.
Cash
Account Raw
Receivable Material
Finished Work-in-
Goods progress
A company should make every efforts to relate matures of payments to its flow or
internally generated funds there should be the lease disparity between maturates of a firm.
Short Term that debt instruments and its flow of internally generated lands because a greater
risk is generated with greater disparity.
2) Scale of operations
The larger will be the amount of working capital required as because the larger
business Units are required to maintain huge inventories and also spend more in carrying out
then Business operations smoothly. A business unit carrying on activities on a small scale
needs less working capital.
3) Sales
Among the various factors, size of the sales is one of the important factors in
determining the amount of working capital. In order to increase sales volume, the enterprise
needs to maintain its current assets. In the course of period, the enterprise becomes in the
position to keep a steady ratio of its current assets to annual sales. As a result, the turnover
ratio, i.e., current assets to turnover increases reducing the length of operating cycle. Thus,
less the operating cycle period, less will be requirements for working capital and vice versa.
5) Terms of Credit
Another important factor that determines the amount of working capital requirements
relates to the terms of credit allowed to the customers. For instance, an enterprise may allow
only 15 days credit, while another may allow 90 days credit to its customers. Besides, an
enterprise may extend credit facilities to its all customers, while another enterprise in the
same business may extend credit only to select and those too reliable customers only
6) Seasonal Variation
7) Turnover of Inventories
If inventories are large in size but turnover is slow, the small-scale enterprise
will need more working capital. On the contrary, if inventories are small but their turnover is
quick, the enterprise will need a small amount of working capital.
9) Contingencies
If the demand for and price of the products of small- scale enterprises are
subject to wide variations or fluctuations, the contingency provisions will have to be made for
meeting the fluctuations. This will obviously increase the requirements for working capital of
the small enterprises. While one can add certain other factors to this list, the said factors
appear to be the major ones in determining the requirement of working capital of a small-
scale enterprise
The standard working capital productivity ratio includes sales, current asset and
Current liabilities. This information is all short- term data a company generates during normal
Business operations. The data is subject to wide variations through each month and year. The
Working capital productivity ratio has limit as long -term information has no inclusion in this
Formula. Therefore, other ratios are necessary to assess other parts of the company’s
operations
4) Considerations
Accountants can usually prepare ratio at any time by reviewing the general
leader For requisite information. Internal stakeholder can use up-to-date ratio information to
Assess business operations at a given time. The issue, however, is the possibility that
Information is not 100 percent accurate during the month. Companies that use ratios Outside
of the normal financial statement data may also experience distorted information.
2) Trade discounts is lost. A company with sample working capital is able to finance
3) Cash discounts are lost. Some companies will try to customers are foregone.
4) The advantages of being able to offer a credit line to customer are forgone
5) Financial reputation is lost result in non- cooperation from trade creditors in time of
Difficulty
6) There may be concerned action by creditors and will apply to court for winding up
-Cash flow within the cash balance held by firm appoint of time by deficit investing surplus
cash.
2. Inventory Management
Inventory is stocks of product a company manufacturing or sale and components that make
up the project. The various forms in which inventory exists in a manufacturing company are
Raw Material
Finished Goods and Spare parts
Objective of inventory Management
To minimize the firm investment inventory to maximize profitability.
To ensure a continuous supply of materials.
Maintain sufficient finished goods inventory for smooth sale operations and sufficient
finished
Goods inventory Tor smooth sale operations and efficient customer service.
3. Receivable Management
Trade credit is most prominent force of modern business. It is considered as
an essential marketing too1. Firms grant trade credit to protect its sale from competitor’s and
to attract the potential customers Receivable constitute a substantial of current assets of
several firms.to its products buy at interesting term. Trade debuts after investing credit and
crediting debtors amount to blocking of firms funds the interval between the dates of sale and
date of payment has to be financed out of working capital, As substantial amounts are tied up
in trade debtors it needs careful analysis and proper management.
2) Goodwill-
Sufficient amount of working capital enables a firm to make prompt payments and
maintain the goodwill.
3) Easy loans
Adequate working capital leads to high solvency and credit standing can arrange
Banks and other on easy and favorable terms. From banks and other on easy and favorable
terms
4) Cash Discounts –
Adequate working capital also enables a concern to avail cash discounts on the
purchases and hence reduces cost.
A ) Current Assets
b)Work in Progress
-Labor XXX
-Labor XXX
d)Sundry Debtors
-Labor XXX
a)Creditors XXX
Net sale
Total Assets
CHAPTER IV
DATA ANALYSIS
TABLE NO.4.1
Particular 2018-19 2019-20 2020-21 2021-22
(A)Current Assets
(B)Current liabilities
Graphical Representation
Interpretation
From the above table it can observe that there is change in working capital position. In
FY 2018-2019 working capital has Rs. 12006719/- From the above calculation it can
see there is increase in net working capital by Rs. 912102/- From the above table it is
observed that in FY 2020-2021 working capital is increase by Rs. 2990249/- then in
FY 2021-2022 working capital increase by Rs. 3134044/- and so as compare to the
FY 2018-2019 and FY 2021-2022 working capital has increased.
Table No-4.2
Particular 2018-2019 2019-2020 Increase Decrease
(A)Current Assets
(B)Current liabilities
Graphical Representation
12800000
12600000
12400000
12200000
12000000
11800000
11600000
11400000
2018-2019 2019-2020
Interpretation
The above table shows the current asset for the FY 2018-2019 was Rs. 17653331/- on the
other hand for FY 2019-2020 it was Rs. 18565433/- It indicates those current assets were
increased by Rs. 912101/- Current liabilities were for the FY 2018-2019 was Rs. 5646612/-
and for FY 2019-2020 it was Rs. 5646612/- It shows that the current liabilities were remains
same .Hence Net Working Capital is increased by Rs 912102/-
(A)Current Assets
(B)Current liabilities
Graphical Representation
Interpretation
The above table shows the current asset for the FY 2019-2020 was Rs. 18565433 /- on the
other hand for FY 2020-2021 it was Rs. 17667458 /- It indicates those current assets were
decreased by Rs. 897975 /- Current liabilities were for the FY 2019-2020 was Rs.56466122 /-
and for FY 2020-2021 it was Rs. 1758388/- It shows that the current liabilities were increased
by 3888224 /- .Hence Net Working Capital is increased by Rs 2990249/-
(A)Current Assets
(B)Current liabilities
2020-2021 15909070
2021-2022 19043114
Graphical Representation
19043114
19000000
18000000
17000000
16000000
15909070
15000000
14000000
2020-2021 2021-2022
Interpretation
The above table shows the current asset for the FY 2020-2021 was Rs. 17667458/ - on the
other hand for FY 2021-2022 it was Rs. 21884786/- It indicates those current assets were
increased by Rs. 4217328/- Current liabilities were for the FY 2021-2022 was Rs. 1758388 /-
and for FY 2019-2020 it was Rs. 2841672/- It shows that the current liabilities were increased
by 1083284/- .Hence Net Working Capital is increased by Rs 3134044/-
Table no 4.5.1
Graphical Representation-
Current Ratio
12
10
10
8 7.7
4 3.12 3.28
0
2018-2019 2019-2020 2020-2021 2021-2022
Interpretation
The ratio falls under the category of short term solvency ratio .As a conventional rule, a
current ratio of 2:1 or more is considered satisfactory. In the FY 2018-2019 it was 3.12:1 in
FY 2019-2020 it was increased to 0.16:1, In the FY 2020-2021 it was increased by 6.72:1
and in the FY 2021-2022 it was decreased by 0.02:1 This shows company’s short term
solvency position is healthy.
Table no 4.5.2
Graphical Representation
3.5 3.4
3
3
2.7
2.5 2.4
1.5
0.5
0
2018-2019 2019-2020 2020-2021 2021-2022
Interpretation
This ratio falls under the category of Activity Ratio. Debtors’ turnover ratio from the
year 2018-2019 is 3.0 Times and year 2019-2020 is 2.4 Times so ratio is decreased by
0.6 Times, Debtors turnover ratio from the year 2019-2020 is 2.4 Times and year
2020-2021 is 3.4 Times so ratio is increased by 1.0 Times .Debtors turnover ratio in
2020-2021 is 3.4 Times in 2021-2022 is 2.7 Times so ratio is decreased by 0.7 Times.
Table no 4.5.3
Year 2018-2019 2019-2020 2020-2021 2021-2022
Trade Debtors 12038249 13238249 10875034 16887058
Sales 36379662 32679662 37595011 47190509
Debtors Velocity 120 Days 147 Days 105 Days 130 Days
(Source: Secondary Data: Financial Statement)
Graphical Representation
Debtors Velocity
160
147
140 130
120
120
105
100
80
60
40
20
0
2018-2019 2019-2020 2020-2021 2021-2022
Interpretation
This ratio falls under the category of activity ratio it shows how many days customer
takes to pay amount In the FY 2018-2019 customer takes 120 Days, In the FY 2019-
2020 Take 147 Days to pay the amount and in the FY 2020-2021 customer takes 105
Days in the FY 2021-2022 Takes 130 Days to pay the amount.
Table no 4.5.4
Graphical Representation
6 5
3.82
4
0
2018-2019 2019-2020 2020-2021 2021-2022
Interpretation
This ratio falls under the category of Activity Ratio. Credit’ turnover ratio from the
year 2019-2020 is 5.0 Times and year 2019-2020 is 3.82 Times so ratio is decreased
by 1.18 Times, Debtors turnover ratio from the year 2019-2020 is 3.82 Times and
year 2020-2021 is 12.94 Times so ratio is increased by 9.12 Times .Debtors turnover
ratio in 2020-2021 is 12.94 Times in 2021-2022 is 10.36 Times so ratio is decreased
by 2.58 Times.
Table no 4.5.6
Year 2018-2019 2019-2020 2020-2021 2021-2022
Trade Creditor 5618171 5618171 1731212 2812224
Net Purchase 28633619 21505710 22402879 29143402
Creditor Velocity 71 Days 95 Days 28 Days 35 Days
(Source: Secondary Data: Financial Statement)
Graphical Representation
Creditor Velocity
100 95
90
80
71
70
60
50
40 35
30 28
20
10
0
2018-2019 2019-2020 2020-2021 2021-2022
Interpretation
This ratio falls under the category of activity ratio it shows a measure of how often a
particular company pays off its debts to suppliers within giving accounting period In the FY
2018-2019 customer takes 71 Days, In the FY 2019-2020 Take 95 Days to pay the amount
and in the FY 2020-2021 customer takes 28 Days in the FY 2021-2022 Takes 35 Days to pay
the amount.
Table no 4.5.6
Year 2018-2019 2019-2020 2020-2021 2021-2022
Sales 36379662 32679662 37595011 47190509
Stock 4515328 4206830 3611696 3823909
Stock Turnover Ratio 8.0 Times 7.7 Times 10.4 Times 12.3 Times
(Source: Secondary Data: Financial Statement)
Graphical Representation
0
2018-2019 2019-2020 2020-2021 2021-2022
Interpretation
This ratio falls under the category of activity ratio Stock turnover ratio from the year
2018-2019 is 8.0 Times and year 2019-2020 is 7.7 Times so ratio is decreased by 0.7
Times stock turnover ratio from the year 2019-2020 is 7.7 Times and year 2020-2021
is 10.4 Times so ratio is increased by 2.7 Times .Stock turnover ratio in 2020-2021 is
10.4 Times in 2021-2022 is 12.3 Times so ratio is increased by 12.3 Times.
Table no 4.5.7
Year 2018-2019 2019-2020 2020-2021 2021-2022
Stock 4515328 4206830 3611696 3823909
Sales 36379662 32679662 37595011 47190509
Stock Velocity 45 Days 46 Days 35 Days 29 Days
(Source: Secondary Data: Financial Statement)
Graphical Representation
Stock Velocity
50
45 46
45
40
35
35
30 29
25
20
15
10
5
0
2018-2019 2019-2020 2020-2021 2021-2022
Interpretation
This ratio falls under the category of activity ratio. It shows how many days are required to
turn the raw material into finished goods or within how many days finished goods laying in
the go-down In FY 2018-2019 it Takes 45 days and in the FY 2019-2020 it takes 46 Days In
the FY 2020-2021 takes 35 days and and in the FY 2021-2022 it Takes 29 Days.
Table no 4.5.8
Graphical Representation
1.5
0.5
0
2018-2019 2019-2020 2020-2021 2021-2022
Interpretation
Working capital turnover ratio from the year 2018-2019 is 3.0 Times and year 2019-2020 is
2.5 Times so ratio is decreased by .05 Times working capital turnover ratio from the year
2019-2020 is 2.5 Times and year 2020-2021 is 2.3 Times so ratio is decreased by 0.3 Times.
Working capital turnover ratio in 2020-2021 is 2.3 Times, in 2021-2022 is 2.4 Times so ratio
is increased by 0.1 Times .
Table no 4.5.9
Graphical Representation
Current Assets Turnover
2.5
2.12 2.15
2
2
1.76
1.5
0.5
0
2018-2019 2019-2020 2020-2021 2021-2022
Interpretation
This ratio falls under the category of efficiency ratio. This shows the amount invested in the
current assets to generate the sales volume. Here in financial year 2018-2019 the ratio is 2.0
Times then in FY 2019-2020 the ratio decreased by 0.24 Times after that in FY 2020-2021
is increased by 0.36 Times then in FY 2021-2022 increased by 0.3 Times
Table no 4.5.10
Graphical Representation
Quick Ratio
9
7.9
8
7
6.3
6
5
4
3 2.5
2.3
2
1
0
2018-2019 2019-2020 2020-2021 2021-2022
Interpretation
This ratio falls under the category of Liquidity ratio. It’s ideal ratio is 1:1. Here in financial
year 2018-2019 the ratio is 2.3:1 then in FY 2019-2020 the ratio 2.5:1 after that in FY 2020-
2021 is i 7.9:1 then in FY 2021-2022 increased by 6.3:1 Here quick ratio is more than ideal
ratio so company’s short term solvency position is healthy
CHAPTER V
FINDINGS AND SUGGESTIONS
5.1 FINDINGS
1) It is found from table no 4.1 that the working capital has increased over the period and
company is able to meet its short term financial requirement.
2) It is observed that from table no 4.2 FY 2019-2020 current asset value where consistently
increase. And liabilities are remaining same.
3) It is found that from Table No 4.3 Both current assets and liabilities are decreased in FY
2020-2021.And net working capital increased.
4) It is found that from Table No 4.3 Both current assets and liabilities are increased in FY
2021-2022.And net working capital also increased.
5) It is found that from Table no 4.5.1 Current ratio is more than ideal ratio i.e.2:1, this shows
company’s short term solvency ratio is healthy.
6) It is found that from Table no 4.5.2 and 4.5.3 that company’s debtors require more days to
change debts into cash during one financial year.
7) It is found that from Table no 4.5.4 and 4.5.5 that how often a particular company pays off
its debts to suppliers within giving accounting period in that company require more days pay
off its debts.
8) It is found that from Table no 4.5.6 and 4.5.7 that company able to quickly turn its
inventory into sales.
9) It is found that from Table no 4.5.8, company’s working capital turnover ratio is good, and
indicates that a company is able to generate a larger amount of sales.
10) It is found that from Table no 4.5.9, current asset turnover ratio of company is good, as it
indicates a more efficient use of assets.
11) It is found that from Table no 4.5.10, companies quick ratio is more than ideal ratio so
company’s short term solvency position is healthy.
5.2 SUGGESTIONS
1) It has been suggested that the company should take measures to control the current
liabilities as the current liabilities are increasing over the years.
2) It has been suggested that the company should use its working capital optimally to increase
its advances.
3)Company should focus and ensure that it collects the full amount of debts from average
accounts receivables at least once during a period, as company’s debtors are taking more
time to pay their debts during financial year.
4) It is suggested that, company should focus on increasing current asset turnover ratio,
because the more the amount of current asset turnover ratio, the better the ability of the
company to generate sales.
5) It is suggested that the company should work on to improve its working capital turnover
ratio as this may help the company to efficiently utilize its short term assets and liabilities to
support its sales levels.
5.3 CONCLUSION
As per calculation current asset are the main part of the working of the company. So,
the company should use its working capital optimally to increase its advances. So it
concluded that the short term solvency position of the company strengthen by investing
owners fund more in working capital.
BIBLOGRAPHY
Website:
www.wickipedia.com
www.investopedia.com
www.momeycontrol.com