PLEASE ANSWER THIS IN EXCEL ONLY. NO WORD DOC?S. MUST HAVE THE FORMULAS IN THE EXCEL!

11.)

You own a stock portfolio invested 15 percent in Stock Q, 25 percent in Stock R, 40 percent in Stock S, and 20 percent in Stock T. The betas for these four stocks are .85, .91, 1.31, and 1.76, respectively. What is the portfolio beta?

12.)

You own a portfolio equally invested in a risk-free asset and two stocks. If one of the stocks has a beta of 1.42 and the total portfolio is equally as risky as the market, what must the beta be for the other stock in your portfolio?

13.)

A stock has a beta of 1.15, the expected return on the market is 10.9 percent, and the risk-free rate is 4.5 percent. What must the expected return on this stock be?

16.)

Organic Produce Corporation has 6.3 million shares of common stock outstanding, 350,000 shares of 5.8 preferred stock outstanding, and 150,000 of 7.1 percent semiannual bonds outstanding, par value $1,000 each. The common stock currently sells for $74 per share and has a beta of 1.09, the preferred stock currently sells for $107 per share, and the bonds have 20 years to maturity and sell for 109 percent of par. The market risk premium is 6.8 percent, T-bills are yielding 4.3 percent, and the firm?s tax rate is 34 percent. Required: (a) What is the firm's market value capital structure? (Do not round intermediate calculations. (b) If the firm is evaluating a new investment project that has the same risk as the firm?s typical project, what rate should the firm use to discount the project?s cash flows?

PLEASE ANSWER THIS IN EXCEL ONLY. NO WORD DOC'S. MUST HAVE THE FORMULAS IN THE EXCEL! 11.) You own a stock portfolio invested 15 percent in Stock Q, 25 percent in Stock R, 40 percent in Stock S, and 20 percent in Stock T. The betas for these four stocks are .85, .91, 1.31, and 1.76, respectively. What is the portfolio beta? 12.) You own a portfolio equally invested in a risk-free asset and two stocks. If one of the stocks has a beta of 1.42 and the total portfolio is equally as risky as the market, what must the beta be for the other stock in your portfolio? 13.) A stock has a beta of 1.15, the expected return on the market is 10.9 percent, and the risk-free rate is 4.5 percent. What must the expected return on this stock be? 16.) Organic Produce Corporation has 6.3 million shares of common stock outstanding, 350,000 shares of 5.8 preferred stock outstanding, and 150,000 of 7.1 percent semiannual bonds outstanding, par value $1,000 each. The common stock currently sells for $74 per share and has a beta of 1.09, the preferred stock currently sells for $107 per share, and the bonds have 20 years to maturity and sell for 109 percent of par. The market risk premium is 6.8 percent, T-bills are yielding 4.3 percent, and the firm's tax rate is 34 percent. Required: (a) What is the firm's market value capital structure? (Do not round intermediate calculations. (b) If the firm is evaluating a new investment project that has the same risk as the firm's typical project, what rate should the firm use to discount the project's cash flows