Question

In: Finance

IN EXCEL PLEASE!!! Thank you! E(rM) 7.50% rf 3.00% Stock price 53.92 Stock beta, bE 0.72...

IN EXCEL PLEASE!!! Thank you!

E(r_M)	7.50%
r_f	3.00%
Stock price	53.92
Stock beta, b_E	0.72
Cost of debt	6.22%
Percentage of equity	75.70%
Percentage of debt	24.30%
Boeing's tax rate, T_C	24.96%

Boeing's debt beta, b_D
Boeing's asset beta
Boeing's WACC

Expert Solution

Weighted Average cost of Capital (WACC)

Where,

W = Weights

Ke = Cost of equity

Kd = Cost of debt

t = tax rate

Beta of Assets

Cost of Equity under CAPM

Where,

Rf = risk free rate

Rm = Market Return

Using CAPM, Beta of Debt

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.

jeff jeffy answered 1 year ago

The capital asset pricing model (CAPM) can be written as E(Ri) = Rf+ βi[E(Rm) − Rf]...

The capital asset pricing model (CAPM) can be written as E(Ri) = Rf+ βi[E(Rm) − Rf] using the standard notation. The first step in using the CAPM is to estimate the stock’s beta using the market model. The market model can be written as Rit= αi+ βiRmt+ uit where Rit is the excess return for security i at time t, Rmtis the excess return on a proxy for the market portfolio at time t, and utis an iid random disturbance...

PLEASE USE AN EXCEL CHART AND SHOW THE FUNCTIONS USED! THANK YOU! XYZ stock price and...

PLEASE USE AN EXCEL CHART AND SHOW THE FUNCTIONS USED! THANK YOU! XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2015 $ 106 $ 5 2016 101 5 2017 89 5 2018 94 5 An investor buys three shares of XYZ at the beginning of 2015, buys another two shares at the beginning of 2016, sells one share at the beginning of 2017, and sells all four remaining shares at the beginning...

CAPM potpourri Can you re- define the CAPM mode as: E(Ri) – Rf = [E(Rm)

CAPM potpourri Can you re- define the CAPM mode as: E(Ri) – Rf = [E(Rm) - Rf] a. Yes or not? Why? Studies have found that Beta is not the only factor that matters for determining the expected return on a stock a. Mention 3 other factors that impact the expected return of the stock and how they could affect it. Explain thoroughly Why Beta was declared “dead” after the market crash of 1987? a. Explain what...

What is the estimated discount rate of ABC (assume beta=1.5)? Assume the market risk premium (E[rm]-rf)...

What is the estimated discount rate of ABC (assume beta=1.5)? Assume the market risk premium (E[rm]-rf) is 5% and assume the risk-free rate is 1%. A. 9% B. 4.5% C. 6% D. 8.5%

Ri = [Rf + ((Rm – Rf) x Bi)] Please define and explain the following components:...

Ri = [Rf + ((Rm – Rf) x Bi)] Please define and explain the following components: Ri Rf (Rm – Rf) Bi What does the CAPM tell us about the required return on a risky investment?

Rf=2%, Rm= 10% An equal weighted portfolio of stock X and Rf yields a return of...

Rf=2%, Rm= 10% An equal weighted portfolio of stock X and Rf yields a return of 10% A portfolio of stock Y and Rf with a 75% investment in stock Y yields a return of 6.5% What is the market beta of a portfolio if we invest 40%in X, 20% in Y, 20% in Rf and 20% in the market?

The risk-free rate is 3.00% and the market risk premium is 7.50%. A stock with a...

The risk-free rate is 3.00% and the market risk premium is 7.50%. A stock with a β of 1.69 just paid a dividend of $1.82. The dividend is expected to grow at 22.07% for three years and then grow at 3.32% forever. What is the value of the stock? Answer format: Currency: Round to: 2 decimal places.

A share of stock with a beta of 0.72 now sells for $47. Investors expect the...

A share of stock with a beta of 0.72 now sells for $47. Investors expect the stock to pay a year-end dividend of $2. The T-bill rate is 3%, and the market risk premium is 6%. If the stock is perceived to be fairly priced today, what must be investors’ expectation of the price of the stock at the end of the year? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

Let θ = (rm - rf) / σm be the market risk price and θ* = (rm - rf) / σ2m = θ / σm, where σm is the standard deviation of market portfolio returns.

Let θ = (rm - rf) / σm be the market risk price and θ* = (rm - rf) / σ2m = θ / σm, where σm is the standard deviation of market portfolio returns. If Pit is the price of stock i at times t = 0, 1, calculate the theoretical price Pio without subtracting the risk from the expected value E(Pi1).

PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please) [EXCEL]...

PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please) [EXCEL] Percent of sales: Cattail Corporation's financial statements for the fiscal year just ended are shown below: Cattail Corporation Income Statement Net Sales: $1500 Costs: $350 Net Income: $1150 Balance Sheet Assets $700 = $700 Debt $600 Equity 100 = $700 Cattail management expects sales to increase by 14 percent next year. Assume that the financial statement accounts vary directly with changes in sales and...