use excel & show all excel formulas to show work

LO3 15.5 LO3 15.6 IPO Pricing The Zipcar IPO was underpriced by about 56 percent. Should Zipcar be upset at Goldman over the underpricing? IPO Pricing In the previous question, how would it affect your thinking to know that the company was incorporated about 10 years earlier, had only $186 million in revenues in 2010, and had never earned a profit? Additionally, the viability of the company's business model was still unproven. IPO Pricing In the previous two questions, how would it affect your thinking to know that in addition to the 9.68 million shares offered in the IPO, Zipcar had an additional 30 million shares outstanding? Of those 30 million shares, 14.1 million shares were owned by four venture capital firms, and 15.5 million shares were owned by the 12 directors and executive officers. LO3 15.7 LO3 15.5 LO3 15.6 IPO Pricing The Zipcar IPO was underpriced by about 56 percent. Should Zipcar be upset at Goldman over the underpricing? IPO Pricing In the previous question, how would it affect your thinking to know that the company was incorporated about 10 years earlier, had only $186 million in revenues in 2010, and had never earned a profit? Additionally, the viability of the company's business model was still unproven. IPO Pricing In the previous two questions, how would it affect your thinking to know that in addition to the 9.68 million shares offered in the IPO, Zipcar had an additional 30 million shares outstanding? Of those 30 million shares, 14.1 million shares were owned by four venture capital firms, and 15.5 million shares were owned by the 12 directors and executive officers. LO3 15.7