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. Suppose you believe that Johnson Company's stock price is going to increase from its current level of $22.50sometime during the next 5 months. For $310.25 you can buy a 5-month call option giving you the right to buy 100 shares at a price of $25 per share. If you buy this option for $310.25 and Johnson's stock price actually rises to $45, what would your pre-tax net profit be?

Need the excel solutions for these.