Examlex

Solved

A Specialty Hedge Fund Is Considering the Purchase of a Jackson

question 29

Essay

A specialty hedge fund is considering the purchase of a Jackson Pollock painting. It estimates the value of the painting to be $185 million. In an auction, both the number of competing bids and the amount of the competing bids is uncertain. The hedge fund has maintained a file summarizing 10 recent art auctions that it believes are similar to the upcoming auction. It is considering a bid of $163 million and would like to evaluate its chances of winning the upcoming auction with this bid.  Bid Amount (As Fraction of Estimated Share Value)  Company 123456710.8170.8840.75620.7710.8630.8250.8190.8510.78630.8040.8510.7860.85140.8800.7560.8740.8770.91050.8900.8040.8190.8600.8800.88060.8510.7860.8960.7840.7920.79270.8810.7860.8040.81980.8040.8190.8600.8800.7730.82490.8190.8960.8770.8600.7840.8190.880100.7560.8040.7860.7860.8190.885\begin{array}{|c|c|c|c|c|c|c|c|}\text { Bid Amount (As Fraction of Estimated Share Value) }\\\hline \text { Company } & \mathbf{1} & \mathbf{2} & \mathbf{3} & \mathbf{4} & \mathbf{5} & \mathbf{6} & \mathbf{7} \\\hline 1 & 0.817 & 0.884 & 0.756 & & & & \\\hline 2 & 0.771 & 0.863 & 0.825 & 0.819 & 0.851 & 0.786 & \\\hline 3 & 0.804 & 0.851 & 0.786 & & & 0.851 & \\\hline 4 & 0.880 & 0.756 & 0.874 & 0.877 & 0.910 & & \\\hline 5 & 0.890 & 0.804 & 0.819 & 0.860 & 0.880 & 0.880 & \\\hline 6 & 0.851 & 0.786 & 0.896 & 0.784 & 0.792 & 0.792 & \\\hline 7 & 0.881 & 0.786 & 0.804 & 0.819 & & & \\\hline 8 & 0.804 & 0.819 & 0.860 & 0.880 & 0.773 & & 0.824 \\\hline 9 & 0.819 & 0.896 & 0.877 & 0.860 & 0.784 & 0.819 & 0.880 \\\hline 10 & 0.756 & 0.804 & 0.786 & 0.786 & 0.819 & 0.885 & \\\hline\end{array}
a. Construct a spreadsheet simulation model for this auction. Use a discrete uniform distribution between the minimum and maximum number of bidders in the 10 observed auctions to model the number of bidders in the Jackson Pollock auction. Fit a realistic distribution to the bid data to generate values of competing bid amounts. Use ASP to apply simulation optimization to determine the hedge fund's bid amount that maximizes the expected return = P(winning auction)*(185 - bid amount). Hint: Placing reasonable bounds on the highest and lowest possible bid amount will greatly assist the optimization algorithm.
b. What is the probability that the hedge fund wins the auction if it bids the amount that maximizes its expected return?


Definitions:

Monthly Income

A measure of the total earnings or revenue generated by an individual, household, or entity within a month.

Hamburger

A popular food item consisting of a cooked patty of ground meat, typically beef, placed inside a sliced bun, often served with various condiments and toppings.

Price

The price one must pay to acquire a good or service.

Opportunity Cost

The cost of foregoing the next best alternative when making a decision.

Related Questions