1. Apple’s Worldwide Revenues from 2004 to 2019 is as follows:

1. Enter the data above into the tab labeled Apple. Graph the data in Excel and use your graph to determine what kind of time series pattern exist. Put your answer in your spreadsheet.
2. Make the following forecasts for 2020. For all of them, use Mean Squared Error to determine which of the forecasts is the best. Make sure your answers are clearly labeled.
   1. Naïve forecast from one prior time period
   2. Calculate a 4-period moving average
   3. Calculate a 3-period moving average with the following weights for time t: time period t-1=0.8, t-2 = 0.15, t-3=.05
3. In the tab called Apple Smoothing, use the data from 3. to forecast 2020 using an alpha equal to 0.7, 0.8, and 0.9. Using MSE, which one offers the best estimate for 2020?
4. In the tab called Apple Regression, use the information from 3. and run a regression to determine your forecast for 2020
   1. Put your regression output in F1 of the same workbook.
   2. Calculate what your forecast is for 2020 in F21.
   3. How does well does this regression equation predict revenue? Write your answer in F22. In addition, explain what your numerical answer means in words.

PLEASE PROVIDE STEP BY STEP AND FORMULAS FOR EXCEL, THANK YOU

4. Jellystone National Park is located 10 minutes away from city A and 20 minutes away from city B. Cities A and B have 200; 000 inhabitants each, and residents in both cities have the same income and preferences for national parks. Assume that the cost for an individual to go to a national park is represented by the cost of the time it takes her to get into the park. Also assume that the cost of time for individuals in cities A and B is $:50 per minute. You observe that each inhabitant of city A goes to Jellystone 10 times a year, while each inhabitant of city B goes only 5 times a year. Assume the following: the only people who go to the park are the residents of cities A and B; the cost of running Jellystone is $1; 500; 000 a year; and the social discount rate is 10%. Also assume that the park lasts forever.

(a) Compute the cost per visit to Jellystone for an inhabitant of each city.

(b) Assuming that those two observations (cost per visit and number of visits per inhabitant of city A, and cost per visit and number of visits per inhabitant of city B) correspond to two points on the same linear individual demand curve for visits to Jellystone, derive that individual demand curve (the cost for the price, and the number of visits for the quantity).

(c) With the individual demand curve from (b), calculate the consumer surplus for an inhabitant in city A and in city B, respectively. (Note that inhabitants in the two cities may not pay the same price.) What is the total consumer surplus of the two cities entire population combined?

(d) The total consumer surplus measures the total bene t of the park to the inhabitants in the two cities. There is a timber developer who wants to buy Jellystone to run his business. He is offering $100 million for the park. Should the park be sold? Show the process you obtain your conclusion.

Playland at Pacific National Exhibition is an amusement park offering 31 different rides (including 4 rollercoasters and 1 water ride). The guests who are 48” or taller can go on any ride they want and so they get more value from visiting the park; let us say their individual demand is given by P = 5 – 0.25qO, where P is the price per ride ($ per ride) and qO is the number of the rides (per day) (the subscript O stands for “One Day;” that’s how the park calls its passes for the guests who are 48” or taller). The guests who are under 48” are not allowed on certain rides so they get less value from visiting the park; let us say their individual demand is given by P = 4 – 0.25qJ, where P is the price per ride ($ per ride) and qJ is the number of the rides (per day) (the subscript J stands for “Jr. One Day;” that’s how the park calls its passes for the guests under 48”). Assume it costs the park flat ¢25 per guest to operate a single ride, and it costs the park flat ¢75 to issue a single ticket to a ride. Assume there are 500 guests 48” or taller and 500 guests under 48” on an average day. We can consider Playland a monopolist in Vancouver

If Playland employed a two-part tariff scheme (the park may choose to ticket each ride, or they may choose to let people go on as many rides [at zero price per ride] as they want and only charge the gate fee for the access to the rides),

6. what would be the gate entry fee for guests 48” or taller ($ per guest)?

7. what would be the gate entry fee for guests under 48” ($ per guest)?

8. what would be the price per ride ($ per ride)?

9. what is Playland’s profit on an average day ($ per day)? Assume zero fixed cost.

Stocks A and B have the following probability distributions of expected future returns: Probability A B 0.1 (15%) (28%) 0.2 6 0 0.3 16 22 0.3 24 28 0.1 38 47 Calculate the expected rate of return, rB, for Stock B (rA = 15.50%.) Do not round intermediate calculations. Round your answer to two decimal places. % Calculate the standard deviation of expected returns, σA, for Stock A (σB = 19.85%.) Do not round intermediate calculations. Round your answer to two decimal places. % Now calculate the coefficient of variation for Stock B. Round your answer to two decimal places. Is it possible that most investors might regard Stock B as being less risky than Stock A? If Stock B is less highly correlated with the market than A, then it might have a higher beta than Stock A, and hence be more risky in a portfolio sense. If Stock B is more highly correlated with the market than A, then it might have a higher beta than Stock A, and hence be less risky in a portfolio sense. If Stock B is more highly correlated with the market than A, then it might have a lower beta than Stock A, and hence be less risky in a portfolio sense. If Stock B is more highly correlated with the market than A, then it might have the same beta as Stock A, and hence be just as risky in a portfolio sense. If Stock B is less highly correlated with the market than A, then it might have a lower beta than Stock A, and hence be less risky in a portfolio sense.

You are trying to study for a physics exam, but your kids keep distracting you. You design a game where you can both play with your kids and study physics. You take two of your children’s blocks and place them on a table. Block 2 (mass = 0.3 kg) is at the edge of the table. Block 1 (mass = 0.2 kg) is held against a spring (spring constant = 500 N/m) that is compressed a distance of 0.08 m. After you let block 1 go from rest, it slides a distance of 0.6 m from the release point and then experiences a head-on collision with block 2. After the collision, block 1 stops and block 2 moves horizontally off the table. The goal of the game is to have block 2 land in a basket on the floor. The coefficient of kinetic friction between block 1 and the table is 0.3. 

A) Where should you place the basket on the floor? 

B)What is the speed of block 2 when it lands in the basket?

C)Determine the speed of block 2 when it hits the basket using kinematics

   - What is the y component of block 2's velocity when it hits the ground?

- What is the speed of block 2 when it hits the ground?

- Does your answer to this follow up agree with you original answer?

D) Suppose you increase the initial compression distance of the spring to some value greater than 0.08 m and then released block 1. Would block 2 spend more time in the air, less time, or the same amount of time?

Stocks A and B have the following probability distributions of expected future returns:

1. Calculate the expected rate of return, r_B, for Stock B (r_A = 12.60%.) Do not round intermediate calculations. Round your answer to two decimal places.
   %

2. Calculate the standard deviation of expected returns, σ_A, for Stock A (σ_B = 18.36%.) Do not round intermediate calculations. Round your answer to two decimal places.
   %

3. Now calculate the coefficient of variation for Stock B. Round your answer to two decimal places.

4. Is it possible that most investors might regard Stock B as being less risky than Stock A?

   1. If Stock B is more highly correlated with the market than A, then it might have a lower beta than Stock A, and hence be less risky in a portfolio sense.
   2. If Stock B is more highly correlated with the market than A, then it might have the same beta as Stock A, and hence be just as risky in a portfolio sense.
   3. If Stock B is less highly correlated with the market than A, then it might have a lower beta than Stock A, and hence be less risky in a portfolio sense.
   4. If Stock B is less highly correlated with the market than A, then it might have a higher beta than Stock A, and hence be more risky in a portfolio sense.
   5. If Stock B is more highly correlated with the market than A, then it might have a higher beta than Stock A, and hence be less risky in a portfolio sense.

EXPECTED RETURNS

Stocks A and B have the following probability distributions of expected future returns:

1. Calculate the expected rate of return, r_B, for Stock B (r_A = 11.80%.) Do not round intermediate calculations. Round your answer to two decimal places.
   %

2. Calculate the standard deviation of expected returns, σ_A, for Stock A (σ_B = 21.10%.) Do not round intermediate calculations. Round your answer to two decimal places.
   %

3. Now calculate the coefficient of variation for Stock B. Round your answer to two decimal places.

4. Is it possible that most investors might regard Stock B as being less risky than Stock A?

   1. If Stock B is more highly correlated with the market than A, then it might have a lower beta than Stock A, and hence be less risky in a portfolio sense.
   2. If Stock B is more highly correlated with the market than A, then it might have the same beta as Stock A, and hence be just as risky in a portfolio sense.
   3. If Stock B is less highly correlated with the market than A, then it might have a lower beta than Stock A, and hence be less risky in a portfolio sense.
   4. If Stock B is less highly correlated with the market than A, then it might have a higher beta than Stock A, and hence be more risky in a portfolio sense.
   5. If Stock B is more highly correlated with the market than A, then it might have a higher beta than Stock A, and hence be less risky in a portfolio sense.

EXPECTED RETURNS

Stocks A and B have the following probability distributions of expected future returns:

1. Calculate the expected rate of return, r_B, for Stock B (r_A = 13.20%.) Do not round intermediate calculations. Round your answer to two decimal places.
   %

2. Calculate the standard deviation of expected returns, σ_A, for Stock A (σ_B = 18.62%.) Do not round intermediate calculations. Round your answer to two decimal places.
   %

3. Now calculate the coefficient of variation for Stock B. Round your answer to two decimal places.

4. Is it possible that most investors might regard Stock B as being less risky than Stock A?

   1. If Stock B is less highly correlated with the market than A, then it might have a higher beta than Stock A, and hence be more risky in a portfolio sense.
   2. If Stock B is more highly correlated with the market than A, then it might have a higher beta than Stock A, and hence be less risky in a portfolio sense.
   3. If Stock B is more highly correlated with the market than A, then it might have a lower beta than Stock A, and hence be less risky in a portfolio sense.
   4. If Stock B is more highly correlated with the market than A, then it might have the same beta as Stock A, and hence be just as risky in a portfolio sense.
   5. If Stock B is less highly correlated with the market than A, then it might have a lower beta than Stock A, and hence be less risky in a portfolio sense.

8.06

EXPECTED RETURNS

Stocks A and B have the following probability distributions of expected future returns:

1. Calculate the expected rate of return, r_B, for Stock B (r_A = 15.10%.) Do not round intermediate calculations. Round your answer to two decimal places.
   %

2. Calculate the standard deviation of expected returns, σ_A, for Stock A (σ_B = 18.51%.) Do not round intermediate calculations. Round your answer to two decimal places.
   %

3. Now calculate the coefficient of variation for Stock B. Round your answer to two decimal places.

4. Is it possible that most investors might regard Stock B as being less risky than Stock A?

   1. If Stock B is more highly correlated with the market than A, then it might have a higher beta than Stock A, and hence be less risky in a portfolio sense.
   2. If Stock B is more highly correlated with the market than A, then it might have a lower beta than Stock A, and hence be less risky in a portfolio sense.
   3. If Stock B is more highly correlated with the market than A, then it might have the same beta as Stock A, and hence be just as risky in a portfolio sense.
   4. If Stock B is less highly correlated with the market than A, then it might have a lower beta than Stock A, and hence be less risky in a portfolio sense.
   5. If Stock B is less highly correlated with the market than A, then it might have a higher beta than Stock A, and hence be more risky in a portfolio sense.

If IBM has the probability distribution shown in the table above, what is IBM’s standard deviation?