Reference no: EM13848288

i. Determine the Value-at-Risk (VaR), denominated in Australian dollars, for the portfolios provided below using

1. Variance/covariance (Delta-Normal/Delta Gamma for non-linear positions)

2. Historical Simulation

3. Monte Carlo Simulation

ii. Determine the Expected Tail Loss (ETL), denominated in Australian dollars, for the portfolios provided below using the results from

1. Historical Simulation

2. Monte Carlo Simulation

For each of the methods above, calculate the VaR and ETL (where applicable) for the following parameter sets:

Confidence Level (%)	95	99	95	99
Holding Period (days)	1	1	10	10

Outline of Steps:

1. Determine the risk factors affecting each portfolio. (Note: the set of interest rate data provided consists of many more zero-coupon rates than needed for the portfolios.)

2. Determine the valuation formulae to be used for the positions. Some positions may need to be decomposed into simpler instruments (e.g bonds can be decomposed into equivalent zero coupon bonds).

3. Determine the mark-to-market value of the portfolios on the valuation date.

4. Determine a method for estimating the change in the underlying risk factor (e.g. log(change), discrete change (%))

5. Determine the variance/covariance and correlation matrices for the various portfolios.

6. Proceed with VaR estimation.

Task 1:

You are required to submit the results for the following:

1. Mark-to-market value of the all portfolios.

2. Value-at-Risk for the following portfolios:

Portfolio 1

Portfolio 2

Portfolio 4

Using:
a. Variance/covariance methodology

b. Historical simulation.

with the parameter values below:

Confidence Level (%)	95	99	95	99
Holding Period (days)	1	1	10	10

Task 2:

Final Submission of Assignment:

The final results of the assignment should be submitted should be in the form of

1. Written report consisting of :

- A brief description of the methods used in calculating VaR.

- Any additional assumptions made for each VaR method including the method used to measure the changes in risk factors, the technique used to determine the 10-day VaR for each method.

- Full documentation of the VaR results for all individual portfolios and the specified combinations using the various methods as required for the assignment.

- A brief analysis and explanation of the variability in the VaR estimates determined using the different methods.

- A brief analysis of the diversified vs. undiversified risk for the combined portfolios.

2. Computer programs/spreadsheets developed and used for the assignment.

Portfolio 1
Physical Bonds Issuer	Coupon rate p.a	Maturity	Next Coupon Date	Face Value (Millions)
Com G	4.75%	15-Jun-16	15-Dec-15	10
Com G	4.25%	21-Jul-17	21-Jan-16	5
Com G	5.50%	21-Jan-18	21-Jan-16	8
Com G	5.25%	15-Mar-19	15-Sep-15	10
Com G	4.50%	15-Apr-20	15-Oct-15	5
Assume: coupon paid semi-annually.

Portfolio 2
Spot Foreign Exchange
Currency	Currency Description	AUD Million Equivalents
USD	US $	40
EUR	Euro	60
GBP	UK £	55
NZD	New Zealand $	30
INR	Indian Rupee	50
JPY	Yen	30

Portfolio 4
Physical Share Issuer	Number of Shares	Bought/Sold
CBA	60,000	Sold
ANZ	80,000	Bought
RIO	100,000	Bought
NCM	200,000	Sold
WPL	150,000	Bought
TLS	250,000	Sold

Share Options(Exchange Traded)
Maturity	Underlying	Put/Call	Bought/Sold	Number of Shares	Strike	(% p.a)
9-Oct-15	BHP	Call	Bought	250,000	$28.00	29.53%
8-Jan-16	RIO	Put	Bought	200,000	$54.00	26.06%
12-Mar-16	RIO	Call	Bought	200,000	$53.00	26.48%
4-Mar-16	NCM	Put	Sold	200,000	$12.00	44.18%
7-Apr-16	NCM	Call	Sold	250,000	$10.00	44.00%
9-Jun-16	WPL	Put	Bought	200,000	$33.00	25.22%
Assume: Options are European style

Attachment:- Assignm.pdf