subject
Business, 08.07.2021 05:00 annapittbull12

1. Choose 18 companies traded on the NYSE. 2. Your timeline will begin For each stock, find the monthly closing prices for 61 months. The time frame you will use is 5 Jan 2016 through 3 Feb 2021. These data are easily found at Yahoo! Finance (http://finance. yahoo. com) [For reference go to Risk and Return Calculation Videos Posted on Learn, both explanation and excel example]. In Yahoo Finance enter a company’s stock symbol in the search field. Once you arrive at the company’s “Summary” page, click on the “Historical Data” link. Enter the required date range (5 Jan 2016 through 3 Feb 2021) and ensure that you have selected “monthly” then click on “Apply”. Click on “Download Data”. Copy and paste information in the “Date” and “Adj. Close” columns into the appropriate columns on the worksheet in the workbook I have provided you (see Format below). When you paste, chose the “123” option. The other data columns are not needed]. Sort these data from “oldest to newest”. Ensure that you provide the name of the company and its stock symbol in the appropriate cells at the top of the worksheet. 3. a. Use your 61 prices to find the average realized rate of rate of return (rs) over 60 months for each stock. Do this by computing the realized return for each month then finding the average of all 60 monthly returns. The return for each month is found by using the equation: (Ending Price – Beginning Price) / Beginning Price. b. Translate the average monthly realized return to an annualized realized return by multiplying the number you arrived at in part a. by 12. 4. a. Find the standard deviation () for the 60 monthly realized returns. Use the standard deviation function to do this. b. Translate this number into an annualized standard deviation by multiplying it by the square root of 12 (use the SQRT function). 5. Compute the coefficient of variation for each stock using average annualized realized returns from 3b. and the annualized ’sfrom 4b. above. 6. Establish a portfolio comprised of four of your stoc

ansver
Answers: 3

Other questions on the subject: Business

image
Business, 22.06.2019 08:30, bartonamber4042
What has caroline's payment history been like? support your answer with two examples
Answers: 3
image
Business, 22.06.2019 19:40, gakodir
Last year ann arbor corp had $155,000 of assets, $305,000 of sales, $20,000 of net income, and a debt-to-total-assets ratio of 37.5%. the new cfo believes a new computer program will enable it to reduce costs and thus raise net income to $33,000. assets, sales, and the debt ratio would not be affected. by how much would the cost reduction improve the roe? a. 11.51%b. 12.11%c. 12.75%d. 13.42%e. 14.09%
Answers: 3
image
Business, 22.06.2019 20:10, spicee68003
Peppy knows a lot about marketing, but not much about the legal or financial aspects of starting a new business. he wants to consult with a lawyer and accountant, but his budget is tight with all of the expenses involved in getting peppy's pizzazzeria up and running. peppy should: trust his basic instincts and try to put it together without the advice of lawyers and accountants. delay talking with a lawyer and accountant until the business has established a positive cash flow for at least one year. immediately hire full-time lawyers and accountants for his staff. consult with a lawyer and accountant even though the budget is tight.
Answers: 1
image
Business, 23.06.2019 00:50, tami5
Hubert manages a grocery store in a country experiencing a high rate of inflation. to keep up with inflation, he spends a lot of time every day updating the prices, printing new price tags, and sending out newspaper inserts advertising the new prices. his employees regularly deal with customer annoyance over the frequent price changes. this is an example of the of inflation.
Answers: 2
You know the right answer?
1. Choose 18 companies traded on the NYSE. 2. Your timeline will begin For each stock, find the mont...

Questions in other subjects:

Konu
Mathematics, 16.10.2020 14:01
Konu
Mathematics, 16.10.2020 14:01