Create a user-defined function to calculate the beta coefficient using the equation (14-22) that was introduced on page 455:
Use the following data to test your functions:
a) Write the function to accept two arguments: the range of returns of the risky asset and the range of returns on the market portfolio. Call this function BetaA. Do not use Application.WorksheetFunction.
b) Rewrite your function so that it makes use of Application.WorksheetFunction to calculate the covariance and the variance of the market returns. Call this function BetaB.
You might also like to view...
Starbucks entered India via an alliance with the Tata Group. They are sourcing coffee beans in India and marketing them at Starbucks stores throughout the world. This is an example of:
A) Market Penetration. B) Market Development. C) Market Diversification. D) Product Development. E) Regular Marketing.
Declaration of a stock dividend results in a liability being recorded.
Answer the following statement true (T) or false (F)
Which of the following would likely be viewed as McDonald’s core competency?
a. Customizable food made available for home delivery b. Prepackaged food made available through convenience stores c. Fast, standardized, and inexpensive food d. Fast, highly customizable, and moderately priced food
If the liquidity effect is smaller than the other effects, and the adjustment of expected inflation is slow, then the
A) interest rate will fall. B) interest rate will rise. C) interest rate will initially fall but eventually climb above the initial level in response to an increase in money growth. D) interest rate will initially rise but eventually fall below the initial level in response to an increase in money growth.