Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PA8-5 (Static) Analyzing Allowance for Doubtful Accounts, Receivables Turnover Ratio, and Days to Collect [LO 8-4] Coca-Cola and PepsiCo are two of the largest and

PA8-5 (Static) Analyzing Allowance for Doubtful Accounts, Receivables Turnover Ratio, and Days to Collect [LO 8-4] 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 rounded amounts reported in their annual reports (amounts in millions). Fiscal Year Ended: Net Sales Accounts Receivable Allowance for Doubtful Accounts Accounts Receivable, Net of Allowance Required: 2018 $ 31,860 3,890 Coca-Cola 2017 $ 35,410 4,150 490 3,400 480 3,670 2016 $ 41,860 4,330 470 3,860 2018 $ 64,660 7,240 100 7,140 1. Calculate the receivables turnover ratios and days to collect for Coca-Cola and PepsiCo for 2018 and 2017. 2-a. Which of the companies was quicker to convert its receivables into cash in 2018? 2-b. Which of the companies was quicker to convert its receivables into cash in 2017? Complete this question by entering your answers in the tabs below. Req 1 Req 2A Req 2B PepsiCo 2017 $ 63,525 7,155 130 7,025 Calculate the receivables turnover ratios and days to collect for Coca-Cola and PepsiCo for 2018 and 2017. (Use 365 days in a year. Do not round intermediate calculations on Accounts Receivable Turnover Ratio. Round your final answers to 1 decimal place. Use final rounded answers from Accounts Receivable Turnover Ratio for Days to Collect ratio calculation.) 2018 2017 Coca-Cola PepsiCo Coca-Cola PepsiCo Receivables Turnover Ratio Days to collect < Req 1 Req 2A > 2016 $ 62,800 6,835 135 6,700 PA8-5 (Static) Analyzing Allowance for Doubtful Accounts, Receivables Turnover Ratio, and Days to Collect [LO 8-4] 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 rounded amounts reported in their annual reports (amounts in millions). 2016 130 $ 62,800 6,835 135 6,700 Fiscal Year Ended: Net Sales Accounts Receivable Allowance for Doubtful Accounts 2018 Coca-Cola 2017 $ 31,860 Accounts Receivable, Net of Allowance 3,890 490 3,400 $ 35,410 4,150 480 3,670 2016 $ 41,860 2018 4,330 470 $ 64,660 7,240 100 PepsiCo 2017 $ 63,525 7,155 3,860 7,140 7,025 Required: 1. Calculate the receivables turnover ratios and days to collect for Coca-Cola and PepsiCo for 2018 and 2017. 2-a. Which of the companies was quicker to convert its receivables into cash in 2018? 2-b. Which of the companies was quicker to convert its receivables into cash in 2017? Complete this question by entering your answers in the tabs below. Req 1 Req 2A Req 2B Which of the companies was quicker to convert its receivables into cash in 2018? PepsiCo Coca-Cola < Req 1 Req 2B > PA8-5 (Static) Analyzing Allowance for Doubtful Accounts, Receivables Turnover Ratio, and Days to Collect [LO 8-4] 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 rounded amounts reported in their annual reports (amounts in millions). Fiscal Year Ended: Net Sales Accounts Receivable Allowance for Doubtful Accounts Accounts Receivable, Net of Allowance Required: 2018 $ 31,860 3,890 490 Coca-Cola 2017 $ 35,410 4,150 480 2016 $ 41,860 4,330 470 3,400 3,670 3,860 2018 $ 64,660 7,240 100 7,140 1. Calculate the receivables turnover ratios and days to collect for Coca-Cola and PepsiCo for 2018 and 2017. 2-a. Which of the companies was quicker to convert its receivables into cash in 2018? 2-b. Which of the companies was quicker to convert its receivables into cash in 2017? Complete this question by entering your answers in the tabs below. Req 1 Req 2A Req 2B Which of the companies was quicker to convert its receivables into cash in 2017? PepsiCo Coca-Cola < Req 2A Req 2B > PepsiCo 2017 $ 63,525 7,155 130 2016 $ 62,800 6,835 135 7,025 6,700

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Information Analysis 2e

Authors: Philip ORegan

2nd Edition

0470865725, 978-0470865729

More Books

Students also viewed these Accounting questions

Question

=+1. Who is your key public?

Answered: 1 week ago

Question

=+4 Develop and deliver the CCT program.

Answered: 1 week ago