I've seen a few M&A experts run their spreadsheets and then the negotiations happened. In reality 90% of the outcome was determined by how competitive the bidding was and how willing the target company seemed to walk away. All spreadsheets went out the window in the first phase.