I need the graphs in excel and Questions in word document
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?
Calculate the price of your order
Select your paper details and see how much our professional writing services will cost.
- Freebies
- Format
- Formatting (MLA, APA, Chicago, custom, etc.)
- Title page & bibliography
- 24/7 customer support
- Amendments to your paper when they are needed
- Chat with your writer
- 275 word/double-spaced page
- 12 point Arial/Times New Roman
- Double, single, and custom spacing
-
We care about originality
Our custom human-written papers from top essay writers are always free from plagiarism.
-
We protect your privacy
Your data and payment info stay secured every time you get our help from an essay writer.
-
You control your money
Your money is safe with us. If your plans change, you can get it sent back to your card.
How it works
-
1
You give us the detailsComplete a brief order form to tell us what kind of paper you need.
-
2
We find you a top writerOne of the best experts in your discipline starts working on your essay.
-
3
You get the paper doneEnjoy writing that meets your demands and high academic standards!
Get your own paper from top experts
Order nowPerks of our essay writing service
We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.
Frequently asked questions
Get instant answers to the questions that students ask most often.
See full FAQWhat if I’m dissatisfied with the paper I get?
The average quality score at our professional custom essay writing service is 8.5 out of 10. The high satisfaction rate is set by our Quality Control Department, which checks all papers before submission. The final check includes:- Compliance with initial order details.
- Plagiarism.
- Proper referencing.
I need an essay on the same day. Is it something you can do?
Sure. Our writing company offers a fast service with an 8-hour deadline for orders up to master’s level. Make sure to specify the deadline in the order form and our writers will write a paper within the indicated timeslot. Just proceed to submit your requirements here Once you order a custom-written essay, our managers will assign your order to the well-suited writer, who has the best skills and experience for preparing your specific assignment. You can also request one of these extra features:- Choose the Writer’s Samples option – study 3 randomly-provided pages from orders that have been written by the assigned writer.
- Request a specific writer – choose an academic writer from the dropdown list in the order’s form (optional for returning customers).
How can I be sure your writing service is not a scam?
We understand that a shade of mistrust has covered the paper writing industry, and we want to convince you of our loyalty. Apart from high-quality writing services, we offer:- The chances of students to boost writing skills in a quick and effective way.
- The opportunity to manage studies and free time in an enjoyable manner.
- The possibilities to improve overall academic performance.
Is it legal to use your professional writing service?
Yes. Custom writing help is not prohibited by any university or college. It’s a 100% legal way of getting professional assistance with paper writing. Hiring writers from an essay writing company is in many ways similar to consulting a tutor – we help you solve the writing issues at hand.How does your service work?
Our custom writing service is a reliable solution on your academic journey that will always help you if your deadline is too tight. You fill in the order form with your basic requirements for a paper: your academic level, paper type and format, the number of pages and sources, discipline, and deadline. Then, you describe the specific details of the paper you need: add the topic, write or paste the instructions, and attach files to be used, if you have them. After that, an online customer support representative chooses the best writer that specializes in your discipline and assigns him or her to complete the paper according to your requirements. When the paper is ready, we check it for plagiarism and send it to you. If you want to change something, you can request a free revision.