Question

Using the data in the table to the​ right, calculate the return for investing in the stock from January 1 to December 31. Prices are after the dividend has been paid.

Date Price Dividend     Jan 1 $ 31.19$31.19 minus− Feb 5 $ 30.26$30.26 $ 0.19$0.19 May 14 $ 30.14$30.14 $ 0.19$0.19 Aug 13 $ 32.39$32.39 $ 0.17$0.17 Nov 12 $ 38.73$38.73 $ 0.19$0.19 Dec 31 $ 42.71$42.71 minus−

Return for the entire period is

Answer 1

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

NPV, IRR, PBP,OCF, INDEX - Microsoft Excel (Product Activation Failed) Page Layout Formulas File Home Insert Data Review View Add-Ins Z AutoSum Cut A A Wrap Text Calibri 11 General Copy Fill Merge & Center $ % Paste B I U 000 Conditional Format Cell Insert Delete Format Sort & Find & Format Painter Clear Filter Select Formatting as Table Styles Clipboard Font Alignment Number Styles Cells Editing fox AV251 Formula Bar A AN AO АР AQ AR AS AT AU AW AX 233 234 RETURN FROM JANUARY 1 TO DECEMBER 31 holding period return 235 1+R price dividend R (%) 236 DATE 237 Jan-01 31.19 Feb-05 -2.37% 0.97627 238 30.26 0.19 239 May-14 30.14 0.19 0.23% 1.00231 240 8.03% 1.08029 32.39 0.17 Aug-13 20.16% 1.20161 241 Nov-12 38.73 0.19 242 Dec-31 42.71 10.28% 1.10276 243 1.40075 (AT238*AT239*AT240*AT241* 244 ANSWER RETURN FOR THE ENTIRE PERIOD = 1.40075 - 1 40.07% 245 0.40075 = 246 247 NOTE 1 HOLDING PERIOD RETURN= (P1 +D1 -PO)/PO0*100 248 E.g., FOR FEB 05, HOLDING PERIOD RETURN = (30.26+ 0.19-31.19),/31.19 249 250 2 RETURN FOR ENTIRE PERIOD ( PRODUCT OF ALL (1 R) VALUES) - 1 251 ARM, MSI,confidence INDEX CURRENCY CROSS OVER HEDGING MONEY MARKET PREF AND DIV POLICY LOAN GM HPR AMTAX GROWTH SUST FCF OCF CASH FLOW STATW erences 130% WA 05:06 ENG 22-11-2019