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?