Mohammed Rashad
← all projects
FinanceValuationM&ADDMCAPMExcel

academic project

Bistro 7 and Cafe Bleu: Merger Valuation

problem · Bistro 7, a Portland restaurant group, wants to buy Cafe Bleu, a chain of 10 restaurants in New York. What's the least the seller should accept, the most the buyer should pay, and what's fair?

approach & results

  • Built the valuation in Excel with a dividend discount model, using CAPM for the cost of equity, for Cafe Bleu on its own and after the merger.
  • On its own Cafe Bleu is worth $11.32 a share. With the merger's savings and growth, it's worth $29.89. Splitting the gains evenly puts a fair price at $20.61.
  • Tested what happens if the merger underdelivers. Every point the cost savings fall short takes about $1.20 off the share value.
  • Recommended offering $17.00 a share in cash plus a $4.00 earn out, paid only if the targets are hit, and walking away above $25.00.