need answers done in excl file

The current price of a stock is $50, the annual risk-free rate is 6%, and a 1-year call option with a strike price of $55 sells for $7.20. What is the value of a put option, assuming the same strike price and expiration date as for the call option?

The current price of a stock is $22, and at the end of one year its price will be either $27 or $17. The annual risk-free rate is 6.0%, based on daily compounding. A 1-year call option on the stock, with an exercise price of $22, is available. Based on the binominal model, what is the option's value?

Weaver Chocolate Co. expects to earn $3.50 per share during the current year, its expected dividend payout ratio is 65%, its expected constant dividend growth rate is 6.0%, and its common stock currently sells for $32.50 per share. New stock can be sold to the public at the current price, but a flotation cost of 5% would be incurred. What would be the cost of equity from new common stock?

Assume that Kish Inc. hired you as a consultant to help estimate its cost of common equity. You have obtained the following data: D0= $0.90; P0 = $27.50; and g = 7.00% (constant). Based on the DCF approach, what is the cost of common from retained earnings?

Eakins Inc.’s common stock currently sells for $45.00 per share, the company expects to earn $2.75 per share during the current year, its expected payout ratio is 70%, and its expected constant growth rate is 6.00%. New stock can be sold to the public at the current price, but a flotation cost of 8% would be incurred. By how much would the cost of new stock exceed the cost of common from retained earnings?

Rivoli Inc. hired you as a consultant to help estimate its cost of common equity. You have been provided with the following data: D0 = $0.80; P0 = $22.50; and g = 8.00% (constant). Based on the DCF approach, what is the cost of common from retained earnings?

O'Brien Inc. has the following data: rRF = 5.00%; RPM = 6.00%; and b = 1.05. What is the firm's cost of common from retained earnings based on the CAPM?

Several years ago the Jakob Company sold a $1,000 par value, noncallable bond that now has 20 years to maturity and a 7.00% annual coupon that is paid semiannually. The bond currently sells for $925 and the company’s tax rate is 40%. What is the component cost of debt for use in the WACC calculation?

S. Bouchard and Company hired you as a consultant to help estimate its cost of common equity. You have obtained the following data: D0= $0.85; P0 = $22.00; and g = 6.00% (constant). The CEO thinks, however, that the stock price is temporarily depressed, and that it will soon rise to $40.00. Based on the DCF approach, by how much would the cost of common from retained earnings change if the stock price changes as the CEO expects?

An analyst wants to use the Black-Scholes model to value call options on the stock of Ledbetter Inc. based on the following data:

The price of the stock is $40.
The strike price of the option is $40.
The option matures in 3 months (t = 0.25).
The standard deviation of the stock’s returns is 0.40, and the variance is 0.16.
The risk-free rate is 6%.

Given this information, the analyst then calculated the following necessary components of the Black-Scholes model:

d1 = 0.175
d2 = -0.025
N(d1) = 0.56946
N(d2) = 0.49003

N(d1) and N(d2) represent areas under a standard normal distribution function. Using the Black-Scholes model, what is the value of the call option?

Bolster Foods’ (BF) balance sheet shows a total of $25 million long-term debt with a coupon rate of 8.50%. The yield to maturity on this debt is 8.00%, and the debt has a total current market value of $27 million. The balance sheet also shows that the company has 10 million shares of stock, and the stock has a book value per share of $5.00. The current stock price is $20.00 per share, and stockholders' required rate of return, rs, is 12.25%. The company recently decided that its target capital structure should have 35% debt, with the balance being common equity. The tax rate is 40%. Calculate WACCs based on book, market, and target capital structures. What is the sum of these three WACCs?

Keys Printing plans to issue a $1,000 par value, 20-year noncallable bond with a 7.00% annual coupon, paid semiannually. The company's marginal tax rate is 40.00%, but Congress is considering a change in the corporate tax rate to 30.00%. By how much would the component cost of debt used to calculate the WACC change if the new tax rate was adopted?

You were recently hired by Scheuer Media Inc. to estimate its cost of common equity. You obtained the following data: D1 = $1.75; P0 = $42.50; g = 7.00% (constant); and F = 5.00%. What is the cost of equity raised by selling new common stock?

Assume that you are on the financial staff of Vanderheiden Inc., and you have collected the following data: The yield on the company’s outstanding bonds is 7.75%; its tax rate is 40%; the next expected dividend is $0.65 a share; the dividend is expected to grow at a constant rate of 6.00% a year; the price of the stock is $15.00 per share; the flotation cost for selling new shares is F = 10%; and the target capital structure is 45% debt and 55% common equity. What is the firm's WACC, assuming it must issue new stock to finance its capital budget?

Bosio Inc.'s perpetual preferred stock sells for $97.50 per share, and it pays an $8.50 annual dividend. If the company were to sell a new preferred issue, it would incur a flotation cost of 4.00% of the price paid by investors. What is the company's cost of preferred stock for use in calculating the WACC?

Rivoli Inc. hired you as a consultant to help estimate its cost of common equity. You have been provided with the following data: D0 = $0.80; P0
= $22.50; and g = 8.00% (constant). Based on the DCF approach, what is the cost of common from retained earnings?