Spreadsheet supplement for case number 801458.

Second in a series on PepsiCo's bid for Quaker Oats. Describes the negotiations between PepsiCo and Quaker including due diligence process, first bid and counteroffer. Quaker's counteroffer included a collar on equity consideration, and thus the case offers an opportunity to discuss and value these contractual devices.

Throughout 1999, PepsiCo closely tracked several potential strategic acquisitions. In the fall of 2000, it appeared that the right moment for an equity-financed acquisition had arrived. At this time, PepsiCo management decided to initiate confidential discussions with The Quaker Oats Co. about a potential business combination. Gatorade, a key brand in Quaker's portfolio, had long been on PepsiCo's wish list, but PepsiCo's managers, led by CEO Roger Enrico and CFO Indra Nooyi, were committed to upholding the value of PepsiCo's shares and, as a result, were determined not to pay too much for Quaker. This case provides information that allows students: to assess the value of Quaker's businesses, estimate potential synergies associated with a Pepsi-Quaker merger, and come up with an effective negotiation strategy.