M&A Case Study - Analysis at Various Prices

How to use Excel to analyze the valuation of a target company based on different EBITDA multiples and compare them with the trading and transaction multiples of comparable companies. How to calculate the enterprise value, change the EBITDA basis, and interpret the results in a negotiation context.