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 $ million. (Round to one decimal place.) Your percentage ownership of the firm after the IPO will be \%. (Round to one decimal place.) percentage ownership of the firm after the IPO? To calculate the amount the firm will raise, multiply the number of shares sold by the selling price. Therefore, Amount Raised =4 million $24.50=$98.0 million If the firm sells 4 million primary shares at $24.50 each, the firm will raise $98.0 million. The total number of shares outstanding after the IPO will be 22 million. To determine the percentage that you own, use the following formula: YourOwnership=TotalNumberofSharesNumberofSharesYouOwn Therefore, YourOwnership=22millionshares9millionshares=0.409 Your percentage ownership of the firm after the IPO will be 40.9%