Question

In: Finance

Caspian Sea Drinks' is financed with 60.00% equity and the remainder in debt. They have 11.00-year,...

Caspian Sea Drinks' is financed with 60.00% equity and the remainder in debt. They have 11.00-year, semi-annual pay, 5.47% coupon bonds which sell for 97.80% of par. Their stock currently has a market value of $24.31 and Mr. Bensen believes the market estimates that dividends will grow at 3.90% forever. Next year’s dividend is projected to be $2.09. Assuming a marginal tax rate of 20.00%, what is their WACC (weighted average cost of capital)?

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

M23 A B C D E Tax rate 20% $1,000 5.47% Par value of Bond (Assumed) Coupon rate Coupon frequency Years until maturity Price of Bond Yield to maturity (cost of debt) Aftertax cost of debt 2 11 $978 6.35% 5.08% Market Price of Share Next Dividend Dividend growth rate Cost of Equity $24.31 $2.09 3.90% 12.50% Capital Weight Cost 60% Debt Equity 5.08% 12.50% 40% WACC 8.05%

Tax rate 0.2 1000 0.0547 6 Par value of Bond (Assumed) Coupon rate Coupon frequency Years until maturity Price of Bond Yield to maturity (cost of debt) Aftertax cost of debt 8 9 =C4*97.8% =RATE(C7/2,-C5/2* C4,C8,-C4,0)*2 =C9*(1-C2) 10 11 12 13 14 24.31 2.09 Market Price of Share Next Dividend Dividend growth rate Cost of Equity 0.039 =(C13/c12)+C14 15 16 Capital Weight Cost =C10 Debt Equity =1-C18 =C15 WACC =SUMPRODUCT(C18:C19,D18:019)


Related Solutions

Caspian Sea Drinks' is financed with 62.00% equity and the remainder in debt. They have 11.00-year,...
Caspian Sea Drinks' is financed with 62.00% equity and the remainder in debt. They have 11.00-year, semi-annual pay, 5.94% coupon bonds which sell for 98.90% of par. Their stock currently has a market value of $24.18 and Mr. Bensen believes the market estimates that dividends will grow at 3.22% forever. Next year’s dividend is projected to be $2.77. Assuming a marginal tax rate of 26.00%, what is their WACC (weighted average cost of capital)? 4 decimal place answer.
Caspian Sea Drinks' is financed with 63.00% equity and the remainder in debt. They have 12.00-year,...
Caspian Sea Drinks' is financed with 63.00% equity and the remainder in debt. They have 12.00-year, semi-annual pay, 5.67% coupon bonds which sell for 97.15% of par. Their stock currently has a market value of $25.94 and Mr. Bensen believes the market estimates that dividends will grow at 3.86% forever. Next year’s dividend is projected to be $2.73. Assuming a marginal tax rate of 24.00%, what is their WACC (weighted average cost of capital)?
Caspian Sea Drinks' is financed with 65.00% equity and the remainder in debt. They have 12.00-year,...
Caspian Sea Drinks' is financed with 65.00% equity and the remainder in debt. They have 12.00-year, semi-annual pay, 5.55% coupon bonds which sell for 98.92% of par. Their stock currently has a market value of $24.82 and Mr. Bensen believes the market estimates that dividends will grow at 3.33% forever. Next year’s dividend is projected to be $2.50. Assuming a marginal tax rate of 35.00%, what is their WACC (weighted average cost of capital) 4 Decimal place answer please.
Caspian Sea Drinks' is financed with 69.00% equity and the remainder in debt. They have 12.00-year,...
Caspian Sea Drinks' is financed with 69.00% equity and the remainder in debt. They have 12.00-year, semi-annual pay, 5.42% coupon bonds which sell for 98.37% of par. Their stock currently has a market value of $25.81 and Mr. Bensen believes the market estimates that dividends will grow at 3.16% forever. Next year’s dividend is projected to be $2.29. Assuming a marginal tax rate of 22.00%, what is their WACC (weighted average cost of capital)? Answer Format: Percentage Round to: 2...
Caspian Sea Drinks' is financed with 70.00% equity and the remainder in debt. They have 12.00-year,...
Caspian Sea Drinks' is financed with 70.00% equity and the remainder in debt. They have 12.00-year, semi-annual pay, 5.27% coupon bonds which sell for 98.50% of par. Their stock currently has a market value of $24.14 and Mr. Bensen believes the market estimates that dividends will grow at 3.26% forever. Next year’s dividend is projected to be $2.29. Assuming a marginal tax rate of 29.00%, what is their WACC (weighted average cost of capital)?
Caspian Sea Drinks' is financed with 60.00% equity and the remainder in debt. They have 10.00-year, semi-annual pay, 5.80% coupon bonds which sell for 97.91% of par.
Caspian Sea Drinks' is financed with 60.00% equity and the remainder in debt. They have 10.00-year, semi-annual pay, 5.80% coupon bonds which sell for 97.91% of par. Their stock currently has a market value of $24.05 and Mr. Bensen believes the market estimates that dividends will grow at 3.56% forever. Next year's dividend is projected to be $2.66. Assuming a marginal tax rate of 20.00%, what is their WACC (weighted average cost of capital)?
Assume a par value of $1,000. Caspian Sea plans to issue a 11.00 year, semi-annual pay...
Assume a par value of $1,000. Caspian Sea plans to issue a 11.00 year, semi-annual pay bond that has a coupon rate of 13.00%. If the yield to maturity for the bond is 13.0%, what will the price of the bond be? Answer format: Currency: Round to: 2 decimal places.
Assume a par value of $1,000. Caspian Sea plans to issue a 11.00 year, semi-annual pay...
Assume a par value of $1,000. Caspian Sea plans to issue a 11.00 year, semi-annual pay bond that has a coupon rate of 8.02%. If the yield to maturity for the bond is 7.60%, what will the price of the bond be? Assume a par value of $1,000. Caspian Sea plans to issue a 8.00 year, semi-annual pay bond that has a coupon rate of 7.91%. If the yield to maturity for the bond is 8.43%, what will the price...
Caspian Sea Drinks is considering the purchase of a plum juicer – the PJX5. There is...
Caspian Sea Drinks is considering the purchase of a plum juicer – the PJX5. There is no planned increase in production. The PJX5 will reduce costs by squeezing more juice from each plum and doing so in a more efficient manner. Mr. Bensen gave Derek the following information. What is the IRR of the PJX5? a. The PJX5 will cost $2.16 million fully installed and has a 10 year life. It will be depreciated to a book value of $203,406.00...
Caspian Sea Drinks is considering the purchase of a plum juicer – the PJX5. There is...
Caspian Sea Drinks is considering the purchase of a plum juicer – the PJX5. There is no planned increase in production. The PJX5 will reduce costs by squeezing more juice from each plum and doing so in a more efficient manner. Mr. Bensen gave Derek the following information. What is the IRR of the PJX5? a. The PJX5 will cost $1.97 million fully installed and has a 10 year life. It will be depreciated to a book value of $204,551.00...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT