Here are the monthly historical closing prices for the following securities and indexes from 2010 to 2015 HSI (Hang Seng Index) Calculate the holding period return for the index i in month t by is the price of index security i at the end of month t (Note the stock prices are already adjusted for dividends and stock splits, so you dont need to worry about them ) Please show all your steps including FORMULAS RESULTS in Excel January 31, 2010 20121 99 February 28, 2010 20608 7 March 31, 2010 21239 35 April 30, 2010 21108 59 May 31, 2010 19765 19 June 30, 2010 20128 99 July 31, 2010 21029 81 August 31, 2010 20536 49 September 30, 2010 22358 17 October 31, 2010 23096 32 November 30, 2010 23007 99 December 31, 2010 23035 45 January 31, 2011 23447 34 February 28, 2011 23338 02 March 31, 2011 23527 52 April 30, 2011 23720 81 May 31, 2011 23684 13 June 30, 2011 22398 1 July 31, 2011 22440 25 August 31, 2011 20534 85 September 30, 2011 17592 41 October 31, 2011 19864 87 November 30, 2011 17989 35 December 31, 2011 18434 39 January 31, 2012 20390 49 February 29, 2012 21680 08 March 31, 2012 20555 58 April 30, 2012 21094 21 May 31, 2012 18629 52 June 30, 2012 19441 46 July 31, 2012 19796 81 August 31, 2012 19482 57 September 30, 2012 20840 38 October 31, 2012 21641 82 November 30, 2012 22030 39 December 31, 2012 22656 92 January 31, 2013 23729 53 February 28, 2013 23020 27 March 31, 2013 22299 63 April 30, 2013 22737 01 May 31, 2013 22392 16 June 30, 2013 20803 29 July 31, 2013 21883 66 August 31, 2013 21731 37 September 30, 2013 22859 86 October 31, 2013 23206 37 November 30, 2013 23881 29 December 31, 2013 23306 39 January 31, 2014 22035 42 February 28, 2014 22836 96 March 31, 2014 22151 06 April 30, 2014 22133 97 May 31, 2014 23081 65 June 30, 2014 23190 72 July 31, 2014 24756 85 August 31, 2014 24742 06 September 30, 2014 22932 98 October 31, 2014 23998 06 November 30, 2014 23987 45 December 31, 2014 23605 04 January 31, 2015 24507 05 February 28, 2015 24823 29 March 31, 2015 24900 89 April 30, 2015 28133 May 31, 2015 27424 19 June 30, 2015 26250 03 July 31, 2015 24636 28 August 31, 2015 21670 58 September 30, 2015 20846 3 October 31, 2015 22640 04 November 30, 2015 21996 42 December 31, 2015 21914 4 Tit Piet Pi,t 1 , where Pit Pit 1

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 03, 2024

Here are the monthly historical closing prices for the following securities and indexes from 2010 to 2015: HSI (Hang Seng Index). Calculate the holding period

Here are the monthly historical closing prices for the following securities and indexes from 2010 to 2015: HSI (Hang Seng Index). Calculate the holding period return for the index i in month t by

image text in transcribed is the price of index/security i at the end of month t. (Note: the stock prices are already adjusted for dividends and stock splits, so you dont need to worry about them.)

Please show all your steps including FORMULAS & RESULTS in Excel.

January 31, 2010	20121.99
February 28, 2010	20608.7
March 31, 2010	21239.35
April 30, 2010	21108.59
May 31, 2010	19765.19
June 30, 2010	20128.99
July 31, 2010	21029.81
August 31, 2010	20536.49
September 30, 2010	22358.17
October 31, 2010	23096.32
November 30, 2010	23007.99
December 31, 2010	23035.45
January 31, 2011	23447.34
February 28, 2011	23338.02
March 31, 2011	23527.52
April 30, 2011	23720.81
May 31, 2011	23684.13
June 30, 2011	22398.1
July 31, 2011	22440.25
August 31, 2011	20534.85
September 30, 2011	17592.41
October 31, 2011	19864.87
November 30, 2011	17989.35
December 31, 2011	18434.39
January 31, 2012	20390.49
February 29, 2012	21680.08
March 31, 2012	20555.58
April 30, 2012	21094.21
May 31, 2012	18629.52
June 30, 2012	19441.46
July 31, 2012	19796.81
August 31, 2012	19482.57
September 30, 2012	20840.38
October 31, 2012	21641.82
November 30, 2012	22030.39
December 31, 2012	22656.92
January 31, 2013	23729.53
February 28, 2013	23020.27
March 31, 2013	22299.63
April 30, 2013	22737.01
May 31, 2013	22392.16
June 30, 2013	20803.29
July 31, 2013	21883.66
August 31, 2013	21731.37
September 30, 2013	22859.86
October 31, 2013	23206.37
November 30, 2013	23881.29
December 31, 2013	23306.39
January 31, 2014	22035.42
February 28, 2014	22836.96
March 31, 2014	22151.06
April 30, 2014	22133.97
May 31, 2014	23081.65
June 30, 2014	23190.72
July 31, 2014	24756.85
August 31, 2014	24742.06
September 30, 2014	22932.98
October 31, 2014	23998.06
November 30, 2014	23987.45
December 31, 2014	23605.04
January 31, 2015	24507.05
February 28, 2015	24823.29
March 31, 2015	24900.89
April 30, 2015	28133
May 31, 2015	27424.19
June 30, 2015	26250.03
July 31, 2015	24636.28
August 31, 2015	21670.58
September 30, 2015	20846.3
October 31, 2015	22640.04
November 30, 2015	21996.42
December 31, 2015	21914.4

Tit = = Piet Pi,t-1 , where Pit Pit-1