Analysis of Bad Debts
Allowance for doubtful accounts receivable (bad debts) is a contra account which reduce the balance of the company’s gross accounts receivable. The relationship between the allowance and the balance in receivables should be relatively constant unless there is a change in the economy overall or a change in customer base.
Accounting Policy on Receivables
The receivables balances primarily include amounts due from clients, third-party payors, members and pharmaceutical manufacturers. Below is a description of Express Scripts’ receivables balances from clients, third-party payors and members. Based on Express Scripts’ revenue recognition policies, certain receivables are unbilled at the end of each period. As of December 31, 2017 and 2016, unbilled receivables were $676.3 million and $705.8 million, respectively. Unbilled receivables are typically billed to PBM clients within 30 days based on the contractual billing schedule agreed upon with the client. Unbilled receivables for medical benefit management services represent amounts due from clients at contracted rates, and are billed once settlement provisions for capitated risk contract terms are met, at least annually.
Express Scripts’ reserves for credit loss in receivables is the allowance for doubtful accounts of $95.3 million and $75.0 million for the years ended December 31, 2017 and 2016, respectively. This estimate is based on the current status of each customer’s receivable balance as well as current economic and market conditions. Express Scripts’ allowance for doubtful accounts also reflects amounts associated with member premiums for the Medicare Part D product offerings. Receivables are written off against the allowances only upon determination such amounts are not recoverable and all collection attempts have failed. Express Scripts regularly reviews and analyzes the adequacy of these allowances based on a variety of factors, including the age of the outstanding receivable and the collection history. When circumstances related to specific collection patterns change, estimates of the recoverability of receivables are adjusted.
As of December 31, 2017 and 2016, Express Scripts has contractual allowances of $206.2 million and $115.2 million, respectively, included in the contractual allowance for certain receivables from third-party payors based upon the payment terms specified in the related contractual agreements with payors. The estimated reimbursement amounts are calculated on a payor-specific basis based on the best information available regarding management’s interpretation of the contract terms and are recorded as a reduction of receivables and revenues at the time revenue is recognized. As of December 31, 2017 and 2016, Express Scripts also has customer credit allowances of $165.1 million and $199.6 million, respectively, which include discounts and claims adjustments issued to the customers in the form of client credits.
Gross receivables have been reduced by 11.1% and 8.5% at December 31, 2017 and 2016, respectively, related to Express Scripts’ allowance for doubtful accounts, contractual allowances for certain receivables from third-party payors, contractual allowances for discounts and claims adjustments issued to the customers in the form of client credits, and contractual allowances for certain rebates receivable with manufacturers.
Source: 10-K (filing date: 2018-02-27).
Allowance for Doubtful Accounts Receivable
|Dec 31, 2017||Dec 31, 2016||Dec 31, 2015||Dec 31, 2014||Dec 31, 2013|
|Selected Financial Data (US$ in thousands)|
|Allowance for doubtful accounts|
|Allowance as a percentage of receivables, gross1|
1 2017 Calculation
Allowance as a percentage of receivables, gross = 100 × Allowance for doubtful accounts ÷ Receivables, gross
= 100 × ÷ =
|Financial ratio||Description||The company|
|Allowance as a percentage of receivables, gross||Allowance for doubtful accounts divided by the gross accounts receivable.||Express Scripts Holding Co.’s allowance as a percentage of receivables, gross decreased from 2015 to 2016 but then increased from 2016 to 2017 exceeding 2015 level.|