I need help explaining the Set questions using the Excel spreadsheet provided. Please show Excel formulas.
ZOOM + FINE 332 Corporate Finance | Module 6 Problem Set Multiples and Transactions, Dividend Discount Model 1. JIM Arines is lookng to buy Jaguar Alrines. Your bass, the CFD, wants a cuick and dry valuation of Jaguar. You choose to Inok at past transactions in the airline industry to get some numbers ors and put them in an Excel spreadsheet For Jaguer, you find out the frm's key financial values and put them in the samadshent. To remind yourself that they are inguts, ynu should color them rod. Using EPS, Book Value (EV), Sales, EBITDA, Premium, and Synergy over stack price.what should be Jaguar's prices per share? 2. Your boss is piling on the work and has asked you to value three more potential acquisitions. They are of Northern Erstern and Central fixad bessonerators serving areas where JTM is looking to expand te name give away the regions of the country. You don't have cash Non dala for these imes they are privately held, but you takes to the Onemember you are Information which you cer back to your carorate finance class that you can use the Dividend Discount Model(DDM to come up with a quick and dirty valuation You know thal JTM's WACC is 8.8% and will use this as the applicable discount rate. Using the DDM Model, what are the value per share of each of these three firs? FINE 332 | Noomber 21 worldwide.ru.edu Urly waiah Pada 12114. Nors www.topd.ed end! Aeronautical Invarsity W. I do not only way. EMBRYRIDDLE a 125% v Zum OH .. T lo Formal Organics View Ad Category ITAL The Cher Tex: SpMidi Carmen un + Prob. 1 Prob. 2 6. NOV 2021 Shee: Sheet Name Proh. 1 Equity Valuations using Multiples and Transactions EPS RY Sales EBUIDA Premium Synergy Historical Multiples: - Averape Median 2.00 Background 17.00 19.00 400 5.on 11,00 9.00 Jaguar shares USM 94.00 45.0% 25.0% Ausrede for all Multiple Duplicate Sheet Last 40 Est. 2021 . 4.11 Ext. 2012 1.66 1.55 . Min. Delete Sheet 22.00 4,200 1,800 EPS Jaguar EPS Maximum Minimum Buok Value Jaguar Hook Value Maximum Minimum Sales Jaguar Sales (last 40) Average Sales Mouple Firm Value Debt Value Emily Value Maximum Minimum EBITDA Jnguar EBITDA (Last 40) Average EBITDA Multiple Firm Value Debi valus Equity valus Maximum Minimum Prendiam Pro Azmunicernent Stuck Irice Maximum 9RS LO 9,068 62.00 Minimum Synergy Pro-Am. Suck I've Muximum Minimum 62.00 125% v % 2uum v H . I T lo Formal Organics View S: Calegur ITAL Tulle Cher Tex. Shop Main Cum un + Prob. 1 Frot. 2 V. NOV 2021 Sheet Sheet Name Prob. 2 Northern nstem Cuniral 2020 Dividends Dividends Growth vr. 2.00 3.0% 1.00 2.0% O.SU 3.5% Background Duplicate Sheet Dividend Stream 2021 2022 TY Delete Sheet Norcel Fenstem Central DDM Yalue of each Firm Scharc Noricu Fastem Central JTM WANT ZOOM + FINE 332 Corporate Finance | Module 6 Problem Set Multiples and Transactions, Dividend Discount Model 1. JIM Arines is lookng to buy Jaguar Alrines. Your bass, the CFD, wants a cuick and dry valuation of Jaguar. You choose to Inok at past transactions in the airline industry to get some numbers ors and put them in an Excel spreadsheet For Jaguer, you find out the frm's key financial values and put them in the samadshent. To remind yourself that they are inguts, ynu should color them rod. Using EPS, Book Value (EV), Sales, EBITDA, Premium, and Synergy over stack price.what should be Jaguar's prices per share? 2. Your boss is piling on the work and has asked you to value three more potential acquisitions. They are of Northern Erstern and Central fixad bessonerators serving areas where JTM is looking to expand te name give away the regions of the country. You don't have cash Non dala for these imes they are privately held, but you takes to the Onemember you are Information which you cer back to your carorate finance class that you can use the Dividend Discount Model(DDM to come up with a quick and dirty valuation You know thal JTM's WACC is 8.8% and will use this as the applicable discount rate. Using the DDM Model, what are the value per share of each of these three firs? FINE 332 | Noomber 21 worldwide.ru.edu Urly waiah Pada 12114. Nors www.topd.ed end! Aeronautical Invarsity W. I do not only way. EMBRYRIDDLE a 125% v Zum OH .. T lo Formal Organics View Ad Category ITAL The Cher Tex: SpMidi Carmen un + Prob. 1 Prob. 2 6. NOV 2021 Shee: Sheet Name Proh. 1 Equity Valuations using Multiples and Transactions EPS RY Sales EBUIDA Premium Synergy Historical Multiples: - Averape Median 2.00 Background 17.00 19.00 400 5.on 11,00 9.00 Jaguar shares USM 94.00 45.0% 25.0% Ausrede for all Multiple Duplicate Sheet Last 40 Est. 2021 . 4.11 Ext. 2012 1.66 1.55 . Min. Delete Sheet 22.00 4,200 1,800 EPS Jaguar EPS Maximum Minimum Buok Value Jaguar Hook Value Maximum Minimum Sales Jaguar Sales (last 40) Average Sales Mouple Firm Value Debt Value Emily Value Maximum Minimum EBITDA Jnguar EBITDA (Last 40) Average EBITDA Multiple Firm Value Debi valus Equity valus Maximum Minimum Prendiam Pro Azmunicernent Stuck Irice Maximum 9RS LO 9,068 62.00 Minimum Synergy Pro-Am. Suck I've Muximum Minimum 62.00 125% v % 2uum v H . I T lo Formal Organics View S: Calegur ITAL Tulle Cher Tex. Shop Main Cum un + Prob. 1 Frot. 2 V. NOV 2021 Sheet Sheet Name Prob. 2 Northern nstem Cuniral 2020 Dividends Dividends Growth vr. 2.00 3.0% 1.00 2.0% O.SU 3.5% Background Duplicate Sheet Dividend Stream 2021 2022 TY Delete Sheet Norcel Fenstem Central DDM Yalue of each Firm Scharc Noricu Fastem Central JTM WANT
