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 | $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 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/ deeased/ 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