### Required Information**Benchmark Assignment - Coca-Cola Co. & Pepsico Inc.**You will need to use the data below from the two companies to calculate problems and answer the following questions.| | **Coca-Cola Co. (in millions)** | **Pepsico Inc. (in millions)** ||------------------------------------------|--------------------------------|-------------------------------|| **Net Revenue (Sales)** | $38,655 | $79,474 || **Net Income** | $9,771 | $7,618 || **Current Assets** | $22,545 | $21,783 || **Current Liabilities** | $19,950 | $26,220 || **Cash & Cash Equivalents** | $12,625 | $5,988 || **Accounts (Trade) Receivables** | $3,512 | $8,680 || **Total Assets (12/31/21)** | $94,354 | $92,377 || **Total Assets (12/31/20)** | $87,296 | $92,918 || **Total Liabilities (12/31/21)** | $69,494 | $76,226 || **Total Liabilities (12/31/20)** | $64,258 | $76,034 || **Stockholders Equity (12/31/21)** | $23,000 | $16,043 || **Stockholders Equity (12/31/20)** | $19,300 | $13,454 |This table includes financial data for Coca-Cola Co. and Pepsico Inc. that compares several key metrics, including net revenue (sales), net income, current assets, current liabilities, cash and cash equivalents, accounts receivables, total assets, total liabilities, and stockholders' equity over two fiscal years (2020 and 2021).- **Net Revenue (Sales)**: Represents total revenue generated from sales before deducting any expenses.- **Net Income**: The profit of the company after all expenses and taxes have been deducted.- **Current Assets**: Assets that are likely to be converted into cash, sold, or consumed within a year.- **Current Liabilities**: Obligations or debts the ## ROI and ROE Calculation for Coca-Cola Co. and PepsiCo Inc.In this exercise, we will calculate the Return on Investment (ROI) for Coca-Cola Co. and PepsiCo Inc. using the DuPont model, which involves calculating the margin and turnover for each company. Subsequently, we will calculate the Return on Equity (ROE) for each company.### Table for Data Entry| | **Coca-Cola Co.** | **PepsiCo Inc.** ||----------------|-------------------|------------------|| **Margin (%)** | | || **Turnover** | | || **ROI (Margin × Turnover)** | | || **ROE** | | |**Instructions:**1. **Margin (%)**: Enter the profit margin for each company.2. **Turnover**: Enter the asset turnover for each company.3. **ROI**: Calculate the ROI for each company by multiplying the margin by the turnover.4. **ROE**: Calculate the ROE for each company based on the ROI and other relevant financial metrics of the company.**Explanation of Concepts:**- **Margin (%):** This refers to the net profit margin, which is calculated as (Net Income / Revenue) × 100. It indicates the percentage of revenue that is converted into profit.- **Turnover:** This refers to the asset turnover ratio, which is calculated as Revenue / Average Assets. It indicates how efficiently a company uses its assets to generate sales.- **ROI (Return on Investment):** This is calculated using the DuPont model as Margin × Turnover. It measures the efficiency of investment in generating profit.- **ROE (Return on Equity):** This is calculated as Net Income / Shareholder's Equity. It measures the profitability of a company in generating profit from shareholders' equity.Please complete the table by entering the appropriate values and performing the necessary calculations.

Formulas,Margin = (Net Income / Net Revenue) x 100Asset Turnover = Net Revenue / Average AssetsROI =…

Required Information Benchmark Assignment - Coca-Cola Co. & Pepsico Inc. You will need to use the data below from the two companies to calculate problems and answer the following questions: Coca-Cola Co. (In Pepsico Inc. (In Net Revenue (Sales) Net Income Current Assets Current Liabilities Cash & Cash Equivalents Accounts (Trade) Receivables Total Assets (12/31/21) Total Assets (12/31/20) Total Liabilities (12/31/21) Stockholders Equity (12/31/21) Stockholders Equity (12/31/20) millions) $38.655 $9,771 $22,545 $19.950 $12,625 $3.512 $94,354 $87,296 $69,494 $23,000 $19,300 millions) $79,474 $7,618 $21,783 $26,220 $5,988 $8,680 $92,377 $92,918 $76,226 $16,043 $13,454

Required Information Benchmark Assignment - Coca-Cola Co. & Pepsico Inc. You will need to use the data below from the two companies to calculate problems and answer the following questions: Coca-Cola Co. (In Pepsico Inc. (In Net Revenue (Sales) Net Income Current Assets Current Liabilities Cash & Cash Equivalents Accounts (Trade) Receivables Total Assets (12/31/21) Total Assets (12/31/20) Total Liabilities (12/31/21) Stockholders Equity (12/31/21) Stockholders Equity (12/31/20) millions) $38.655 $9,771 $22,545 $19.950 $12,625 $3.512 $94,354 $87,296 $69,494 $23,000 $19,300 millions) $79,474 $7,618 $21,783 $26,220 $5,988 $8,680 $92,377 $92,918 $76,226 $16,043 $13,454

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

Required: a. What is the ratio of real assets to total assets? (Hint: for this question, only include those listed under "Real assets") b. What is the ratio of real assets to total assets for nonfinancial firms in the following table? Assets Real assets Equipment and intellectual property Real estate Inventories Total real assets Financial assets Deposits and cash Marketable securities Required A $ Billion $ 8,345 14,423 2,724 $ 25,492 Required B $ 2,333 4,059 4,075 14,005 $ 24,472 $ 49,964 % Total 16.7% 28.9 5.5 51.0% 4.7% 8.1 8.2 28.0 49.0% 100.0% Liabilities and Net Worth Liabilities Debt securities Bank loans & mortgages Other loans Trade debt Other Total liabilities Complete this question by entering your answers in the tabs below. Net worth $ Billion Trade and consumer credit Other Total financial assets TOTAL Balance sheet of U.S. nonfinancial corporations Note: Column sums may differ from total because of rounding error. Source: Flow of Funds Accounts of the United States,…
Required information [The following information applies to the questions displayed below.] Consider the following balance sheet and income statement for Mmm Good Foods Incorporated (the company that operates Tasty Fried Chicken and Pizza Party), in condensed form, including some information from the cash flow statement: (amounts are millions) Balance Sheet Cash and short-term investments Accounts receivable Inventory Other current assets Long-lived assets Total assets Current liabilities Total liabilities Shareholders' equity Total liabilities and equity Income Statement Sales Cost of sales Gross margin Earnings before interest and taxes Interest Taxes Net income Share price Earnings per share Number of outstanding shares (millions) Cash Flows Cash flow from operations Capital expenditures Dividends Mmm Good Foods Incorporated 2019 2018 $743 623 $ 443 597 161 3,704 $ 5,231 $ 1,541 13, 247 (8,016) $ 5,231 $ 5,597 1,235 $ 4,362 $ 1,859 486 79 $ 1,294 $ 102 4.23 300 $ 1,315 196 511 167…
Calculate the following ratios all are required 1-Receivables Turnover 2-Inventory Turnover 3-Payables Turnover 4-Debt-Equity Ratio 5-Debt Ratio Balance sheet Group Parent Company 31 December 2018 31 March 2018 31 December 2018 31 March 2018 Notes RO RO RO RO ASSETS Non-current Property, plant and equipment 5 6,406,433 7,113,759 3,683,610 4,182,275 Investment in subsidiaries - - 515,750 515,750 Fixed deposit 9.1 1,048,399 - 1,048,399 - Deferred tax assets 27 675,393 537,722 727,632 602,078 Non-current assets 8,130,225 7,651,481 5,975,391 5,300,103 Current Inventories 6 4,481,209 3,832,010 4,450,529 3,651,720 Trade and other receivables 7 3,771,104 3,502,574 3,244,883 2,758,158 Due from related parties 18 - - 351,897 2,439,914 Financial assets at…
Evaluate and comment on businesses financial performance by calculating and analysing 2 profitability, liquidity and solvency ratios based on the information from financial statements Consider whether certain aspects (profitability, liquidity or solvency) can be improved and if so, how? (300 words)
Question Content Area Use the information provided for Harding Company to answer the question that follow. Harding Company Accounts payable $33,234 Accounts receivable 67,995 Accrued liabilities 6,510 Cash 22,738 Intangible assets 35,347 Inventory 83,390 Long-term investments 101,069 Long-term liabilities 79,156 Notes payable (short-term) 27,161 Property, plant, and equipment 689,074 Prepaid expenses 2,037 Temporary investments 30,842 Based on the data for Harding Company, what is the quick ratio (rounded to one decimal place)? a.3.1 b.0.8 c.1.8 d.15.4
Question Content Area The following information pertains to Tanzi Company. Assume that all balance sheet amounts represent both average and ending balance figures. Assume that all sales were on credit. Assets Cash and short-term investments $41,912 Accounts receivable (net) 29,707 Inventory 28,654 Property, plant and equipment 293,074 Total Assets $393,347 Liabilities and Stockholders' Equity Current liabilities $58,253 Long-term liabilities 97,633 Stockholders' equity-common 237,461 Total Liabilities and stockholders' equity $393,347 Income Statement Sales $80,900 Cost of goods sold 36,405 Gross margin $44,495 Operating expenses 25,209 Net income $19,286 Number of shares of common stock 6,546 Market price of common stock $35 What is the current ratio for this company? Round your answer to two decimal places. Select the correct answer. 1.23 2.22 0.72 1.72
oped Dok H Int 0 ence [The following information applies to the questions displayed below] Forten Company's current year Income statement, comparative balance sheets, and additional Information follow. For the year. (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of Inventory are on credit, and (4) all debits to Accounts Payable reflect Sens cash payments for Inventory. FORTEN COMPANY Income Statement For Current Year Ended December 31 Sales Cost of goods sold Gross profit Operating expenses (excluding depreciation) Depreciation expense Other gains (losses) Loss on sale of equipment Income before taxes Income taxes expense Net income Assets Cash FORTEN COMPANY Comparative Balance Sheets December 31 Accounts receivable Inventory Prepaid expenses Total current assets Equipment Accumulated depreciation-Equipment Total assets Liabilities and Equity Accounts payable Long-term notes payable Total liabilities…
Preparing an income statement) Prepare an income statement and a common-sized income statement from the following information. Click on the following icon in order to copy its contents into a spreadsheet.) Sales Cost of goods sold General and administrative expense Depreciation expense Interest expense Income taxes Complete the income statement below. (Round to the nearest dollar. NOTE: You may input expense acc as negative values.) Income Statement Gross profits Total operating expenses Operating income (EBIT) Earnings before taxes Net income $525,863 199,246 60,236 8,305 11,860 98,486 $ SS
The following is selected financial data from Block Industries. How much does Block Industries have in current liabilities? Cash Accounts receivable Equipment Prepaid expenses Accounts payable Unearned revenue Long-term notes payable Common stock Revenue Sales tax payable Interest expense Depreciation expense OOOO $1 $19,800 $25,800 $12,300 $20,000 13,400 10,650 5,000 12,300 7,500 10,000 18,000 11,700 6,000 4,500 1,000
Question Content Area The following information pertains to Diane Company. Assume that all balance sheet amounts represent both average and ending balance figures and that all sales were on credit. Use this information to answer the question that follow. Assets Cash and short-term investments $30,000 Accounts receivable (net) 20,000 Merchandise inventory 15,000 Property, plant, and equipment 185,000 Total assets $250,000 Liabilities and Stockholders' Equity Current liabilities $45,000 Long-term liabilities 70,000 Stockholders' equity—common 135,000 Total liabilities and stockholders' equity $250,000 Income Statement Sales $85,000 Cost of merchandise sold 45,000 Gross profit $40,000 Operating expenses (15,000) Interest expense (5,000) Net income $20,000 Number of shares of common stock outstanding 6,000 Market price per share of common stock $20 Total dividends paid $9,000 Net cash flows from operating…
Analysis above two financial statement, what you can observe without using financial ratio.
Required Information Use the following information for the Exercises below. (Algo) [The following information applies to the questions displayed below.] Simon Company's year-end balance sheets follow. At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity Current Year 1 Year Ago 2 Years Ago $ 29,387 58,429 $ 29,125 40,023 66,638 $ 23,920 69,328 88,056 7,860 224,536 $ 413,700 7,564 282,628 $ 356,638 81,206 162,500 54,468 $101,981 76,998 $ 58,464 162,500 72,221 $ 413,780 $ 356,638 For both the current year and one year ago, compute the following ratios: 43,855 3,236 184,761 $ 300,200 $ 38,438 64,354 162,580 34,988 $ 300,200 Exercise 17-6 (Algo) Common-size percents LO P2 1. Express the balance sheets in common-size percents. 2. Assuming annual sales have not changed in the last three…