Question: 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

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 day of each year if Dec 31 is a weekend) for Apple stock. Note: Use adjusted close to include the effect of 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 until 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 spreadsheet (XLSX). I would then use the VLOOKUP function to help you find the relevant year-end data. One complication when identifying year-end data is that there are no prices on weekends. With a bit of work you can work around this.

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!

can you help me to finished the assignment 2? Southern Cross University Business School ACC00152 Business Finance Unit Information Guide Session 1 2011 Contents Contacts and MySCU...

Please answer all of question 2 in the attachment below No plagiarism and please reference any sources you used. Bachelor of Business (Incorporating Graduate Diploma and Graduate Certificate in...

Please answer all of question 3:Portfolio analysis in the attachment below. To answer the question use the excel spread sheet return data attachment and complete all the answers on the excel...

Questions were written in the word file named questions, and the question related powerpoint slides were named as slides. Thanks in advance. 1) The common stock of Marielle Machinery will generate...

please explain it with details You are an investment trainee at a top pension fund company based in London. You are asked to prepare a report based on the tasks set out in the report brief below. The...

Robert and Lisa Franklin Case Personal and Financial Objectives: 1.) Robert plans to retire now and begin his retirement by traveling around the world with Lisa. 2.) Robert plans to sell his share of...

You must write a report including your findings, all relevant information and computations, and provide evidence. For this project, you must download monthly historical data from Jan. 2001 to Dec....

Hi, I have an Assignment for my Finance Subject. I have attached the necessary documentation here for you to view including the Lecture slides of all the Topics covered for this assignment. Please...

PT KFC Statement of Profit or Loss for the years Ended 31 December 2020 (internal estimation) and 2019 Sales COGS Gross Profit SGA Expense Operating income Interest income Interest expense Other...

I need help to answer these questions below that are based on the case "Larry Puglia and the T. Rowe Price Blue Chip Growth Fund" 1. How well has the Blue Chip Growth Fund performed in recent years?...

A Minneapolis-area employer is preparing to hire for a new business analyst position. They found a report for their local labor market that says the mean salary for early career, professional workers...

The mean annual U.S. per-person consumptions of lower fat and skim milk and the mean annual U.S. per-person consumptions of whole milk are shown in Table 66 for various years. Let L be the mean...

Tim and Liam have resided together for several years but are not married. Tim is concerned that if he dies first, his family may contest the transfer of his assets to Liam through his will, so he...

Override toString() for the class HighScores. It should return a String that contains all of the high scores in entries, formatted nicely. Note that toString is already implemented for the Score...