Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

PRICE DATA: 10 STOCKS AND SP500, 2015-2020 SP500 represented by Vanguard's Index 500 fund (includes dividends) 1 2 3 4 5 6 7 8 9

"PRICE DATA: 10 STOCKS AND SP500, 2015-2020 SP500 represented by Vanguard's Index 500 fund (includes dividends)" 1 2 3 4 5 6 7 8 9 10 11 Apple Google Amazon Seagate Comcast Merck Johnson-Johnson General Electric Hewlett Packard Goldman Sachs SP500 Date AAPL GOOG AMZN STX CMCSA MRK JNJ GE HPQ GS GSPC 1-Jan-20 308.78 1,434.23 2,008.72 56.08 42.99 84.74 147.93 12.44 21.12 236.31 3,225.52 1-Dec-19 292.95 1,337.02 1,847.84 57.92 44.76 89.59 144.95 11.14 20.18 228.53 3,230.78 1-Nov-19 265.82 1,304.96 1,800.80 58.10 43.94 85.88 135.68 11.25 19.72 218.77 3,140.98 1-Oct-19 247.43 1,260.11 1,776.66 56.49 44.40 85.36 130.30 9.96 17.06 210.89 3,037.56 1-Sep-19 222.77 1,219.00 1,735.91 51.74 44.66 82.37 127.68 8.91 18.43 204.82 2,976.74 1-Aug-19 206.84 1,188.10 1,776.29 48.29 43.85 84.62 125.73 8.23 17.81 200.28 2,926.46 1-Jul-19 211.10 1,216.68 1,866.78 44.54 42.56 81.21 127.55 10.42 20.49 216.21 2,980.38 1-Jun-19 196.12 1,080.91 1,893.63 44.68 41.68 81.51 136.42 10.46 20.08 193.50 2,941.76 1-May-19 172.81 1,103.63 1,775.07 39.68 40.42 77.00 127.59 9.40 18.05 178.43 2,752.06 1-Apr-19 198.08 1,188.48 1,926.52 45.82 42.69 76.51 137.36 10.13 19.27 201.34 2,945.83 1-Mar-19 187.50 1,173.31 1,780.75 44.81 39.21 80.30 135.99 9.94 18.61 187.72 2,834.40 1-Feb-19 170.18 1,119.92 1,639.83 43.57 37.92 78.49 132.05 10.34 18.90 191.56 2,784.49 1-Jan-19 163.59 1,116.37

find the return data

RETURN DATA
Date AAPL GOOG AMZN STX CMCSA MRK JNJ GE HPQ GS SP500
1/Jan/20
1/Dec/19
1/Nov/19
1/Oct/19
1/Sep/19
1/Aug/19
1/Jul/19
1/Jun/19
1/Apr/15
1/Mar/15
1/Feb/15

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Human Resource Management Text And Cases

Authors: Tom Redman, Adrian Wilkinson

4th Edition

0273757822, 9780273757825

Students also viewed these Finance questions

Question

=+d. Derive the IRR of each project.

Answered: 1 week ago

Question

=+c. Calculate the NPV of each project at 9%.

Answered: 1 week ago