Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me calculate the risk free rate H B A D Date Value 9/27/2021 0:00 9/28/2021 0:00 9/29/2021 0:00 9/30/2021 0:00 10/1/2021 0:00 10/4/2021
Please help me calculate the risk free rate
H B A D Date Value 9/27/2021 0:00 9/28/2021 0:00 9/29/2021 0:00 9/30/2021 0:00 10/1/2021 0:00 10/4/2021 0:00 10/5/2021 0:00 10/6/2021 0:00 10/7/2021 0:00 10/8/2021 0:00 10/11/2021 0:00 10/12/2021 0:00 10/13/2021 0:00 10/14/2021 0:00 10/15/2021 0:00 10/18/2021 0:00 10/19/2021 0:00 10/20/2021 0:00 10/21/2021 0:00 10/22/2021 0:00 10/25/2021 0:00 10/26/2021 0:00 10/27/2021 0:00 10/28/2021 0:00 10/29/2021 0:00 11/1/2021 0:00 11/2/2021 0:00 11/3/2021 0:00 11/4/2021 0:00 11/5/2021 0:00 11/8/2021 0:00 11/9/2021 0:00 11/10/2021 0:00 11/11/2021 0:00 Daily Portfolio Return S997,695,67 S963,482.90 -3.43% 5958.863.27 -0.4896 $954,299.02 -0.48% 5956,212.78 0.20% 5930,723.57 -2.67% 5946.290.51 1.67% $947.169.51 0.09% 5956.790.87 1.029 S956,302.87 -0.05% S949,560.74 -0.71% 942,725.55 -0.72% $947.119.37 0.4794 S962,192.72 1.59% S967,060.42 0.51% $978,895.61 1.22% $982,256.19 0.34% 979.556,47 -0.27% S982.196.16 0.27% 5963,857.87 -1.8796 5967.984.41 0.43% $969,747.19 0.18% 5979.781.81 1.039 $990.102.24 1.0596 5990,639.14 0.05% 5985,540.65 -0.51% 5990,273.01 0.48% $999.594.21 0.94% $1,009,641.39 1.01% S1,015,912.96 0.62% S1.014,684.55 -0.1296 S1.016.929.24 0.22 5996,445,61 -2.01% $1,001,483.03 0.51% E F G Daily S&P 500 Date Adj Close Index Return 9/27/2021 0:00 $4.443.11 9/28/2021 0:00 $4,352.63 -2.04% 9/29/2021 0:00 $4,359.46 0.16% 9/30/2021 0:00 $4,307 54 - 1.19% 10/1/2021 0:00 $4,35704 1.15% 10/4/2021 0:00 $4,300.46 -1.30% 10/5/2021 0:00 $4,345.72 1.05% 10/6/2021 0:00 $4,363.55 0.41% 10/7/2021 0:00 $4,399.76 0.83% 10/8/2021 0:00 $4,391.34 -0.1996 10/11/2021 0:00 $4,361.19 -0.69% 10/12/2021 0:00 $4,350.65 -0.24% 10/13/2021 0:00 $4,363.80 0.30% 10/14/2021 0:00 $4,438.26 1.71% 10/15/2021 0:00 $4,471.37 0.75% 10/18/2021 0:00 $4,486.46 0.34% 10/19/2021 0:00 $4,519.63 0.74% 10/20/2021 0:00 $4,536.19 0.37% 10/21/2021 0:00 $4,549.78 0.3096 10/22/2021 0:00 $4,544.90 -0.11% 10/25/2021 0:00 $4,566 48 0.47% 10/26/2021 0:00 $4,574 79 0.18% 10/27/2021 0:00 $4.551.68 -0.51% 10/28/2021 0:00 $4,596.42 0.98% 10/29/2021 0:00 $4,605.38 0.19% 11/1/2021 0:00 $4,613.67 0.18% 11/2/2021 0:00 $4,630.65 0.37% 11/3/2021 0:00 $4.660.57 0.65% 11/4/2021 0:00 $4,680.06 0.4296 11/5/2021 0:00 $4,697.53 0.37% 11/8/2021 0:00 $4.701.70 0.0996 11/9/2021 0:00 $4,685 25 -0.35% 11/10/2021 0:00 $4,646.71 -0.82% 11/11/2021 0:00 $4,649.27 0.06% AERAAR B E D 26 10/29/2021 0:00 27 11/1/2021 0:00 28 11/2/2021 0:00 29 11/3/2021 0:00 30 11/4/2021 0:00 31 11/5/2021 0:00 32 11/8/2021 0:00 33 11/9/2021 0:00 34 11/10/2021 0:00 35 11/11/2021 0:00 36 11/12/2021 0:00 37 11/15/2021 0:00 38 11/16/2021 0:00 39 11/17/2021 0:00 40 41 42 Mean 43 StdDev 44 Holding Period Return (HPR 45 Annualized HPR 46 Annualized Std. Dev 47 Risk-free rate on 09/27/2021 48 Sharpe Ratio S990,639.14 S985.540.65 5990,273.01 S999.594.21 $1,009,641.39 S1.015,912.96 $1,014,684.53 $1,016929.24 S996,445,61 $1.001.483.03 $1,016,765.61 $1,020,144.61 S1.019,555.70 S1.013,371.42 0.0590 -0.5196 0.48% 0.9498 1.0196 0.629 -0.1296 0.2294 -2.0196 0.5194 1.5394 0.3396 -0.06% -0.6196 10/29/2021 0:00 11/1/2021 0:00 11/2/2021 0:00 11/3/2021 0:00 11/4/2021 0:00 11/5/2021 0:00 11/8/2021 0:00 11/9/2021 0:00 11/10/2021 0:00 11/11/2021 0:00 11/12/2021 0:00 11/15/2021 0:00 11/16/2021 0:00 11/17/2021 0:00 $4,605 38 $4,613.67 $4,630.65 $4.660.57 $4,680.06 $4,697.53 $4.701.70 $4,685 25 $4,646.71 $4,649 27 $4,682.85 $4,682.80 $4,700.90 $4,688.67 0.19% 0.18% 0.37% 0.6596 0.4296 0.3796 0.0996 -0.35% -0.82% 0.06% 0.72% 0.00% 0.39% -0.26% 0.05% 1.11% 1.57% 10.80% 17 63% 0.06% 60.93% H B A D Date Value 9/27/2021 0:00 9/28/2021 0:00 9/29/2021 0:00 9/30/2021 0:00 10/1/2021 0:00 10/4/2021 0:00 10/5/2021 0:00 10/6/2021 0:00 10/7/2021 0:00 10/8/2021 0:00 10/11/2021 0:00 10/12/2021 0:00 10/13/2021 0:00 10/14/2021 0:00 10/15/2021 0:00 10/18/2021 0:00 10/19/2021 0:00 10/20/2021 0:00 10/21/2021 0:00 10/22/2021 0:00 10/25/2021 0:00 10/26/2021 0:00 10/27/2021 0:00 10/28/2021 0:00 10/29/2021 0:00 11/1/2021 0:00 11/2/2021 0:00 11/3/2021 0:00 11/4/2021 0:00 11/5/2021 0:00 11/8/2021 0:00 11/9/2021 0:00 11/10/2021 0:00 11/11/2021 0:00 Daily Portfolio Return S997,695,67 S963,482.90 -3.43% 5958.863.27 -0.4896 $954,299.02 -0.48% 5956,212.78 0.20% 5930,723.57 -2.67% 5946.290.51 1.67% $947.169.51 0.09% 5956.790.87 1.029 S956,302.87 -0.05% S949,560.74 -0.71% 942,725.55 -0.72% $947.119.37 0.4794 S962,192.72 1.59% S967,060.42 0.51% $978,895.61 1.22% $982,256.19 0.34% 979.556,47 -0.27% S982.196.16 0.27% 5963,857.87 -1.8796 5967.984.41 0.43% $969,747.19 0.18% 5979.781.81 1.039 $990.102.24 1.0596 5990,639.14 0.05% 5985,540.65 -0.51% 5990,273.01 0.48% $999.594.21 0.94% $1,009,641.39 1.01% S1,015,912.96 0.62% S1.014,684.55 -0.1296 S1.016.929.24 0.22 5996,445,61 -2.01% $1,001,483.03 0.51% E F G Daily S&P 500 Date Adj Close Index Return 9/27/2021 0:00 $4.443.11 9/28/2021 0:00 $4,352.63 -2.04% 9/29/2021 0:00 $4,359.46 0.16% 9/30/2021 0:00 $4,307 54 - 1.19% 10/1/2021 0:00 $4,35704 1.15% 10/4/2021 0:00 $4,300.46 -1.30% 10/5/2021 0:00 $4,345.72 1.05% 10/6/2021 0:00 $4,363.55 0.41% 10/7/2021 0:00 $4,399.76 0.83% 10/8/2021 0:00 $4,391.34 -0.1996 10/11/2021 0:00 $4,361.19 -0.69% 10/12/2021 0:00 $4,350.65 -0.24% 10/13/2021 0:00 $4,363.80 0.30% 10/14/2021 0:00 $4,438.26 1.71% 10/15/2021 0:00 $4,471.37 0.75% 10/18/2021 0:00 $4,486.46 0.34% 10/19/2021 0:00 $4,519.63 0.74% 10/20/2021 0:00 $4,536.19 0.37% 10/21/2021 0:00 $4,549.78 0.3096 10/22/2021 0:00 $4,544.90 -0.11% 10/25/2021 0:00 $4,566 48 0.47% 10/26/2021 0:00 $4,574 79 0.18% 10/27/2021 0:00 $4.551.68 -0.51% 10/28/2021 0:00 $4,596.42 0.98% 10/29/2021 0:00 $4,605.38 0.19% 11/1/2021 0:00 $4,613.67 0.18% 11/2/2021 0:00 $4,630.65 0.37% 11/3/2021 0:00 $4.660.57 0.65% 11/4/2021 0:00 $4,680.06 0.4296 11/5/2021 0:00 $4,697.53 0.37% 11/8/2021 0:00 $4.701.70 0.0996 11/9/2021 0:00 $4,685 25 -0.35% 11/10/2021 0:00 $4,646.71 -0.82% 11/11/2021 0:00 $4,649.27 0.06% AERAAR B E D 26 10/29/2021 0:00 27 11/1/2021 0:00 28 11/2/2021 0:00 29 11/3/2021 0:00 30 11/4/2021 0:00 31 11/5/2021 0:00 32 11/8/2021 0:00 33 11/9/2021 0:00 34 11/10/2021 0:00 35 11/11/2021 0:00 36 11/12/2021 0:00 37 11/15/2021 0:00 38 11/16/2021 0:00 39 11/17/2021 0:00 40 41 42 Mean 43 StdDev 44 Holding Period Return (HPR 45 Annualized HPR 46 Annualized Std. Dev 47 Risk-free rate on 09/27/2021 48 Sharpe Ratio S990,639.14 S985.540.65 5990,273.01 S999.594.21 $1,009,641.39 S1.015,912.96 $1,014,684.53 $1,016929.24 S996,445,61 $1.001.483.03 $1,016,765.61 $1,020,144.61 S1.019,555.70 S1.013,371.42 0.0590 -0.5196 0.48% 0.9498 1.0196 0.629 -0.1296 0.2294 -2.0196 0.5194 1.5394 0.3396 -0.06% -0.6196 10/29/2021 0:00 11/1/2021 0:00 11/2/2021 0:00 11/3/2021 0:00 11/4/2021 0:00 11/5/2021 0:00 11/8/2021 0:00 11/9/2021 0:00 11/10/2021 0:00 11/11/2021 0:00 11/12/2021 0:00 11/15/2021 0:00 11/16/2021 0:00 11/17/2021 0:00 $4,605 38 $4,613.67 $4,630.65 $4.660.57 $4,680.06 $4,697.53 $4.701.70 $4,685 25 $4,646.71 $4,649 27 $4,682.85 $4,682.80 $4,700.90 $4,688.67 0.19% 0.18% 0.37% 0.6596 0.4296 0.3796 0.0996 -0.35% -0.82% 0.06% 0.72% 0.00% 0.39% -0.26% 0.05% 1.11% 1.57% 10.80% 17 63% 0.06% 60.93% Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started