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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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