ESSENTIALS OF INVESTMENTS>LL<+CONNECT
11th Edition
ISBN: 9781264001026
Author: Bodie
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 7, Problem 2WM
Summary Introduction
In this problem we have to get the data from yahoo finance for Alcoa and S&P 500 for 60 months and calculate their returns by using this formula:
Returns = ln(Return in current year/return in previous year)
Here ln stands for natural logarithm.
Expert Solution & Answer
Explanation of Solution
The data is shown below:
| Date | Returns Alcoa | Returns S&P |
| 12/1/2013 | 0 | 0 |
| 1/1/2014 | 0 | 0 |
| 2/1/2014 | 0.019785587 | 0.042213375 |
| 3/1/2014 | 0.094520691 | 0.006908249 |
| 4/1/2014 | 0.045565745 | 0.006181643 |
| 5/1/2014 | 0.010340052 | 0.020812196 |
| 6/1/2014 | 0.09213958 | 0.018878997 |
| 7/1/2014 | 0.09598186 | -0.015194687 |
| 8/1/2014 | 0.013333413 | 0.036963644 |
| 9/1/2014 | -0.029980428 | -0.015635436 |
| 10/1/2014 | 0.040797065 | 0.022936399 |
| 11/1/2014 | 0.031133233 | 0.024237474 |
| 12/1/2014 | -0.088938172 | -0.004197385 |
| 1/1/2015 | -0.008906032 | -0.031532779 |
| 2/1/2015 | -0.056519624 | 0.053438876 |
| 3/1/2015 | -0.133367024 | -0.017549197 |
| 4/1/2015 | 0.037969704 | 0.008484722 |
| 5/1/2015 | -0.071017427 | 0.01043673 |
| 6/1/2015 | -0.112097041 | -0.021235559 |
| 7/1/2015 | -0.121939527 | 0.019549683 |
| 8/1/2015 | -0.043485446 | -0.064624731 |
| 9/1/2015 | 0.025067099 | -0.026798731 |
| 10/1/2015 | -0.078577301 | 0.079719379 |
| 11/1/2015 | 0.047029033 | 0.000504742 |
| 12/1/2015 | 0.056257819 | -0.017685659 |
| 1/1/2016 | -0.302996218 | -0.052067617 |
| 2/1/2016 | 0.202912827 | -0.004136906 |
| 3/1/2016 | 0.074574737 | 0.06390499 |
| 4/1/2016 | 0.153553957 | 0.002695762 |
| 5/1/2016 | -0.18644828 | 0.015208367 |
| 6/1/2016 | 0.002902807 | 0.000910506 |
| 7/1/2016 | 0.135955619 | 0.034990433 |
| 8/1/2016 | -0.052185714 | -0.001219987 |
| 9/1/2016 | 0.008845955 | -0.001235213 |
| 10/1/2016 | -0.12794767 | -0.019616837 |
| 11/1/2016 | 0.301002453 | 0.033603545 |
| 12/1/2016 | -0.027282474 | 0.018037111 |
| 1/1/2017 | 0.260883907 | 0.017726315 |
| 2/1/2017 | -0.052376863 | 0.036523001 |
| 3/1/2017 | -0.005508 | -0.000389273 |
| 4/1/2017 | -0.019668973 | 0.009050132 |
| 5/1/2017 | -0.023699955 | 0.011509759 |
| 6/1/2017 | -0.008842777 | 0.004802226 |
| 7/1/2017 | 0.108723913 | 0.019164018 |
| 8/1/2017 | 0.186889829 | 0.000546284 |
| 9/1/2017 | 0.060570954 | 0.019119039 |
| 10/1/2017 | 0.024577509 | 0.02194556 |
| 11/1/2017 | -0.121820059 | 0.003713141 |
| 12/1/2017 | 0.241786656 | 0.033766015 |
| 1/1/2018 | -0.034945458 | 0.054657399 |
| 2/1/2018 | -0.145632637 | -0.039726108 |
| 3/1/2018 | -0.00022244 | -0.027252497 |
| 4/1/2018 | 0.129966368 | 0.002715086 |
| 5/1/2018 | -0.06308127 | 0.021378191 |
| 6/1/2018 | -0.025067115 | 0.004830749 |
| 7/1/2018 | -0.080131612 | 0.035387951 |
| 8/1/2018 | 0.031842536 | 0.029814315 |
| 9/1/2018 | -0.100472256 | 0.004285093 |
| 10/1/2018 | -0.143767471 | -0.071929346 |
| 11/1/2018 | -0.095281689 | 0.017701752 |
| 12/1/2018 | -0.098711084 | -0.047137951 |
For First half of the data that is for 30 months, we run the regression between Alcoa and S&P to get this as an output.
Regression equation for the first 30 months is
Y = 0.6203X − 0.0098
From this equation the
Beta = slope of regression line = 0.6203
Alpha = intercept of regression line = 0.0098
For next half of the data that is for 30 months, we run the regression between Alcoa and S&P to get this as an output.
Regression equation for the first 30 months is
Y = 1.9944X − 0.0058
From this equation the
Beta = slope of regression line = 0.1.9944
Alpha = intercept of regression line = 0.0058
Conclusion
From this we can interpret that the for the first 30 months beta is quite lower as compared to the next 30 months. Also Alpha increased from negative 0.0098 to negative 0.0058 for the last 30 months meaning that the stock became more volatile and riskier and was giving more returns.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Mikkleson Mining stock is selling for $40 per share and has an expected dividend in the coming year of $2.00 and has an expected constant growth rate of 5%. The company is considering issuing a 10-year convertible bond that would be priced at $1,000 par value. The bonds would have an 8% annual coupon, and each bond could be converted into 20 shares of common stock. The required rate of return on an otherwise similar nonconvertible bond is 10.00%. What is the estimated floor price of the convertible at the end of Year 3?
a. $926.10
b. $794.01
c. $835.81
d. $879.80
$972.41
Ms. Lloyd, who is 25 and expects to retire at age 60, has just been hired by the Chambers Corporation. Ms. Lloyd's current salary is $30,000 per year, but her wages are expected to increase by 5 percent annually over the next 35 years. The firm has a defined benefit pension plan in which workers receive 2 percent of their final year's wages for each year of employment. Assume a world of certainty. Further, assume that all payments occur at year-end. What is Ms. Lloyd's expected annual retirement benefit, rounded to the nearest thousands of dollars?
a. $116,000
b. $35,000
c. $89,000
d. $57,000
e. $132,000
When a company's interest payment Blank______, the company's tax bill Blank______.
Multiple choice question.
increases; increases
stays the same; increases
increases; decreases
decreases; decreases
Chapter 7 Solutions
ESSENTIALS OF INVESTMENTS>LL<+CONNECT
Ch. 7 - Prob. 1PSCh. 7 - Consider the statement: “If we can identify a...Ch. 7 - Are the following true or false? Explain. (LO 7-5)...Ch. 7 - Here are data on two companies. The T-bill rate is...Ch. 7 - Characterize each company in the previous problem...Ch. 7 - What is the expected rate of return for a stock...Ch. 7 - Kaskin, Inc., stock has a beta of 1.2 and Quinn,...Ch. 7 - What must be the beta of a portfolio with E(rf)) =...Ch. 7 - The market price of a security is $40. Its...Ch. 7 - You arc a consultant to a large manufacturing...
Ch. 7 - Consider the following table, which gives a...Ch. 7 - Prob. 13PSCh. 7 - Prob. 14PSCh. 7 - If the simple CAPM is valid, which of the...Ch. 7 - Prob. 16PSCh. 7 - If the simple CAPM is valid, which of the...Ch. 7 - Prob. 18PSCh. 7 - Prob. 19PSCh. 7 - Prob. 20PSCh. 7 - In problem 2123 below, assume the risk-free rate...Ch. 7 - Prob. 22PSCh. 7 - In problem 2123 below, assume the risk-free rate...Ch. 7 - Two investment advisers are comparing performance....Ch. 7 - Suppose the yield on short-term government...Ch. 7 - Based on current dividend yields and expected...Ch. 7 - Consider the following data for a single index...Ch. 7 - Assume both portfolios A and B are well...Ch. 7 - Prob. 29PSCh. 7 - Prob. 30PSCh. 7 - Et
Ch. 7 - Suppose two factors are identified for the U.S....Ch. 7 - Suppose there are two independent economic...Ch. 7 - As a finance intern at Pork Products, Jennifer...Ch. 7 - Suppose the market can be described by the...Ch. 7 - Which of the following statements about the...Ch. 7 - Kay, a portfolio n1anacr at Collins Asset...Ch. 7 - Prob. 3CPCh. 7 - Jeffrey Bruner, CFA, uses the capital asset...Ch. 7 - Prob. 5CPCh. 7 - According to CAPM, the expected rate of a return...Ch. 7 - Prob. 7CPCh. 7 - Prob. 8CPCh. 7 - 9. Briefly explain whether investors should expect...Ch. 7 - Assume that both X and Y are well-diversified port...Ch. 7 - Prob. 11CPCh. 7 - 12. A zero-investment, well-diversified portfolio...Ch. 7 - 13. An investor takes as large a position as...Ch. 7 - In contrast to the capital asset pricing model,...Ch. 7 - Prob. 1WMCh. 7 - Prob. 2WMCh. 7 - Prob. 3WMCh. 7 - a. Which of the stocks would you classify as...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Analyze the attached general ledger and balance sheet to see if the current assets and general ledger are accurate. Why or why not? Analyze the attached ledger and balance sheet and determine if the long-term assets and ledger are accurate. Why or why not?arrow_forwardWhat are the appropriate depreciation methods for the company, and how can we determine this based on the attached general ledger? Based on these records, what strategy would be recommended to increase profitability and maintain strong liquidity?arrow_forwardDon't used Ai solutionarrow_forward
- Don't used Ai solutionarrow_forwardllumina Inc. is expected to pay its next dividend of $0.4 two years from now. This dividend should then grow at a rate of 10% for 3 years (till the end of year 5), and at a reduced rate of 6% thereafter. The market required rate of return is 16%. The price of the company's shares today is: $4.15 $4.39 $3.79 $3.96arrow_forwardA bank has made a loan charging a base lending rate of 8%. It expects a probability of default of 5%. If the loan is defaulted, it expects to recover 50% of its money through the sale of its collateral. The expected return on this loan is _____% (rounded to two decimal places).arrow_forward
- Ch 26: Assignment - Mergers and Corporate Control Widget Corp., which is considering the acquisition of Exteter Enterprise Inc., estimates that acquiring Exteter will result in an incremental value for the firm. The analysts involved in the deal have collected the following information from the projected financial statements of the target company: Data Collected (in millions of dollars) Year 1 Year 2 Year 3 EBIT $13.0 $15.6 $19.5 Interest expense 5.0 5.5 6.0 Debt 35.2 41.6 44.8 Total net operating capital 107.1 109.2 111.3 Exteter Enterprise Inc. is a publicly traded company, and its market-determined pre-merger beta is 1.00. You also have the following information about the company and the projected statements: •Exteter currently has a $38.00 million market value of equity and $24.70 million in debt. The risk-free rate is 3.5%, there is a 5.60% market risk premium, and the Capital Asset Pricing Model produces a pre-merger required rate of return on equity ISL of 9.10%. •Exteter's cost…arrow_forward3. Problem 30-03 (Plan Funding) Plan Funding eBook Consolidated Industries is planning to operate for 10 more years and then cease operations. At that time (in 10 years), it expects to have the following pension benefit obligations: Year 11-15 16-20 21-25 Annual Total Payment $3,480,000 2,980,000 26-30 31-35 2,480,000 1,980,000 1,480,000 The current value of the firm's pension fund is $5.6 million. Assume that all cash flows occur at year-end. a. Consolidated's expected return on pension assets is 11%, and it uses 11% to discount the expected pension benefit payments. What is the present value of the firm's pension fund benefits? Do not round intermediate calculations. Round your answer to the nearest dollar. $ b. Is the plan underfunded or overfunded? Do not round intermediate calculations. Round your answer to two decimal places. Funding ratio= which means the assets are select than the PV of benefits and the plan is select Less or greater Select underfunded overfundedarrow_forwardPlan Funding Consolidated Industries is planning to operate for 10 more years and then cease operations. At that time (in 10 years), it expects to have the following pension benefit obligations: Year 11-15 16-20 21-25 Annual Total Payment $3,500,000 3,000,000 2,500,000 26-30 31-35 2,000,000 1,500,000 The current value of the firm's pension fund is $6.1 million. Assume that all cash flows occur at year-end. a. Consolidated's expected return on pension assets is 12%, and it uses 12% to discount the expected pension benefit payments. What is the present value of the firm's pension fund benefits? Do not round intermediate calculations. Round your answer to the nearest dollar. $ b. Is the plan underfunded or overfunded? Do not round intermediate calculations. Round your answer to two decimal places. Funding ratio = which means the assets are -Select- than the PV of benefits and the plan is -Select- ☑. Less or Greater Overfunded or Underfundedarrow_forward
- Benefits and Contributions The Certainty Company (CC) operates in a world of certainty. It has just hired Mr. Jones, age 27, who will retire at age 65, draw retirement benefits for 14 years, and die at age 79. Mr. Jones' salary is $21,000 per year, but wages are expected to increase at the 6% annual rate of inflation. CC has a defined benefit plan in which workers receive 1% of the final year's wage for each year employed. The retirement benefit, once started, does not have a cost-of-living adjustment. CC earns 12% annually on its pension fund assets and uses a 10% rate to discount its expected future benefit payments. Assume that pension contribution and benefit cash flows occur at year-end. Do not round intermediate calculations. Round your answers to the nearest dollar. a. How much will Mr. Jones receive in annual retirement benefits? $ b. What is CC's required annual contribution to fully fund Mr. Jones' retirement benefits? $ c. Assume now that CC hires Mr. Smith at the same…arrow_forwardlab.infoseclearning.com/console/5061763/3047 310-win10 Project Three Milestone - GNS3 File Edit View Control Node Annotate Tools Help e 41 Sales_PC1 0000 Sales_PC2 Sales_PC3 Enforce US Keyboard Layout View Fullscreen Send Ctrl+Alt+Delete Reboot To exit full screen, press and hold esc ■C00/6@ Q Sales_Switch Human Resources_Switch Office_Router Sales PC4 Customer_Service_Switch X: -299.0 Y: -136.0 Z: 1.0 H Type here to search CS_FTP_Server HR_PC2 HR_PC1 7:19 PM 12/14/2024 Barrow_forwardAGG is a US multinational that manufactures specialist high tech parts in the airline engine industry. AGG is an established company with steady growth in turnover and dividends over the last 10 years. The company is undertaking a projected titled Project Big as a strategic response to the changing market scene. AGG will develop a new state of the art highly automated plant located in Cambodia which is expected to result in cost advantages if it is implemented. The details about the project are below • Initital investment has been estimated at $500m • • The annual pre tax savings in operating costs at current exchange rates has been calculated at $150m for the first four years (starting in the first year) The residual value of the project at the end of the four years is estimated to be $250m The initial investment, net of residual value, qualifies for capital allowance and can be claimed back on a straight line basis over the four years of the project. Current AGG's cost of capital is…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Portfolio return, variance, standard deviation; Author: MyFinanceTeacher;https://www.youtube.com/watch?v=RWT0kx36vZE;License: Standard YouTube License, CC-BY