Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the annual return for the period 2010-2020 for the risk-free asset using the data given for the risk-free asset. Then calculate the average return
Calculate the annual return for the period 2010-2020 for the risk-free asset using the data given for the risk-free asset.
Then calculate the average return for the risk-free asset. Please use Excel and show your formula, thanks!
The risk-free asset:
Calculate:
Year end Dec-2010 Dec-2011 Dec-2012 Dec-2013 Dec-2014 Dec-2015 Dec-2016 Dec-2017 Dec-2018 Dec-2019 Dec-2020 3-month Bank bill rate (%) 5.03 4.51 3.11 2.61 2.75 2.34 1.78 1.77 2.02 0.90 0.02 Risk free rate (%) ? ? ? Return_risk-free asset ? ? ? ? ? ? ? Year 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Average ? ? ? ? ? ? ? ? ? ? Year end Dec-2010 Dec-2011 Dec-2012 Dec-2013 Dec-2014 Dec-2015 Dec-2016 Dec-2017 Dec-2018 Dec-2019 Dec-2020 3-month Bank bill rate (%) 5.03 4.51 3.11 2.61 2.75 2.34 1.78 1.77 2.02 0.90 0.02 Risk free rate (%) ? ? ? Return_risk-free asset ? ? ? ? ? ? ? Year 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Average ? ? ? ? ? ? ? ? ?
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