please show work in excel

A chocolate company (ticker: CHOC) announces a surprise acquisition of a peanut butter company (PB). By securing a steady supply of peanut butter, CHOC hopes to produce chocolate peanut butter cups more cheaply. Joining forces will result in $5.0 million additional free cash flow, starting in one year, above what the forms would generate separately. This incremental benefit will grow by 3% every year thereafter. Both CHOC and PB have WACC of 11%. Prior to the announcement, CHOC's stock price was $125 and it had 67 million shares. PB's stock price was $41 with 17 million shares. When the takeover is announced, what is your best guess for the dollar change in a) CHOC's stock price? b) PB's stock price? Another friend likes buying individual stocks One stock he recommends has a 5% dividend yield. He says. "I prefer this over a stock that doesn't pay dividends, because at least I'm earning 5% on my money. Evaluate his statement. Edit View insert Format Tools Table 12ptParagraph BIAYTOV