Question: Please show your work in Microsoft Excel . Below is a sample problem for reference. 2. Chen Brothers, Inc., sold 4 million shares in its

Please show your work in Microsoft Excel. Below is a sample

Please show your work in Microsoft Excel.

Below is a sample problem for reference.

problem for reference. 2. Chen Brothers, Inc., sold 4 million shares in

2. Chen Brothers, Inc., sold 4 million shares in its IPO, at a price of $18.50 per share. Management negotiated a fee (the underwriting spread) of 7% on this transaction. What was the dollar cost of this fee? The cost of the underwriter fees was } million. (Round to two decimal places.) To calculate the total dollar value of the IPO, use the following formula: IPOValue=PriceperShareNumberofShares Therefore, IPOValue=$19.15pershare7millionshares=$134.1million The total dollar value of the IPO was $134.1 million. To determine the cost of the underwriter fees, use the following formula: Underwriting Fees = IPO Value Underwriter Spread Therefore, Underwriting Fees =$134.1 million 0.102=$13.68 million The cost of the underwriter fees was $13.68 million

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!

Please show your work in Microsoft Excel . Below is a sample problem for reference. 1. Wallace Publishing recently completed its IPO. The stock was offered at $13.88 per share. On the first day of...

Please show your work in Microsoft Excel . Below is a sample problem for reference. percentage ownership of the firm after the IPO? If all of the shares sold are primary shares, the firm will raise $...

Please show your work in Microsoft Excel . Below is a sample problem for reference. percentage ownership of the firm after the IPO? If all of the shares sold are from your holdings, (Select the best...

Please show your work in Microsoft Excel . Below is a sample problem for reference. 9. Roundtree Software is going public using an auction IPO. The firm has received the following bids: Assuming...

Please show your work in Microsoft Excel . Below is a sample problem for reference. 20. Your investment bankers price your IPO at $15.43 per share for 9.7 million shares. If the price at the end of...

Please see attached. Please show your work. Thanks Please Show Your Work Accounting for Bonds Sold at a Discount The Biltmore National Bank raised capital through the sale of $100 million face value...

Case Breeder's Own Pet Foods, Inc. In January 2011, Breeder's Own Pet Foods, Inc. executives looked forward to their meeting with representatives of Marketing Momentum Unlimited, a market- ing and...

Hi Ruchi, I need help with the attached assignment. It's due in about a week. Thanks 1) The paper should be written in APA style Research Paper format. This is the link that explains the research...

Gordon Manufacturing started 2014 with the following account balances. Cash ..................... $3,500 Common stock ................. 2,800 Retained earnings ................ 1,400 Raw materials...

On December 1, Diaz Company introduces a new product that includes a one-year warranty on parts. In December, 1,000 units are sold. Management believes that 5% of the units will be defective and that...

a stock had returns of 1 8 . 0 8 % , - 5 . 2 8 % , 2 0 . 5 1 % , and 8 . 6 9 % for the last 4 years. what is the variance of the returns

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

to encourage a drive for change by developing new ideas;

4 What are the alternatives to the competences approach?

2 What different concepts and approaches are used in countries with dissimilar cultures?