In: Finance
Based on the Annual Report for 2015-2018 for Disney and Netflix: Answer the following:
2. Accounts Receivable Management
• Who takes longer to collect AR (Days Sales Outstanding
ratio)?
• What are their respective 3-year trends for DSO?
• What options could the company consider to improve DSO?
Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. All financials are in $ Billion.
Linkage | 2015 | 2016 | 2017 | 2018 | Source | |
Disney | ||||||
Revenues | A | 52.00 | 55.37 | 54.94 | 59.47 | https://www.marketwatch.com/investing/stock/dis/financials |
Account Receivables | B | 8.02 | 9.07 | 8.63 | 9.33 | https://www.marketwatch.com/investing/stock/dis/financials/balance-sheet |
Average receivables | C = average of successive Bs | 8.55 | 8.85 | 8.98 | ||
Days sales Outstanding | D = C / A x 365 | 56.33 | 58.80 | 55.12 | ||
Netflix | ||||||
Revenues | A | 6.78 | 8.83 | 11.69 | 15.79 | https://www.marketwatch.com/investing/stock/nflx/financials |
Account Receivables | B | - | - | - | - | https://www.marketwatch.com/investing/stock/nflx/financials/balance-sheet |
Average receivables | C = average of successive Bs | - | - | - | ||
Days sales Outstanding | D = C / A x 365 | - | - | - |
• Who takes longer to collect AR (Days Sales Outstanding ratio)?
Netflix doesn't have any receivables. It's receivables is zero. Hence, the comparison cant be made. But for the sake of completion, Disney takes longer in comparison to Netflix, to collect AR.
• What are their respective 3-year trends for DSO?
For Disney, the figure is very stable and is in the range of 55 - 60 days. It has gone up marginally in 2017 but then declined in 2018
For Netflix, no such trend could be studied as it has zero receivables.
• What options could the company consider to improve DSO?
In order to improve the DSO, the company could consider the following: