In: Finance
You are given the following information concerning the trades made on a particular stock. Calculate the money flow for the stock based on these trades. (Leave no cells blank - be certain to enter "0" wherever required. A negative value should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest whole dollar.)
Price | Volume | |||||
$ | 59.96 | |||||
59.97 | 3,500 | |||||
59.95 | 3,000 | |||||
59.94 | 3,400 | |||||
58.95 | 3,550 | |||||
60.23 | 4,300 | |||||
60.14 | 4,600 | |||||
Price | Up/Down | Volume | Price * Volume | Positive money flow | Negative money flow | Net money flow |
---|---|---|---|---|---|---|
59.96 | ||||||
59.97 | Up | 3500 | 209,895 | 209895 | ||
59.95 | down | 3000 | 179,850 | 179850 | ||
59.94 | down | 3400 | 203,796 | (179850 + 203796) = 383646 | ||
58.95 | down | 3550 | 209,273 | (383646 + 209,273) = 592919 | ||
60.23 | Up | 4300 | 258,989 | (209895 + 258989) = 468884 | ||
60.14 | down | 4600 | 276,644 | (592919 + 276644) = 869563 | ||
Money flow at the end of the day | (468884 - 869563) = -$400679 |