0001 Show Me How Ofice 365 Calculator Current position analysis PepsiCo, Inc. (PEP), the parent company of Frito Lay rock foods and Pepsi beverages, had the following current assets and current abates at the end of two recent years Current Year Previous Year (in millions) (In mitions) Cash and cash equivalent $12,969 $2,200 Short-term investments, al cost 6,253 3,562 Accounts and notes receivable, net 5,000 6,746 Inventaries 3,440 3,433 Propaid expenses and other current sets 1,616 1,777 Short-term bogations 7,170 3,767 Accounts payable 12,493 This information has been collected in the Microsoft Excel Online Open the spreadsheet, perform the required analysis, and input your answers in the Question below Determine the contrats for both pars Round your answers to one dedim Current Year Previous Year Previous Next Calculator Show me how Ofice 365 Baod Accounts and notes receivable, net 6,089 6,746 Inventories 3,440 3,435 Prepeld expenses and other current assets 1,616 1.777 Short-term obligations 7,176 3,767 Accounts payable 14,829 12,497 This information has been collected in the Microsoft Excel Online Mle. Open the sprendshot, perform the required analysis, and input your answers in the questions below Open spreadsheet a. Determine the (1) current ratio and (2) quick rate for both years. Round your answers to one decimal place. Current Year Previous Year 1. Current ratio 2. Quick ratio b. They of Pepco has PepsiCo is a med by the current and quick ratios nos some over this time period. The current ratio has and the quick ratio has company with resources for meeting short-term obligations. Its quidity as during this period Previous