Calculate the standard deviations for the market and stock

Assignment Help Financial Management
Reference no: EM132014647

Prepare the following problems in Excel and ensure the formulas are present in the appropriate cells

The market and Stock J have the following probability distributions:

Probability rM rJ

0.3 15% 22%

0.4 9% 53 %

0.3 18% 11%

a. Calculate the expected rates of return for the market and Stock J.

b. Calculate the standard deviations for the market and Stock J.

Reference no: EM132014647

Questions Cloud

Prepare the first row of loan amortization schedule : Prepare the first row of a loan amortization schedule based on the following information.
What is the conversion price of zippy stock : Zippy Corporation just sold $30 million of convertible bonds with a conversion ratio of 40. What is the conversion price of Zippy’s stock?
Calculate the average rate of return for each stock : Calculate the average rate of return for each stock during the 5-year period.
What is the fund required rate of return : If the market’s required rate of return is 14% and the risk-free rate is 6%, what is the fund’s required rate of return?
Calculate the standard deviations for the market and stock : Calculate the expected rates of return for the market and Stock J. Calculate the standard deviations for the market and Stock J.
What is most you would be willing to pay for investment : What is the most you would be willing to pay for a investment that will pay you $541 in one year, $293, in two years,
What is value of stock given your required rate of return : What is the value of the stock given your required rate of return? Should you buy this stock if its current market price is $34.41?
What is the standard deviation of that selection : What is the expected value of the selection, and what is the standard deviation of that selection?
Find it attractive to convert the bond into zippy stock : what is the probability that investors will find it attractive to convert the bond into Zippy stock in the next year?

Reviews

Write a Review

Financial Management Questions & Answers

  Basic for an offer in compromise

Which of the following is not a basic for an offer in compromise?

  True regarding premium bonds

Which of the following are true regarding premium bonds?

  Two alternatives for purchasing a new printing machine

Two alternatives for purchasing a new printing machine (from provider's A and B) are being considered for a production upgrade of a printing facility.

  Dividends are expected-what is current value of one share

Nu-Tech stock's last annual dividend was $1.10 a share. Dividends are expected to increase by 25 percent for the next two years and then increase at a constant 4 percent annually. The required return on this high-risk stock is 18.5 percent. What is t..

  Intensive care urology practice not-for-profit business

Intensive Care Urology Practice (ICUP), a not-for-profit business, had revenues in 2015 of $144,000. Expenses other than depreciation were 75% of revenues and Depreciation was $15,000. Construct ICUP’s Income Statement. What was ICUP’s Cash Flow for ..

  Compute the project payback period and net present value

Compute the project’s payback period, net present value (NPV), profitability index (PI), internal rate of return (IRR), and modified internal rate of return.

  Child who is receiving services from child protection agency

A child who is receiving services from a child protection agency due to physical abuse is referred to a school social worker due to bullying behavior.

  Large worksheets and complex financial functions

Large worksheets and complex financial functions such as creating amortization tables come with their own set of challenges.

  Compute the t bill discount

T-Bill Discount Newly issued three-month T-bills with a par value of $10,000 sold for $9,700. - Compute the T-bill discount.

  The futures contracts are required to hedge this position

A company has a $26 million portfolio with a beta of 1.2. The futures price for a contract on an index is 1900. The size of one futures index contract is $250 times the index. What position (long or short) in futures contracts should the company take..

  Expected return on two stocks for particular market returns

Consider the following table, which gives a security analyst's expected return on two stocks for two particular market returns: Market Return Aggressive Stock Defensive Stock 6% 2.8% 4.6% 15 28 10. What are the betas of the two stocks?

  Calculate the NPV of the machine

A company is considering buying a new machine for one of its factories. Calculate the NPV of the machine if the discount rate is 12% and the tax rate is 30%.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd