Don't used hand raiting and don't used Ai solution

John works for a fixed income hedge fund. Your fund invests in $100 million in mortgage-backed-bonds (MBS) with a duration of 10. He finances these bonds with $2 million in investor capital and $98 million of overnight repurchase agreements (required haircut=2%) with an interest rate of 1%. After hours, negative news comes out on the evening news that increases yields on MBS by 25 basis points. Moreover, effective tomorrow, because of this bad news, repurchase agreement lenders will now require a haircut of 3% to lend to you via repurchase agreements with your MBS as collateral. Assuming he receives no interest payments from your MBS, how much cash does he need to not default on today’s repurchase agreement and to keep the position open for one more day tomorrow? Please provide calculations in excel.

220 6-1. (Expected return and risk) Universal Corporation is planning to invest in a secu- LO1 LO2 rity that has several possible rates of return. Given the following probability distribu- tion of returns, what is the expected rate of return on the investment? Also, compute the standard deviations of the returns. What do the resulting numbers represent? PROBABILITY 0.10 0.20 0.30 RETURN -10% 5% 0.40 10% 25% 6-2. (Average expected return and risk) Given the holding-period returns shown here, calculate the average returns and the standard deviations for the Kaifu Corporation Myb and for the market. MONTH 1 2 3 KAIFU CORP. 4% 6% 0% 2% MARKET 2% 3% 1% -1% 6-3. (Expected rate of return and risk) Carter, Inc. is evaluating a security. Calculate the investment's expected return and its standard deviation. PROBABILITY 0.15 RETURN 6% 0.30 9% 0.40 10% 0.15 15% PART 2 The Valuation of Financial Assets 6-4. (Expected rate of return and risk) Summerville, Inc. is considering an investment in one of…

6-14. (Expected return, standard deviation, and capital asset pricing model) The following LO5 are the end-of-month prices for both the Standard & Poor's 500 Index and Nike's common stock. a. Using the data here, calculate the holding-period returns for each of the months. NIKE S&P 500 INDEX 2017 January $52.90 $2,279 February 57.16 2,364 March 55.73 2,363 April 55.41 2,384 May 52.99 2,412 June 59.00 2,423 July 59.05 2,470 August 52.81 2,472 September 51.85 2,519 October 54.99 2,575 November 60.42 2,648 December 62.55 2,674 2018 January 68.22 2,824 b. Calculate the average monthly return and the standard deviation for both the S&P 500 and Nike. 222 PART 2 • The Valuation of Financial Assets c. Develop a graph that shows the relationship between the Nike stock returns and the S&P 500 Index. (Show the Nike returns on the vertical axis and the S&P 500 Index returns on the horizontal axis as done in Figure 6-5.) d. From your graph, describe the nature of the relationship between Nike stock…

required rates of return for the three securities? 6-23. (Portfolio beta and security market line) You own a portfolio consisting of the ☑ stocks below: PERCENTAGE OF STOCK OR SECURITY PORTFOLIO BETA EXPECTED RETURN 1 20% 1.00 12% 2 30% 0.85 8% 3 15% 1.20 12% 25% 0.60 7% 5 10% 1.60 16% The risk-free rate is 3 percent. Also, the expected return on the market portfolio is 11 percent. a. Calculate the expected return of your portfolio. (Hint: The expected return of a portfolio equals the weighted average of the individual stocks' expected returns, where the weights are the percentage invested in each stock.) b. Calculate the portfolio beta. c. Given the foregoing information, plot the security market line on paper. Plot the stocks from your portfolio on your graph. d. From your plot in part (c), which stocks appear to be your winners and which ones appear to be your losers? e. Why should you consider your conclusion in part (d) to be less than certain? 6-24. (Portfolio beta) Assume you…

Wizzy Wigs is an unleveraged firm with $80 million in total assets, 2 million shares outstanding, and $15 million in EBIT. The shares price is $40, tax adjusted cost of debt 4.61%, and corporate tax rate of 21%. What are the returns on equity (ROEs) for the firm if it shifts to a 0.75 debt-to-equity ratio and for an individual with 700 shares who created homemade leverage at the same DE ratio? ◻ firm 25.61%; inv. 24.99% firm 18.24%; inv. 19.46% firm 38.59%; inv. 35.53% firm 23.19%; inv. 22.46% firm 30.07%; inv. 30.19% Please show work on excel spreadsheet

You are running a hot Internet company. Analysts predict that its earnings will grow at 20% per year for the next 9 years. After that, as competition increases, earnings growth is expected to slow to 4% per year and continue at that level forever. Your company has just announced earnings of $4 million. What is the present value of all future earnings if the interest rate is 9%? (Assume all cash flows occur at the end of the year.) The present value of all future earnings is million. (Round to two decimal places.)

3. Losses for an insurance company next year are estimated to be 100 million with standard deviation 250 million. Using lognormal and two-parameter Pareto distributions to obtain the VaR at the 95%, 97.5%, 99% security levels. Comment on your findings.

A company sold 4 million shares in its IPO, at a priceof $18.50 per share. Management negotiated a fee(the underwriting spread) of 7% on this transaction.What was the dollar cost of this fee?