Question

Use the data for Starbucks (SBUX) and Google (GOOG) E to answer the following questions: a. What is the return for SBUX over the period without including its dividends? With the dividends? b. What is the return for GOOG over the period? c. If you have 25% of your portfolio in SBUX and 75% in GOOG, what was the return on your portfolio excluding dividends? a. What is the return for SBUX over the period without including its dividends? The return without the dividends is %. (Round to two decimal places.) With the dividends? The return with the dividends is %. (Round to two decimal places.) b. What is the return for GOOG over the period? The return is %. (Round to two decimal places.) c. If you have 25% of your portfolio in SBUX and 75% in GOOG, what was the return on your portfolio excluding dividends? The return of the portfolio is % (Round to two decimal places.)

pleasee help

Answer 1

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

DATA MISSING. I AM USING THE DATA WHICH I COLLECTED LAST TIME. IF ANY CHANGE, LET ME KNOW

NPV, IRR, PBP,OCF, INDEX - Microsoft Excel (Product Activation Failed) Page Layout Formulas File Home Insert Data Review View Add-Ins E AutoSum - Cut Wrap Text Calibri 11 General ECopy Fill Merge & Center Insert Delete Format Paste В IU- 000 Conditional Format Cell Sort & Find & % Format Painter Clear Filter Select Formatting as Table Styles Alignment Number Clipboard Font Styles Cells Editing fox AV1 AV AW АХ AY AZ ВА ВВ ВС BD ВЕ BF BG a 1 RETURN FROM NOV 14, 2011 TO DEC 13, 2012 STARBUCKS holding period return 2 dividend R (%) price 3 1+R 43.64 NOV 14, 2011 5 FEB 6, 2012 48.29 0 10.66% 1.10655362 MAY 7, 2012 6 55.48 0 14.89% 1.14889211 AUG 6, 2012 7 43.48 0 -21.63% 0.78370584 22.31% 1.22309 108 8 DEC 13, 2012 53.18 1.2186 [(BC5*BC6*BC7*BC8) 9 ТОTAL 10 ANS a (i 11 ETURN FOR THE TIRE PERIOD = 1.2186 - 1 0.2186 = 21.86% (WITHOUT DIVIDEND) 12 13 NOTE 14 HOLDING PERIOD RETURN =( P1 +D1 -PO)/PO*100 15 E.g., FOR FEB 06, HOLGING PERIOD RETURN = (48.29 +0.0-43.64)/43.64*100 16 17 RETURN FOR ENTIRE PERIOD = ( PRODUCT OF ALL (1 R) VALUES) 1 18 19 ARM, MSI,Confidence INDEX OCF CASH FLOW STATW GM HPR AMTAX GROWTH SUST LOAN CROSS OVER FCF PREF AND DIV POLICY CURRENCY HEDGING MONEY MARKET erences 130% WA XУ 06:23 ENG 30-10-2019

NPV, IRR, PBP,OCF, INDEX - Microsoft Excel (Product Activation Failed) Page Layout Formulas File Home Insert Data Review View Add-Ins E AutoSum - Cut Wrap Text Calibri 11 General Copy Fill Merge & Center Conditional Format Formatting as Table Styles Insert Delete Format Paste в IU* 090 Cell Sort & Find & % Format Painter Clear Filter Select Alignment Clipboard Font Number Styles Cells Editing fox AV37 AV AW AX AY AZ BА ВВ ВС BD ВЕ BF BG 19 20 RETURN FROM NOV 14, 2011 TO DEC 13, 2012 21 STARBUCKS holding period return 22 dividend R (%) price 23 1 R 24 NOV 14, 2011 43.64 48.29 25 FEB 6, 2012 0.17 11.04% 1.11044913 15.24% 1.15241251 26 MAY 7, 2012 55.48 0.17 -21.32% 0.78677001 27 AUG 6, 2012 43.48 0.17 DEC 13, 2012 28 53.18 0.21 22.79% 1.22792088 1.23630268 [BC25*BC26*BC27* BC28)] 29 TOTAL 30 ANS a (ii) RETURN FOR THE ENTIRE PERIOD 1.2363 - 1 0.2363 31 23.63% (WITH DIVIDEND) 32 33 34 35 36 37 HEDGING MONEY MARKET PREF AND DIV POLICY OCF CASH FLOW STATW LOAN CROSS OVER GM HPR AMTAX GROWTH SUST ARM, MSI,confidenceINDEX CURRENCY FCF erences 130% XУ 06:24 ENG 30-10-2019

NPV, IRR, PBP,OCF, INDEX - Microsoft Excel (Product Activation Failed) Formulas File Home Insert Page Layout Data Review View Add-Ins Z AutoSum Cut Wrap Text Calibri 11 General Copy Fill в IU Merge & Center Conditional Format Formatting as Table Styles Paste Cell Insert Delete Format Sort & Find & % KH Format Painter Clear Filter Select Alignment Number Clipboard Font Styles Cells Editing fox BD66 ВЕ AV AW AX AY AZ ВА ВВ ВС BD BF BG 49 RETURN FROM NOV 14, 2011 TO DEC 13, 2012 GOOGLE holding period return 50 dividend R (%) price 51 1+R 613 52 NOV 14, 2011 53 FEB 6, 2012 609.09 0 -0.64% 0.99362153 607.55 54 MAY 7, 2012 0 -0.25% 0.99747164 5.81% 1.05805284 55 AUG 6, 2012 642.82 0 56 DEC 13, 2012 659.05 2.52% 1.02524813 ТОTAL 1.0751 [-[ВC53*ВC54"ВC55*ВC56)] 57 58 ANS (b) RETURN FOR THE ENTIRE PERIOD 1.0751 - 1 0.0751 59 7.51% (WITHOUT DIVIDEND) 60 61 WITHOUT DIVIDEND 62 RETURN ON PORTFOLIO WEIGHTED RETURN (weight x return) STOCK WEIGHT 63 RETURN 64 STARBUCKS 25% 21.86% 5.47% GOOGLE 5.63% 65 75% 7.51% ANS (c) RETURN ON PORTFOLIO 66 11.10% 67 ARM, MSI,confidence INDEX GM HPR AMTAX GROWTH SUST OCF CASH FLOW STATW LOAN CROSS OVER FCF HEDGING MONEY MARKET PREF AND DIV POLICY CURRENCY erences 130% XУ 06:24 ENG 30-10-2019