BAFI1029 Derivatives and Risk Management
Requirements: 2000
BAFI1029 Derivatives and Risk Management
Assessment 3 – Individual Risk Management Report (50%)
Report and Excel
Due Date: Week 13, 23:59 Friday, 6 October 2023 (Singapore time)
Assessment Task
This is an individual task. In this assessment, students are required to form one equity portfolio, evaluate their risks and provide solution to manage the risk. The goal of this individual assignment is to gain a better understanding of the portfolio investment (in the US stock market) and risk management process. Below are the tasks:
to build one equity investment portfolio and justify the stock selection
to hold the portfolio from Thursday, 31 August 2023 to Friday, 22 September 2023 and observe its changes
to identify the portfolio risk by reporting portfolio’s VaR
to provide suggestions of managing the risk
to communicate your investment and risk management process using a professional report
Portfolio Creation
Please follow the following steps to build one portfolio.
Create an account (with your real first & surname) on
Create a watchlist of one Portfolio based on the close price as of Thursday, 31 August 2023
Note: The specified date here is used to start the observing period of your portfolios, not the date on which you must perform the task. For example, you can create portfolios either on Thursday, 31 August 2023, or on dates such as 11 September or 13 September 2023, but you will still observe the price change between the sample period Thursday, 31 August 2023 to Friday, 22 September 2023. As an illustration, this is the link to the historical daily prices of the AMZN stock.
This watchlist of Portfolio ($1 million) consists of Four stocks from the S&P 500
Choose any Three stocks from Table 1 (that are the largest in S&P500 index) plus Walmart Inc (WMT)
Make the number of shares for WMT equal to “Last three digits of your student number” if they are larger than 99.
Make the number of shares for WMT equal to “First three digits of your student number” if your last three digits are smaller than or equal to 99.
Example: For student S7777777, you need to hold 777 shares of TSLA in your Portfolio. For student S6660011, you need to hold 666 shares of TSLA in your Portfolio.
Determine the weights and shares for the rest of the stocks you chose in step a.
You have USD 1 million for this Portfolio.
Note: Since the shares can’t be bought in fraction, a tiny variation from the specified budget is acceptable. You can choose to hold some Cash if you believe the investment opportunity is not good enough, but you will need to justify this decision in your report. The total $1 million investment you have is based on the share prices on Thursday, 31 August 2023.
Take screenshots of your portfolio and the necessary information in all sections. Make sure you attach them in the Appendix of your submitted report.
Suppose this is a Buy-and-Hold strategy, therefore, do not change your portfolio setting during your holding period Thursday, 31 August 2023 to Friday, 22 September 2023.
Guideline for Investing and Calculations
Marking Guide Your report must include the following sections:
Trading philosophy: (2 marks)
Give an overview of your philosophy to form the portfolio. You should identify yourself as a value or growth investor or a mixture of both. Provide brief definitions for value/growth investing.
Portfolio construction: (5 marks)
Present your initial portfolio, including information on why you have invested in the stocks in your initial portfolio (three stock selection for Portfolio).
The overall market and macroeconomic condition (2.5 marks)
Industry consideration and/or diversification, specific stock’s strengths/positive prospects (2.5 marks)
Risk identification: (27 marks)
In this part, you should discuss the risk profile of your portfolio. Use daily historical stock price between 1st October 2018 and 30th August 2023 to calculate the VaR of your Portfolio (VaR template can be found in Week 11’s material on Canvas). The discussion should include the following points:
Calculation and discussion of the one-day 95%-Value at Risk of each stock in your portfolio using historical simulation approach. That means, if you have four stocks in total, you need VaR for each. (10 marks)
Calculation and discussion of the 10-day 99%-Value at Risk of your portfolio using model- building approach. Show key steps of workings. (3 marks)
Calculation and discussion of the 10-day 99%-Value at Risk of your portfolio using a historical simulation approach. (3 marks)
Discuss the performance of VaR in (b) and (c), by comparing your calculated VaR results and the portfolios’ actual 10-day returns (Thursday, 31 August 2023 to Wednesday, 13 September 2023). (5 marks)
Calculation and discussion of the 95%-Expected Shortfall (CVaR) of your portfolio using a historical simulation approach. (6 marks)
Hedging using Options: (12 marks)
On any day between Thursday, 31 August 2023 and the assessment due date, how will you use the option contract to hedge one of your three selected stocks in your Portfolio. You need to determine and explain which option you want to use (i.e., specify whether it is a call or put, when the expiration date is, appropriate strike price, whether you should go long or short, number of contracts, etc.). Provide justification for your decision. (7 marks)
Note: The budget for option transaction is not limited and not included in the initial $1 million budget. If you are not able to backdate historical price for the option, feel free to use the available price whenever you start drafting the answer to this question. For example, if your start to look at this question on 4th September 2023, and cannot find the historical option price on 31 August 2023, then it is fine to use the option price on 4th September 2023.
Discuss when you will exercise your option and its potential payoff. (5 marks)
The professionalism of the report. (e.g., Usage of professional Figures and Tables, with numbering and captions.) (4 marks)
Total=50 marks
Submission
All submissions must be made electronically on Canvas, accompanied by a . The submission must be using 1 or 1.5 spacing and 12-point Times New Roman font. Work that fails to meet these specifications will not be accepted. Students should ensure that the report is free from problems like copying and plagiarism.
The report and excel spreadsheet will be submitted through “Canvas-Assignments-Assessment 3”. You can submit multiple times before the due date. The report should be no longer than 2500 words (-/+ 15%), excluding references and appendix. The student can have up to 2-page appendix. Citation and reference should be provided where necessary. The Excel file contains your workings to support the reported analysis.
Students are required to keep back-ups of all submitted work just in case any are lost.
The tutor of your enrolled session will mark your assessment.
Note:
The report will include VaR calculations which will require you to use Excel. Therefore, though the result of calculations should be discussed in the report, you should submit a separate Excel file to Canvas to show your detailed calculations. Meanwhile, you also need to include one or two tables to summarize the key results of your calculations.
This instruction includes suggestions on items to include in the report, more information for parts you think are important may be included as you feel necessary, keeping in mind the word limit.
The teaching team is not supposed to comment on your calculation workings or identify your calculation mistakes. The teaching team will provide guidance to make sure that you are on the right track. However, it is still your responsibility to investigate your work and identify the errors.
Table 1 Stock list
Additional Resources:
To help you construct your portfolio:
Information on value investing can be found here:
Information on growth investing can be found here:
Options Data
Options contract for, for example, Facebook can be found here.
Other data:
Historical stock prices can be downloaded from open access websites like yahoo finance such as the following link:
for Facebook historical prices.
Annual return of the S&P500 can be found here
A proxy for risk-free rate such as 3-month treasury bill can be found here
and Policy
Unless extension is granted, severe penalties apply for late submission. For late submission, the mark awarded will be reduced by 10% for each day (2 points) the submission is late. Submissions that are late by 7 days or more will not be marked and zero marks will be awarded.
If you can’t submit an assessment on time due to circumstances outside your control, you may be eligible for an extension to the due date. See If you seek an extension to the prescribed due dates, up to 7 days, you must submit your request through the Assessment Extension Tool enabled in Canvas, and where appropriate supporting documents such as a medical certificate in case of illness should be provided. It will be reviewed and actioned directly in Canvas. You must submit the request at least one working day before the assessment deadline for an extension to the due date of up to seven calendar days.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
