Use Yahoo Finance as the information source for this exercise.
1. Estimate the cost of equity (Re) using the Dividend Growth Model (DGM) and the Capital Asset Pricing Model (CAPM), respectively. Use the average of the results of the two models as the cost of equity for XOM.
(a). Dividend Growth Model (DGM): XOM was one of the biggest payers in dividends. Using the dividend information provided in the Excel and the relevant information from Yahoo Finance, estimate cost of equity and complete the below table. Assuming the current share price is $103.66.
Arithmetic average g: | % |
Forward dividend per share: | $ |
Re_DGM: | % |
(b). Capital Asset Pricing Model (CAPM): Look up the following information from Yahoo Finance. Estimate the cost of equity using CAPM and complete the below table. Assume the 10-year T-bond yield is 4% and the market risk premium is 5%.
(c) From this exercise, you would see that your estimation is only as good as your assumptions of each components that go into the calculation. It's not entirely science, and exercising judgment is where the skill and experience come to play! Assuming that you decide to use the average of the two as the final estimate for the cost of equity. Your final cost of equity for XOM is:
2. Estimate the cost of debt: Using the bond information provided in the Excel, estimate (i) the market value of outstanding amount for each bond, (ii) the YTM for each bond, and (iii) the cost of debt as the market value weighted average of YTM of all bonds.
3. Capital structure: Given the share price of $103.66 and the number of shares outstanding is 4.01 billions, estimate the weights of debt and equity based on the market value, and complete the below table. Hint: you know the market value outstanding amount of each bond, by summing the amount along all bonds, it gives you the total market value of the debt.
| $ in billions | Weight (%) |
Debt, MV | $ b | % |
Equity, MV | $ b | % |
4. Estimate WACC, assuming the tax rate is 33%.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{12}{|l|}{ Source: Bloomberg } \\ \hline Coupon Frequency & Issue Date & Name & Ticker & Coupon & Maturity & \begin{tabular}{l} Bloomberg \\ Composite \\ Rating \end{tabular} & Avg P & \begin{tabular}{l} Remaining \\ tenor (in \\ years) \end{tabular} & \begin{tabular}{l} BV outstanding \\ amount (USD) \end{tabular} & \begin{tabular}{l} MV outstanding \\ amoutn (USD) \end{tabular} & YTM \\ \hline 2 & 4/15/2020 & Exxon Mobil Corp & XOM & 3.452 & 4/15/2051 & AA- & 71.2 & 31.02 & 2,750,000,000 & & \\ \hline 2 & 3/19/2020 & Exxon Mobil Corp & XOM & 3.482 & 3/19/2030 & AA- & 91.3455 & 10.01 & 2,000,000,000 & & \\ \hline 2 & 3/3/2016 & Exxon Mobil Corp & XOM & 3.043 & 3/1/2026 & AA- & 95.7695 & 10.00 & 2,500,000,000 & & \\ \hline 2 & 4/15/2020 & Exxon Mobil Corp & XOM & 2.61 & 10/15/2031 & (AA- & 85.491 & 10.51 & 2,000,000,000 & & \\ \hline 2 & 3/19/2020 & Exxon Mobil Corp & XOM & 2.992 & 3/19/2025 & AA- & 97.1115 & 5.00 & 2,750,000,000 & & \\ \hline 2 & 3/19/2020 & Exxon Mobil Corp & XOM & 4.327 & 3/19/2050 & AA- & 82.8925 & 30.02 & 2,750,000,000 & & \\ \hline 1 & 6/26/2020 & Exxon Mobil Corp & XOM & 0.142 & 6/26/2024 & AA- & 97.731 & 4.00 & 1,605,000,000 & & \\ \hline 2 & 3/19/2020 & Exxon Mobil Corp & XOM & 4.227 & 3/19/2040 & AA- & 86.2485 & 20.01 & 2,000,000,000 & & \\ \hline 2 & 8/16/2019 & Exxon Mobil Corp & XOM & 2.44 & 8/16/2029 & AA- & 87.1615 & 10.01 & 1,250,000,000 & & \\ \hline 2 & 3/19/2020 & Exxon Mobil Corp & XOM & 3.294 & 3/19/2027 & AA- & 95.2755 & 7.00 & 1,000,000,000 & & \\ \hline 2 & 3/6/2015 & Exxon Mobil Corp & XOM & 2.709 & 3/6/2025 & AA- & 96.845 & 10.01 & 1,750,000,000 & & \\ \hline 1 & 6/26/2020 & Exxon Mobil Corp & XOM & 1.408 & 6/26/2039 & AA- & 67.2465 & 19.01 & 1,070,000,000 & & \\ \hline 2 & 3/3/2016 & Exxon Mobil Corp & XOM & 4.114 & 3/1/2046 & AA- & 81.5515 & 30.01 & 2,500,000,000 & & \\ \hline 1 & 6/26/2020 & Exxon Mobil Corp & XOM & 0.524 & 6/26/2028 & AA- & 87.9615 & 8.01 & 1,070,000,000 & & \\ \hline 1 & 6/26/2020 & Exxon Mobil Corp & XOM & 0.835 & 6/26/2032 & AA- & 78.6745 & 12.01 & 1,070,000,000 & & \\ \hline 2 & 8/16/2019 & Exxon Mobil Corp & XOM & 2.019 & 8/16/2024 & AA- & 97.5345 & 5.01 & 1,000,000,000 & & \\ \hline 2 & 8/16/2019 & Exxon Mobil Corp & XOM & 2.995 & 8/16/2039 & AA- & 73.759 & 20.01 & 750,000,000 & & \\ \hline 2 & 3/20/2014 & Exxon Mobil Corp & XOM & 3.176 & 3/15/2024 & AA- & 99.212 & 9.99 & 1,000,000,000 & & \\ \hline 2 & 3/6/2015 & Exxon Mobil Corp & XOM & 3.567 & 3/6/2045 & AA- & 75.2875 & 30.02 & 1,000,000,000 & & \\ \hline 2 & 8/16/2019 & Exxon Mobil Corp & XOM & 3.095 & 8/16/2049 & AA- & 66.4655 & 30.02 & 1,500,000,000 & & \\ \hline 2 & 8/16/2019 & Exxon Mobil Corp & XOM & 2.275 & 8/16/2026 & AA- & 93.3885 & 7.01 & 1,000,000,000 & & \\ \hline 2 & 3/30/2006 & XTO Energy Inc & XOM & 6.1 & 4/1/2036 & AA- & 103.536 & 30.03 & 174,435,000 & & \\ \hline 2 & 4/18/2008 & XTO Energy Inc & XOM & 6.375 & 6/15/2038 & AA- & 101.5205 & 30.18 & 199,725,000 & & \\ \hline 2 & 7/19/2007 & XTO Energy Inc & XOM & 6.75 & 8/1/2037 & AA- & 110.195 & 30.06 & 252,384,000 & & \\ \hline \end{tabular} MV of all bonds >