Question
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
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 | $47,528.4 | $39,486.5 | $41,811.1 |
Less provision for doubtful receivables | 306.9 | 318.4 | 448.2 |
Trade receivables, net | $47,221.5 | $39,168.1 | $41,362.9 |
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 | days | |
DSO for 2017 | 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 | |
Amount owed in 2017 | |
Amount owed in 2016 |
c. What proportion of trade receivables is doubtful each year?
Note: Round the percentage (your final answer) to two decimal places (for example, enter 0.66% for 0.6555%).
2018: Proportion of AR that is doubtful | |
2017: Proportion of AR that is doubtful | |
2016: Proportion of AR that is doubtful |
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/ remained flat
over time.
Step by Step Solution
3.41 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
Solution a Days Sales Outstanding DSO is calculated by dividing Trade Receivables by Average Daily Sales DSO for 2018 Trade Receivables INR 475284 million Revenue from Operations for 2018 INR 158042 m...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