Question: MAKE IT IN EXCEL USE THIS FOFMULA: WACC = equity / (equity +debt) x cost of equity + debt (equity +debt) x cost of debt

MAKE IT IN EXCEL

USE THIS FOFMULA: WACC = equity / (equity +debt) x cost of equity + debt (equity +debt) x cost of debt x (1-tax rate)

Calculate the weighted average cost of capital (WACC), considering that Company W has a total value of debt and equity of EUR 1,246,890, and hold 40% in debt. The cost of equity is of 6% and the company borrows at a cost of 3%. Company D pays 35% tax.

An investor bought shares of Company W and as a return on investment of 3%, did he made a cost-effective decision?

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!

Calculate the weighted average cost of capital (WACC), considering that Company D has a total value of debt and equity of 600,000, and hold 40% in debt. The cost of equity is of 4% and the company...

WACC Practice Problem a) The levered beta and the debt equity ratio of other firms, the higher the debt equity ratio, the lower the levered beta. Therefore, with 0.85 debt ratio, the levered beta...

any help is appreciated Cabana Cruise Line uses a combination of debt and equity to fund operations, and they have a bond r and currently trades at a value of $51 per share. Cabana Cruise Line has...

1.Estimation of WACC (30%): There are several ways that one can value a company, and the most popular ones are WACC (weighted average cost of capital) and APV (adjusted present value). In this...

1. Estimation of WACC (35 points): There are several ways that one can value a company, and the most popular ones are WACC (weighted average cost of capital) and APV (adjusted present value). In this...

STARBUCKS Go to Yahoo Finance and look for the stock information for the company. Answer the following (In a table format in excel see uploaded file in Learn) What is the most recent stock price...

The Sunshine Solar Panel Company is planning a $150 million expansion that will generate cash flows for 10 years. As an analyst in the companys Finance Department, you are being tasked to determine...

1) Calculate NOPAT for 2014 and 2015. $45,000 and $50,000 respectively was considered to be a reinvestment for the future growth of the firm. 2) Calculate the relative proportions of debt and equity...

. Currently, Forever Flowers Inc. has a capital structure consisting of 20% debt and 80% equity. Forever's debt currently has an 9% yleld to maturity. The risk-free rate ( rRP) is 4%, and the market...

Please Show the excel formulas Thank You WACC facts: Barking Dog Corp Cost of Capital Given: Optimal Capital Structure: 25% Debt 10% Preferred Equity 65% Common Equity Net income for the coming year:...

Due to your good credit, your bank reduces the interest rate on your $14,000 loan from 8.8% to 7.1% per year. Thanks to the change, how much will you save in interest this year? The amount you will...

It is often stated that people are born to be a leader or a politician and people cannot be taught the art of being a leader. What do you think and why? Give your opinion with relevant examples....

13 Sofia is looking at the number sequence -14, -8,-2,4,... Read what she says. Is Sofia correct? Show all your working. The 50th term of this sequence is 280

One of the most popular innovations advertisers are using online to get visitors to watch their messages uses animated GIF files or video clips to grab viewers' attention. This is referred to as _ _...

What skills will you need in order to share what you have learned more widely?

Which individuals or groups may not wish to be identified through any dissemination process? What steps could you take to ensure that appropriate anonymity and confidentiality are maintained and that...

To what extent do you routinely use your critical judgement to assess the reliability and validity of evidence, including that based on your previous experience?