PepsiCo, Inc. (PEP), the parent company of Frito-Lay snack foods and Pepsi beverages, had the following current assets and current liabilities at the end of two recent years: Current Year (in millions) Previous Year (in millions) Cash and cash equivalents $25,551 $9,216 Short-term investments, at cost 7,238 4,835 Accounts and notes receivable, net 7,097 7,405 Inventories 2,641 2,635 Prepaid expenses and other current assets 1,647 1,805 Short-term obligations 7,425 3,820 Accounts payable 15,345 12,674 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Determine the (1) current ratio and (2) quick ratio for both years. Round your answers to one decimal place. Current Year Previous Year 1. Current ratio fill in the blank 2 fill in the blank 3 2. Quick ratio fill in the blank 4 fill in the blank 5
PepsiCo, Inc. (PEP), the parent company of Frito-Lay snack foods and Pepsi beverages, had the following current assets and current liabilities at the end of two recent years: Current Year (in millions) Previous Year (in millions) Cash and cash equivalents $25,551 $9,216 Short-term investments, at cost 7,238 4,835 Accounts and notes receivable, net 7,097 7,405 Inventories 2,641 2,635 Prepaid expenses and other current assets 1,647 1,805 Short-term obligations 7,425 3,820 Accounts payable 15,345 12,674 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Determine the (1) current ratio and (2) quick ratio for both years. Round your answers to one decimal place. Current Year Previous Year 1. Current ratio fill in the blank 2 fill in the blank 3 2. Quick ratio fill in the blank 4 fill in the blank 5
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 52E: Juroe Company provided the following income statement for last year: Juroes balance sheet as of...
Related questions
Question
PepsiCo, Inc. (PEP), the parent company of Frito-Lay snack foods and Pepsi beverages, had the following current assets and current liabilities at the end of two recent years:
Current Year (in millions) |
Previous Year (in millions) |
|||
Cash and cash equivalents | $25,551 | $9,216 | ||
Short-term investments, at cost | 7,238 | 4,835 | ||
Accounts and notes receivable, net | 7,097 | 7,405 | ||
Inventories | 2,641 | 2,635 | ||
Prepaid expenses and other current assets | 1,647 | 1,805 | ||
Short-term obligations | 7,425 | 3,820 | ||
Accounts payable | 15,345 | 12,674 |
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
-
Determine the (1)
current ratio and (2) quick ratio for both years. Round your answers to one decimal place.Current Year Previous Year 1. Current ratio fill in the blank 2 fill in the blank 3 2. Quick ratio fill in the blank 4 fill in the blank 5
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning