Question: NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE 1. Cost of Equity: Stock quote link Stock price: $ 65.95 Dividend: $ 1.66 Key statistics link Beta:

NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE

1. Cost of Equity:
Stock quote link
Stock price: $ 65.95
Dividend: $ 1.66
Key statistics link
Beta: 1.43
Shares outstanding: 148,610,000
Analysts' estimates link
5-year dividend growth: 6.85%
Bond center link:
Risk-free rate: 0.13%
Market Risk Premium: 7.00%

Cost of Equity: Use DDM: r = D/P + g
Cost of Equity: Use CAPM: r = rf + B * (Rm - Rf)

Please provide Excel solutions for the above two problems using the formula given.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

4.21 Case Study Competency IV.1RM Determine diagnosis and procedure codes and groupings according to official guidelines. Competency IV.1 Validate assignment of diagnostic and procedural codes and...

Q:

Stock quote link Stock price: 298.94 Dividend: 2.60 Key statistics link Beta 0.93 Shares outstanding: 439,660,000 Analysts' estimates link 5-year dividend growth: 7.34% Bond center link: Risk-free...

Q:

HND 1. Cost of Equity: Stock quote link Stock price: Dividend: A 65.95 1.66 A Key statistics link Beta: Shares outstanding: 1.43 148,610,000 9 Analysts' estimates link 11 5-year dividend growth:...

Q:

Stock quote link Stock price: Dividend: 498.50 2.00 Key statistics link Beta: Shares outstanding: 0.95 25,000,000 Analysts' estimates link 5-year growth: 8.08% 0.72% 7.00% Bond center link: Risk-free...

Q:

NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE Calculate WACC: Debt Weight: 60.00% Equity Weight: 40.00% Tax rate: 35.00% WACC: Use CAPM Cost of Equity The below information is given. I need to solve...

Q:

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Q:

with formula please $ $ 65.95 1.66 1.43 148,610,000 1 1. Cost of Equity: 2 Stock quote link 3 Stock price: 4 Dividend: 5 6 Key statistics link 7 Beta: 8 Shares outstanding: 9 10 Analysts'estimates...

Q:

1. Cost of Equity 2 Stock quote link 3 Stock price: 4 Dividend: 65.95 1.66 6 Key statistics link / Beta: 8 Shares outstanding: 1.43 148,610,000 0 Analysts' estimates link 115-year dividend growth:...

Q:

B C A 1. Cost of Equity: 2 Stock quote link 3 Stock price $ 65.95 $ Dividend: 1.66 5 Key statistics link Beta: 1.43 Shares outstanding: 148,610,000 10 Analysts' estimates link 11 5-year dividend...

Q:

Stage 4: Developing Combined-Asset Portfolios You are going to develop two multi-asset portfolios from the stocks you chose. Place the information for these steps in the Portfolios worksheet. Step 1)...

Q:

I need help with B and D and E. please. NOTE: Market information changes all the time. Please provide the specific date when you get the financial data. Hyperlinks for stock information for COST and...

Q:

Suppose Cowles Corp.'s market value of debt is $10,000,000 and it has 1,200,000 shares selling at $9 per share? What is the WACC if the cost of debt is 6% and the expected rate of return on the stock...

Q:

Using Probability Distributions Suppose the returns on large-company stocks are normally distributed. Based on the historical record, use the cumulative normal probability table (rounded to the...

Q:

Select the correct statement: A . Payments up to P 3 0 0 0 0 0 made by employens for the death of an employee is exempled trom nocme tax D . The pension paid to a war veleran is included in tarable...

Q:

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...