Question

Problem 8-11 Money Flow (LO4, CFA1) 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 1 Volume Day Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday Price $61.85 61.81 61.82 61.85 61.84 61.87 61.88 61.92 61.91 61.93 1,000 1,400 1,300 800 1,100 1,400 600 1,200 1,600 Price Up/Down Price Times Volume Positive Money Flow Negative Money y Net Money Flow Flow $ 61.85 61.81 61.82 61.85 61.84 61.87 61.88 61.92 61.91 61.93 Money flow at the end of the day

Answer 1

1	2	3	4=2*3	5	6	7
Price ($)	Up/Down(Current-Previous)	Volume	Price diff. *Volume	+ve money flow	-ve money flow	Net money flow
61.85
61.81	-0.04	1000	-40		-40	-40
61.82	0.01	1400	14	14		14
61.85	0.03	1300	39	39		39
61.84	-0.01	800	-8		-8	-8
61.87	0.03	1100	33	33		33
61.88	0.01	1400	14	14		14
61.92	0.04	600	24	24		24
61.91	-0.01	1200	-12		-12	-12
61.93	0.02	1600	32	32		32
			Money flow at end of period			96