## Master Class: Calculating Value at Risk (VaR): First Steps

*in*Master Class

## Methodology

### Setting the Scene

#### Sample Portfolio

Our sample portfolio that we will use for calculating Value at Risk (VaR) consists of the following 4 items:

- 100 shares of OGDC
- 5 barrels of Crude Oil
- 1 foreign exchange denominated asset with market value of USD 10 on 5
^{th}March 2010. - 100 units of 3-year PIB with issue date of 19
^{th}February 2009 and coupon rate of 11.25%. This means that the outstanding term of the bond is 1.96 years.

#### Revaluation Date and Value of the Portfolio

We are calculating Portfolio Value at Risk (VaR) on the 5^{th} of March 2010 at the end of the day.

### Preliminary steps

The following steps are common to all the above mentioned Value at Risk (VaR) approaches:

#### Step P1: Determine look back period for Value at Risk

Determine the period over which the risk is to be evaluated. For illustration purposes let us assume a look back period of 5 days from 1^{st} March 2010 to 5^{th} March 2010. In practice window lengths cover a wider duration, such as 6 months, 1 year, etc.

#### Step P2: Obtain the daily times series data for each risk factor for the determined look back period for Value at Risk

The risk factors related to the assets in our portfolio are equity prices (OGDC), foreign exchange rates (USD-PKR), commodity prices (WTI) and interest rates (PKRV rates for 1 and 2 years respectively) as given below:

OGDC | WTI* | FX (USD-PKR) | PKRV_1 year (%) | PKRV_2 year (%) | |

01/03/2010 | 116.51 | 6,695.01 | 85.0700 | 12.27 | 12.33 |

02/03/2010 | 117.32 | 6,781.38 | 85.1077 | 12.27 | 12.33 |

03/03/2010 | 116.40 | 6,877.91 | 85.0490 | 12.26 | 12.32 |

04/03/2010 | 116.58 | 6,812.55 | 84.9339 | 12.25 | 12.32 |

05/03/2010 | 117.61 | 6,911.20 | 84.8000 | 12.25 | 12.33 |

*WTI denominated in PKR = WTI denominated in USD×FX rate on that date. For example WTI spot price on 01/03/2010 was USD 78.70 per barrel. To convert this to PKR we multiplied this price with the FX rate for USD-PKR for that day, i.e. 78.70 × 85.0700 = PKR 6695.01.

**Step P3: Adjustments to original time series data for Value at Risk **

The interest rate risk factors, i.e. the PKRV rates, need to be adjusted to take into account the portfolio’s exact exposure to this risk factor. The PKRV rate series will first be interpolated based on the outstanding term to maturity of the bond and then will be converted into a price series which will be used in the actual VaR calculation:

The detailed steps to this process are given below:

- Determine the outstanding term of the bond. This is calculated as follows:

=1.96 years

- Calculate an interpolated PKRV rate series for this outstanding term. Interpolation will be done using the following formula:

T= outstanding term =1.96 years

T_{1}=rounded down value of the outstanding term = 1 year

T_{2}= T_{1}+1 =2 years

Using PKRV rates for 5^{th} March 2010, the interpolated rate is calculated as follows:

The resulting interpolated PKRV rate series works out to:

PKRV_interpolated (%) | |

01/03/2010 | 12.3277 |

02/03/2010 | 12.3277 |

03/03/2010 | 12.3177 |

04/03/2010 | 12.3173 |

05/03/2010 | 12.3269 |

- Calculate the price of the bond at each data point using

- Settlement date = Revaluation date = 5
^{th}March 2010 - Maturity Date =19
^{th}March 2012 - Coupon Rate = 11.25%
- Yield = PKRV_interpolated (%) applicable to that data point
- Redemption value = 100
- Coupon payment frequency = 2
- Basis = Actual/365

This may be done using Excel’s Price formula or by discounting the cash flows using the following formula:

where:

t = number of days from settlement to next coupon date.

E = number of days in coupon period in which the settlement date falls.

N = number of coupons payable between settlement date and redemption date.

A = number of days from beginning of coupon period to settlement date.

The resulting bond price series works out to:

PIB Prices | |

01/03/2010 | 98.1596 |

02/03/2010 | 98.1596 |

03/03/2010 | 98.1764 |

04/03/2010 | 98.1771 |

05/03/2010 | 98.1609 |

**Step P4: Calculate a return series from the time series data for Value at Risk **

A return series is derived from the given time series data by taking the natural logarithm of the ratio of successive prices/ rates, i.e.

where s_{t} is the price/ rate at time t. For example for OGDC the return on 5^{th} March 2010

The return series for the rest of the portfolio is given below:

OGDC | WTI | FX | PIB Prices | |

| 0.6928% | 1.2819% | 0.0443% | 0.0000% |

| -0.7873% | 1.4134% | -0.0690% | 0.0171% |

| 0.1545% | -0.9549% | -0.1354% | 0.0007% |

| 0.8796% | 1.4377% | -0.1578% | -0.0164% |

**Step P5: Calculate a return series for the portfolio **

In order to evaluate the VaR for the portfolio, the return series for the portfolio will be required. This is derived by calculating a weighted average return series using the individual return series for each instrument in the portfolio. This will be calculated as follows:

- Calculate the weights of the respective instruments in the portfolio on the revaluation date, where
**weight = value of the instrument÷total value of the portfolio**. The weights for the portfolio are given below:

- Derive a weighted average return series by calculating for each point in time in the data series the sum product of the weight and return across instruments/ scrips in the portfolio. The resulting weighted average return series will be correlation adjusted, i.e. it will account for correlations between the various instruments. For example for data point 5
^{th}March 2010 the portfolio return will be

18.2%×0.8796%+53.48%×1.4377%+13.12%×(-0.1578%)+15.19%×(-0.0164%)=0.9058%.

The return series for the sample portfolio is as follows:

Portfolio | |

| 0.8175% |

| 0.6062% |

| -0.5002% |

| 0.9058% |

We can now move on to the next steps required to calculate Value at Risk (VaR)