Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use Adj Close column to compute the monthly risk-free rates from October 2015 to September 2020. Compute the annual percentage rate of the monthly average

Use Adj Close column to compute the monthly risk-free rates from October 2015 to September 2020. Compute the annual percentage rate of the monthly average risk-free rate based on ^IRX sheet in the uploaded Yahoo Finance Excel file. (If the answer is 12.34%, then submit 12.34 instead of 0.1234 or 12.34%.)image text in transcribed

H A B C D E F G 1 Date Open High Low Close Adj Close Volume 2 2015/8/1 0.058 0.103 0.003 0.05 0.05 0 3 2015/9/1 0.063 0.063 0.003 0.005 0.005 0 4 2015/10/1 0.003 0.068 0.003 0.068 0.068 0 5 2015/11/1 0.073 0.175 0.033 0.17 0.17 0 6 2015/12/1 0.21 0.27 0.135 0.148 0.148 0 7 2016/1/1 0.165 0.32 0.153 0.3 0.3 0 8 2016/2/1 0.3 0.343 0.255 0.30 0.308 0 9 2016/3/1 0.318 0.328 0.15 0.193 0.193 0 10 2016/4/1 0.193 0.248 0.183 0.193 0.193 0 11 2016/5/1 0.193 0.348 0.18 0.283 0.283 0 12 2016/6/1 0.33 0.333 0.225 0.248 0.248 0 13 2016/7/1 0.243 0.315 0.215 0.24 0.24 0 14 2016/8/1 0.258 0.328 0.235 0.32 0.32 0 15 2016/9/1 0.32 0.36 0.158 0.26 0.26 0 16 2016/10/1 0.273 0.348 0.268 0.295 0.295 0 17 2016/11/1 0.343 0.51 0.343 0.468 0.468 0 18 2016/12/1 0.47 0.528 0.42 0.48 0.48 0 19 2017/1/1 0.488 0.535 0.473 0.5 0.5 0 20 2017/2/1 0.505 0.538 0.48 0.523 0.523 0 21 2017/3/1 0.625 0.775 0.608 0.738 0.738 0 22 2017/4/1 0.74 0.81 0.738 0.78 0.78 0 23 2017/5/1 0.78 0.955 0.778 0.95 0.95 0 24 2017/6/1 0.953 1.01 0.928 0.993 0.993 0 25 2017/7/1 1 1.173 0.998 1.053 1.053 0 26 2017/8/1 1.058 1.07 0.965 0.978 0.978 0 27 2017/9/1 0.98 1.053 0.97 1.028 1.028 0 28 2017/10/1 1.033 1.123 1.013 1.123 1.123 0 29 2017/11/1 1.123 1.29 1.123 1.238 1.238 0 30 2017/12/1 1.238 1.435 1.23 1.355 1.355 0 31 2018/1/1 1.388 1.443 1.368 1.43 1.43 0 32 2018/2/1 1.425 1.64 1.42 1.618 1.618 0 33 2018/3/1 1.61 1.76 1.588 1.67 1.67 0 34 2018/4/1 1.683 1.835 1.66 1.763 1.763 0 35 2018/5/1 1.823 1.893 1.78 1.87 1.87 0 36 2018/6/1 1.868 1.915 1.853 1.88 1.88 0 37 2018/7/1 1.875 1.995 1.875 1.985 1.985 0 38 2018/8/1 1.98 2.08 1.955 2.055 2.055 0 39 2018/9/1 2.058 2.17 2.058 2.15 2.15 0 40 2018/10/1 2.158 2.29 2.153 2.278 2.278 0 41 2018/11/1 2.278 2.358 2.268 2.308 2.308 0 42 2018/12/1 2.31 2.4 2.288 2.3 2.3 0 43 2019/1/1 2.395 2.403 2.305 2.34 2.34 0 44 2019/2/1 2.34 2.4 2.335 2.383 2.383 0 0 45 2019/3/1 2.385 2.418 2.328 2.328 2.328 0 46 2019/4/1 2.343 2.39 2.32 2.368 2.368 0 47 2019/5/1 2.37 2.373 2.288 2.293 2.293 0 48 2019/6/1 2.28 2.3 2.035 2.035 2.035 0 49 2019/7/1 2.055 2.208 1.968 2.03 2.03 0 50 2019/8/1 2.023 2.048 1.823 1.933 1.933 0 51 2019/9/1 1.93 1.965 1.7 1.77 1.77 0 52 2019/10/1 1.805 1.805 1.495 1.498 1.498 0 53 2019/11/1 1.495 1.585 1.48 1.54 1.54 0 54 2019/12/1 1.55 2 1.478 1.505 1.505 0 55 2020/1/1 1.51 1.535 1.46 1.51 1.51 0 56 2020/2/1 1.513 1.545 1.23 1.23 1.23 0 57 2020/3/1 1.09 3.39 -0.235 0.03 0.03 0 58 2020/4/1 0.085 0.26 0.04 0.09 0.09 0 59 2020/5/1 0.088 0.14 0.078 0.128 0.128 60 2020/6/1 0.13 0.168 0.125 0.135 0.135 61 2020/7/1 0.135 0.143 0.083 0.083 0.083 62 2020/8/1 0.083 0.103 0.075 0.095 0.095 63 OOOO

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions