Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed

Calculate:

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Financial Issues In Emerging Economies

Authors: Rita Biswas , Michael Michaelides

1st Edition

183867960X, 1838679618, 9781838679606, 9781838679613

More Books

Students also viewed these Finance questions