Please show your calculations, no excel.
Please show your calculations, no excel. 3. Suppose that there tots: 1, 2, 3 and 4....
Please show also the formulas in excel. Calculate also exp return, risk, corr coefficient, optimal weight and weights for portfolio and equity portfolio. Thank you for your time! 1 The fund manager has invested! 0 million euros into a bond portfolio which has expected annual return of 13% and 2 expected risk of 8.5% 3 To reduce his overall risk, porfolio manager decided to invest into equity portfolio 4 with expected annual return of 19% and risk 22%. 5 The...
Round Stic M Part II: Problems (50%). You MUST show me all details of your work. Simply giving me one number is NOT acceptable and receives 0, whether or the number you give is correct. 1. Consider a risky portfolio. The end-of-year cash flow derived from the portfolio will be either $70,000 or $200,000 with equal probabilities of 5. The alterative risk-free investment in T-bills pays 6% per year. (15%) &. If you require a risk premium of 8%, how...
questions are not in excel Use the information below to help answer questions 1-7 • Excel's solver was used to create the Minimum Variance Frontier (MVF) • Portfolios 1-6 are all on the MVF • Portfolios 1-6 were created by weighting Stock W, Stock X, Stock Y, Stock Z • Portfolios 1-5 are corner portfolios •The risk free rate is 4% • All return and risk figures are annualized 16949 9.99 22222 1. Assume a two risk asset portfolio with...
Please show work thank you Suppose that the borrowing rate that your client faces is 10%. Assume that the S&P 500 index has an expected return of 16% and standard deviation of 22%. Also assume that the risk-free rate is re = 3%. Your fund manages a risky portfolio, with the following details: Elrp) = 12%, Op = 18%. What is the largest percentage fee that a client who currently is lending (y< 1) will be willing to pay to...
please provide assistance with the following as well as step by step instruction question 4 your portfolio is invested 30% each in A and C, and 40% in B what us the expected return if the portfolio? Also what is the variance of this portfolio? the standard deviation. pleas give steps and calculation 3. Returns and Variances [LOI] Consider the following information: Rate of Return If Probability of State of State of State Occurs Economy Economy Stock Stock Stock A...
Here are the risk and return estimates for the T-Note (#1) and the S&P 500 (#2) for the coming year: Problem IV (12 points) Here are the risk and return estimates for the T-Note (#1) and the S&P 500 (#2) for the coming year: T-Note (#1) Expected Return E(R) 6%e Std, Deviation 12% Correlation (T-Note, S&P 500) = 0 S&P 500 (#2) 8% 16% 1. What is the expected return and standard deviation of the following portfolios? Portfolio Weight in...
please answer question 4 Examples on Asset Pricing Models 1. You are given the following equilibrium expected returns and risks -07: 12 ke (RA) - 12.296; E(R) -15.556; No. 0. 015 a. What is the equation of the Security Market Line? b. A portfolio, made up of A (above) and another security, has a beta of 1.10 and expected return of 1396Which one would you rather buy - A alone or the portfolio? Why? ES 1.6 I OVAL B A...
PROBLEM i Create a column of monthly returns for your 2 stocks and the following 3 portfolios. Organize your spreadsheet as follows: a. Date VRSN (#1) Portfolio 1 80% in A 20% in B Portfolio 2 50% in A 50% in B Portfolio 3 20% in A 80% in B MNST (#2) S&P 500 X.x X.x Xx Xx Xx b. Calculate the historical average return and standard deviation for your stocks and the portfolios. Recall you are using historical data,...
please answer all them, i have enough questions left! ? question #1 please :) Examples on Asset Pricing Models 25 (2-2)(RA) = 12.2%; EOR 1. You are given the following equilibrium expected returns and risks: 3.7 (RM-Red E(RA) = 12.2%; E(RB) = 15.5%; Ba=0.7; BB = 1.25. ER2=0.08 +0.06 Bi a. What is the equation of the Security Market Line? b. A portfolio, made up of A (above) and another security, has a beta of 1.10 and expected return of...
Please use EXCEL to do it Show your answers along with the formula and steps you used for each question Table 1.en January 1,2019 LIBOR so Im days) Problem 3: On January 1, 2019,a US-based lender wishes to hedge against decrease n future interest rates. The lender proposes to hedge against this risk by entering into an FRA with the notional amount of S10 million Use 30/360 day ceent coav ention ลnd simple interest rate 540% 530% s 20% 510%...