Question: Please answer this using formulas. (Not Excel) The average return for the S&P 500 index from 1886 to 2017 was 9.5%, with a standard deviation

Please answer this using formulas. (Not Excel)

The average return for the S&P 500 index from 1886 to 2017 was 9.5%, with a standard deviation of 18%. Based on these numbers, what is you best forecast for the S&P 500 return for 2018? construct a 95% confidence interval for the forecast.

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 Finance Questions!

I appreciate it if someone could help me to answer those questions. Question 1 3 pts Tased on current dividend yields and expected capital gains, the expected rates of return on portfolios A and B...

A household savings-account spreadsheet shows the following entries for the first day of each month in 2019: Required: Use the Excel function XIRR to calculate the dollar-weighted average retum for...

Please tell me which function I should apply to get the answer to the following. The yellow cells are the figures I have to calculate \f3. (6 points) ("Would you have invested?"?) The spreadsheet...

7 Problem 18-1 (Static) 7.69 A household savings-account spreadsheet shows the following entries for the first day of each month in 2019: points Date Account Skipped January 1 $ (148, 000.00)...

please answer 9, 21, 23, 25, 28. show work/explanation please. will upvote! thank you in advance! about the effect of B on portfolio return? 9. What must be the beta of a portfolio with E(rp) = 20%,...

Please Bold the final answer Based on current dividend yields and expected capital gains, the expected rates of return on portfolios A and B are 9.5% and 12.5%, respectively. The beta of A is 0.8,...

please answer b-1. Based on current dividend yields and expected capital gains, the expected rates of return on portfollos A and B are 13.1% and 16.5%, respectively. The beta of A is .8, while that...

please solve 21, 23 showing work/explanation. will upvote, thank you in advance! Part TWO Portfolio Theory In Problems 21-23 below, assume the risk-free rate is 8% and the expected rate of return on...

please i need help in excel by writing the formula to understand thank you e Search AutoSave ODE 8 File Home Insert 8 Draw Nasser_Berk DeMarzo_Harford Problem.11-11.Start Formulas Data Review View...

We examine a generalization of the hierarchical (Bayes) model considered in Example 7.2.16 and Exercise 7.22. Suppose that we observe X1,... , Xn, where Xi|i ~ n (i|2), i = l,...,n, independent, i ~...

In Problem 13.7 on page 531, you used the number of customers to predict the waiting time at a supermarket checkout. Perform a residual analysis for these data (stored in Supermarket). Based on these...

Write notes on TWO of the following: (a) the name clause of the memorandum; (b) the transfer of shares; (c) variation of class rights; (d) promoters. (The Institute of Chartered Secretaries and...

TASK 1: Your manager wants you to brief your Front-of-House (FOH) team at a designated staff briefing: on the principles and benefits of enhanced customer service experiences how to anticipate...

How does the computation of summary statistics (mean, mode, median, max, min, etc.) meet the definition of descriptive analytics?

A sequence check will help us to see if there is a duplicate payment to vendors. Why is that important for the auditor to find?

If sentiment analysis is used on a product advertisement, would you guess the overall sentiment would be positive or negative?