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

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 for WACC.

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)
2. Find Cost of Debt:
Suppose the average bond information is below for an annual coupon paying bond:
Maturity 5
Coupon 4.00%
FV $5,000.00
P $4,500.00
YTM 6.40%

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:

Consider a regression model that links a CEOs compensation (in $ millions) with the total assets of the firm (in $ millions) and the firms industry. Dummy variables are used to represent four...

Q:

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

Q:

Green is given. Blue is input. need help with missing cells (parts d,e,f) Instructions: Do not change data in the green shaded areas. Only enter formulas and cell references in the blue shaded areas....

Q:

Question 1: Show all excel formulas Question 2: show all excel formulas (Use cells A6 to B27 from the given information to complete this question. You must use the built-in Excel function to answer...

Q:

As a new Investment Analyst for Burt & Brommer (B&B) Capital Management, Inc., you are asked to estimate the mean, variance, standard deviation of returns for FedEx (FDX) common stock. You have...

Q:

As a new Investment Analyst for Burt & Brommer (B&B) Capital Management, Inc., you are asked to estimate the mean, variance, standard deviation of returns for FedEx (FDX) common stock. You have...

Q:

Hi I am doing a project on the integrative case, and would like some assistance. If anyone can please help with the project Making Long Term FM Decisions - Integrative Case Title: Analyzing Long Term...

Q:

Hi, you asked me to put the question on advantage question. Please if you can helpthat would be great help. Thanks Making Long Term FM Decisions - Integrative Case Title: Analyzing Long Term...

Q:

Here is the condensed 2021 balance sheet for Skye Computer Company (in thousands of dollars): 2021 Current assets $ 2,000 Net fixed assets 3,000 Total assets $ 5,000 Accounts payable and accruals $...

Q:

Here is the condensed 2021 balance sheet for Skye Computer Company (in thousands of dollars): 2021 Current assets $ 2,000 Net fixed assets 3,000 Total assets $ 5,000 Accounts payable and accruals $...

Q:

Please help, where did I go wrong. Thank you Skye's earnings per share last year were $3.75. The common stock sells for $60.00, last year's dividend (D0) was $2.95, and a flotation cost of 10% would...

Q:

What is Form 941? How often is the form filed?

Q:

Oxnard Corporation has accumulated E&P of negative $40,000 and current E&P of $50,000. Oxnard made a $60,000 dividend distribution to its shareholders during the year. As a result of this...

Q:

In general, being means individuals do not have financial means to cover the gap between what their insurance covers and the total cost of their medical bills

Q:

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...