Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Use Yahoo Finance as the information source for this exercise.

image text in transcribed

image text in transcribed

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%.

Beta: x
Re_CAPM: %

(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:

Re: %

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.

Rd: %

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%.

WACC: %
\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 >

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management For Nurse Managers Merging The Heart With The Dollar

Authors: Janne Dunham-Taylor, Joseph Z. Pinczuk

1st Edition

1284031039, 9781284031034

More Books

Students also viewed these Finance questions

Question

2. How can cash be raised for the required investments?

Answered: 1 week ago

Question

What are the potential limitations of group discussion?

Answered: 1 week ago