This assignment is to be done individually. This means that you are required to answer the questions in the assignment on your own. The purpose of the assignment is to help you become more familiar with pricing options, using a specifically designed piece of software. The pricing of options is a very technical area, and most of us do not have the technical expertise to price options from first principals. Therefore in your working lives, if you do need to price options, then it will most likely be done for you via software.
The software we will be using is called ‘Derivable’, which has been specifically developed for the Hull et al (2014) textbook. You can download the software from the Model unit site under the ‘Additional Resources’ section. Software Installation Installation instructions for the Derivable software are quite straight forward. Please follow these simple steps. Step 1 . Go to the BIFF 5 Model site, under ‘Additional Resources’ Section, click on the Derivable software and download the file ‘Derivable. Zip’. Step 2. Double-click on the Derivable. IP file to bring up the Winzip utility program. Step 3. In the Winzip utility program, on the ‘Home’ tab, there should be a button labeled ‘I-click Unzip’. Press on the ‘I-click Unzip’ button. The compressed files directories and folders should then be extract. Once Winzip has completed the extraction, then close the Winzip program. Step 4. There should now be a folder in your directory named ‘Derivable’. Drill down through the Derivable folder until you come to the list of files; The only file you need to be concerned with for the Assignment is ‘JUDGE . XSL’. Step 5.
Double-click on file ‘JUDGE . XSL’. This should bring up your Excel application aerogram with the JUDGE . XSL spreadsheet. If you look in the ‘readmes. Txt’ file that is located in the same directory as the JUDGE . XSL file, it will tell you the versions of the Excel program that Derivable will work with. If you are not using any of these versions of Excel then you will need to get access to one of them in order to do the assignment. Step 6. Once you have opened the ‘JUDGE . XSL’ program in Excel, that final step you need to perform is to ensure that Excel has ‘Enabled Macros’.
This will allow the Excel program to use the Visual Basic for Applications (ABA) code on which Derivable is eased. If you are using Excel 2010, the enable macros should appear as a ‘strip’ across the top of your spreadsheet when you first enter the JUDGE . XSL program. You just need to press the enable button. If you a later version of Excel you will need to go to the macro security settings and enable the macros. Once you have enabled the macros, Derivable will be available for use. Step 7: Click on the Excel spreadsheet tab ‘Equity_FIX_landed_Futures_Options’.
This is the only spreadsheet you will need to complete the assignment. Format of Assignment and submission requirements: The assignment consists of seven questions. You should attempt all questions. Responses to the questions should be presented according to the Q Manual. The Q Manual provides guidelines on the presentation of submitted materials. Submission of the assignment will require both an electronic submission AND a hard copy submission: The submission of an electronic copy can be done via Model (further technical details will be provided prior to the submission date. The submission of a physical hard copy will be done via a designated assignment box located in the 3rd Floor Foyer of Building H. Further details to be provided closer to the submission date. ) ASSIGNMENT QUESTIONS Please note: Most, but not all of the material needed to answer these questions will be covered in lectures. You are postgraduate students so it is expected that you will be able to seek out the material necessary to complete the questions using your own initiative. All information is available within the textbook, even though it may not all be covered in lectures.
IQ . Use Derivable to calculate the value of an American put option on a non- dividend-paying stock when the stock price is USED 30, the strike price is USED 32, the sis-free rate is 5%, the volatility is 30% and the time to maturity is 1. 5 years. (Choose ‘Binomial American’ for the option type and 50 time steps. ) (See Chapter 9 for supporting theory and materials) a) What is the option’s intrinsic value? B) What is the option’s time value? C) What would a time value of zero indicate? What is the value of an option with zero time value? ) Using a trial and error approach, calculate how low the stock price would have to be for the time value of the option to be zero. (use 50 and 500 time steps) Q. Consider an option on a stock when the stock price is $41, the strike price is $40, he risk-free rate is 6%, the volatility is 35% and the time to maturity is one year. Assume that a dividend of $0. 50 is expected after six months. (See Chapter 10 for a) Use Derivable to value the option assuming it is a European call. B) Use Derivable to value the option assuming it is a European put. ) Verify that put-call parity holds. D) Explore, using Derivable, what happens to the price of the options as the time to maturity becomes very large. For this purpose, assume there are no dividends. Explain the results you get. Q. Suppose that the price of a non-dividend-paying stock is $32, its volatility is 30% ND the risk-free rate for all maturities is 5% per annum. Use Derivable to calculate the cost of setting up the following positions. In each case provide a table showing the relationship between profit and final stock price. Ignore the impact of discounting.
Each table should have two columns, ‘Stock Price Range’ and ‘Profit’ (See Chapter 11 for supporting theory and materials) a) a bull spread using European call options with strike prices of $25 and $30 and a maturity of six months b) a bear spread using European put options with strike prices of $25 and $30 and a ) a butterfly spread using European call options with strike prices of $25, $30 and $35 and a maturity of one year d) a butterfly spread using European put options with strike prices of $25, $30 and e) a straddle using options with a strike price of $30 and a six-month maturity f) a strangle using options with strike prices of $25 and $35 and a six-month maturity. Q. Consider a European call option on a non-dividend-paying stock where the stock price is ADD 40, the strike price is ADD 40, the risk-free rate is 4% per annum, the volatility is 30% per annum and the time to maturity is six months. See Chapter 12 for supporting theory and materials) a) Calculate , and for a two-step tree b) Value the option using a two-step tree. C) Verify that Derivable gives the same answer. D) Use Derivable to value the option with 5, 50, 100 and 500 time steps. Q.
Consider an American call option when the stock price is $18, the exercise price is $20, the time to maturity is six months, the volatility is 30% per annum and the risk- free interest rate is 10% per annum. Two equal dividends of 40 cents are expected during the life of the option, with ex-dividend dates at the end of two months and five months.
Why Work with Us
Top Quality and Well-Researched Papers
We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.
Professional and Experienced Academic Writers
We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.
Free Unlimited Revisions
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.
Prompt Delivery and 100% Money-Back-Guarantee
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.
Original & Confidential
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.
24/7 Customer Support
Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admission Essays & Business Writing Help
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.