Explore BrainMass

# Enter formulas to calculate the requirements of this problem

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Enter formulas to calculate the requirements of this problem.

a. What is the average underpricing of this sample of IPOs?
Average underpricing FORMULA

b. What is the average initial return on my "portfolio" of shares purchased from the four IPOs I bid on?
Calculate the average initial return weighting by the amount of money invested in each issue.

Investment Initial
(Shares x price) Return Profit
A FORMULA 7% FORMULA
B FORMULA 12% FORMULA
C FORMULA -2% FORMULA
Total \$0 \$0

Average return FORMULA

c. Why have I performed so poorly relative to the average initial return on the full sample of IPOs? What lessons do you draw from my experience?

© BrainMass Inc. brainmass.com March 4, 2021, 7:38 pm ad1c9bdddf
https://brainmass.com/business/finance/enter-formulas-to-calculate-the-requirements-of-this-problem-113914

#### Solution Summary

The solution provides detailed explanations and discussions in the attached Excel file for the problem.

\$2.49