Compute the historical value-at-risk

The 5% historical value-at-risk assesses major historical losses of your investment and is obtained as the 5th percentile of the past returns. A percentile is a threshold value below which a given percentage of the past returns were observed. In this case, the 5th percentile of historical returns is the value below which 5% of the returns were observed.

In this exercise, your task is to find the 5% historical value-at-risk of ABC based on the series of historical returns of the stock for the period 2013 to 2017.

To do so, use the PERCENTILE() function. It receives two arguments: the range of cells containing the dataset to consider and the percentile included in the range [0,1].