How To Calculate Risk Measure With VaR, Historical Simulation And Portfolio Hedging

Calculating Risk Measure with VaR

The choice of adequate VAR is mainly essential as it mainly helpful in making sufficient investment decisions by calculating the overall risk from investment. The following choice needs to be conducted for identifying the adequate VAR (i) normal distribution based on a 252-day rolling window, (ii) the normal distribution with a variance estimated by the EWMA, and(iii) historical simulation based on a window of 252 days.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

2.1 Calculating VAR with normal distribution based on 252 rolling window:

 Particulars

Qantas

Fairfax Media

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Sample mean

-0.08%

-0.01%

Sample’s standard deviation

            0.0198

               0.0196

Confidence level

5%

99%

Normal quartile

2.3263

2.3263

VAR 1(day)

-4.69%

-4.56%

2.2 Calculating normal distribution with EWMA:

Items

Value

Value

Sample’s mean

0.01%

-0.03%

Sample variance

0.05%

0.05%

Standard deviation

2.24%

2.30%

Confidence level

99%

99%

Normal quantile

2.3263

2.3263

VaR (1 day)

-0.10%

-0.15%

2.3 Calculating historical simulation based on 252 days:

Particulars

Qantas

Fairfax Media

Historical VAR

-5.001%

-4.520%

Method

Normal Distribution

Normal Distribution

Historical Simulation

Volatility

Rolling Window

EWMA

Number of observation

252

1260

252

VaR(1, 99%)

-4.69%

-0.10%

-5.00%

Normal Var Qantas

Normal Var Fairfax

EWMA Qantas

EWMA Fairx

Historical Var Qantas

Historical Var Fairfax

Green: Exceedances ≤ 4

210

213

0

0

195

213

Yellow: 5 ≤ Exceedances ≤ 9

42

39

0

0

56

39

Red: 10 ≥ Exceedances

1

1

253

253

2

1

The above table mainly depicts the relevant Basel traffic lights, which could help in identifying the most adequate technique that could be used in discovering adequate VAR. From the overall evaluation, historical simulation is mainly depicted as the most viable approach, which could be used in detecting the overall VAR calculation.

From the overall VAR calculation the VAR(10,99%) mainly indicates that the VAR(.99%) * 10^(1/2) = -30.11%.

In addition, total portfolio value is 42,200 * -30.11% = -12,705.67. Therefore, there is a chance that the total value of the portfolio will mainly lose the 30.11% or 12,705.67 in investment.

4. Calculating the hedging strategy:

4.1 Beta calculation:

Covariance of NAB and S&P200 = Standard deviation of S&P200 * Correlation between NAB and S&P200 * Standard deviation of NAB

 Particulars

Qantas

Fairfax Media

correlation Qantas and S&P200

0.399162361

0.399162361

Standard deviation

0.022429941

0.023046568

Standard deviation S&P200

0.009261863

covariance

0.00829%

0.00842%

covariance

0.00829%

0.00852%

Beta

            0.9667

               0.9932

4.2 Number of future contract:

Qantas

Fairfax Media

Particulars

Value

Value

Value of shares

3.33

0.89

Number of shares

           10,000

               10,000

Value of shares

           33,300

                 8,900

Beta

           0.9667

               0.9932

S&P

5665.79981

Points per $

25

Notion value of index

         141,645

Number of Future contracts

                0.23

                   0.06

Total number of futures needs to be sold

                0.29

There for seeing the overall table 0.29 or 1 futures need to be hedged, as futures are mainly conducted on certain lots. Therefore, the S&P 200 futures will mainly sold in January 3, 2017 and then bought in January 16, 2017. This time horizon will mainly help in depicting the relevant profits and reduction in risk that might be conducted with the hedge.

Particulars

Value

Value

Shorting

0.29

Selling 1 contract at January 3, 2017

5736.3999

      143,410.00

Buying 1 contract at January 16, 2017

5699.3999

      142,485.00

Cost of holding

           42,200

Profit on futures

           925.00

Net cost of NAB shares with futures contracts

     41,275.00

Therefore, after using short hedge the overall profits attained from investment is mainly at 925. In addition, the overall use of hedge has mainly helped in reducing the systematic risk that might affect the overall value of portfolio.

4.3 VAR of the portfolio:

Particulars

Value

Expected return of the portfolio

0.0103%

Expected return of Qantas

0.0148%

Expected return of Fairfax

-0.0297%

Expected return of the index

0.0117%

Covariance of Oantas and Fairfax

0.0065%

Covariance of Oantas and S&P 500

0.0002%

Covariance of Fairfax and S&P 500

0.0002%

Normal quantile at 99% confidence level

2.3263

Var Qantas

-0.05001

Var Fairfax

-0.04520

Var S&P 200

0.0086%

VaR (1, 99%)

-1.1073%

VaR (10, 99%)

-3.5015%

The evaluation of the hedge mainly helps in reducing the cost of holding both Qantas and Fairfax Media. Thus, the overall opportunity for losing the investment is mainly calculated at -3.50515%. Where -3.50515% * 41,275.00 = -1445.25, will mainly be lost from the investment opportunity.

4.4 Valuation of Put option:

The overall 100 put options is mainly identified as the most viable investment instrument, which needs to be bought to hedge for the overall shares in both Qantas and Fairfax Media. This bout a 100 put needs to be both doe Qantas and Fairfax Media for hedging the overall portfolio. This option is mainly used in reducing the overall damage potential losses, which might be incurred from an investment.

4.5 Valuation of six step put option:

The annual volatility of both the stock are mainly depicted as follows.

The overall valuation of the put options is mainly identified, as the most viable method, which could help in reducing the overall loses from investment. From the overall evaluation share price of Qantas and Fairfax Media are depicted as follows.

Particulars

Qantas

Fairfax Media

Share price

                    3.33

                    0.89

Put

               0.3751

               0.1033

Price rise

               3.9789

               1.0686

Number of shares

               10,000

               10,000

Value from put

           2,737.82

               753.83

Value from portfolio

39788.96196

10686.46232

Portfolio value

         46,983.78

Actual portfolio value

         42,200.00

Increment in Value

           4,783.78

Particulars

Qantas

Fairfax Media

Share price

               3.33

                    0.89

Put

          0.3751

               0.1033

Price decline

          2.7869

               0.7412

Number of shares

          10,000

               10,000

Value from put

    (9,181.85)

         (2,520.46)

Value from portfolio

27869.287

7412.181658

Portfolio value

    46,983.78

Actual portfolio value

    42,200.00

Decline in value

      4,783.78

From the above two table the entire relevant decline in value and increment in value due to the price action of both Qantas and Fairfax Media could effectively be evaluated. The use of option stock could eventually help the company in making adequate investment decisions. Thus, it could be evaluated that decline and increment in share value mainly increased the overall portfolio be 4783.78.

4.5 Profit diagram:

The above figure mainly depicts the relevant payoff, which could be conducted by an investment option. The overall portfolio value mainly use adequate investment options, which could help in generating higher revenue from investment. In addition, the overall profits of the portfolio mainly increased after being stagnant for some time and attaining breakeven point. Therefore, the loss in premium is could be generated from the overall income that is generated from investment.

Abed, H. S., Wittert, G. A., Leong, D. P., Shirazi, M. G., Bahrami, B., Middeldorp, M. E., … & Abhayaratna, W. P. (2013). Effect of weight reduction and cardiometabolic risk factor management on symptom burden and severity in patients with atrial fibrillation: a randomized clinical trial. Jama, 310(19), 2050-2060.

Au.finance.yahoo.com. (2017). Symbol lookup from Yahoo Finance. [online] Available at: https://au.finance.yahoo.com/lookup/all?s=ishares%20s&t=A&m=ALL [Accessed 27 May 2017].

Fitzpatrick, K. E., Tuffnell, D., Kurinczuk, J. J., & Knight, M. (2016). Incidence, risk factors, management and outcomes of amniotic?fluid embolism: a population?based cohort and nested case–control study. BJOG: An International Journal of Obstetrics & Gynaecology, 123(1), 100-109.

Margolis, K. L., O’Connor, P. J., Morgan, T. M., Buse, J. B., Cohen, R. M., Cushman, W. C., … & Lipkin, E. W. (2014). Outcomes of combined cardiovascular risk factor management strategies in type 2 diabetes: the ACCORD randomized trial. Diabetes care, 37(6), 1721-1728.

Wiengarten, F., Humphreys, P., Gimenez, C., & McIvor, R. (2016). Risk, risk management practices, and the success of supply chain integration. International Journal of Production Economics, 171, 361-370