Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question-1: Some asset price data has been assigned to your name (see attached excel file). Input the price data in the following table. 10 a)

image text in transcribed

Question-1: Some asset price data has been assigned to your name (see attached excel file). Input the price data in the following table. 10 a) calculate the return for the years, 2015, 2016, 2017, 2018, 2019, 2020, 2021. Year Price (Tk) Return (%) 2014 ./4, 59,4 2015 12 60/4 60,4 2016 6/3.0 63.0 2017 619.7 69.7 2018 68.5 68.8 2019 88.5 2020 69,1 2021 69.5 [For example-consider 2014 price (Tk 10) as beginning price and 2015 price (Tk 12) as ending price. Then calculate - Return (2015)= (2015 Price- 2014 Price)/2014 price = (12-10)/10 = 0.02 or 2% Likewise do the same for other years (2016, 2017, 2018, 2019, 2020, 2021). Return on 2014 will remain empty] b) Calculate average return, standard deviation, and semi-deviation from the returns of 2015- 2021

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_2

Step: 3

blur-text-image_3

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

Get Funded The Startup Entrepreneurs Guide To Seriously Successful Fundraising

Authors: John Biggs, Eric Villines

1st Edition

1260459063, 978-1260459067

More Books

Students also viewed these Finance questions