The following information is for the next 4 questions Copy the following limit order book to Excel and answer the questions below. Bid and ask size are in units of 100. Bid Ask Size Bid Size 4 1 1 4 8 $24.44 $23.64 $23.28 $22.98 $22.72 $22.42 $21.79 7 10 Ask $25.16 $25.69 $26.37 $26.95 $27.11 $27.22 $28.06 5 4 3 9 9 9 9 Please answer the following 4 questions AND upload an excel spreadsheet with your calculations. An investor with $50,000 places a market buy order. What is the value weighted average price (VWAP)? O A. $25.06 B. $26.35 O C. $21.79 OD. $22.44 Question 15: The best bid is: O A. $21.79 O B. $25.16 $ O C. $24.44 OD. $28.06 The absolute and relative spread are: A. $2.15 (absolute) and 4.91% (relative) B. $0.72 (absolute) and 2.91% (relative) O C. $0.72 (absolute) and 4.91% (relative) ) ( O D.52.15 (absolute) and 2.9196 (relative) What would be the price impact (relative to the best ask)? O A. 4.7696 B. 6.8196 O C. 2.5296 OD. 1.1396 The following information is for the next 4 questions Copy the following limit order book to Excel and answer the questions below. Bid and ask size are in units of 100. Bid Ask Size Bid Size 4 1 1 4 8 $24.44 $23.64 $23.28 $22.98 $22.72 $22.42 $21.79 7 10 Ask $25.16 $25.69 $26.37 $26.95 $27.11 $27.22 $28.06 5 4 3 9 9 9 9 Please answer the following 4 questions AND upload an excel spreadsheet with your calculations. An investor with $50,000 places a market buy order. What is the value weighted average price (VWAP)? O A. $25.06 B. $26.35 O C. $21.79 OD. $22.44 Question 15: The best bid is: O A. $21.79 O B. $25.16 $ O C. $24.44 OD. $28.06 The absolute and relative spread are: A. $2.15 (absolute) and 4.91% (relative) B. $0.72 (absolute) and 2.91% (relative) O C. $0.72 (absolute) and 4.91% (relative) ) ( O D.52.15 (absolute) and 2.9196 (relative) What would be the price impact (relative to the best ask)? O A. 4.7696 B. 6.8196 O C. 2.5296 OD. 1.1396