Please show all Excel formulas. Thank you.

1. Apache Airlines is looking to buy Aerial Airlines. Your boss, the CFO, wants a quick and dirty valuation of Aerial. You choose to look at past transactions in the airline industry to get some numbers. You find the following from reported transactions for the average price paid: a. 12.0x the acquired firm's earnings per share (EPS) b. 9.0x EBITDA C. 45.0% premium of share price For Aerial, you find out the following: a. EPS = $4.00 b. EBITDA = $835 million (debt value = $2, 320 million) C. Stock Price = $42 Using EPS, EBITDA, and premium over stock price, what should be Aerial's prices per share? What is the average of the three? Transactions Cost of Equity DDM Transactions EPS EBITDA Premium Values for past transactions: - Average Last 10 EPS Aerial EPS Average EPS Multiple Equity Value per Share Average price per share using 3 references EBITDA Aerial EBITDA (in MS, last 40) Average EBITDA Multiple Firm Vales Debt Value Equity Value Equity Value per Share Premium Pre-Merger Announcement Stock Price Average Premium Multiple of shares outstanding M 90.5