Make a wacc calculation tool

Assignment Help Finance Basics
Reference no: EM133117117

Your company's required return on debt is 6%, its tax rate is 30%, and its required return on equity is 10%. The company has 20 billion dollars of debt, and book equity is 10 billion dollars. The stock price is 10 dollars a share, and the company has 5 billion shares outstanding. The company's WACC is _________.

Return on Debt

6%

ROE

10%

Tax Rate

30%

Debt

20,000 

Book equity

10,000 

Stock price

10 

Shares Outstanding

5,000 

WACC

 

NOTE: I am having trouble making the excel formula that gives the answer to this question given the information provided. Would you please include what the formula looks like so I can make a WACC calculation tool in excel, please?

Reference no: EM133117117

Questions Cloud

J/506/9064 Development as a Strategic Manager Assignment : J/506/9064 Development as a Strategic Manager Assignment Help and Solution, Qualifi Level 7 Diploma in Business Strategy - Assessment Writing Service
What is the one year forward interest rate : Suppose that zero interest rates with continuous compounding are as follows:
Treasury bond futures price : Suppose that the Treasury bond futures price is 101-12. Which of the following four bonds is cheapest to deliver? Please answer with just a number (1, 2, 3, or
What is the correct arbitrage strategy : Suppose that the six month risk-free interest rate is 8% per annum with continuous compounding and that the dividend yield on a stock index is 2% per annum.
Make a wacc calculation tool : Your company's required return on debt is 6%, its tax rate is 30%, and its required return on equity is 10%. The company has 20 billion dollars of debt, and boo
Calculate the present value of the payments : Jack will receive $2000 every two years from a fund. He will receive 10 payments in total with the ?rst payment being paid 5 years from new. Given that the nomi
Assigning bond ratings : What factors do rating agencies consider when assigning bond ratings?
Make equal annual payments : You are celebrating your 40" birthday today. You want to start saving for your anticipated retirement at age 65. You want to be able to withdraw $100,000 f
What is the value of this property today : Suppose you are considering the acquisition of an income producing property. The building is currently leased for the next 5 years with annual (year-end) cashfl

Reviews

Write a Review

Finance Basics Questions & Answers

  How to solve time value of money problems

Note the tabs in the file: Intro, Future Value, Present Value, FV of an Annuity, PV of an Annuity, Amortized Loans 1, and Uneven Cash Flows 1. Each of these tabs provides detailed information on how to solve time value of money problems and each a..

  What will the price be from now

A 20-year, $1,000 par value bond has a 7% annual payment coupon. The bond currently sells for $850. If the yield to maturity remains at the current rate.

  What social and economic conditions support

(a) What social and economic conditions support and encourage healthy choices? (b) What social and economic structures affect health that have nothing to do with individual choices?

  Calculate webb sports shop cash flow from operations

In 2012, Webb Sports Shop had cash flows from investing activities of $2,567,000 and cash flows from financing activities of $3,459,000.

  Calculate the net present value,

Calculate the net present value, internal rate of return, and simple payback. Next, determine the effect that each of the three (3) values will have on the company.

  Calculate the diluted earnings per share

ABC Company earns a net profit of $500,000, and has $7,000,000 common shares outstanding that sell on the open market for an average of $18 per share.

  The bank has offered them discounted loan at 10 and

1 an exporter manufacturing a specialized piece of equipment can hedge the risk that its customer will cancel the

  What is the firm value of operations

If the weighted average cost of capital is 17%, what is the firm's value of operations, in millions?

  Determine the npv for the project

Brower, Inc., just constructed a manufacturing plant in Ghana. The construction cost 9 billion Ghanaian cedi. Brower intends to leave the plant open for 3 years

  Good investment opportunities

Why did the company "lever up," if there are no good investment opportunities today, why not pay out today's cash and see if anything crops tomorrow?

  Define short-term effects on earnings per share

Why might a pre occupation with increasing earnings per share and a discounted cash-flow evaluation of prospective acquistions yield different results?

  Times are rough for auger biotech having raised 85 million

times are rough for auger biotech. having raised 85 million in an initial public offering of its stock early in the

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd