Please calculate the return on equity using Excel. Market Value of Debt Market vlaue of Equity...

Question

Question

Market Value of Debt Market vlaue of Equity Total Value of Capital $2,500,000.00 $1,000,000.00 $3,500,000.00 Тc 25.00% 10% WA

Please calculate the return on equity using Excel.

business finance

Answer 1

Answer #1

WACC = Debt% x Kd x (1-tax) + Equity% x Ke

10% = 71.43% x 5% x (1-25%) + 28.57% x Ke

Ke = 25.625%

Therefore expected return on equity = 25.625%

Answer 2

Similar Homework Help Questions

Arbitra Inc.'s current capital structure is 30% debt and 70% equity. The expected return on its...

Arbitra Inc.'s current capital structure is 30% debt and 70% equity. The expected return on its debt is 5%, its equity Beta is 1.1. The riskfree rate is 2%, and the expected return on the market is 10%. Consider now the following additional information. The government of Bigland, where Arbitra Inc. is located, introduces a 40% corporate income tax rate. Arbitra Inc. (capital structure still 50% debt and 50% equity) has only one project which is expected to generate $1000...
A firm has a market capitalization (market value of equity) of $16 Billion and net debt of $12 Billion

Question 11A firm has a market capitalization (market value of equity) of $16 Billion and net debt of $12 Billion. Calculate the weight of debt in the firm's weighted average cos of capital (WACC) calculation. (Note: Enter your answer as a percentage rounded to two decimal places.] Question 12A firm has an effective (after-tax) cost of debt of 3%, and its weight of debt is 40%. Its equity cost of capital is 9%, and its weight of equity is 60%. Calculate...
A firm has a market capitalization (market value of equity) of $30 Billion and net debt of $4 Billion

A firm has a market capitalization (market value of equity) of $30 Billion and net debt of $4 Billion. Calculate the weight of debt in the firm's weighted average cost of capital (WACC) calculation.

A firm has a market capitalization (market value of equity) of $11 Billion and net debt of $3 Billion

A firm has a market capitalization (market value of equity) of $11 Billion and net debt of $3 Billion. Calculate the weight of equity in the firm's weighted average cost of capital (WACC) calculation.
A firm has a market capitalization (market value of equity) of $25 Billion and net debt...

A firm has a market capitalization (market value of equity) of $25 Billion and net debt of $15 Billion. Calculate the weight of debt in the firm's weighted average cost of capital (WACC) calculation. [Note: Enter your answer as a percentage rounded to two decimal places.]
NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE Calculate WACC: Debt Weight: 60.00% Equity Weight: 40.00% Tax...

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

A firm has a market capitalization (market value of equity) of $19 Billion and net debt...

A firm has a market capitalization (market value of equity) of $19 Billion and net debt of $11 Billion. Calculate the weight of equity in the firm's weighted average cost of capital (WACC) calculation. [Note: Enter your answer as a percentage rounded to two decimal places.]
Using market value and book value (separately), find the adjusted WACC, using 30% tax rate. Please...

Using market value and book value (separately), find the adjusted WACC, using 30% tax rate. Please include formulas in the answer. I need to understand how to calculate the book and market values of debt and stock as shown in the grey boxes. Thank You! Using market value and book value (separately), find the adjusted WACC, using 30% tax rate Component Debt Preferred Stock Common Stock Balance Sheet Value 5,000,000.00 4.000,000.00 2.000,000.00 Market Value Cost of Capital 890 10% 13%...
SMU, Inc. has equity with a market value of $20 million and debt with a market...

SMU, Inc. has equity with a market value of $20 million and debt with a market value of $10 million. SMU pays 8% interest on its debt per year, and the expected return on the market portfolio over the next year is 18%. The beta of SMU’s equity is .90. The firm pays no taxes. a. What is SMU’s debt to equity ratio? What is SMU’s weighted average cost of capital? b. What is the cost of capital for an...

Novus can raise equity capital in its domestic equity market, or in the global equity markets. Novus's...

Novus can raise equity capital in its domestic equity market, or in the global equity markets. Novus's equity beta in the domestic market is 0.95. In the global equity markets, which have a higher expected return, Novus has a lower beta of 0.625. The risk-free rate in either the domestic or global securities market is 3.5%, while the domestic market has an expected market return of 10% and the global market has an expected return of 12.5%. a) Calculate Novus's cost of Equity...