[answered] Managerial Finance 1. You bought a stock one year ago for $

Please show work in excel with correct cell formulas. Thank you

Managerial Finance

 

1. You bought a stock one year ago for $51.53 per share and sold it today for $58.26 per share. It paid a $1.59 per share

 

dividend today.

 

a. What was your realized return?

 

b. How much of the return came from dividend yield and how much came from capital gain?

 

a. What was your realized return?

 

The realized return was %. (Round to two decimal places.) b. How much of the return came from dividend yield and how much came from capital gain?

 

The return that came from dividend yield is

 

The return that came from capital gain is %. (Round to two decimal places.)

 

%. (Round to two decimal places.) 2. You bought a stock one year ago for $50.44 per share and sold it today for $44.04 per share. It paid a $1.01 per share

 

dividend today.

 

a. What was your realized return?

 

b. How much of the return came from dividend yield and how much came from capital gain?

 

a. What was your realized return?

 

The realized return was %. (Round to two decimal places.) b. How much of the return came from dividend yield and how much came from capital gain?

 

The return that came from dividend yield is

 

The return that came from capital gain is %. (Round to two decimal places.)

 

%. (Round to two decimal places.) 3. Consider two local banks. Bank A has 77 loans outstanding, each for $1.0 million, that it expects will be repaid today. Each

 

loan has a 7% probability of default, in which case the bank is not repaid anything. The chance of default is independent

 

across all the loans. Bank B has only one loan of $77 million outstanding, which it also expects will be repaid today. It also

 

has a 7% probability of not being repaid. Which bank faces less risk? Why? 4. Consider the following two, completely separate, economies. The expected return and volatility of all stocks in both

 

economies is the same. In the first economy, all stocks move together ?in good times all prices go up together and in bad

 

times they all fall together. In the second economy, stock returns are independent ?one stock increasing in price has no

 

effect on the prices of other stocks. Assuming you are riskaverse and you could choose one of the two economies in which

 

to invest, which one would you choose? Explain.

 

(Select the best choice below.)

 

A. A riskaverse investor is indifferent in both cases because he or she faces unpredictable risk.

 

B. A riskaverse investor would prefer the economy in which stock returns are independent

 

because by combining the stocks into a portfolio he or she can get a higher expected return

 

than in the economy in which all stocks move together.

 

C. A riskaverse investor would choose the economy in which stock returns are independent

 

because risk can be diversified away in a large portfolio.

 

D. A riskaverse investor would choose the economy in which stocks move together because the

 

uncertainty is much more predictable, and you have to predict only one thing.

 

5. What does the beta of a stock measure?

 

(Select the best choice below.)

 

A. B eta meas ures leverage.

 

B. B eta meas ures the amount of s ys tematic ris k in a s tock.

 

C. B eta meas ures liquidity.

 

D. B eta meas ures interes t rate ris k. 6. Suppose the market risk premium is 6% and the riskfree interest rate is 3%. Using the data in the table, 1, calculate the

 

expected return of investing in a. Starbucks' stock.

 

b. Hershey's stock.

 

c. Autodesk's stock.

 

a. Starbuck's stock.

 

The expected return of Starbucks stock is %. (Round to two decimal places.) b. Hershey's stock.

 

The expected return of Hershey stock is %. (Round to two decimal places.) c. Autodesk's stock.

 

The expected return of Autodesk stock is %. (Round to two decimal places.) 1: Data Table

 

(Click on the icon located on the topright corner of the data table below in order to copy its contents into a spreadsheet.) Starbucks

 

Beta Hershey 0.80 Autodesk

 

1.96 0.33

 

7. You own three stocks: 600 shares of Apple Computer, 10,000 shares of Cisco Systems, and 5,000 shares of ColgatePalmolive. The current share prices and expected returns of Apple, Cisco, and Colgate-Palmolive are, respectively,

 

$415, $22, $98 and 12%, 10%, 8%.

 

a. What are the portfolio weights of the three stocks in your portfolio?

 

b. What is the expected return of your portfolio?

 

c. Suppose the price of Apple stock goes up by $23, Cisco rises by $3, and Colgate-Palmolive falls by $15. What are

 

the new portfolio weights?

 

d. Assuming the stocks expected returns remain the same, what is the expected return of the portfolio at the new

 

prices?

 

a. What are the portfolio weights of the three stocks in your portfolio?

 

The portfolio weight of Apple Computer is %. (Round to two decimal places.) The portfolio weight of Cisco Systems is %. (Round to two decimal places.) The portfolio weight of Colgate-Palmolive

 

b. What is the expected return of your portfolio? %.

 

(Round to two decimal

 

places.) The expected return on the portfolio is

 

c. is %. (Round to two decimal places.) Suppose the price of Apple stock goes up by $23, Cisco rises by $3, and Colgate-Palmolive falls by $15. What are the

 

new portfolio weights?

 

The new portfolio weight of Apple is %. (Round to two decimal places.) The new portfolio weight of Cisco is %. (Round to two decimal places.) The new portfolio weight of Colgate-Palmolive is %. (Round to two decimal places.) d. Assuming the stocks expected returns remain the same, what is the expected return of the portfolio at the new

 

prices?

 

The new expected return is %. (Round to two decimal places.) 1 . Suppose Autodesk stock has a beta of 2.20, whereas Costco stock has a beta of 0.74. If the risk free interest rate is 4.5%

 

and the expected return of the market portfolio is 13.5%, what is the expected return of a portfolio that consists of ?55%

 

Autodesk stock and 45% Costco stock, according to the CAPM? The expected return is

 

9. %. (Round to two decimal places.) Unida Systems has 37 million shares outstanding trading for $11 per share. In addition, Unida has $94 million in

 

outstanding debt. Suppose Unida's equity cost of capital is 14%, its debt cost of capital is 9%, and the corporate tax

 

rate is 30%.

 

a. What is Unida's unlevered cost of capital?

 

b. What is Unida's aftertax debt cost of capital?

 

c. What is Unida's weighted average cost of capital?

 

a. What is Unida's unlevered cost of capital?

 

Unida's unlevered cost of capital is %. (Round to one decimal place.) b. What is Unida's aftertax debt cost of capital?

 

Unida's aftertax debt cost of capital is %. (Round to one decimal place.) c. What is Unida's weighted average cost of capital?

 

Unida's weighted average cost of capital is %. (Round to one decimal place.) 10. You would like to estimate the weighted average cost of capital for a new airline business. Based on its industry asset

 

beta, you have already estimated an unlevered cost of capital for the firm of 10%. However, the new business will be

 

23% debt financed, and you anticipate its debt cost of capital will be 7%. If its corporate tax rate is 33%, what is your

 

estimate of its WACC?

 

The equity cost of capital is

 

The weighted average cost of capital is %. (Round to one decimal place.)

 

%. (Round to one decimal place.) 11. Watch the video called "The Capital Structure Choice: CISCO"2.

 

Which of the following is part of a firm's capital structure?

 

A. Equity B. Preferred Stock C. Debt D. All answers are correct. 2: http://media.pearsoncmg.com/aw/aw_finance_videos/capitalstructure/index.php?video=CapStruct&size=Lg 12. Watch the video called "The Capital Structure Choice: CISCO ".

 

Since debt has a lower cost than equity, the firm can reduce its capital costs by simply replacing equity with debt.

 

A. True B. False

 

---

Solution details:

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.