last 5 years (2021, 2020, 2019, 2018 and 2017) for Microsoft Corporation (MSFT) You can use yahoo finance
3. the annual rate of return (both arithmetic and continuous) for the last five years, the standard deviation and variance for those five years' monthly returns and the company's beta. Use monthly data, which means that you need to consider 61 prices (125=60, plus one because you need a base price to compute the first rate of return). To estimate the beta, you need to determine the covariance between the stock returns and the market returns. Use the SP500 index prices as a proxy to measure the American stock market. If the stock that you selected is traded in a different country, make sure that you select that country's market index returns. Annual Rate of Return The Annual Rate of Return refers to the amount of money that investors expect to receive at the end of every financial year. This rate is also used to encourage potential investors to invest in the company based on whether the company has a good ARR or not. The formula for finding ARR is as follows; Yearly Rate of Return =( EYP-BYP/BYP )100 where: EYP= End of year price For the financial year ending on 2017 , the annual rate of return was Yearly Rate of Return =((85.5462.58)/85.54)100 =26.841%p,a For the financial year ending on 2018, the annual rate of return was Yearly Rate of Return =((101.5785.95)/101.57)100 For the financial year ending on 2019 , the annual rate of return was Ycarly Rate of Return =((157.70101.57)/157.70)100 For the financial year ending on 2020 , the annual rate of retum was Yearly Rate of Return =((222.42157.70)/157.70)100 =41.04% p.a For the financial year ending on 2021, the annual rate of return was Yearly Rate of Return =((336.32217.69)/336.32)100 3. the annual rate of return (both arithmetic and continuous) for the last five years, the standard deviation and variance for those five years' monthly returns and the company's beta. Use monthly data, which means that you need to consider 61 prices (125=60, plus one because you need a base price to compute the first rate of return). To estimate the beta, you need to determine the covariance between the stock returns and the market returns. Use the SP500 index prices as a proxy to measure the American stock market. If the stock that you selected is traded in a different country, make sure that you select that country's market index returns. Annual Rate of Return The Annual Rate of Return refers to the amount of money that investors expect to receive at the end of every financial year. This rate is also used to encourage potential investors to invest in the company based on whether the company has a good ARR or not. The formula for finding ARR is as follows; Yearly Rate of Return =( EYP-BYP/BYP )100 where: EYP= End of year price For the financial year ending on 2017 , the annual rate of return was Yearly Rate of Return =((85.5462.58)/85.54)100 =26.841%p,a For the financial year ending on 2018, the annual rate of return was Yearly Rate of Return =((101.5785.95)/101.57)100 For the financial year ending on 2019 , the annual rate of return was Ycarly Rate of Return =((157.70101.57)/157.70)100 For the financial year ending on 2020 , the annual rate of retum was Yearly Rate of Return =((222.42157.70)/157.70)100 =41.04% p.a For the financial year ending on 2021, the annual rate of return was Yearly Rate of Return =((336.32217.69)/336.32)100
