Hedge Fund Homework Be careful as all your Historical Performance data is in % already, e.g.10.50 is
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66648faae638a_41066648faad0ad5.jpg)
Hedge Fund Homework
Be careful as all your Historical Performance data is in % already, e.g.10.50 is 10.50%
1.Visually examine your data, what are some of the issues with hedge fund historical performance data? How are you going to deal with it?
2.Plot the cross-sectional number of hedge funds over time every month. Hint starts with 6and ends with 52(?) use =count(). At what point in time do you trust your data? Why?
3.Identify the hedge funds with the top 10 highest historical Sharpe Ratio. Compute their standard statistics -- Ann.Ret,Ann.Std,Correlation, Sharpe Ratios.
4.Create an EW portfolio of the top 10 highest Sharpe Ratio hedge funds from 3. Report the EW portfolio's standard statistics.
5.Identify the top 10 lowest beta hedge funds, compute their standard statistics. Also, compute their traditional betas and lagged betas (3periods). Which hedge funds should investors be careful about? Why?
6.Take your two portfolios from 4. and 5. leverage up the portfolio to have the same volatility, assume you can borrow at 3% per year, or 3%/12 or 25 bps per month. Report the standard statistics. Which portfolio is better? Why?
Maximum 3-pages of Executive write-ups
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66648fab488ab_41166648fab326a2.jpg)