IJNRD2207166
IJNRD2207166
IJNRD2207166
ORG
ABSTRACT
The project examined the company performance towards receivables action executing in Lakshmi Machine Works Ltd.,
Coimbatore. The prime objective is to analyze and evaluate the receivables management and its performance in Lakshmi
Machine Works Ltd., Coimbatore. The study used ratio analysis and trend analysis as tools to find out that the efficiency of
receivables management during the study period. The ratios were Receivables to Current Assets Ratio, Receivables to Total
Assets Ratio, Receivables to Sales Ratio, Receivables Turnover Ratio, Average Collection Period, and Working Capital Ratio,
have been computed to show the impact on working capital. Data was analyzed using descriptive research to give results.
Charts, tables and graphs were used to report findings. The study concluded that, accounts receivable management as practiced
in Lakshmi Machine Works Ltd was adequate. Recommendations were made to better enhance accounts receivable management
in Lakshmi Machine Works Ltd. Findings of the study are only related to the financial statements of Lakshmi Machine Works
Ltd.
Keywords - Receivables Management, Trend analysis, Ratio, working capital.
1. INTRODUCTION
Receivable management is otherwise known as Debtor’s management. Accounts receivable is an accounting transaction
which deals with the billing of customer who owes money to a person, company or organization for goods and services that has
been provided to the customers. In most business entities this is typically done by generating an invoice and mailing or
electronically delivering it to the customer, who in turn must pay it within an established timeframe called credit or payment
terms. An example of a common payment term is Net 30, meaning payment is due in the amount of the invoice 30 days from
the date of invoice. Other common payment terms include Net 45and Net 60 but could in reality be for any time period agreed
upon by the vendor and the customer.
On a company's balance sheet, accounts receivable is the amount that customers owe to that company. Sometimes called
trade receivables, they are classified as current assets assuming that they are due within one year. To record a journal entry for
a sale on account, one must debit a receivable and credit a revenue account. When the customer pays off their accounts, one
debits cash and credits the receivable in the journal entry. The ending balance on the trial balance sheet for accounts receivable
is always debit. Accounts receivable departments use the sales ledger. Other types of accounting transactions include accounts
payable, payroll, and trial balance.
1.2.4 PROFIT:
The level of receivables increases as a result of increase in sales. When sales increase beyond a certain level, the additional
cost incurred are less than the increase in revenue. It will be beneficial to increase sales beyond a point because it will bring
more profit. The increase in profit will be followed by an increase in the size of the receivable.
1.2.5 MARKET:
It may be necessary for the firm to explore a new market for its products/services. One of the attractive way in which a firm
enters a new market is by giving incentives to the customers in the form of credit facilities. In doing so, the size of receivable
will increase.
1.3.5 BENEFITS:
Apart from the cost, another factor that has a bearing on accounts receivableis the benefit emanating from credit sales. The
benefits are: “The increased sale and thereby profits”.However, the benefits would depend upon the credit policy adopted by
the firm, i.e., a conservative or liberal credit policy. The impact of liberal credit policy is likely to have two forms:-
Sales expansion
Sales retention
In sales expansion a firm may grant credit either to increase sales or to attract new customer. This motive is growth oriented;
on the other hand the sales retentionthe firm may grant credit to protect its current sales against emerging competition. No matter
whatever is the motive, the result the result of increased sales is the increase the profit of the firm.
2. INDUSTRY PROFILE
2.1.1 AUTOMOTIVE INDUSTRY
The Automotive industry is the key driver of any growing economy. A sound transportation system plays a pivotal role in
a country’s rapid economic and industrial development. The well-developed Indian automotive industry ably fulfils this
catalytic roleby producing a wide variety of vehicles. The automobile industry comprises automobile and auto component
sectors. It includes passenger cars; light, medium and heavy commercial vehicles; multi-utility vehicles such as jeeps, scooters,
motorcycles, three-wheelers and tractors; and auto components like engine parts, drive and transmission parts, suspension and
braking parts, and electrical, body and chassis parts. India’s automotive industry is now worth $34 billion and expected to
grow$145billion in another ten years. The Indian automotive industry is growing at a very high ratewith sales of more than one
companion passenger vehicles per annum. The overall growth rateis 10-15 per cent annually. India is the world’s second largest
IJNRD2207166 International Journal of Novel Research and Development (www.ijnrd.org) 1469
© 2022 IJNRD | Volume 7, Issue 7 July 2022 | ISSN: 2456-4184 | IJNRD.ORG
manufacturer of two-wheelers, fifthlargest manufacturers of commercial vehicles as well as largest manufacturer of tractors. It is
thefourth largest passenger car marketin Asia and home to the largest motorcycle manufacturer. Major players in this sector
include Tata, Mahindra, Daewoo Motor India, Hyundai Motors India and General Motors India, Maruti, Ashok Leyland, Bajaj,
Hero Honda, Ford, Fiatand few other players. The Indian auto components industry is worth $10 billion. Indigenous firms like
Bharat Forge, Sundaram Fasteners, Minda Industries and Gabrial India Ltd. are in the limelight. There is a boom in the auto
components segment because of strong demand and robust economy. Indian companies are very optimistic. The Auto
Components Manufacturers Association (ACMA) along with McKinsey has pegged domestic demand for components at $20-
25 billion in 2020 from $1.4 billion in 2015-16. This would take the overall industry size to $40-45 billion by 2015 in India. The
Indian automotive industry has made rapid strides since witnessing the entry of several new manufacturers with state-of-the-art
technology.
3. REVIEW OF LITERATURE
Lazaridis and Tryfonidis (2020) also investigated relationship between accounts receivables management and corporate
profitability for the firms listed in Athens StockExchange for a sample of 131 listed companies. The researcher used the
company financials from 2001-2004 for the study. The results of the study of regression analysis showed that there was a
statistically significant relationship between gross operating profit, a measure of profitability and the cash conversion cycle. He
suggested that by optimizing the cash conversion cycle the managers could create value for the shareholders. Results of
empirical analysis show that there is statistical evidence for a strong relationship between the firm’s profitability and its
receivables management efficiency.
Afza and Nazir (2020) made an attempt to investigate the traditional relationship between receivables management
policies and a firm’s profitability for asample of 204 non- financial firms listed on Karachi Stock Exchange (KSE) for the period
1998-2005.The study found significant difference among their receivables requirements and financing policies acrossdifferent
industries. Moreover, regression results found a negative relationship between the profitability of firms and the degree of
aggressiveness of receivables investment and financingpolicies.
IJNRD2207166 International Journal of Novel Research and Development (www.ijnrd.org) 1472
© 2022 IJNRD | Volume 7, Issue 7 July 2022 | ISSN: 2456-4184 | IJNRD.ORG
Suk. H, Kim.SH and Rowland have conducted a survey among 94 Japanese companies in USA (2013) found that they differed
in working capital management practices from the US companies in terms of lower levels of inventory and higher levels of
accounts receivables. The study revealed that the US firms piled-up their inventories; Japanese firms hadhigher percentage of
receivables to total assets.
Deloof, M (2020) found a significant negative relation between gross operating income and the number of days accounts
receivables, inventories and accounts payables of Belgian firms. These results suggested that managers can create value for their
shareholders byreducing the number of day’s accounts receivables and inventories to a reasonable minimum. The negative
relationship between accounts payable and profitability inconsistent with the viewthat less profitable firms wait longer to pay
their bills.
Vanhorne in his study (2021), recognizing receivable management as an area largely lacking in theoretical perspective,
attempted to develop a framework in termsof probabilistic cash budget for evaluating decisions concerning 51the level of liquid
assets and the maturity composition of debt involving risk-return trade-off. He proposed calculation of different forecasted
liquid asset requirements along with their subjective probabilities under different possible assumptions of sales, receivables,
payables and other related receipts and disbursements. He suggested preparing a schedule showing, under each alternative of
debt maturity, probability under each alternative of debt maturity, probability distributions of liquidassetbalances for future
periods, opportunity cost, maximum probability of running out ofcashand number of future periods in which there was a chance
of cash stock-out. Once the risk andopportunity cost for different alternatives were estimated, the formcould determine the best
alternative by balancing the risk of running out of cash against the cost of providing a solutionto avoid such a possibility
depending on management’s risk tolerance limits. Thus, Vanhorne study presented a risk-return trade-off of receivable
management in entirely new perspective byconsidering someof the variables probabilistically. However, the usefulness of the
framework suggested by Vanhorne is limited because of the difficulties in obtaining informationabout the probability
distributions of liquid-asset balances, the opportunity cost andthe probability of running out of cash for different alternative of
debt maturities.
Deloof (2021) surveyed on Belgian Firms to find out whether the receivables management affects profitability. He found that
most firms had a large amount of cash investedin receivables. It can be expected that the way in which working capital is
managed, will havea significant impact on the profitability of those firms. Using correlation and regression tests he found a
significant negative relationship between corporate profitability and number of days accounts receivable, inventories and
accounts payable of Belgian firms. On the basis of these he suggested that manager could increase corporate profitability by
reducing the number of days accounts receivable and inventories to a reasonable minimum. The negative relationship between
accounts payable and profitability is consistent with the view that less profitable firmswait longer to pay their bills.
Beneda, Nancy; Zhang, Yilei (2021), studied impact of receivable management on the operating performance and growth of
new public companies. The study also sheds light onthe relationship of receivable with debt level, firm risk, and industry. Using
a sample of initial public offerings (IPO's), the study finds a significant positive association between higher levelsof accounts
receivable and operating performance. The study further finds that maintaining control (i.e. lower amounts) over levels of cash
and securities, inventory, fixed assets, and accounts.
Pass C.L., Pike R.H(2021), studied that over the past 40 years major theoretical developments have occurred in the areas of
longer-term investment and financial decision making. Many of these new concepts and the related techniques are now being
employed successfully in industrial practice. By contrast, far less attention has been paid to the area of short-term finance, in
particular that of receivable management. Such neglect might be acceptable were receivables considerations of relatively little
importance to the firm, but effective receivables management has a crucial role to play in enhancing the profitability and growth
of the firm. Indeed, experience shows that inadequate planning and control of receivables is one of the more common causes of
business failure.
Pasuvappa. M (2018) Accounts receivable of a firm is a legally enforceable claim forpayment from a business to its customers
/ clients for goods supplied and / or services renderedin execution of the customer’s order. On the balance sheet, it is reported as
a current asset andis considered part of an organization’s working capital. The foundation behind accounts receivable is
a firm’s policies and procedures for sales. A system must be in place to track accounts receivable. This should include balance
forwards, listing of all open invoices and generation of monthly statements to customers. An aging of receivables should be
used tocollect overdue accounts. Several empirical papers also address trade receivableles.
4 RESEARCH METHODOLOGY
Research methodology is the specific procedures or techniques used to identify, select, process, and analyze information
about a topic. In a research paper, the methodology section allows the reader to critically evaluate a study's overall validity
and reliability.
TABLE NO – 5.1
STATEMENT OF CASH COLLECTION AND PAYMENTS(In lakhs)
INFERENCE:
The above table shows that the amount of money collected against the receivables was high in the year 2018-2019 and the
amount paid to the creditors was high in the year2015-2016.In the year 2016-2017 the amount of money collected was low. The
balance remained after making the payment to the creditors showed an increasing in 2018-2019.
31,391.62
2016-2017 31,590.46 1,639.27 1,838.11 0.63
27,749.54
2017-2018 29,021.15 1,838.11 3,109.72 4.38
33,247.49
2018-2019 32,605.16 3,109.72 2,467.39 -1.97
40,773.66
2019-2020 39,689.62 2,467.39 1,383.35 -2.73
40,129.18
2020-2021 39,789.62 1,383.35 1043.79 -0.85
INFERENCE:
The above table shows that the cash realized against receivables was steadily increasingfrom the year 2017-2018 to
2020-2021. The percentage of outstanding debtors showedfluctuating trend. The percentage of outstanding debtors
was high in the year 2017-2018. But in the next year this percentage has been decreased at negative percentage.
TABLE NO -5.4
DEBTORS TURN OVER RATIO / RECEIVABLES TURNOVER RATIO
(In lakhs)
INFERENCE:
From the above table, it can be inferred that the debtor turnover ratio of the firm was decreased from the year 2016-2017 to
2018-2019. Then the ratio was increased from the year2018-2019 to 2020-2021. The ratio shows a fluctuating trend.
2016-2017 18.17 20
2017-2018 11.73 31
2018-2019 11.69 31
2019-2020 20.61 17
2020-2021 32.78 11
INFERENCE:
From the above table it is inferred that in all the year a major portion of the working capital was occupied by
receivables. The ratio of receivables to working capital has shows an increase from the year 2016-2017 to 2017-2018.
Then it has decreased from the year 2018- 2019 to 2019-2020. The ratio of receivables to working capital is very low
in the year 2020- 2021. It shows that the concern utilized its working capital for necessary needs.
INFERENCE:
From the above table it is inferred that certain portion of the current assets was occupiedby receivables. The ratio of receivables
to current assets has shown an increase from 2016- 2017 to 2017-2018. Then it decreased from the year 2018- 2019 to 2019-
2020. It shows that 0.09 is very least during the year 2020-2021.
(In lakhs)
INFERENCE:
The above table shows that the cash position ratio has increased from 2016 -2017 to 2017-2018.Then it has decreased from the
year 2018-2019 to 2019-2020. It shows fluctuating trend during the study period.
TABLE NO – 5.10
RETURN ON INVESTMENT(In lakhs)
INFERENCE:
The above table shows that there is increasing net profit ratio from 2016- 2017 to 2018-2019. And it has decreased to 44.74 and
45.78 in the year 2018-2019 and 2020-2021 respectively. It shows highest net profit ratio 50.94 in the year 2018-2019.
INFERENCE:
The above table shows that the return on total assets ratio was in increasing trend. It hasincreased from the year 2016-2017 to
2020-2021. It shows the highest ratio 20.17 in the year 2020-2021.
Average
Rear Credit Ratio
accounts
purchases
payable
TABLE NO – 5.14
AVERAGE PAYMENT PERIOD (In lakhs)
Creditors turnover
Year Creditors payment
ratio(times) period(days)
INFERENCE:
The above table shows that the average payment period is fluctuating. It has decreasedfrom the year 2016-2017 to
2019-2020. And it has increased to 410.11 in the year 2020-2021. The highest payment period is 1140.62 days in the
year 2016- 2017. It shows their cash positionduring the study period.
INFERENCE:
The above table shows that there is fluctuation in quick ratio during the study period. Ithas increased from 2016-
2017 to 2017-2018. It has decreased from 2017-2018 to 2018-2019. And it has increased to 1.94 in the year 2019-
2020. And slightly it has decreased to 1.92 in theyear 2020-2021.
TABLE NO – 5.17
CORRELATION ANALYSIS CORRELATION BETWEEN SALES
AND DEBTORS
S.No X Y X2 Y2 XY
3378648.37 58066740.
1 31,590.46 1,838.11 997957163
2 43
842227147. 9670358.47 90247650.
2 29,021.15 3,109.72
3 8 58
6088013.41 80449645.
3 32,605.16 2,467.39 1063096459
2 73
1913657.22 54904635.
4 39,689.62 1,383.35 1575265936
3 83
1089497.56 41532007.
5 39,789.62 1043.79 1583213860
4 46
Total 22140175.0
172,696.01 9,842.36 6061760564 325200680
5
r= 0.83
INTERPRETATION
The above table shows that co-efficient of correlation between sales and debtors is
0.83. It is below 1. So there is positive relationship between these two factors.
TABLE -5.18
TREND ANALAYSIS
Year Net Profit(y) X X2 Xy
.Let the equation of the straight line of best fit, with the origin at the middle year 2020and unit of X
as 1 year, be
Y = a + Bx
By the method of least square, the values of a and b are given bya =∑Y/N and b =∑XY/∑X2
N = number of years = 5
Using [2], a =∑y/N = 78,855.42/5 =15771.084 , and b =∑XY/∑X2 =16,186.03
/10 =1,618.60
Substuting these values in (1),we get, the required equation of the best fitted straightline as :
Y= 15771.084 + 1,618.60 x., with 2011 = 0
Table: 5.19
Trend Values
X
YEARS TREND VALUES [ Y=15771.084 + 1,618.60 x]
INTERPRETATION
The trend analysis shows that there was an increase in net profit from the year 2020- 2021. This shows that the company is
in a good position. The maximum trend value is 19008.28. And it shows least trend value as 15771.084 in the year 2021.
6. FINDINGS
The amount of money collected against the receivables was high in the year2019-2020 and the amount
paid to the creditors was high in the year 2017- 2018.
The percentage of outstanding debtors was high in the year 2017-2018. But in the nextyear this
percentage has been decreased at negative percentage.
There was decreasing trend in percentage of bad debts losses from the year2018-2019 to 2020-2021.
The debtor turnover ratio of the firm was decreased from the year 2016-2017to 2018-2019.
The least collection period was 11 days during the year 2017-2018 which impliedthe better quality
of receivables.
The ratio of receivables to working capital is very low in the year 2020-2021. It showsthat the concern
utilized its working capital for necessary needs.
The ratio of receivables to current assets has shown an increase from 2016- 2017 to 2017-2018.
The annual sales marked a higher growth rate of 121.73 % in the year 2019-2020.The cash position
ratio has increased from 2016-2017 to 2018-2019.
The highest percentage is 24.47 in the year 2020-2021. It shows the company is notgoing with good
return.
There is increasing net profit ratio from 2016-2017 to 2018-2019.The return on total assets ratio was in
increasing trend
There is fluctuating trend in creditors turnover ratio during the study period
The average payment period is fluctuating. And it has increased to 410.11 inthe year2020-2021.
There is increasing trend during the study period in current ratio. It hasincreased from the year 2016-
2017 to 2019-2020.
Quick ratio has increased from 2014-2017 to 2017-2018. It has decreased from2017-2018 to 2018-2019.
REFERENCES
Khan M.Y& Jain P.K (1992),Financial Management, Tata McGrew Hill publishingcompany Limited, New
Delhi,Second edition, 1992.
Shashi K.Gupta & Sharma R.K (2000), Financial management – Theory and practice,Kalyani publishers,
New Delhi, Third revised and enlarged edition, 2000. Prassannachandra (1994), Financial Management –
Theory and practice, TataMcGrew Hill publishing company Limited, New Delhi, third edition, 1994.
Dr.Maheshwari S.N (1993), Financial Management – principles and practice,
Sultanchand and sons, New Delhi, third revised and enlarged edition, 1993. Kulkarni.P & Satya Prasad B.G
(1999), Financial management, Himalaya house,Mumbai, 19th revised edition,1999.
Kothari.C.R (1999), Research Methodology, Wishwa prakash Publishers, NewDelhi,second edition, 1999.
Pillai.R.S.N(1999), statistics, S.chand and company Ltd., New Delhi, firstedition,1999.
JOURNALS
Grzegorz M, M (2008) Profit Management Approach in Accounts Receivable Management, Southeast
European Economic and Business Journal, Vol. 3, No2, PP. 89-96.
Vadakarai (2007), “Research on Management Variables of Accounts Receivable and Plant and
Machinery Investment”, Journal of International Studies, Journal of Social Science and Management, vol.
1, no. 7.
JanPJankiRamadu and S Durga Rao (2007), "Management of money owed receivable in industrial vehicles
in India", IUP Applied Finance.