Question: Look at the spreadsheet for Coca-Cola. (a) Does the ratio of excess cash marketable securities to total current assets make sense (compare 2003 to 2010)?

Look at the spreadsheet for Coca-Cola.
(a) Does the ratio of excess cash marketable securities to total current assets make sense (compare 2003 to 2010)?
(b) How would you change the model forecasts to make the ratio of excess cash and marketable securities to total current assets more reasonable?
(c) How would your proposal change affect the value of Coca-Cola?

Step by Step Solution

★★★★★

3.32 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a In 2003 excess cash is 4726830 69 of current assets and by 2010 it is 773617165 451 This does not ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

897-B-C-F-G-F (3250).docx

120 KBs Word File

Students Have Also Explored These Related Corporate Finance Questions!

The Coca-Cola Company is a global soft-drink beverage company that is a primary and direct competitor with PepsiCo. The data in Chapter 12 Exhibits 12.14-12.16 include the actual amounts for 2012 and...

The Coca-Cola Company is organized geographically and defines reportable operating segments as regions of the world. The following information was extracted from Note 19 Operating Segments in the...

The Coca-Cola Company is a global soft-drink beverage company that is a direct competitor with Starbucks. The data in Chapter 12, Exhibits 12.14 through 12.16 (pages 806-809), include the actual...

Hello, Need help with the following:Please see Rubric thks Using information from"Are You Paying Too Much for That Acquisition?" List and describe the components used to calculate synergy value....

I have no idea how to do this homework. I need some help. Verhovek Co. December 31, 2011 ACCT NO. ACCOUNT TITLE 12-31-2010 POST CLOSING TRIAL BALANCE DEBIT CREDIT 12-31-2011 UNADJUSTED TRIAL BALANCE...

Hello, I need help with my assignment. I have totally three questions to answer. The first question seems to be answered already in "item.docx". I really need help with Q2 and Q3, which are shown in...

Waren Sports Yearend Worksheet Introduction: Accountants use Excel to analyze transactions and accounts, prepare financial statements, calculate budgets, create invoices, and many more tasks....

Hello I have been having a problem with this excel assignment and I had posted it yesterday but I haven't get helped since please help me the excel details instruction is attacked SDSU Accounting...

How can an acquisition create value for the combined entitys shareholders but not for the acquirers shareholders?

Find (i) AB, (ii) BC, (iii) CA, (iv) A(BC), (v) (AB)C. 1 1 2 3 +-(: : :) - - ( A = ,B 3 4 5 6 7 M 7 14 1 4 2 1 3 6 C= bitioun 32 13 94 1 7

Required a ) Calculate the total debiv / credit card expense for Aprila. b ) Record the journal entry for the day's sales ignoring Cost of Goods Sold. For transactions with mpre than one debit, enter...

What is meant when economists describe a market as perfectly competitive? Discuss the violations of perfect competition in higher education. Do colleges and universities compete? Give two examples of...

Using the data from Table 11.3, what is the volatility of an equally weighted portfolio of Microsoft, Alaska Air, and Ford Motor stock?

Suppose the average stock has a volatility of 50%, and the correlation between pairs of stocks is 20%. Estimate the volatility of an equally weighted portfolio with (a) 1 stock, (b) 30 stocks, (c)...

Consider an equally weighted portfolio of stocks in which each stock has a volatility of 40%, and the correlation between each pair of stocks is 20%. a. What is the volatility of the portfolio as the...

Bridgton Golf Academy is evaluating new golf practice equipment. The "Dimple-Max" equipment costs $105,000, has a 5 year life, and costs $9,700 per year to operate. The relevant discount rate is 11...

The following table provides forecasted earnings and dividends per share for XPQ Manufacturing Inc. from 2001 to 2005. Beyond the forecasted period, the residual earnings are expected to grow at 5%...

Pro forma income statement Scenario analysis Allen Products LP, wants to do a scenario analysis for the coming year. The pessimistic prediction for sales is $894,000; the most likely amount of sales...