This paper circulates around the core theme of Calculate the following: a. Average Monthly returns for Ford or IBM or BBY (based on your last name) together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Last starts with J, Ford (ticker = F)(for Students with last names starting from I-¬-R), please see. 1 answer below » Last starts with J, Ford (ticker = F)(for Students with last names starting from I-¬-R), please see attached file for instructions Additional Requirements Level of Detail: Show all work Document Preview: FIN 5080 Instructor: Dr. Palkar Quiz 4 EC Page 1 of 2 Deadline is Sunday, August 24th by 11:59 PM. You must submit your answers using Excel. Submissions using Word or PDF will not be accepted. Make sure you are using cell references while solving the problems. You must upload your View complete question » Last starts with J, Ford (ticker = F)(for Students with last names starting from I-¬-R), please see attached file for instructions Additional Requirements Level of Detail: Show all work Document Preview: FIN 5080 Instructor: Dr. Palkar Quiz 4 EC Page 1 of 2 Deadline is Sunday, August 24th by 11:59 PM. You must submit your answers using Excel. Submissions using Word or PDF will not be accepted. Make sure you are using cell references while solving the problems. You must upload your work using the Assignment Drop-box. Assignments not uploaded properly will receive a grade of zero. This extra credit assignment is based on “Other Topics” Handout. 1. This assignment will require you to analyze time series of monthly returns. Start by retrieving MONTHLY data for the period of July 31, 2009 – July 31, 2014 from Yahoo Finance website (http://finance.yahoo.com/) for – Best Buy (ticker = BBY) (for Students with last names starting from A--H) – Ford (ticker = F) (for Students with last names starting from I--R) – IBM (ticker = IBM) (for Students with last names starting from S--Z) – (if you use the wrong company, no points will be allotted for this question) Instructions for downloading the data from Yahoo!: To obtain the monthly data, click on “Historical Prices” on the left panel. Select Date Range. Make sure Monthly is selected and then click on “Get Prices”. Scroll down and click on “Download to Spreadsheet”. Instructions for sorting the data by DATE: Re--sort the data so that the most previous date is at the bottom of your spreadsheet (i.e. highlight DATE columns and click on SORT, make sure “expand the selection” is selected, then click on SORT and sort by Date and order by ‘Oldest to Newest’). Calculating Returns: Use the ‘Adjusted Close’ column to obtain returns for each period. Remember that the Adjusted Close column has already adjusted the prices for dividends and stock splits so you do not have to adjust for it again. Just use the adjusted close column to obtain the returns. 1 1 = – t-t t PP R Calculate the following: a. Average Monthly returns for Ford or IBM or BBY (based on your last name). b. Standard Deviation and variance of monthly returns for Ford or… Attachments: Q-Attachmenty….pdf View less » Aug 01 2015 04:16 PM
