Math Problem Statement
Data table
(Click on the following icon in order to copy its contents into a spreadsheet.)
Company
Infront AnalyticsInfront Analytics
(Infront.comInfront.com)
Computers and Software
Apple Inc.Apple Inc.
(APPLAPPL)
1.091.09
Dell TechnologiesDell Technologies
(DELLDELL)
1.161.16
MicrosoftMicrosoft
(MSFTMSFT)
1.021.02
Utilities
American Electric Power Co.American Electric Power Co.
(AEPAEP)
0.490.49
Duke Energy Corp.Duke Energy Corp.
(DUKDUK)
0.880.88
Centerpoint EnergyCenterpoint Energy
(CNPCNP)
1.34(Related to Checkpoint 8.3)**** (Analyzing systematic risk and expected rates of return)**** The following table,
LOADING...
,
contains beta coefficient estimates for six firms. Calculate the expected increase in the value of each firm's shares if the market portfolio were to increase by 10 percent. Perform the same calculation where the market drops by 10 percent. Which set of firms has the most variable or volatile stock returns?
(Hint:
Use at least four decimal places in all calculations.)
Question content area bottom
Part 1
Input the expected increase in the value of each firm's shares if the market portfolio were to increase by 10%. (Round each answer to two decimal places.)
Part 2
Part 3
Part 4
Part 5
Part 6
Company
Infront AnalyticsInfront Analytics
(Infront.comInfront.com)
Beta Estimate
Expected Increase
Computers and Software
Apple Inc.Apple Inc.
(APPLAPPL)
1.091.09
10.9010.90%
Dell TechnologiesDell Technologies
(DELLDELL)
1.161.16
11.6011.60%
MicrosoftMicrosoft
(MSFTMSFT)
1.021.02
10.2010.20%
Utilities
American Electric Power Co.American Electric Power Co.
(AEPAEP)
0.490.49
4.904.90%
Duke Energy Corp.Duke Energy Corp.
(DUKDUK)
0.880.88
8.808.80%
Centerpoint EnergyCenterpoint Energy
(CNPCNP)
1.341.34
13.4013.40%
Part 7
Input the expected decrease in the value of each firm's shares if the market portfolio were to decrease by 10%. (Round each answer to two decimal places.)
Company
Infront AnalyticsInfront Analytics
(Infront.comInfront.com)
Beta Estimate
Expected Decrease
Computers and Software
Apple Inc.Apple Inc.
(APPLAPPL)
1.091.09
enter your response here%
Solution
To solve these calculations, let’s understand the method for calculating the expected increase and expected decrease in a firm’s stock price based on its beta coefficient.
Formula
The expected change in value of a firm’s shares due to a change in the market portfolio is calculated as: In this case:
- If the market increases by 10%, we multiply each company’s beta by .
- If the market decreases by 10%, we multiply each company’s beta by .
Part 1: Expected Decrease in Stock Value with a 10% Market Drop
Let’s calculate the expected decrease for each company if the market drops by 10%.
-
Apple Inc. (Beta = 1.09):
-
Dell Technologies (Beta = 1.16):
-
Microsoft (Beta = 1.02):
-
American Electric Power Co. (Beta = 0.49):
-
Duke Energy Corp. (Beta = 0.88):
-
Centerpoint Energy (Beta = 1.34):
Summary Table
Here’s a table of the expected decrease in share value:
Company | Beta Estimate | Expected Decrease (%) |
---|---|---|
Apple Inc. | 1.09 | -10.90 |
Dell Technologies | 1.16 | -11.60 |
Microsoft | 1.02 | -10.20 |
American Electric Power Co. | 0.49 | -4.90 |
Duke Energy Corp. | 0.88 | -8.80 |
Centerpoint Energy | 1.34 | -13.40 |
Part 2: Analyzing Volatility
The beta coefficient is a measure of volatility. Stocks with a higher beta are generally more volatile relative to the market.
In this case, Centerpoint Energy (Beta = 1.34) is the most volatile, while American Electric Power Co. (Beta = 0.49) is the least volatile among these firms.
Questions and Next Steps
- Would you like to see how the increase values relate to different investment risk strategies?
- Do you need an explanation on the concept of beta in more detail?
- Would you like a further breakdown of each industry and why certain sectors tend to have higher or lower beta values?
- Do you want to see calculations for other hypothetical market changes (e.g., a 5% increase)?
- Should we explore other factors besides beta that could influence stock volatility?
Tip
Stocks with a beta higher than 1.0 tend to have more pronounced price changes relative to the market, while those below 1.0 tend to be less responsive.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Finance
Expected Return
Market Volatility
Formulas
Expected Change = Beta * Market Change
Theorems
Capital Asset Pricing Model (CAPM)
Suitable Grade Level
Undergraduate (Finance or Economics)
Related Recommendation
Stock Beta Coefficient Calculation for Market Downturn of 10%
Calculating Stock Return Using CAPM with a Beta of 1.8 and Market Deviation
Calculate Stock Change Based on Beta Coefficients and Market Fluctuations
Calculate Expected Stock Return Using CAPM with Beta 1.3
Calculate Average Beta of New Stocks for a Portfolio with CAPM