Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have to download the monthly data from 12/1/2012 to 12/1/2017 for some funds. Then I calculated the return from one month to another and

I have to download the monthly data from 12/1/2012 to 12/1/2017 for some funds. Then I calculated the return from one month to another and did the statistics about this funds using the return rates (mean, variance, etc.)

Then, I would have to use a risk free rate equal to 0.04167% per month (continuously compounded annual rate of 0.5%), and compute Sharpe's slope/ratio for each fund.

Can I use the average from the monthly returns (simple average formula on excel) and calculate the sharpe like (Rportfolio - Rf)/SD using 0.04167% as monthly risk free rate? or do I have to use the compounded rate? how do would I calculate the Return / SD annualized?

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

Principles of Managerial Finance

Authors: Chad J. Zutter, Scott B. Smart

15th edition

013447631X, 134476315, 9780134478197 , 978-0134476315

More Books

Students also viewed these Finance questions