Question

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.) Volume Price $38.30 30.32 30.30 38.29 29.30 30.42 30.33 3.900 3.400 3.800 3.950 4.700 5.000 Up/Down Price Times Volume Positive Money Negative Money Flow Flow Net Money Flow Price $ 30 30 30 32 30.30 29 30 30 33 Money fow at the end of the day

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

- 2x BG NPV, IRR, PBP,OCFINDEX - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Add-Ins % Cut Σ AutoSum : A Calibri 11 A A = = = V Wrap Text General Ea Copy Fill 2 m Paste B I U Format Painter - D A Merge & Center $ - % Conditional Format 8. Cell Insert Delete Format Sort & Find & Formatting as Table Styles 2 Clear Filter Select Clipboard Font Alignment Number Styles Cells Editing BE110 - for L AV AW AX AY AZ BA BB BC BD BE BE 109 110 111 112 113 114 PRICE UP/DOWN VOLUME PRICE TIMES POSITIVE MONEY NEGATIVE MONEY NET MONEY 115 VOLUME FLOW FLOW FLOW 116 A*B 117 30.30 30.32 3900 118248 118248 119 3400 103020 103020 120 30.29 3800 115102 218122 <------ (103020 + 115102] 121 29.3 3950 115735 333857 <------ [218122 + 115735] 122 30.42 4700 142974 261222 <------ [118248 +142974] 123 30.33 5000 151650 485507 <---------- (333857+151650] 124 125 MONEY FLOW AT THE END OF THE DAY -224285 <------ [261222 - 485507] 126 127 O CF CASH FLOW STATW FCFARM, MSI,confidenceINDEX CURRENCY LOAN CROSS OVER HEDGING MONEY MARKET GM HPR AM TAX GROWTH SUST PREF AND DIV POLICY I Red ferences DOI 130% - ODOB 9 * ENG 118 + 30.3 1 + 1 H O- 31-10-2019