Enron email

Algorithmic Indexing

25 Jul 2000, 12:45 UTC

Re: MG Metals: summary of VAR methodology and current status

From
Tanya Tamarchenko tanya.tamarchenko@enron.com
To
Ted Murphy, Vince J Kaminski, Anjam Ahmad, Grant Masson, Cantekin Dincerler, Kirstee Hewitt, andreas.barschkis@mgusa.com, Eric Gadd, Lloyd Fleming, Bjorn Hagelmann, David Port
Date
Tue, 25 Jul 2000 05:45:00 -0700 (PDT)
Dear all,

Anjam and myself  had a highly productive and informative set of meetings 
with Andreas Barkchis of MG Metals NY on Thursday 20th July in the NY 
office.  Firstly we should say "thanks" to Andreas for being so helpful in 
addressing out numerous requests for information - we look forward to 
establishing a solid working relationship with him going forward.

Find below a summary of Version_1a for initial rough calculation of MG 
Metal's VAR.

Also Anjam, Kirstee (from London side) and Cantekin, Grant, Vince and myself 
(Houston side) have been working for last 2 days on the spreadsheet VAR 
model. 
The current status of this effort and a plan for future progress is 
summarized in the enclosed document:   
  
______________________________________________________________________________
_______________________________________________________
V@R methodology for MG Metals positions
Version_1a

Introduction
This document describes the initial rough model for calculations 
Value-At-Risk for MG Metals. This model will be implemented in a spreadsheet, 
which will serve as a prototype for the RiskTrac implementation. 

Risk factors
The following positions represent most of MG Metal,s risk and will be covered 
by Version_1a:
- Base metals, positions including:
- aluminium;
- copper;
- gold;
- lead;
- nickel;
- silver;
- tin;
- zinc;
Risk related to these positions will be quantified by simulating forward 
prices for each metal.
- Copper concentrate;
Risk related to these positions will be quantified by simulating TC charges.
- Cocoa beans;
Risk related to these positions will be quantified by simulating forward 
prices for cocoa beans.

Therefore these 10 curves will drive the risk: price curves for aluminium, 
copper, gold, lead, nickel, silver, tin, zinc and cocoa beans plus tc curve 
for copper concentrate.

Assumptions and simplifications:
- For each metal we are going to use a single price curve or all types of 
products (physical, financial, LME traded, Comex traded, scrap, alloy, stock, 
etc.);
- Delta, gamma approach for risk on options, positions;
 
Components required to implement V@R model: 
- current forward prices available from Mercur;
- current implied volatilities available through Reuters;
- current positions from Mercur;
- history of prices required to calculate factor loadings and correlations 
across commodities;   

Methodology
Version_1a will be based on Risk Matrix approach. We will calculate principal 
components for each metal and cocoa beans to take in account the correlations 
along the term structure. We will also calculate the correlations across 
commodities based on prompt month prices history for last 3 months. 
 
Portfolio hierarchy
Each position will be assigned to one of the following portfolios under the 
whole portfolio AGG-METALS:
- MG Metal & Commodity Corp.
- MG Ltd.;
- MG Metal & Commodity Company Ltd.;
- MG Metall Recycling GmbH, Ffm;

Under each of these sub-portfolio there will be the following sub-portfolios:
- Comex;
- Frame contract;
- LME;
- LME Alloy;
- LME Metal Index;
- Option Call;
- Option Put;
- Physical;
- Physical Alloy;
- Physical Real;
- Physical Scrap;
- Price Part.;
- Prov. Billing;
- Stock;
- Stock Alloy;
- Stock Comex;
- Stock Physical;
- Stock Scrap;