Question

calculate the monthly time-weighted and money weighted returns for shareholders in the ADKSX with using excel....

calculate the monthly time-weighted and money weighted returns for shareholders in the ADKSX with using excel. In a text box nearby, comment on whether investors’ trading decisions have created value.

Month ADKSX Return (%) ADKSX Cash Flow ($)
Nov-09 3.49 -$10,648,393
Dec-09 6.93 -$618,800
Jan-10 -2.05 $940,820
Feb-10 5.74 -$2,484,437
Mar-10 5.19 -$3,699,836
Apr-10 5.48 -$1,379,757
May-10 -4.68 $2,145,936
Jun-10 -6.31 -$2,953,884
Jul-10 5.9 -$4,160,472
Aug-10 -5.18 $1,096,304
Sep-10 8.61 -$5,571,657
Oct-10 4.5 -$669,464
Nov-10 2.77 -$3,145,367
Dec-10 9.16 -$6,162,018
Jan-11 0.13 -$598,724
Feb-11 4.61 -$5,193,195
Mar-11 1.68 -$1,867,372
Apr-11 1.59 -$5,787,661
May-11 -1.44 $939,196
Jun-11 -2.01 -$8,659,954
Jul-11 -2.05 -$4,788,384
Aug-11 -9.21 $4,965,357
Sep-11 -9.1 -$1,883,066
Oct-11 9.93 -$14,263,069
Nov-11 -3.57 $8,125,462
Dec-11 2.85 -$6,061,345
Jan-12 7.51 -$5,746,866
Feb-12 3.09 $2,736,332
Mar-12 2.54 -$1,292,755
Apr-12 -3.94 $4,966,330
May-12 -6.22 $685,191
Jun-12 6.56 -$10,979,794
Jul-12 -0.53 $5,493,510
Aug-12 2.46 -$2,541,394
Sep-12 3.18 -$1,832,990
Oct-12 -2.01 $3,863,418
Nov-12 0.9 -$5,249,329
Dec-12 2.74 -$2,779,842
Jan-13 5.53 -$6,216,814
Feb-13 0.77 $3,947,213
Mar-13 4.91 -$4,713,550
Apr-13 -1.22 $5,687,708
May-13 3.83 -$10,980,264
Jun-13 2.17 $547,420
Jul-13 8.08 -$12,609,468
Aug-13 -3.79 -$9,483,183
Sep-13 5.83 -$18,739,327
Oct-13 3.33 -$1,455,317
Nov-13 5.65 -$8,224,571
Dec-13 3.16 -$1,150,847
Jan-14 -2.73 -$9,303,278
Feb-14 3.68 -$28,847,135
Mar-14 1.68 -$12,084,903
Apr-14 -4.36 -$12,713,165
May-14 0.36 -$17,804,063
Jun-14 3.45 -$11,626,738
Jul-14 -4.87 $35,413,624
Aug-14 4.48 -$27,097,660
Sep-14 -6.54 $32,965,860
Oct-14 1.94 -$2,819,541
Nov-14 1.21 $5,033,000
Dec-14 3.79 $2,346,479
Jan-15 -5.38 $42,499,034
Feb-15 6.38 -$16,763,972
Mar-15 3.47 -$4,860,017
Apr-15 -1.31 -$6,274,145
May-15 0.14 -$14,844,855
Jun-15 -1.88 -$932,434
Jul-15 -3.04 -$3,114,419
Aug-15 -3.71 -$3,494,407
Sep-15 -5.41 -$6,052,531
Oct-15 5.71 -$31,921,982
Nov-15 3.4 $8,694,246
Dec-15 -3.46 $24,371,295
Jan-16 -6.85 $13,372,071
Feb-16 1.61 -$24,982,153
Mar-16 4.38 -$6,115,002
Apr-16 0.84 $13,374,544
May-16 0.52 $4,477,632
Jun-16 -1.24 $23,410,848
Jul-16 6.82 -$12,838,062
Aug-16 2.36 $16,083,080
Sep-16 1.77 $4,967,151
Oct-16 -4.05 $18,242,506
Nov-16 10.31 -$34,134,702
Dec-16 2.29 $26,704,823
Jan-17 0.9 $5,906,279
Feb-17 -0.44 $3,771,133
Mar-17 1.03 $1,709,143
Apr-17 0.62 $3,124,164
May-17 -0.48 $28,317,223
Jun-17 1.77 $5,125,779
Jul-17 0.22 $7,081,482
Aug-17 -2.25 $8,815,809
Sep-17 6.6 -$19,239,222
Oct-17 -0.33 $19,668,033
Nov-17 2.5 -$6,509,556
Dec-17 0.2 $11,719,426
Jan-18 0.67 -$12,752,620
Feb-18 -5.37 $17,143,225
Mar-18 0.33 -$13,934,286
Apr-18 1.36 -$780,801
May-18 1.15 $1,462,751
Jun-18 3.33 -$6,608,870
Jul-18 1.54 $7,472,658
Aug-18 2.61 -$1,955,692
Sep-18 -1.61 $14,319,574
Oct-18 -11.96 $227,713,787
0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
calculate the monthly time-weighted and money weighted returns for shareholders in the ADKSX with using excel....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • If there are any seasonality or relationship between the price and the US oil price? How...

    If there are any seasonality or relationship between the price and the US oil price? How to analyze? Jan-10 2.769 Jan-11 3.148 Jan-12 3.44 Jan-13 3.391 Jan-14 3.392 Feb-10 2.699 Feb-11 3.264 Feb-12 3.64 Feb-13 3.736 Feb-14 3.434 Mar-10 2.824 Mar-11 3.615 Mar-12 3.907 Mar-13 3.779 Mar-14 3.606 Apr-10 2.9 Apr-11 3.852 Apr-12 3.958 Apr-13 3.638 Apr-14 3.735 May-10 2.89 May-11 3.96 May-12 3.791 May-13 3.675 May-14 3.75 Jun-10 2.785 Jun-11 3.735 Jun-12 3.596 Jun-13 3.689 Jun-14 3.766 Jul-10 2.782...

  • Calculate the sample correlation coefficient rxy. Calculate the value of the test statistic. Date Energy Healthcare...

    Calculate the sample correlation coefficient rxy. Calculate the value of the test statistic. Date Energy Healthcare Jan-10 -4.87 -0.15 Feb-10 1.8 0.53 Mar-10 2.26 1.41 Apr-10 3.03 -3.75 May-10 -11.5 -5.12 Jun-10 -5.67 -0.52 Jul-10 8.73 1.49 Aug-10 -5.99 -0.97 Sep-10 10.15 8.24 Oct-10 3.89 2.28 Nov-10 2.85 -2.52 Dec-10 5.55 1.4 Jan-11 6.6 1.55 Feb-11 5.7 3.04 Mar-11 1.32 1.22 Apr-11 1.64 5.89 May-11 -4.06 2.62 Jun-11 -2.08 -0.55 Jul-11 1.14 -2.64 Aug-11 -10.41 -2.8 Sep-11 -15.06 -4.17 Oct-11...

  • Consider five years of monthly sales data for a company in the attached file (Q5.xlsx). a) Foreca...

    Consider five years of monthly sales data for a company in the attached file (Q5.xlsx). a) Forecast monthly sales for the next year (2020). (10 marks) b) Discuss whether a simple exponential smoothing model works well with this data or not. (5 m 7 9 Month Sales 747 Feb-14 697 Mar-14 1014 Jan-14 Ap4 1126 May-14 1105 Jun-14 1450 Jul-14 1633 Aug-14 1711 Sep-14 1307 Oct-1223 Nov-14 9T5 Dec-14S53 4J-15 1024 Feb-15928 Mar-151442 7Apr-151371 May-15 1536 Ju15 2004 Jul-15 1854...

  • From the following monthly stock prices assume rf of 0.5% per month and calculate 1.Monthly growth...

    From the following monthly stock prices assume rf of 0.5% per month and calculate 1.Monthly growth return 2.CAPM and beta 3.Average return 4.Variance 5.Covariance 6. Assume a credit rating and calculate a VAT assuming debt to equity structure 1 date share price benchmark 2 Mar 18 3 Feb-18 4 Jan-18 5 Dec-17 6 Nov-17 7 Oct-17 8 Sep-17 304.85 24,263.35 322.3 25,107.40 354.4 27,379.45 315.15 25,539.45 306.9 25,332.40 314.25 25,019.35 350 24.053.00 350.61 24,318.40 361.9 25,103.65 292.7 23,211.20 286.27 23,424.80...

  • Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average...

    Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...

  • Date Gasoline Crude Oil Jan 01, 2010 2.031 79.07 Jan 08, 2010 2.124 82.34 Jan 15,...

    Date Gasoline Crude Oil Jan 01, 2010 2.031 79.07 Jan 08, 2010 2.124 82.34 Jan 15, 2010 2.079 80.06 Jan 22, 2010 2.010 76.62 Jan 29, 2010 1.942 73.94 Feb 05, 2010 1.885 74.57 Feb 12, 2010 1.908 73.88 Feb 19, 2010 2.031 78.25 Feb 26, 2010 2.042 79.22 Mar 05, 2010 2.127 80.19 Mar 12, 2010 2.154 81.76 Mar 19, 2010 2.150 81.44 Mar 26, 2010 2.118 80.65 Apr 02, 2010 2.191 83.01 Apr 09, 2010 2.238 85.66 Apr...

  • Use the data table to estimate the alpha of Nike and HP Inc. ​stock, expressed as​...

    Use the data table to estimate the alpha of Nike and HP Inc. ​stock, expressed as​ % per month. Monthly Returns Date Nike HP Inc. S&P 500 Jan-11 -3.442% 8.527% 2.330% Feb-11 7.941% -4.509% 3.474% Mar-11 -14.624% -5.913% -0.005% Apr-11 8.745% -1.465% 2.896% May-11 2.587% -7.406% -1.121% Jun-11 6.915% -2.301% -1.706% Jul-11 0.189% -3.379% -2.000% Aug-11 -3.882% -25.988% -5.498% Sep-11 -0.958% -13.292% -6.910% Oct-11 12.677% 18.530% 10.915% Nov-11 -0.176% 5.036% -0.406% Dec-11 0.572% -7.406% 1.024% Jan-12 7.907% 8.618% 4.637% Feb-12...

  • Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 De...

    Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 Dec-13 6 Mar-14 un-14 Jul-14 14 ep-14 ct-14 4.67 9.05 8.57 Feb-15 5.02 4.8 Apr-15 0.58 7.79 Aug-15 4.83 5.81 Dec-15 11.81 1.5 8.84 1.8 12.42 Apr-16 May-16 2.62 2.75 0.04 5.2 4.95 0.59 7.67 Jul-16 Aug-16 Dec-16 0.2 5.23 The following table shows a portion of the monthly returns data (in percent) for 2010-2016 for two of Vanguard's mutual funds: the Vanguard Energy Fund and the...

  • Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 Dec-13 6 Mar-14...

    Energy Healthcare May-11 Sep-11 Oct-11 Jun-12 Sep-12 Oct-12 Nov-12 Dec-12 Mar-13 May-13 Oct-13 Dec-13 6 Mar-14 un-14 Jul-14 14 ep-14 ct-14 4.67 9.05 8.57 Feb-15 5.02 4.8 Apr-15 0.58 7.79 Aug-15 4.83 5.81 Dec-15 11.81 1.5 8.84 1.8 12.42 Apr-16 May-16 2.62 2.75 0.04 5.2 4.95 0.59 7.67 Jul-16 Aug-16 Dec-16 0.2 5.23 The following table shows a portion of the monthly returns data (in percent) for 2010-2016 for two of Vanguard's mutual funds: the Vanguard Energy Fund and the...

  • On Blackboard under "Course Content / Homeworks and Practice Tests" there is an Excel file titled...

    On Blackboard under "Course Content / Homeworks and Practice Tests" there is an Excel file titled "HW 6 Data" with monthly stock return data to be used for this question: What is Deckers Outdoor Corporation's [DECK] beta? Round to two decimal places. [Hint: Take S&P 500 as a proxy for the market, and use the beta formula from the book. You will need to use two Excel functions: STDEV.S and CORREL] Numeric Answer S&PS00 DECK NKE SBUX -1.5% Ос-19 7.4%...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT