Hi, I need support using the following information for find the correct excel formula to use. Please include excel formula. prob. 1- To find the Maximum/Minimum for Book value: Maximum=EPS Median*Jaguar Book Value Minimum=EPS Average*Jaguar Book Value Max: For Sales and EBITDA, we have to divide the equity value to the Jaguar shares o/s (M). Min: You have to first find (Jaguar Sales (Last 4Q)*Median)-Debt Value and then divide to Jaguar shares o/s (M). For Premium and Synergy, we have to multiply the Pre-Announcement Stock Price to the (1+ Average or Median.

JTM Airlines is looking to buy Jaguar Airlines. Your boss, the CFO, wants a quick and dirty valuation of Jaguar. You choose to look at past transactions in the airline industry to get some numbers and put them in an Excel spreadsheet. For Jaguar, you find out the firm's key financial values and put them in the spreadsheet. To remind yourself that they are inputs, you should color them red. Using EPS, Book Value (BV), Sales, EBITDA, Premium and Synergy over stock price, what should be Jaguar's prices per share?

A B C D E F G H Equity Valuations using Multiples and Transactions IN EPS BV Sales EBITDA Premium Synergy 3 Historical Multiples: - Average 14.00 3.00 2.00 10.00 40.0% 20.0% Jaguar shares ofs (M) auf - Median 13.50 2.50 2.20 9.00 30.0% 15.0% 75.00 EPS Last 4Q Est. 2021 Est. 2022 Co Jaguar EPS 1.84 4.91 5.65 Maximum Minimum 11 Book Value 12 Jaguar Book Value 32.46 13 Maximum 14 Minimum 15 Sales 16 Jaguar Sales (Last 4Q) 3,722 17 Average Sales Multiple 18 Firm Value 19 Debt Value 2,094 20 Equity Value 21 Maximum 22 Minimum 23 EBITDA 24 Jaguar EBITDA (Last 4Q) 1,017 25 Average EBITDA Multiple 26 Firm Value 27 Debt Value 2,094 28 Equity Value 8,076 29 Maximum 30 Minimum 31 Premium Pre-Announcement Stock Price 71.00 33 Maximum 34 Minimum 35 Synergy 36 Pre-Announcement Stock Price 71.00 7 Maximum 38 Minimum 30