5. The IPO Database

The file IPOdata.xlsx contains raw data on 78 IPOs (Initial Public Offerings of stock) issued between 1994 and 1999. Copy this database to a clean worksheet and use it to answer the following questions.

a. What is the average revenue, by underwriter, for the IPO year (REV IPO YR-0) and for the following year (REV IPO YR-1)?

Average Revenue

Underwriter YR-0 YR-1

b. What was the net income in the IPO year (NI IPO YR-0) for the five smallest IPOs in terms of the number of employees?

Net Income

1

2

3

4

5

c. Among IPOs issued in 1999, which one had the largest difference between the high and low ranges as a percent of the actual price?

d. How many IPOs were issued by either Chase or Goldman in 1996?

% IPOdata Home Insert Draw Page Layout Formulas Data Review View Tell me ||| Share = = = === EE E Merge & Centre Delete v%, 6 % Bilv v tv av Open recovered workbooks? Your 13 EEE - : EEN w3ssEHY . %=:us =EH; news 132 4 Hr 2 tsEHDPHEET BUwa%E5TH HSM"sna & T EN d_us a su:mvbbs... Nis besiu- go wuwan :g 3g w=8mm:======== : : g",use 2.2.9_ - PC_ * EN 1 IPOdata ||| Share * w Home Insert Draw Page Layout Formulas Data Review View Tell me Wraa Text Bilv v tv av = = = = Merge & Centre Open recovered workbooks? Your recent che Insert * conoma , v TIER 6 % Sandalina Format FASE FIN ==,2E%H:manins RPPXBRUSEEN 2."!?"E"w":""n mmms.sun% : a : e . ang so a gas paus 8M 3G= = . id::: jani Bu an Me 2 *12mmar: "",:a | % IPOdata Home Insert Draw Page Layout Formulas Data Review View Tell me ||| Share = = = === EE E Merge & Centre Delete v%, 6 % Bilv v tv av Open recovered workbooks? Your 13 EEE - : EEN w3ssEHY . %=:us =EH; news 132 4 Hr 2 tsEHDPHEET BUwa%E5TH HSM"sna & T EN d_us a su:mvbbs... Nis besiu- go wuwan :g 3g w=8mm:======== : : g",use 2.2.9_ - PC_ * EN 1 IPOdata ||| Share * w Home Insert Draw Page Layout Formulas Data Review View Tell me Wraa Text Bilv v tv av = = = = Merge & Centre Open recovered workbooks? Your recent che Insert * conoma , v TIER 6 % Sandalina Format FASE FIN ==,2E%H:manins RPPXBRUSEEN 2."!?"E"w":""n mmms.sun% : a : e . ang so a gas paus 8M 3G= = . id::: jani Bu an Me 2 *12mmar: "",:a |