Question: When using expectation theory, given future returns and states of outcomes, we can Use the AVERAGE function to find the expected return of a

When using expectation theory, given future returns and states of outcomes, we

When using expectation theory, given future returns and states of outcomes, we can Use the AVERAGE function to find the expected return of a security. None of these answers are correct. Either use VAR.S or VAR.P to find the variance of a security's returns. Use the VAR.P function to find the variance of the portfolio.

Step by Step Solution

★★★★★

3.46 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The VARP function calculates the variance of a portfolio given the expected returns and ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

We can use the random-number table to simulate outcomes from a given discrete probability distribution. Jose plays basketball and has probability 0.7 of making a free-throw shot. Let x be the random...

We can use the gambling interpretation given in Exercise 28 to find the expected number of tosses required to reach pattern B when we start with pattern A. To be a meaningful problem, we assume that...

We can use the utility-maximizing rule to determine whether consumers are doing the best they can. Suppose a firm has a fixed budget of $200 to spend on punch and cookies for its holiday party. The...

If travel expenses increase to $4,000 per trip, what should the company be willing to pay for each robot and still break even? You can change the average travel expenses, and redo the goal seeking...

Suppose you observe the following situation: Assume these securities are correctly priced. Based on the CAPM, what is the expected return on the market? What is the risk-free rate? Beta Expected...

Cheng and Gonzales operate a trucking company that hauls produce from California to the East Coast. There are three departments: West Coast, Midwest, and East Coast. A number of support services for...

They are financial weapons of mass destruction, Warren Buffett wrote in his popular annual Berkshire Hathaway Letter from the Chairman, in 2003. Mr. Buffett was referring to financial derivatives....

On average, how often did you watch educational television (for example, Sesame Street) or use educational media (e.g., computer games, apps) when you were a child? (circle one) Not at All | Very...

In this exercise, you are asked to explore some classic issues from the empirical literature on stock market returns. The data for this question can be found in an Excel spreadsheet on the textbook...

In Example 16.3, we illustrate the calculation of the likelihood function for the probit model in a small example. In this exercise, we will repeat that example using logit instead of probit. The...

Sketch a graph of equation or pair of equations in Problem in a rectangular coordinate system. 5x - 6y = 15

Turn on your desk lamp. Pick up the cord, with your thumb and index finger spanning the width of the cord. (a) Compute an order-of-magnitude estimate for the current in your hand. You may assume that...

Employee discipline is NOT a mandatory subject of bargaining. Group of answer choices True False

In your own words, explain how Aquinas' version of natural law theory could be used to deem the Third Reich laws invalid.

Farrah owns 5,000 shares of stock in DAS, Inc. with a market value of $15,000.DAS declares a 20% stock dividend. After the dividend is paid, Farrah owns A. 5,000 shares with a market value of...

1) Each of the following situations involves a possible violation of the rule on independence. For each situation, (1) decide whether the Code of Professional Conduct has been violated, and (2)...

Energy and Specific Heat Are you completing this experiment online? Yes Specific Heat of an Unknown Metal Identification number of unknown metal 4 Mass of unknown metal (g) 18.07 Mass of calorimeter...

The following is the ending balances of accounts at December 31, 2021, for the Welsmuller Publishing Company. prepare a classified balance sheet for the Weismuller Publishing Company at December 31,...

paraphrase The aim is to explain how I will utilize key leadership abilities in areas such as inter-professional collaboration, communication, ethical relationships, and project management to improve...

1 point When using expectation theory, given future returns and states of outcomes, we can Use the AVERAGE function to find the expected return of a security. None of these answers are correct....

Hi, I have an Assignment for my Finance Subject. I have attached the necessary documentation here for you to view including the Lecture slides of all the Topics covered for this assignment. Please...

I am looking for the correct answer for this Q .. Can you help me :) I need also steps with Calculatorplz Thanks....

I need assistance with all problems attached except 4.1 Can you assist? Case Problem 4.1 Coates's Decision On January 1, 2017, Dave Coates, a 23-year-old mathematics teacher at Xavier High School,...

Hi! You did a real good job helping me and I need you once again for FIN 402 Case Problem 4.1 Coates's Decision On January 1, 2017, Dave Coates, a 23-year-old mathematics teacher at Xavier High...