Coca-Cola and PepsiCo are two of the largest and most successful beverage companies in the world in terms of the products that they sell and their receivables management practices. To evaluate their ability to collect on credit sales, consider the following information reported in their 2008, 2007, and 2006 annual reports (amounts in millions).

Coca-Cola and PepsiCo are two of the largest and most successful beverage companies in the world in terms of the products that they sell and their receivables management practices. To evaluate their ability to collect on credit sales, consider the following information reported in their 2008, 2007, and 2006 annual reports (amounts in millions).

 

	Coca-Cola			PepsiCo
Fiscal Year Ended:	2008	2007	2006	2008	2007	2006
Net Sales	$ 51,444	$ 47,857	$ 25,988	$ 52,751	$ 47,074	$ 37,037
Accounts Receivable	3,331	3,578	2,840	3,974	3,860	3,337
Allowance for Doubtful Accounts	74	75	82	89	88	83
Accounts Receivable, Net of Allowance	3,257	3,503	2,758	3,885	3,772	3,254

Requirement 1:

Calculate the receivables turnover ratios and days to collect for Coca-Cola and PepsiCo for 2008 and 2007. (Consider a 365 days a year. Round your answers to 1 decimal place.)

 

2008	Coca-Cola		PepsiCo
Receivables Turnover Ratio
Days to collect		days		days

2007	Coca-Cola		PepsiCo
Receivables Turnover Ratio
Days to collect		days		days

Requirement 2:

Which of the companies is quicker to convert its receivables into cash?

Coca-Cola

 

Explanation:  

Coca-Cola

2008

		Net sales		$ 51,444
Receivables Turnover  Ratio	=		=		=	15.2
		Average net receivables		($ 3,257 + $3,503)/2

		365		365
Days to collect	=		=		=	24 days
		Receivables Turnover		15.2

2007

		Net sales		$ 47,857
Receivables Turnover  Ratio	=		=		=	15.3
		Average net receivables		($ 3,503 + $2,758)/2

		365		365
Days to collect	=		=		=	23.9 days
		Receivables Turnover		15.3

PepsiCo

2008

		Net sales		$ 52,751
Receivables Turnover  Ratio	=		=		=	13.8
		Average net receivables		($ 3,885 + $3,772)/2

		365		365
Days to collect	=		=		=	26.4 days
		Receivables Turnover		13.8

PepsiCo

2007

		Net sales		$ 47,074
Receivables Turnover  Ratio	=		=		=	13.4
		Average net receivables		($ 3,772 + $3,254)/2

		365		365
Days to collect	=		=		=	27.2 days
		Receivables Turnover		13.4