show work in excel with formuals. thank you

better picture

zebra stripes would like to sell 400 shares of atock using the dutch auction method. the bids recieved were bidder A 200 shares at $28, bidder B 300 shares at $27, bidder C 500 shares at $26 and bidder D 400 shares at $25. how much will bidder b have to pay to purchase her allocated shares?

show work in excel with formulas.

105 11. Zebra Stripes would like to sell 100shares of stack using the Dutch action method. The kids reached wireler A. 200 shares at $28: Bilder , 300 shares at $27; Bidder C, 500 shares at SM, and 10 der Dhares 25. How much will Bilder Bhave to pay to purchase her allocated shares? 200 300 500 400 5.26 528 200 500 1000 1000 02857146 E116 > Yield semiannually coup freg pent aper 3.20% divide semi 2 $29.50 2.099765123 104 2.100 22. Zebra Stripes would like to sell 400 shares of stock using the Dutch auction method. The bids received were Bidder A, 200 shares at $28: Bidder B, 300 shares at $27; Bilder C, 500 shares at $26; and Bilder D, 400 shares at $25. How much will Bidder B have to pay to purchase her allocated shares? 102 la 200 200 ib 300 $27 500 le 500 $26 1000 111 d 400 $25 1400 112 0.285714286 113 115 116 118 23. Firm A has a market value of $318,000 while Firm B's market value is $69.000. Firm A just acquired Firm for $75,000 cash. What is the net present value of the acquisition if the merper creates 119 $15.500 of synergy 120 121 12 125 120 24. Morze is considering adding more retail space in the deli, which will require some remodeling. The remodeling and shelving costs are estimated to be $13.900. Retail sales are expected to produce et 131 cash ws of $8,400, 512.900, 519,000, and $16.500 in the coming for years, respectively. What is the payback period for this investment? GradeSummary MultipleChoice ShortAnswer Ratios and MACRS Tables Ready C Accessibility Investigate DET Type here to search RE DLL