Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
ticker direction quantity price YHOO US B 100 18.73 YHOO US B 20 18.8 C US S 200 34.56 YHOO US B 100 18.61 FB
| ticker | direction | quantity | price |
| YHOO US | B | 100 | 18.73 |
| YHOO US | B | 20 | 18.8 |
| C US | S | 200 | 34.56 |
| YHOO US | B | 100 | 18.61 |
| FB US | S | 200 | 27.39 |
| BAC US | B | 100 | 9.81 |
| AAPL US | S | 50 | 589.01 |
| ORCL US | S | 100 | 32.39 |
| ORCL US | S | 200 | 32.349 |
| BAC US | B | 444 | 9.825 |
| C US | S | 200 | 34.28 |
| GRPN US | B | 400 | 4.12 |
| BAC US | B | 100 | 9.79 |
| FB US | B | 100 | 27.75 |
| FB US | B | 100 | 27.12 |
| BAC US | S | 15 | 9.81 |
| AAPL US | S | 25 | 589.08 |
| EBAY US | B | 100 | 52.62 |
| YHOO US | S | 400 | 18.62 |
| AAPL US | B | 100 | 589.05 |
| AAPL US | S | 10 | 589.08 |
| BAC US | S | 17 | 9.8 |
| DELL US | S | 1452 | 10.17 |
| AAPL US | S | 88 | 589 |
| GRPN US | B | 1000 | 4.23 |
| FB US | B | 100 | 27.74 |
| C US | B | 100 | 34.28 |
| BAC US | B | 100 | 9.88 |
| C US | S | 100 | 34.37 |
| FB US | B | 600 | 27.74 |
| AAPL US | S | 100 | 588.9 |
| MSFT US | B | 500 | 26.75 |
| AAPL US | S | 20 | 589.08 |
| GRPN US | S | 100 | 4.19 |
| BAC US | S | 1800 | 9.829 |
| MSFT US | S | 100 | 26.62 |
| YHOO US | S | 200 | 18.73 |
| GRPN US | S | 100 | 4.14 |
| BAC US | B | 100 | 9.855 |
| AAPL US | S | 25 | 589.08 |
| BAC US | B | 1000 | 9.81 |
Directions: Answer the questions below using Excel formulas (e.g. VLOOKUP, SUMIFS, etc). 1) What is the total market value of all the trades that are buying BAC US? 2) What is the volume-weighted average price of all buys in FB US?
Show formulas please and thank you!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started