Pepsico, Inc., 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 Previous Year (in millions) (in millions) Cash and cash equivalents $7,706 $5,462 Short-term investments, at cost 320 364 Accounts and notes receivable, net 6,785 6,655 Inventories 3,749 4,007 Prepaid expenses and other current assets 1,563 2,233 Short-term obligations 4,823 6,269 Accounts payable 12,296 12,071 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 A. 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 2. Quick ratio B. The liquidity of PepsiCo has * some over this time period. The current ratio has - resources for meeting short-term obligations. Its liquidity as measured by the current and quick ratios has * and the quick ratio has . Pepsico is a company with * during this period.

Pepsico, Inc., 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 Previous Year (in millions) (in millions) Cash and cash equivalents $7,706 $5,462 Short-term investments, at cost 320 364 Accounts and notes receivable, net 6,785 6,655 Inventories 3,749 4,007 Prepaid expenses and other current assets 1,563 2,233 Short-term obligations 4,823 6,269 Accounts payable 12,296 12,071 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 A. 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 2. Quick ratio B. The liquidity of PepsiCo has * some over this time period. The current ratio has - resources for meeting short-term obligations. Its liquidity as measured by the current and quick ratios has * and the quick ratio has . Pepsico is a company with * during this period.

Name: Pepsico, Inc., the parent company of Frito-Lay snack foods and Pepsi
Uploaded: 2022-11-18T00:26:54.000Z
Channel: Bartleby
Description: Pepsico, Inc., 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 Previous Year(in millions)(in millions)Cash and cash equivalents$7,7

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...

See similar textbooks

Similar questions

Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Refer to the information for Juroe Company on the previous page. Also, assume that Juroes total assets at the beginning of last year equaled 17,350,000 and that the tax rate applicable to Juroe is 40%. Required: Note: Round answers to two decimal places. 1. Calculate the average total assets. 2. Calculate the return on assets.
The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. You have been asked to prepare a statement of cash flows for Prime Sports Gear for 2013. Review the worksheet called CASHFLOW that has been provided to assist you in preparing the statement. The worksheet has been designed so that as you make entries in columns D and F, column G will be automatically updated. For example, FORMULA1 should be entered as =B17+D17F17. Columns C and E are to be used to enter letter references for each of the debit and credit entries on the worksheet.
The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. Open the file CASHFLOW from the website for this book at cengagebrain.com. First, enter the formulas. Then, complete the worksheet in the manner described next. According to the problem, cash increased from 39,600 to 67,210 during the year. This is a 27,610 increase. To record this increase on the worksheet, move to row 17. Since this is the first account you are analyzing, enter the letter a in column C. Then enter 27610 in column D (a debit since cash increased). This brings the year-end balance (column G) to 67,210, its proper balance. Now move to the bottom part of the statement where you see the categories Operating Activities, Investing Activities, and so on. The credit side of the entry has to be entered here. The proper space for this cash entry is on row 59. Enter the letter a in cell E59 and 27610 in cell F59. Notice the totals at the bottom of the page (row 60) now agree. The next account balance that changed is accounts receivable. It increased by 9,035. To enter this change on the worksheet, enter the letter b in cell C18 and 9035 in cell D18 (again, a debit since accounts receivable increased). This brings the year-end balance in column G to 121,250, its proper balance. The change in accounts receivable balance is an operating activity adjustment (as explained in your textbook). Enter the credit side of this entry in cells E34 and F34, and enter the explanation Increase in accounts receivable in cell A34. Note: Your textbook probably shows Net income as the first item under Operating Activities. We will get to that later. The sequence in which you enter items on this worksheet is not important. All other balance sheet accounts must be analyzed in the same manner, placing appropriate debit or credit entries in the top part of the worksheet to obtain the proper balances in column G, and then entering the second side of the entry in the appropriate row on the bottom part of the worksheet. You should use letter references to identify all entries. Also, you must enter a description of the entry in column A under the appropriate activity category. Although a sequence of analyzing the balance sheet from top to bottom is suggested here, this order is not necessary. As mentioned earlier, your textbook may specify a different sequence. Also, note that some accounts may have both debit and credit adjustments to them. The worksheet is not a substitute for a statement of cash flows, but it does provide you with all the numbers you need to properly prepare one. You will be done with your analysis when: a. The individual account balances at December 31, 2013, as shown on the worksheet (column G) equal those shown in the given problem data. b. The transaction column totals are equal (cells D60 and F60). c. The sum of the operating, investing, and financing activities (cell G59) equals the change in cash (cell D59 or F59). When you are finished, enter your name in cell A1. Save your completed file as CASHFLOW2. Print the worksheet when done. Also print your formulas. Check figure: Total credits at 12/31/2013 (cell G31), 860,460.
PepsiCo, Inc., the parent company of Frito-Lay snack foods and Pepsi beverages, had thefollowing current assets and current liabilities at the end of two recent years: Current Year Previous Year (in millions) (in millions)Cash and cash equivalents $ 6,297 $ 4,067Short-term investments, at cost 322 358Accounts and notes receivable, net 7,041 6,912Inventories 3,581 3,827Prepaid expenses and other current assets 1,479 2,277Short-term obligations 4,815 6,205Accounts payable 12,274 11,949a. Determine the (1)…
Sherwood, Inc., the parent company of Frito-Lay snack foods and Sherwood beverages, had the following current assets and current liabilities at the end of two recent years: Line Item Description Current Year(in millions) Previous Year(in millions) Cash and cash equivalents $4,611 $4,986 Short-term investments, at cost 3,275 9,259 Accounts and notes receivable, net 10,411 9,497 Inventories 1,445 963 Prepaid expenses and other current assets 481 356 Short-term obligations 385 4,089 Accounts payable 9,245 9,101 a. Determine the (1) current ratio and (2) quick ratio for both years. Round your answers to one decimal place. Line Item Description Current Year Previous Year 1. Current ratio ? ? 2. Quick ratio ? ? slightly over this time period. Both the current and quick ratios have fill in the blank 2 of 4 . Sherwood is a fill in the blank 3 of 4 company with fill in the blank 4 of 4 resources…
Sherwood, Inc., the parent company of Frito-Lay snack foods and Sherwood 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 $3,155 $3,047 Short-term investments, at cost 2,241 5,659 Accounts and notes receivable, net 7,123 5,803 Inventories 1,445 1,926 Prepaid expenses and other current assets 481 712 Short-term obligations 385 4,089 Accounts payable 9,245 9,101 a. Determine the (1) current ratio and (2) quick ratio for both years. Round to one decimal place. Current Year Previous Year 1. Current ratio 2. Quick ratio
PepsiCo, Inc., 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 $8,721 $10,610 Short-term investments, at cost 272 8,900 Accounts and notes receivable, net 7,142 7,024 Inventories 3,128 2,947 Prepaid expenses and other current assets 2,630 1,546 Accounts payable 18,112 15,017 Other short-term liabilities 4,026 5,485 a. Determine the (1) current ratio and (2) quick ratio for both years. Round answers to one decimal place. Current Year Previous Year 1. Current ratio fill in the blank 1 fill in the blank 2 2. Quick ratio fill in the blank 3 fill in the blank 4 b. The liquidity of PepsiCo has over this time period. The current ratio has and the quick ratio has .
epsiCo, 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 $21,243 $10,202 Short-term investments, at cost 8,540 5,297 Accounts and notes receivable, net 6,361 6,644 Inventories 2,814 2,801 Prepaid expenses and other current assets 1,602 1,863 Short-term obligations 6,613 3,718 Accounts payable 13,667 12,334 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 2. Quick ratio
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…
Sherwood, Inc., had the following current assets and current liabilities at the end of two recent years: Year 2(in millions) Year 1(in millions) Cash and cash equivalents $4,165 $4,528 Short-term investments, at cost 2,958 8,408 Accounts and notes receivable, net 9,404 8,624 Inventories 1,771 787 Prepaid expenses and other current assets 590 291 Short-term obligations (liabilities) 315 3,342 Accounts payable and other current liabilities 7,453 6,813 a. Determine the (1) current ratio and (2) quick ratio for both years. Round to one decimal place. Year 2 Year 1 Current ratio fill in the blank 1 fill in the blank 2 Quick ratio fill in the blank 3 fill in the blank 4
PepsiCo, Inc. (PEP), the parent company of Frito-LayTM snack foods and Pepsi beverages, had the following current assets and current liabilities at the end of two recent years: Year 2(in millions) Year 1(in millions) Cash and cash equivalents $ 9,096 $ 6,134 Short-term investments, at cost 2,913 2,592 Accounts and notes receivable, net 6,437 6,651 Inventories 2,720 3,143 Prepaid expenses and other current assets 1,865 2,143 Short-term obligations (liabilities) 4,071 5,076 Accounts payable and other current liabilities 13,507 13,016 a. Determine the (1) current ratio and (2) quick ratio for both years. Round to one decimal place. Year 2 Year 1 Current ratio ???? ???? Quick ratio ???? ????
PepsiCo, Inc. (PEP), the parent company of Frito-LayTM snack foods and Pepsi beverages, had the following current assets and current liabilities at the end of two recent years: Year 2(in millions) Year 1(in millions) Cash and cash equivalents $ 9,096 $ 6,134 Short-term investments, at cost 2,913 2,592 Accounts and notes receivable, net 6,437 6,651 Inventories 2,720 3,143 Prepaid expenses and other current assets 1,865 2,143 Short-term obligations (liabilities) 4,071 5,076 Accounts payable and other current liabilities 13,507 13,016 a. Determine the (1) current ratio and (2) quick ratio for both years. Round to one decimal place. Year 2 Year 1 Current ratio fill in the blank 1 fill in the blank 2 Quick ratio fill in the blank 3 fill in the blank 4 b. What conclusion can be drawn from these data?