Calculation of average return and standard deviation of
market:
Calculation of Covariance and Beta:Formula sheet
4. You have observed the following returns for Market, Apple, and Microsoft for last 3 vearS:...
Suppose you have collected the following historical returns for 2 stocks (Stock A and Stock B). Your task is to summarize the data using the following statistical measures: expected return, variance, standard deviation, covariance, and correlation. Stock A Stock B 2010 0.10 0.07 2009 -0.02 0.01 2008 0.08 -0.03 Estimate the expected return for each stock. In a short description, what do these numbers represent? (For the quiz, provide the expected return for Stock A.) Estimate the return variance and...
1. We have the following discrete distribution for an asset i's return for the next period: Probability Market Rate Scenario Best Case Most Likely Worst Case of Scena rio of Return 0.2 0.6 0.2 0.20 0.05 0.10 a) Find the expected return, variance, and standard deviation for the asset. Write out all the setups for each calculation b) Based on your calculation, draw figure 2-4 on page 44 and interpret what calculated ± 16, ± 26, and ± 3σ deviations...
The following are monthly percentage price changes for four market indexes. Month DJIA S&P 500 Russell 2000 Nikkei 1 0.04 0.01 0.04 0.04 2 0.07 0.06 0.10 -0.03 3 -0.02 -0.02 -0.03 0.08 4 0.02 0.02 0.02 0.01 5 0.05 0.05 0.11 0.01 6 -0.07 -0.04 -0.09 0.05 Compute the following. Average monthly rate of return for each index. Round your answers to five decimal places. DJIA: S&P 500: Russell 2000: Nikkei: Standard deviation for each index. Do not round...
Q13: You have a loan principal of $100,000. The annual interest rate is 3% and the loan term is 30 years. Using the PMT() formula, calculate the amount of each annual payment. $30,005.21 $5,036.20 $30,011.45 $5,101.93 Q14: Which of the statements about normal distribution is incorrect? The skewness must be 0 and kurtosis must be 3 for a normal distribution The mean, median, and mode are all the same in a normal distribution We can simply use mean and variance...
The purpose of this analysis is to find an intrinsic value for Microsoft (MSFT) using the both the Constant Dividend Discount Model (DDM) and the Non-constant DDM. You will need to (1) estimate Beta in order to calculate the required return for MSFT; (2) estimate dividend growth rate; and (3) estimate future dividends. Submit your Excel spreadsheet with all data and formulas so that your answers can be replicated. You may answer the questions on the spreadsheet. HOWEVER, WRAP YOUR...
Refer to Table 1. Write the Excel formula for each cell marked with “?” in columns B, C and D such that formula could be copied and pasted into columns D, E, F and G using Microsoft Excel without further editing. There is no need to explicitly write the Excel formula for cells marked with “Copy & paste”. Label each formula clearly with cell reference position. In 2020, BS Bank employs 800 employees in its call centres in the United States...