Complete Study Problem 13-5 from the end of Chapter 13 of the text and submit to your instructor. Clearly label the calculation of the required ratios and solve using Excel. Use formulas to calculate the ratios and format the cells to insert a comma if there is more than three numbers. Round dollar amounts to the nearest whole dollar. Summarize your analysis in a concise management statement not to exceed 100 words.
13-5. (Flotation costs and issue size) D. Butler Inc. needs to raise $14 million. Assuming that the market price of the firm's stock is $95, and flotation costs are 10 percent of the market price, how many shares would have to be issued? What is the dollar size of the issue?