Paying users zone. Data is covered by hidden.

  • Get to Coca-Cola Co. for $19.99, or

  • get to whole website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc

Analysis of Bad Debts

Difficulty: Advanced

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.

Receivables Accounting Policy

Trade Accounts Receivable

Coca-Cola records trade accounts receivable at net realizable value. This value includes an appropriate allowance for estimated uncollectible accounts to reflect any loss anticipated on the trade accounts receivable balances and charged to the provision for doubtful accounts. Coca-Cola calculates this allowance based on the history of write-offs, the level of past-due accounts based on the contractual terms of the receivables, and the relationships with, and the economic status of, the bottling partners and customers. Coca-Cola believes the exposure to concentrations of credit risk is limited due to the diverse geographic areas covered by the operations.

A significant portion of Coca-Cola's net operating revenues and corresponding accounts receivable is derived from sales of the products in international markets. Coca-Cola also generates a significant portion of the net operating revenues by selling concentrates and syrups to bottlers in which Coca-Cola has a noncontrolling interest.

Source: Coca-Cola Co., Annual Report

Allowance for Doubtful Accounts Receivable

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Allowance for doubtful accounts hidden hidden hidden hidden hidden
Trade accounts receivable, gross hidden hidden hidden hidden hidden
Allowance as a percentage of trade accounts receivable, gross1 hidden% hidden% hidden% hidden% hidden%

Source: Based on data from Coca-Cola Co. Annual Reports

2017 Calculations

1 Allowance as a percentage of trade accounts receivable, gross = 100 × Allowance for doubtful accounts ÷ Trade accounts receivable, gross
= 100 × hidden ÷ hidden = hidden%

Ratio Description The company
Allowance as a percentage of trade accounts receivable, gross Allowance for doubtful accounts divided by the gross accounts receivable. Coca-Cola Co.'s allowance as a percentage of trade accounts receivable, gross increased from 2015 to 2016 and from 2016 to 2017.