1.) 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?

2.) 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 $45. The strike price of the option is $40. The option matures in 6 months (t = 0.5). The standard deviation of the stock's returns is 0.50, and the variance is 0.25. The risk-free rate is 5%. Using the Black-Scholes model, what is the value of the call option?

Need the excel solutions