Question

Making Business Decisions: Loaning Money to The Coca-Cola Company As chief lending officer for a bank,...

Making Business Decisions: Loaning Money to The Coca-Cola Company

As chief lending officer for a bank, you need to decide whether to make a loan to The Coca-Cola Company. The current items, listed in alphabetical order, are taken from the consolidated balance sheets of The Coca-Cola Company and its competitor PepsiCo at the end of 2015 and 2014 (included in the companies’ Form 10-Ks for the year ended December 31, 2015 for Coca-Cola and December 26, 2015 for PepsiCo; all amounts are in millions of dollars):

The Coca-Cola Company 12/31/15 12/31/14
Accounts payable and accrued expenses $9,660 $9,234
Accrued income taxes 331 400
Assets held for sale 3,900 679
Cash and cash equivalents 7,309 8,958
Current maturities of long-term debt 2,677 3,552
Inventories 2,902 3,100
Loans and notes payable 19,100 19,130
Liabilities held for sale 1,133 58
Marketable securities 4,269 3,665
Prepaid expenses and other assets 2,752 3,066
Short-term investments 8,322 9,052
Trade accounts receivable, less allowances
of $352 and $331, respectively
3,941 4,466
PepsiCo 12/26/15 12/27/14
Accounts and notes receivable, net $6,437 $6,651
Accounts payable and other current liabilities 13,507 13,016
Cash and cash equivalents 9,096 6,134
Inventories 2,720 3,143
Prepaid expenses and other current assets 1,865 2,143
Short-term investments 2,913 2,592
Short-term obligations 4,071 5,076

Required:

1. Compute working capital and the current ratio for both companies for 2015. Enter working capital amounts in millions of dollars. Round current ratio to two decimal places. If required, use the minus sign to indicate negative working capital.

Item Coca-Cola PepsiCo
Working capital $ $
Current ratio :1 :1

2. On the basis of your answers to (1), which company appears to be more liquid?

  • Both are equally liquid
  • PepsiCo
  • Neither are liquid
  • Coca-Cola

3. Which of these are measures of liquidity?

  • Current ratio and Debt equity ratio
  • Current ratio and Profitability ratio
  • Current ratio and Working capital
  • Debt equity ratio and Working cap

Homework Answers

Answer #1

Working Capital = Current Assets - Current Liabilities

Current Ratio = Current Assets/ Current Liabilities

Current Assets 3900+7309+2902+4269+2752+8322+3941 = 33,395 6437+9096+2720+1865+2913 = 23,031
Current Liabilities 9660+331+2677+19100+1133 = 32,901 13507+4071 = 17,578
Current Ratio 33395/32901 =       1.02 23031/17578 =       1.31
Working Capital 33395-32901 =        494 23031-17578 =     5,453
Company having higher Current Ratio is more liquid   Pepsi Co.
Measured of liquidity Current Ratio and working Capital
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Calculate the following leverage ratios for PepsiCo and Coca-Cola based on their 2018 balance sheet found...
Calculate the following leverage ratios for PepsiCo and Coca-Cola based on their 2018 balance sheet found on company website: Liabilities to Assets Ratio Liabilities to Shareholders' Equity Ratio Long-term Debt to Long-term Capital Ratio
Information from Gre Company's balance sheet follows Current Assets      Cash $2,100,000      Marketable Securities 7,200,000...
Information from Gre Company's balance sheet follows Current Assets      Cash $2,100,000      Marketable Securities 7,200,000      Accounts Receivable 50,500,000      Inventories 65,000,000      Prepaid expenses 1,000,000                Total current assets $125,800,000 Current Liabilities      Notes payable $1,400,000      Accounts payable 18,000,000      Accrued expenses 11,000,000      Income taxes payable 600,000      Current portion of long-term debt 3,000,000                Total current liabilities $34,000,000 What is the acid-test ratio for Greg Company? Select one: a. 1.60 b. 1.76 c. 2.20 d....
Coca-Cola Company Balance Sheet December 31 (Amounts in Millions) 2010 2009 Assets Current assets Cash and...
Coca-Cola Company Balance Sheet December 31 (Amounts in Millions) 2010 2009 Assets Current assets Cash and cash equivalent $ 11,199 $ 9,151 Marketable securities 138 62 Account receivable 4,430 3,758 Merchandise inventory 2,650 2,354 Other current assets 3,162 2,226 Non-current assets Long term investments 9,706 8,731 Property, Plant and equipment 14,727 9,561 Intangible assets 26,909 12,828 Total assets 72,921 48,671 Current liabilities Accounts payable and accrued liabilities $ 8,859 $ 6,657 Loans and notes payables 8,100 6,749 Other liabilities 1,549...
Current Position Analysis The following data were taken from the balance sheet of Bock Suppliers Company:...
Current Position Analysis The following data were taken from the balance sheet of Bock Suppliers Company: Current Year Previous Year Cash $359,100 $264,000 Temporary investments 415,800 297,000 Accounts and notes receivable (net) 170,100 99,000 Inventories 1,205,800 872,300 Prepaid expenses 621,200 557,700 Total current assets $2,772,000 $2,090,000 Accounts and notes payable (short-term) $365,400 $385,000 Accrued liabilities 264,600 165,000 Total current liabilities $630,000 $550,000 a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio....
The following data were taken from the balance sheet of Nilo Company at the end of...
The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets:   Cash $303,600 $229,600   Marketable securities 351,600 258,300   Accounts and notes receivable (net) 143,800 86,100   Inventories 868,600 650,300   Prepaid expenses 447,400 415,700   Total current assets $2,115,000 $1,640,000 Current liabilities:   Accounts and notes payable   (short-term) $272,600 $287,000   Accrued liabilities 197,400 123,000   Total current liabilities $470,000 $410,000 a. Determine for each year (1) the working capital, (2)...
The following data were taken from the balance sheet of Nilo Company at the end of...
The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets:   Cash $330,600 $260,000   Marketable securities 382,800 292,500   Accounts and notes receivable (net) 156,600 97,500   Inventories 957,000 701,500   Prepaid expenses 493,000 448,500   Total current assets $2,320,000 $1,800,000 Current liabilities:   Accounts and notes payable   (short-term) $336,400 $350,000   Accrued liabilities 243,600 150,000   Total current liabilities $580,000 $500,000 a. Determine for each year (1) the working capital, (2)...
Working Capital and Short-Term Firm Liquidity Ratios Favor Company has a current ratio of 2.08 (2.08:1)...
Working Capital and Short-Term Firm Liquidity Ratios Favor Company has a current ratio of 2.08 (2.08:1) on December 31. On that date its current assets are as follows: Cash and cash equivalents $28,000 Short-term investments 87,000 Accounts receivable (net) 125,000 Inventory 258,500 Prepaid expenses 9,980 Current assets $508,480 Favor Company's current liabilities at the beginning of the year were $192,000 and during the year its operating activities provided a cash flow of $38,830. a. What are the firm's current liabilities...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets:   Cash $483,400 $386,400   Marketable securities 559,700 434,700   Accounts and notes receivable (net) 228,900 144,900   Inventories 664,600 477,000   Prepaid expenses 342,400 305,000   Total current assets $2,279,000 $1,748,000 Current liabilities:   Accounts and notes payable   (short-term) $307,400 $322,000   Accrued liabilities 222,600 138,000   Total current liabilities $530,000 $460,000 a. Determine for each year (1) the...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets:   Cash $446,900 $361,200   Marketable securities 517,400 406,400   Accounts and notes receivable (net) 211,700 135,400   Inventories 161,700 104,900   Prepaid expenses 83,300 67,100   Total current assets $1,421,000 $1,075,000 Current liabilities:   Accounts and notes payable   (short-term) $284,200 $301,000   Accrued liabilities 205,800 129,000   Total current liabilities $490,000 $430,000 a. Determine for each year (1) the...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years: Current Year Previous Year Current assets:   Cash $335,200 $275,200   Marketable securities 388,100 309,600   Accounts and notes receivable (net) 158,700 103,200   Inventories 776,200 498,400   Prepaid expenses 399,800 318,600   Total current assets $2,058,000 $1,505,000 Current liabilities:   Accounts and notes payable   (short-term) $284,200 $301,000   Accrued liabilities 205,800 129,000   Total current liabilities $490,000 $430,000 a. Determine for each year (1) the...