Question: 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)

Question-1: Some asset price data has been assigned to your name

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

TruVu is a manufacturer of contact lenses and uses the weighted-average method of process costing. TruVu's production facility produces millions of lenses every month. Direct materials are all added...

Asset prices: 2014-55.9 2015-56.9 2016-54.9 2017-56.0 2018-56.1 2019-57.1 2020-55.2 2021-56.0 Question-1: Some asset price data has been assigned to your name (see appendix). Input the price data in...

Please help me figure out these ratios, I made mistake in the first Excel assignment, and cannot figure out the second one. I attached the my excel assignment along with the question pdf. For my...

ONDRAYA STORE CASE: The Concept The Opportunity K. Ondraya is considering entering the womenswear market by opening a store in Calgary and has collected the following information. Because of the...

Finance Excel ASS: Ratios 1. Financial Data Using the same company you selected in Module Three, add another two years of financial statement data so that you have three years of annual data to...

Case Study analysis assignment. MARKETING PLAN. Group assignment. 1 file per group. ONDRAYA STORE CASE: The Concept The Opportunity K. Ondraya is considering entering the womenswear market by opening...

it is a case study for marketing plan of Ondraya Store, Calgary Sales Forecast Year 1 Year 2 Year 3 Sales Revenue Put in the forecasted numbers in $. Kase Study analysis assignment. MARKETING PLANA...

I NEEDTHIS ASSIGNMENT DONE i WILL TIP 30 Here is the assignment and my spread sheet so far The financial statements were given, I just need to do the calculations at the bottom of the first three...

Case: Managing supplier Quality: Integrated Devices Bill Edwards is a quality engineer assigned to the Injected Molding Commodity Team at Integrated Devices. The commodity team is responsible for...

Question-1: Some asset price data has been input the price data in the following table. a) calculate the return for the years, 2015, 2016, 2017, 2018, 2019, 2020, 2021. Year Price 2014 40.7 2015 41.7...

Given a scenario and a dataset (see attached excel file), you are required to run regression of the dataset, and present your results in a report. In your report, you should include an introduction...

Define consistency.

What will be the amount of heat change at constant pressure? a) 223.53 cal b) 371.25 Cal c) 155.8 Cal d) 355.68 Cal 22. What will be the amount of work done in the process ? a) -62.32 Cal b) -140.925...

Explain briefly how the IF and VLOOKUP functions can be used in financial modelling providing examples of each

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...