Rluxmi, I'm hoping you know the answer to this one because I am confused...please help! More documents and websites to follow. The questions are the following: From a financial perspective, is hedging an urgent need for the company? Suppose fuel prices go up by 20% from the 2012 level, what is the potential impact of this ?oil shock? on Delta's 2013 earnings? Please assess the impact based on your forecast of Delta's 2013 income statement. Please follow the basic rules of financial forecast: assume that the data items will increase at the historical growth rate from 2012 level. Your forecast can be simplified statements which include only the most important data items. If Delta decides to hedge one month?s fuel consumption for its fleet using futures contracts, what NYMEX product(s) should be used? Please provide a brief reason why you chose this product. Since jet fuel futures contracts are not available, a perfect hedge is not possible. You need to consider a cross-hedging product (i.e., crude oil, No. 2 heating oil, and RBOB futures contract) which has the highest correlation with the jet fuel spot prices. Suppose that Delta wants to hedge one month?s fuel consumption for its fleet. Simulate potential hedging gains/losses using last month?s historical data (assuming that you entered the position of the futures contracts at the beginning of your simulation period). Please specify the contract, contract month, number of contracts required for the hedge, position (long or short), and margin requirements, as well as your daily margin account balance. Did you get any margin calls from the simulated hedging position? What is the total gain/loss of your position during the simulation period? Use a table similar to Table 2.1 on page 28 of the textbook to summarize the simulation results. Please find the one month?s fuel consumption of Delta from its annual report (use projected fuel consumption of 2013 on page 47 (note 1 to the table) under section Item7A). Assume that the fuel consumption is spent evenly across each month and there is no seasonality in different months. Access the New York Mercantile Exchange and choose the following margin requirements: "NYM" for exchange, "Crude oil" or "Refined products" for asset class, "CL" (crude oil futures), "HO" (No. 2 heating oil futures), or "RB" (RBOB gasoline futures) for product. Please note that different maturity month contracts may have different performance bond levels. You need to calculate the minimum hedge ratio and number of contracts using historical data of spot jet fuel prices and futures prices (the product that you choose). These materials will be covered in Lesson 6 (a similar example is provided on page 57 of the textbook (Example 3.3)). Please follow the historical daily settlement prices link for historical daily settlement prices (daily "closing" prices) for crude oil, No.2 heating oil, RBOB gasoline futures contracts. You can use these prices of last month for the simulation purpose. Use settlement price of day 1 of your simulation period as the start settlement price of the simulation. Please following the historical spot prices link for the historical spot prices for crude oil, jet fuel, No. 2 heating oil, RBOB gasoline. What are the potential costs/pitfalls of this hedging program? You can include your simulation results for your discussion.
Paper#1877 | Written in 18-Jul-2015Price : $25