Answered step by step
Verified Expert Solution
Question
1 Approved Answer
6. The purpose of this problem is to learn how to measure returns over time using excel and to illustrate the effects of portfolio formation.
6. The purpose of this problem is to learn how to measure returns over time using excel and to illustrate the effects of portfolio formation. Data You will conduct analyses on Apple Inc., Microsoft Inc., and International Business Machines Corp. with their historical monthly data. First, you need their monthly return data. Visit http://finance.yahoo.com. Enter "Apple" or its ticker symbol "AAPL" in the "Get Quotes" box Two Minute Quick answers to your personal finance questions! Then click on "Historical Data" (underlined in the screen shot below). Choose "MAX" for time period and click "DONE". Choose "Monthly" for frequency and click "Apply" and then Download Data Apple Inc. (AAPL) Add to watchlist NasdaqGS-NasdaqGS Delayed Price. Currencyin USD 140.64 0.28 (-0.20%) At close March 25 400PM EDT Historical Data THERE'S NO PLACE LIKE IT FIND OUT MORE Time Period Dec 12, 1980 Mar 27, 2017 Show Historical Prices v Frequency: Monthly Download Data Currency in USD Notice that Yahoo Finance provides "open", "High", "Low", "Close and "Adj. Close" for each month denoted by the first trading day of the month. For example, in the downloaded monthly series, "1/02/2017" sim ly means February 2017, not the first day of that month. In particular, Close and Adj. Close dated "1/02/2017" are based on the price at the end of February 2017, not at the beginning of February as the date might suggests. If in doubt, check the daily series to verify Keep Date and Adj. Close for all the months. Adjusted close prices are adjusted for dividend payments and are easier to compute monthly percentage returns with. In the third column, calculate monthly returns in percentage from the adjusted close prices. For example, 2017
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started