Chat with support 24/7


Professional Custom Essay Writing Service

Order from the best essay help service in the whole world!

...content here............

I need somwone good in financial.business excel to fo this

You have to answer the following 5 questions: Q1: What is a collar strategy and how does it work? Q2: Construct a collar strategy with at-the-money calls and at-the-money puts using the historical data in case Exhibit 3. Back-test what would have been the growth in value of a $1 invested from the start of December 1990 to the end of December 2007 following this strategy. See case Exhibit 2 for details on a collar strategy. Plot it against the monthly growth in value of $1 in the HFRX EH: Equity Market Neutral Index (HFRI EH), the S&P 500 Index, and in one-month Treasury bills (T-bills). What do you conclude? What would have been the Sharpe ratio of this strategy? Q3: Now do the same but with a collar strategy with OTM calls (with strikes equal to 105% of the current value of the S&P 500 Index) and OTM puts (with strikes equal to 95% of the current value of the S&P 500 Index). What would have been the growth in the value of $1 following this strategy? And what would have been the Sharpe ratio? Q4: Can you get a fixed-strike rule for the “moneyness” of the call and put options on the collar strategy so you can match the growth in the value of $1 experienced by the Fairfield Guard hedge fund? A fixed-strike rule means that you should keep the moneyness (the percentage that makes the strikes for the call and put options to be OTM) held constant over time. Q5: What are your observations? What do you conclude?

Need a Professional Writer to Work on Your Paper and Give you Original Paper? CLICK HERE TO GET THIS PAPER WRITTEN

Place a custom essay order similar to this or any related topic. NB: The assignment paper will be written from scratch as per your instructions and it will be 100% original. It will pass all plagiarism check.

endwhile; ?>

Check Our Prices

Free Quote



All kinds of papers in all subject areas

We can successfully deal with all kinds of school assignments corresponding to various academic disciplines. Among these school papers are:

  • Custom essays
  • Dissertations and theses (undergraduate, Master's, PhD)
  • Research and term papers
  • Courseworks and case studies
  • Admission essays and personal statements, etc.
University of Nairobi