Concept explainers
Spreadsheet Exercise
Jane is considering investing in three different stocks or creating three distinct two-stock portfolios. Jane views herself as a rather conservative investor. She is able to obtain historical returns for the three securities for the years 2012 through 2018. The data are given in the following table.
In any of the possible two-stock portfolios, the we1ght of each stock m the portfolio will be 50%. The three possible portfolio combinations are AB, AC, and BC.
To Do
Create a spreadsheet similar to Tables 8.6 and 8.7 to answer the following:
- a. Calculate the average return for each individual stock.
- b. Calculate the standard deviation for each individual stock.
- c. Calculate the average returns for portfolios AB, AC, and BC.
- d. Calculate the standard deviations for portfolios AB, AC, and BC.
- e. Would you recommend that Jane invest in the single stock A or the portfolio consisting of stocks A and B? Explain your answer from a risk-return viewpoint
- f. Would you recommend that Jane invest in the single stock B or the portfolio consisting of stocks B and C? Explain your answer from a risk-return viewpoint
My Lab Finance Visit www.pearson.com/mylab/finance for Chapter Case: Analyzing Risk and Return on Chargers Products’ Investments, Group Exercises, and numerous online resources.
Want to see the full answer?
Check out a sample textbook solutionChapter 8 Solutions
MyLab Finance with Pearson eText -- Access Card -- for Principles of Managerial Finance
- Question 25 Jasmine bought a house for $225 000. She already knows that for the first $200 000, the land transfer tax will cost $1650. Calculate the total land transfer tax. (2 marks) Land Transfer Tax Table Value of Property Rate On the first $30 000 0% On the next $60 000 0.5% (i.e., $30 001 to $90 000) On the next $60 000 1.0% (i.e., $90 001 to $150 000) On the next $50 000 1.5% (i.e., $150 001 to $200 000) On amounts in excess of $200 000 2.0% 22 5000–200 000. 10 825000 2.5000.00 2 x 25000 =8500 2 maarrow_forwardQuestion 25 Jasmine bought a house for $225 000. She already knows that for the first $200 000, the land transfer tax will cost $1650. Calculate the total land transfer tax. (2 marks) Land Transfer Tax Table Value of Property Rate On the first $30 000 0% On the next $60 000 0.5% (i.e., $30 001 to $90 000) On the next $60 000 1.0% (i.e., $90 001 to $150 000) On the next $50 000 1.5% (i.e., $150 001 to $200 000) On amounts in excess of $200 000 2.0% 225000–200 000 = 825000 25000.002 × 25000 1= 8500 16 50+ 500 2 marksarrow_forwardSuppose you deposit $1,000 today (t = 0) in a bank account that pays an interest rate of 7% per year. If you keep the account for 5 years before you withdraw all the money, how much will you be able to withdraw after 5 years? Calculate using formula. Calculate using year-by-year approach. Find the present value of a security that will pay $2,500 in 4 years. The opportunity cost (interest rate that you could earn from alternative investments) is 5%. Calculate using the formula. Calculate using year-by-year discounting approach. Solve for the unknown in each of the following: Present value Years Interest rate Future value $50,000 12 ? $152,184 $21,400 30 ? $575,000 $16,500 ? 14% $238,830 $21,400 ? 9% $213,000 Suppose you enter into a monthly deposit scheme with Chase, where you have your salary account. The bank will deduct $25 from your salary account every month and the first payment (deduction) will be made…arrow_forward
- PowerPoint presentation of a financial analysis that includes the balance sheet, income statement, and statement of cash flows for Nike and Adidas. Your analysis should also accomplish the following: Include the last three years of data, and evaluate the trends in the data. Summarize the footnotes on each of the statements. Compute the earnings per share for the three years. Compare the two companies and determine the insights gathered from the trend analysis.arrow_forwardIn addition to the customer affairs department of the insurance company the insurance policy must identify which other following on the policy Name of the producer Current director of insurance Policyholder satisfaction rating for paying claims 4. Financial rating from a recognized financial rating servicearrow_forwardIn addition to the customer affairs department of the insurance company the insurance policy must identify which other following on the policy Name of the producer Current director of insurance Policyholder satisfaction rating for paying claims D. Financial rating from a recognized financial rating servicearrow_forward
- Unearned premium refunds for insurance policies cancelled when an insurance company is covered by the Illinois Insurance guaranty fund is subject to a MAXIMUM premium refund of what amount? A.$ 100.00 B.$ 1000.00 C.$10,000.00 D.$ 100,000.00arrow_forwardBefore the department of insurance can issue an order charging an insurance company with improper claims practices, they must first: Review the company's financial statement on file with the department Determine that the practice has been done with such frequency as to indicate a business practice Contact the company's competitors to determine if they know how the company operates Contact the NAIC to determine if the company is on the watch listarrow_forwardthe last three (3) years of the EPS and a summary of the footnotes for Nike and Adidas.arrow_forward
- Pfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning