EXCEL FORMULA:
Problem 10 Intro You've collected the following information for three stocks: Shares Price Stock (million) 2018...
You've collected the following information for three stocks: Shares Price Stock (million) 2017 2018 A 85 132 115 B 134 93 98 C 300 46 56 a. What is the relative change in a price-weighted index? Enter your answer as a decimal number or with the percentage sign. b. What is the relative change in a market value-weighted index? Enter your answer as a decimal number or with the percentage sign.
Problem 3 Intro You've estimated the following expected returns for a stock, depending on the strength of the economy: State (s) Probability Expected return Recession 0.3 -0,05 Normal Expansion 0.5 0.06 0.2 0.11 Attempt 1/10 for 10 pts. Part 1 What is the expected return for the stock? 4+ decimals Submit Attempt 1/10 for 10 pts. Part 2 What is the standard deviation of returns for the stock? 4+ decimals Submit
Problem 9 Intro You've analyzed IBM's stock and your personal expectation is that it will deliver a return of 10% over the next year. The stock has a beta of 0.4. The risk-free rate is 2.5% and the expected market risk premium is 4.5%. | Attempt 1/5 for 10 pts. Part 1 What is the security's expected alpha? Enter your answer as a decimal. 3+ decimals Submit
Problem 17 Intro You've assembled the following portfolio: Stock Beta Portfolio weight The expected market return is 5% and the risk-free rate is 2%. Assume that the CAPM holds. Part 1 Attempt 1/5 for 10 pts. What is the beta of the portfolio? 2+ decimals Submit VB Attempt 1/5 for 10 pts. Part 2 What is the expected return of your portfolio? 3. decimals Submit
Problem 17 Intro You've assembled the following portfolio: Stock Beta Portfolio weight 1 1.6 0.2 2 1.1 3 0.7 0.5 The expected market return is 9% and the risk-free rate is 2%. Assume that the CAPM holds. i | Attempt 1/5 for 10 pts. Part 1 What is the beta of the portfolio? No decimals Submit Part 2 IB Attempt 175 for 10 pts. What is the expected return of your portfolio? 3+ decimals Submit Intro We know the following...
Intro You've estimated the following expected retums for a stock, depending on the strength of the economy Probability Expected return 02 -0.02 State (s) Recession Normal Expansion 0.5 0,09 0.3 0.14 Attempt 1/1 for 10 pts. Part 1 What is the expected return for the stock? 3+ decimals Submit Part 2 Attempt 1/1 for 10 pts What is the standard deviation of returns for the stock? Type here to search O
Intro You've collected the following information about a company Value Line item Sales Costs Depreciation Interest The company's average tax rate is 13%. B Attempt 2/10 for 8 pts. Part 1 What is EBIT? Correct v EBIT = Sales - Costs - Depreciation = 160 - 30 - 10 = 120 Part 2 IS- Attempt 4/10 for 6 pts. What is net income? tecime Submit Intro You've collected the folowing information about a company Value 660 Line item Sales Costs...
Problem 12 Intro You've assembled the following portfolio: Stock Expected return Portfolio weight 6.5% 30% 11.9% 18.3% Part 1 1 Attempt 2/5 for 10 pts. What is the weight for stock 3 if you want to achieve an expected portfolio return of 11%? 3+ decimals Submit
help please
Problem 3 Intro You've collected some information about a Treasury bill: Maturity Days to maturity Bid Ask Face value 3/10 136 1.85 1.79 $10,000 Part 1 | Attempt 2/5 for 10 pts. How much do you have to pay to buy this T-bill (in $)? 0+ decimals
Problem 2 Intro We know the following expected returns for stocks A and B.glven different states of the economy: 0.04 State (s) Probability E(ra) Ers,s) Recession 0.2 -0.1 Normal 0.5 0.08 0.05 Expansion 0.3 0.18 0.07 - Attempt 1/5 for 10 pts. Part 1 What is the expected return for stock A? 3+ decimals Submit Attempt 175 for 10 pts. Part 2 What is the expected return for stock B? Submit Problem 9 Intro You have $100,000 to invest and...