Complete the problems using excel formula Show all work (display all the variables used in your formulas, and or detail all steps used in determining the calculation) Raybac is about to go public Its present stockholders own 550,000 shares The new public issue will represent 930,000 shares The shares will be priced at $40 to the public with a 16 spread The out of pocket costs in addition to the spread will be $530,000 What are the net proceeds to Raybac 2 Maxwell Corp is coming to the market with a new offering of 450,000 shares of stock at $22 to the public Maxwell will receive $19 per share The firm has one million shares outstanding and earnings of $6 million before recording the new issue What is the amount of earnings per share after the stock issuance

The Answer is in the image, click to view ...

Question: Complete the problems using excel formula. Show all work (display all the variables used in your formulas, and/or detail all steps used in determining the

Complete the problems using excel formula. Show all work (display all the variables used in your formulas, and/or detail all steps used in determining the calculation)

Raybac is about to go public. Its present stockholders own 550,000 shares. The new public issue will represent 930,000 shares. The shares will be priced at $40 to the public with a 16% spread. The out-of-pocket costs in addition to the spread will be $530,000. What are the net proceeds to Raybac?

2. Maxwell Corp. is coming to the market with a new offering of 450,000 shares of stock at $22 to the public. Maxwell will receive $19 per share. The firm has one million shares outstanding and earnings of $6 million before recording the new issue. What is the amount of earnings per share after the stock issuance?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Complete the problems using excel formula. Show all work (display all the variables used in your formulas, and/or detail all steps used in determining the calculation) 1. How much must you invest at...

Complete the problems using Excel formula. Show all work (display all the variables used in your formulas, and/or detail all steps used in determining the calculation) How much must you invest at 7%...

Complete the problems using excel formula. Show all work (display all the variables used in your formulas, and/or detail all steps used in determining the calculation) A firm recently issued bonds...

Ch15-1: Raybac is about to go public. Its present stockholders own 550,000 shares. The new public issue will represent 930,000 shares. The shares will be priced at $40 to the public with a 16%...

please provide answer clearly in table or excel Ch9-1: How much must you invest at Thinterest in order to see your investment grow to $15,000 in 9 years? Show all work (display all the variables used...

Ch9-1: How much must you invest at 7% interest in order to see your investment grow to $15,000 in 9 years? Show all work (display all the variables used in your formulas, and/or detail all steps used...

Ch10-1: A 10-year bond, with a par value equaling $1,000, pays 7% annually. If similar bonds are currently yielding 6% annually, what is the market value of the bond? Use semi-annual analysis. Show...

Ch11-1: The coupon rate on an issue of debt is 11%. The yield to maturity on this issue is 11%. The corporate tax rate is 34 s. What would be the approximate after-tax cost of debt for a new issue of...

If Excel Inc. has projected sales of $30,000 in January, $20,000 in February, and $20,000 in March, where 20% of sales are cash sales and the remaining (80%) credit sales are collected the month...

1 2345 6 7 8 A B E F H Ch4-2: If Excel Inc. has projected sales of $30,000 in January, $20,000 in February, and $20,000 in March, where 20% of sales are cash sales and the remaining (80%) credit...

Some parallel database systems store an extra copy of each data item on disks attached to a different processor, to avoid loss of data if one of the processors fails. a. Why is it a good idea to...

Making presentations is a skill that is expected of all managers in organizations today. Whether you'll be presenting an organization's quarterly earnings to a Board, arguing on behalf of a new...

Who is MOST Likely to be depressed?O a 1 0 0 - year - old who is married with dose friendsO a 7 0 - year - old who has never mariedO a 6 5 year - old who has just retredO a 9 0 - year - old who is...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...