FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Closing Prices - Last trading day of the year 2020 2019 2018 2017 2016 Avg Price Avg Return s. Deviation Sharp Ratio AMZN FB TSLA

image text in transcribed
Closing Prices - Last trading day of the year 2020 2019 2018 2017 2016 Avg Price Avg Return s. Deviation Sharp Ratio AMZN FB TSLA HD WMT Find the Closing Prices of each stock for the five years. Use the last trading day of that year Compute the average Price using Excel AVERAGE formula Compute the Average Return: [(Price 2020 -Price 2016)/Price 2016]/5 Compute the Standard Deviation using Excel STDEV formula Compute the Sharp ratio using the formula (Avg Return-Risk free")/Standard Deviation What stock is th ebest investment? Explain "The risk free rate is the rate earned on a treasury bill. Use 2% for this assignment

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Dimensions Of Marketing Decisions

Financial Dimensions Of Marketing Decisions

Authors: David W. Stewart

1st Edition

3030155641,303015565X

More Books

Students also viewed these Finance questions

Question

★★★★★
A 2-kHz sound wave traveling in the x-direction in air was observed to have a differential pressure p(x, t) = 10N/m2 at x = 0 and t = 50 s. If the reference phase of p (x, t) is 36o, find a complete...

Answered: 1 week ago

Question

★★★★★
Historical Realized Rates of Return You are considering an investment in either individual stocks or a portfolio of stocks. The two stocks you are researching, Stock A and Stock B, have the following...

Answered: 1 week ago

Question

★★★★★
=+c. Suppose the plants whose marginal benefit curves you depicted in part a were participants in the 33/50 program. In a replica of your graph from part a, mark targeted levels of

Answered: 1 week ago

Question

★★★★★
What is the internal rate of return on the following projects, each of which requires a $20,000 cash outlay now and returns the cash flows indicated? a. $10,426.72 at the end of Years 1 and 2. b....

Answered: 1 week ago

Question

★★★★★
Misty needs to have $23,000 at the end of 8 years to fulfill her goal of purchasing a small sailboat. She is willing to invest a lump sum today and leave the money untouched for 8 years until it...

Answered: 1 week ago

Question

★★★★★
What should be the balance in a Registered Retirement Income Fund (RRIF) that will provide $2,500 at the beginning of each month for 7 years, if the RRIF earns 4.25% compounded quarterly?

Answered: 1 week ago

Question

★★★★★
An online retailer has come up with two new layouts for their website. To determine whether they should revamp the website, a focus group of 8 individuals is put together. These 8 individuals will...

Answered: 1 week ago

Question

★★★★★
Lot-for-Lot Gross requirements Scheduled receipts Projected on hand 95 Net requirements Planned order receipts Planned order releases Lead-time 1 week => 2 3 4 5 6 7 8 10 80 110 80 20 140 60 80 40 0...

Answered: 1 week ago

Question

★★★★★
A gas tungsten arc-welding is performed to join two aluminium workpieces through continuous fillet welding. The current and voltage of the arc-welding operation is 300A and 20V, respectively. The...

Answered: 1 week ago

Question

★★★★★
3. Use Consolidate to create a summary of real estate sales for all property types. Place the consolidated data on the Summary worksheet in cells B3:C15. Use the Average function to consolidate the...

Answered: 1 week ago

Question

★★★★★
W Franklin corporation issues $82,000, 8%, 5-year bonds on January 1, for $85,690. Interest is paid semiannually on January 1 and July 1. If Franklin uses the straight-line method of amortization of...

Answered: 1 week ago

Previous Question Next Question