Solve the problem using excel formula

A B C D E F G H K L M N P-10: Underwriting spread (LO15-2) The Wrigley Corporation needs to raise $44 million. The investment banking firm of Tinkers, Evers, & Chance will handle the transaction. HINT: this is similar to P-8 If stock is utilized, 2,300,000 shares will be sold to the public at $20.50 per share. The corporation will receive a net price of $19 per share. What is the percentage underwriting spread per share? b. If bonds are utilized, slightly over 43,700 bonds will be sold to the public at $1,009 per bond. The corporation will receive a net price of $994 per bond. What is the percentage of underwriting spread per bond? (Relate the dollar spread to the public price.) C. Which alternative has the larger percentage of spread? Is this the normal relationship between the two types of issues? IN Given: Offer Public Net to On Own Size Price Firm Spread Amt Spread % A a ) 2,300,000 20.50 19.00 b ) 43,700 1,009.00 994.00 C ) V 00 P-11: Secondary offering (LO15-2) Kevin's Bacon Company Inc. has earnings of $9 million with 2,100,000 shares outstanding before a public distribution. Seven hundred thousand shares will be included in the sale, of which 400,000 are new corporate shares, and 300,000 are shares currently owned by Ann Fry, the founder and CEO. The 300,000 shares that Ann is selling are referred to as a secondary offering, and all proceeds will go to her. The net price from the offering will be $16.50, and the corporate proceeds are expected to produce $1.8 million in corporate earnings. HINT: this is similar to P-4 a. What were the corporation's earnings per share before the offering? b . What are the corporation's earnings per share expected to be after the offering? 9 10 Given: Shares Additional New Shares On Own 11 Outstanding Earnings EPS Issuance Outstanding Price 12 a) 2, 100,000 9,000,000 400,000 16.5 14 Additional Earnings (capital gains): 1,800,000 (given) 15 New Earnings Amount: 16 b) EPS if including share sales in the current period: 17