In: Finance
A stock had the following trades during a particular period. What was the money flow for the stock? (Leave no cells blank - be certain to enter "0" wherever required. Input all amounts as positive values. Do not round intermediate calculations. Round your answers to the nearest whole dollar.)
Week | Day | Price | Volume | |||||
1 | Monday | $ | 91.42 | |||||
Tuesday | 91.38 | 2,700 | ||||||
Wednesday | 91.39 | 3,100 | ||||||
Thursday | 91.42 | 3,000 | ||||||
Friday | 91.41 | 3,150 | ||||||
2 | Monday | 91.44 | 1,100 | |||||
Tuesday | 91.45 | 1,600 | ||||||
Wednesday | 91.49 | 600 | ||||||
Thursday | 91.48 | 1,500 | ||||||
Friday | 91.50 | 3,300 | ||||||
Price | Up/Down | Price Times Volume | Positive Money Flow | Negative Money Flow | Net Money Flow |
$91.42 | |||||
91.38 | –selected answer correct | $246,726selected answer correct | $0selected answer correct | $(108)selected answer incorrect | |
91.39 | +selected answer correct | 283,309selected answer correct | 31selected answer incorrect | 0selected answer correct | |
91.42 | +selected answer correct | 274,260selected answer correct | 90selected answer incorrect | 0selected answer correct | |
91.41 | –selected answer correct | 287,942selected answer correct | 0selected answer correct | (32)selected answer incorrect | |
91.44 | +selected answer correct | 100,584selected answer correct | 33selected answer incorrect | 0selected answer correct | |
91.45 | +selected answer correct | 146,320selected answer correct | 16selected answer incorrect | 0selected answer correct | |
91.49 | +selected answer correct | 54,894selected answer correct | 24selected answer incorrect | 0selected answer correct | |
91.48 | –selected answer correct | 137,220selected answer correct | 0selected answer correct | (15)selected answer incorrect | |
91.50 | +selected answer correct | 301,950selected answer correct | 66selected answer incorrect | 0selected answer correct |
v
Price Times Volume = Price * Volume
Money Flow = (Current Day Price - Previous Day Price ) * Current Day's Volume
Net Money Flow is the cumulative positive or negative money flow.
The money flow is positive if the previous day's price was lower than current day's price and it is negative is previous day's price was higher than current day's price.
The answer to the above question is as follows :-
Day | Price | Volume | Up/Down | Price Times Volume | Positive Money Flow | Negative Money Flow | Net Money Flow |
Monday | $ 91.42 | ||||||
Tuesday | $ 91.38 | 2,700 | Down | $ 246,726 | $ - | $ 108 | $ (108) |
Wednesday | $ 91.39 | 3,100 | Up | $ 283,309 | $ 31 | $ - | $ (77) |
Thursday | $ 91.42 | 3,000 | Up | $ 274,260 | $ 90 | $ - | $ 13 |
Friday | $ 91.41 | 3,150 | Down | $ 287,942 | $ - | $ 32 | $ (19) |
Monday | $ 91.44 | 1,100 | Up | $ 100,584 | $ 33 | $ - | $ 14 |
Tuesday | $ 91.45 | 1,600 | Up | $ 146,320 | $ 16 | $ - | $ 30 |
Wednesday | $ 91.49 | 600 | Up | $ 54,894 | $ 24 | $ - | $ 54 |
Thursday | $ 91.48 | 1,500 | Down | $ 137,220 | $ - | $ 15 | $ 40 |
Friday | $ 91.50 | 3,300 | Up | $ 301,950 | $ 66 | $ - | $ 105 |