Create a user-defined function to calculate the Sharp ratio using the equation (14-17) that was introduced in Chapter 14 on page 450. Use the following data to test your function:
a) Write the function to accept three arguments: the risk-free rate, the standard deviation of returns, and the average return. Call this function SharpeRatioA.
b) Rewrite your function so that it accepts the range of returns and makes use of Application.WorksheetFunction to calculate the standard deviation and the average return. Call this function SharpeRatioB.
You might also like to view...
Which action during the selection process would be illegal under the equal employment opportunity laws?
A. asking all candidates whether they have ever worked under a different name B. asking candidates whether they are able to perform the essential functions of a job C. asking candidates whether they will need any reasonable accommodation to complete the selection process D. asking all candidates which schools they have attended E. asking candidates how close they are to retirement age
Why is giving an employee a rating preferred to a ranking?
What will be an ideal response?
Wholesalers and retailers purchase large quantities of goods from manufacturers but sell only one or a few at a time to many different customers. This process is called ________
A) creating assortments B) breaking bulk C) third-party logistics D) order processing E) inventory control
Select the most accurate statement about sources found on the Web
A) Information posted at most sites has undergone the same editing and scrutiny given to articles in scholarly publications. B) Researchers can safely assume that the information posted on websites by individuals and companies is reputable. C) Wikis, blogs, and discussion forum entries are short-lived and change constantly. D) Wikipedia is reliable and should be used when conducting any scholarly research.