Excel Online Structured Activity: Black-Scholes Model Assume the following inputs for a call option: (1) current stock price is $29, (2) strike price is $35, (3) time to expiration is 4 months, (4) annualized risk-free rate is 4%, and (5) variance of stock return is 0.32. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Black-Scholes Model Current price of underlying stock, P $29.00 Strike price of the option, X $35.00 Number of months unitl expiration 4 Formulas Time until the option expires, t #N/A Risk-free rate, rRF 4.00% Variance, \sigma 2 0.32 d1 = #N/A N(d1) = 0.5000 d2 = #N/A N(d2) = 0.5000 VC = #N/A Use the Black-Scholes model to find the price for the call option. Do not round intermediate calculations. Round your answer to the nearest cent. $ fill in the blank.

Excel Online Structured Activity: Black-Scholes Model Assume the following inputs for a call option: (1) current stock price is $29, (2) strike price is $35, (3) time to expiration is 4 months, (4) annualized risk-free rate is 4%, and (5) variance of stock return is 0.32. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Black-Scholes Model Current price of underlying stock, P $29.00 Strike price of the option, X $35.00 Number of months unitl expiration 4 Formulas Time until the option expires, t #N/A Risk-free rate, rRF 4.00% Variance, \sigma 2 0.32 d1 = #N/A N(d1) = 0.5000 d2 = #N/A N(d2) = 0.5000 VC = #N/A Use the Black-Scholes model to find the price for the call option. Do not round intermediate calculations. Round your answer to the nearest cent. $ fill in the blank.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter12: The Cost Of Capital

Section: Chapter Questions

Problem 25P

See similar textbooks

Similar questions

Assume the following inputs for a call option: (1) current stock price is $23, (2) strike price is $28, (3) time to expiration is 5 months, (4) annualized risk-free rate is 5%, and (5) variance of stock return is 0.3. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Use the Black-Scholes model to find the price for the call option. Do not round intermediate calculations. Round your answer to the nearest cent.
Video Excel Online Structured Activity: Black-Scholes Model Assume the following inputs for a call option: (1) current stock price is $26, (2) strike price is $30, (3) time to expiration is 6 months, (4) annualized risk-free rate is 6%, and (5) variance of stock return is 0.2. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet Use the Black-Scholes model to find the price for the call option. Do not round intermediate calculations. Round your answer to the nearest cent. $
The market and Stock J have the following probability distributions: Probability rM rJ 0.3 15.00 % 19.00 % 0.4 10.00 6.00 0.3 18.00 10.00 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the expected rate of return for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank % Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the standard deviation for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %
You want to estimate the monthly alpha and beta of AXON stock, using the index model. Suppose AXON has a beta of 0.95 and a monthly alpha of 0.5 (representing half a percent). If you set up the regression model correctly, the index model equation should be (remember in index model formulas, we use R instead of r to denote excess returns): Select an answer and submit. For keyboard navigation, use the up/down arrow keys to select an answer. b с d Rmarket = Rmarket = 0.5 x Rstock +0.95 Raxon 0.95 x Rstock +0.5 = 0.5 x Rmarket +0.95 Raxon = 0.95 x Rmarket +0.5
Karen Kay, a portfolio manager at Collins Asset Management, is using thecapital asset pricing model (CAPM) for making recommendations to her clients.Her research department has developed the information shown in the followingexhibit.Forecast Returns, Standard Deviations, and BetasForecast Return Standard Deviation BetaLow β stock (X) 14.0% 36% 0.8High β stock (Y) 17.0% 25% 1.5Market index 14.0% 15% 1.0Risk-free rate 5.0%(a) Calculate expected return and alpha for each stock.(b) Identify and justify which stock would be more appropriate for an investorwho wants to add this stock to a well-diversified equity portfolio.(c) Now consider Karen employs the “Betting Against Beta” strategy and let, , and denote the portfolio weights of the investmentin each of the asset classes (e.g. risk-free asset, low beta stock, market index,high beta stock, respectively) such that .According to its investment mandate, Collins Asset Management shouldtarget a gross leverage of 2.3. How much does she have to…
(Expected rate of return and risk) Syntex, Inc. is considering an investment in one of two common stocks. Given the information that follows, which investment is better, based on the risk (as measured by the standard deviation) and return? Common Stock A Probability 0.20 0.60 0.20 Probability 0.15 0.35 0.35 0.15 (Click on the icon in order to copy its contents into a spreadsheet.) ew an example Get more help. T 3 a. Given the information in the table, the expected rate of retum for stock A is 15.6 %. (Round to two decimal places.) The standard deviation of stock A is %. (Round to two decimal places.) E D 80 73 Return. 12% 16% 18% U с $ 4 R F 288 F4 V Common Stock B % 5 T FS G 6 Return -7% 7% 13% 21% B MacBook Air 2 F& Y H & 7 N 44 F? U J ** 8 M | MOSISO ( 9 K DD O . Clear all : ; y 4 FIX { option [ + = ? 1 Check answer . FV2 } ◄ 1 delete 1 return shift
The following table represents the rate of returns of two stocks in different economic conditions along with their probabilities (the data are also uploaded on moodle) RATES OF RETURN ON STOCKS EXPECTED ECONOMIC PROBABILITY STOCK A STOCK B CONDITIONS RECESSION 0.55 -0.04 -0.02 STABLE 0.35 0.25 0.30 EXPANDING 0.10 0.15 0.20 Answer the following by using mathematical calculations: a) Calculate the expected rate of return for each stock respectively. Explain what the expected value implies. b) Calculate the standard deviation for each stock respectively. Explain what the standard deviation implies. c) If you were an investor in which stock you were going to invest? Justify your answer. d) Calculate the covariance between Stock A and stock B. Discuss. e) Calculate the expected return and the standard deviation of the portfolio consisting 40% in stock A and 60% in stock B. f) Discuss the risk and return associated with investing i All of your funds in stock A ii. All of your funds in stock…
Excel Online Structured Activity: Historical Return: Expected and Required Rates of Return You have observed the following returns over time: Year Stock X Stock Y Market 2011 14 % 12 % 10 % 2012 20 7 9 2013 -13 -2 -13 2014 3 1 2 2015 19 9 12 Assume that the risk-free rate is 4% and the market risk premium is 6%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is the beta of Stock X? Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 2 What is the beta of Stock Y? Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 3 What is the required rate of return on Stock X? Do not round intermediate calculations. Round your answer to one decimal place. fill in the blank 4 % What is the required rate of return on Stock…
You run a regression for a stock's return on a market index and find the following Excel output: Multiple R 0.35 R-Square 0.12 Adjusted R-Square 0.02 Standard Error 38.45 Observations 12 Coefficients Standard Error t-Stat p-Value Intercept 4.05 15.44 0.26 0.80 Market 1.32 0.97 1.36 0.10 The stock is ________ riskier than the typical stock
Please see the attached diagram image. Please show how to solve this problem and please show all steps and formulas in Excel. Based on the Capital Asset Pricing Model (CAPM) and the diagram below, what is the return of the stock if its beta is 1.2 or 0.8?
Stock X has a 9.5% expected return, a beta coetticient ot 0.8, and a 35% standard deviation of expected returns. Stock Y has a 12.0% expected return, a beta coetticient of 1.1, and a 20.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. XE Open spreadsheet a. Calculate each stock's coefficient of variation. Round your answers to two decimal places. Do not round intermediate calculations. CV CVy b. Which stock is riskier for a diversified investor? I.For diversified investors the relevant risk is measured by standard deviation of expected returns. Therefore, the stock with the lower standard deviation of expected returns is more risky. Stock Y has the lower standard deviation so it is more risky than Stock X, II. For diversified investors the relevant risk is measured by beta. Therefore, the stock…
(Expected rate of return and risk) Syntex, Inc. is considering an investment in one of two common stocks. Given the information that follows, which investment is better, based on the risk (as measured by the standard deviation) and return? Common Stock A Probability 0.20 0.60 0.20 Probability 0.15 0.35 0.35 0.15 (Click on the icon in order to copy its contents into a spreadsheet.) Common Stock B Return 13% 14% 18% Return - 6% 7% 15% 21% a. Given the information in the table, the expected rate of return for stock A is 14.6 %. (Round to two decimal places.) The standard deviation of stock A is %. (Round to two decimal places.)