skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

-It has to be excel sheet -avoid plagiarism-explain the answers and how you get the correct answer Measurement of Risk and Return in Investing*Complete the problems in an Excel spreadsheet. Be sure to show your work to receive credit; no hard keys.Problem 6-1: Rate of return and standard deviation A stock currently is paying 5% return. Calculate the following investment’s expected rate of return and its standard deviation based on the data below. DATA Probability Return 0.15 -0.05 0.25 0.15 0.2 0.2 0.4 0.25 Problem 6- 2 Holding-Period Return Calculate the following investment’s the holding-period return. DATA TIME STOCK PRICE (SAR) 1 20 2 23 3 21 4 25 Problem 6-3: Holding-Period Gain SAR and Return Calculate the following investment’s the holding-period gain and return based on the data below. DATA Purchase price 34.22 Selling price 36.68 Shares sold 22 Problem 6-4: Capital Asset Pricing Model Based on the data below, calculate the required rate of return for each stock. DATA Stock Beta A 0.85 B 0.6 C 1.4 Risk-free rate 0.05 Market rate 0.12 Problem 6-5: Security Market Line Based on the data below, calculate portfolio’s return and beta. DATA Stock % of Portfolio Beta Expected Return 1 0.5 0.85 0.12 2 0.3 0.75 0.11 3 0.35 2 0.15 risk-free rate 0.05 Market rate 0.1 Problem 6-6: Required Rate of Return CAPM Calculate the required rate of return by using CAPM based on the data below. DATA Risk-free rate = 0.04 Market Risk Premium = 0.10 Beta = 1.2 Problem 6-7: Expected Return, Standard DeviationCalculate Adidas’ and S&P 500 Index’s average rate of returns and standard deviation, based on the data below. DATA Month Adidas S&P 500 Stock Prices Index Jan-19 52.9 2368.45 Feb-19 67.16 2363.64 Mar-19 68.73 2362.72 Apr-19 65.41 2384.2 May-19 62.99 2411.8 Jun-19 70.1 2423.41 Jul-19 69.05 2470.3 Aug-19 62.81 2471.65 Sep-19 61.85 2519.36 Oct-19 64.99 2575.26 Nov-19 70.42 2647.58 Dec-19 72.55 2673.61

GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don't hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®

Back To Top