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 Year Return 2013 27 00 2014 21 00 2015 4 00 2016 23 00 2017 9 00 Write the function to accept three arguments the risk free rate, the standard deviation of returns, and the average return Call this function SharpeRatioA 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

The Answer is in the image, click to view ...

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

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:

Year	Return
2013	27.00%
2014	-21.00%
2015	4.00%
2016	23.00%
2017	9.00%

Write the function to accept three arguments: the risk-free rate, the standard deviation of returns, and the average return. Call this function SharpeRatioA.
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.

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!

2 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: Year Return 2013...

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: Year Return 2013...

Create a user-defined function to calculate the value of a common stock using the earnings model that was introduced in Chapter 9 on page 266. a. What arguments will you need to accept in order to...

Create a user-defined function to calculate the value of a common stock using the earnings model that was introduced in Chapter 8 on page 246. a. What arguments will you need to accept in order to...

How to solve using Excel!! Create a user-defined function to calculate the value of a common stock using the earnings model that was introduced in Chapter 9 on page 284. What arguments will you need...

pls i need help with the samsung wiley Annual Report Project only the other 4 Attachment is a guideline telling you what need to be done.pls see the attached Apple company wiley Annual Report ANNUAL...

can anyone please help me with it? why it is not giving me full credit? I do not know if I did it correctly or not. anyway, thanks in advance. File Home inert Draw Page Layout Formules Data Review...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

y = Vx 5 Start Over 10 8. 7. 4 3 1 -10 -9 -8 -7 -6 -5 -4 -3 -2 -1 1. 2 4 7. 8 10 -1 -2 -3 -4 -5 -6 -7 -8 -10 in 10

Group 2 - as individuals, that is those who didn't create the presentation for this week, should, (No later than 11:59 pm on Fri), provide a "substance-based" comment (i.e., 50-70 words based on...

is the grooves seperating activity within the brain called? 3 . What is a recording of the electrical activity within the brain called? ( Complete words, not an abbreviation. ) 0 . 1 Pts

The project _ _ _ _ _ answers the questions of what, when, how much, and at times where.

d. What language(s) did they speak?

1. How do electronic means of communication (e-mail, the Internet, fax, and so on) differ from face-to-face interactions?

3. What are some of the potential challenges organizations face as they become more diverse?