Question: Hi, I require help with this assignment. The files are as attached Date Jun 28, 1996 Jul 31, 1996 Aug 30, 1996 Sep 30, 1996

 Hi, I require help with this assignment. The files are as

Hi, I require help with this assignment. The files are as attached

attached Date Jun 28, 1996 Jul 31, 1996 Aug 30, 1996 Sep

Date Jun 28, 1996 Jul 31, 1996 Aug 30, 1996 Sep 30, 1996 Oct 31, 1996 Nov 29, 1996 Dec 31, 1996 Jan 31, 1997 Feb 28, 1997 Mar 31, 1997 Apr 30, 1997 May 30, 1997 Jun 30, 1997 Jul 31, 1997 Aug 29, 1997 Sep 30, 1997 Oct 31, 1997 Nov 28, 1997 Dec 31, 1997 Jan 30, 1998 Feb 27, 1998 Mar 31, 1998 Apr 30, 1998 May 29, 1998 Jun 30, 1998 Jul 31, 1998 Aug 31, 1998 Sep 30, 1998 Oct 30, 1998 Nov 30, 1998 Dec 31, 1998 Jan 29, 1999 Feb 26, 1999 Mar 31, 1999 Apr 30, 1999 May 31, 1999 Jun 30, 1999 Jul 30, 1999 Aug 31, 1999 Sep 30, 1999 Oct 29, 1999 Nov 30, 1999 Dec 31, 1999 Jan 31, 2000 Feb 29, 2000 Mar 31, 2000 Apr 28, 2000 May 31, 2000 Jun 30, 2000 Jul 31, 2000 Aug 31, 2000 Sep 29, 2000 MSCI_US MSCI_IN MSCI_SG MSCI_world USTBILL_monthly 100 100 100 100 0.004 95.62 91.74 92.38 96.48 0.0045 97.78 89.91 94.48 97.61 0.0041 103.28 82.66 94.32 101.45 0.0044 105.94 80.86 91.13 102.18 0.0042 113.97 73.72 94.56 107.92 0.0041 111.84 77.87 96.24 106.21 0.0046 119.52 84.91 98.29 107.51 0.0045 120.39 90.77 97.24 108.77 0.0039 115.02 83.43 89.82 106.63 0.0043 122.62 94.02 85.08 110.14 0.0043 129.59 92.84 90.59 116.95 0.0049 135.52 107.14 89.07 122.81 0.0037 146.27 108.93 86.76 128.48 0.0043 137.61 97.13 79.29 119.9 0.0041 144.82 98.83 82.34 126.44 0.0044 140.9 95.47 66.59 119.8 0.0042 147.75 85.17 72.66 121.94 0.0039 149.96 86.65 67.32 123.45 0.0048 151.92 77.66 55.26 126.91 0.0043 162.6 85.85 69.54 135.51 0.0039 171.06 92.10 68.89 141.25 0.0039 173.1 94.03 64.47 142.66 0.0043 169.65 83.31 53.23 140.89 0.004 176.97 72.94 46.46 144.25 0.0041 175.25 72.16 46.01 144.04 0.004 150.88 66.14 36.92 124.86 0.0043 160.82 69.38 41.8 127.08 0.0046 173.29 64.14 51.71 138.6 0.0032 185.08 62.99 59.38 146.86 0.0031 196.03 68.25 58.65 154.06 0.0038 204.51 76.39 58.9 157.45 0.0035 198.8 73.84 58.19 153.28 0.0035 207.08 86.25 64.65 159.69 0.0043 214.57 75.53 80.02 166.01 0.0037 209.58 89.71 81.23 159.96 0.0034 220.86 93.40 94.07 167.45 0.004 213.71 103.62 95.36 166.97 0.0038 212.37 113.25 95.06 166.69 0.0039 206.07 113.18 93.49 165.1 0.0039 219.55 105.16 98.36 173.7 0.0039 224.26 111.73 104.4 178.61 0.0036 239.91 127.86 116.95 193.09 0.0044 227.06 141.61 101.39 182.06 0.0041 221.67 167.55 92.28 182.57 0.0043 243.8 150.34 92.4 195.21 0.0047 235.92 126.72 97.97 186.98 0.0046 229.69 111.68 79.67 182.27 0.005 235.2 123.59 90.44 188.43 0.004 231 110.20 90.49 183.15 0.0048 243.02 115.09 93.6 189.13 0.005 229.81 102.55 85.67 179.1 0.0051 BILL_monthly Oct 31, 2000 Nov 30, 2000 Dec 29, 2000 Jan 31, 2001 Feb 28, 2001 Mar 30, 2001 Apr 30, 2001 May 31, 2001 Jun 29, 2001 Jul 31, 2001 Aug 31, 2001 Sep 28, 2001 Oct 31, 2001 Nov 30, 2001 Dec 31, 2001 Jan 31, 2002 Feb 28, 2002 Mar 29, 2002 Apr 30, 2002 May 31, 2002 Jun 28, 2002 Jul 31, 2002 Aug 30, 2002 Sep 30, 2002 Oct 31, 2002 Nov 29, 2002 Dec 31, 2002 Jan 31, 2003 Feb 28, 2003 Mar 31, 2003 Apr 30, 2003 May 30, 2003 Jun 30, 2003 Jul 31, 2003 Aug 29, 2003 Sep 30, 2003 Oct 31, 2003 Nov 28, 2003 Dec 31, 2003 Jan 30, 2004 Feb 27, 2004 Mar 31, 2004 Apr 30, 2004 May 31, 2004 Jun 30, 2004 Jul 30, 2004 Aug 31, 2004 Sep 30, 2004 Oct 29, 2004 Nov 30, 2004 Dec 31, 2004 Jan 31, 2005 Feb 28, 2005 228.17 210.16 209.83 217.51 198.07 185.44 199.89 201.09 196.49 194.66 181.73 167.84 170.3 183.42 184.59 181.98 178.43 185.08 173.08 171.79 158.7 147.29 147.99 131.29 143.22 151.84 142.67 139.23 137.11 138.38 149.95 157.99 159.95 162.92 165.98 164.06 173.42 175.1 184.2 187.54 189.82 186.8 183.93 186.38 189.9 183.43 184.37 186.4 189.25 197.03 203.94 198.89 203.04 93.78 100.58 100.06 108.86 104.90 86.43 84.48 87.88 83.34 80.62 79.49 68.43 73.01 80.48 80.60 82.02 87.19 86.69 82.86 77.65 79.99 74.35 78.98 75.15 75.06 82.87 87.34 83.75 84.94 78.61 75.17 81.30 92.91 99.27 112.09 118.54 130.97 134.17 155.79 152.02 150.13 153.66 151.14 127.34 127.82 136.95 136.90 148.54 154.07 172.91 185.56 182.30 187.32 85.6 84.02 84.53 84.78 82.8 68.84 69.65 66.75 67.87 67.04 67.72 53.88 54.35 58.49 64.73 72.63 69.84 73.37 71.25 69.9 65.54 64.21 64.07 56.78 62.24 58.95 57.58 55.06 54.52 53.72 54.2 59.12 62.55 67.17 69.74 71.98 76.24 75.65 79.23 83.22 84.18 83.78 82.41 80.84 81.94 84.18 86.12 90.49 91.15 93.88 96.88 98.59 99.34 176.12 165.45 168.15 171.42 156.95 146.67 157.55 155.59 150.74 148.75 141.64 129.18 131.67 139.48 140.37 136.13 134.98 140.97 136.23 136.55 128.29 117.5 117.74 104.82 112.57 118.67 112.94 109.53 107.65 107.36 116.94 123.68 125.87 128.45 131.26 132.09 139.95 142.12 151.07 153.53 156.15 155.18 152.09 153.58 156.8 151.72 152.45 155.38 159.22 167.65 174.1 170.22 175.69 0.0056 0.0051 0.005 0.0054 0.0038 0.0042 0.0039 0.0032 0.0028 0.003 0.0031 0.0028 0.0022 0.0017 0.0015 0.0014 0.0013 0.0013 0.0015 0.0014 0.0013 0.0015 0.0014 0.0014 0.0014 0.0012 0.0011 0.001 0.0009 0.001 0.001 0.0009 0.001 0.0007 0.0007 0.0008 0.0007 0.0007 0.0008 0.0007 0.0006 0.0009 0.0008 0.0006 0.0008 0.001 0.0011 0.0011 0.0011 0.0015 0.0016 0.0016 0.0016 Mar 31, 2005 Apr 29, 2005 May 31, 2005 Jun 30, 2005 Jul 29, 2005 Aug 31, 2005 Sep 30, 2005 Oct 31, 2005 Nov 30, 2005 Dec 30, 2005 Jan 31, 2006 Feb 28, 2006 Mar 31, 2006 Apr 28, 2006 May 31, 2006 Jun 30, 2006 Jul 31, 2006 Aug 31, 2006 Sep 29, 2006 Oct 31, 2006 Nov 30, 2006 Dec 29, 2006 Jan 31, 2007 Feb 28, 2007 Mar 30, 2007 Apr 30, 2007 May 31, 2007 Jun 29, 2007 Jul 31, 2007 Aug 31, 2007 Sep 28, 2007 Oct 31, 2007 Nov 30, 2007 Dec 31, 2007 Jan 31, 2008 Feb 29, 2008 Mar 31, 2008 Apr 30, 2008 May 30, 2008 Jun 30, 2008 Jul 31, 2008 Aug 29, 2008 Sep 30, 2008 Oct 31, 2008 Nov 28, 2008 Dec 31, 2008 Jan 30, 2009 Feb 27, 2009 Mar 31, 2009 Apr 30, 2009 May 29, 2009 Jun 30, 2009 Jul 31, 2009 199.79 196.18 202.6 203.11 210.74 208.78 210.57 207.11 215.48 215.6 221.49 221.71 224.56 227.52 220.79 221.03 221.77 227.13 232.91 240.87 245.65 248.63 253.14 248.51 251.2 261.97 271.14 266.61 258.35 262.28 272.23 276.82 265.13 263.62 247.62 239.92 239.04 250.87 254.87 234.1 231.42 234.59 213.07 176.64 163.6 165.72 152.22 136.62 148.33 162.57 171.52 171.9 184.86 181.15 171.52 186.68 202.83 214.27 215.02 236.07 212.00 232.91 255.28 274.60 281.48 309.52 320.40 274.99 280.66 280.93 307.40 331.57 353.60 373.82 385.48 395.31 361.18 372.55 417.68 446.69 450.19 478.25 463.23 541.14 633.14 620.49 667.31 571.61 557.94 487.20 541.18 486.37 391.21 417.48 412.61 336.71 240.83 215.14 236.00 231.25 207.28 232.48 277.91 379.84 371.59 404.74 98.76 99.08 99.88 101.82 109.68 105.24 106.27 102.09 106.49 110.81 117.04 120.27 123.08 131.05 120.44 123.39 123.66 127.94 131.86 142.82 153.01 162.59 168.97 169.96 179.38 187.11 196.33 198.26 200.25 193.32 216.01 225.83 208.53 208.73 182.54 189.87 193.22 205.72 207.15 191.55 190.35 175.23 149.06 105.84 102.96 109.92 103.79 92.24 100 117.5 146.71 145.99 168.75 172.35 168.71 171.84 173.4 179.5 180.93 185.69 181.22 187.36 191.55 200.14 199.93 204.42 210.73 203.72 203.75 205.06 210.49 213.06 220.92 226.45 231.11 233.89 232.77 237.13 247.73 254.91 253.03 247.48 247.4 259.25 267.26 256.46 253.22 233.93 232.69 230.57 242.87 246.88 227.28 221.78 218.77 192.84 156.33 146.32 151.09 137.9 123.87 133.29 148.38 162.01 161.34 175.06 0.0021 0.0021 0.0024 0.0023 0.0024 0.003 0.0029 0.0027 0.0031 0.0032 0.0035 0.0034 0.0037 0.0036 0.0043 0.004 0.004 0.0042 0.0041 0.0041 0.0042 0.004 0.0044 0.0038 0.0043 0.0044 0.0041 0.004 0.004 0.0042 0.0032 0.0032 0.0034 0.0027 0.0021 0.0013 0.0017 0.0018 0.0018 0.0017 0.0015 0.0013 0.0015 0.0008 0.0003 0 0 0.0001 0.0002 0.0001 0 0.0001 0.0001 Aug 31, 2009 Sep 30, 2009 Oct 30, 2009 Nov 30, 2009 Dec 31, 2009 Jan 29, 2010 Feb 26, 2010 Mar 31, 2010 Apr 30, 2010 May 31, 2010 Jun 30, 2010 Jul 30, 2010 Aug 31, 2010 Sep 30, 2010 Oct 29, 2010 Nov 30, 2010 Dec 31, 2010 Jan 31, 2011 Feb 28, 2011 Mar 31, 2011 Apr 29, 2011 May 31, 2011 Jun 30, 2011 Jul 29, 2011 Aug 31, 2011 Sep 30, 2011 Oct 31, 2011 Nov 30, 2011 Dec 30, 2011 Jan 31, 2012 Feb 29, 2012 Mar 30, 2012 Apr 30, 2012 May 31, 2012 Jun 29, 2012 Jul 31, 2012 Aug 31, 2012 Sep 28, 2012 Oct 31, 2012 Nov 30, 2012 Dec 31, 2012 Jan 31, 2013 Feb 28, 2013 Mar 29, 2013 Apr 30, 2013 May 31, 2013 Jun 28, 2013 Jul 31, 2013 Aug 30, 2013 Sep 30, 2013 Oct 31, 2013 Nov 29, 2013 Dec 31, 2013 191.29 198.71 194.86 206.45 210.71 203.32 209.59 222.14 225.7 207.5 196.47 210.2 200.86 219.13 227.75 228.01 243.26 249.09 257.44 257.75 265.63 262.75 258.3 253.27 239.26 222.05 246.45 245.77 248.1 259.78 271.23 279.91 278.23 261.13 271.46 275.14 281.6 288.78 283.56 285.41 288.12 303.37 307.27 318.83 325.13 331.98 327.56 344.79 335.28 346.39 361.77 372.08 382.08 400.34 444.42 426.57 462.45 478.64 453.29 459.42 501.87 511.29 470.45 490.63 494.20 487.09 566.39 575.59 538.00 578.91 503.31 494.42 549.34 543.61 520.63 529.84 517.69 453.75 424.18 460.51 386.99 363.75 440.06 461.27 436.69 416.03 367.78 395.05 393.38 397.81 456.00 438.71 458.30 458.22 481.18 445.90 446.52 465.19 451.49 421.50 409.79 365.76 399.37 441.53 426.56 440.65 164.72 174.26 172.91 181.34 191.26 179.79 181.23 188.85 199.77 182.04 188.89 203.88 202.42 218.81 226.11 222.39 233.65 233.18 221.49 232.19 245.33 240.67 236.92 248.22 224.83 193.79 214.28 196.93 191.81 219.63 230.17 228.8 230.87 207.31 220.16 237.44 236.45 243.5 239.84 243.93 251.25 254.89 255.25 258.83 267.72 254.41 242.45 251.46 237.73 253.75 262.83 258.9 255.58 182.36 189.69 186.35 194.06 197.61 189.48 192.23 204.24 204.38 185 178.73 193.26 186.13 203.55 211.19 206.73 221.99 227.06 235.11 232.9 242.94 238.15 234.47 230.28 214.15 195.74 216.05 210.89 210.86 221.5 232.44 235.56 233.05 213.15 224.12 227.06 232.94 239.44 237.89 241.06 245.73 258.32 258.88 265.07 273.61 273.96 267.31 281.47 275.59 289.49 300.89 306.37 312.97 0.0001 0.0001 0 0 0.0001 0 0 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0.0001 0 0 0 0 0.0001 0 0 0 0 0 0 0 0 0.0001 0 0 0.0001 0.0001 0.0001 0.0001 0.0001 0 0 0 0 0 0 0 0 0 0 0 0 Jan 31, 2014 Feb 28, 2014 Mar 31, 2014 Apr 30, 2014 May 30, 2014 Jun 30, 2014 Jul 31, 2014 Aug 29, 2014 Sep 30, 2014 Oct 31, 2014 Nov 28, 2014 Dec 31, 2014 Jan 30, 2015 Feb 27, 2015 Mar 31, 2015 Apr 30, 2015 May 29, 2015 Jun 30, 2015 Jul 31, 2015 Aug 31, 2015 Sep 30, 2015 Oct 30, 2015 Nov 30, 2015 Dec 31, 2015 Jan 29, 2016 Feb 29, 2016 Mar 31, 2016 Apr 29, 2016 May 31, 2016 Jun 30, 2016 Jul 29, 2016 Aug 31, 2016 369.11 386.46 389.11 391.45 400.79 409.38 403.62 419.82 413.26 423.24 434.46 433.14 420.91 445.53 439.1 443.12 449.02 440.52 449.32 422.06 410.89 444.79 446.34 438.84 415.52 414.64 443.04 445.23 453.37 454.54 471.79 472.51 423.93 438.46 476.63 471.36 516.49 537.00 543.51 557.46 549.56 571.29 580.43 545.84 589.19 600.14 575.30 537.67 552.88 554.51 564.35 514.79 517.13 525.26 500.17 512.41 477.15 441.84 499.63 502.00 511.43 518.22 547.63 553.98 238.85 246.95 253.29 263.34 268.32 267.76 278.99 275.84 264.58 261.57 264.87 263.39 257.89 257.86 258.39 276.58 261.74 258.26 246.03 217.57 207.97 227.69 215.39 216.83 197.3 204.01 227.79 229.03 219.04 228.6 229.14 224.6 301.45 316.7 317.34 320.76 327.38 333.37 328.13 335.5 326.53 328.72 335.47 330.19 324.29 343.45 338.3 346.4 347.89 339.94 346.16 323.4 311.61 336.4 334.89 329.14 309.53 307.41 328.5 333.91 336.09 332.48 346.62 347.08 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0001 0.0001 0.0002 0.0002 0.0001 0.0001 0.0002 0.0002 0 Present graph here Chart Title 800 700 600 500 400 300 200 100 0 Jun 01, 1996 Jun 01, 1999 Jun 01, 2002 MSCI_US Jun 01, 2005 MSCI_IN Jun 01, 2008 MSCI_SG Jun 01, 2011 MSCI_world Jun 01, 2014 Perform data calculations here Jun 01, 2014 Display results here Average and standard deviation USA Returns Arithmatic Geometric Standard Deviation Difference India Singapore World Index Risk-free Perform any calcuations here Display results here Average excess returns and Sharpe Ratio USA Excess Returns Sharpe Ratio India Singapore World Index Perform any calcuations here Display results here Covariance matrix USA India Singapore USA India Singapore USA India Singapore Correlation matrix USA India Singapore Perform any calcuations here Display results here Allow short selling, leverage Portfolio weights US IN 0 Steps to finding optimal weights using Solver step 1 Install solver SG 0 Total 1 step 2 0 and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!