Chapter 20 Value at Risk Practice Questions Problem 20. 8

CHAPTER 20

Value at Risk
Practice Questions



Problem 20.8.

A company uses an EWMA model for forecasting volatility. It decides to change the parameter from 0.95 to 0.85. Explain the likely impact on the forecasts.

Reducing from 0.95 to 0.85 means that more weight is put on recent observations of and less weight is given to older observations. Volatilities calculated with will react more quickly to new information and will “bounce around” much more than volatilities calculated with .

Problem 20.9.

Explain the difference between value at risk and expected shortfall.

Value at risk is the loss that is expected to be exceeded (100 – X)% of the time in days for specified parameter values, and . Expected shortfall is the expected loss conditional that the loss is greater than the Value at Risk.

Problem 20.10.

Consider a position consisting of a $100,000 investment in asset A and a $100,000 investment in asset B. Assume that the daily volatilities of both assets are 1% and that the coefficient of correlation between their returns is 0.3. What is the 5-day 99% value at risk for the portfolio?
The standard deviation of the daily change in the investment in each asset is $1,000. The variance of the portfolio’s daily change is

The standard deviation of the portfolio’s daily change is the square root of this or $1,612.45. The standard deviation of the 5-day change is

From the tables of we see that . This means that 1% of a normal distribution lies more than 2.33 standard deviations below the mean. The 5-day 99 percent value at risk is therefore 2.33×3,605.55 = $8,400.93.

Problem 20.11.

The volatility of a certain market variable is 30% per annum. Calculate a 99% confidence interval for the size of the percentage daily change in the variable.

The volatility per day is . There is a 99% chance that a normally distributed variable will be within 2.57 standard deviations. We are therefore 99% confident that the daily change will be less than .

Problem 20.12.

Explain how an interest rate swap is mapped into a portfolio of zero-coupon bonds with standard maturities for the purposes of a VaR calculation.

When a final exchange of principal is added in, the floating side is equivalent a zero-coupon bond with a maturity date equal to the date of the next payment. The fixed side is a coupon-bearing bond, which is equivalent to a portfolio of zero-coupon bonds. The swap can therefore be mapped into long and short positions in zero-coupon bonds with maturity dates corresponding to the payment dates. A cash flow mapping procedure can then be used to map each of the zero-coupon bonds to positions in the adjacent standard-maturity zero-coupon bonds.

Problem 20.13.

Explain why the linear model can provide only approximate estimates of VaR for a portfolio containing options.

The change in the value of an option is not linearly related to the percentage change in the value of the underlying variable. The linear model assumes that the change in the value of a portfolio is linearly related to percentage changes in the underlying variables. It is therefore only an approximation for a portfolio containing options.

Problem 20.14.

Some time ago a company entered into a forward contract to buy £1 million for $1.5 million. The contract now has six months to maturity. The daily volatility of a six-month zero-coupon sterling bond (when its price is translated to dollars) is 0.06% and the daily volatility of a six-month zero-coupon dollar bond is 0.05%. The correlation between returns from the two bonds is 0.8. The current exchange rate is 1.53. Calculate the standard deviation of the change in the dollar value of the forward contract in one day. What is the 10-day 99% VaR? Assume that the six-month interest rate in both sterling and dollars is 5% per annum with continuous compounding.

The contract is a long position in a sterling bond combined with a short position in a dollar bond. The value of the sterling bond is or $1.492 million. The value of the dollar bond is or $1.463 million. The variance of the change in the value of the contract in one day is

The standard deviation is therefore $0.000537 million. The 10-day 99% VaR is million.

Problem 20.15.

The most recent estimate of the daily volatility of the U.S. dollar–sterling exchange rate is 0.6%, and the exchange rate at 4 p.m. yesterday was 1.5000. The parameter in the EWMA model is 0.9. Suppose that the exchange rate at 4 p.m. today proves to be 1.4950. How would the estimate of the daily volatility be updated?

The daily return is . The current daily variance estimate is . The new daily variance estimate is

The new volatility is the square root of this. It is 0.00579 or 0.579%.

Problem 20.16.

Suppose that the daily volatilities of asset A and asset B calculated at close of trading yesterday are 1.6% and 2.5%, respectively. The prices of the assets at close of trading yesterday were $20 and $40, and the estimate of the coefficient of correlation between the returns on the two assets made at close of trading yesterday was 0.25. The parameter used in the EWMA model is 0.95.

(a) Calculate the current estimate of the covariance between the assets.

(b) On the assumption that the prices of the assets at close of trading today are $20.5 and $40.5, update the correlation estimate.

1. 
   The volatilities and correlation imply that the current estimate of the covariance is .
   
2. 
   If the prices of the assets at close of trading today are $20.5 and $40.5, the returns are and . The new covariance estimate is
   

The new variance estimate for asset A is

so that the new volatility is 0.0166. The new variance estimate for asset B is

so that the new volatility is 0.0245. The new correlation estimate is

Problem 20.17.

Suppose that the daily volatility of the FT-SE 100 stock index (measured in pounds sterling) is 1.8% and the daily volatility of the dollar/sterling exchange rate is 0.9%. Suppose further that the correlation between the FT-SE 100 and the dollar/sterling exchange rate is 0.4. What is the volatility of the FT-SE 100 when it is translated to U.S. dollars? Assume that the dollar/sterling exchange rate is expressed as the number of U.S. dollars per pound sterling. (Hint: When , the percentage daily change in is approximately equal to the percentage daily change in X plus the percentage daily change in .)

The FT-SE expressed in dollars is where is the FT-SE expressed in sterling and is the exchange rate (value of one pound in dollars). Define as the proportional change in on day and as the proportional change in on day . The proportional change in is approximately . The standard deviation of is 0.018 and the standard deviation of is 0.009. The correlation between the two is 0.4. The variance of is therefore

so that the volatility of is 0.0231 or 2.31%. This is the volatility of the FT-SE expressed in dollars. Note that it is greater than the volatility of the FT-SE expressed in sterling. This is the impact of the positive correlation. When the FT-SE increases, the value of sterling measured in dollars also tends to increase. This creates an even bigger increase in the value of FT-SE measured in dollars. A similar result holds for a decrease in the FT-SE.

Problem 20.18.

Suppose that in Problem 20.17 the correlation between the S&P 500 Index (measured in dollars) and the FT-SE 100 Index (measured in sterling) is 0.7, the correlation between the S&P 500 index (measured in dollars) and the dollar-sterling exchange rate is 0.3, and the daily volatility of the S&P 500 Index is 1.6%. What is the correlation between the S&P 500 Index (measured in dollars) and the FT-SE 100 Index when it is translated to dollars? (Hint: For three variables , , and , the covariance between and equals the covariance between and plus the covariance between and .)

Continuing with the notation in Problem 20.17, define as the proportional change in the value of the S&P 500 on day . The covariance between and is . The covariance between and is . The covariance between and equals the covariance between and plus the covariance between and . It is

The correlation between and is

Problem 20.19.

The one-day 99% VaR is calculated for the four-index example in Section 20.2 as $253,385. Look at the underlying spreadsheets on the author’s web site and calculate a) the 95% one-day VaR and b) the 97% one-day VaR.
The 95% one-day VaR is the 25th worst loss. This is $168,612. The 97% one-day VaR is the 15th worst loss. This is $188,758.

Problem 20.20.

Use the spreadsheets on the author’s web site to calculate the one-day 99% VaR, using the basic methodology in Section 20.2 if the four-index portfolio considered in Section 20.2 is equally divided between the four indices.

In the “Scenarios” worksheet the portfolio investments are changed to 2500 in cells L2:O2. The losses are then sorted from the largest to the smallest. The fifth worst loss is $258,355. This is the one-day 99% VaR.

Problem 20.21.

At the end of Section 20.6, the VaR for the four-index example was calculated using the model-building approach. How does the VaR calculated change if the investment is $2.5 million in each index? Carry out calculations when a) volatilities and correlations are estimated using the equally weighted model and b) when they are estimated using the EWMA model with . Use the spreadsheets on the author’s web site.
The alphas (row 21 for equal weights and row 7 for EWMA) should be changed to 2,500. This changes the one-day 99% VaR to $238,022 when volatilities and correlations are estimated using the equally weighted model and to $510,459 when EWMA with is used.
Problem 20.22.

What is the effect of changing from 0.94 to 0.97 in the EWMA calculations in the four-index example at the end of Section 20.6? Use the spreadsheets on the author’s web site.

The parameter  is in cell N3 of the EWMA worksheet. Changing it to 0.97 changes the one-day 99% VaR from $488,217 to $404,661. This is because less weight is given to recent observations.

Further Problems
Problem 20.23.

Consider a position consisting of a $300,000 investment in gold and a $500,000 investment in silver. Suppose that the daily volatilities of these two assets are 1.8% and 1.2%, respectively, and that the coefficient of correlation between their returns is 0.6. What is the 10-day 97.5% value at risk for the portfolio? By how much does diversification reduce the VaR?

The variance of the portfolio (in thousands of dollars) is

The standard deviation is . Since , the 1-day 97.5% VaR is and the 10-day 97.5% VaR is . The 10-day 97.5% VaR is therefore $63,220. The 10-day 97.5% value at risk for the gold investment is . The 10-day 97.5% value at risk for the silver investment is . The diversification benefit is

Problem 20.24.

Consider a portfolio of options on a single asset. Suppose that the delta of the portfolio is 12, the value of the asset is $10, and the daily volatility of the asset is 2%. Estimate the 1-day 95% VaR for the portfolio. Suppose that the gamma of the portfolio is . Derive a quadratic relationship between the change in the portfolio value and the percentage change in the underlying asset price in one day.

An approximate relationship between the daily change in the value of the portfolio, and the return on the asset is

The standard deviation of is 0.02. It follows that the standard deviation of is 2.4. The 1-day 95% VaR is 2.4×1.65 = $3.96.

From equation (20.5) the quadratic relationship between and is

or

Problem 20.25.

A bank has written a call option on one stock and a put option on another stock. For the first option the stock price is 50, the strike price is 51, the volatility is 28% per annum, and the time to maturity is nine months. For the second option the stock price is 20, the strike price is 19, the volatility is 25% per annum, and the time to maturity is one year. Neither stock pays a dividend, the risk-free rate is 6% per annum, and the correlation between stock price returns is 0.4. Calculate a 10-day 99% VaR using DerivaGem and the linear model.

My answer follows the usual practice of assuming that the 10-day 99% value at risk is times the 1-day 99% value at risk. Some students may try to calculate a 10-day VaR directly, which is fine. From DerivaGem, the values of the two option positions are –5.413 and –1.014. The deltas are –0.589 and 0.284, respectively. An approximate linear model relating the change in the portfolio value to proportional change, , in the first stock price and the proportional change, , in the second stock price is

or

The daily volatility of the two stocks are and , respectively. The one-day variance of is

The one day standard deviation is, therefore, 0.4895 and the 10-day 99% VaR is .

Problem 20.26.

Suppose that the price of gold at close of trading yesterday was $600, and its volatility was estimated as 1.3% per day. The price at the close of trading today is $596. Update the volatility estimate using the EWMA model with .

The return on gold is . Using the EWMA model the variance is updated to

so that the new daily volatility is or 1.271% per day.

Problem 20.27.

Suppose that in Problem 20.28 the price of silver at the close of trading yesterday was $16, its volatility was estimated as 1.5% per day, and its correlation with gold was estimated as 0.8. The price of silver at the close of trading today is unchanged at $16. Update the volatility of silver and the correlation between silver and gold using the EWMA model with .

The return on silver is zero. Using the EWMA model the variance is updated to

so that the new daily volatility is or 1.454% per day. The initial covariance is Using EWMA the covariance is updated to

so that the new correlation is

Problem 20.28. (Excel file)

An Excel spreadsheet containing daily data on a number of different exchange rates and stock indices can be downloaded from the author’s Web site:

http://www.rotman.utoronto.ca/hull/data

Choose one exchange rate and one stock index. Estimate the value of in the EWMA model that minimizes the value of



where is the variance forecast made at the end of day and is the variance calculated from data between day and . Use Excel’s Solver tool. Set the variance forecast at the end of the first day equal to the square of the return on that day to start the EWMA calculations.
In the spreadsheet the first 25 observations on (v­_i-_)² are ignored so that the results are not unduly influenced by the choice of starting values. The best values of for EUR, CAD, GBP and JPY were found to be 0.947, 0.898, 0.950, and 0.984, respectively. The best values of for S&P500, NASDAQ, FTSE100, and Nikkei225 were found to be 0.874, 0.901, 0.904, and 0.953, respectively.

Problem 20.29.

A common complaint of risk managers is that the model building approach (either linear or quadratic) does not work well when delta is close to zero. Test what happens when delta is close to zero in using Sample Application E in the DerivaGem Application Builder software. (You can do this by experimenting with different option positions and adjusting the position in the underlying to give a delta of zero.) Explain the results you get.

We can create a portfolio with zero delta in Sample Application E by changing the position in the stock from 1,000 to 513.58. (This reduces delta by .) In this case the true VaR is 48.86; the VaR given by the linear model is 0.00; and the VaR given by the quadratic model is -35.71.

Other zero-delta examples can be created by changing the option portfolio and then zeroing out delta by adjusting the position in the underlying asset. The results are similar. The software shows that neither the linear model nor the quadratic model gives good answers when delta is zero. The linear model always gives a VaR of zero because the model assumes that the portfolio has no risk. (For example, in the case of one underlying asset .) When there are no cross gammas the quadratic model assumes that is always positive. (For example, in the case of one underlying asset .) This gives a negative VaR.

In practice many portfolios do have deltas close to zero because of the hedging activities described in Chapter 17. This has led many financial institutions to prefer historical simulation to the model building approach.

Problem 20.30 (Excel file)

Suppose that the portfolio considered in Section 20.2 has (in $000s) 3,000 in DJIA, 3,000 in FTSE, 1,000 in CAC40, and 3,000 in Nikkei 225. Use the spreadsheet on the author’s web site to calculate what difference this makes to the one-day 99% VaR that is calculated in Section 20.2.
First the investments worksheet is changed to reflect the new portfolio allocation. (see row 2 of the Scenarios worksheet for historical simulation). The losses are then sorted from the greatest to the least. The one-day 99% VaR is the fifth worst loss or $230,897.
Problem 20.31 (Excel file)

The calculations for the four-index example at the end of Section 20.6 assume that the investments in the DJIA, FTSE 100, CAC40, and Nikkei 225 are $4 million, $3 million, \$1 million, and $2 million, respectively. How does the VaR calculated change if the investment are $3 million, $3 million, $1 million, and $3 million, respectively? Carry out calculations when a) volatilities and correlations are estimated using the equally weighted model and b) when they are estimated using the EWMA model. What is the effect of changing  from 0.94 to 0.90 in the EWMA calculations? Use the spreadsheets on the author's web site.

1. 
   The portfolio investment amounts have to be changed in row 21 of the Equal Weights worksheet for the model building approach. The worksheet shows that the new one-day 99% VaR is $229,683. This is slightly higher than the one-day VaR for the original portfolio.
   
2. 
   The portfolio investment amounts have to be changed in row 7 of the EWMA worksheet. The worksheet shows that one-day 99% VaR is $478,895. This is slightly lower than the one-day VaR for the original portfolio. Changing  to 0.90 (see cell N3) changes VaR to $537,828. This is higher because recent returns are given more weight.