Economics Homework Help

FIN 2FDR LTUSC Derivative Securities & Hedging Strategy Question

Supplementary and selected relevant material provided:

– Textbook chapters 3 and 5 (Textbook is available online)

– Optional reading: Carter, David A., and Rogers, Daniel A. and Simkins, Betty J., Does Hedging Affect Firm Value? Evidence from the Us Airline Industry. Financial Management, Vol. 35, No. 1, Spring 2006. Available via the library. (Relevant sections: The introduction and the literature review sections)

– Other readings provided on futures in LMS.

– Excel file with real data obtained for the securities used.

Research and Inquiry

Besides, you are expected to do research and inquiry and get 2 articles/papers using an online search or via the La Trobe Library that you use in supporting arguments used in your discussions. These could professional or academic articles that should be used to justify points you answer for Q3. Invalid/ improper referencing will not be counted in the marking for Q3.

Reporting references (Use APA style)

Examples:

In-text or inline citation

Rule	Surname of author, no initials or suffixes such as Jr. The year of publication is also included. Also, add the page number for our internal check when marking.
Citation examples	..This was seen in an Australian study (Conger, 1979, p. 40). OR Conger (1979, p. 40) has argued that… OR In 1979, Conger conducted a study which showed that…

References list example

Australian Bureau of Statistics. (2008). Childhood education and care (No. 4402.0). Retrieved from http://www.abs.gov.au

Referencing resources for more examples:

https://www.lib.latrobe.edu.au/referencing-tool/apa-6

The grading criteria is based on.

Use of information (including evidence of inquiry and research), which supports the solution (quantitative and/or qualitative) proposed.
Evidence of problem-solving skills, analysis, and critical reasoning demonstrated in the answers provided for project questions.
Reporting accurate numerical solutions including estimations and calculations.
Interpret plots if used, regression results (OLS estimation files are provided as support files), other estimates, and numerical calculations accurately and correctly in a manner consistent with the the questions raised in the project.
Devise appropriate strategies and/or recommendations based on numerical analysis and inquiry.
Communicate answers and results clearly and professionally via a written report and appendix. Proofread the report prior to submission.
Proper use of references inline and/or in footnotes and providing a reference list following a formal style such as APA 6.
Present a professionally formatted Excel workbook with embedded notes explaining content, proper and accurate use of formulas, and proper labeling of plots in the Excel sheet and the report.
Compliance with project requirements and La Trobe policies.
Plagiarism on any part of the project will result in a fail in the project.

Highlights:

Real-world application on hedging.
Use real data from financial markets.
Applies methods and utilizes disciplinary knowledge covered in the subject.

Links and files:

If you do not have the DataAnalysis tool pack in Excel already installed, use the following instructions found at this link

https://docs.microsoft.com/en-us/previous-versions/technet-magazine/ff969363(v=msdn.10)?redirectedfrom=MSDN

Assignment

Assume that you were approached by the CFO of USC Airlines, an established hypothetical airline based in the US and operates internationally to selected destinations.

The CFO is debating the effectiveness and business viability of hedging jet fuel and is seeking your advice. Her opinion is mainly driven by an international report that shows that not all airlines hedge jet fuel. USC consumes an average of $60 million of fuel per year and allocates these expenses evenly across each month of the year.

In your capacity as a Risk Analyst who is familiar with Derivative products you are tasked to advise the CFO about hedging Jet fuel oil. Your advice is driven by an empirical assessment using a dataset provided in an Excel file and your understanding of hedging using futures.

You are expected to advise the CFO on

1- Establishing a hedging strategy that includes setting a hedging position and evaluating its effectiveness and explain whether it is favorable for USC Airlines. (Note: This requires using the optimal hedging ratio based on the OLS regression method to conduct relevant calculations. You are expected to explain the results and all calculations).

2- Justifying the choice of an appropriate hedging asset from the two assets provided.

3- Critique the hedging strategy proposed in answering question 1.

Format of the assignment report:

Executive summary (Highlight key results and the main recommendation in one paragraph (100 words).

Analysis section (900 words divided as you see fit across 3 questions)

Answer the three questions raised above and take note of the following:

· When answering question 1, report the statistical table of estimates, explain the estimates, and show/type all equations that you are using in your calculations. You are expected to provide an analysis based on estimates or calculations in answering question 1 or any other question where it is necessary to do so.

· All questions are analytical and require reasoning.

· When answering question 3, use research papers as a reference and report arguments in line with what you what to communicate. You must provide an inline reference that includes the page of the paper/report/article you are referring to and provide an appropriate reference list at the end of the assignment using the APA referencing style provided by the library (See some examples below).

Description of the dataset

The dataset is collected from Bloomberg and contains a time series for:

Spot market Jet Fuel (see snapshot for selected specs)
HO1 Commodity (contract size 42000 gallons see a snapshot in the datafile, and
CO1 Commodity (contract size 1000 barrels see a snapshot in datafile for selected specs)

See the data file in Excel. Weekly observations are provided for all data. The commodities follow the January cycle.

You may find contract specs on exchange websites. Here is one example for HO1:

https://www.cmegroup.com/trading/energy/refined-products/heating-oil_contract_specifications.html#)

The data file contains 4 main fields:

PX_LAST is the last traded price for the week

PX_SETTLE is the Settlement Price

PX_VOLUME is the traded volume

OPEN_INT is the open interest.