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.

Answer rating: 100% (QA)

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... View the full answer