I think something is off with my rate of return on assets for cocacola and times interest earned ratio. I think I may be making an excel error but want to make sure I am pulling from the right numbers to double check ### Financial Ratios for Pepsi-Co, Inc. and The Coca-Cola Company#### **Pepsi-Co, Inc. Financial Data (for years ended December 31)**- **Acid-test ratio (CA-inventory-prepaid)/CL** - 2020: 0.77 - 2019: 0.66 - 2018: 0.82- **Current ratio** - 2020: 0.98 - 2019: 0.86 - 2018: 0.99- **Debt ratio** - 2020: 0.85 - 2019: 0.81 - 2018: 0.81- **Earnings per share** - 2020: 5.14 - 2019: 5.23 - 2018: 8.84- **Inventory turnover** - 2020: 8.47 - 2019: 9.32 - 2018: 9.39- **Net income ($ in millions)** - 2020: $7,120 - 2019: $7,314 - 2018: $12,515- **Rate of return on assets** - 2020: 10.97% - 2019: 13.05% - 2018: 13.40%- **Receivables turnover** - 2020: 8.67 - 2019: 8.98 - 2018: 9.05- **Return on assets** - 2020: 9.34% - 2019: 10.31% - 2018: 17.69%- **Operating income percentage** - 2020: 14.32% - 2019: 15.32% - 2018: 15.64%- **Revenues ($ in millions)** - 2020: $70,372 - 2019: $67,161 - 2018: $64,661- **Times interest earned ratio** - 2020: 9.04 - **Transcription and Explanation of Financial Data****Balance Sheet Information (Left Side)**1. **Current Assets:** - Cash and cash equivalents: $6,795M (2020), $6,480M (2019), $8,917M (2018) - Short-term investments: $1,671M (2020), $1,247M (2019), $1,001M (2018) - Total cash, cash equivalents, and short-term investments: $8,466M (2020), $7,727M (2019), $9,918M (2018) - Marketable securities: $114M (2020), $112M (2019), $231M (2018) - Trade accounts receivable: $3,146M (2020), $3,373M (2019), $3,259M (2018) - Inventories: $2,124M (2020), $2,001M (2019), $1,877M (2018) - Prepaid expenses and other assets: $1,390M (2020), $1,298M (2019), $1,645M (2018) - **Total Current Assets:** $19,240M (2020), $20,411M (2019), $24,930M (2018)2. **Non-Current Assets:** - Equity method investments: $19,273M (2020), $19,895M (2019), $19,412M (2018) - Other investments: $574M (2020), $605M (2019), $572M (2018) - Deferred tax assets, net: $1,834M (2020), $2,076M (2019), $1,848M (2018) - Property, plant, and equipment, net: $10,770M (2020), $10,934M (2019), $9,682M (2018) - Trademarks with indefinite lives: $10,975M (2020), $10,982M (2019), $8,731M (2018) - Bottlers’ franchise rights with indefinite lives: $11,169M (2020), $11,004M (2019

Ratio Analysis The purpose preparing the ratio analysis is to measure the total strength and…

I think something is off with my rate of return on assets for cocacola and times interest earned ratio. I think I may be making an excel error but want to make sure I am pulling from the right numbers to double check

I think something is off with my rate of return on assets for cocacola and times interest earned ratio. I think I may be making an excel error but want to make sure I am pulling from the right numbers to double check

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

1. Which of the following statements are true?a. The value of any investment is based on the cash flows it is expected to generate in the future.b. Investors are not generally risk averse.c. Uncertain cash flows are preferred to certain cash flows.d. All of the above are true.e. None of the above are true. 2. A basic knowledge of finance will help you with your personal investments by helping you understanda. how to accurately predict changes in the short-term interest rates.b. how to determine the optimal dividend policy for each firm.c. how to determine which technology is most likely to be accepted by consumers.d. how to review companies and industries to determine their prospects for future growth and therisk inherent in those companies and industries.e. how to predict the growth in sales for the firm. 3. Which of the following events would make it more likely that a company would choose to call itsoutstanding callable bonds?a.A reduction in market interest rates.b.The company's…
All of the following are purposes of internal risk rating systems except: Group of answer choices D. Pricing and trading of loans. B. Setting of limits and acceptance or rejection of new transactions. C. Inadequacy of loan reserves. A. Monitoring of credit quality.
Analyzing multiple financial ratios at one point in time is a good way to get a broad sense of a business's health, but looking at changes in ratios over time can be misleading because ratios are not designed to be used in this way. O True O False QUESTION 12 If two investments have the same initial cost and economic life, the SRR will be higher for the investment with higher total net return. O True False
Subject:- Accouning
QuickBank has decided to lower the interest rate it charges on business loans in order to attract more business. It has succeeded in boosting the number of loan applications, but it finds that many of the applicants turn out to be very poor credit risks. This illustrates the problem known as adverse selection moral hazard the principal-agent porblem diversification
Give your thoughts on the prompts below Firms use market capitalization when considering the market value added. We have seen that a number of things can affect capitalization values, so is this really the best method to use? A well known company recently had a 20-1 stock split that drew a lot of attention...how does this affect their market value added? Administrative errors can have a big impact in receivables turnover and payment delay ratios, so companies should include administrative and other indirect costs in the calculations of those ratios. Agree or Disagree and defend your answer.
Thank you. It's all done.