Question
Analyzing Accounts Receivable Lupin Pharmaceuticals, an Indian transnational pharmaceutical company, develops and markets a wide portfolio of branded and generic products. The company reported the
Analyzing Accounts Receivable Lupin Pharmaceuticals, an Indian transnational pharmaceutical company, develops and markets a wide portfolio of branded and generic products. The company reported the following in its 2018 annual report.
INR millions | 2018 | 2017 | 2016 |
---|---|---|---|
Trade receivables | $52,229.0 | $43,391.8 | $45,946.3 |
Less provision for doubtful receivables | 306.9 | 318.4 | 448.2 |
Trade receivables, net | $51,922.1 | $43,073.4 | $45,498.1 |
Total assets | $140,958 | $146,544 | $127,375 |
Revenue from operations | 158,042 | 174,943 | 142,555 |
Required a. Calculate days sale outstanding (DSO) for 2018 and 2017. Note: Round amount (your final answer) to one decimal place (for example, enter 6.8 for 6.77555).
DSO for 2018 | Answer | days |
DSO for 2017 | Answer | days |
b. Determine the total amount that customers owe Lupin each year. Note: Round dollar amount (your final answer) to one decimal place (for example, enter 6.8 for 6.77555).
Amount owed in 2018 | Answer |
Amount owed in 2017 | Answer |
Amount owed in 2016 | Answer |
c. What proportion of trade receivables is doubtful each year? Note: Round percentage (your final answer) to two decimal places (for example, enter 0.66% for 0.6555%).
2018: Proportion of AR that is doubtful | Answer |
2017: Proportion of AR that is doubtful | Answer |
2016: Proportion of AR that is doubtful | Answer |
d. From this ratio, what do we conclude about the quality of its trade receivables over time? We can conclude that the quality of receivables has increased, decreased or remained flat over time.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started