Calculated using excel Input DataAlphaBetaResidual Standard DeviationMarket DataExpected ReturnStandard DeviationRequired:VoughtHammerRoxxonInternationalLexCorpIndustriesEnergy1.20%0.60%1.60%2.50%0.8771.0151.631.2521.70%14.80%21.30%25.70%S&P 500Treasury Bills12.00%24.00%3.00%0.00%Note: Use cells A2 to C11 from the given information to complete this question.Using the information in the table above, using the Treynor-Black model, please take all necessary steps to create an optimal riskyportfolio, including discovering initial individual weights and the beta-adjusted active portfolio weight. Then, calculate the riskpremium and variance of the optimal risky portofolio.Active PositionsInitial Position (Not Scaled)Scaled Initial PositionVoughtInternationalHammerRoxxonLexCorpIndustriesEnergy25.48%27.39%35.27%37.85%20.23%21.74%27.99%30.04%

The picture depicts a spreadsheet with an application similar to Microsoft Excel. Financial…

Answered: Input Data Alpha Beta Residual Standard…

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter11: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 11.18E

See similar textbooks

Similar questions

v. 2
What is the standard deviation of asset M?
Question content area top Part 1 (Related to Checkpoint 8.3) (CAPM and expected returns) a. Given the following holding-period returns, LOADING... Month Sugita Corp. Market 1 2.4 % 1.0 % 2 −1.0 2.0 3 0.0 3.0 4 0.0 0.0 5 7.0 7.0 6 7.0 1.0 , compute the average returns and the standard deviations for the Sugita Corporation and for the market. b. If Sugita's beta is 1.84 and the risk-free rate is 6 percent, what would be an expected return for an investor owning Sugita? (Note: Because the preceding returns are based on monthly data, you will need to annualize the returns to make them comparable with the risk-free rate. For simplicity, you can convert from monthly to yearly returns by multiplying the average monthly returns by 12.) c. How does Sugita's historical average return compare with the return you should expect based on the Capital Asset…
To 4-dogot accuracy please compute The standard deviation of IWM return and the standard deviation of EEM return?
Given market data in Table 2 below Table 2: Market Quantity Supplied and Demanded Data for Good X Market Quantity Prices Supplied (P) (Qs) Quantity Demanded (Qd) $18.00 20 100 $20.00 40 80 $22.00 60 60 $24.00 80 40 $26.00 100 20 The inversed function of QS(P) is OP(QS) = 16.000 + 0.100QS OP(QS) = 20.000 + 0.100Q OP(QS) 16.000 + 10.000Q OP(QS) = 20.000 + 10.000Q
calculate the following Sharpe Ratio (SP) Treynor Measure Jensen Measure M2 measure T2 measure Information Ratio (appraisal ratio) Fund Average return Standard Deviation Beta coefficient Unsystematic Risk A 0.240 0.220 0.800 0.017 B 0.200 0.170 0.900 0.450 C 0.290 0.380 1.200 0.074 D 0.260 0.290 1.100 0.026 E 0.180 0.400 0.900 0.121 F 0.320 0.460 1.100 0.153 G 0.250 0.190 0.700 0.120 Market 0.220 0.180 1.000 0.000 Risk free return 0.050 0.000
The following table illustrates the regression results from regressing monthly IBM excess returns on monthly S&P 500 excess returns. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations Intercept Excess Market 0.517 0.268 ANOVA O 0.264 Regression Residual Total O 0.422 0.517 0.268 0.264 0.080 180.000 df 1.000 178.000 179.000 Coefficients 0.001 1.120 SS MS 0.422 0.422 1.153 0.006 1.575 What is the estimated correlation between excess IBM and market returns? F 65.085 Standard Error t Stat P-value 0.006 0.237 0.813 0.139 8.068 0.000 Significance F 0.000
Please do not give image format
To 4-digit accuracy, what is the Mean of IWM return and the Mean of EEM return?
Please do not give solution in image format thanku
Here How has been the value of G6 calculated? explanation please
You are analyzing risk and return and CAPM using the historical data provided below (the same as the downloadable file DataQ16.xlsx ). YYYYMM Return(Stk) Return(Mkt) Return(T-bill) 201601 -4.98% -10.18% 0.05% 201602 -2.07% -2.90% 0.06% 201603 11.63% 8.71% 0.06% 201604 0.32% 1.40% 0.07% 201605 9.39% -1.20% 0.09% 201606 1.62% -0.10% 0.09% 201607 5.91% 5.28% 0.09% 201608 8.20% 4.96% 0.08% 201609 5.55% 1.39% 0.09% 201610 -3.38% -1.56% 0.11% 201611 -5.88% -0.63% 0.11% 201612 -2.07% -3.46% 0.12% 201701 7.75% 6.18% 0.14% 201702 1.27% 1.63% 0.14% 201703 7.63% 1.56% 0.09% 201704 9.25% 2.09% 0.09% 201705 10.20% 4.25% 0.08% 201706 4.33% 0.41% 0.09% 201707 12.25% 6.05% 0.11% 201708 4.98% 2.37% 0.11% 201709 2.19% -1.49% 0.09% 201710 4.05% 2.51% 0.09% 201711 13.78%…

SEE MORE QUESTIONS

Recommended textbooks for you

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS