Please show work in excel formulas.

1. 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? F G H K Premium Synergy 1037 53.3% 53.0% 243% 24.5% Jag har 88.33 D 1 Equity Valuations using Multiples and Transactions 2 EPS BY Sales EBITDA 3 Historical Multiples: 4 - Average 17.19 3.63 241 5 - Medina 18.13 3.69 2237 9.91 6 7 EPS Last 40 Ext. 2021 Est.2022 8 Jaguar EPS 4.91 5.69 9 Maximum 10 Minimum 11 Book Value 12 Jaguar Book Value 32.46 13 Marimum 14 Minimum 15 Sales 16 Jaguar Sales (Last 40) 3,722 17 Average Sales Multiple 18 Firm Value 19 Debt Value 2,094 20 Equity Value 21 Maximum 22 Minimum 23 EBITDA 24 Ja EBITDA (LA 400 1,017 Average EBITDA Maltiple 26 im Vile 27 Debt Value 2004 28 Equity Value 8.656 29 Maximum 30 Minimum JI Preciom 32 Pro Announcement Stock Price 31 Marin 34 Minimum 35 Syer 36 Pre Annoncement Stock Price 37 Maximum 38 Minimum 39 71.00 7100 1. 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? F G H K Premium Synergy 1037 53.3% 53.0% 243% 24.5% Jag har 88.33 D 1 Equity Valuations using Multiples and Transactions 2 EPS BY Sales EBITDA 3 Historical Multiples: 4 - Average 17.19 3.63 241 5 - Medina 18.13 3.69 2237 9.91 6 7 EPS Last 40 Ext. 2021 Est.2022 8 Jaguar EPS 4.91 5.69 9 Maximum 10 Minimum 11 Book Value 12 Jaguar Book Value 32.46 13 Marimum 14 Minimum 15 Sales 16 Jaguar Sales (Last 40) 3,722 17 Average Sales Multiple 18 Firm Value 19 Debt Value 2,094 20 Equity Value 21 Maximum 22 Minimum 23 EBITDA 24 Ja EBITDA (LA 400 1,017 Average EBITDA Maltiple 26 im Vile 27 Debt Value 2004 28 Equity Value 8.656 29 Maximum 30 Minimum JI Preciom 32 Pro Announcement Stock Price 31 Marin 34 Minimum 35 Syer 36 Pre Annoncement Stock Price 37 Maximum 38 Minimum 39 71.00 7100