Question: use Yahoos current data on apple stock... solve in excel 2, a. Using information from Yahoo! Finance, calculate the average annual return and standard deviation

use Yahoos current data on apple stock... solve in excel

2, a. Using information from Yahoo! Finance, calculate the average annual return and standard deviation of annual returns for the past 10 years (Dec 31 - Dec 31) for Apple stock. Note: Use "adjusted close" to account for dividends. b. What compound annual return is equivalent to the return on Apple stock that you calculated in part a? Note: For problem 2, you will need to get the data by clicking on the link called "Historical Prices" and selecting "Daily Prices". Page down ntil you see "Download to Spreadsheet" and open the file. This will be a CSV (comma-separated) file, so I recommend copying and pasting the entire sheet into a regular Excel workbook. I would then use the VLOOKUP function to help you find the relevant year-end data. Two complications when identifying year-end data: leap year and weekends. With a bit of work you can eliminate both problems

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

In the "Portfolio Excel Template" accompanying this assignment you have data about 5 Vanguard mutual funds during the 19 years from 2000 through 2018: 1. REIT Index Fund (Real Estate) 2. Total Stock...

Google Apple Microsoft display formulas and explain if possible to understand than you 2. Three assets Select another three stocks and download monthly data from Yahoo! Finance. Calculate average...

Additional Problem a. Using information from Yahoo! Finance, calculate the average annual return and standard deviation of annual returns for the past 10 years (Dec 31 to Dec 31or the last trading...

PORTFOLIO RISK AND RETURN On a weekend in late October 2015, Albert sat over his breakfast, and imitated of his personal investment portfolio over the past seven years. He remembered that, after the...

case study: Questions: needed urgently PORTFOLIO RISK AND RETURN On a weekend in late October 2015, Albert sat over his breakfast, and imitated of his personal investment portfolio over the past...

A. Using information from Yahoo! Finance, calculate the average annual return and standard deviation of annual returns for the past 10 years (From Dec 31, 2011 until Dec 31, 2020) for Apple stock....

PERSONAL INFORMATION: Javier and Sofia Garca live in Roanoke, VA in a home Javier inherited from his parents. They have two daughters: Ariana (age 8) and Isabela (age 10); both attend the...

2. The following is an opportunity loss table. States of Nature Alternatives Alternative 1 Alternative 2 Alternative 3 B. 30 10 20 20 25 What decision should be made based on the minimax regret...

The success of CeBIT in Hannover has prompted Deutsche Messe AG to market the CeBIT concept outside Germany using the slogan CeBIT Worldwide Events. Using cebit.de, suggest a rationale for this....

Based on the curves, what tenor should AA ranked corporations try to borrow at if they are not concerned with term risk? - 6 - month - 7 - year 1 0 - year

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...