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: Expected Change=Beta×Market Change\text{Expected Change} = \text{Beta} \times \text{Market Change} In this case:

  • If the market increases by 10%, we multiply each company’s beta by +10%+10\%.
  • If the market decreases by 10%, we multiply each company’s beta by 10%-10\%.

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%.

  1. Apple Inc. (Beta = 1.09): Expected Decrease=1.09×(10%)=10.90%\text{Expected Decrease} = 1.09 \times (-10\%) = -10.90\%

  2. Dell Technologies (Beta = 1.16): Expected Decrease=1.16×(10%)=11.60%\text{Expected Decrease} = 1.16 \times (-10\%) = -11.60\%

  3. Microsoft (Beta = 1.02): Expected Decrease=1.02×(10%)=10.20%\text{Expected Decrease} = 1.02 \times (-10\%) = -10.20\%

  4. American Electric Power Co. (Beta = 0.49): Expected Decrease=0.49×(10%)=4.90%\text{Expected Decrease} = 0.49 \times (-10\%) = -4.90\%

  5. Duke Energy Corp. (Beta = 0.88): Expected Decrease=0.88×(10%)=8.80%\text{Expected Decrease} = 0.88 \times (-10\%) = -8.80\%

  6. Centerpoint Energy (Beta = 1.34): Expected Decrease=1.34×(10%)=13.40%\text{Expected Decrease} = 1.34 \times (-10\%) = -13.40\%

Summary Table

Here’s a table of the expected decrease in share value:

CompanyBeta EstimateExpected Decrease (%)
Apple Inc.1.09-10.90
Dell Technologies1.16-11.60
Microsoft1.02-10.20
American Electric Power Co.0.49-4.90
Duke Energy Corp.0.88-8.80
Centerpoint Energy1.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

  1. Would you like to see how the increase values relate to different investment risk strategies?
  2. Do you need an explanation on the concept of beta in more detail?
  3. Would you like a further breakdown of each industry and why certain sectors tend to have higher or lower beta values?
  4. Do you want to see calculations for other hypothetical market changes (e.g., a 5% increase)?
  5. 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)