Previous Year (in millions) $12,063 3,328 7,071 2,498 1,839 3,858 15,038 12,800 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. Cash and cash equivalents Short-term investments, at cost Accounts and notes receivable, net Inventories Prepaid expenses and other current assets Short-term obligations Accounts payable Open spreadsheet a. Determine the (1) current ratio and (2) quick ratio for both years. Round your answers to one decimal place. 1. Current ratio 2. Quick ratio b. The liquidity of PepsiCo has Current Year Current Year (in millions) $25,397 8,274 6,424 2,512 1,577 7,277 PepsiCo is a j by the current and quick ratios has Previous Year some over this time period. The current ratio has company with during this period. and the quick ratio has resources for meeting short-term obligations. Its liquidity as measured.

Previous Year (in millions) $12,063 3,328 7,071 2,498 1,839 3,858 15,038 12,800 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. Cash and cash equivalents Short-term investments, at cost Accounts and notes receivable, net Inventories Prepaid expenses and other current assets Short-term obligations Accounts payable Open spreadsheet a. Determine the (1) current ratio and (2) quick ratio for both years. Round your answers to one decimal place. 1. Current ratio 2. Quick ratio b. The liquidity of PepsiCo has Current Year Current Year (in millions) $25,397 8,274 6,424 2,512 1,577 7,277 PepsiCo is a j by the current and quick ratios has Previous Year some over this time period. The current ratio has company with during this period. and the quick ratio has resources for meeting short-term obligations. Its liquidity as measured.

Financial Accounting Intro Concepts Meth/Uses

14th Edition

ISBN:9781285595047

Author:Weil

Publisher:Weil

Chapter16: Statement Of Cash Flows: Another Look

Section: Chapter Questions

Problem 18P

See similar textbooks

Similar questions

PreviousBalance AnnualPercentageRate (APR)(as a %) MonthlyPeriodicRate FinanceCharge(in $) Purchasesand CashAdvances PaymentsandCredits NewBalance(in $) $2,490.00 % 1 1 4 % $ $1,374.98 $300.00 $
Days' cash on handFinancial statement data for years ending December 31 for NewtonCompany follow: 20Y9 20Y8 Cash (end of year)Short-term investments (end of year)Operating expensesDepreciation expense $25,5008,27060,13513,225 $24,2509.46063,78011,400 Determine the days' cash on hand for 20Y8 and 2019. Round allcalculations to one decimal place.
. Estimate the duration of Deposit NBank Balance SheetCash = $ 50Loan M (7%, 6 years) = $200Deposit N (3 years, 2%) = $ 200Equity = $ 50Total Assets = $250Total Liabilities = $ 250 a.1.94 b. 2.94 c. 3.94 d. 4.94
The company Alumnos Emprendedores S.A. has an investment for a total amountof $175,800.00, and annual net cash flows of $52,050.00, calculate the periodof recovery, detail your result in years, months and days
What is the Net Present Value of the following cash flow stream? Year Cash Flow 0 -$1,977 1 $421 2 $889 3 $517 4 $939 Assume an interest rate of 3%
. Following information is available in respect of A LtdParticulars As on 31.3.2019(Rupees. In Lacs)As on 31.3.2020(Rupees. In Lacs)Investment in FinancialAssets- 100Equity Share Capital 150 160Long term Loans taken 100 200Dividend paid - 26Dividend received - 10Interest received - 15a. Prepare the cash flow from financing activities from the above information and givereasons for each element whether these elements belongs to financing activities or not b. Calculate the relationship between the debt and equity for the year 2019 and 2020, andcomment
Charles Wilson Company sells 8% bonds having a maturity value of $1,910,000 for $1,765,190.00. The bonds are dated January 1, 2025, and mature January 1, 2030. Interest is payable annually on January 1. Click here to view factor tables.
Compound Interest Table Complete the following schedule for investments a through f by indicating the relevant factor from the present value or future value table and the final present or future value amount. Investment Compounding a. Annuity b. Annuity Annually Semiannually Semiannually Annually c. Annuity d. Single Payment e. Single Payment Semiannually f. Single Payment Semiannually Factor Answer $ a. $ Annual Interest Rate Amount 5% $2,000 4% 1,000 6% 14,000 •Note: Round your answers to the nearest whole dollar. •Note: Do not use a negative sign (-) with your answers. b. 5% 9,000 6% 16,000 4% 9,600 $ C. Investment $ Period d. $ Payment at Beg. or End e. of Period 2 years End 3 years Beginning 4 years Beginning 6 years n/a 5 years n/a 4 years n/a $ f. Future Value or Present Value Future Present Future Present Future Present
Consider a cash flow and interest profile as shown: The worth at the end of Year 3 of these cash flows is: a. $5,000.00 b. $5,504.72 c. $5,994.56 d. $5,440.00
How much net cash did the entity receive (give) with regards to the premium transactions for the yeargiven below? (if net cash outflow, put a negative (-) sign before the numerical figure.A. December 31, 2020B. December 31, 2021
Compute the annual dollar changes and percent changes for each of the following accounts. (Decreases should be indicated with a minus sign. Round percent change to one decimal place.) Current Year Prior Year Short-term investments $ 379,006 $ 237,965 Accounts receivable 101,137 105,306 Notes payable 0 92,802 Horizontal Analysis - Calculation of Percent Change Choose Numerator: / Choose Denominator: Percent Change = / Current Year Prior Year Dollar Change Percent Change Short-term investments $379,006 $237,965 % Accounts receivable 101,137 105,306 % Notes payable 0 92,802 %
From the following income statement and the balance sheets, prepare a funds-flow statement: The Income Statement for the year ended 31 December 2018 shows: Amount(2) Amount(2) 15,000.00 Profit before depreciation Less: Depreciation Taxation 5,000.00 5,000.00 Dividend Transfer to reserves Balance of profit and Loss(P/L)A/e The Balance Sheet as on 31 December, 2017 and 31 December, 2018 is as follows: | Liabilitios 500.00 3,500.00 14,000.00 1,000.00 As on As on Assets As on As on 31/12/2017 31/12/2018 31/12/2017 31/12/2018 Share capital Reserves Fixed Assets 40,000.00 42,000.00 15,000.00 18,5000.00 Current Assets: P&L A/e 1,000.00 Stodk 10,000.00 15,000.00 Secured Loans 9,000.00 14,000.00 Debtors 15,000.00 21,000.00 Current Liabilities and 18,500.00 19,000.00 provisions Total Cash 2,500.00 4,000.00 67,500.00 82,500.00 67.500.00 82,500.00