Question: PLEASE type excel formual for the answer. You've observed the following returns on Pine Computer's stock over the past five years: 8 percent, -12 percent,

PLEASE type excel formual for the answer.

You've observed the following returns on Pine Computer's stock over the past five years: 8 percent, -12 percent, 14 percent, 21 percent, and 16 percent. What was the arithmetic average return on the company's stock over this five-year period? What was the variance?f 2. the company's returns over this period? The standard deviation? Input area: (Use cells A6 to B11 from the given information to complete this question. You must use the built-in Excel function to answers this question. Make sure to use the "sample" Excel formulas.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

Sorry to bother you! When calculating the variance in the second question of this question, why is the denominator n-1? Is there a more intuitive way to understand this? Chapter 12 on 9. Calculating...

PLEASE TYPE ANSWER IN THE EXCEL FORMULA. You've observed the following returns on Pine Computer's stock over the past five years: 8 percent, -12 percent, 14 percent, 21 percent, and 16 percent. What...

You ve observed the following returns on Pine Computer's stock over the past five years: 8 percent, 12 percent, 14 percent, 21 percent, and 16 percent. Suppose the average inflation rate over this...

1. Parker & Stone, Incorporated, is looking at setting up a new manufacturing plant in South Park to produce garden tools. The company bought some land six years ago for $8.3 million in anticipation...

Calculate the expected returns of your portfolio Stock Invest Exp Ret A $358 8.1% B $954 18.1% C $1,383 26% Note: Enter your answer in percentages rounded off to two decimal points. Do not enter % in...

1 Suppose a stock had an initial price of $97.22 per share, paid a dividend of $8.4 per share during the year, and had an ending share price of $86.42. What are the percentage returns? Note: Enter...

I need help with the attached homework assignment.. Question 1 Suppose a stock had an initial price of $96.2 per share, paid a dividend of $6 per share during the year, and had an ending share price...

You ve observed the following returns on Pine Computer's stock over the past five years: 13 percent, -13 percent, 20 percent, 25 percent, and 10 percent. Suppose the average Inflation rate over this...

Please explain each step very detail. Thank you. You've observed the following returns on Pine Computer's stock over the past five years: 10 percent, 11 percent, 18 percent, 19 percent, and 10...

12-10 Calculating Real Returns and Risk Premiums [LO1] Youve observed the following returns on Pine Computers stock over the past five years: 14 percent, 14 percent, 16 percent, 26 percent, and 10...

Determine the lengths of cords ACB and CO. The knot at C is located midway between A and B. Given: a = 3 ft b = 6 ft c = 4 ft a

Your company has an existing loan with monthly payments, principal, and interest of $1,883.65. There are 48 payments left on the loan and the loan has an unpaid balance of $74,269.00. Your company is...

Classify this news event as Systematic or Unsystematic and indicate whether prices will increase or decrease. Home Depot's sales soared in the first quarter, despite an increase in costs due to the...

Consider the balance sheet above, what is the value for net fixed assets