Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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 with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

Students also viewed these Finance questions