finance math guruu

AliceRanwodds
FINE332_Excel_Template_6.xlsx

Prob. 1

Equity Valuations using Multiples and Transactions
EPS BV Sales EBITDA Premium Synergy
Historical Multiples:
- Average 14.00 3.00 2.00 10.00 40.0% 20.0% Jaguar shares o/s (M)
- Median 13.50 2.50 2.20 9.00 30.0% 15.0% 75.00
EPS Last 4Q Est. 2021 Est. 2022
Jaguar EPS 4.84 4.91 5.69
Maximum
Minimum
Book Value
Jaguar Book Value 32.46
Maximum
Minimum
Sales
Jaguar Sales (Last 4Q) 3,722
Average Sales Multiple
Firm Value
Debt Value 2,094
Equity Value
Maximum
Minimum
EBITDA
Jaguar EBITDA (Last 4Q) 1,017
Average EBITDA Multiple
Firm Value
Debt Value 2,094
Equity Value 8,076
Maximum
Minimum
Premium
Pre-Announcement Stock Price 71.00
Maximum
Minimum
Synergy
Pre-Announcement Stock Price 71.00
Maximum
Minimum

Prob. 2

2020 Dividends
Dividends Growth/yr.
Northern 3.66 3.0%
Eastern 2.25 4.4%
Central 1.15 3.9%
Dividend Stream
2021 2022 TV
Northern
Eastern
Central
DDM Value of each Firm
$/share
Northern
Eastern
Central
JTM WACC 7.0%

v. JAN '22

No content - Intentionally left blank